Duration: 1 day(s)
Course Code: XL13L4
Early Bird Courses
London 18th Aug 2017 £191.75 Book
London 22nd Nov 2017 £191.75 Book
For dates or any further enquiries please call 01344 830100
Price: P.O.A

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 Prerequisites

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).

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

 

Programme Focus

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)
 

Click to expand...

Next Learning Step

The next course in this series is:

Excel Level 5 VBA Programming Introduction