Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Reporting, Analytics With Excel+Macro+SQL+Power BI (43Hours)
Rating: 4.6 out of 5(234 ratings)
1,239 students

Reporting, Analytics With Excel+Macro+SQL+Power BI (43Hours)

Combo pack of Excel, Excel VBA and Macro, SQL Server, Power BI, Power Query, DAX Step by Step Practical Live Training
Created byShishir Kumar
Last updated 4/2026
English

What you'll learn

  • Advanced Reporting and Analytics with Advanced Function and Formula in Excel
  • Automation with VBA Macro Development with Different Projects
  • Database Management and Query Optimization with SQL Server Database
  • Power BI Report and Dashboard Designing and Data Modeling with and Use of DAX (Data Analytics Expression)

Course content

47 sections201 lectures43h 13m total length
  • Course Overview17:07
  • Practice Dataset2:30
  • What is Analyst8:05
  • Excel and Advanced Excel Introduction5:20
  • Excel Macro Introduction and Basic Macro writing16:16
  • SQL Introduction7:12
  • Power BI Introduction, Import Data and Visualization24:15

Requirements

  • No specific requirement for this course

Description

Are you ready to take your Microsoft Excel skills to the next level? Do you want to become proficient in Management Information System (MIS) reporting and harness the power of Visual Basic for Applications (VBA) and SQL Server for automation and Data Management? This comprehensive course is designed to make you an expert in advanced Excel techniques, MIS reporting, and VBA macro development, SQL Server Database, Power BI Data Modeling, Report and Dashboard Design, Power Query and Dax (Data Analysis Expressions)

**Advanced Excel Skills:** This course will empower you with advanced Excel skills, including data analysis, complex formulas, pivot tables, and data visualization. You'll learn how to tackle complex tasks with ease. - **MIS Reporting Excellence:** We'll delve into the world of MIS reporting, teaching you how to create, manage, and present data effectively for informed decision-making. You'll gain the knowledge and practical skills needed for efficient data reporting and analysis. - **VBA Macro Development:** Take control of Excel with VBA. Learn how to automate repetitive tasks, create custom functions, and build interactive user interfaces. VBA mastery will save you time and boost your productivity.

**Hands-On Learning:** We believe in learning by doing. You'll have ample opportunities for hands-on practice with Excel and VBA. By the end of the course, you'll have a portfolio of work that showcases your skills. - **Expert Instruction:** Our experienced instructors are passionate about Excel, MIS, and VBA. They will guide you through the course, offering insights, tips, and best practices.


Who this course is for:

  • This course is designed for them who is looking career in Analyst, BI Developer, MIS Reporting using Excel and Power BI