- Fill Handle
- Filling values, text and dates
- Custom Fill Lists
Overview
Dive deeper into the inner workings of Microsoft Excel with our Intermediate Excel course! This training is designed to help you understand Excel’s thought process when handling numbers, text, formulas, and functions.
You’ll uncover the logic behind how Excel interprets data and performs calculations, enabling you to harness its power with greater precision.
From mastering advanced formulas to effectively managing text and numerical data, this course equips you with the skills to think like Excel does. Perfect for professionals and enthusiasts alike, you’ll gain insights to streamline workflows, boost efficiency, and unlock Excel’s full potential in your projects and tasks.
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 Intermediate Course Outline
541 KB
Excel Intermediate Exercise Files
270 KB
2 items
Detailed Course Outline
- Selecting cells
- Insert Cells, Columns and Rows
- Insert Dates
- Adding Data
- Formula structure
- Formula Calculation order
- Absolute and Relative cell references
- Formula Auditing
- Trace formula Dependence and Precedence.
- Find and correct Formula Errors
- Watch and Evaluate formulas
- Function Structure
- Using Formula Bar and Paste Function features
- Introduction into various function types:
- Math & Trig functions
- Date functions
- Text functions
- Using AutoCalculate
- Creating Custom Number formats
- Conditional Formatting
- Grouping Rows and Columns
- Modify Groups
- Show / hide Outlines
- Clearing Outlines
- Creating charts
- Formatting chart components
- Creating and applying user-defined charts
- Combining chart types and adding a secondary axis
- Adding Trendlines and Error Bars
- Set Validation criteria
- Specify a data Input Message
- Customise Error Messages
Course prerequisites
You need to be familiar with the basics of Excel.
Inclusions
Instructor - led Training
Menual & Files
Unlimited Free Support
Microsoft Excel Intermediate
Related Courses
-
Advanced$395 -
Advanced Level 2$395 -
Fundamentals$375 -
Advanced
Course Details
Duration
1 day
Level
Intermediate
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
- Fill Handle
- Filling values, text and dates
- Custom Fill Lists
- Selecting cells
- Insert Cells, Columns and Rows
- Insert Dates
- Adding Data
- Formula structure
- Formula Calculation order
- Absolute and Relative cell references
- Formula Auditing
- Trace formula Dependence and Precedence.
- Find and correct Formula Errors
- Watch and Evaluate formulas
- Function Structure
- Using Formula Bar and Paste Function features
- Introduction into various function types:
- Math & Trig functions
- Date functions
- Text functions
- Using AutoCalculate
- Creating Custom Number formats
- Conditional Formatting
- Grouping Rows and Columns
- Modify Groups
- Show / hide Outlines
- Clearing Outlines
- Creating charts
- Formatting chart components
- Creating and applying user-defined charts
- Combining chart types and adding a secondary axis
- Adding Trendlines and Error Bars
- Set Validation criteria
- Specify a data Input Message
- Customise Error Messages
Course prerequisites
You need to be familiar with the basics of Excel.
Inclusions
Instructor - led Training
Menual & Files
Unlimited Free Support
Microsoft Excel Intermediate
Related Courses
-
Fundamentals$375
-
Advanced
-
Advanced$395
-
Advanced Level 2$395
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.