Microsoft Excel Intermediate

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.

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