Library

Course: Excel Essentials - Level 3

Excel Essentials - Level 3

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
About this Course

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 you will 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
Curriculum
Number of Lecture: 18
Total Duration: 01:58:00
Excel Essentials Level 3
  • Introduction  
  • Workbook  
  • Excel Essentials Practice File  
  • Advanced Options  
  • Worksheet Grouping  
  • Dates & Times  
  • Linking within Excel  
  • Linking Excel to PowerPoint and Word  
  • Data Validation (Drop Down Lists)  
  • IF Function with Dates  
  • IF Function and Nested Functions  
  • VLOOKUP Function  
  • Protecting Information in Excel  
  • Introduction to Pivot Tables  
  • What If Analysis - Scenario Manager  
  • Goal Seek  
  • Introduction to Macros  
  • Next Steps  
Reviews (0)