Special Fee :   Unlock special pricing on single course enrollment with code EYVA10DISCOFF at checkout until 19th September
× Sign in Register Cart (0)

About the Course:

 

Microsoft Excel is one of the most powerful and versatile tools used across industries for data management, analysis, reporting, and decision-making. This course has been carefully designed to help learners develop skills and techniques in Excel through practical, hands-on training.

The program covers basic operations like formatting, formulas, and data handling, to advanced functionalities such as PivotTables and macros. Learners will learn essential as well as advanced features of Excel to manage, analyse, and present data efficiently. This program prioritizes experiential learning and authentic, real-world problem-solving to enhance educational outcomes.

Learners will gain not only the technical know-how but also the practical application skills that employers value, making this course an ideal choice for both beginners and professionals who want to enhance their Excel expertise.

 

Who should take this Course

 

  • Students and graduates seeking to strengthen Excel skills.
  • Working professionals whose roles involve frequent data handling
  • Analysts, entrepreneurs, economists, and data professionals seeking to deepen their expertise in Excel.
  • Anyone looking to improve reporting, productivity, and data-driven decision-making.

Course Coverage

 

Module 1:

  • Data tables in Excel
  • Basic cell formatting
  • Data filtering and sorting
  • Cell grouping
  • Conditional formatting
  • Freezing panes

Case study
 

Module 2:

  • Date formatting
  • Flash fill
  • Removing duplicates
  • Data validation and dropdowns 
  • Cell merge, custom formatting introduction, wrap text
  • Paste special and text to column

Case Study

 

Module 3:

  • IF function, nested if, IFS, IF AND OR
  • Cell referencing basic, absolute, mixed
  • Arithmetical functions: IFERROR, SUM, AVERAGE, MAX, AVERAGEIF, MIN, COUNT, COUNTA, COUNTIF, SUMIF, SUMPRODUCT

Case study


Module 4:

  • Lookup functions: VLOOKUP, HLOOKUP, XLOOKUP
  • Index and Match functions
  • Tracing precedents and dependents, circular referencing error
  • Pivot tables, slicers, pivot charts, value field settings

Case study
 

Module 5:

  • Using Index and Match function together to look up values
  • Creating dynamic dropdowns for different scenarios
  • Offset function basics, using with arithmetic functions
  • Text function, ampersand (&) function

Case study
 

Module 6:

  • Using custom formatting
  • Rounding off functions, MOD function, ABS function
  • Find and replace, MONTH, YEAR, NETWORKDAYS, HYPERLINK, TRIM, RANDOM function

Case study
 

Module 7:

  • CAGR computation
  • PMT function
  • TVM formulas: NPV, IRR, PV, FV functions
  • What-if analysis, data table, single/double variable

Case study


Module 8:

  • Goal Seek function
  • Scenario analysis
  • Named ranges
  • Macros – absolute, relative referencing
  • Creation of construction flags, max and min functions
  • Worksheet protection

Case study

   

Related Courses

For queries, feedback or assistance

Contact EY Virtual Academy Support

ey.learningsolution@in.ey.com
We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept All”, you consent to the use of ALL the cookies. However, you may visit "Cookie Settings" to provide a controlled consent.