Princepal Singh Ms Excel, Power Query, Power BI, VBA macro
No reviews yet

I am committed to equipping professionals with the tools and knowledge required to leverage data effectively for strategic decision-making and operational excellence. With a strong foundation in Excel, Power BI, Power Pivot, Power Query, VBA, and Lean Six Sigma methodologies, I deliver impactful training solutions that drive measurable results and empower teams to achieve their goals.
Key Skills and Expertise:
1. Technical Proficiency: Mastery in Excel including advanced functions, macros with VBA, Power Pivot, and Power Query for data modeling and visualization.
2. Power BI Proficiency: Experienced in creating interactive dashboards and reports to facilitate data-driven decision-making.
3. Lean Six Sigma Knowledge: Applied Lean Six Sigma methodologies to drive process improvements and operational efficiencies.
4. Training and Development: Skilled in developing engaging training materials and workshops that promote hands-on learning and practical application.
Professional Approach:
1. Customized Training Solutions: Tailor training sessions to meet specific organizational objectives and learner requirements, ensuring maximum knowledge retention and application.
2. Interactive Learning: Foster an interactive and collaborative learning environment to enhance participant engagement and comprehension.
3. Continuous Improvement: Stay updated with the latest advancements in Excel, Power BI, and Lean Six Sigma practices to deliver up-to-date and relevant training content.
Personal Attributes:
1. Passion for Education: Dedicated to empowering individuals with the skills and confidence needed to excel in data analysis and process optimization.
2. Effective Communication: Clear communicator adept at explaining complex concepts in a straightforward manner.
3. Analytical Thinking: Utilize analytical thinking to address challenges and facilitate efficient learning experiences.

Subjects

Google Sheets Beginner-Expert
Power Query Beginner-Intermediate
Power Pivot Beginner-Expert
MS - Excel Beginner-Expert

Experience

MOR (Jan, 2025–Present) at Greystar
MIS Executive (May, 2024–Jan, 2025) at Chandigarh group of colleges, Jhanjeri
MIS Executive (Jan, 2023–May, 2024) at Teleperformance

Education

BA (Jul, 2019–Jul, 2022) from MDSU, Ajmer University

Fee details

₹400–600/hour (US$4.21–6.32/hour)

Courses offered

MS Excel
- ₹3600
- Duration: 3 Weeks
- Delivery mode: Online
- Group size: Individual
- Instruction language: Hindi, English
- Certificate provided: No
Unlock the full potential of Microsoft Excel with this comprehensive course designed for all skill levels – from beginners to advanced users. Whether you're looking to master basic data entry, create complex formulas, or learn advanced data analysis techniques, this course has you covered. Taught by experienced instructors, the course is structured to provide hands-on learning, practical exercises, and real-world applications, allowing you to gain proficiency at your own pace.

Course Outline:
1. Basic Excel Skills:

Introduction to MS Excel interface: Workbooks, Worksheets, and Cells
Basic operations: Data entry, navigation, and formatting
Working with simple formulas and functions (SUM, AVERAGE, MIN, MAX)
Formatting cells: Font styles, colors, and borders
Sorting and filtering data
Basic charts and graphs
2. Intermediate Excel Skills:

Advanced functions: IF, VLOOKUP, HLOOKUP, COUNTIF, SUMIF
Conditional formatting: Highlighting data based on rules
Managing large datasets: Freezing panes, grouping, and ungrouping data
Data validation techniques
Introduction to PivotTables and PivotCharts
Data analysis using basic Excel tools
3. Advanced Excel Skills:

Complex formulas: Nested functions, array formulas, and complex conditions
Advanced PivotTables: Grouping, calculated fields, and multiple consolidation ranges
Advanced charting techniques: Combination charts, trendlines, and data visualization
Automating tasks with Macros and VBA (Visual Basic for Applications)
Advanced data analysis: Using Power Query, Power Pivot, and Power BI integration
Data modeling and scenario analysis
Reporting and dashboard creation
Course Features:

Interactive, instructor-led online sessions
Step-by-step demonstrations and tutorials
Practical assignments and quizzes for each level
Personalized feedback and support from instructors
Real-life business case studies and applications
Lifetime access to recorded sessions and course materials
Who Should Take This Course:

Beginners who want to build a strong foundation in MS Excel
Intermediate users aiming to enhance their Excel skills
Professionals who require advanced Excel techniques for data analysis, financial modeling, and reporting
Students looking to improve their productivity and data management capabilities
By the end of this course, you'll be equipped with the skills to use MS Excel confidently, from basic tasks to advanced data analysis, allowing you to streamline your work processes and make data-driven decisions more effectively.

Enroll now and become an Excel expert at your own pace!