Single Courses
 
Contact Us

  • Address :
  • 123 King Street
    Hammersmith
    W6 9JG

  • Contact No. :
  • 0800 232 1806
    0208 455 9585

Excel Expert  

Aims and Objectives

To learn advanced spreadsheet skills using Microsoft Excel

Know how to use Excel in order to sit the MOS Expert examination

The flexibility and value of self-study course designed to enable you to work at your own pace

A personalised workbook to use as a reference guide on completion of the course

The opportunity to gain the widely recognised Pitman Training Certificate

Target Audience

Those who wish to learn Excel to the Microsoft Office Specialist (MOS) Expert syllabus

Prerequisites

Knowledge of Excel

Course Content

Lesson 1: Importing and exporting data. Object linking and embedding. Importing data from web files

Lesson 2: Using templates. Creating and applying custom templates. Editing and storing templates

Lesson 3: Using multiple workbooks. Linking workbooks. Creating and using workspace files

Lesson 4: Formatting numbers. Using custom formats. Using conditional formats

Lesson 5: Printing workbooks. Grouping worksheets. Printing multiple workbooks. Using the report manager

Lesson 6: Working with named ranges. Moving and deleting a named range. Range names in calculations. Adding and removing toolbar buttons. Creating toolbars

Lesson 7: Working with toolbars. Customising toolbars. Adding and removing buttons. Creating a new toolbar. Creating customised menus

Lesson 8: Using macros. Recording macros. Running and editing macros. Assigning a macro to a toolbar or menu

Lesson 9: Auditing a worksheet. Data entry validation. Auditing data dependency. Showing cells containing ERROR values

Lesson 10: Working with data lists. Filtering lists and using custom filers. Form option buttons. Criteria option buttons

Lesson 11: Data management. Searching for data with advanced filters. Summarising data with outlines. Querying a database Controlling formatting and layout. Refreshing external data

Lesson 12: Pivot tables. Creating pivot tables. Modifying and grouping pivot tables. Creating interactive pivot tables for the web

Lesson 13: Using analysing tools. Goal seeking. Using Solver. Scenario Manager

Lesson 14: Workgroups. Applying worksheets protection. Password protecting a file. Adding comments to the worksheet. Working with shared workbooks. Merging workbooks. Tracking changes and resolving conflicts

Course Duration: 18-20 Hours

Course Code: 1010111203