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)
L61 Import Text File
Download
Tab Delimited.txt
Download
M08 External Data Demonstrations.xlsx
Download
Access Database.accdb
Complete and Continue
Lesson Content Locked
Your session expired. Please sign in again to continue.
Login