Excel Essentials: Levels 1-4
Original price was: $167.00.$97.00Current price is: $97.00.
Master Excel and Word with this bundled training designed for everyday users. Includes 4 levels of Excel plus a complete Word course with 30 short video tutorials, workbook, and guides. All built to save you time and simplify your workflow. View the demo.
Description
Take control of your workday with Excel skills that make a real difference. This full bundle includes all four levels of training – from the basics to advanced tools like PivotTables, dashboards, and macros. Whether you’re new to Excel or ready to tackle more complex tasks, you’ll build skills step by step with clear, practical instruction.
Each course is designed to help you work smarter, not harder. You’ll learn how to manage data, create meaningful reports, and reduce manual work – without jargon or overwhelm. If you want to feel confident in Excel and become the go-to person for solutions, this is the place to start.
Modules Details
Learn valuable skills in each module:
Level 1
Build A Strong Foundation
- 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
Go Beyond the Basics
- Charts & Graphs
- Conditional Formatting
- Custom Autofill Lists
- Formula Auditing
- Insert Function
- Printing
- Text Functions
- Paste Special
- Range Names
- Subtotals
Level 3
Take Control of Complex Data
- 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
Master Advanced Tools
- 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
Preview Each Level With These Samples
Excel Essentials Level 1
Terminology & Navigation
Excel Essentials Level 2
Conditional Formatting
Excel Essentials Level 3
Pivot Tables Introduction
Excel Essentials Level 4
Pivot Table Report Page Filters
