Module 1
Creating and saving a workbook
Entering data and working in the formula bar
Saving and closing a workbook
Open and rename an existing workbook
Module 2
Working with functions and formulae
Entering numbers and formulae
Quickly create a series of dates using the Fill Handle
Using Auto Sum to calculate
Using references and functions
Paste function working with statistical functions
Absolute and Relative cell addresses
Module 3
Printing selected parts of a sheet
Printing the whole sheet
Margins and other print options,
Selecting portrait or landscape and fit-to-page
Working with gridlines and print titles
Module 4
Formatting
Changing column width and row height
Using the undo and repeat command
Making non adjacent cell selections
Hide / unhide columns and rows
Format for currency and dates
Format using one of Excels built in templates
Add borders and shading
Module 5
Create charts using the ChartWizard
Modify, add and delete chart data
Change chart types to make sure the chart fits your data
Module 6
Printing tables and forms
Managing workbooks
Copy and move sheets to make workbooks manageable
Document with cell notes and text boxes
Find files quickly by searching for summary information in the properties dialog box
<< Back to Tutoured Courses
