Microsoft Excel 2007
Basic
Description
In Excel Basic, the student will discover the basic features and tools necessary to utilize Excel. Students will perform calculations, change a documents appearance, filter and reorder data, combine data from several sources & create charts.
Outline
- Unit 1: Getting started
- Topic A: Spreadsheet terminology
- Topic B: Exploring the Excel window
- Topic C: Getting help
- Topic D: Opening and navigating workbooks
- Topic E: Closing workbooks
- Unit 2: Entering and editing data
- Topic A: Creating workbooks
- Topic B: Entering and editing labels and values
- Topic C: Entering and editing formulas
- Topic D: Saving and updating workbooks
- Unit 3: Modifying a worksheet
- Topic A: Moving and copying data
- Topic B: Moving and copying formulas
- Topic C: Using absolute references
- Topic D: Inserting and deleting ranges
- Unit 4: Using functions
- Topic A: Entering functions
- Topic B: Using AutoSum
- Topic C: Using AVERAGE, MIN, and MAX
- Unit 5: Formatting worksheets
- Topic A: Formatting text
- Topic B: Formatting rows and columns
- Topic C: Number formatting
- Topic D: Using Format Painter and AutoFormat
- Unit 6: Printing
- Topic A: Preparing to print
- Topic B: Page Setup options
- Topic C: Printing worksheets
- Unit 7: Creating charts
- Topic A: Chart basics
- Topic B: Modifying charts
- Topic C: Printing charts
- Unit 8: Web features
- Topic A: Saving workbooks as Web pages
- Topic B: Hyperlinks
- Topic C: Sending workbooks via e-mail
Intermediate
Description
Intermediate Excel exercises include: creation of templates and workbooks, sort and filter data, reuse and share data, use of various functions and auditing features to create advanced formulas and audit worksheets. Students will learn the importance of PivotTable how to best utilize the component, and how to use PivotChart reports and other analytical tools.
Outline
- Unit 1: Working with large worksheets
- Topic A: Viewing options
- Topic B: Hiding, displaying, and outlining data
- Topic C: Printing large worksheets
- Unit 2: Using multiple worksheets and workbooks
- Topic A: Using multiple worksheets
- Topic B: Linking worksheets by using 3-D formulas
- Topic C: Consolidating data
- Topic D: Linking workbooks
- Topic E: Managing workbooks
- Unit 3: Customizing Excel
- Topic A: Using the Options dialog box
- Topic B: Customizing toolbars and menus
- Unit 4: Advanced formatting
- Topic A: Borders and shading
- Topic B: Using special number formats
- Topic C: Working with dates
- Topic C: Working with styles
- Topic E: Other advanced formatting
- Unit 5: List management
- Topic A: Examining lists
- Topic B: Sorting and filtering lists
- Topic C: Advanced filtering
- Unit 6: Advanced charting
- Topic A: Chart formatting options
- Topic B: Using combination charts
- Topic C: Using graphic elements
- Unit 7: Documenting and auditing
- Topic A: Auditing features
- Topic B: Comments and text boxes
- Topic C: Protection
- Topic D: Workgroup collaboration
- Unit 8: Using templates
- Topic A: Built-in templates
- Topic B: Creating and managing templates
Advanced
Description
Advanced Excel exercises include: working with formulas, data tables, list management, PivotTables, PivotCharts, importing and exporting, analytics, macros, webpages, and SharePoint services.
Outline
- Unit 1: Working with advanced formulas
- Topic A: Using names
- Topic B: Using decision-making functions
- Topic C: Creating nested functions
- Topic D: Using financial functions
- Unit 2: Lookups and data tables
- Topic A: Working with lookup functions
- Topic B: Using MATCH and INDEX
- Topic C: Creating data tables
- Unit 3: Advanced list management
- Topic A: Creating subtotals
- Topic B: Validating cell entries
- Topic C: Exploring database functions
- Topic D: Working with data forms
- Unit 4: Working with PivotTables and PivotCharts
- Topic A: Working with PivotTables
- Topic B: Rearranging PivotTables
- Topic C: Formatting PivotTables
- Topic D: Working with PivotCharts
- Unit 5: Exporting and importing
- Topic A: Exporting and importing text files
- Topic B: Exporting and importing XML data
- Topic C: Querying external databases
- Unit 6: Using analytical options
- Topic A: Working with Goal Seek and Solver
- Topic B: Working with the Analysis ToolPak
- Topic C: Working with scenarios
- Topic D: Working with views
- Unit 7: Working with macros
- Topic A: Running and recording a macro
- Topic B: Working with VBA code
- Topic C: Function procedures
- Unit 8: Interactive Web pages
- Topic A: Creating interactive Web spreadsheets
- Topic B: Publishing PivotTables on the Web
- Unit 9: Using SharePoint services
- Topic A: Document Workspaces
