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 PLUS naming cells and cell ranges
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 Filter and Advanced filter
Working with a filtered data
Creating and running subtotals automatically
Using the Format as Table feature to automatically display filters and totals
Charts
Creating charts based on a data table
Gaining access to more chart options
Formatting the chart layout (ie. labels, plot area, axis, etc.)
Formatting and Display Techniques
Understanding Levels of Formatting
Applying cell styles on-the-fly
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
