Duration: 1 day(s)
Course Code: XL07L4
Early Bird Courses
London 14th Feb 2018 £191.75 Book
London 24th May 2018 £191.75 Book
For dates or any further enquiries please call 01344 830100
Price: P.O.A

Microsoft Excel 2007 Level 4

Course Aims

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.

Course Prerequisites

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 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.

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

 

Click to expand...

Next Learning Step

The next Excel training course in this series is: