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.