9.10 Excel Essentials
Learn Microsoft Excel skills with our proven program designed to help busy professionals like YOU- 100% Guaranteed and taught by Rob Hambleton one of the Top Excel Trainers in the Country. Rob makes it Fun to Learn Excel.
Excel Essentials gives you all the practice files you need to start using Microsoft Excel TODAY!
Excel Essentials Levels 1-4 contains:
Since Microsoft Excel is so widely used — many say it’s the most popular piece of software in the world – knowing how to use it correctly is critical. In the business world solid Excel Skills mean higher efficiency, effectiveness, sound decision making and improved job performance.
Microsoft Excel is a huge program and learning it can be daunting. You need an expert with real world experience and a track record of successfully training adults to guild you through the process of becoming a proficient and confident Excel user.
Rob Hambleton, Soul Canyon Training & Development, has assembled a step by step approach to learning Excel that is exciting, engaging and highly motivating. Rob is an award winning trainer who puts on at least 150 live Excel training events each year. Rob has been using spreadsheet softwear and successfully training adults for nearly 30 years – and he’s here to help you learn Excel!
Video training modules – 5-10 minutes each – Workbooks – Practice files
Level 1 Modules:
Introduction – Terminology and Navigation – The File Tab – The QAT – Right Click Formatting – Entering and Editing Data – Autofill – Selecting Multiple Cells – Core Keyboard Shortcuts – Working with Rows and Columns – Working with Worksheets – Saving a File – Formatting Basics – Formula Basics – Function Basics – Database Basics – Next Steps
Level 2 Modules:
Charts & Graphs – Conditional Formatting – Custom Autofill Lists – Formula Auditing – Insert Functions – Printing – Text Functions – Paste Special – Range Names – Subtotals.
Level 3 Modules:
Options – Worksheet Grouping – Date & Times – Linking in Excel – Linking in PowerPoint/Word – Data Validation – Functions – IF and DATES – Functions – IF, AND. Nesting – Functions – VLOOKUP – Protection & Security – Pivot Tables – Introduction – What if – Scenario – What if – Goal Seek
Level 4 Modules:
Pivot Table Basics – Pivot Table Layout Options – Pivot Table Summary Functions – Pivot Table Reports/Page Filters – Pivot Table Slicers – Updating Pivot Table Data – Pivot Charts – Macro Recording – Macro Editing – Macro Buttons
1 Excel Level 1 -- Introduction
FREE PREVIEWExcel Essentials Level I Workbook
FREE PREVIEW2 Excel Level I -- Core Keyboard Shortcuts
FREE PREVIEW3 Excel Level I -- Terminology and Navigation
FREE PREVIEW4 Excel Level I -- The File Tab
FREE PREVIEW5 Excel Level I -- The QAT
FREE PREVIEW6 Excel Level I -- Right Click Formatting
7 Excel Level I -- Entering and Editing Data
8 Excel Level I -- Autofill
9 Excel Level I -- Selecting Multiple Cells
FREE PREVIEW10 Excel Level I -- Working With Columns and Rows
11 Excel Level I -- Working with Worksheets
12 Excel Level I -- Saving a File
13 Excel Level I -- Basic Formatting
FREE PREVIEW14 Excel Level I -- Formula Basics
15 Excel Level I -- Function Basics
16 Excel Level I -- Database Basics
17 Excel Level I -- Next Steps
FREE PREVIEWExcel Level I -- Absolute Referencing
1 Excel Level 2 -- Introduction
FREE PREVIEWExcel Essentials Level 2
2 Excel Level 2 -- Custom Lists
3 Excel Level 2 -- Paste Special
4 Excel Level 2 -- Range Names
5 Excel Level 2 -- Formula Auditing
6 Excel Level 2 -- Functions -- Insert Function
7 Excel Level 2 -- Functions -- Text Functions
8 Excel Level 2 -- Subtotals
9 Excel Level 2 -- Conditional Formatting
10 Excel Level 2 -- Charts and Graphs
11 Excel Level 2 -- Printing
12 Excel Level 2 -- Next Steps
1 Excel Level 3 -- Introduction
FREE PREVIEWExcel Essentials Level 3
2 Excel Level 3 -- Options
3 Excel Level 3 -- Worksheet Grouping
4 Excel Level 3 -- Dates and Times
5 Excel Level 3 -- Linking In Excel
6 Excel Level 3 -- Linking To Powerpoint and Word
7 Excel Level 3 -- Data Validation
8 Excel Level 3 -- IF Function and DATES
9 Excel Level 3 -- IF AND NESTING
10 Excel Level 3 -- Functions VLOOKUP
11 Excel Level 3 -- PROTECTION
12 Excel Level 3 -- Pivot Tables -- Introduction
13 Excel Level 3 -- What if -- Scenarios
14 Excel Level 3 -- What if -- Goal Seek
15 Excel Level 3 -- Macros -- Introduction
16 Excel Level 3 -- Next Steps
2 Excel Level 4 -- Pivot Table Basics
Excel Essentials Level 4 -- Pivot Tables & Macros
3 Excel Level 4 -- Pivot Table Layout Options
4 Excel Level 4 -- Pivot Table Summary Functions
5 Excel Level 4 -- Pivot Table Report Page Filters
7 Excel Level 4 -- Updating Pivot Table Data
8 Excel Level 4 -- Pivot Charts
9 Excel Level 4 -- Recording a Macro
10 Excel Level 4 -- Macro Editing
11 Excel Level 4 -- Creating Macro Buttons
12 Excel Level 4 -- Next Steps
Excel Essentials -- Level UP -- Flash Fill
Excel Level I -- Conditional Formatting for Due Dates and Expiration Dates
Excel Essentials -- Level UP -- Dates Times Timesheets and Macros
Excel Essentials -- Level UP -- Basic Financial Functions
Excel Essentials -- Level UP -- VLOOKUP vs. INDEX and MATCH
Excel Essentials -- Level UP - CLEAN and TRIM Functions