Workbook Management
- Multiple worksheets
- Adding / deleting / moving / copying worksheets
- Renaming and using sheet tab colours
- Arranging 2 or more worksheets/ workbooks together on the screen
Worksheet Navigation
- Freeze Panes
- Split Screen
- Go to commands
- Find and replace
- Naming cells and ranges
Expanding your Calculations
- Using named cells in calculations
- 3D calculations
- Introducing the Excel functions
- Statistical functions
- Today and Now functions
View Excel Fundamentals - Level 1
Back to Excel information page |
Linking Worksheets
- Using Paste Special and the mouse
Working with Large Worksheets
Excel's Database Features
- Creating a list
- AutoFilter
- Data Form
- Sorting
- Sub Totals
Charts and Graphs
- The Chart Wizard
- Creating a quick chart
- Changing the chart type
- Data points and Data Series
- Moving a chart
- Adding/removing data
- Formatting the chart
- Changing the chart options
|