My Shopping Cart
There are no items in your shopping cart.

Excel Visual Features: Create More Attractive Worksheets (IME730G)

Presented by: Dennis Taylor
(*) Single User Price. For multiple users please call 1-844-384-4744
Pre Recorded Webinar
60 minutes
Event Description

Jazz Up Your Worksheet with Some Handy Tips from Dennis Taylor

Appearances count, particularly when you’re making a presentation or creating a handout. A dull, lifeless worksheet doesn’t need to be if you know how to enliven your data with some of many tools that Excel offers. Use conditional formatting to make significant data stand out with icons or shaded color cells; convert large lists into tables and gain additional data manipulation tools along with vast visual improvements; instead of creating elaborate charts that might require a lot of tweaking to get them just right, consider using sparklines (in-cell charts) that provide a visual complement to your data as well as displaying vital trend information. Excel has a wealth of other visual tools as well that let you present information with increased clarity and visual appeal.

Excel expert Dennis Taylor will show you how to get right to the essence of features like conditional formatting, form controls, SmartArt tools, and the myriad of features available on the Insert tab. You’ll also learn the benefit of inserting pictures, ClipArt, and shapes as well as how re-configure them and add text.  Plus, find out how to set up check boxes and scroll bars to simplify data entry chores.

Session Highlights

  1. Conditional Formatting - accentuate significant data with color bars, icons, and other visual effects that react to dynamic worksheet changes
  2. Themes - make quick adjustments to the entire workbook for consistent colors and fonts
  3. Form Controls - create interactive worksheets with check boxes, spin buttons, and more
  4. Tables - convert data to tables to simplify list organization and set up dynamic charts
  5. SmartArt - explore over 200 options to create organization charts, process flow diagrams, Venn diagrams, and more
  6. Sparklines - Create in-cell charts with the new (in Excel 2010) feature

 You can make vast improvements to the appearance of your worksheets and charts if you learn how to use the wealth of visual tools that Excel offers.

Who should attend?

Any Excel user who needs to add color and flair to worksheets and wants quick methods to add emphasis to data and charts will benefit from this webinar. Annotating worksheets, using SmartArt features, converting data into tables, and adding sparklines to accompany data are just a few of the many tools presented in this webinar.

About Our Speaker(s)

Dennis Taylor | Microsoft Excel SpeakerDennis Taylor
Dennis Taylor has taught thousands of Excel seminars and classes since the early 90's, is the author/presenter of over 250 Excel webinars, and authored the book Teach Yourself Microsoft Excel 2000. He has taught hundreds of public Excel seminars in the US and Canada since 2006 and has recorded over 100 Excel courses bo... More info

Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
    Event Title: Excel Visual Features: Create More Attractive Worksheets
    Presenter(s): Dennis Taylor

Our Accreditation Partners Protection Status

Dear Valued Customers,

We regret to announce that ProEdTech LLC and all its affiliate brands will cease operations on April 1, 2019.

We are no longer able to fulfill online orders. We will fullfill all DVD and book orders already placed.

Customers of canceled webinars and subscription products may request a refund at (800) 223-8720 or You must do so by April 1, 2019.

Thank you for your business and loyalty over the years. We sincerely apologize for any inconvenience caused.

Best regards,
The ProEdTech Team