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

One Month
Two Months
Three Months
More than Three Months
PRINCE2 Foundation & Practitioner
MSP Foundation & Practitioner
APMP Certificate
ITIL Foundation
Scrum in One Day
Certified ScrumMaster
ISTQB Software Test Foundation
Microsoft Project
BCS Business Analysis Practice
Other - Please Specify Below

Our Customers Include