Presenting Data With Excel


Course Code:

Presenting Data With Excel

Duration:
1 day
9.00am to 5.00pm
Location:
80 Jurong East Street 21 #04-04
Devan Nair Institute
Singapore 609607
Course Fees:
S$199 (excl of G.S.T)
2018 Course Dates
Dates available on request
None of the published dates will work for you? Speak to our training consultants for a private tuition arrangement or a closed door training.Candidates will be assessed through Theory test, Practical test and reviews.

Course Outline

Module 1: Complete Charting

• Basic how to’s and best practices for faster and more accurate chart creation

• Various chart type and their applications

• Showing percentages/gain loss

• Showing multiple year performances

• Customizing charts

• Using Pictographs (Picture based charts)

• Adding trendlines

• Formatting templates with charts

• Inserting charting in cells using Sparklines

• Dynamic charts

Module 2: Gathering, Analysing and Presenting Data

• Format data in Excel tables

• Applying Conditional Formatting and managing Rules

• Pivot Tables – fast application of sorting, grouping and totalling

• Presenting analysis with Pivot Charts

• Dynamic filtering with Slicers

Module 3: Telling the Data Story

• Case Study of various sample reports

Take the Next Step

It Takes Less Than 5 Min