Advanced Excel with AI course is designed to provide practical, hands-on experience to ensure that the participants can apply their new skills effectively in their daily tasks and succeed in the rapidly shifting landscape of AI in Excel.
Day I
· Logical and Lookup Functions
· Data Presentation with Charts
· Conditional Formatting
· Data Analysis with Pivot Tables
· Data Exploration with Pivot Charts
· Developing Interactive Dashboard
Day II
· Recording and Running Macros
· Basic Editing of Macros
· Basics of VBA Programming
· Capabilities and Limitations of Gen AI
· AI-assisted Data Analysis in Excel
· AI-assisted VBA Programming
Dr Shrikant Mulik brings over 24 years of industry experience, including nearly 18 years with L&T Infotech. He holds a PhD from NMIMS University, an MBA from IIT Bombay, and a B.E. in Computer Science from Mumbai University. He has published 12 research papers, accumulating over 600 citations. Currently, he serves as Director at Vidyarjan Academy (VidAc) and Director at Vidyarjan Foundation.
· Individuals starting with basic Excel knowledge and aspiring to master advanced features.
· Those interested in leveraging AI to optimize data analysis and presentation in Excel.