• No products in the cart.

STARTS:  11th of January
ENDS:  12th of February
TIME:  10am – 12pm
SCHEDULE:  Tue, Thur

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.


No knowledge of computer and/or IT is required to attend this program.

Who Should Attend?

Data Analysts

Financial Analysts

Intermediate Excel Users

Freshers seeking jobs in Analytics/Consulting job streams

Course Curriculum

Recording: Intro to Advanced Excel Recording 13 Jan, 2021 Details 02:00:00
Recording: Advance Excel Recording_Logical Functions 1_14-Jan-2021 Details 00:18:00
Recording: Advance Excel Recording_Logical Functions2_14-Jan-2021 Details 02:00:00
Recording: Advanced Excel Class Video Recording Database Functions 21 Jan, 2021 Details 02:00:00
Learning to work with Logical Functions
Learning to work with LOOKUP and database formula
Learning to work with Range Name and Drop Down List
Learning how to work with Pivot table and charts
Learning how to work with Scenarios and Macros
What can HOT do better? Details 00:00:00

Training Features

  • Instructor-led Live Sessions
  • Real-life Case Studies
  • Assignments
  • Lifetime Access
  • 24 x 7 Expert Support
  • Certification

Course Objectives

After the completion of the Microsoft Excel Course, you would have learnt the following:

Learn to use formulas and functions.

Create and modify charts.

Convert, sort, filter, and manage lists.

Insert and modify illustrations in a worksheet.

Learn to work with tables.

Learn to use conditional formatting and styles

Create pivot tables and charts

Learn to trace precedents and dependents

Convert text and validate and consolidate data

Collaborate with others by protecting worksheets and workbooks

Create, use, edit, and manage macros

Import and export data



What are the system requirements for this course?

Operating System: Windows 7 or higher, Mac OS.

Processor: Intel Pentium 4 or higher.

Memory:   4GB RAM  recommended.

Screen resolution: 1280 x 1024 or larger.

Application window size: 1024 x 680 or larger.

What if I miss a class?

You will never miss a lecture at HiiT Online Training! You can choose either of the two options:

  • View the recorded session of the class available in your LMS.
  • You can attend the missed session in any other live batch.

Can I attend a demo session before enrollment?

We always keep limited number of participants in a live session to maintain the Quality Standards. But, unfortunately participation in a live class without enrolment is not possible.

Who are the Instructors?

Our Instructors are in-house professionals at least 5 years of relevant experience in various domains. They are subject matter experts and are trained to provide a great learning experience.

Course Reviews


  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

© 2021 HiiT Plc | Privacy Policy | Terms of Use | HiiT Online Training is powered by HiiT Training Institute

Join our Mailing List

Receive updates on our upcoming courses, free webinars & promotions