Further Details
Formulae Basics
Basic calculations
SUM, MIN, MAX, AVERAGE,COUNT, COUNTA
Copying formulae
Absolute referencing
Mixed referencing
Naming cells and ranges
Introduction to IF statements
Performing calculations with dates and times
Charting
The chart wizard
Formatting chart elements
Changing the source data
Creating a secondary axis
Saving a custom chart
Setting a default chart
Formatting
Changing column widths and row heights
Formatting cells for different data types
Using autoformat for tables
Format painter
Styles
Condtional formatting based on cell values
Printing
Setting a print area
Getting data to fit the page
Headers and footers
Printing rows and/or column headers on every page
Printing gridlines
Basic List Management
Sorting on multiple columns
Hiding columns
Changing column order
Freezing rows and columns
Introduction to filters
Guide price
£450 per group of 8 delegates |
