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

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 Content

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


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)

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the request service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

Our Customers Include