Completed
) Introduction
Class Central Classrooms beta
YouTube playlists curated by Class Central.
Classroom Contents
Excel Formulas & Functions, PivotTables, Slicers & Charts
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Calculations in Excel
- 3 ) Worksheet formulas definition and elements
- 4 ) Example of Number Formula
- 5 ) ROUND function
- 6 ) How Number Formatting Interacts with Numbers and Formulas
- 7 ) Example of Text Formula
- 8 ) TEXTBEFORE function
- 9 ) FORMULATEXT function
- 10 ) IFNA function
- 11 ) Show Nothing with a Formula using Zero Length Text String “”
- 12 ) Example of Logical Formula using Comparative Operators
- 13 ) Don’t Get Tricked By Number Formatting
- 14 ) Alt Keyboard Shortcuts
- 15 ) Excel’s Golden Rule = Most Important Formula Tip
- 16 ) Excel Models
- 17 ) Percentage Number Format
- 18 ) Style Formatting
- 19 ) “Old School” Formula that Requires a Relative Cell Reference and a Manual Copy action.
- 20 ) Angry Rabbit Copy Cursor
- 21 ) “New School” Formula that Spills Results
- 22 ) Dynamic Spilled Array Formula
- 23 ) Beauty of Excel. Bricklin and Frankston and VisiCalc.
- 24 ) Summary of Worksheet Formulas and Excel Models
- 25 ) Define Data Analysis
- 26 ) Define Data, Table, Field, Record
- 27 ) Tools for Data Analysis
- 28 ) Data Analysis Goals for Video
- 29 ) Excel Table feature
- 30 ) Define PivotTable
- 31 ) PivotTable feature
- 32 ) Grouping Dates to create Month Report
- 33 ) PivotTable Cache
- 34 ) Change Report Layout, Manually and Default Settings
- 35 ) Calculations in Values Area of PivotTable
- 36 ) Number Formatting for PivotTable
- 37 ) Conditional Formatting in PivotTable
- 38 ) Add New Data to Excel Table and Refresh PivotTable
- 39 ) Default Settings For Expanding Excel Tables
- 40 ) Excel Line Chart to Show Sales Trends from a PivotTable
- 41 ) Formatting Chart
- 42 ) Rules for Visualizing with Charts
- 43 ) Add Slicer To PivotTable and Chart to visualize Sales Rep Sales Trends
- 44 ) Excel Data Analysis Tools Summary
- 45 ) Summary of Video
- 46 ) Closing and Video Links
