Mastering Microsoft Excel At Work Webinar Series

# Mastering Microsoft Excel At Work Webinar Series

5th to 9th September, 2022

Monday to Friday

6:00 pm to 8:00 pm

“Microsoft Excel is one of the greatest, most powerful, most important software applications of all time.”

Fees : Early Bird ₹. 999 on or before 2nd September, 2022 ; ₹. 1499 thereafter

Registration :

https://imojo.in/CEexcel

Coverage :

Day 1

Functions, Formulas,

3D formulas, array formulas

Vlookup

Hlookup

Index

Match

Text Functions

Day 2

Funtions, Formulas,

3D formulas, array formulas

Round functions

Logical Funtions

Countif

Sumifs

Dynamic Array Funtions

Database Functions

Day 3

Macros & Advanced Uses of Macros

Recording of Macros

Executing Macros

Creating a Macro Button

Live Recording of Macros

Relative and Absolute Ref

Macro Security

Editing Recorded Macros

Day 4

Pivot Table

Creating Pivot Table

Pivot Charts

Pivot With Tables

Pivot Table Designing

Pivot Slicers

Classic and Tabular Format

Creating Dashboards

Day 5

Advanced Features

Charts

Tips and Tricks with Flashfill

Consolidation

Xlookup

Whatif analysis

Goal Seek

Power Query

Power Pivot

Advanced features of Excel 365

Guest Speaker :

CA. Kedar Pande

B.Com, FCA, DISA

Kindly Share with all your Professional Friends, Colleagues and Other Connects.

To Your Success,

Virag Shah

CA CMA CS LLB CAIIB

Founder - Connect Easy

+91 7043 154 500