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 options in the Paste Special Dialog Box
- 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 Logical Functions
- Using the IF function
- Nesting IF functions
Using Financial Functions
- Using the PMT function
- Using the FV 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
|
Working with Lists
- What is a list?
- Sorting a list
- Filtering a list
- Specifying a criteria range in a filter operation
Linking worksheets within a workbook
- Renaming worksheets
- 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
- Opening a new workbook window/Arranging workbook windows
- 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
- Using the Research Feature
- Inserting comments into a worksheet, creating a discussion
|