Advanced Microsoft Excel

Advanced Microsoft Excel

 

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.


Course Content

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 

For Whom

  • Business analysts
  • Administrative assistants
  • Marketing managers
  • Project managers
  • Accountants
  • Financial analysts
  • Job Seekers or anyone that is required to work with computers on a day-to-day basis. 

Duration

Commencement Date: 7th August 2018

Duration: 4 weeks 

Payment Methods

Interested individuals can pay using the following methods:

Pay at the centre of your choice
Pay to the bank using the following bank details
Account Number: 2011745387

Account Name: HiiT Plc

Bank: First Bank

Payment Types

Full Payment (Attracts 5% discount of Course Fee)

Installmental Payments (First Payment= 60% of Course Fee)



Location Price
Lagos ₦30,000



[/su_note] [/su_animate]