Module 1
Managing workbooks
Copy and move sheets making workbooks more manageable
Enter data to several sheets at once using Group Mode
Format a group of worksheets at the same time
Consolidate data from different worksheets
Module 2
Creating reports
Use Group and Outline
Expand and collapse an Outline
Create quick summary reports
Use automatic subtotal
Module 3
Sorting and managing lists, working with database features
Filter to find records that meet your criteria
Analyse data using database functions
Sort data by specific criteria
Use a data form to enter data
Module 4
Worksheet functions
Creating and using Range Names
Using Conditional Logic =IF function
Working with Lookup Tables =Vlookup and =Hlookup
Module 5
Charting your data
Creating standard charts
Creating custom charts
Updating charts with new or additional data
Bar, Column and Pie charts
Classic Combination charts
Plotting data using secondary axis
Custom Scatter graphs
Line and column combination graphs
Module 6
Printing tables and forms
Customising your workspace
Display and customise toolbars
Split worksheets to see more than one section of data at a time
Arrange sheets within windows to see more than one sheet at a time
<< Back to Tutoured Courses
