Microsoft Office Excel – Step 1
Getting Started with Excel
An overview of Excel, Navigate in Excel, Select Data, Enter Data, Save a Workbook, Obtain Help
Modifying a Worksheet
Move and Copy Data Between Cells, Fill Cells with Series of Data, Edit Cell Data, Insert and Delete Cells, Columns, and Rows, Find, Replace and Go To Cell Data, Spell Check a Worksheet
Performing Calculations
Create Basic Formulas, Calculate with Functions, Copy Formulas and Functions, Create an Absolute Reference
Formatting a Worksheet
Change Font Size and Type, Add Borders and Color to Cells, Change Column Width and Row Height, Merge Cells, Apply Number Formats, Create a Custom Number Format, Align Cell Contents, Find and Replace Formats, Apply an AutoFormat, Apply Styles
Developing a Workbook
Format Worksheet Tabs, Reposition Worksheets in a Workbook, Insert and Delete Worksheets, Copy and Paste Worksheets, Copy a workbook
Printing Workbook Contents
Set a Print Title, Create a Header and a Footer, Set Page Margins, Change Page Orientation, Insert and Remove Page Breaks, Print a Range
Customizing Layout
Split a Worksheet, Arrange Worksheets, Freeze and Unfreeze Rows and Columns, Hide and Unhide Worksheets
Microsoft Office Excel – Step 2
Creating and Applying Templates
Create a workbook from a template, Create a custom Template, Working with Comments, Create a Hyperlink, Use Web-based Research Tools
Creating and Modifying Charts
Create a Chart, Format Chart Items, Change the Chart Type, Create a Diagram
Working with Graphic Objects
Insert Graphics, Create AutoShapes, Format Graphic Objects, Change the order of Graphic Objects, Group Graphic Objects, Move, Copy, and Resize Graphic Objects
Calculating with Advanced Formulas
Create and Apply a Name for a Range of Cells, Calculate Across Worksheets, Calculate with Date and Time Functions, Calculate with Financial Functions, Calculate with Lookup and Reference Functions, Calculate with Logical Functions
Sorting and Filtering Data
Sort Data lists, Filter Data Lists, Create and Apply Advanced Filters, Calculate with Database Functions
Using Excel with the Web
Export Excel Data, Publish a Worksheet to the Web, Import Data from the Web, Create a Web Query
Microsoft Office Excel – Step 3
Streamlining Workflow
Create a Macro, Edit a Macro, Customize Access to Excel Commands, Apply Conditional Formatting, Add Data Validation Criteria, Update a Workbook’s Properties, Modify Excel’s Default Settings
Collaborating with Others
Protect Files, Share a Workbook, Set Revision Tracking, Review Tracked Revisions, Merge Workbooks, Adjust Macro Settings, Administer Digital Signatures
Auditing Worksheets
Trace Cell Precedents, Trace Cell Dependents, Locate Errors in Formulas, Locate Invalid Data Formulas, Watch and Evaluate Formulas, Group and Outline Data
Analyzing Data
Create a Trendline, Create Scenarios, Perform What-If Analysis, Develop a PivotTable Report, Develop a PivotChart Report, Perform Statistical Analysis with the Analysis ToolPak
Working With Multiple Workbooks
Create a Workspace, Consolidate Data, Link Cells in Different Workbooks, Edit Links
Importing and Exporting Data
Export to Microsoft Word, Import a Word Table, Import Text files
Structuring XML Workbooks
Develop XML Maps, Import, Add, and Export XML Data, Manage XML Workbooks, Apply XML View Options
