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
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.