Webinar on

Advance MS Excel

on

28th 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 20072010

  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