Excel 2013 Level 4

Duration: 1 Day

Course Code: XL13L4

Course Aims:

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

Course Pre-requisites:

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

Course Objectives:

On completion of this course delegates will be able to:

  • Find and calculate data using lookup, math and statistical functions
  • Calculate with dates
  • Manipulate text using calculations and text functions
  • Import and export data from/to other applications and text files
  • Carry out “What-If Analysis” using Scenario Manager, Goal Seek and Solver
  • Create dashboard interfaces using form controls
  • Create standardised worksheets with the use of templates
  • Automate common tasks in worksheets by recording macros
  • Assign macros to the Quick Launch Toolbar, keystrokes and worksheet buttons

Course Content:

Introduction and Objectives

Further Functions

  • INDEX
  • MATCH
  • SUMIF(S)
  • COUNTIF(S)
  • Date Functions
  • Text Functions

Importing & Exporting Data

  • Importing Data from text files
  • Importing Data from the web
  • Changing external data range properties
  • Removing the query definition
  • Exporting data

What If Tools

  • Using the Scenario Manager
  • Displaying a scenario
  • Creating a scenario summary report
  • Obtaining the desired result to a formula using Goal Seek

Using Form Controls in a Workbook

  • Creating a check box, list box, combo box, options buttons & spin button
  • Using Templates
  • Creating, using, editing and deleting templates

Introduction to Macros

  • Defining & running macros
  • Recording a macro
  • Assigning a shortcut key
  • Adding a custom button to the Quick Launch Toolbar
  • Adding a macro button to a worksheet

Action planning
Review of Programme

Click Here to view Course Dates

For more information on how to book, please click here.

Many thanks,

WWP & the Euroclear Team