Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel Complete Training
Module 01: Introduction to Excel
DL01 Sample File Download HERE
L01 Excel Interface (7:54)
L02 Quick Access and File Menu (9:02)
L03 Navigate and Select (6:41)
L04 Enter and Edit Data (6:30)
L05 Delete Replace Cancel (5:33)
L06 Keyboard Shortcuts (12:02)
B01 Customize the Ribbon (8:26)
Module 02: Calculating Values
DL02 Sample File Download HERE
L07 Simple References (3:35)
L08 Formulas (8:17)
L09 Functions (11:56)
L10 AutoFill Functions (5:07)
L11 Absolute and Relative References (7:55)
L12 Mixed References (6:52)
L13 Named Ranges (5:02)
B02 Managing Named Ranges (5:28)
Module 03: Managing Your Workbook
DL03 Sample File Download HERE
L14 Saving (9:41)
L15 File Compatibility (6:15)
L16 Move and Copy Calculations (3:56)
L17 AutoFill (15:37)
L18 Insert Rows and Columns (5:00)
L19 Insert Sheets (5:30)
L20 Freeze and Split (6:20)
L21 Hide Columns (2:37)
L22 Find and Replace (8:37)
L23 Printing (9:17)
L24 Formatting (8:46)
L25 Styles and Themes (9:40)
L26 Number Formatting (11:21)
B03 Custom Themes (10:17)
Module 04: Working with Lists and Tables
L27 List Design (7:18)
L28 Insert Table (13:17)
L29 Sorting (8:18)
L30 Custom Sorting (11:18)
L31 Remove Duplicates (5:01)
L32 AutoFilter (11:05)
L33 Advanced Filter (10:47)
L34 Subtotals (9:29)
L35 Quick Analysis (5:04)
L36 Flash Fill (6:30)
B04 Text to Columns (11:24)
Module 05: Charting
DL05 Sample File Download HERE
L37 Creating Charts (11:29)
L38 New Chart Types (8:09)
L39 Chart Formatting (15:12)
L40 Adding Chart Data (9:06)
L41 Chart Templates (2:27)
L42 Printing Charts (9:05)
L43 Themes (6:52)
L44 Chart Best Practices (14:48)
L45 Sparklines (4:35)
Module 06: Pivot Tables and Pivot Charts
DL06 Sample File Download HERE
L46 Understanding Pivot Tables (3:29)
L47 Creating Pivot Tables (7:38)
L48 Formatting Pivot Tables (12:37)
L49 Drilling into Data (5:37)
L50 Filtering Pivot Tables (10:12)
L51 Pivot Charts (11:03)
L52 Pivot Table Connections (10:37)
L53 Creating Dashboards (15:55)
Module 07: Pre-Setting Your Spreadsheet
DL07 Sample File Download HERE
L54 Data Validation with Ranges (6:20)
L55 Data Validation Lists (7:31)
L56 Native Condl Formatting (5:23)
L57 Custom Conditional Formatting (8:42)
L58 Password Protection (3:32)
L59 Range Protection (7:35)
L60 Adding Comments (2:52)
Module 08: Working with External Data
DL08 Sample File Download HERE
L61 Import Text File (4:48)
L62 Database Query (3:59)
L63 Web Query (4:02)
L64 Pivot Table from External Data (5:23)
L65 Export Options (2:48)
Module 09: Using Powerful Functions
DL09 Sample File Download HERE
L66 Named Ranges (10:12)
L67 Date Functions (8:57)
L68 Left Right Mid (8:47)
L69 FIND and LEN (9:04)
L70 CONCATENATE (6:17)
L71 VLOOKUP (10:51)
L72 INDEX and MATCH (10:22)
L73 IF (5:34)
L74 AND and OR (10:59)
L75 SUMIFS (17:49)
Module 10: Nesting Functions
DL10 Sample File Download HERE
L76 ROUND (7:08)
L77 Nesting IF and AND (6:34)
L78 IFERROR (6:40)
L79 IF and OR (8:40)
L80 LEFT and FIND (7:12)
L81 MID FIND and LEN (8:31)
Module 11: What if Analysis
DL11 Sample File Download HERE
L82 Goal Seek (5:14)
L83 Data Consolidation (5:21)
L84 3D References (5:03)
L85 Scenario Manager (6:45)
L86 Solver (9:16)
Module 12: Recording Macros
DL12 Sample File Download HERE
L88 Recording Macros (11:22)
L89 Absolute References (4:58)
L90 Relative References (4:36)
L91 Combined References (7:52)
L92 Editing Macros (3:50)
L93 Assigning Shortcuts (1:55)
L94 Quick Access Toolbar (2:08)
L95 Ribbon (2:54)
L96 Button (6:41)
L46 Understanding Pivot Tables
Download
M06 Pivot Table Demonstrations.xlsx
Complete and Continue