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

Excel Visual Features: Create More Attractive Worksheets (IME973B)

Presented by: Dennis Taylor
This conference is no longer available
But don't worry, our customer care representatives will help you find an event that meets your needs!
Call on (800) 223-8720
Event Description
1.0 CPE

Learn How to Use Diverse Excel Features to Create an Engaging Worksheet


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 the 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.

Join this webinar with Excel expert Dennis Taylor, who will demonstrate 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 will learn the benefit of inserting pictures, ClipArt, and shapes as well as how to re-configure them and add text. You will also learn how to set up check boxes and scroll bars to simplify data entry chores.

Session Highlights

  • Learn to use conditional formatting to accentuate significant data with color bars, icons, and other visual effects that react to dynamic worksheet changes
  • Use themes to make quick adjustments to the entire workbook for consistent colors and fonts
  • Learn the use of form controls to create interactive worksheets with check boxes, spin buttons, and more
  • Learn to convert data to tables to simplify list organization and set up dynamic charts
  • Explore over 200 SmartArt options to create organization charts, process flow diagrams, Venn diagrams, and more
  • Use the quickly-applied Sparklines feature to create in-cell charts

Who Should Attend

Any Excel user who wants to learn how to:

  • Add color and flair to worksheets and wants quick methods to add emphasis to data and charts
  • Annotate worksheets
  • Use SmartArt features
  • Convert data into tables
  • Add sparklines to accompany data
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