Menu

Advanced Microsoft Excel at HiiT - ₦30,000

Advanced Microsoft Excel is much more than a quick way to add up numbers. In this course, you will learn advanced features such as nesting IF statements, how to calculate the Mean of a group of numbers using AVERAGEIF, SUMIF and more. You will learn about performing lookups with HLOOKUP and VLOOKUP. This course also covers Sparklines, and goes in-depth with Pivot Tables and Charts. Finally, you will learn how to create and record your own Macros.

Pre-requisite:
No knowledge of computer and/or IT is required to attend this program.

The courses that are covered in this program include:
Using logical functions
Naming ranges
Creating named ranges
Using named ranges in formulas
The IF function (recap)
Creating nested IF functions
AND and OR functions
Combining logical functions
Working with lookups
The VLOOKUP function
The HLOOKUP function
Advanced list management
Using data validation
Setting criteria for entry of text, values and dates
Creating a dropdown list
Using database functions
Setting up criteria
DSUM
DAVERAGE
DCOUNT
Pivot Tables and Pivot Charts
Using the PivotTable Wizard
Rearranging PivotTables
Using the PivotTable toolbar
Creating Pivot Charts
Using Slicers to manipulate PivotTables
Using analytical options
Using Goal Seek
Using the Solver add-in
Working with scenarios
Creating and saving scenarios
Viewing scenarios
Macros

Duration:
4 weeks

Contacts:
27 Obafemi Awolowo Way, Beside Obafemi Awolowo House, Ikeja, Lagos.
Phone: 0816-1660-043, 0802-270-5992
Email: [email protected]