Microsoft Excel (Intermediate)

Description

MS Excel the popular spreadsheet from Microsoft.

This 1 day course is designed to increase users' knowledge of the features and functions within Excel and realize the advantages of using a powerful electronic spreadsheet.

The course is entirely 'hands on', so those attending will get practice in creating and modifying actual spreadsheets, enhancing them with charts. Joe is a Certified Microsoft Master Instructor.

It is assumed that you can bring your own laptop to the course with MS Excel installed.

Users with a basic understanding of MS Excel who want to consolidate and expand on their knowledge of the basic features in a short space of time.

A working knowledge of using PCs, Windows, gained from the workplace or by prior attendance on a course.

Learn by doing – in additional to the formal presentations from Trigraph, attendees will benefit by using the MS Excel software itself on their own dedicated PC / Laptop. They will build their own Worksheets.

All of our trainers are highly skilled project management professionals with formal Microsoft Excel certification.

The training materials are fully owned by Trigraph which means we have full flexibility to tailor the content to suit particular client requirements.

What you will learn

On completion of this course, delegates will be able to:

• Review the basics
• Custom Formatting
• Use Templates
• Data Validation
• Navigating large Worksheets
• Using more advanced formulae
• Productivity features
• Charts
• Excel and the Internet
• Using Autofilter

Getting Started

Reviewing the Basics
Custom Formatting

Using Custom Formats
Using Conditional Formatting
Number Formatting eg ‘000
Using Templates

Creating Templates
Data Validation

Setting-up Data Validation / Drop Down Lists
Navigating Worksheets and Workbooks

Working with Large Sheets
Worksheet Linking
Using More Advanced Formulae

Preventing Rounding Errors
Conditional Formulae (IF, IfError, SumIf) / Financial Functions (PMT)
Productivity Features

Protecting the Worksheet
Hiding Data
Absolute Cell References
Charts

Creating Charts / Changing Chart Elements / Changing Chart Data
Combination Charts / Printing Charts / Inserting Logos / Manipulating Objects
Excel and the Internet

Creating Hyperlinks
Saving a Worksheet as a Web Page
Using AutoFilters

Selecting / Sorting/ Criteria Filters