Discover better ways to analyze data and find solutions with MS Excel. Excel offers enhanced charting and rich analysis tools for creating spreadsheets and sharing information. Course features range from basic moving around the worksheet and entering and formatting data to creating complex formulae and working with pivot table analysis and charts.



Sample Course Outline - This can be customised to suit you!

Basics
Moving Around A Worksheet
Entering A Series
AutoComplete
Editing Data
To clear a range of cells
Copying with Drag and Drop
Exercise Selecting
Mouse Pointer Shapes

Formatting
Toolbar
Painter
Printing
Preview

Headers & Footers
Page View
Column and row Headings
Repeating rows on printed copy

Creating Worksheets
Inserting and deleting sheets

Formulae
Operator Symbols
Relative formulas – Auto-fill
Formula Error messages
Summing data
Absolute References
Sorting Information
AutoFilter

Graphs and charts
Using the wizard, Changing
Adding labels and data
Pie charts and column graphs

Using more complex Functions
The SUM Function
Using Paste Function
Using the Formula Palette
Averaging Data
Countif function, SUMIF Function, If Statements
Conditional Formulae
Creating Named Ranges
Freeze panes and split window

Data Handling
Sorts
Subtotals
Filters
Custom Autofilters
Creating 3D SUMS
Linking Spreadsheets
Grouping worksheets
Graphs and charts
Using the wizard
Pivot tables