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