top of page
Excel Half Day Course Outlines
Empty computer room neatly placed for student in a computer lab..jpg

Basic

  • Screen Elements

  • Create

  • Basic Calculations

  • Move & Copy

  • Insert & Delete

  • Column Width & Row Height

  • Basic Formatting

  • Print Preview and Send to Printer

  • AutoFill

​

​

Intermediate

  • Work with Multiple Worksheets

  • Use Absolute Cell References

  • Sort & Filter Data

  • Use Functions

​

​

Advanced

  • Work with Range Name

  • Consolidate Data

  • Outline & Group a Worksheet

  • Use more Functions

Enhancing Worksheets​

  • Format Cells Dialog Box

  • Custom Formatting

  • Format Painter

  • Conditional Formatting

  • Format a Table

  • Cell Styles

​

​

Managing Worksheets

  • Multiple Worksheet

  • Absolute Cell References

  • Range Names

  • Large Worksheets

​

​

List Management

  • Sort & Filter Data

  • Advanced Filter

  • SubTotals

  • Remove Duplicates

  • Import & Export Data

​

​

Basic Functions & PivotTables​

  • Absolute Cell References

  • Range Names

  • Sum, Max, Min, Ave

  • PivotTables

  • Slicers

  • PivotCharts

  • Table

​

​

Large Worksheets & Charts???​

  • Printing Options

  • View Options

  • Hide

  • Charts

  • Sparklines

  • Formatting

  • Format Painter

  • Styles

  • Conditional Formatting

  • Custom Formatting

​

​

PivotTables & Charts

  • PivotTables

  • Slicers

  • PivotChart

  • Tables

  • Analyse

  • Charts

  • Sparklines

​

​

Functions and Auditing Tools

  • Statistical - Max, Min, Average, Count, Large, Small

  • Logical - IF, Nested IF, And, Or

  • Lookup -  Vlookup, Hlookup, Xlookup, Filter

  • Date 

  • Auditing Tools

​

​

Optimising

  • Data Validation

  • Protect

  • Consolidate Data

  • Outline & Group

  • Templates

​

​

Automating & What IF Analysis Tools

  • Record a macro

  • Customise Excel

  • Scenarios

  • Goal Seek​

Excel Basic Half Day Course Outline
Excel Intermediate Half Day Course Outine
Excel Basic Functions and PivotTables Half Day Course Outline
Excel List Management Half Day Course Outline
Excel Large Worksheets and Charts Half Day Course Outline
Excel Advanced Half Day Courses
Excel Data Vaidation and Consolidate Data Half Day Course Outline
Excel More Functions and Auditing Tools Half Day Course Outline

Excel Half Day Courses

Below is a variety of half-day courses for basic to the more advanced users.  We have half-day courses from learning the basics to specific courses tailored to topics. Feel free to mix and match theses courses to make a full-day course.

We also offer a variety to of half day course. - read more

Contact Form
bottom of page