Excel Essentials - Level 3

Features Includes:
  • Self-paced with Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App

Course Preview Video

  • Categories

    Productive Expertise & Efficiency

  • Duration


  • 14 Students Enrolled


Continue expanding your Excel skills with more advanced settings and skills in this high powered class.

Modules include: Advanced Options and Techniques, Worksheet Grouping, Dates & Times, Linking within Excel, Linking to PowerPoint and Word, Data Validation (Drop Down Lists), IF Function with Dates, IF Function with Nested Functions, VLOOKUP Function, Protection in Excel, Pivot Tables Introduction, What If Modelling -- Scenarios and Goal Seek, Macros Introduction.

This class is packed with skills and techniques that will massively expand your capabilities with the program.

Basic knowledge
  • Students are only required to have a basic understanding of how rows and columns are referenced in Excel

What will you learn
  • Advanced Options and Techniques
  • Worksheet Grouping
  • Dates & Times
  • Linking within Excel
  • Linking to PowerPoint and Word
  • Data Validation (Drop Down Lists)
  • IF Function with Dates
  • IF Function with Nested Functions
  • VLOOKUP Function
  • Protection in Excel
  • Pivot Tables Introduction
  • What If Modelling - Scenarios and Goal Seek
  • Macros Introduction
Course Curriculum
No of Lectures: 18 Total Duration: 01:58:00
Cristie McCarroll – December 29, 2021