Description

Data analysis is defined as a cleaning, transformation, and modeling process for the identification of useful information in decision making in business. Data analysis attempts to collect valuable data and make a choice based on the analysis of the data.

Learning Outcome and Goals

• Describe Excel Data thoroughly
• Prevent common mistake in Microsoft Excel Reporting
• Conduct Analysis using Historical Data.
• Able to provide fast statistical report.
• Better manage a Database and search of information quickly
• Complete an Analysis Report in a Shorter time
• Make informed Decision using the right Analysis Tools.

Course Requirement

• Participants should be able to use a PC at the beginner level.
• Basic knowledge and functionality of Microsoft Excel
• Microsoft Office 2013 and above

Training Methodology

• Instructor Led | Group Coaching.
• Debrief and Reflection | Discussion.

Course Information

Course Outline

Exploring Excel Data in Microsoft Excel

• What is Excel Data?
• Excel Data Type
• Advanced Number Formatting
• Excel Referencing | Name Range.

Report Checking Features

• Conditional Formatting
• Target vs Actual
• Sales Trend
• Data Validation
• Circle non-Compliance
• Data Entry Accuracy

Data Management

• Understanding Database Concept
• Data Range vs Table
• Cleaning up messy Data
• Sorting & Filtering Database
• Database Functions

Analyzing Data Using PivotTable

• Basic PivotTable Interface
• PivotTable Layout
• Value Field Setting
• Grouping and Filtering
• Calculated Fields

Analyze Data using Charts.

• Column Chart | Dual Axis Chart
• Pie and Pie of Pie Chart
• Thermometer Chart
• Speedometer Chart

Analyze Data using What-If-Analysis

• Understanding What-If-Analysis
• Applying Goal Seek to achieve Target.
• Using Data Table to Test the Variables
• Save all data set using Scenario.