Overview

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 365Learn 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).xlsx20.Covid 19.xlsx19.Monthly Budget Dashboard Template.xlsx18.University Monthly Budget Dashboard Template.xlsx17.Monthly Personal Budget Dashboard Template.xlsx16.Multiple Dependent drop down list Sales Dashboard.xlsx15.Dependent drop down list Sales Dashboard.xlsx14.Sales KPI Dashboard Template 2.xlsx13.Download Searchable Drop Down List COVID - 19 Microsoft Excel Dashboard Live Update 26/05/2020.xlsx12.Searchable drop down list Excel Dashboard Template with lookup picture.xlsx11.Extra Project 2 - Sales Commission Calculator Template.xlsx10.Extra Project 0 - Searchable Drop Down List Sales Dashboard Template.xlsx9.KPI Sales Dashboard Template.xlsx8.Business Finance Management Dashboard Template.xlsx7.Extra Project 0 - COVID - 19 Data Analytics in Excel Dashboard Template 1 - Live Update.xlsx6.Download Sales KPI Dashboard Template1.xlsx5.Download Customer Analytics Dashboard Template.xlsx4.Extra Project 5 - Real Estate Management Dashboard Template.xlsx3.Download Sales Team Dashboard Template.xlsx2.Extra Project 6 - Fully Automated Inventory Management Dashboard Template.xlsx1.Extra Project 0 - COVID - 19 Data Analytics in Excel Dashboard Template 2 - Live Update.xlsx ______________________________________________________________________________________________________ Microsoft Power BI/Office 365Learn 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!

Skills

Reviews