0845 450 6120

Excel 2007 - Specialist

This course is aimed at people who want expand their knowledge into the more specialised analytical functionality and built-in automation offered by Microsoft Excel.

 

Special Offer   Multiple Delegate / Course Discounts Available - Contact Us for Details

 

We don't currently have any courses listed for Excel 2007 - Specialist, would you like to view all courses for Microsoft Office?

Learning Objectives

On completion of this Excel training course delegates will be able to:

  • Use the SumIf, Countif, Index, Match and date functions.
  • Import and export data from other applications
  • Carry out “What-Ifs” using Goal Seek, and Scenario Manager
  • Create dashboard interfaces using form controls
  • Create standardised worksheets with the use of templates
  • Automate common tasks in worksheets by recording and editing macros
  • Assign macros to the Quick Access Toolbar, keystrokes and button on the worksheet.

Pre-Requisites

Students who wish to attend this course must have very good knowledge of Excel 2007 and be competent at working with advanced functions (e.g. Logical & Lookup) and have some basic knowledge of Excel’s analytical capabilities (e.g. Pivot Tables and database tools).

Course Content

Further Functions

  • INDEX

  • MATCH

  • SUMIF(s)

  • COUNTIF(s)

  • Using Date Functions

Importing & Exporting Data

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

Using Goal Seek and Scenario

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

Using Form Controls in a Workbook

  • 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 Access 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

Action planning

Review of Programme

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the request service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

Our Customers Include