Blog
Library

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

    01:58:00

  • 0 Students Enrolled

Description

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
Number of Lectures: 18 Total Duration: 01:58:00
Reviews

No Review Yet