Mastering Formulas & Functions in Excel

This workshop is designed for finance and accounting professionals, who work on humongous raw datasets from various sources and in various formats. This workshop is focused on learning advanced excel formulae’s and functions and learn new excel tips and tricks to use them in their daily routines and solve complex business problems.

Our expert trainer will work with all the participants on various data sets and work on practical examples to help them gain expertise in all the advanced formulae’s and functions and its applicability in real world

Hands on exercises will be given to participants helping them to summarize and organize data for meaningful reporting and help them derive insights.

Course Outline

Mastering formulae’s and Functions:

Revising basic Excel functions and formulae’s
Learning Excel Arithmetic operators
Understanding intermediate Formulae’s and Functions
Evaluating and examining the formulae’s
Shortcuts to write the formulas
Look up and Reference functions,
Working with Logical Functions
Absolute and Relative cell referencing
IF conditions
Nested IF conditions
Date & Time Functions
Advanced Date And Time Functions
SUMIF and COUNTIF, SUMIFS and COUNTIFS
Text functions
Statistical Functions
Financial Functions
Math and Trig functions
Database and Information Functions
Multiple exercises to create complex functions
Hands on challenges to be an expert on Nested formulas and functions

Learning Outcomes

The participants of this workshop will learn complex calculation through nested functions, dynamic formulas, enhanced features of nested functions to create meaningful and insightful information using excel to perform their daily tasks efficiently

This workshop will also help the participants to learn new excel shortcuts that will help them increase their productivity in their day to day work

Pre-Requisites

All participants should have their laptop with preinstalled MS office 2010 and above

Who Should Attend

Finance and accounting professionals (such as Accountants, Controllers, Finance managers, Auditors and all accounting professionals) who use excel not only for day to day processing but also for interpretation and data mining to convert raw data to meaningful analysis.

The aim of the course is to make the participants learn advanced excel tips and techniques in a way that helps you enhance your productivity, speed and make your work much easy to interpret.

Contact Us

Name *

Phone Number

Email *

Company Name

Message *