Data Visualisation using Microsoft Excel | Free Udemy Course
Learn Power Pivot, Pivot Tables, Pivot charts and more - Free Course | Free Udemy Course
new- 1.5 hours hours of on-demand video
The course - Microsoft Excel for Data Visualisation and Data Analysis- is designed to teach excel applications for business intelligence, data visualisation and data analysis to prospective business intelligence analysts, business analysts and those who want to learn how to conduct business intelligence analysis and data analysis in Excel. The course covers all the key business intelligence, data visualisation and data analysis tools that Excel has to offer. And these tools are taught using practical, hands on demonstrations using sample data in Excel. Students will not only learn advanced Excel business intelligence tools but also learn how to analyse and study trends in data. The course will equip students with skills in business intelligence and will teach students how to study, understand and interpret data using Excel. The course will also equip students with advanced data visualisation and data analysis tools. The following topics are covered in the course:1. Power Query2. Pivot tables and charts.3. Power pivot4. Excel Dashboards5. Forecasting6. What-if-analysis7. Solver8. Descriptive Statistics9. Correlation Analysis10. Regression AnalysisThe course has a project at the end of the course. In this project students will deal with data on an apple refurbished product seller, provided by the instructor, and will do the following analysis:1. Import data with Power Query and transfer the data. This step will involve assigning formatting data.2. Students will generate pivot charts.3. Students will create an Excel Dashboard using pivot charts.4. Students will submit the dashboards.Who this course is for:People interested in learning Excel for Business AnalysisPeople interested in learning Excel for Business IntelligencePeople interested in learning advanced Excel applicationsPeople interested in learning data analysis and visualisation using ExcelPeople interested in learning power pivots, power queries, and pivot charts and tables in ExcelPeople interested in embarking on a business intelligence and analyst career
Course Content:
Sections are minimized for better readability, click the section title to view the course content
JOIN OUR WHATSAPP GROUP TO GET LATEST COUPON AS SOON AS UPDATED
JOIN WHATSAPPJOIN OUR TELEGRAM CHANNEL TO GET LATEST COUPON
JOIN TELEGRAMJOIN OUR FACEBOOK GROUP TO GET LATEST COUPON
JOIN FACEBOOKFree Online Tools And Converters for your use
URL Encoder
Input a string of text or a URL and encode the entered string
Try itURL Decoder
Input an encoded string of text or a URL and decode the entered string
Try itColor Contrast Checker (WCAG)
Calculate the color contrast ration for your website (WCAG)
Try itXML Formatter
Paste or upload an XML and have it formatted to a beautiful XML format
Try itURL Slug Generator
Convert any title or sentence into a variety of slugs for your pages URL
Try itE-Signature
Draw an e-signature or type a signature for your online signature
Try it