|
|
 |
|
 |
|
Microsoft Excel > Introduction
Lesson 1 – Getting Started
Starting a new workbook
Entering data and working in the formula bar
Saving and naming
Entering values and formulae
Create a series of dates using the fill handle
Use auto sum to calculate
Lesson 2 – Creating formulas
Use cell references and functions
Absolute and relative cell addresses
Use function wizard to work with statistical data
Formatting a sheet, change column width and row height
Hide and unhide columns and rows
Best cell selection techniques
Lesson 3 – Learning to format with style
Format cells
Use borders, colour and shading
Using conditional formatting
Format a workbook using one of excels built in templates
Lesson 4 – Best printing practices
Printing multiple pages
Printing a selection
Setting up margins and other print options
Scaling and fit-to-page options
Working with commands and dialogue boxes
Lesson 5 – Working with Excels functions
A detailed view of the fill range option
Creating your own custom lists
Working with Date arithmetic
Working with Volatile dates
Lesson 6 – Charting your work
Charting your data
Create charts using the chart wizard
Modify, add and delete chart data
Quick ways to update your charts
Lesson 7 – More advanced chart techniques
Change chart types to make sure that the chart fits your data
Use automatic formatting to skip repetitive formatting steps
Creating comparison graphs
Format and edit chart types
Lesson 8 – Managing your workbooks
Insert new sheets into your workbook
Name your individual sheets
Copy and move sheets to make your workbook more manageable
Document your work with cell notes, text boxes, and summary information
Create a formula to link sheet together
Lesson 9 – Working in Group Mode
Enter data to several sheets at once
using Group mode
Format a group of worksheets at the same time
Consolidate data from different worksheets
Create linking formal that update automatically
Lesson 10 – Sorting Data
Sort your data on multiple levels
Create automatic subtotals
Collapse and expand to show
summary data only
Understanding how Excel selects cell references to use in formulas
Lesson 11 – Group and Outline
Create an outline on a worksheet
Expand and collapse an outline
Create quick summary reports
Creating an advanced outline
Lesson 12 – Range Names
Creating range names
Modifying range names
Using range names in formula
Navigating using range names
|
|
|
