Virtual Data Analyst Advance Excel Course

http://linktr.ee/ce_viragshah

https://youtu.be/J5q33pjKl-0

https://chat.whatsapp.com/CWip9pLWHUj6ZIEzgjXQSm

# Virtual Data Analyst Advance Excel Course

Visit @

https://connecteasywebinars.myinstamojo.com/

1st to 6th May, 2023

Monday to Saturday

Daily 6:00 pm to 8:00 pm

Registration :

https://imjo.in/VMUREg

Coverage :

✍️ Day 1: Data Cleaning

✏️ Conditional Formatting Tips

✏️ Text Functions

✏️ Cell Functions

✍️ Day 2: Data Screening

✏️ Dependent Drop-down List

✏️ Advance Filter

✏️ Custom Short

✍️ Day 3: Data Crunching

✏️ Power Query for Merging Data

✏️ Lookup Function - 3 Variants

✏️ Index & Match tricks

✍️ Day 4: Financial Data Analysis

✏️ Financial Function Covering (NPV,IRR,PMT,PV,FV)

✏️ Loan Repayment Schedule

✏️ EMI Calculator

✍️ Day 5: Data Automation

✏️Pre-Filled Template Creation

✏️ Macro Creation

✍️ Day 6: Data Visualisation

✏️ Power pivot

✏️ Pivot table

✏️ Pivot chart

✏️ Slicers

✏️ Time Line

Faculty :

CA. Alok Sethi

Corporate Trainer

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

To Your Success,

Virag Shah

CA CMA CS LLB CAIIB

Founder - Connect Easy

+91 7043 154 500

http://linktr.ee/ce_viragshah