Microsoft Excel Reporting, Analyze & Manipulate Data

Learn to extract Information from Database & Gather Information into Logical Framework etc

Microsoft Excel Reporting and Data Analysis

Trainer

Target Audience: Anyone who needs to use Excel to prepare reports, analyze
data, and present it in a meaningful manner

Pre-requisite: Prior knowledge of formatting data within cells; applying
simple functions like SUM, AVERAGE, etc.; and able to
create basic charts

Course Synopsis: The course will focus on the capability of Excel to handle
large amounts of data that can be analyzed, manipulated and
presented into professional looking reports

Course Objective: To equip participants with sufficient knowledge in applying
the various built-in functions and features to extract the right
type of information from databases and present it in a
meaningful format like reports and charts. Participants will
also learn to understand various types of data and make it
work for them. Learn how to gather information into logical
framework and present it into a table of reports and graphs.

Reporting, Data Analysis

Training / Course Outline:

1. FORMATTING OF DATA

Converting basic data to various formats
Adding leading zeroes to numbers
Combining text to numbers
Using the Format Painter to highlight specific text
Other tips and shortcut techniques when formatting data

2. WORKING WITH DATA

Understanding Relative and Absolute Cell Referencing
Highlighting specific data based on conditions given
Validating a range of data based on condition set
Visualizing data using customized Data Bars, Color Scales, and Icons
Highlighting cells by applying formulas within Conditional Formatting
Highlighting alternating rows and columns of data in reports
Other tips on working with data

3. ANALYZING & REPORTING DATA USING FEATURES OF EXCEL

Using the Filter and Advanced Filter options
Performing calculations using Filter
Highlighting and removing duplicate data
Applying Subtotal for calculations of grouped data
Consolidating data from multiple worksheets to a single worksheet

4. DECISION MAKING FROM DATA USING FUNCTIONS

Performing comparative analysis using Logical functions
Summing a data range based on various conditions
Constructing formulas using Named Ranges
Looking up specific values from within a table
Applying Informational functions to check on validity of data

5. PERFORMING VARIOUS WHAT-IF ANALYSIS FOR REPORTING PURPOSES

Using the Goal Seek functions for different scenarios
Applying different scenarios for best, worst, and most likely situations with the
Scenario Manager
Sensitivity analysis using one and two input Data Table

6. ANALYZING DATA FROM DATABASES

Importance of a database
Benefits of applying Database functions
Applying criterias to extract specific groups of information from database
How Database functions can be used within large sets of data

7. PRESENTING & REPORTING OF DATA USING CHARTS

When to use what type of charts
Using Combination Charts
Exploring Other Charts
Creating a Gantt Chart
Changing to a Custom Layout
Generating a Histogram

Share
Share