Microsoft Excel Beginners Course 303 – Formulas, Functions and Formatting
$69.00 $29.00 inc GST
- Formulas: Entering formulas using keyboard, arrow keys and mouse
- Understand relative cells references, common formula errors, using multiplication, division and combine two formulas
- AutoCalculate: Create additions and basic functions quickly
- Functions: Intro to functions & function syntax, Autosum, Autosum multiple ranges, intro to basic functions (Maximum, Minimum, Average)
- Functions in more detail: Sum, formula bar, editing functions, F2 key, Autofill to quickly copy functions
- Formatting: How your spreadsheets look, lines, colours, shading, text and number size, font, colour
- Currency formatting, date & text formatting
- Merging cells, centring, alignment formatting fill colour, font colour and borders
Advanced formatting, Autoformats, repeat regular actions quickly, format painter.
