This workshop aims to equip participants with advanced Excel skills essential for 2024 and beyond.
Session content:
Session 1: Advanced Formulas and New Features (New Features & Formulas in Excel)
Introduction to the latest features in Excel (e.g., XLOOKUP, FILTER, SORT).
Utilizing dynamic arrays for enhanced data manipulation.
Exploring new chart types and data visualization tools.
Data Cleaning and Formula Minimization
Session 2: Data Cleaning Techniques using Power Query (Data Cleaning and Formula Minimization)
Leveraging built-in Excel tools: PivotTables, Power Query, and Flash Fill.
Simplifying complex formulas with helper columns and structured references.
Session 3: Introduction to Task Automation & Advanced Visualizations (Task Automation and Optimized Reporting)
Automation of repetitive task using using Power Query
Reshaping Data using power Query
Creating dynamic dashboards and reports.
Automating repetitive process for MIS and Data analytics using Power Query.
For Whom:
Intermediate to advanced Excel users looking to enhance their skills in data management, formula optimization, and task automation.
Key Takeaways:
Mastery of advanced formulas and their applications.
Familiarity with new features and tools in Excel.
Proficiency in data cleaning and preparation.
Techniques to minimize the use of complex formulas.
Skills to automate repetitive tasks and build optimized reports.
Practical experience through hands-on exercises and real-world scenarios
Facilitator profile:
Mr. Shiju has trained over 2000 professionals, 5000+ students, and teachers in the USA, India & Middle East. He has conducted various training on data and Digital technologies in various associations, academic institutions and gives digital transformation consulting to SME’s, he served as principal consultant at UNIFO solutions in the supply chain domain, it head at Hitachi, business solutions specialists in IPP technology Australia, business consultant in Aurionpro
Fee Details:
Fee's Details
Member amount : Rs 2200.00- (Including 18%GST)
Non Member amount : Rs 2800.00- (Including 18%GST)
This workshop aims to equip participants with advanced Excel skills essential for 2024 and beyond.
Madras Management Ceneter
Name : Vinothkanna P
Mobile : 6374603433
Email : mma@mmachennai.org
Knowledge partner:
Mastery of advanced formulas and their applications.
Familiarity with new features and tools in Excel.
Proficiency in data cleaning and preparation.
Techniques to minimize the use of complex formulas.
Skills to automate repetitive tasks and build optimized reports.
Practical experience through hands-on exercises and real-world scenarios
Session 1: Advanced Formulas and New Features (New Features & Formulas in Excel)
Introduction to the latest features in Excel (e.g., XLOOKUP, FILTER, SORT).
Utilizing dynamic arrays for enhanced data manipulation.
Exploring new chart types and data visualization tools.
Data Cleaning and Formula Minimization
Session 2: Data Cleaning Techniques using Power Query (Data Cleaning and Formula Minimization)
Leveraging built-in Excel tools: PivotTables, Power Query, and Flash Fill.
Simplifying complex formulas with helper columns and structured references.
Session 3: Introduction to Task Automation & Advanced Visualizations (Task Automation and Optimized Reporting)
Automation of repetitive task using using Power Query
Reshaping Data using power Query
Creating dynamic dashboards and reports.
Automating repetitive process for MIS and Data analytics using Power Query.
Intermediate to advanced Excel users looking to enhance their skills in data management, formula optimization, and task automation.
Mr. Shiju has trained over 2000 professionals, 5000+ students, and teachers in the USA, India & Middle East. He has conducted various training on data and Digital technologies in various associations, academic institutions and gives digital transformation consulting to SME’s, he served as principal consultant at UNIFO solutions in the supply chain domain, it head at Hitachi, business solutions specialists in IPP technology Australia, business consultant in Aurionpro
Fee's Details
Member amount : Rs 2200.00- (Including 18%GST)
Non Member amount : Rs 2800.00- (Including 18%GST)