HOT
blank

Business Data Analysis with Microsoft Excel and Power BI

Office Productivity

Rating4.6
Enroll Now

Business Data Analysis with Microsoft Excel and Power BI, available at $79.99, has an average rating of 4.62, with 64 lectures, based on 2248 reviews, and has 20731 subscribers.

You will learn about Constantly being updated with new content and covering more areas of business data analysis. Be more productive and creative in their use of Microsoft Excel and Power BI for business and reporting Become proficient in using PivotTables for analyzing a large data Become proficient in the use of VLOOKUP, HLOOK, LOOKUP to get last item, INDEX and MATCH to make automated dynamic dashboarts/reports. Learn how to use Sorting in more advanced ways: multi-level sorting, sorting left to right. Learn how to create professional and great looking charts in Excel and understand when to use a particular chart type. Learn creative uses of Excel and a lot of keyboard shortcuts that saves analysis time Be introduced to Excel VBA, shown how to create a macro by clicking a particular button twice. Make a sample Excel VBA userform that gets data from user and input into a table in Excel Learn Power BI and other new interesting business data analysis tools by Microsoft This course is ideal for individuals who are This course is designed mainly for business professionals who use Excel a lot at work. It is built entirely out of my experience teaching over 500 business professionals over the course of two years on Excel, business data analysis and VBA. It focuses on giving you business productivity improving Excel skill and tips using practice files I built to mirror Excel consulting jobs I have done for companies. The course is best suited for people who currently used Excel at work and will benefit from improved Excel skills for reporting, presentation and analysis. or However, if you seldom use Excel and just want a certificate in Excel for CV purpose, you will find it hard to put in the commitment required to finish this training. You should consider the Microsoft MOS training as it is more ideal for CV building. or This course is also not for people who want to learn business data analysis but not with Excel and/or Power BI. The entire course is Excel and Power BI based. It is particularly useful for This course is designed mainly for business professionals who use Excel a lot at work. It is built entirely out of my experience teaching over 500 business professionals over the course of two years on Excel, business data analysis and VBA. It focuses on giving you business productivity improving Excel skill and tips using practice files I built to mirror Excel consulting jobs I have done for companies. The course is best suited for people who currently used Excel at work and will benefit from improved Excel skills for reporting, presentation and analysis. or However, if you seldom use Excel and just want a certificate in Excel for CV purpose, you will find it hard to put in the commitment required to finish this training. You should consider the Microsoft MOS training as it is more ideal for CV building. or This course is also not for people who want to learn business data analysis but not with Excel and/or Power BI. The entire course is Excel and Power BI based.

Enroll now: Business Data Analysis with Microsoft Excel and Power BI

Summary

Title: Business Data Analysis with Microsoft Excel and Power BI

Price: $79.99

Average Rating: 4.62

Number of Lectures: 64

Number of Published Lectures: 64

Number of Curriculum Items: 64

Number of Published Curriculum Objects: 64

Original Price: $49.99

Quality Status: approved

Status: Live

What You Will Learn

  • Constantly being updated with new content and covering more areas of business data analysis.
  • Be more productive and creative in their use of Microsoft Excel and Power BI for business and reporting
  • Become proficient in using PivotTables for analyzing a large data
  • Become proficient in the use of VLOOKUP, HLOOK, LOOKUP to get last item, INDEX and MATCH to make automated dynamic dashboarts/reports.
  • Learn how to use Sorting in more advanced ways: multi-level sorting, sorting left to right.
  • Learn how to create professional and great looking charts in Excel and understand when to use a particular chart type.
  • Learn creative uses of Excel and a lot of keyboard shortcuts that saves analysis time
  • Be introduced to Excel VBA, shown how to create a macro by clicking a particular button twice.
  • Make a sample Excel VBA userform that gets data from user and input into a table in Excel
  • Learn Power BI and other new interesting business data analysis tools by Microsoft

Who Should Attend

  • This course is designed mainly for business professionals who use Excel a lot at work. It is built entirely out of my experience teaching over 500 business professionals over the course of two years on Excel, business data analysis and VBA. It focuses on giving you business productivity improving Excel skill and tips using practice files I built to mirror Excel consulting jobs I have done for companies. The course is best suited for people who currently used Excel at work and will benefit from improved Excel skills for reporting, presentation and analysis.
  • However, if you seldom use Excel and just want a certificate in Excel for CV purpose, you will find it hard to put in the commitment required to finish this training. You should consider the Microsoft MOS training as it is more ideal for CV building.
  • This course is also not for people who want to learn business data analysis but not with Excel and/or Power BI. The entire course is Excel and Power BI based.

Target Audiences

  • This course is designed mainly for business professionals who use Excel a lot at work. It is built entirely out of my experience teaching over 500 business professionals over the course of two years on Excel, business data analysis and VBA. It focuses on giving you business productivity improving Excel skill and tips using practice files I built to mirror Excel consulting jobs I have done for companies. The course is best suited for people who currently used Excel at work and will benefit from improved Excel skills for reporting, presentation and analysis.
  • However, if you seldom use Excel and just want a certificate in Excel for CV purpose, you will find it hard to put in the commitment required to finish this training. You should consider the Microsoft MOS training as it is more ideal for CV building.
  • This course is also not for people who want to learn business data analysis but not with Excel and/or Power BI. The entire course is Excel and Power BI based.

**** Important Notice *********************************

We do regular live support sessions to give a more enriching experience and help you align what you are learning with career growth. Enroll now to get this benefit for life!

