|
Excel 3 details
- Topics to be covered
- Reviewing Excel 2 topics
Importing and exporting data
- Using paste special
- Linking and embedding objects
- Importing text files into Excel
- Opening text files using Excel
- Exporting data from Excel to other Office applications
Worksheet auditing
- Tracking changes
- Showing formula precedents and dependants
- Setting up data validation rules
- Displaying invalid data
- Using find and replace
Creating and using lists
- Entering data
- Formatting fields
- Creating a data series
- Sorting and searching data
- Filtering data
- Using a data form
Managing data
- Using Autofilter
- Setting up and using advanced filters
- Removing filters
- Summarising data with outlines and sub-totals
- Removing outlines and sub-totals
|
Pivot tables
- Creating a Pivot table
- Modifying a Pivot table
- Printing Pivot tables
- Creating a Pivot table chart
- Modifying a Pivot table chart
- Printing Pivot table charts
Analysis tools
- Using Goal Seek
- Using Solver
- Creating scenarios
- Using scenario summaries
Macros
- Understanding macros
- Recording basic macros
- Using relative references
- Running a macro
- Assigning keyboard shortcut to a macro
- Creating and modifying a macro toolbar button
Workbook protection
- Preventing opening/modification of workbook
- Protecting individual cells
- Protecting worksheet
- Adding and modifying comments
|
