Getting the most out of Microsoft Excel Charts
Learn to create, customize and format Excel charts, add labels and trendlines, build pie and combo charts and sparklines, and reuse charts in Word and PowerPoint.
Speaker
Tom Fragale
Microsoft Office trainer · 30+ years in computing
Overview
A good chart shows the meaning of large amounts of data far better than the raw numbers. This 90-minute Excel charts training covers how to create and manage different types of charts, starting with the basics and building up to more complex combo charts.
You'll learn to create a chart from your data, customize and format it, change existing charts, and add data labels, titles and trendlines, including using a trendline to project future values.
The session also covers pie charts, combo charts and sparklines, saving and reusing chart templates, and linking Excel charts to Word, PowerPoint or Outlook.
Why attend: Managers often ask for charts or changes to existing ones. Knowing how to build and adjust them yourself makes you the go-to person, saves time and helps your team present data clearly. This session suits business owners, executives, managers, administrators, salespeople, trainers, bankers and anyone who uses Excel regularly.
What’s covered
- Creating a chart from Excel data
- Customizing and formatting charts
- Adding data labels, titles and trendlines
- Using a trendline to project into the future
- Pie charts
- Combo charts
- Sparklines
- Saving and reusing a chart template
- Linking an Excel chart to Word, PowerPoint or Outlook
Who should attend
What you get
About the speaker
Tom Fragale is a computer professional with over 30 years of professional experience. He has trained over 30,000 business people in on-line webinars, public seminars, and on-site training. His clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across many industries, including manufacturing, banking, pharmaceutical, education, retail, etc. He started his career as a database application programmer and has served as a consultant and project manager on many successful projects. His topics of expertise include: Access, Excel, Word, PowerPoint, Outlook, Crystal Reports, SQL Server, Visio, QuickBooks, and SharePoint, among others. His passion is training people and helping people get the most out of their computers, and he is a published author having written a book on Microsoft Access. He graduated in 1988 from LaSalle University in Philadelphia, PA with a BA in Computer Science.
Staci Warne · 60 min
Cathy Horwitz · 180 min
Craig Brody · 60 min