Microsoft Excel Introduction
Instructor-Led Beginner Excel Courses
Learn the basics with with our one-day Excel course.
New to Excel and not sure how to use features such as entering data, sorting and filtering, create a simple calculation, or how to print a worksheet?
Our one-day beginner Excel courses are specifically designed to get you using Excel with confidence.
Explore the important tools for use in Excel.
Gain practical skills from our experienced trainers with plenty of real-world examples. Experience one on one training or have colleagues join you in a private training session.
Beginner Excel Course
Who is this course for?
This beginner Excel course is suited to those who have little to no experience in using Microsoft Excel but want to learn how to navigate and use Excel with confidence.
Course Description
Our beginner Excel course is part of a 3-level study program. This course aims to give participants a thorough understanding of the basics of creating and working with spreadsheets using Microsoft Excel. It covers creating a new workbook, adding data, editing data, working with formulas, printing and charting.
Learning Outcomes
At the completion of Microsoft Excel Introduction you should be able to:
- navigate your way around Microsoft Excel
- open and navigate within workbooks and worksheets
- understand and work with ranges in a worksheet
- use the fill operations available to fill a data series
- understand, create and work with formulas and functions
- understand and use formula cell referencing
- understand and use the number formatting features in Excel
- sort data in a list in a worksheet
- filter data in a table
- print your workbook data
- create effective charts in Microsoft Excel
Prerequisites
Our beginner Excel course assumes little or no knowledge of the software. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system.
Course Duration
The Microsoft Excel Introduction course is run over one-day but can be customised to suit your needs.
Course Overview
Getting to know Excel
- The Excel Workbook Screen
- Using the Ribbon
- Access Backstage View
- Use Shortcut Menus
- Use the Quick Access Toolbar
Create a new workbook
- Entering Text, Numbers and Dates
- Saving a New Workbook
- Check Spelling
Work with workbooks
- Open an existing workbook
- Navigate a workbook
- Navigate using the keyboard
- Using Go To
- View Recent Files and Folders
Edit a workbook
- Overwrite Cell Contents
- Edit Longer Cells
- Edit Formulas
- Clear cell contents
- Delete Data
- Use Undo and Redo
Select ranges
- Select Adjacent Ranges
- Select Non-Adjacent Ranges
- Select Larger Ranges
- Select Rows
- Select Columns
Copy Data
- Use AutoFill for Quick Copying
- Copy from One Cell to Another
- Copy from One Cell to a Range
- Copy from One Range to Another
Fill Data
- Fill a Data Series
- Filling a Growth Series
- Extract data using Flash Fill
Formula and Functions
- Create Basic Arithmetic Formulas
- Use the SUM Function
- Sum Non-Adjacent Ranges
- Calculate an Average
- Find a Maximum & Minimum Value
- Create More Complex Formulas
Cell Referencing
- Use Relative cell refences in formulas
- Identify issues with Relative formulas
- Create Absolute cell references
Font Formatting
- Apply fonts and font size
- Use various formatting techniques
- Customise colours
- Use Format Painter
Number Formatting
- Apply General Number Formats
- Format Currency and Percentages
- Format Dates
- Increase and decrease decimal places
Sort Data
- Perform alphabetical data sorts
- Perform number based data sorts
- Sort by more than one column
Filter Data
- Apply and use a filter
- Clear a filter
- Apply filters on multiple values
- Filter by colour
- Create custom filters
Printing
- Use Print Preview
- Print a specific range of data
- Print an entire worksheet
- Use Print Options
Create Charts
- Create a new chart
- Edit chart elements
- Customise chart options
Course Inclusions
Skills Analysis
Take advantage of our free online skills analysis prior to your training to ensure have are undertaking the correct course.
Certificate
After completing the course you’ll receive a certificate to show off your new-found knowledge and skills.
We come to you
To save your business time, money and unnecessary travel, we come to you, delivering our training at your premises.
Hands-on training
We’re big believers in hands-on learning so you’ll be on a computer and building your skills in real-time.
Email Support
Access unlimited support following your training course to build on your learning and ask any burning questions.
Real-world examples
You'll work through real-world examples to reinforce learning and increase your confidence.
In-Person Course Pricing
Our courses provide the flexibility to pick and choose the content you want to focus on and therefore customise the course content. Our courses are tailored for group training and provide a cost-effective way of training small teams.
Pricing as of 1st October 2021. All prices are exempt of GST.
| Number of participants | Cost |
|---|---|
| 1 participant | $550.00 |
| 2 participants | $670.00 |
| 3 participants | $790.00 |
| 4 participants | $910.00 |
| 5 participants | $1,030.00 |
| 6 participants | $1,150.00 |
Contact us for pricing with 6+ participants.
Costs include travel by our trainer to your premises within the Greater Sydney region. Pricing will be confirmed at the time of your booking enquiry.
Customer Testimonials
“Discussing the learning material, providing examples and then being able to personally put this into practice was beneficial to my learning experience.”
“Very informative, learnt a great number of time saving techniques.”
“Amazed at how many tips and tricks I was not aware of in Excel. Explained and demonstrated in an easy way for all attendees to understand.”
“The training was easy to follow and understand the reason why you would need and use certain functions within Excel. There were so many more uses for Excel than I ever would have realized.”
“Belinda was fantastic, explained everything in terms we can understand.”
“Belinda was great, the course content & her instructions were easy to follow & a bubbly personality keeping everyone engaged.”
“Course was informative and being able to perform the activities in real-time assisted with my ability to retain the information as we were working through.”
“Great! So easy to digest. Found a lot of extra features I could be using & shortcuts.”
“I was a bit worried at first. It was very easy to listen and learn from Belinda. I was ok after the first 5 minutes.”
“Gave organised steps & reasons for them. Practical examples of where and why we use certain functions.”
“The trainer was extremely knowledgeable and taught the course content in language that was easy to understand.”
“Trainer had great enthusiasm and knowledge about Excel and how to use it.”
“Great – will save an hour a week through efficiency improvements.”
“Belinda was very knowledgable of the subject and was good at tailoring the training to suit the way we use the software.”
“Very informative. Learnt a lot of new things and shortcuts.”
“It was great to expand on previous knowledge and pick up a wide variety of new skills.”
“Belinda was great. Everything was covered in detail and explained so we could understand.”
“Professional, thorough, easy to understand. Very well presented.”
“Very helpful and explanatory. Belinda is very thorough and patient.”
“Belinda breaks everything down so it’s easy to understand.”
“Really enjoyed it. Explained so much that will help me in my job.”
“Absolutely amazing, Belinda explains everything & if you don’t understand, she will go back through it.”
“Clear info, wonderful to have everything explained so well. Belinda took her time and was patient when we needed things explained again.”
“Belinda was very clear in her presentation. The pace of the training was helpful.”
“Today has been a wonderful day learning more in a fun, interactive & personal way. Thank you so much.”
“Extremely well communicated. Clear and concise instructions.”
“Brilliantly simplified and explained information with a very practical focus.”
“Belinda was great! The pace was just right for me. I have learnt so much. Belinda is very organised, which improves the learning experience.”