Microsoft Excel 2013 Level 4

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

Related Courses

Access 2013 Foundation                                                    Finance for Non-Financial Managers

Project 2013 Level 1                                                           Presenting with Impact

Excel Level 5 VBA Programming Introduction