Excel Essentials World Class Video Training Modules

$167.00

Learn Microsoft Excel using short & informative video modules, practice files, & workbooks.

Item added to cart View Cart Checkout
Description

EXCEL ESSENTIALS WORLD CLASS
VIDEO TRAINING

Learn Microsoft Excel skills with our proven program, designed to help busy professionals like YOU. Top Excel trainer Rob Hambleton will guide you through a wide variety of skills in a fun and engaging manner. Rob makes it easy to start using Microsoft Excel today!

Excel Essentials Levels 1-4 includes:

  • 50 video training modules (5-10 minutes each)
  • Practice files
  • Downloadable PDF workbooks
  • Delivered as a zip file

RELATED PRODUCTS

Word Essentials Training Module with Rob Hambleton
Word Essentials World Class Video Training

Excel Essentials Modules

Learn valuable skills in each module:

Level 1 Modules

  • Terminology & Navigation
  • The File Tab
  • The QAT
  • Right Click Formatting
  • Entering & Editing Data
  • Autofill
  • Selecting Multiple Cells
  • Core Keyboard Shortcuts
  • Working with Rows and Columns
  • Working with Worksheets
  • Saving Files
  • Formatting Basics
  • Formula Basics
  • Function Basics
  • Database Basics

Level 2 Modules

  • Charts & Graphs
  • Conditional Formatting
  • Custom Autofill Lists
  • Formula Auditing
  • Insert Function
  • Printing
  • Text Functions
  • Paste Special
  • Range Names
  • Subtotals

Level 3 Modules

  • Options
  • Worksheet Grouping
  • Dates & Times
  • Linking in Excel
  • Linking to PowerPoint/ Word
  • Data Validation
  • Functions – IF and DATES
  • Functions – IF, AND, Nesting
  • Functions – VLOOKUP
  • Protection & Security
  • Pivot Tables – Introduction
  • What If – Scenario Manager
  • What If – Goal Seek
  • Macros — Introduction

Level 4 Modules

  • Pivot Table Basics
  • Pivot Table Layout Options
  • Pivot Table Summary Functions
  • Pivot Table Report/Page Filters
  • Pivot Table Slicers Updating Pivot Table Data
  • Pivot Charts
  • Macro Recording
  • Macro Editing
  • Macro Buttons

Test drive Excel Essentials with these video samples:

Excel Essentials Level 1:
Database Basics

Excel Essentials Level 2:
Insert Functions

Excel Essentials Level 3:
Pivot Table Introduction

Return Policy

Unless otherwise specified, purchases of digital content from the truenorthskills.com Self-Paced Learning page are not returnable after purchase.

If you are having compatibility or quality issues with your content, please contact us for assistance.