- 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 -
Advanced Level 2$395 -
Advanced$395 -
Fundamentals$375
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 Level 2$395
-
Advanced
-
Advanced$395