Excel Visual Tools: Go Beyond Charts & Present Your Data Like a Pro
Summary
In addition to charts, Excel has a wealth of visual tools and effects that let you present information with greater clarity, making your worksheets come alive. In this 90-minute, hands-on training, discover those techniques that you can use to impress your clients and colleagues, save time and make more informed decisions. Join Excel expert Dennis Taylor in this instructor-led, live training to learn:
- Conditional Formatting: Highlight data with color bars, icons, & more
- Convert data to tables to simplify list organization & set up dynamic charts
- Dynamic charts: Converting data to tables to simplify list organization
- Create interactive worksheets & forms with check boxes, spin buttons & more
- Smart Arts for organization charts, process flow diagrams, Venn diagrams
- Make quick adjustments to your workbooks for consistent colors & fonts
- 15 minutes of assisted exercises to increase your performance right away
- 30 minutes of interaction & live Q&A session!
- Customized & graded final exam to affect your retention & test your knowledge
Program Highlights
Top Tips to Maximize Excel Conditional Formatting, Tables & Sparklines
- Conditional formatting power tips: Keys to make your data stand out
- Convert data to tables: Speed-up formula creation, sorting & filtering
- How to use Sparklines to give a quick visual presentation of data
- Easy shortcuts to adjust themes, dates, times, colors, fonts & more
How to Master Shapes, Pictures, Graphic Titles, Diagrams & Form Controls
- Fast ways to insert shapes & add text as needed: Impress your clients
- Annotate charts & worksheets: Add lines, arrows, boxes, comments & more
- Use Form Controls to simplify data entry/editing with visual tools
- Ways to create eye-catching titles & labels with Word Art
Additional Training Tools:
- 15-minute exercises session designed to boost your skills right away
- A 30-minute interactive Q&A session to have all your Excel questions answered!
- Customized & graded final exam to boost your retention & test your knowledge
About The Speaker
Microsoft Excel expert Dennis Taylor is recognized nationally as an author, computer trainer and facilitator.
- Mr. Taylor is author of "Teach Yourself Microsoft Excel 2000," co-author of six books on spreadsheet software, and Author/Presenter of over 50 Excel Training CD courses.
- Dennis has developed and presented specialized Excel courses (Tips and Tricks, Database Features, Advanced Formulas and Functions) to numerous clients over the past 25 years.
- He has over 25 years of training and consulting experience and has taught over 250 Excel seminars, hundreds of webinars, and over 3,000 classes.
Program Benefits
Present your data like a pro, make informed decisions and impress your colleagues with all the power and variety of Excel’s visual features. Join us for this comprehensive, 90-minute Excel Lab that brings you all the power of live demonstrations, assisted exercises and more interaction in a live and longer Q&A session.