Have any question? +2348023037488, +2348062446972

Microsoft Excel & Dashboard Reporting

Microsoft Excel has become extremely power tool for any data analyst. Whether you work in Sales, Marketing, Customer Service, Logistics, Accounts, Manufacturing, Finance or Administration, everyone must become an expert at using Microsoft Excel.

It is not sufficient to know Tables & Formulas in Excel. You must also know how to make sense of the data that you have.

Program Outline

Understanding Dashboards

Principles of Great Dashboard Design

Using Advanced Formulas & Functions in Excel

Referencing & Ranges

Advanced Lookup

Advanced Formatting

Advanced Pivot Table Techniques

Percentage

Computed Columns

Grouping & Sorting

Top Views

Multiple data sources

Pivot Charts & VIsual Dashboarding Techniques

Excel-Dashboard to Compare Sales - Training Example

Advanced Power Charting Techniques

Dashboard Macros

Creating Dynamic Dashboards with Excel

Creating a Sales Dashboard

Target Audience

Sales, Marketing, Finance, IT Executives, Engineers, Project Managers, Directors, CXOs, Managing Directors, General Managers, and Data Analysts who dabble with data and want to learn advanced techniques to convert Data into actionable Information.

Cost: N 80 000

Register
Copyright © 2023 Jireh Computer Solution Ent. All right reserved.
Powered by:

Style Switcher

Select Layout
Chose Color
Chose Pattren
Chose Background