Course curriculum

  • 1

    Welcome

    • Welcome to Innovations in Excel
  • 2

    Work with Basic Formulas

    • Work with basic formulae

    • Work with basic formulae

    • Knowledge Check 1
  • 3

    Work with Basic Functions

    • Work with basic functions

    • Work with basic functions

    • Knowledge Check 2
  • 4

    Understand How Calculations Work

    • Understand how calculations work

    • Understand how calculations work

    • Knowledge Check 3
  • 5

    Different Types of Cut, Copy & Paste

    • Different types of Cut, Copy & Paste

    • Different types of Cut, Copy & Paste

    • Knowledge Check 4
  • 6

    Page Layout

    • Page Layout

    • Page Layout

    • Knowledge Check 5
  • 7

    Formatting

    • Formatting

    • Formatting

    • Knowledge Check 6
  • 8

    Basic Conditional Formatting

    • Basic Conditional Formatting

    • Basic Conditional Formatting

    • Knowledge Check 7
  • 9

    Features for Working with Large Data

    • Features for working with large data

    • Features for working with large data

    • Knowledge Check 8
  • 10

    Present Data as a Chart

    • Present data as a chart

    • Charting

    • Knowledge Check 9
  • 11

    Set Up for Printing

    • Set up for printing

    • Set up for printing

    • Knowledge Check 10
  • 12

    Linking and 3-D Calculation

    • Linking and 3-D Calculation

    • Linking and 3-D Calculation

    • Knowledge Check 11
  • 13

    Using Naming

    • Using Naming

    • Naming

    • Knowledge Check 12
  • 14

    Working with IF, AND & OR Functions

    • Working with IF, AND & OR functions

    • Working with IF, AND & OR functions

    • Knowledge Check 13
  • 15

    Working with Related IF Functions

    • Working with Related IF Functions

    • Working with Related IF Functions

    • Knowledge Check 14
  • 16

    Working with Dates and Times

    • Working with Dates and Times

    • Working with Dates and Times

    • Knowledge Check 15
  • 17

    Create and work with a Basic PivotTable

    • Create and work with a Basic PivotTable

    • Create and work with a Basic PivotTable

    • Knowledge Check 16
  • 18

    Calculate with a PivotTable

    • Calculate with a PivotTable

    • Calculate with a PivotTable

    • Knowledge Check 17
  • 19

    Using the LOOKUP functions

    • Using the LOOKUP functions

    • Using the LOOKUP functions

    • Knowledge Check 18
  • 20

    Left Lookups using INDEX and MATCH

    • Left Lookups using INDEX and MATCH

    • Left Lookups using INDEX and MATCH

    • Knowledge Check 19
  • 21

    What-if Analysis

    • What-if Analysis

    • What-if Analysis

    • Knowledge Check 20
  • 22

    Sparklines and Protection

    • Sparklines and Protection

    • Sparklines and Protection

    • Knowledge Check 21

CPD Certificate of Completion

Upon completion of this eLearning course, you will be awarded a certificate with 10 hours CPD. Please note that if you are a member of Engineers Ireland, this event can be recorded as CPD.  You can record this activity in the My CPD section on your profile.