They say that a picture paints a thousand words and in Excel that means finding ways to represent numerical data pictorially so that your audience can quickly and easily understand it. It's often easier to look at a chart or graph to interpret trends in a set of data than looking at a set of figures and with so many options to choose from, where do you start?
09/28/2016 10:00 AM09/28/2016 04:00 PMTraining Topic: Data Visualization with ExcelInstructor: Mike Thomas
Objectives of the Presentation
Presenting data using traditional charts
Creating Sparkline (in-cell) charts
Using drawing tools and SmartArt to present numerical data
Creating infographic-style visualizations
Presenting data as a Heat Map to aid quick analysis
Displaying numerical data with colors
Why Should you Attend
Learning how to effectively present numerical data in an interesting, engaging and fun way is a must-have skill in today’s world. This webinar will give you the skills you need to be able to do this as well as providing you with some practical ideas for presenting data.
This session will cover the following topics:
Creating a chart with a single keystroke
Selecting the most appropriate chart type (i.e. pie chart, line chart, etc)
Adding labels, gridlines, titles and backgrounds to a chart
Creating a combination chart(bar/line)
Creating a dynamic chart (based on a Table)
Adding annotations to a chart
Creating Sparkline charts
Creating infographic style charts
Using Conditional Formatting to present data visually
Creating a Pareto Chart to aid prioritization
Who will Benefit
Any user of Excel who needs to know how to create charts and graphs
Accountants, CPA's, CFO's, Financial consultants, Controllers, Data Analyst, Marketing Analyst, DBA, Database Administrators, Logistics Analyst, Financial Analyst, Web Analytics Specialist, SEO, Digital Analyst, Social scientists
Attendees should have an introductory level knowledge of Excel. The training will be delivered using Excel 2016 for Windows although much of the functionality is available in Excel 2007/2010 and 2013 on Windows and 2016 on Mac.
Your webinar shared successfully!
Happy New Year
Happy New Year
Flat 40% off on all our On-Demand Webinars use promo code NY2018
Register for any of the Upcoming Webinar & get 40% off on next purchase USE ORDER ID AS PROMO CODE
Flat 40% off on all our On-Demand Webinars use promo code
Register for any of the Upcoming Webinar & get 40% off on next purchase