Learn essential Excel 2016 skills through this comprehensive 12-hour free course designed to build proficiency for workplace success and career advancement. Master fundamental Excel operations including formula creation for business calculations, advanced functions like VLOOKUP and IF statements, and professional formatting techniques for reports and dashboards. Develop expertise in number formatting, PivotTables for data analysis and reporting, and essential data management tools including Sort, Filter, and Flash Fill. Explore advanced features such as Power Query for data import and cleaning, Power Pivot relationships for multi-table reporting, and chart creation for effective data visualization. Practice keyboard shortcuts, customize the Quick Access Toolbar, understand Excel's default data alignment principles, and work with date and time calculations. Gain proficiency in mixed cell references, defined names, conditional formatting, and advanced PivotTable techniques including slicers and various calculation options. Complete hands-on business tasks that integrate multiple Excel features, preparing you to efficiently handle real-world workplace scenarios and demonstrate the Excel competency required for career opportunities.

Syllabus

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