Intermediate editing and formatting techniques
- Finding a specific entry in a worksheet
- Finding and replacing a specific entry in a worksheet
- Creating a new style/applying a style
- Using alignment options in the format cells dialog box
Using absolute cell references
- Entering an absolute column and row cell reference into a formula
- Entering an absolute column or row cell reference into a formula
Using Financial Functions
Using logical functions
- Using the IF function
- Nesting IF functions
Using date/time functions
- Using the DATE function
- Using the NOW function
Creating a chart
- What is a chart ?
- Plotting a basic chart
- Modifying and enhancing a basic chart
- Previewing and printing a chart
- Including non-contiguous data ranges in a chart, plotting a pie chart
- Adding new data to an existing chart
|
Working with lists
- What is a list ?
- Filtering a list
- Specifying a criteria range in a filter operation
Linking worksheets within a workbook
- Setting up related worksheets within a workbook
- Moving the cell pointer from one worksheet to another
- Copying data from one worksheet to another, editing the data
- Entering a formula to link related worksheets
- Formatting multiple worksheets in one operation
- Moving and copying worksheets
- Previewing and printing multiple worksheets in one operation
Controlling the worksheet display
- Splitting the workbook window into panes, freezing window panes
- Hiding rows and columns of a worksheet
- Changing the zoom level for a worksheet
Additional intermediate Excel features
- using an Excel template to create a workbook
- Previewing and saving Excel data as a web page
- Inserting a hyperlink into a worksheet
- Inserting comments into a worksheet, creating a discussion
|