Excel Visual Tools: Go Beyond Charts & Present Your Data Like a Pro

Price: $

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 training, discover those techniques that you can use to impress your clients and colleagues, save time and make more informed decisions.

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

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

About The Speaker

Melissa Esquibel is a technology consultant, coach, trainer and speaker.

She is a consultant, frequent speaker and Microsoft Certified Trainer
Since 1991, Ms. Esquibel has assisted a variety of companies and industries with Microsoft Office (Excel, Word, PowerPoint, Access, Outlook) all versions through 2016.
Melissa has 25+ years experience in information technology with a background in training, technical writing and business risk analysis

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.

Credits

Credit Hours:

Field of Study:

Program Level:

Basic Knowledge

Prerequisites:

None

Advance Prep:

Delivery Method:

Group Internet Based

Progressive Business Conferences is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org

Purchase This On-Demand Webinar