+44 (0)20 3283 8799 enquiries@bitesizeltd.com
Log in
+44 (0)20 3283 8799 enquiries@bitesizeltd.com
Excel

MS Excel Course Outline – Advanced level

Course Description

This advanced MS Excel course focusses on analysing data in Excel. You will also find it helpful if you spend most of your working day using Excel and need to learn more about the various functions..

By the end of this course you will be able to work with logical functions such as IF and OR, NOT and count up blank cells, add up cells that meet a certain criteria with CountIF. You will learn how to use V and H lookups to quickly pick up data. You will learn how to perform calculations based around dates and also create different types of charts (depending on the data you have) including new ones such as Waterfall and Histograms.

Estimated course duration is 3-4 hours. Each lesson takes on average 3-5 minutes to complete.
Download PDF

Topics Covered

Logical Functions

If Function
Nesting Functions
AND & OR Functions
Not Function
Nested IF Functions

Maths and Statistical Functions

Count A
Count Blank
Count IF
SUM IF
Integer
Displaying/Printing Formulas

Lookups

Vlookups
Hlookups
Using Index
Using Match

Text Functions

Case
Left and Right
Concatenate

Working with dates and times

Calculations with dates and times
Subtracting time
Subtracting one year from another
Working out your age
How many days to a future date
Number of weekdays between 2 dates
Add days, weeks, months or years to a date
How many minutes have you been alive?

Charts

Column charts
Line charts
Bar charts
Pie charts
Area charts
Scatter charts
Stock charts
Surface charts
Doughnut charts
Radar charts
Bubble charts
Histogram charts - NEW
Pareto charts - NEW
Waterfall charts - NEW
Box and Whisker charts - NEW
Sunburst charts - NEW
Tree map charts - NEW

Can't see what you need?

All Microsoft Office Online Courses are based on a typical one day training course at a specific skill level and are included in our full online library. If you require a more tailored course to meet a particular learning need, get in touch.

All Personal Development Online Courses are 15 minute modules that complement our Bite Size methodology and work well together to create a great training plan.

Great deals for Corporate licences – give us a call.

GET IN TOUCH

On-line courses

Face to face Workshops

Virtual On-line Classes

On-line Shop for 1 to 50 licences

Personalise your own course

Create your own branded learning site
bitsy

Sign up for our free weekly tip

Receive a free nugget of IT Learning every week! It will give you a good feel for how we write and design our lessons and you could learn something new every week too!

Sign Up See our Tips