*************************************************************

Microsoft Excel is the world’s most used and versatile business analysis, reporting and strategy software. Having a deep practical knowledge of Excel will turn you almost superhuman at work and increase your productivity. You will be seen as a very efficient, highly competent and indispensable partner in the organization’s progress. And, hopefully, it will lead to a much greater career role and opportunity for you.

Power BI is Microsoft’s business intelligence and dashboarding tool that enables organizations to have a wholesome understanding of what is happening at all operational levels of the company. With it you can create reports with drill down features, access-level restrictions, auto-refresh, alerts/triggers and interactivity.

This training is going to focus on making you highly proficient in the use of Excel and Power BI for business data analysis, dashboard creation and reporting the professional way. And most of this would be achieved through lots of samples that will be similar to what you’ll need at work.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introducing the trainer and the course

Lecture 2: Important Information on Extensive Support and Live Virtual Sessions

Chapter 2: Data Manipulation in Excel and setting the foundation.

Lecture 1: How Excel handles different data types

Lecture 2: Data consistency, starting with the end in view

Lecture 3: Building Datasheets that can scale

Lecture 4: Sorting

Lecture 5: Filtering

Lecture 6: Data Cleaning part 1

Lecture 7: Data Cleaning part 2

Lecture 8: Data Formatting

Chapter 3: Charts

Lecture 1: Charts part 1

Lecture 2: Charts part 2

Chapter 4: Creative Excel Use and Tips

Lecture 1: Creative Excel Features part 1

Lecture 2: Creative Excel Features part 2

Lecture 3: Specials — Creative Excel Use part 1

Lecture 4: Specials — Creative Excel Use part 2

Lecture 5: Special Video — Excel Keyboard Shortcuts part 1

Lecture 6: Special Video — Excel Keyboard Shortcuts part 2

Chapter 5: Business Data Analysis

Lecture 1: Pivot Table, Pivot Chart and PowerPivot

Lecture 2: Mail Merge

Lecture 3: Business Data Analysis, part 1

Lecture 4: Business Data Analysis, part 2

Lecture 5: Business Data Analysis, part 3

Lecture 6: Business Data Analysis, part 4

Lecture 7: Forecasting using Excel 2016 Forecast tool

Lecture 8: Data Visualization – part 1

Lecture 9: Data Visualization – part 2

Lecture 10: Excel Reports And Presentation

Lecture 11: NamedRange, Goal Seek, Scenario Manager – part 1

Lecture 12: NamedRange, Goal Seek, Scenario Manager – part 2

Lecture 13: Protecting_Workbook_Worksheet_Printing

Lecture 14: Excel Web Query

Lecture 15: Power Excel Functions – part 1

Lecture 16: Power Excel Functions – part 2

Lecture 17: Power Excel Functions – part 3

Lecture 18: Power Excel Function – SUMPRODUCT

Lecture 19: New Excel Function – XLOOKUP

Lecture 20: New Excel Function – UNIQUE

Lecture 21: New Excel Function – SORT

Chapter 6: Live Session on Advanced Filtering, Custom List, Data Validation, Charts…

Lecture 1: Live Session – Part 1 Covering Advanced Filtering in-depth

Lecture 2: Live Session – Part 2 Covering Custom Lists and Data Validation

Lecture 3: Live Session – Part 3 Covering Dynamic Charts

Lecture 4: Live Session – Part 4 Covering Conditional Formating and New Excel Formulas

Lecture 5: Live Session – Part 5 Covering New Excel Charts and Intro to Infographics

Lecture 6: Live Session – Part 6 Covering Questions and Answers

Lecture 7: PowerQuery for automating report data update

Chapter 7: Power BI

Lecture 1: Power BI part 1

Lecture 2: Power BI part 2

Lecture 3: Power BI part 3

Lecture 4: DAX Tutorial #1: CROSSJOIN

Lecture 5: DAX #2: Meet the most popular DAX formula — CALCULATE

Lecture 6: DAX #3: VALUES, another must know DAX formula

Lecture 7: DAX #4: CALENDAR, every sales/operations analyst friend

Lecture 8: DAX #5: SUMMARIZE

Chapter 8: Excel VBA

Lecture 1: Excel Macros

Lecture 2: Userform and more Macros – part 1

Lecture 3: Userform and more Macros – part 2

Chapter 9: Difference Between Data Analysis, Business Analysis, BI and Big Data

Lecture 1: Data Analysis vs Business Analysis vs Business Intelligence vs Big Data part_1

Lecture 2: Data Analysis vs Business Analysis vs Business Intelligence vs Big Data part_2

Lecture 3: Data Analysis vs Business Analysis vs Business Intelligence vs Big Data part_3

Lecture 4: Data Analysis vs Business Analysis vs Business Intelligence vs Big Data part_4

Chapter 10: Demonstration of Pivot Table vs Power Pivot vs Power BI

Lecture 1: Pivot Table vs Power Pivot vs Power BI part 1

Lecture 2: Pivot Table vs Power Pivot vs Power BI part 2

Lecture 3: Pivot Table vs Power Pivot vs Power BI part 3

Instructors

Rating Distribution

  • 1 stars: 62 votes
  • 2 stars: 75 votes
  • 3 stars: 358 votes
  • 4 stars: 773 votes
  • 5 stars: 980 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Top 10 Chatgpt And Ai Tools Courses to Learn in November 2024

Top 10 Excel Vba Courses to Learn in November 2024

CreateStudio 2D Animation and 2D Animation Marketing Videos