Excel Excellence : Advanced Tools & Automation (Virtual Course)

http://linktr.ee/ce_viragshah

https://youtu.be/J5q33pjKl-0

https://chat.whatsapp.com/Hn6DaCwonZnCcOFklCRDdj

# Excel Excellence : Advanced Tools & Automation (Virtual Course)

Visit @  

www.connecteasy.in

16th Sept. to 20th Sept., 2024

Monday to Friday  

7 pm to 9 pm Daily

Register @  

https://imjo.in/yZvaFH

A participation certificate will be awarded.

Coverage: 

Day 1: Data Management and Analysis  

- Sorting and filtering data with Smart Shortcut Keys  

- Using AutoFill and Flash Fill, Customising Ribbon & QAT  

- Sum, Sumif, Aggregate, Subtotal and database functions  

- Custom Sort & Advanced Filters  

Day 2: Conditional Formatting and Charts  

- Applying conditional formatting rules  

- Creating and customizing charts  

- Sparklines and trendlines  

- Using slicers and timelines  

- Creating Integrated Dynamic Dashboards  

Day 3: Advanced Data Analysis Tools  

- Using Data Validation  

- Using Goal Seek and Solver  

- Performing What-If analysis  

- Analyzing data with statistical functions  

Day 4: PivotTables and Power Query  

- Creating PivotTables and PivotCharts  

- Customizing PivotTable fields and layouts  

- Advanced PivotTable techniques  

- Introduction to Power Query  

- Importing, transforming, and combining data  

Day 5: Automation with AI & Power Automate  

- Introduction to AI and AI Tools  

- Integrating AI Tools with Excel  

- Introduction to Automate in Excel  

- Writing Work Flows in Automate for routine tasks  

- Case Studies for Automation of sending emails and reminders  

Guest Speaker:  

CA. Alok Sethi  

Global Corporate Trainer  

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