Excel Essentials - Level 3

Course

Online

£ 10 + VAT

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

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.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

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

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Emagister S.L. (data controller) will process your data to carry out promotional activities (via email and/or phone), publish reviews, or manage incidents. You can learn about your rights and manage your preferences in the privacy policy.

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 6 years

Subjects

  • Ms Word
  • Ms PowerPoint
  • MS Excel
  • Options
  • Powerpoint
  • Word
  • Excel

Course programme

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

Additional information

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

Excel Essentials - Level 3

£ 10 + VAT