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
-
Intermediate$375 -
Advanced -
Advanced Level 2$395 -
Advanced$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
-
Intermediate$375
-
Advanced$395
-
Advanced Level 2$395
-
Advanced
I had the pleasure of
…
I had the pleasure of being trained by Anton twice now for work. Always very informative and an enjoyable learning experience. His knowledge and training style definitely works for both individual and group sessions. Highly recommended!
Jerrick M
Anton took our business through
…
Anton took our business through staff training with a lot of back end knowledge, patience and great communication.
We felt well supported and enjoyed our experience with Blank Page. We would highly recommend Anton for further training. Regards MA.
Myotherapy Association Australia
I had the pleasure of
…
I had the pleasure of being trained by Anton twice now for work. Always very informative and an enjoyable learning experience. His knowledge and training style definitely works for both individual and group sessions. Highly recommended!
Jerrick M
Anton is absolutely delightful; a
…
Anton is absolutely delightful; a great teacher and a wonderful tutor. I am a professional educator with well over 30 years experience and I can unconditionally recommend Anton and Blank Page in terms of professional instruction based on an in-depth understanding of the subject matter and great sensitivity to learner needs; personal engagement and great ability in teaching this ‘old dog’ plenty of new tricks! And I consider myself to be tech-challenged and yet I came away with confidence and as importantly competence I did not think I’d attain! Two thumbs up and Thank You Blank Page and Anton.
Helen Bear
Anton took our business through
…
Anton took our business through staff training with a lot of back end knowledge, patience and great communication.
We felt well supported and enjoyed our experience with Blank Page. We would highly recommend Anton for further training. Regards MA.
Myotherapy Association Australia
Reviews
There are no reviews yet.