Microsoft Excel 2010 Level 4

Further Functions

• INDEX
• MATCH
• SUMIF
• COUNTIF
• Using Date Functions

Importing & Exporting Data

• Importing Data from Text Files
• Exporting Data
• Changing External Data Range
  Properties
• Importing Data from Other Applications
• Removing the Query Definition
• Importing Data from the Web

Using Scenarios & Goal Seek

• Using the Scenario Manager
• Displaying a Scenario
• Creating a Scenario Summary Report
• Using Goal Seek

Solving Problems

• Using Solver
• Restoring the Original Values
• Changing a Constraint
• Creating a Solver Report

Using Data Tables

• Placing Formulas In a Data Table
• Creating One & Two-Way Variable
  Tables

Using Form Controls in a Workbook

• Worksheet Controls - Introduction to
  ActiveX Controls
• Creating a Control Box, Check Box,
  List Box, Options Buttons & Spin Box

Using Templates

• Working with Templates
• Using, Editing, Deleting Templates

Introduction to Macros

• Defining & Running Macros
• Recording a Macro
• Assigning a Shortcut Key
• Adding a Custom Button to the Quick
  Launch Toolbar

Creating and Editing Macro Buttons

• Adding a Macro Button to a Worksheet
• Editing a Macro Button
• Deleting a Macro Button

Appendix A – Using Shared Workbooks

• Post your Spreadsheet online

Appendix B – Excel Preferences and
Options

Appendix C – Hyperlinks and Saving
for the Web

• Access 2010 Foundation
• Project 2010 Level 1

• Finance for Non-Financial Managers
• Presenting with Impact

The next course in this series is:

• Excel Level 5 VBA Programming Introduction

Relevant accreditations include:

• Microsoft^® Certified Application Specialist:
  Using Microsoft^® Office Excel 2010