Working with Multiple Worksheets & Workbooks-Welcome and Critical Information
Welcome to Excel Skills for Business: Intermediate I
Course Goals and Weekly Learning Objectives
Working with Multiple Worksheets & Workbooks-Scenario: Multiple Worksheets and Workbooks
Week 1 Introduction
()
Week 1 Discussion
()
Working with Multiple Worksheets & Workbooks-Practice Videos and Challenges
Read me before you start: Quizzes and Navigation
Download the Week 1 workbooks
Read me before you start: Versions and regions
Practice Video: Multiple Worksheets
()
Practice Video: 3D Formulas
()
Practice Video: Linking Workbooks
()
Practice Video: Consolidating by Position
()
Practice Video: Consolidating by Category (Reference)
()
Week 1 Wrap-Up
()
Week 1: Practice Challenge
Week 1: Advanced Practice Challenge
Working with Multiple Worksheets & Workbooks-Toolbox
Keyboard Shortcuts, Excel Terminology and Ninja Tips
Text and Date Functions-Scenario
Week 2 Introduction
()
Week 2 Discussion
()
Text and Date Functions-Practice Videos and Challenges
Download the Week 2 workbooks
Practice Video: Combining Text (CONCAT, &)
()
Practice Video: Changing Text Case (UPPER, LOWER, PROPER)
()
Practice Video: Extracting Text (LEFT, MID, RIGHT)
()
Practice Video: Finding Text (FIND)
()
Practice Video: Date Calculations (NOW, TODAY, YEARFRAC)
()
Week 2 Wrap-Up
()
Week 2: Practice Challenge
Text and Date Functions-Toolbox
Keyboard Shortcuts, Excel Terminology and Ninja Tips
Named Ranges-Scenario
Week 3 Introduction
()
Week 3 Discussion
()
Named Ranges-Practice Videos and Challenges
Download the Week 3 workbooks
Practice Video: Introducing Named Ranges
()
Practice Video: Creating Named Ranges
()
Practice Video: Managing Named Ranges
()
Practice Video: Named Ranges in Formulas
()
Practice Video: Apply Names
()
Week 3 Wrap-Up
()
Week 3: Practice Challenge
Named Ranges-Toolbox
Keyboard Shortcuts, Terminology and Ninja Tips
Summarising Data-Scenario
Week 4 Introduction
()
Week 4 Discussion
()
Summarising Data-Practice Videos and Challenges
Download the Week 4 workbooks
Practice Video: COUNT functions
()
Practice Video: Counting with Criteria (COUNTIFS)
()
Practice Video: Adding with Criteria (SUMIFS)
()
Practice Video: Sparklines
()
Practice Video: Advanced Charting
()
Practice Video: Trendlines
()
Week 4 Wrap-Up
()
Week 4: Practice Challenge
Summarising Data-Toolbox
Keyboard Shortcuts, Excel Terminology and Ninja Tips
Tables-Scenario
Week 5 Introduction
()
Week 5 Discussion
()
Tables-Practice Videos and Challenges
Download the Week 5 workbooks
Practice Video: Creating and Formatting Tables
()
Practice Video: Working with Tables
()
Practice Video: Sorting and Filtering in Tables
()
Practice Video: Automation with Tables
()
Practice Video: Converting to Range and Subtotaling
()
Week 5 Wrap-Up
()
Week 5: Practice Challenge
Tables-Toolbox
Keyboard Shortcuts, Excel Terminology and Ninja Tips
Pivot Tables, Charts and Slicers-Scenario
Week 6 Introduction
()
Week 6 Discussion
()
Pivot Tables, Charts and Slicers-Practice Videos and Challenges
Download the Week 6 workbooks
Practice Video: Creating and Modifying a Pivot Table
()
Practice Video: Value Field Settings
()
Practice Video: Sorting and Filtering a Pivot Table
()
Practice Video: Reporting Filter Pages
()
Practice Video: Pivoting Charts
()
Practice Video: Pivoting Slicers
()
Week 6 Wrap-Up
()
Week 6: Practice Challenge
Pivot Tables, Charts and Slicers-Toolbox
Keyboard Shortcuts, Excel Terminology and Ninja Tips