Course Highlights
  • Data analysis techniques using tools and functions such as slicers and pivot tables
  • How to ensure data integrity by applying structured references, creating input sheets and error checking
  • How to present and format your data using spreadsheets, graphs and charts
  • How to navigate and utilise multiple sheets, workbooks and printing options using keyboard shortcuts
  • Create templates, custom lists, macros and basic VBA techniques
Curriculum

10 Topics
Setting the Stage
Blank Canvas
Sheets Tables and Things
Keep Organised
Code of Conduct
Lights Camera Action!
Getting Into Shape
Keep It Clean
Creating Footprints
A Helping Hand

10 Topics
Setting the stage
The blank canvas
Sheets tables and things
Keep organised
The code of conduct
Lights camera action!
Getting into shape
Keep it clean
Creating footprints
A helping hand

8 Topics
More Functions and Formulae
Automating Your Work with Macros
Importing Data
Working with Tables
Creating and Formatting Data
Creating and Formatting Content
Thesaurus and Research
Validating Data

9 Topics
Importing Data into Excel
Advanced Tables
Analysing Data with Automated Tools
Analysing Data with Scenarios
Using Pivot Tables and Pivot Charts
Analysing Data with Functions
Protecting Cells Sheets and Workbooks
Collaborating with Others
Managing Data and Workbooks

  Write a Review

Microsoft Excel Online Training

Go to Paid Course