1.1 Starting Excel

Microsoft Excel (365): Crash Course

1 Starting Excel

Course Materials
1.1 Starting Excel (1:29)
1.2 Understanding Excel Interface (4:29)
1.3 Getting Familiar with The Excel Workbook and Worksheets (1:33)
1.4 Explaining the Ribbon (5:45)
1.5 Saving an Excel File (2:54)

2 What you can enter

2.1 Combined What you can enter in a cell (7:42)
2.2 Relative and Absolute Cell Referencing (3:12)
2.3 Entering Formula (1:56)
2.4 Order of Operations (2:59)
2.5 Date Serial Numbers (4:24)

3 Sheets, rows and columns

4 Functions, ranges and shortcuts

4.1 Functions (3:49)
4.2 SUM Function (3:23)
4.3 Copy and Drag Formula (4:56)
4.4 More basic functions (2:48)
4.5 Named Ranges (8:42)
4.6 Names Constants and Formula (3:52)
4.7 Shortcuts (3:43)
4.8 More Shortcuts (6:49)

5 Formatting and conditional formatting

Course Materials
5.1 Formatting Font (4:57)
5.2 Formatting Alignment (2:59)
5.3 Formatting Borders (2:42)
5.4 Formatting Numbers (3:17)
5.5 Conditional Formatting PreConfigured (4:45)
5.6 Conditional Formatting with Formula (11:04)
5.7 Conditional Formatting Dialogue Box Formula Trick (3:15)

6 Printing

7 Managing data

7.1 Data Sort (5:55)
7.2 Filtering (5:35)
7.3 Tables (6:43)
7.4 Text to Columns (5:20)
7.5 Flash Fill (2:53)
7.6 Data Validation (5:22)
7.7 Group and Outline (4:05)
7.8 Freeze Panes (1:47)

8 Managing text and working with formulas and functions

8.1 Relative and Absolute Referencing (5:47)
8.2 VLOOKUP (6:51)
8.3 Index Match (6:35)
8.4 IF (2:10)
8.5 Nested If (3:18)
8.6 Countif Countifs (6:56)
8.7 SUMIF SUMIFS (5:25)
8.8 LEN (1:59)
8.9 RIGHT LEFT MID (5:07)
8.11 Common Error Types (2:18)
8.10 SEARCH (1:50)
8.12 IFERROR (3:08)

9 Charts

9.1 Chart Basics (5:09)
9.2 Chart Series and Column Charts (5:27)
9.3 Bar Charts (5:16)
9.4 Pie Charts (4:28)
9.5 Composite Charts (3:17)

10 Pivot tables, Power Query and Dashboards

10.1 Power Query Intro (4:46)
10.2 Power Query Consolidation (2:47)
10.3 Pivot Tables (2:12)
10.4 Setting up a Pivot Table (4:22)
10.5 Pivot Table Field Settings (4:06)
10.6 Pivot Table Calculated Fields (1:55)
10.7 Pivot Table Groupings (2:10)
10.8 Pivot Table Slicers and Timelines (4:52)
10.9.1 Dashboards Part 1 (6:26)
10.9.2 Dashboards Part 2 (7:45)

11 Macros

12 Intro to VBE and VBA

12.1 Introduction to VBE (8:19)
12.2 Object Model (9:11)
12.3 Module Worksheets Classes (7:50)
12.4 Variables and Constants (10:23)
12.5 Vba Formatting (10:38)
12.6a If Statement (7:08)
12.6b Select Case (6:25)
12.7a For Loop (10:13)
12.7b DoWhile DoUntil Loop (2:47)
12.7c ForEach Loop (4:54)
12.8a Errors (6:00)
12.8b Errors (4:24)
12.9 Consolidate (6:33)