Duration: 1/2 day (9am - 12nn)
Cost: $99.00 + GST
Schedule: Please phone (09) 630.1220 for Auckland or (07) 857.0770 for Hamilton to request for a schedule
Course Outline
Formulas and Functions
Revisiting the mathematical principles PLUS naming cells and cell ranges
Reinforcing understanding of Relative, Absolute, and Mixed References
Accessing the Insert Function wizard
Getting more familiar with the IF function and its use
Making sense with VLOOKUP and HLOOKUP functions
Database and List Management
Understanding basic database terminology
Sorting a database
Deciding between AutoFilter and Advanced filter
Working with a filtered data
Creating and running subtotals automatically
Charts
Creating charts using the Chart Wizard
Accessing more chart options in the Chart toolbar
Formatting the chart layout (ie. labels, plot area, axis, etc.)
Formatting an Display Techniques
Understanding Levels of Formatting
Copy existing formats using the Format Painter
Creating formatting consistency with Styles
Using Conditional Formatting
The Extras
Embedding and linking objects (e.g. Word)
Placing a chart into Word or PowerPoint presentation
Creating navigation options using Hyperlinks
