Completed
) Introduction
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Basics - Introduction to Excel - Excel's Golden Rule for Formulas, Formula Inputs, & Charts
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Goal of video
- 3 ) Type labels for Net Income Projection Table and Assumption Table
- 4 ) Add Stylistic Formatting
- 5 ) Enter Formula Inputs
- 6 ) Format Cells Dialog Box using Ctrl + 1
- 7 ) Start Revenue Formula (we are not copying this formula anywhere)
- 8 ) Revenue Increase Formula (uses Relative and Absolute Cell References):
- 9 ) Why Percentage Revenue Increase Formula is TRUE
- 10 ) The Beauty of Excel
- 11 ) Expense Formula (uses Relative and Absolute Cell References)
- 12 ) Why Expense Formula is TRUE
- 13 ) Net Income Formula (uses two Relative Cell References)
- 14 ) Insert Chart: Column Chart
- 15 ) Move and Resize Chart
- 16 ) Format Chart with Green Plus
- 17 ) Discuss Chart Junk
- 18 ) Delete Chart Elements
- 19 ) Open Chart Formatting Task Pane with Ctrl + 1
- 20 ) Link Chart Title to Cell
- 21 ) Use Alt Key to Snap Chart to Grid
- 22 ) Excel’s Golden Rule
- 23 ) Use Assumption Table (Formula Input Table) to change Formula inputs and watch everything update
- 24 ) Page Setup
- 25 ) Summary
