Microsoft Excel 2007 Training Materials
Intermediate Level Course Teaching Materials
MANIPULATING DATA, & NAMED RANGES
- Paste Special
- Transposing data
- Importing text and delimiting by space, comma or tab
- What does naming a cell range mean?
- Rules for naming cells and ranges
- Naming cell range(s) in a worksheet
- Named ranges within formulas
- Navigating through workbooks using named ranges
- Creating named ranges automatically based on cell values
- Deleting named cells/ranges
- Creating subtotals
- Removing subtotals
TEMPLATES
- Using templates
- Creating templates
- Opening and editing templates
FORMATTING & DISPLAY TECHNIQUES
- Formatting tables
- Formatting tables using table styles
- Formatting cell ranges using conditional formatting
- Creating custom number formats
- Freezing the top row
- Freezing the first column
- Freezing the top row and the first column at the same time
- Hiding and un-hiding rows
- Hiding and un-hiding columns
- Hiding and un-hiding worksheets
SORTING AND QUERYING DATA
- Sorting internal Excel databases
- Custom sort options
- Using AutoFilter to query data
- Multiple queries
- Removing filters
- Top 10 AutoFilter
- Filtering unique records
- Advanced Filter
LINKING & CONSOLIDATING DATA
- Linking individual cells within a worksheet
- Linking charts to data within a worksheet
- Linking a cell range on one worksheet to another worksheet (within the same workbook)
- Linking data on one worksheet to a chart in another worksheet (within the same workbook)
- Linking data from one workbook to another
- Linking a chart from one workbook to another
- Copying data from Excel into a Word document
- Linking data from Excel into a Word document
- Copying a chart from Excel into a Word document
- Linking a chart from Excel into a Word document
- Consolidating data over several worksheets or worksheet pages
CHARTS FORMATTING TECHNIQUES
- Changing the angle of pie chart slices
- Formatting the chart axis fonts
- Formatting the chart axis scales
- Formatting the chart axis text orientation
- Creating and positioning a chart title
- Re-positioning a chart legend
- Re-positioning chart data labels
- Exploding the segments within a pie chart
- Deleting a data series within a chart
- Adding a data series to a chart
- Modifying the chart type for a defined data series
- Widening the gap between columns / bars within a 2-D chart
- Inserting an image into a 2D chart (as a background)
- Inserting an image into a 2D chart (to format a column or bar of data)
PROTECTION AND SECURITY
- Specifying a password for opening a workbook
- Using the “read-only recommended” option
- Removing a password from an Excel workbook
- Protecting a worksheet or worksheet elements
- Removing workbook protection
- Allowing selective editing of a protected worksheet