Microsoft Excel: Intermediate

What topics are covered by the course?


Introduction
Refresher on basic formulas and functions
Preventing rounding errors
Building in checks and proofs
Conditional formulas
Linking worksheets/workbooks

Further functions
Logical functions; IF, AND, OR
Conditional statistical functions
Date and time functions

Creating business diagrams
Creating Venn diagrams
Editing diagrams
Exporting diagrams

Databases
Creating a database
Sorting and filtering
Sub-totalling
Consolidations
Enhanced list functionality

Formatting numbers
Creating custom number formats
Conditional formatting
Controlling date formats

Creating charts
The different types of charts
Chart formatting features
Using Trends
Combining charts
Linking Excel and Word Security
Worksheet protection
Workbook protection

Security
Worksheet protection
Workbook protection

Questions and answers

Who should attend?

You should have attended the Introduction to Microsoft Excel course at Media Training or have an equivalent working knowledge.

What will I be able to do on completion?

You will look at different ways of formatting, analysing and presenting information and learn to use both databases and charts to analyse data.

How will I be assessed?

There is no formal assessment at the end of this course.

Guide Price: 420 plus VAT

Delivery: Classroom
Category: Intermediate Microsoft Excel »
Duration: One day

Search for intermediate microsoft excel courses in