Excel Xplore: Journey to Proficiency (Virtual Sessions)

Excel Xplore: Journey to Proficiency (Virtual Sessions)

"Embark on a transformative journey to Excel mastery, exploring advanced features and strategies."

A participation Certificate will be awarded.

Visit @

www.connecteasy.in

17th to 21st June, 2024

Monday to Friday

6:00 pm to 8:00 pm

Fees: Early Bird Rs. 999 on or before 14th June, 2024 ; thereafter Rs. 1499

Register @

https://imjo.in/EuJ3ay

Coverage:

Day 1: Data Management and Analysis

✏️ Sorting and filtering data with Smart Shortcut Keys

✏️ Using AutoFill and Flash Fill

✏️ Subtotal and database functions

✏️ Custom Sort & Advanced Filters

Day 2: Conditional Formatting and Charts

✏️ Applying conditional formatting rules

✏️Creating and customizing charts

✏️Sparklines and trendline

✏️Using slicers and timelines

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: Macros and Automation with AI

✏️ Recording and editing macros

✏️ Introduction to VBA (Visual Basic for Applications)

✏️ Writing VBA code for automation

✏️ Creating custom functions using AI Tools

✏️ Integrating macros and automation into Excel workflows

Faculty:

???? CA. Alok Sethi

Global Corporate Trainer

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

To Your Success,

Virag Shah

+91 7043 154 500

http://linktr.ee/ce_viragshah