Interesting Excel Workshop with Experts

Interesting Excel Workshop with Expert

1st to 5th June, 2021

Daily 6.00 pm to 8.00 pm

Visit @

http://tiny.cc/CONNECTEASY

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

Register @

https://imjo.in/6YSDwj

Fees : Rs. 999 on or before 28th May, 2021, thereafter Rs. 1499

E - Participation Certificate will be Provided.

Day 1

Justify

Painter

Grouping and ungrouping

Data sparkline

Excel maps

3D referencing

People graph

Create Emoji

Excel Tables

Pivot Tables, Pivot slicers

Flash fill

Basic forecasting

Manage your own portfolio with live stock Market data

Day 2

Basic and Advanced Conditional Formatting

Sorting and Subtotal

How to insert different files in excel

Sum, Sumif, Sumifs, Sum between date range

Power full Indirect Function in Excel

Vlookup with trim and Indirect

Day 3

Pivot Tables (in detail)

Macros

Introduction to Macros

Creating Recording Macros

Assigning Shortcut Key

Executing Macros

Creating Macro Buttons

Live Recording of Macros

Day 4

1 Basics of Dynamic Array Functions & Spill behaviour.

2 XLOOKUP AND DIFFERENCE BETWEEN VLOOKUP / HLOOKUP WITH EXAMPLES

3 TEXTJOIN

4 FILTER

5 SORT

6 SEQUENCE

7 UNIQUE

8 Various applications & nested use of these functions.

Day 5

Applied Excel with live Business Case Studies

1) Partnership Remuneration formulation (MIN/MAX function)

2) Income Tax Calculation (IFS function)

3) PAN Number Validation (LET, CODE, MID function)

4) Stock Valuation on FIFO basis via Excel

Expert Faculties : ????

CA. Vaibhav Doshi

Dr. Nipun Shah

CA. Dhananjay Gokhale

(Join Webinar link will be shared on your Registered mail ID)

Kindly share with all your Professional Friends and Connects.

To Your Success,

Virag Shah

+91 7043 154 500