Power BI Desktop on 23 February 2021
Introduction To Dashboard Reporting
Course Description
Dashboard simplifies complex data and provides an at-a-glance view of current status or performance in real time. Dashboards are made up of tables, charts, gauges, and numbers. They can be used in any industry, for almost any purpose. This course enables user to create appropriate, informative, simple and easy to understand visual Dashboards.
Prerequisites
Participants should have basic knowledge in Microsoft Excel.
Conditional Formatting with Microsoft Excel
Course Description
Conditional Formatting (CF) is very good if you want to be informed in real time, answer questions visually,
Enhance data presentations, analyze data: find exceptions, find relationships, find trends, etc. In this course you will be exposed to all different usage of CF.
Prerequisites
Participants should have experience working with Microsoft Excel.
Excel 365 New Functions on 30 January 2021
Course Description
New functions in Excel 2019 and 365 are awesome. They reduce the human effort and complexity of the formulas, cutting the need of array formulas. They not only making life easy and reduces the size of the file, learning and using them are definitely much easier compared to the legacy versions.
Prerequisites
Experience in using basic Excel.