Presenting Data With Excel
Course Code: |
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) |
2019 & 2020 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