Completed
Free Excel Basics Course at YouTube
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel 2016 Basics - Learn to Efficiently Use Excel at Work and to Get a Job
Automatically move to the next video in the Classroom when playback concludes
- 1 Free Excel Basics Course at YouTube
- 2 Excel Basics 1: Introduction To Excel 1: Formatting, Formulas, Cell References, Page Setup
- 3 Excel Basics 2: Introduction to Excel 2: Excel's Golden Rule for Formulas, Formula Inputs, & Charts
- 4 Excel Basics 3: Count & Add with COUNT, COUNTA, SUM, COUNTIFS, SUMIFS Functions (Intro Excel #3)
- 5 Excel Basics 4: PivotTables & SUMIFS Function to Create Summary Reports (Intro Excel #4)
- 6 Excel Basics 5: PivotTable Power to Create Reports with Various Calculations & Layouts
- 7 Excel Basics 6: Customize Quick Access Toolbar (QAT) and Show New Ribbon Tabs
- 8 Excel Basics 7: Keyboard Shortcuts Are Fast!
- 9 Excel Basics 8: Default Data Alignment In Excel & How it Can Help
- 10 Excel Basics 9: Number Formatting as Façade & the ROUND Function
- 11 Excel Basics 10: Date & Time Number Formatting, Formulas, Functions & Calculations
- 12 Excel Basics 11: Search for Excel Functions & get help with Function Arguments
- 13 Excel Basics 12: Complete Formula Lesson of Formula Types & Formula Elements 12 Examples
- 14 Excel Basics 13: IF Function Made Easy! IS Functions Too! 14 Epic Examples!!
- 15 Excel Basics 14: Excel VLOOKUP Function Made Easy! 9 Examples to Make Your Job Easier!
- 16 Excel Basics 15: Excel Table Feature & Dynamic Ranges for VLOOKUP, PivotTables, & more!
- 17 Excel Basics 16: Mixed Cell References #1 Trick to Creating Formulas Quickly!!!
- 18 Excel Basics 18: Defined Names in Excel Formulas & Functions & For Jump Go To!
- 19 Excel Basics 17: Style Formatting: By Hand, Cell, Table & Conditional Formatting
- 20 Excel Basics 19: SUMIFS, COUNTIFS, AVERAGEIFS, functions calculations w 1 or more Criteria
- 21 Excel Basics 20: PivotTable Power: 14 Amazing PivotTable Reporting Tricks: Slicers to Show Values As
- 22 Excel Basics 21: Relationships Rather than VLOOKUP for PivotTable Reports (Excel 2016 Data Model)
- 23 Excel Basics 22: Set Default PivotTable Layout & Options in Excel 2016 Office 365 or Later
- 24 Excel Basics 23: Data Analysis Features: Sort, Filter, Flash Fill to Organize & Clean Data
- 25 Excel Basics 24: Excel Charts & Graphs to Visualize Quantitative Data. No Chart Junk!!!
- 26 Excel Basics 25: Power Query (Get & Transform) to Clean & Transform Data into Proper Data Set
