Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Learn Microsoft Excel and Create Interactive Dashboards

Learn everything you need in Excel.Download 30 Useful Excel Dashboard Templates.Excel 2019,Excel 2020,Office 365.
4.3
4.3/5
(177 reviews)
7,382 students
Created by

8.9

CourseMarks Score®

8.5

Freshness

7.7

Feedback

9.8

Content

Platform: Udemy
Video: 46h 10m
Language: English
Next start: On Demand

Table of contents

Description

Note: Select “auto” to watch 1080p HD quality videos.
This course covers training for two Microsoft apps.Microsoft Excel and Microsoft Power BI.These two apps are very useful in the  office and business world.
                                                                                                      Microsoft Excel/Office 365
Learn pivottables ,pivotcharts,power query,power pivot,power map,what-if-analysis tools,solver and others topics.Learn how to add charts in Microsoft Excel sheet.Learn how to use formulas and functions in Microsoft Excel.Learn how to create dashboards in Excel.To see more topics of this course,view course contents in the course landing page.
Note:-Extra downloadable Dashboard Templates are included with this course in the resource.
21.Covid 19 (1).xlsx
20.Covid 19.xlsx
19.Monthly Budget Dashboard Template.xlsx
18.University Monthly Budget Dashboard Template.xlsx
17.Monthly Personal Budget Dashboard Template.xlsx
16.Multiple Dependent drop down list Sales Dashboard.xlsx
15.Dependent drop down list Sales Dashboard.xlsx
14.Sales KPI Dashboard Template 2.xlsx
13.Download Searchable Drop Down List COVID – 19 Microsoft Excel Dashboard Live Update 26/05/2020.xlsx
12.Searchable drop down list Excel Dashboard Template with lookup picture.xlsx
11.Extra Project 2 – Sales Commission Calculator Template.xlsx
10.Extra Project 0 – Searchable Drop Down List Sales Dashboard Template.xlsx
9.KPI Sales Dashboard Template.xlsx
8.Business Finance Management Dashboard Template.xlsx
7.Extra Project 0 – COVID – 19 Data Analytics in Excel Dashboard Template 1 – Live Update.xlsx
6.Download Sales KPI Dashboard Template1.xlsx
5.Download Customer Analytics Dashboard Template.xlsx
4.Extra Project 5 – Real Estate Management Dashboard Template.xlsx
3.Download Sales Team Dashboard Template.xlsx
2.Extra Project 6 – Fully Automated Inventory Management Dashboard Template.xlsx
1.Extra Project 0 – COVID – 19 Data Analytics in Excel Dashboard Template 2 – Live Update.xlsx
                                       ______________________________________________________________________________________________________
                                                                                                      Microsoft Power BI/Office 365
Learn How to Analyze Data in Microsoft Business Intelligence Power BI.How to Reports and Dashboards are Created in Power BI.
In this course,you will learn,how to analyze business data in Microsoft business intelligence power bi.You will learn how to extract data from the website and an other sources and how that data is transformed in power query editor and power bi.You will learn how to that data is visualized in power bi.You will learn how to create reports and dashboards in power bi and how to add buttons in report page.You will learn how to custom visuals are added and data is visualized from that visuals.And much more!

You will learn

✓ Learn all basic concepts of excel
✓ Learn most commonly used formulas in the office
✓ Learn PivotTables and PivotCharts
✓ Learn Power Query
✓ Learn Power Pivot
✓ Learn Power Map
✓ Learn What-if-analysis Tools
✓ Learn Forecasting Sheet
✓ Learn Excel Formulas and Functions
✓ Create Excel Dashboards
✓ And Much More!
✓ Create reports in power bi
✓ Create dashboards in power bi
✓ Visualize data in power bi
✓ Edit data in power bi and power query editor
✓ Add buttons in report page
✓ Visualize data in power bi by adding custom visuals

Requirements

• This course is recorded on office 365 but this will work on excel 2019.

This course is for

• If someone want to learn excel from basic to Advance,this course covers basic and advance levels topics.
• If someone want to learn business intelligence for data analysis and for creating dashboards and reports,learn Microsoft power BI from basic to advance levels.
MSc Data Science
I am passionate about learning Dash. Dash is a python framework that creates beautiful web based data visualization dashboards. We can deploy dash apps on servers and then share them through links. Dash apps are mobile friendly and can be viewed on mobile devices as well as all other devices.
Browse all courses by on Coursemarks.
Platform: Udemy
Video: 46h 10m
Language: English
Next start: On Demand

Students are also interested in