Mastering Data Presentation & Visualization

Mastering Data Presentation & Visualization

Category: Microsoft Excel Available
For more information, visit our official website at iconictraining.com.my

Description

Mastering Data Presentation & Visualization

Course Duration: 2 Days

Introduction

Microsoft PowerPoint - Mastering Data Presentation & Visualization helps to transform your company data into rich visuals that facilitate new ways of thinking about and organizing your data, so that you can focus on what is important to achieving your goals.

Prerequisites

Basic knowledge of Microsoft Excel is essential with the following pre-requisites:

Course Objectives

Upon completion of this module, participants should be able to:

Key Content

Module 1: Things You Should Know Before Getting into Reporting

Lesson 1.1: What to do when a big data bomb drops onto your hand?

Module 2: Building Your First Report with Pivot Table

Lesson 2.1: 3 steps in creating a report Lesson 2.2: Facelift the Report Lesson 2.3: Organizing and Sort Out Useful Info Lesson 2.4: Using Pivot Table Value Outside Pivot Table Lesson 2.5: Slicing and Dicing Data Using Slicer and Timeline

Module 3: Visualizing Reports Using Pivot Chart

Lesson 3.1: Displaying the Trends and Comparison of Data with Pivot Chart Lesson 3.2: Formatting Pivot Charts

Module 4: Ice-Breaking Session with PowerPoint

Lesson 4.1: What is Power Pivot? Lesson 4.2: Get Your Power Pivot

Module 5: Where Should You Begin with Power Pivot

Lesson 5.1: Importing Data into Data Model through Excel Lesson 5.2: Importing Data from Delimited File Lesson 5.3: Importing Data from Database File Lesson 5.4: Talk about the Relationship

Module 6: Adding Calculated Column Using Existing Information From Tables

Lesson 6.1: Inserting a calculated column Lesson 6.2: Using the DAX function Lesson 6.3: Define Hierarchy

Module 7: It's Time to Put Everything Together

Lesson 7.1: Create Reports by Connecting to External Data Sources Lesson 7.2: Visualize Report Lesson 7.3: Say No More to Reporting Routine

Target Audience

This course is designed for clerks, officers, executives, supervisors, administrators, and managers of all levels who want to further enhance their knowledge and practical uses of Microsoft Excel

More detail about Iconic Training Solutions Sdn Bhd
Iconic Training Solutions Sdn Bhd
Iconic Training Solutions Sdn Bhd Experiential Learning & Soft Skills Training Courses Malaysia, Best Software Provider Kuala Lumpur (KL), Leadership Enhancement Program Selangor ~ Iconic Training Solutions Sdn Bhd
Contact Us flagMalaysia