The Excel Program
- Starting Excel
- The Excel start screen
- The Excel screen
Calling Up Commands
- The ribbon
- The File menu
- Icons
- Context menus and toolbars
- Keys (shortcuts)
- Help
Workbook
- Moving around the worksheet
- Zoom
- Entering data
- Completing an entry
- Cancelling an entry
- Changing an entry
- Creating totals
Saving a Workbook
- The Save As Explorer window
- The Save and Save As commands
- Closing and opening a file
- Creating a new workbook
Ranges
- Selecting a range
- Clipboards
- Copying cells
- Undoing changes
- Cutting cell contents
- Pasting cell contents from a clipboard
- Collecting and pasting
- Drag and drop
- Deleting
Functions
- Structure of functions
- Statistical evaluations
- Using functions
Formatting a Worksheet
- Changing column width
- Changing row height
- Alignment
- Number formatting
- Inserting rows and columns
- Font style
- Centring headings
- Fill colour
- Find and replace
- Freezing columns and rows
First Calculations
- Mathematical operators
- Calculating with constant numbers
- Calculating with variable numbers
- Relative and absolute addressing (references)
- Errors in a worksheet
- Range names
- Window commands
- Calculations with the IF function
- Conditional formatting
Chart
- Creating a new chart
- Contextual tools
- Formatting the chart
- Changing the appearance of the chart
Printing
- Printer setup
- Print preview
- Page setup
- Page break preview
- Headers and footers
- Page Layout view
- Printing
3D Worksheets
- Inserting and deleting worksheets
- Navigating between worksheets
- Copying and moving worksheets
- Copying across multiple worksheets
- Group mode
- 3D ranges
Filling in Data
- Filling in date values
- AutoFill with the mouse
- Flash Fill
Excel as a Database
- Preliminary considerations
- Ranges in a database
- Filters
- Entering criteria
- Sorting
