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
Intermediate I - Week 5-6bFZsbxMEeeBfg6A3Ng9Ng.zip
(136 KB)
C2 W6 Practice Challenge-tNV3iIetEeeH2wpiyfKlxA.xlsx
(96 KB)
C2 W6 Practice Challenge Solution-BTpegYeuEeeH2wpiyfKlxA.xlsx
(134 KB)
C2 W4 Practice Challenge-1iHma4xpEee5BApqFAWhtA.xlsx
(93 KB)
C2 W4 Practice Challenge Solution-5NH4zoxpEeeyYw4zrZ81PA.xlsx
(117 KB)
Intermediate I - Week 4-sS4wELxMEeeQPRI6Xo6b9A.zip
(2.1 MB)
C2 W5 Practice Challenge-whmzhePaEeiaxBKyA9PBAg.xlsx
(80 KB)
C2 W5 Practice Challenge Solution-UuGrF8QjEeeExwq9-tNSbA.xlsx
(129 KB)
Intermediate I - Week 6-L0dArg0wEeiM4QqxMOvfrA.zip
(4.0 MB)
W1_AdvPracticeChallenge-QsR8jRaoEeiV3A7PVRrSig.xlsx
(12 KB)
W1_PracticeChallenge_Bondi-gqss8lmXEei3rhJFDm6TJA.xlsx
(26 KB)
Help Desk April Summary-asfk-IGIEeebfg77QIAAvA.xlsx
(8 KB)
W1_PracticeChallenge_Avalon-v3UBKlmXEei3rhJFDm6TJA.xlsx
(27 KB)
Help Desk May-eS0Lg4GIEee5ARJvajajFg.xlsx
(34 KB)
W1_PracticeChallenge_HeadOffice-dezZCVmXEeiCvwrZ42CKLg.xlsx
(11 KB)
Help Desk June-h3RwxIGIEee5ARJvajajFg.xlsx
(35 KB)
W1_PracticeChallenge_Manly-VNabGBanEeisIgqNB1NuHA.xlsx
(27 KB)
W1_AdvPracticeChallenge_Solution-N0fQDBaoEeiV3A7PVRrSig.xlsx
(17 KB)
W1_PracticeChallenge_Bondi_Soln-r_OVRFmXEei3rhJFDm6TJA.xlsx
(28 KB)
W1_PracticeChallenge_HeadOffice_Soln-h6l3sjsLEemFOA6Hm29iNA.xlsx
(15 KB)
Intermediate I - Week 1-LNO-dbxMEeegtgptwxkqZg.zip
(286 KB)
C2 W3 Practice Challenge-zZFBkePYEeiixgqCUDoEfA.xlsx
(72 KB)
C2 W3 Practice Challenge Solution-jtxX5vzYEeeuoQ4MK7iWlg.xlsx
(76 KB)
Intermediate I - Week 3-kahFebxMEeeBfg6A3Ng9Ng.zip
(156 KB)
C2 W2 Practice Challenge-8nYNXX_0Eeebfg77QIAAvA.xlsx
(88 KB)
C2 W2 Practice Challenge Solution-ERMeb3_1Eeebfg77QIAAvA.xlsx
(92 KB)
Intermediate I - Week 2-Z97yA7xMEeeQPRI6Xo6b9A.zip
(63 KB)
