Microsoft Excel (Intermediate Level)

Microsoft Excel

Microsoft Excel is a software program included in the Microsoft Office suite. It is used to create spreadsheets, which are documents in which data is laid out in rows and columns — like a big table.

Due to its extreme versatility and power, Excel has become one of the most-used software programs in the business world since its launch in 1985. Indeed, the personal computing renaissance of the 1980s and 1990s was largely driven by the many uses of Excel.

Designed for

  • Open to all.

Training Modules

Module 1:

Functions and Formulas

  • Absolute cell referencing
  • Function Syntax
  • Common statistical functions
  • The COUNTIF function
  • The SUMIF function
  • The IF function

 

Module 2:

Working with the Date and Time

  • Date functions – TODAY and NOW
  • The EDATE function
  • The NETWORKDAYS function
  • Working with time values
  • AutoFill date sequences

 

Module 3:

Conditional Formatting

  • Conditional Formatting from cell value
  • Conditional formatting from a formula
  • Editing Conditional Formatting Rules
  • Adding Sparklines

Module 4:

Advanced Sorting and Filtering

  • Sorting Custom Lists
  • Sorting by Colour
  • Complex Filtering Criteria
  • Searching for Criteria
  • SUBTOTAL Function
  • Subtotalling a List
  • Creating a simple Pivot Table

 

Module 5:

Tables 

  • Creating a Table
  • Adding a Table Formula
  • Adding Records to a Table
  • Adding Totals Row
  • Grouping and Hiding an Outline

 

Module 6:

Advanced Charts

  • Creating a Chart Sheet
  • Switch Columns/Rows
  • Creating a Secondary Axis
  • Changing a Series Chart Type
  • Moving a Chart
  • 3D Charts
  • 3D Chart Rotation