Excel Expert

Duration:30Hour


Description:

Excel Level 1

 

1 - Creating a Basic Worksheet

Explore the User Interface and the Ribbon Navigate and Select in Excel Obtain Help Enter Data and Save a Workbook Customize the Quick Access Toolbar

2 - Performing Calculations

Create Basic Formulas Calculate with Functions Copy Formulas and Functions

3 - Modifying a Worksheet

Manipulate Data Insert and Delete Cells, Columns, and Rows Search for Data in a Worksheet Spell Check a Worksheet

4 - Formatting a Worksheet

Modify Fonts Add Borders and Color to Cells Change Column Width and Row Height Apply Number Formats Position Cell Contents Apply Cell Styles

5 - Printing Workbook Contents

Print Workbook Contents Using Default Print Options Set Print Options Set Page Breaks

6 - Managing Large Workbooks

Format Worksheet Tabs Manage Worksheets in a Workbook Manage the View of Large Worksheets.

 

Excel Level 2

 

1 - Calculating Data with Advanced Formulas

Manage Cell and Range Names Calculate Data Across Worksheets Use Specialized Functions Analyze Data with Logical and Lookup Functions

2 - Organizing Worksheet and Table Data

Create and Modify Tables Format Tables Sort or Filter Worksheet or Table Data Calculate Data in a Table or Worksheet

3 - Presenting Data Using Charts

Create a Chart Modify Charts Format Charts

4 - Analyzing Data Using PivotTables and PivotCharts

Create a PivotTable Report Analyze Data Using PivotCharts

5 - Inserting Graphic Objects

Insert and Modify Pictures and ClipArt Draw and Modify Shapes Illustrate Workflow Using SmartArt Graphics Layer and Group Graphic Objects

6 - Customizing and Enhancing Workbooks and the Excel Environment

Customize the Excel Environment Customize Workbooks Manage Themes Create and Use Templates

 

Excel Level 3

 

1 - Streamlining Workflow

Create a Macro Edit a Macro Apply Conditional Formatting Add Data Validation Criteria Update a Workbook's Properties Modify Excel's Default Settings

2 - Collaborating with Others

Protect Files Share a Workbook Set Revision Tracking Review Tracked Revisions Merge Workbooks Administer Digital Signatures Restrict Document Access

3 - Auditing Worksheets

Trace Cells Troubleshoot Errors in Formulas Troubleshoot Invalid Data and Formulas Watch and Evaluate Formulas Create a Data List Outline

4 - Analyzing Data

Create a Trendline Create Scenarios Perform What-If Analysis Perform Statistical Analysis with the Analysis ToolPak

5 - Working with Multiple Workbooks

Create a Workspace Consolidate Data Link Cells in Different Workbooks Edit Links

6 - Importing and Exporting Data

Export Excel Data Import a Delimited Text File

7 - Using Excel with the Web

Publish a Worksheet to the Web Import Data from the Web Create a Web Query

8 - Structuring XML Workbooks

Develop XML Maps Import and Export XML Data