0845 450 6120

Excel 2013 - Specialist

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.


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


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

Learning Objectives

On completion of this course you 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


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 Content

Further Functions

  • SUMIF(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

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

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

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

Appendix A – Using Shared Workbooks (if time)

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