Learn all the functionalities, shortcuts, formulas, interfaces and interactions between objects to generate dashboards
What you'll learn

Create their own Excel Dashboards

Create Excel reports with charts and formulas

Create automated reports in Excel

Created automated reports and applications with Excel functions and VBA

Requirements

Basic knowledge of Windows or OSX for MAC

Basic knowledge of Microsoft Excel

Description

In details:

how to connect form commands or ActiveX to values in cells and ranges

how to generate automated charts which will be updated just modifying a single value in one or a few cells

how to create dynamic images, which will be updated by chag some values in cells

how to use Excel functions and formulas to create tables and data sources and summary reports

how to use combined lookup and reference formulas to retrieve joined values between different tables

how to create variable charts with data series generated dynamically

The course is conducted through examples.

These examples covers Excel dashboards in the most popular business areas, in details:

Dashboard testing activities

Interactive Dashboard in Excel using Hyperlinks

Interactive Sales Chart

several KPI dashboards

Make Dynamic Dashboards using Pivot Tables & Slicers

Customer Service Dashboard

Project Management Dashboard / Project Status Report

Financial Dashboard

During the course and especially at the end some example will be done implementing Visual Basic for Applications (VBA). The programming language to create macros and functions to expand the functionalites of Excel.

Who this course is for:

High school or university students

Financial controller

Project Managers

Sales managers or employees

Business analysts

Project controllers

Risk analysts

Bank clarks




DOWNLOAD
uploadgig.com


rapidgator.net


nitro.download