Top

Microsoft Excel - OnlineDownload Course Outline

These are the basic outlines of our Microsoft Excel Online sessions.

Duration: 2 hours for each session

You can get more detail on these courses by viewing or downloading the PDF course outline using the link on the right.

Using the latest online technology, these sessions are brought direct to your PC or laptop in real time where you'll have a live instructor delivering an interactive experience.  All you need is a broadband connection and ideally a headset.  Please note that because you'll be using our "Virtual PC's", you don't need Excel loaded onto your computer or laptop.

These are all individual sessions and you can register for any one or all of them.  If you want to register for more than one session, we recommend that you take them in their numbered order.

To register for a session click here or click on the Online Training Schedule button on the left.

Session 1: Basic Formulas and Functions

    AutoFill
  • Quickly coy the contents of a cell by “dragging down”.
  • Automatically enter sequential dates, days, months.
  • Create your own numeric sequences.
    • Formulas and Functions
  • Accurately enter an Excel formula so you can perform calculations on your data.
  • Accurately enter a basic  Excel function using SUM, MIN, MAX, AVERAGE and COUNTA

Session 2: Data Analysis with Conditional Formatting, Table Styles and SubTotals

  • Using the Excel Table Style
  • Use Table Styles to format large amounts of data for readability.
  • Use Table Styles to analyse data.
    • Conditional Formatting
  • Apply conditional formatting to analyse specific data based on criteria.
  • Use data bars, coloured gradients and icons to find specific data.
    • Creating Subtotals
  • Create subtotals on sorted data.
  • Use an Outline to analyse Subtotals

Session 3: Advanced Formula Workshop

    Absolute References
  • Accurately enter a formula that uses absolute references.
    • Naming Cells and Ranges
  • Correctly create named cells and use names in formulas accurately.
    • The IF Function
  • Construct an IF function correctly to enter data into cells based on the result of a test.

Session 4: IF, VLOOKUP, COUNTIFS, and SUMIFS

    The IF Function
  • Construct an IF function correctly to enter data into cells based on the result of a test.
    • Countifs and Sumifs Functions
  • Correctly construct the Countifs function to count up specific values in a range of values.
  • Correctly construct the SumIfs function to add up up specific values in a range of values.
    VLookup
  • Correctly construct the Vlookup function to find data based on a lookup value.

Session 5: Pivot Tables

    Create a PivotTable Report
  • Construct a Pivot Table
  • Add/Remove Pivot Table Fields
  • Reorganise the PivotTable
  • Hide Rows and Columns
  • Work with multiple Data Areas
    • Format the Report
  • Use Layout Options
  • Sort Items
  • Add/Remove Subtotals
  • Manage Totals
  • Change the Subtotal Function
    • Use Advanced Data Field Options
  • Use different functions in the Data Area
  • Use the “Show Data As” Option
  • Apply numeric formats to the Data Area