Microsoft Excel 2016 - Advanced

Course Information
Log In to enroll.

Don't have an account with us? First, Register a new account and then come back here to enroll.

Location: Online

Duration: 15 Hours

Start Date: 7/7/2020

Enrollment opens: 7/7/2020

Categories

Microsoft Excel 2016 - Advanced

Synopsis

Course Overview


Formulas make Excel smart. With out them, Excel is just a data keeping tool. But by using formulas, you can crunch data, analyze it and get answers to most complex questions. While beginners to excel can use a simple SUM or IF formula, as an advanced user of excel you will be able to seamlessly write & combine formulas like SUMIFS, SUMPRODUCT, INDEX, MATCH, LOOKUP formulas. Apart from knowing the formulas, as an advanced Excel user, you will know how to debug them, audit them and how to use which formula for which occasion - and you may even have a few alternatives for any given formula problem.


IMPORTANT: Exploring Digital Skills must be completed prior to enrollment in Microsoft Excel 2016 - Advanced.