HomeAdvance Microsoft Excel

Microsoft Excel is a spreadsheet program used to store and retrieve numerical data.

The Advanced Microsoft Excel course goes beyond this. 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, etc

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 

Thirty Thousand Naira only (N30,000.00)

4 Weeks (Three times a week)

©2022 Softalicious Technologies. All Rights Reserved.