Excel - Intermediate

Enquire About This Course

Our 1 day Microsoft Excel Intermediate course is suitable for those with a sound working knowledge of Excel who wish to progress to the more complicated functions and features.

Prerequisites

A working knowledge of Excel or our Introduction to MS Excel course.

 

Benefits

At the end of this course you will have a complete understanding of the higher functions of Excel. You will be able to perform the most advanced calculations and functions, manipulate data using pivot tables and 'advanced' analysis, record macros and integrate with other office applications. You will then be qualified to progress to our Excel Advanced course.

 

Course Content

Sheet Operations

• Copy/ Move Within Current File And To External Files
• Group Sheets ( Adjacent & Non-Adjacent Sheets)
• Link Worksheets Within A Single File
• Link Worksheets to External Files

Security

• Protect Cell Ranges
• Password Protect Files

Advanced Functions

• IF Function & Nested IF Statements
• And & Or Functions
• Lookup Functions (Horizontal And Vertical Lookup)
• Subtotals
• Conditional Formatting

3D Ranges

• Create & Maintain (Within Worksheets In a Single File & Between External Files)
• Consolidate Data (via 3D Ranges & Using The Consolidate Tool)

Organising Workbooks

• Create Templates
• Protect Ranges & Worksheets

Data

• Enter & Records Using The Input Form
• Sort Data Into Lists
• Filter Data - Autofilter, Advanced Filter
• Validation Rules

Outlines

• Group Row/ Column Data To Create Outline Levels Based On Worksheet Formulae
• Display Summary Rows And Summary Styles

Custom Views

• Create and Modify
• Include Hidden Rows, Columns, Filter Settings

Click here to download:

Excel Intermediate

Enquire About This Course