Business Data Analysis with Microsoft Excel and Power BI
An in-depth training on Excel and Power BI for busy professionals who use Excel a lot at work.
4.19 (2304 reviews)
20,918
students
12.5 hours
content
Nov 2020
last update
$74.99
regular price
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
Screenshots
Related Topics
514734
udemy ID
5/29/2015
course created date
11/1/2019
course indexed date
Bot
course submited by