Using the Ribbon and Quick Access toolbar Excel Views Navigation between sheets and workbooks
Overview
Unlock the full potential of Microsoft Excel with our Excel Fundamentals training course! Designed for beginners and those seeking to enhance their skills, this course covers the essential features and tools of Excel to help you work smarter, not harder.
From mastering formulas and functions to organizing data efficiently, you’ll gain practical knowledge that can be applied to both personal and professional tasks. Whether you’re looking to boost productivity, improve data analysis, or stay competitive in today’s data-driven world, this training equips you with the confidence and expertise to excel—pun intended!
Microsoft Excel training course in Melbourne and across Australia. We can come to you for Face-to-face Excel training or you can join us online for Live online Excel training courses.
Course Materials
Excel Fundamentals Course Outline
604 KB
Excel Fundamentals Exercise Files
131 KB
2 items
Detailed Course Outline
Constructing Spreadsheets Entering numbers, text and dates Keyboard commands Copy and Paste text, values and formulas
Cell addresses and references Constructing Basic Formulas & Functions Formula Bar Copy and Paste data and formulas
Naming & colour-coding worksheets Grouping worksheets Formulas across worksheets and workbooks. Moving and copying worksheets
Formatting Numbers Cell Alignment Borders Fonts and Colours
- Modify colours in charts and visuals
- Adding shapes, text boxes, and images
- Page layout and formatting
- Group interactions among visualisations
- Duplicate a report page
- Show categories with no data
- Summarisation and category options
- Rearrange visualisations
- Visual hierarchies and drill-down
Creating Basic Charts Chart Types Chart Data Format Chart Components
Freeze Panes Page Setup Margins Headers and Footers Sheet printing options Print Area Page Break Preview
Course prerequisites
Some basic PC or Mac keyboard and mouse skills are beneficial but not required for this course.
Inclusions
Instructor - led Training
Menual & Files
Unlimited Free Support
Microsoft Excel Fundamentals
Related Courses
-
Advanced$395 -
Intermediate$375 -
Advanced -
Advanced Level 2$395
Course Details
Duration
1 day
Level
Fundamentals
Private Sessions
Book a private session for 1 to 12 of your employees. Courses can be customised to suit your learning needs.
Public Sessions
Join a public course session conducted LIVE ONLINE via Microsoft Teams.
$375
Detailed Course Outline
Using the Ribbon and Quick Access toolbar Excel Views Navigation between sheets and workbooks
Constructing Spreadsheets Entering numbers, text and dates Keyboard commands Copy and Paste text, values and formulas
Cell addresses and references Constructing Basic Formulas & Functions Formula Bar Copy and Paste data and formulas
Naming & colour-coding worksheets Grouping worksheets Formulas across worksheets and workbooks. Moving and copying worksheets
Formatting Numbers Cell Alignment Borders Fonts and Colours
- Modify colours in charts and visuals
- Adding shapes, text boxes, and images
- Page layout and formatting
- Group interactions among visualisations
- Duplicate a report page
- Show categories with no data
- Summarisation and category options
- Rearrange visualisations
- Visual hierarchies and drill-down
Creating Basic Charts Chart Types Chart Data Format Chart Components
Freeze Panes Page Setup Margins Headers and Footers Sheet printing options Print Area Page Break Preview
Course prerequisites
Some basic PC or Mac keyboard and mouse skills are beneficial but not required for this course.
Inclusions
Instructor - led Training
Menual & Files
Unlimited Free Support
Microsoft Excel Fundamentals
Related Courses
-
Advanced
-
Intermediate$375
-
Advanced$395
-
Advanced Level 2$395