|
Microsoft® Office Excel® 2010: Level 1
(First Look)
back to top
Course Content
Lesson 1: Creating a Basic Excel Worksheet
Topic 1A:
Identify the Elements of the User Interface
Topic 1B:
Customize the Excel Interface
Topic 1C:
Work with Cells
Topic 1D:
Enter Data in an Excel Workbook
Topic 1E:
Obtain Help in Excel
Lesson 2: Performing Calculations in an Excel Worksheet
Topic 2A:
Create Basic Formulas
Topic 2B:
Calculate the Cell Values by Using Functions
Topic 2C:
Copy Formulas and Functions
Lesson 3: Modifying an Excel Worksheet
Topic 3A:
Manipulate Data
Topic 3B:
Modify the Worksheet Elements
Topic 3C:
Search for Data in a Worksheet
Topic 3D:
Modify Rows and Columns
Lesson 4: Formatting an Excel Worksheet
Topic 4A:
Modify Fonts
Topic 4B:
Check a Worksheet for Spelling Errors
Topic 4C:
Apply Number Formatting
Topic 4D:
Add Borders and Colors to Cells
Topic 4E:
Align the Content in a Cell
Topic 4F:
Apply Cell Styles
Lesson 5: Printing Excel Workbooks
Topic 5A:
Set the Page Layout Options
Topic 5B:
Set Page Breaks
Topic 5C:
Print a Workbook
Lesson 6: Managing an Excel Workbook
Topic 6A:
Format Worksheet Tabs
Topic 6B:
Manage Worksheets
Topic 6C:
View Worksheets and Workbooks
Microsoft® Office Excel® 2010: Level 2
back to top
Course Content
Lesson 1: Calculating Data with Advanced Formulas
Topic 1A:
Apply Cell and Range Names
Topic 1B:
Calculate Data Across Worksheets
Topic 1C:
Use Specialized Functions
Topic 1D:
Analyze Data with Logical and Lookup Functions
Lesson 2: Organizing Worksheet and Table Data
Topic 2A:
Create and Modify Tables
Topic 2B:
Format Tables
Topic 2C:
Sort or Filter Data
Topic 2D:
Use Functions to Calculate Data
Lesson 3: Presenting Data Using Charts
Topic 3A:
Create a Chart
Topic 3B:
Modify Charts
Topic 3C:
Format Charts
Lesson 4: Analyzing Data Using PivotTables, Slicers, and PivotCharts
Topic 4A:
Create a PivotTable Report
Topic 4B:
Filter Data Using Slicers
Topic 4C:
Analyze Data Using PivotCharts
Lesson 5: Inserting Graphic Objects
Topic 5A:
Insert and Modify Pictures and ClipArt
Topic 5B:
Draw and Modify Shapes
Topic 5C:
Illustrate Workflow Using SmartArt Graphics
Topic 5D:
Layer and Group Graphic Objects
Lesson 6: Customizing and Enhancing the Excel Environment
Topic 6A:
Customize the Excel Environment
Topic 6B:
Customize Workbooks
Topic 6C:
Manage Themes
Topic 6D:
Create and Use Templates
Microsoft® Office Excel® 2010: Level 3
back to top
Course Content
Lesson 1: Streamlining Workflow
Topic 1A:
Update Workbook Properties
Topic 1B:
Create a Macro
Topic 1C:
Edit a Macro
Topic 1D:
Apply Conditional Formatting
Topic 1E:
Add Data Validation Criteria
Lesson 2: Collaborating with Other Users
Topic 2A:
Protect Files
Topic 2B:
Share a Workbook
Topic 2C:
Set Revision Tracking
Topic 2D:
Review Tracked Revisions
Topic 2E:
Merge Workbooks
Topic 2F:
Administer Digital Signatures
Topic 2G:
Restrict Document Access
Lesson 3: Auditing Worksheets
Topic 3A:
Trace Cells
Topic 3B:
Troubleshoot Invalid Data and Formula Errors
Topic 3C:
Watch and Evaluate Formulas
Topic 3D:
Create a Data List Outline
Lesson 4: Analyzing Data
Topic 4A:
Create a Trendline
Topic 4B:
Create Sparklines
Topic 4C:
Create Scenarios
Topic 4D:
Perform a What-If Analysis
Topic 4E:
Perform a Statistical Analysis with the Analysis ToolPak
Lesson 5: Working with Multiple Workbooks
Topic 5A:
Create a Workspace
Topic 5B:
Consolidate Data
Topic 5C:
Link Cells in Different Workbooks
Topic 5D:
Edit Links
Lesson 6: Importing and Exporting Data
Topic 6A:
Export Excel Data
Topic 6B:
Import a Delimited Text File
Lesson 7: Integrating Excel Data with the Web
Topic 7A:
Publish a Worksheet to the Web
Topic 7B:
Import Data from the Web
Topic 7C:
Create a Web Query
Lesson 8: Structuring Workbooks with XML
Topic 8A:
Develop XML Maps
Topic 8B:
Import and Export XML Data
Excel
2007
Course Content
Lesson 1:
Creating a Basic Worksheet
Topic 1A: Explore the User Interface and the Ribbon
Topic 1B: Navigate and Select in Excel
Topic 1C: Obtain Help
Topic 1D: Enter Data and Save a Workbook
Topic 1E: Customize the Quick Access Toolbar
Lesson 2: Performing Calculations
Topic 2A: Create Basic Formulas
Topic 2B: Calculate with Functions
Topic 2C: Copy Formulas and Functions
Lesson 3: Modifying a Worksheet
Topic 3A: Manipulate Data
Topic 3B: Insert and Delete Cells, Columns, and Rows
Topic 3C: Search for Data in a Worksheet
Topic 3D: Spell Check a Worksheet
Lesson 4: Formatting a Worksheet
Topic 4A: Modify Fonts
Topic 4B: Add Borders and Color to Cells
Topic 4C: Change Column Width and Row Height
Topic 4D: Apply Number Formats
Topic 4E: Position Cell Contents
Topic 4F: Apply Cell Styles
Lesson 5: Printing Workbook Contents
Topic 5A: Print Workbook Contents Using Default Print Options
Topic 5B: Set Print Options
Topic 5C: Set Page Breaks
Lesson 6: Managing Large Workbooks
Topic 6A: Format Worksheet Tabs
Topic 6B: Manage Worksheets in a Workbook
Topic 6C: Manage the View of Large Worksheets
Excel
2007
Course Content
Lesson 1:
Calculating Data with Advanced Formulas
Topic 1A: Manage Cell and Range Names
Topic 1B: Calculate Data Across Worksheets
Topic 1C: Use Specialized Functions
Topic 1D: Analyze Data with Logical and Lookup Functions
Lesson 2: Organizing Worksheet and Table Data
Topic 2A: Create and Modify Tables
Topic 2B: Format Tables
Topic 2C: Sort or Filter Worksheet or Table Data
Topic 2D: Calculate Data in a Table or Worksheet
Lesson 3: Presenting Data Using Charts
Topic 3A: Create a Chart
Topic 3B: Modify Charts
Topic 3C: Format Charts
Lesson 4: Analyzing Data Using PivotTables and PivotCharts
Topic 4A: Create a PivotTable Report
Topic 4B: Analyze Data Using PivotCharts
Lesson 5: Inserting Graphic Objects
Topic 5A: Insert and Modify Pictures and ClipArt
Topic 5B: Draw and Modify Shapes
Topic 5C: Illustrate Workflow Using SmartArt Graphics
Topic 5D: Layer and Group Graphic Objects
Lesson 6: Customizing and Enhancing Workbooks and the Excel Environment
Topic 6A: Customize the Excel Environment
Topic 6B: Customize Workbooks
Topic 6C: Manage Themes
Topic 6D: Create and Use Templates
Excel 2007
Course Content
Lesson 1:
Streamlining Workflow
Topic 1A: Create a Macro
Topic 1B: Edit a Macro
Topic 1C: Apply Conditional Formatting
Topic 1D: Add Data Validation Criteria
Topic 1E: Update a Workbook's Properties
Topic 1F: Modify Excel's Default Settings
Lesson 2: Collaborating with Others
Topic 2A: Protect Files
Topic 2B: Share a Workbook
Topic 2C: Set Revision Tracking
Topic 2D: Review Tracked Revisions
Topic 2E: Merge Workbooks
Topic 2F: Administer Digital Signatures
Topic 2G: Restrict Document Access
Lesson 3: Auditing Worksheets
Topic 3A: Trace Cells
Topic 3B: Troubleshoot Errors in Formulas
Topic 3C: Troubleshoot Invalid Data and Formulas
Topic 3D: Watch and Evaluate Formulas
Topic 3E: Create a Data List Outline
Lesson 4: Analyzing Data
Topic 4A: Create a Trendline
Topic 4B: Create Scenarios
Topic 4C: Perform What-If Analysis
Topic 4D: Perform Statistical Analysis with the Analysis ToolPak
Lesson 5: Working with Multiple Workbooks
Topic 5A: Create a Workspace
Topic 5B: Consolidate Data
Topic 5C: Link Cells in Different Workbooks
Topic 5D: Edit Links
Lesson 6: Importing and Exporting Data
Topic 6A: Export Excel Data
Topic 6B: Import a Delimited Text File
Lesson 7: Using Excel with the Web
Topic 7A: Publish a Worksheet to the Web
Topic 7B: Import Data from the Web
Topic 7C: Create a Web Query
Lesson 8: Structuring Workbooks with XML
Topic 8A: Develop XML Maps
Topic 8B: Import and Export XML Data
Excel 2003
Course Content
Lesson 1: Getting Started with Excel
Topic 1A: An Overview of Excel
Topic 1B: Navigate in Excel
Topic 1C: Select Data
Topic 1D: Enter Data
Topic 1E: Save a Workbook
Topic 1F: Obtain Help
Lesson 2: Modifying a Worksheet
Topic 2A: Move and Copy Data Between Cells
Topic 2B: Fill Cells with Series of Data
Topic 2C: Edit Cell Data
Topic 2D: Insert and Delete Cells, Columns, and Rows
Topic 2E: Find, Replace, and Go To Cell Data
Topic 2F: Spell Check a Worksheet
Lesson 3: Performing Calculations
Topic 3A: Create Basic Formulas
Topic 3B: Calculate with Functions
Topic 3C: Copy Formulas and Functions
Topic 3D: Create an Absolute Reference
Lesson 4: Formatting a Worksheet
Topic 4A: Change Font Size and Type
Topic 4B: Add Borders and Color to Cells
Topic 4C: Change Column Width and Row Height
Topic 4D: Merge Cells
Topic 4E: Apply Number Formats
Topic 4F: Create a Custom Number Format
Topic 4G: Align Cell Contents
Topic 4H: Find and Replace Formats
Topic 4I: Apply an AutoFormat
Topic 4J: Apply Styles
Lesson 5: Developing a Workbook
Topic 5A: Format Worksheet Tabs
Topic 5B: Reposition Worksheets in a Workbook
Topic 5C: Insert and Delete Worksheets
Topic 5D: Copy and Paste Worksheets
Topic 5E: Copy a Workbook
Lesson 6: Printing Workbook Contents
Topic 6A: Set a Print Title
Topic 6B: Create a Header and a Footer
Topic 6C: Set Page Margins
Topic 6D: Change Page Orientation
Topic 6E: Insert and Remove Page Breaks
Topic 6F: Print a Range
Lesson 7: Customizing Layout
Topic 7A: Split a Worksheet
Topic 7B: Arrange Worksheets
Topic 7C: Freeze and Unfreeze Rows and Columns
Topic 7D: Hide and Unhide Worksheets
Excel 2003
Course Content
Lesson 1:
Creating and Applying Templates
Topic 1A: Create a Workbook from a Template
Topic 1B: Create a Custom Template
Topic 1C: Working with Comments
Topic 1D: Create a Hyperlink
Topic 1E: Use Web-based Research Tools
Lesson 2: Creating and Modifying Charts
Topic 2A: Create a Chart
Topic 2B: Format Chart Items
Topic 2C: Change the Chart Type
Topic 2D: Create a Diagram
Lesson 3: Working with Graphic Objects
Topic 3A: Insert Graphics
Topic 3B: Create AutoShapes
Topic 3C: Format Graphic Objects
Topic 3D: Change the Order of Graphic Objects
Topic 3E: Group Graphic Objects
Topic 3F: Move, Copy, and Resize Graphic Objects
Lesson 4: Calculating with Advanced Formulas
Topic 4A: Create and Apply a Name for a Range of Cells
Topic 4B: Calculate Across Worksheets
Topic 4C: Calculate with Date and Time Functions
Topic 4D: Calculate with Financial Functions
Topic 4E: Calculate with Statistical Functions
Topic 4F: Calculate with Lookup and Reference Functions
Topic 4G: Calculate with Logical Functions
Lesson 5: Sorting and Filtering Data
Topic 5A: Sort Data Lists
Topic 5B: Filter Data Lists
Topic 5C: Create and Apply Advanced Filters
Topic 5D: Calculate with Database Functions
Topic 5E: Add Subtotals to a Worksheet
Lesson 6: Using Excel with the Web
Topic 6A: Export Excel Data
Topic 6B: Publish a Worksheet to the Web
Topic 6C: Import Data from the Web
Topic 6D: Create a Web Query
Excel
2003
Course Content
Lesson 1:
Streamlining Workflow
Topic 1A: Create a Macro
Topic 1B: Edit a Macro
Topic 1C: Customize Access to Excel Commands
Topic 1D: Apply Conditional Formatting
Topic 1E: Add Data Validation Criteria
Topic 1F: Update a Workbook's Properties
Topic 1G: Modify Excel's Default Settings
Lesson 2: Collaborating with Others
Topic 2A: Protect Files
Topic 2B: Share a Workbook
Topic 2C: Set Revision Tracking
Topic 2D: Review Tracked Revisions
Topic 2E: Merge Workbooks
Topic 2F: Adjust Macro Settings
Topic 2G: Administer Digital Signatures
Lesson 3: Auditing Worksheets
Topic 3A: Trace Cell Precedents
Topic 3B: Trace Cell Dependents
Topic 3C: Locate Errors in Formulas
Topic 3D: Locate Invalid Data and Formulas
Topic 3E: Watch and Evaluate Formulas
Topic 3F: Group and Outline Data
Lesson 4: Analyzing Data
Topic 4A: Create a Trendline
Topic 4B: Create Scenarios
Topic 4C: Perform What-If Analysis
Topic 4D: Develop a PivotTable© Report
Topic 4E: Develop a PivotChart© Report
Topic 4F: Perform Statistical Analysis with the Analysis ToolPak
Lesson 5: Working with Multiple Workbooks
Topic 5A: Create a Workspace
Topic 5B: Consolidate Data
Topic 5C: Link Cells in Different Workbooks
Topic 5D: Edit Links
Lesson 6: Importing and Exporting Data
Topic 6A: Export to Microsoft Word
Topic 6B: Import a Word Table
Topic 6C: Import Text Files
Lesson 7: Structuring XML Workbooks
Topic 7A: Develop XML Maps
Topic 7B: Import, Add, and Export XML Data
Topic 7C: Manage XML Workbooks
Topic 7D: Apply XML View Options
|
