Udemy

MBA in Excel- Master Business Analytics in Excel

Enroll Now
  • 716 Students
  • Updated 8/2024
4.4
(139 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
19 Hour(s) 9 Minute(s)
Language
English
Taught by
MyExcelAcademy .
Rating
4.4
(139 Ratings)

Course Overview

MBA in Excel- Master Business Analytics in Excel

Master Excel with Formulas, Functions, Excel Dashboards, Pivot tables, Power Query, Macros & VBA and Power BI

Course reviews:


"Best course of MS excel. covered everything"

Abhishek Batham


" This course really worth more than others."

Sandeep K.H - India


" Thank you for this amazing course and for all the Information you shared in this course. For me your course is in top 10 excel courses here on Udemy and believe me I have seen a lot. Your course have everything. If you will do in the future others courses I will buy then instantly. "

Copaci Florin-Romania


"Thank you so much for the course. I am loving it. You present challenge after challenge in each exercise, and its been fun following, along as well as figuring out multiple ways to answer your questions. I hope you make more courses. You are a good teacher."

N.Sanchez - USA


"I am lucky I took this course. Amazing"

Ijlal hasnain - Pakistan


"I must confess, course really helped me in doing my work. I highly recommend the course to the who like to learn and master in data analysis. Funny thing, I did this course while based in Switzerland. Most importantly, I was able to reach out with my customized questions to the course Instructor and he was always reachable and supportive to answer my queries."

Rizwan Safdar - Switzerland


All in One Excel Course - Enhance your Excel experience with MBA in Excel. Start with formulas, move onto Pivot tables, macro and VBA, manipulate data and consolidate with Power Query and visualize with Power BI. All in One course, from basics to Advanced level.  Recommended for any Excel user to level up their skills and insights of different tools provided. Excel is a must anywhere you go in the world. Uplift your Excel confidence and step out an Excel hero. With more than 18 hours of content, I hope you will be able to learn many new tips and at the end of the course be able to quickly analyze and debug formulas with ease. From data analysis, to visualization, the course walks you through the steps required to become a superior data analyst. All you need is basic Excel skills and a passion to put in hard work to master key concepts.

More videos to be added on student feedback and request.

Formulas covered are Xlookup, Vlookup, Counta, Index & Match, Sumif, Sumifs, Countif, Countifs, Array nested formulas, Filter, Xmatch, Sumproduct, Text functions, Date functions, VBA coding, DAX functions, Pivot tables, Named Ranges, Offset, Conditional Formatting, Dashboard creation, Animation in Excel, Getpivotdata, Slicers, Indirect function, Textjoin, IFS, Maxifs, Sort, Sortby, Unique, Switch, Let, Sequence, much more and  Super Excel shortcuts.

Course is updated with Microsoft 365 version.

Course Content

  • 10 section(s)
  • 132 lecture(s)
  • Section 1 Lets begin by understanding our dataset
  • Section 2 Introduction
  • Section 3 Analyzing Data in Excel
  • Section 4 Pivot Tables
  • Section 5 Using and debugging Advanced Formulas
  • Section 6 Lookup data in Excel - various ways
  • Section 7 Performing Business Calculations
  • Section 8 Excel Dashboards
  • Section 9 Unleash the power of Macros
  • Section 10 Designing a Dashboard

What You’ll Learn

  • The course builds slowly with intermediate concepts to Advanced level Excel skills, using formulas, pivot tables and VBA
  • You will learn data analysis using nested formulas, pivot tables, VBA magic to animate Charts, Power Query and Power BI
  • Course is designed in Excel 2019 and also covers new formulas of Microsoft Office 365
  • Recommended for any Excel enthusiast to master key Excel concepts
  • After completing the course, you will have the confidence and knowledge towards becoming an Excel Expert
  • I will be updating the course on new materials and videos as and when needed on student feedback


Reviews

  • S
    Sudheendra Kulkarni
    4.0

    I have learned lot of things in excel and power BI. It helped me learning from basics to advance level.

  • B
    Benjamin Kesenyang
    5.0

    nice

  • V
    Vincent Omolani
    1.0

    The poor content, its blurred.

  • V
    Vinay kumar
    2.5

    Unclear instructions.

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed