This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Skills for Business Specialization
Excel Skills for Business Essentials 2021-6
excel-essentials - 01 - Week 1 Introduction (2:50)
excel-essentials - 02 - Week 1 Discussion (3:39)
excel-essentials - 03 - Practice Video Taking Charge of Excel (7:07)
excel-essentials - 04 - Practice Video Navigating and Selecting (5:36)
excel-essentials - 05 - Practice Video View Options (5:29)
excel-essentials - 06 - Practice Video Data Entry, Data Types, Editing and Deleting (6:46)
excel-essentials - 07 - Practice Video Fill Handle (5:30)
excel-essentials - 08 - Week 1 Wrap-up (1:41)
excel-essentials - 09 - Copy and Paste (5:01)
excel-essentials - 10 - Templates (2:29)
excel-essentials - 11 - Week 2 Introduction (2:21)
excel-essentials - 12 - Week 2 Discussion (4:39)
excel-essentials - 13 - Practice Video Formulas (3:32)
excel-essentials - 14 - Practice Video Formulas in Context (4:19)
excel-essentials - 15 - Practice Video Functions I SUM and AUTOSUM (4:19)
excel-essentials - 16 - Practice Video Functions II AVERAGE, MIN and MAX (4:21)
excel-essentials - 17 - Discussion Absolute Cell References (4:09)
excel-essentials - 18 - Practice Video Absolute Cell References (3:51)
excel-essentials - 19 - Practice Video Calculations across sheets (4:51)
excel-essentials - 20 - Week 2 Wrap-up (1:30)
excel-essentials - 21 - Excel Options (6:07)
excel-essentials - 22 - Week 3 Introduction (2:42)
excel-essentials - 23 - Week 3 Discussion (3:47)
excel-essentials - 24 - Practice Video Formatting (3:40)
excel-essentials - 25 - Practice Video Borders (3:54)
excel-essentials - 26 - Practice Video Alignment Tools (4:00)
excel-essentials - 27 - Practice Video Format Painter (3:35)
excel-essentials - 28 - Practice Video Number Formats (5:31)
excel-essentials - 29 - Practice Video Styles and Themes (5:05)
excel-essentials - 30 - Week 3 Wrap-up (1:21)
excel-essentials - 31 - Graphics (6:32)
excel-essentials - 32 - Week 4 Introduction (1:51)
excel-essentials - 33 - Week 4 Discussion (3:40)
excel-essentials - 34 - Practice Video Managing Rows and Columns (4:05)
excel-essentials - 35 - Practice Video Find and Replace (3:19)
excel-essentials - 36 - Practice Video Filtering (6:10)
excel-essentials - 37 - Practice Video Sorting (3:43)
excel-essentials - 38 - Practice Video Conditional Formatting (5:46)
excel-essentials - 39 - Week 4 Wrap-up (1:25)
excel-essentials - 40 - Accessibility (5:21)
excel-essentials - 41 - Week 5 Introduction (2:04)
excel-essentials - 42 - Week 5 Discussion (3:18)
excel-essentials - 43 - Practice Video Print Preview (4:16)
excel-essentials - 44 - Practice Video Orientation, Margins and Scale (4:50)
excel-essentials - 45 - Practice Video Page Breaks (5:25)
excel-essentials - 46 - Practice Video Print Titles (4:16)
excel-essentials - 47 - Practice Video Headers and Footers (4:37)
excel-essentials - 48 - Week 5 Wrap-up (1:19)
excel-essentials - 49 - Save Options (5:02)
excel-essentials - 50 - Week 6 Introduction (2:05)
excel-essentials - 51 - Week 6 Discussion (4:58)
excel-essentials - 52 - Practice Video Basic Chart Types Pie, Column and Line Charts (6:13)
excel-essentials - 53 - Practice Video Move and Resize Charts (6:04)
excel-essentials - 54 - Practice Video Change Chart Style & Type (4:32)
excel-essentials - 55 - Practice Video Modify Chart Elements (4:47)
excel-essentials - 56 - Week 6 Wrap-up (1:26)
excel-essentials - 57 - Sharing Charts (4:56)
Excel Skills for Business Intermediate I 2021-6
excel-intermediate-1 - 01 - Week 1 Introduction (2:16)
excel-intermediate-1 - 02 - Week 1 Discussion (4:55)
excel-intermediate-1 - 03 - Practice Video Multiple Worksheets (6:24)
excel-intermediate-1 - 04 - Practice Video 3D Formulas (5:16)
excel-intermediate-1 - 05 - Practice Video Linking Workbooks (6:46)
excel-intermediate-1 - 06 - Practice Video Consolidating by Position (5:58)
excel-intermediate-1 - 07 - Practice Video Consolidating by Category (Reference) (3:58)
excel-intermediate-1 - 08 - Week 1 Wrap-Up (1:27)
excel-intermediate-1 - 09 - Week 2 Introduction (2:07)
excel-intermediate-1 - 10 - Week 2 Discussion (5:44)
excel-intermediate-1 - 11 - Practice Video Combining Text (CONCAT, &) (4:17)
excel-intermediate-1 - 12 - Practice Video Changing Text Case (UPPER, LOWER, PROPER) (4:34)
excel-intermediate-1 - 13 - Practice Video Extracting Text (LEFT, MID, RIGHT) (3:55)
excel-intermediate-1 - 14 - Practice Video Finding Text (FIND) (5:03)
excel-intermediate-1 - 15 - Practice Video Date Calculations (NOW, TODAY, YEARFRAC) (3:52)
excel-intermediate-1 - 16 - Week 2 Wrap-Up (1:21)
excel-intermediate-1 - 17 - Week 3 Introduction (2:04)
excel-intermediate-1 - 18 - Week 3 Discussion (2:57)
excel-intermediate-1 - 19 - Practice Video Introducing Named Ranges (5:17)
excel-intermediate-1 - 20 - Practice Video Creating Named Ranges (5:01)
excel-intermediate-1 - 21 - Practice Video Managing Named Ranges (4:18)
excel-intermediate-1 - 22 - Practice Video Named Ranges in Formulas (5:06)
excel-intermediate-1 - 23 - Practice Video Apply Names (5:17)
excel-intermediate-1 - 24 - Week 3 Wrap-Up (1:16)
excel-intermediate-1 - 25 - Week 4 Introduction (2:01)
excel-intermediate-1 - 26 - Week 4 Discussion (3:56)
excel-intermediate-1 - 27 - Practice Video COUNT functions (4:26)
excel-intermediate-1 - 28 - Practice Video Counting with Criteria (COUNTIFS) (5:10)
excel-intermediate-1 - 29 - Practice Video Adding with Criteria (SUMIFS) (6:04)
excel-intermediate-1 - 30 - Practice Video Sparklines (4:24)
excel-intermediate-1 - 31 - Practice Video Advanced Charting (5:16)
excel-intermediate-1 - 32 - Practice Video Trendlines (4:26)
excel-intermediate-1 - 33 - Week 4 Wrap-Up (1:12)
excel-intermediate-1 - 34 - Week 5 Introduction (2:13)
excel-intermediate-1 - 35 - Week 5 Discussion (4:24)
excel-intermediate-1 - 36 - Practice Video Creating and Formatting Tables (5:06)
excel-intermediate-1 - 37 - Practice Video Working with Tables (5:53)
excel-intermediate-1 - 38 - Practice Video Sorting and Filtering in Tables (6:06)
excel-intermediate-1 - 39 - Practice Video Automation with Tables (5:17)
excel-intermediate-1 - 40 - Practice Video Converting to Range and Subtotaling (5:19)
excel-intermediate-1 - 41 - Week 5 Wrap-Up (1:28)
excel-intermediate-1 - 42 - Week 6 Introduction (2:16)
excel-intermediate-1 - 43 - Week 6 Discussion (2:51)
excel-intermediate-1 - 44 - Practice Video Creating and Modifying a Pivot Table (5:58)
excel-intermediate-1 - 45 - Practice Video Value Field Settings (5:55)
excel-intermediate-1 - 46 - Practice Video Sorting and Filtering a Pivot Table (5:20)
excel-intermediate-1 - 47 - Practice Video Reporting Filter Pages (6:49)
excel-intermediate-1 - 48 - Practice Video Pivoting Charts (5:33)
excel-intermediate-1 - 49 - Practice Video Pivoting Slicers (6:00)
excel-intermediate-1 - 50 - Week 6 Wrap-Up (1:25)
Excel Skills for Business Intermediate II 2021-6
excel-intermediate-2 - 01 - Week 1 Introduction (2:22)
excel-intermediate-2 - 02 - Week 1 Discussion (4:29)
excel-intermediate-2 - 03 - Practice Video Data Validation (6:58)
excel-intermediate-2 - 04 - Practice Video Creating Drop-down Lists (6:29)
excel-intermediate-2 - 05 - Practice Video Using Formulas in Data Validation (7:01)
excel-intermediate-2 - 06 - Practice Video Working with Data Validation (7:38)
excel-intermediate-2 - 07 - Practice Video Advanced Conditional Formatting (5:20)
excel-intermediate-2 - 08 - Week 1 Wrap-Up (2:09)
excel-intermediate-2 - 09 - Week 2 Introduction (2:53)
excel-intermediate-2 - 10 - Week 2 Discussion (4:05)
excel-intermediate-2 - 11 - Practice Video Logical Functions I IF (7:30)
excel-intermediate-2 - 12 - Practice Video Logical Functions II AND, OR (5:41)
excel-intermediate-2 - 13 - Practice Video Combining Logical Functions I IF, AND, OR (5:09)
excel-intermediate-2 - 14 - Practice Video Combining Logical Functions II Nested IFs (5:35)
excel-intermediate-2 - 15 - Practice Video Handling Errors IFERROR, IFNA (6:21)
excel-intermediate-2 - 16 - Week 2 Wrap-Up (1:47)
excel-intermediate-2 - 17 - Week 3 Introduction (2:43)
excel-intermediate-2 - 18 - Week 3 Discussion (4:59)
excel-intermediate-2 - 19 - Practice Video Introduction to Lookups CHOOSE (3:45)
excel-intermediate-2 - 20 - Practice Video Approximate Matches Range VLOOKUP (5:17)
excel-intermediate-2 - 21 - Practice Video Exact Matches Exact Match VLOOKUP (6:40)
excel-intermediate-2 - 22 - Practice Video Finding a Position MATCH (7:28)
excel-intermediate-2 - 23 - Practice Video Dynamic Lookups INDEX, MATCH (7:06)
excel-intermediate-2 - 24 - Week 3 Wrap-Up (1:28)
excel-intermediate-2 - 25 - Week 4 Introduction (2:46)
excel-intermediate-2 - 26 - Week 4 Discussion (3:47)
excel-intermediate-2 - 27 - Practice Video Error Checking (9:20)
excel-intermediate-2 - 28 - Practice Video Formula Calculation Options (6:28)
excel-intermediate-2 - 29 - Practice Video Trace Precedents and Dependents (5:23)
excel-intermediate-2 - 30 - Practice Video Evaluate Formula, Watch Window (8:51)
excel-intermediate-2 - 31 - Practice Video Protecting Workbooks and Worksheets (9:37)
excel-intermediate-2 - 32 - Week 4 Wrap-Up (1:24)
excel-intermediate-2 - 33 - Week 5 Introduction (2:38)
excel-intermediate-2 - 34 - Week 5 Discussion (4:08)
excel-intermediate-2 - 35 - Practice Video Modelling Functions SUMPRODUCT (5:50)
excel-intermediate-2 - 36 - Practice Video Data Tables (7:01)
excel-intermediate-2 - 37 - Practice Video Goal Seek (5:12)
excel-intermediate-2 - 38 - Practice Video Scenario Manager (8:50)
excel-intermediate-2 - 39 - Practice Video Solver (9:48)
excel-intermediate-2 - 40 - Week 5 Wrap-Up (1:30)
excel-intermediate-2 - 41 - Week 6 Introduction (2:09)
excel-intermediate-2 - 42 - Week 6 Discussion (3:39)
excel-intermediate-2 - 43 - Practice Video Record a Macro (7:36)
excel-intermediate-2 - 44 - Practice Video Run a Macro (5:56)
excel-intermediate-2 - 45 - Practice Video Edit a Macro (7:05)
excel-intermediate-2 - 46 - Practice Video Working with Macros (5:46)
excel-intermediate-2 - 47 - Practice Video Relative Reference Macros (8:03)
excel-intermediate-2 - 48 - Week 6 Wrap-Up (1:53)
Excel Skills for Business Advanced 2021-6
excel-advanced - 01 - Week 1 Introduction (2:42)
excel-advanced - 02 - Week 1 Discussion (4:44)
excel-advanced - 03 - Practice Video Spreadsheet Design Principles (12:49)
excel-advanced - 04 - Practice Video Calculations (14:25)
excel-advanced - 05 - Practice Video Formatting (11:52)
excel-advanced - 06 - Practice Video Documentation (10:03)
excel-advanced - 07 - Practice Video Interface and Navigation (12:39)
excel-advanced - 08 - Week 2 Introduction (3:19)
excel-advanced - 09 - Week 2 Discussion (4:26)
excel-advanced - 10 - Practice Video Tables and Structured Referencing (9:43)
excel-advanced - 11 - Practice Video Using Functions to Sort Data (8:30)
excel-advanced - 12 - Practice Video Introduction to Array Formulas (5:26)
excel-advanced - 13 - Practice Video Working with an Array Function (TRANSPOSE) (4:41)
excel-advanced - 14 - Practice Video Solving Problems with Array Formulas (4:37)
excel-advanced - 15 - Week 3 Introduction (2:11)
excel-advanced - 16 - Week 3 Discussion (4:50)
excel-advanced - 17 - Practice Video Replace blanks with repeating values (5:41)
excel-advanced - 18 - Practice Video Fix Dates (DATE, MONTH, YEAR, DAY, TEXT) (6:21)
excel-advanced - 19 - Practice Video Remove Unwanted Spaces (TRIM, CLEAN) (4:42)
excel-advanced - 20 - Practice Video Diagnostic Tools (ISNUMBER, LEN, CODE) (7:21)
excel-advanced - 21 - Practice Video Remove Unwanted Characters (SUBSTITUTE, CHAR, VALUE) (6:12)
excel-advanced - 22 - Week 4 Introduction (2:13)
excel-advanced - 23 - Week 4 Discussion (6:19)
excel-advanced - 24 - Practice Video Working with Dates (EOMONTH, EDATE, WORKDAY.INTL) (5:47)
excel-advanced - 25 - Practice Video Financial Functions (FV, PV, PMT) (8:22)
excel-advanced - 26 - Practice Video Loan Schedule (PMT, EDATE) (10:49)
excel-advanced - 27 - Practice Video Net Present Value and Internal Rate of Return (NPV, IRR) (7:47)
excel-advanced - 28 - Practice Video Depreciation Functions (SLN, SYD, DDB) (6:29)
excel-advanced - 29 - Week 5 Introduction (2:45)
excel-advanced - 30 - Week 5 Discussion (5:40)
excel-advanced - 31 - Practice Video INDIRECT (9:39)
excel-advanced - 32 - Practice Video ADDRESS (6:19)
excel-advanced - 33 - Practice Video Introduction to OFFSET (7:17)
excel-advanced - 34 - Practice Video Solving Problems with OFFSET (12:17)
excel-advanced - 35 - Week 6 Introduction (2:55)
excel-advanced - 36 - Week 6 Discussion (4:04)
excel-advanced - 37 - Practice Video Dashboard Design (9:49)
excel-advanced - 38 - Practice Video Prepare Data (8:42)
excel-advanced - 39 - Practice Video Construct Dashboard (11:05)
excel-advanced - 40 - Practice Video Creative Charting (11:08)
excel-advanced - 41 - Practice Video Interactive Dashboard (9:05)
excel-intermediate-1 - 36 - Practice Video Creating and Formatting Tables
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock