This is a comprehensive coverage of Excel Charts. When you complete this workshop, you will possess the necessary knowledge and the hands-on tools to create the Excel charts to present data in a meaningful fashion. The workshop will instruct you how to prepare data for the charts, work around the axis, and personalize the charts, amongst other things. You will be able to create all the Excel charts, modify them and express the chart in the best way to characterize you or your company. This workshop covers the first part of my recent book.
Course Objectives:
• Understand the purpose of all Excel Charts.
• Prepare data for creating charts.
• Data visualization techniques.
• Creating personal chart templates.
Course Outline:
The first part will familiarize you with most of Excel charts’ gallery. The idea is for understand where, when and how to use these Excel charts.
The second part is to understand Chart Terminology, Elements and Styles – how to use them and modify the charts with them. At this point you will be comfortable creating and manipulating any of the Excel charts.
Next part enables you to take any “predictable” chart and make it appear as “your” chart – the chart that you are proud to present. It shows how to modify the charts in a variety of ways. You can swap the Rows with the Columns. You can delete or add data to existing charts. It covers different filtering, layouts and formatting techniques. You will learn how to add specific features to a chart, such as logos or pictures for presenting your company’s identity. Once you create a chart which you would like to use again – you will be able to save the chart - as a Template for future use.
The last part covers unconventional charts and advanced charting technique topics. Will start with techniques used to animate charts. It continues with creating combination charts. Will cover alternatives to Excel charts, namely, Sparklines, Text charts and Conditional Formatting charts. At the very end we show how to construct a curve and mathematical function which have the best fit to the series of data points on a chart, named “Trendlines”. Examples include supply and demand curve functions and other business data sets. In addition to the mathematical function, the chart will show how to calculate the “Coefficient of Determination” – which expresses the correlation between Trendline and data enable you to use charts for forecasting.
What You Get:
• Training Materials
• Live Q&A Session with our Expert
• Participation Certificate
• Access to Signup Community (Optional)
• Reward Points
Who Will Benefit:
Any person using Excel who wants to learn or improve their Excel charts skills. It will help users of any level improve they charting skills with countless examples – using hands on examples on provided Excel workbook.
2 Hours Virtual Seminar on Visualizing Data with Excel Charts
Get Instant Access 120 Minutes View Program |
Excel Pivot Tables , Pivot Charts, Slicers, and Timelines
Get Instant Access 75 Minutes View Program |
Mastering Excel Charts and Graphs - Communicate Insights More Effectively
Get Instant Access 60 Minutes View Program |
3 Hour Excel Automation Boot Camp: Sort and Filter Tools, Conditional Formatting, Data Validation and Visualizing Excel with Smart-Art and Charts
Get Instant Access 180 Minutes View Program |
Mastering Excel Charts
Get Instant Access 60 Minutes View Program |
Get Instant Access On-Demand Access
Preparing for the ICE Storm: What to Do During I 9 Audits and ICE Raids
Janette S. Levey
Human Resources
Get Instant Access On-Demand Access
OSHA Inspections and Investigations-How to Manage Them
Irwin Dobrushin
Environment Health and Safety | OSHA
Get Instant Access On-Demand Access
29 CFR 1904: OSHA's New Injury Recordkeeping E-Submission Rule
Occupational Safety and Health Administration
Get Instant Access On-Demand Access
Working with Excel Databases: Sort, Filter, Subtotal and More
Cathy Horwitz
Cross Industry | Skill Enhancement
Get Instant Access On-Demand Access
Writing Audit Reports
Jonnie T. Keith CIA, CFE, CGAP, CICA
Governance, Risk and Compliance
Get Instant Access On-Demand Access
BSA Reporting Requirements
Banking and Financial Services Industry
Get Instant Access On-Demand Access
Human Factors-Usability Based on ISO 62366
Medical Device | Diagnostic | Pharmaceutical | Biologics fields
Get Instant Access On-Demand Access
Chat GPT for Project Managers
Charles H. Paul
All FDA Regulated Industry