Online Microsoft Office software Course: Excel : London


Hosting By

London

This event is no longer available.

You work independently on this course

Unravel the mysteries of Microsoft Office. The course covers everything from the basics to the most complex functionality, as well as focusing on specific areas of the software. They aim to teach applicable skills and use real-life examples where possible, and can be accessed on a broad range of devices.

This course focuses on Excel

The bundle includes: Microsoft Excel for beginners | Microsoft Excel intermediate | Microsoft Excel advanced

Microsoft Excel for beginners includes: add | multiply | subtraction | dividing | sort | percentage | running totals | merge | filter | average | AVERAGEIF | VLOOKUP | CountBlank | transpose | pie charts | column charts | conditional formatting

Microsoft Excel intermediate includes: | SumProduct | data validation with date, whole numbers or list feature | ABS function | CLEAN function | CELL function with 10 variations | MEDIAN function | N function | RANDBETWEEN function | custom background image | change text to lower case, upper case or proper case | autofill | tables | templates

Microsoft Excel advanced includes: add a password | AND function | auto updating drop-down lists | CEILING formula | charts that update automatically | CHOOSE formula | advanced calculator | combo chart | pivot chart | customise the status bar | DATEDIF function | DATEVALUE function | DAVERAGE function | DPRODUCT | INDEX function | ISERR function | isolate first name | REPLACE function | select all cells with comments | strikethrough | timeline in pivot table | VLOOKUP with two criteria | VLOOKUP with MIN

You must register by 28th March 2021 and then you have lifetime access to the course to always refer back to .

You need internet access and will have to use a laptop, desktop or MAC for this course

Ask A Question

Online Microsoft Office software Course: Excel
  Spice

Hosting By

London

News: London

Posted Dec 17, 2020 12:00
Click here to access our latest newsletter
Posted Dec 11, 2020 12:00
Click here to check out our latest news!
Posted Nov 12, 2020 12:00
Click here for our latest newsletter!
Spice on YouTube

Take a look at some of our brilliant events you can be a part of...