Excel 2016 Basics Free Course - Learn to Efficiently Use Excel at Work and to Get a Job.
4.0
(3)
24 learners
What you'll learn
This course includes
- 12.3 hours of video
- Certificate of completion
- Access on mobile and TV
Course content
1 modules • 26 lessons • 12.3 hours of video
Excel 2016 Basics Free Course - Learn to Efficiently Use Excel at Work and to Get a Job.
26 lessons
• 12.3 hours
Excel 2016 Basics Free Course - Learn to Efficiently Use Excel at Work and to Get a Job.
26 lessons
• 12.3 hours
- Free Excel Basics Course at YouTube 01:06
- Excel Basics 1: Introduction To Excel 1: Formatting, Formulas, Cell References, Page Setup 01:02:55
- Excel Basics 2: Introduction to Excel 2: Excel's Golden Rule for Formulas, Formula Inputs, & Charts 37:50
- Excel Basics 3: Count & Add with COUNT, COUNTA, SUM, COUNTIFS, SUMIFS Functions (Intro Excel #3) 21:07
- Excel Basics 4: PivotTables & SUMIFS Function to Create Summary Reports (Intro Excel #4) 33:26
- Excel Basics 5: PivotTable Power to Create Reports with Various Calculations & Layouts 20:20
- Excel Basics 6: Customize Quick Access Toolbar (QAT) and Show New Ribbon Tabs 10:18
- Excel Basics 7: Keyboard Shortcuts Are Fast! 08:16
- Excel Basics 8: Default Data Alignment In Excel & How it Can Help 09:25
- Excel Basics 9: Number Formatting as Façade & the ROUND Function 28:50
- Excel Basics 10: Date & Time Number Formatting, Formulas, Functions & Calculations 39:54
- Excel Basics 11: Search for Excel Functions & get help with Function Arguments 17:05
- Excel Basics 12: Complete Formula Lesson of Formula Types & Formula Elements 12 Examples 43:24
- Excel Basics 13: IF Function Made Easy! IS Functions Too! 14 Epic Examples!! 54:08
- Excel Basics 14: Excel VLOOKUP Function Made Easy! 9 Examples to Make Your Job Easier! 40:08
- Excel Basics 15: Excel Table Feature & Dynamic Ranges for VLOOKUP, PivotTables, & more! 36:47
- Excel Basics 16: Mixed Cell References #1 Trick to Creating Formulas Quickly!!! 45:08
- Excel Basics 18: Defined Names in Excel Formulas & Functions & For Jump Go To! 10:45
- Excel Basics 17: Style Formatting: By Hand, Cell, Table & Conditional Formatting 18:03
- Excel Basics 19: SUMIFS, COUNTIFS, AVERAGEIFS, functions calculations w 1 or more Criteria 35:16
- Excel Basics 20: PivotTable Power: 14 Amazing PivotTable Reporting Tricks: Slicers to Show Values As 39:50
- Excel Basics 21: Relationships Rather than VLOOKUP for PivotTable Reports (Excel 2016 Data Model) 21:35
- Excel Basics 22: Set Default PivotTable Layout & Options in Excel 2016 Office 365 or Later 04:26
- Excel Basics 23: Data Analysis Features: Sort, Filter, Flash Fill to Organize & Clean Data 30:08
- Excel Basics 24: Excel Charts & Graphs to Visualize Quantitative Data. No Chart Junk!!! 34:34
- Excel Basics 25: Power Query (Get & Transform) to Clean & Transform Data into Proper Data Set 30:54
Take this course with you
Download the app to continue lessons from your phone anytime.
