Business Data Analysis with Microsoft Excel and Power BI

4.1 (1935)
Обучение платное
12.5 часов курса
Курс от Udemy
Чему вы научились?
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
О курсе

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.

You will be able understand the course structure and know the trainer.
Introducing the trainer and the course

This first lecture is an introduction to the course and also introduces me, the trainer.

Data Manipulation in Excel and setting the foundation.
How Excel handles different data types
Excel recognizes only four data types. Anything you type into Excel will fall under one of these data types. In this lecture we will set some of the foundation knowledge you will need to work productively in Excel.
Data consistency, starting with the end in view
This builds up on the knowledge established in Lecture 2. Excel is different from the other software in the Microsoft Office suite and has its own special set of guidelines to make the most of it. We will be going into those general rules you need to master to be very proficient in the use of Excel for business purposes.
Building Datasheets that can scale
Almost everything you enter in Excel reports, raw data are in table format. However there are some special types that I refer to as datatable. In this lecture I will explain what they are and why they need to be handled differently.

I will introduce you to sorting in Excel. Talk about the recommended way to sort. Do examples that cover the usual top to bottom sorting, then the left to right sorting, and cascaded sorting.


I will show via a relevant example how to do filtering and the benefits.

Data Cleaning part 1
I will cover removing duplicates, text-to-column, subtotal and data validation.
Data Cleaning part 2
Data Formatting
I'll show you how to use the "Format as Table" tool. Also how to set up your Excel sheet for printing. And finally how to put some of your analysis/report directly in the body of an email.
  • The training is constantly being updated with new interesting content. The goal is to have the most comprehensive and up-to-date business data analysis with Excel and Power BI course.
  • The training requires having Excel 2010 and above. Excel 2007 will also work but you won't be able to practice the PowerPivot example. You will also need Power BI Desktop installed, it is free from Microsoft.
  • You also must be ready to practice every topic covered as there are companion practice along files for every topic.
Michael Olafusi
Michael Olafusi
6x Microsoft MVP, Financial Modeler & BI Professional
Курсы Udemy подойдут для профессионального развития. Платформа устроена таким образом, что эксперты сами запускают курсы. Все материалы передаются в пожизненный доступ. На этой платформе можно найти курс, без преувеличений, на любую тему – начиная от тьюториала по какой-то камере и заканчивая теоретическим курсом по управлению финансовыми рисками. Язык и формат обучения устанавливается преподавателем, поэтому стоит внимательно изучить информацию о курсе перед покупкой.
Комментарии (1935)
Как и любой другой веб-сайт, konevy использует файлы cookie. Эти файлы используются для хранения информации, включая предпочтения посетителей и страницы веб-сайта, которые он/она посещал. Информация используется для того, чтобы подстроить содержимое нашей страницы под тип браузера пользователя и другие параметры и таким образом улучшить его пользовательский опыт. Для получения более подробной информации о файлах cookie, пожалуйста, прочтите статью «Что такое файлы cookie»