Business Data Analysis with Microsoft Excel and Power BI
3.0 /5- Offered byUDEMY
Business Data Analysis with Microsoft Excel and Power BI at UDEMY Overview
Duration | 13 hours |
Total fee | ₹2,299 |
Mode of learning | Online |
Credential | Certificate |
Business Data Analysis with Microsoft Excel and Power BI at UDEMY Highlights
- Earn a certificate of completion from Udemy
- Learn from 37 downloadable resources & 1 article
- Get full lifetime access of the course material
- Comes with 30 days money back guarantee
Business Data Analysis with Microsoft Excel and Power BI at UDEMY Course details
- For business professionals who use Excel a lot at work
- For people who want to learn business data analysis but not with Excel and/or Power BI
- 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
- Microsoft Excel is the world's most used and versatile business analysis, reporting and strategy software
- You will be seen as a very efficient, highly competent and indispensable partner in the organization's progress
- 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
- 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
Business Data Analysis with Microsoft Excel and Power BI at UDEMY Curriculum
Introduction
Important Information on Extensive Support and Live Virtual Sessions
Data Manipulation in excel setting environment
How Excel handles different data types
Data Cleaning part 1
Data Cleaning part 2
Data Formatting
Charts
Charts part 1
Charts part 2
Creative Excel Use & Tips
Creative Excel Features part 1
Specials -- Creative Excel Use part 1
Specials -- Creative Excel Use part 2
Special Video -- Excel Keyboard Shortcuts part 1
Special Video -- Excel Keyboard Shortcuts part 2
Business Data Analysis
Business Data Analysis, part 1
Business Data Analysis, part 2
Business Data Analysis, part 3
Business Data Analysis, part 4
Forecasting using Excel 2016 Forecast tool
Data Visualization - part 1
Data Visualization - part 2
Excel Reports And Presentation
Live session advanced filtering, custom list, data validation, charts....
Live session- Part 1 Covering advanced filtering in depth
Live Session - Part 2 Covering Custom Lists and Data Validation
Live Session - Part 3 Covering Dynamic Charts
Live Session - Part 4 Covering Conditional Formating and New Excel Formulas
Live Session - Part 5 Covering New Excel Charts and Intro to Infographics
Live Session - Part 6 Covering Questions and Answers
PowerQuery for automating report data update
Business Data Analysis with Microsoft Excel and Power BI at UDEMY Faculty details
Other courses offered by UDEMY
Business Data Analysis with Microsoft Excel and Power BI at UDEMY Students Ratings & Reviews
1 Rating- 2-31
Student Forum
Anything you would want to ask experts?