Microsoft Excel Intermediate Training Course

Click here to Buy MS Office today!

Microsoft Excel Intermediate

Course Aims

This course is designed for existing users of Excel. Users will see techniques for using the application in a more efficient manner and learn how to create more sophisticated formulae. This entirely 'hands on' course allows participants the chance to explore some of the more complex Excel features and functions.

Pre-requisites

This course is aimed at existing users of MS Excel who have attended the Introduction course or have a good basic knowledge of the software.

Target Audience

This course is for users who want to gain a broader understanding of Excel, and utilise its more complex features to work with a greater degree of efficiency and sophistication in their spreadsheets. The topics listed below indicate the range of features which, depending on the interests of the course attendees, can be covered on the course.

Course Outline:

Reviewing Workbook Basics

Entering and Editing Data

Working With Formulae and Functions

Using Autofill

Formatting Worksheets

Working with Multiple Worksheets

Selecting Sheets

Manipulating Worksheets

Linking Worksheets in a Workbook with Formulae

Linking files

Protecting Data

Protecting Cells

Protecting Files with Passwords

Creating Charts

Creating Charts

Manipulating Charts

Modifying a Chart & its Elements

Sorting Data

Sorting Data

Sorting and Sub-sorting

Using Excel as a Database

Searching for Specific Records

Using Validation to Limit Data Entry

Creating Sub-totals

Conditional Logic

Using the IF Function

Creating Nested IF Statements

Conditional Formatting

Extracting Data From a List

Using the VLOOKUP function to extract specific data in a list

Pivot Tables

Setting-up a Pivot Table

Changing a Pivot Table

Working with Toolbars

Hiding and Displaying Toolbars

Adding a Tool to a Toolbar

Removing a Button From a Toolbar

Macros

Recording a Macro

Running Macros

Assigning Macros to Buttons on the toolbars

Using the Worksheet Efficiently

Naming Ranges

Paste Special

Working with Custom Lists

Creating a Custom List

At the end of this course you will be able to:
Work with multiple sheets and files, and link them with formulae; use Excel as a database and sort and filter data in a list; create and edit charts; use more sophisticated formulae and functions, e.g. IF and VLOOKUP.