DASHBOARD – Data Analysis – Reporting Training with Excel

DASHBOARD - Data Analysis - Reporting Training with Excel

Get Information

Dashboards are one of the most effective, efficient and widely used reporting tools used in business life.

One of the important advantages of Dashboard Reports is that users can see and adjust many parameters from a single screen.

Dashboard Reporting, Creating Formulas, Designing Charts, Filtering Techniques, Data Transfer and Data Analysis, etc. With its unique content prepared for those who are curious about more; and for those who can use Excel at a good level, you will be able to get very comprehensive information in this course, where you will learn which steps our datasets need to go through in order to create a Dashboard report, as well as how the data can be analyzed.

About Education

Education Objectives

  • To make Dashboard Design,
  • Learn methods and techniques for sharing reports with other users,
  • To use graphic types and types effectively,
  • Understand which graph should be used for which data set,
  • To be able to clean corrupted data in a dataset,
  • To be able to perform Data Extraction Operations from other tables,
  • Understand Special and Advanced Filtering Methods and Techniques,
  • To make statistical analyzes using formulas,
  • Create summary reports with pivot tables,
  • To be able to tabulate data sets in CSV format.

 

Education Content

MODULE 1 – DATA CLEANING

Data in CSV Format

Delete Empty Rows

Editing Corrupted Data

Merge Data

Parsing Data

MODULE 2 – TABLE CONCATENATION

Data Extraction

Column Substitution and Basic Calculation

Conditional Calculations

MODULE 3 – FILTERS

Basic Filtering

Basic Filtering Example

Custom Filtering (Number-Date-Text)

Advanced Filtering-Introduction

Advanced Filtering-Joker

Advanced Filtering-VE

Advanced Filtering – OR

Advanced Filtering-Comprehensive Sample

Advanced Filtering-Copy to Another Location

MODULE 4 – STATISTICAL ANALYSIS

Status Bar Analytics

General Analysis with Formulas

Single Conditional Analysis with Formulas

Multiconditional Analysis with Formulas

MODULE 5 – PIVOT TABLES

Order Status Pivot

Customer Profile Pivot

Product Based Monthly Order Pivot

Carrier Details Pivot

City Based Monthly Average Amount Pivot

Single View Pivots

MODULE 6 – CHARTS & INDICATORS

Bar Chart

Ring Graphic

Line Graphics

Merged Graph

Stacked Column Chart

Linked Image

Display of Single Digits

MODULE 7 – DASHBOARD

Moving Charts and Indicators

Alignment – Positioning – Sizing

Design Touches

Slicers

Dashboard Usage

Adding and Removing Data

Changing Theme Colors

MODULE 8 – SHARING WITH OTHER USERS

Storing Pages

Encrypted Page Protection

Encrypted Workbook Protection

Who Should Receive the Training?

  • People who have knowledge about Dashboard or who design Dashboard and want to improve themselves,
  • People who want to make dynamic and automatically updating reports,
  • People who want to automate reporting,
  • People who do reporting and want to improve themselves in this field,
  • Data Analysts and Data Analyst Candidates,
  • Data Management and Reporting people,
  • People who want to make more accurate decisions by analyzing their data,
  • People who want to make graphs from data,
  • Those who want to benefit from the full capabilities of MS Excel,
  • Bankers
  • Accountants
  • Teachers,
  • Marketers
  • Salespeople,
  • Health Sector Workers,
  • All Other Occupational Groups,
  • Anyone who is involved in reporting and wants to take it to the next level.

Requirements

  • It is common for Excel versions to vary. What is really important in education is the understanding of the logic and process of the subject.
  • Must have advanced knowledge of Excel.

Plan this training institutionally!

This training can be planned in different durations and content specific to your organization. Please contact us for detailed rich content and planning to realize your training objectives.

Get in touch

Additional information

Lokasyon

Online

Kontenjan

20

Eğitmen

Academy Club