Microsoft Office training - Excel Intermediate

Excel Training

Intermediate Excel Training Course

£295 + VAT for most venues (£395 + VAT for London)

1 day

Once you've got the basics of Excel, it's time to learn a little more about what you can do. This one-day intermediate course will show you how to use range names, sort and filter lists, create decision (IF) functions and much more!

Course details

Locations:Manchester, London
Next course:Fri 18 May 2018
Time:09.30-16.30

SCHEDULED DATES Course Contents - PDF

Course Contents

Absolute references

Absolute cell references
Using the $ sign

Range names

Creating range names
Editing/deleting range names

Conditional formulae

Creating a single =IF formula
Using =SUMIFS and =COUNTIFS
Combining conditions (AND, OR and NOT)

Conditional formatting

Creating cell rules
Managing cell rules
Viewing conditional formats
Data bars and icon sets

Basic tables

Using a spreadsheet as a table
Sorting table data
Filtering table data
Table styles (a warning!)

Advanced printing

Layout versus Preview tab
Print areas and print tiltes
Setting/removing page breaks
Headers, footers and page numbering

Formatting numbers and dates

Standard number formats
Hiding cell contents
Date formats

Working with dates

Using series fill
Using dates in formulae
TODAY and NOW

Covered if time allows If time

Data validation

Setting validation rules
Input and error messages
Highlighting validated cells
Circling invalid data

Protection

How protection works
Unlocking cells
Turning protection on for a worksheet
Protecting the whole workbook

Why Choose Us?

No more than 6 people per class
Proper restaurant lunch included
572 references viewable online
Free USB stick containing course files
Genuine Wise Owl trainers only
Unbelievably good courseware

View full list of benefits

Sample customer feedback

"Tutor was very knowledgeable, helpful and approachable...., made SQL interesting. Course material is very detailed and useful. Found the content really useful and something I will definitely use at work."

Vicky Murphy (Berrymans Lace Mawer (BLM))

"The course was exactly what I was looking for in order to complete a specific project that I am working on shortly. Many of the topics are relevant to what I had in mind for the project. The content of the course and duration were right for a basics to RB. The trainer, was excellent and I learned a lot from his teaching method."

Mark McArdle (BAE Systems)

"Really good, enjoyable. Group size was perfect for keeping everyone together."

Paul Ryan (Ebiquity Plc)

"Very good, I will definitely recommend this course to anyone!"

Chris Daplet (Centrica Energy)

"Excellent content, pace and delivery. Highly recommended."

Bob Hurst (Bishop Grosseteste University)

There are lots more where these came from (or just refresh this page to change the quotes shown).

You shouldn't attend this course unless you're already familiar with creating formulae in Excel.

Other Microsoft Excel training resources

Excel exercises

To help you determine if this is the right course for you, we've published all of our Excel exercises online.

View Excel, Excel VBA or PowerPivot exercises

Excel videos

In addition to providing classroom training, we've also created a series of online training videos on Excel.

View Excel tips, Excel VBA - Basics, Microsoft Excel, PowerPivot or Excel VBA - pivot tables/charts videos

Excel skills assessment

You can test how well you know Excel by taking one of our skills assessment tests.

View Excel skills assessment or Excel VBA skills assessment skills assessment tests

Excel blogs

We've published lots of blogs on various aspects of Excel, which make for good reading for when you have a few spare moments.

View Excel, Power BI - Excel or VBA macros blogs

This page has 0 threads Add post