Sanjeev Kumar

Years of Experience in Microsoft Excel Training classes

8

Years of Experience in Computer Classes

3

Teaching Experience in detail in Computer Classes

Course Offering: Advanced Excel, Power BI, VBA/Macro, and Automation Techniques With 3 years of teaching experience and hands-on expertise as a Senior Analyst at Cognizant working on the Google project, I offer comprehensive lessons in data analysis and automation tools, including: Excel Formulas & Functions Master the core formulas like COUNT, COUNTIFS, SUM, SUMIFS, IF/IFS, VLOOKUP, HLOOKUP, INDEX, XLOOKUP, and others. Learn the logic behind these formulas and when to use each one effectively. Advanced Excel Techniques Create and manipulate Pivot Tables for insightful data analysis. Understand how to use the LEFT, RIGHT, and MID functions to manipulate text data. Learn automation techniques to make data reporting more efficient. Power BI & Dashboard Creation Learn how to create impactful, dynamic dashboards in Power BI. Understand the relationship between data models and visualizations. Get hands-on experience automating reports and visualizations. VBA/Macro Programming for Automation Learn how to write and edit VBA/Macro code to automate repetitive tasks. Understand how to create powerful workflows and reports using automation. Google Sheets Apply your Excel skills to Google Sheets and learn the differences and unique features of working with it in cloud-based environments. Teaching Methodology Practical Application: We focus on real-world problems, and I'll guide you through the steps to solve them using formulas and automation techniques. Interactive Lessons: I provide engaging lessons with a hands-on approach, where you can practice the concepts you learn on live data. Clear Understanding of Formula Logic: My teaching goes beyond just knowing the formula—I'll help you understand how they work and when to use them in different contexts. Assessment: You’ll be tested on your knowledge with practical exercises and problems that assess your ability to apply what you’ve learned. Outcome By the end of the course, you will be equipped to: Use formulas to analyze and manipulate data effectively. Create and automate complex reports and dashboards in Excel, Power BI, and Google Sheets. Use VBA/Macro to automate processes and save time

Years of Experience in Microsoft Power BI classes

1

Teaching Experience in detail in Microsoft Power BI classes

Learn how to create impactful, dynamic dashboards in Power BI. Understand the relationship between data models and visualizations. Get hands-on experience automating reports and visualizations.