Excel Basics - Introduction to Excel - Excel's Golden Rule for Formulas, Formula Inputs, & Charts

This beginner course teaches how to build a net income projection in Excel using formula inputs, relative and absolute cell references, and a linked column chart. It also covers formatting, page setup, and updating projections by changing assumptions.

Syllabus

) Introduction.
) Goal of video.
) Type labels for Net Income Projection Table and Assumption Table.
) Add Stylistic Formatting.
) Enter Formula Inputs.
) Format Cells Dialog Box using Ctrl + 1.
) Start Revenue Formula (we are not copying this formula anywhere).
) Revenue Increase Formula (uses Relative and Absolute Cell References):.
) Why Percentage Revenue Increase Formula is TRUE.
) The Beauty of Excel.
) Expense Formula (uses Relative and Absolute Cell References).
) Why Expense Formula is TRUE.
) Net Income Formula (uses two Relative Cell References).
) Insert Chart: Column Chart.
) Move and Resize Chart.
) Format Chart with Green Plus.
) Discuss Chart Junk.
) Delete Chart Elements.
) Open Chart Formatting Task Pane with Ctrl + 1.
) Link Chart Title to Cell.
) Use Alt Key to Snap Chart to Grid.
) Excel’s Golden Rule.
) Use Assumption Table (Formula Input Table) to change Formula inputs and watch everything update.
) Page Setup.
) Summary.