Excel Never Fails To Amaze

Excel is a simple and powerful financial analysis tool. It has various features that help in improved presentation of financial data and reports. This Advanced MS Excel course provides the formulas and techniques that can be used for simplifying large volume of data, clearing inconsistent fields or values. A combination of techniques and complex formulae can be used to manage difficult calculations and workings.

It is important to note that in MS Excel, there can be multiple methods to achieve a result. There can be different approaches, but the key is to reach the desired result within the shortest time. Hence the key to being effective at Excel is to define the objective first and then to use the various tools and formulae based on requirement.

This course is ideal for

  • All individuals seeking to learn advanced functions in MS Excel
  • Executives responsible for preparation of financial models, reports, projections, etc.
  • Senior executives and managers who need to analyse data and reports

The Course is Divided into these 5 Modules

Module 1: Important Tools

  • Excel Overview
  • Formula Referencing
  • Keyboard Shortcuts

Module 2: Data Cleaning and Data Validation

  • SORTING Procedure
  • FILTERS and Advance Filters
  • LOOKUP Function
  • Error Checking (e.g. tracing dependants)
  • Auditing a Formula

Module 3: Data Analysis Techniques

  • PIVOT TABLE with Multiple Data and Data Models
  • Nested Functions, Name Cells/ Ranges/ Constants
  • Relative, Absolute, Mixed Cell References: >,<,= Operators
  • Logical Functions using IF, AND, OR, NOT
  • The LOOKUP function

Module 4: Special Functions

  • Date and Time functions
  • Annotating Formulas
  • Gantt Chart
  • What If and Goal Seek
  • Ageing Analysis
  • Others: LEFT, MID, RIGHT, LOWER, UPPER, PROPER, CONCATENATE, TRANSPOSE

Module 5: Developing the workbook

  • Formatting Worksheets, Securing & Protecting Spreadsheets
  • Password Protecting Worksheets
  • Linking Multiple Sheets
  • Sheet Referencing
  • Linking Between Word/Excel/PPT

MS Excel offers immense possibilities. It is only through patient, dedicated and hands-on interventions that one can master Excel. Based on the specific needs and well-defined demands of the key management personnel, experts at V. Purohit & Associates can tailor high impact, Advanced Excel Training modules.

Talk to us

Talk to us, to share your requirements. We will be happy to discuss your challenges and co-create solutions.

We are a new-age financial accounting company, that upholds age-old values and principles of Chartered Accountancy. We offer a fairly-differentiated set of services, tailored to specific business goals and challenges.

Services