Microsoft Excel 2013 Level 4

WWP Training Limited
Delivery Method: Face-to-face

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

  • 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

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


Related Courses

Access 2013 Foundation                                                    Finance for Non-Financial Managers

Project 2013 Level 1                                                           Presenting with Impact

Excel Level 5 VBA Programming Introduction

Dates available on arrangement

WWP Training Limited can also create this course for you on arrangement either at your workplace or at one of their locations.

Make Enquiry

Write A Review Of Microsoft Excel 2013 Level 4

£336.00 (inc VAT)
Make Enquiry Add To Wishlist
All prices include VAT where applicable