Webinar on

Advance MS Excel

on

28^th January 2023

11:00 am to 04:30 pm

Introduction

The training would be very useful to participants across various industries and functional specializations such as Finance, Marketing, Operations, Human Relations, Information Technology and Administration.  No matter which type of industry/service vertical or functional specialization your employees are engaged in, many aspects of MS Excel are “All pervasive” The training is designed such that there would be “significant value addition” to one and all.

Our Excel training course will really show you how to make Excel work for you.

For Whom

This training is aimed at experienced Excel users who need to perform more complex functions, lists analysis, automation using basic macros, use What-If tools and who would like to start recording basic macros & who are already aware of basic features and functionalities.

AGENDA

Ü Updates from 2003 à2007à2010

Ü Naming Ranges/Formulas

ü Naming of Ranges

ü Creating Dynamic Ranges

Ü Pivot Tables / Charts

ü Using various Formats of Pivot Table and creating Pivot Charts

ü Creating additional field(s) in Pivot Table without actually having those in database

ü Advance Chart skills

ü Bi-axis charts for different scaled data

ü Dynamic Charts

Ü Conditional /database Functions

ü Working with conditional functions like Sum-if,  Count-if

ü Ignoring errors from the range

Ü Lookup Functions

ü Using Lookup functions like Vlookup , Hlookup

ü Usage of Match, Index etc

ü Creating Dynamic Vlookup functions

ü Alternate of Vlookup, which is more effective than Vlookup function

Ü Data Validation/ Filters/ Sorting

ü Overview of Data Validations

ü Types of Validations

ü Various types of Messages in validations

ü Filters for more than 2 Criteria on one column

ü Columnar Sorting

ü Manual Sorting

Ü Conditional Formatting

ü Basic understanding/Usage of Conditional Formatting

ü Using various functions in conditional formatting

ü Creating Chess Board through Conditional Formatting (Fun Activity)

Ü Array Functions (For Advance Level users and Programmers)

ü Using Array functions for Conditional Operations

ü Overcoming the limitations of Other functions in MS-Excel

Pre-requisites

You should have good internet connection and good quality headphone/speaker set with Laptop / Desktop.

You should have notepad/pen to note down important points.

How to Register:

Fees: Per person

Rs. 4500 /-

USD 91

18% GST is applicable

> Mode of Payment: NEFT /Paytm / Credit Card/ GPAY

> Fees include certificate of participation & Course Material.

*Terms & Conditions apply

Best regards

For GFORD Institute of Management Pvt Ltd

Ajay Arora

For booking seats Email us : gfordseminar@outlook.com

Mob.: 9711114779 / 9315556407

For Query and nominations – 9540012349 only Whatsapp

For unsubscribe from the mailing list, please mail us on deletemailgford@gmail.com