We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

Details

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.

Outline

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. 
Reviews
Be the first to write a review about this course.
Write a Review
HiiT Plc is Nigeria’s best Indigenous IT Training Establishment. We have excelled in IT Training/Education, Publishing, IT Consultancy and IT Solutions Development & Services. In our 20 years of successful existence, we have graduated over 50,000 students at our CPN-accredited IT Training Centres located in Lagos, Abuja, Ibadan, Kano and other cities nationwide.
HiiT Plc
27 Awolowo Way,Ikeja,Lagos, ikeja, lagos, Nigeria 234
Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.