more-arw search

Webinar Recording

Delivering Dynamic Excel Reports and Analyses with Excel’s Automatic Indicators

Date: Wednesday, January 8, 2014
Time: 2:00 pm - 3:00 pm EST There are no CPE Credits for this Solution Demonstration.
  • This Webinar has been presented.
  • This Webinar page will be removed very soon. After that time, it cannot be 'completed' in your Webinar plan.
Join us for our second Excel training series webinar featuring Excel expert and Microsoft Excel MVP, Charley Kyd. This webinar will show you how to create and use traffic lights and other indicators in your Excel worksheets to…

  • Proactively alert you to reporting errors.
  • Mitigate critical reporting errors by leveraging functionality such as the ability to automatically turn off a print Area red if a report fails to reconcile.
  • Alert your audience to extreme conditions by utilizing techniques such as automatically displaying a large red arrow that points to an extreme value; or surround it with a thick border; or change its cell black and its font white.
  • Alert your audience to whether an upward trend in a chart is positive or negative.
  • Display & update different figures in reports, dynamically, as determined by your data.


  1. A beginning knowledge of Excel.

Bonus Content

You’ll receive one or more workbooks that contain completed examples that Charley created for this course. So if you miss a step during the webinar, you can learn it from the workbook.

View other webinars in this four-part series.

After attending this webinar you will be able to:
Assign conditional formats to areas of your worksheet, conditions that are controlled by formulas in cells in a Control worksheet.
Create formulas that display or hide arrows that point to key cells.
Set up Excel drawing objects, chart objects, and other objects to change automatically as determined by values in cells.


Charley Kyd, Founder, ExcelUser
Charley Kyd
Founder, ExcelUser
Charley is the founder of, perhaps the only site dedicated to the business use of Microsoft Excel....... Earlier, he worked as the CFO for various small and mid-sized companies, and later, as a business information consultant, specializing in management reporting with Excel and OLAP databases. He beta tested VisiCalc while working as a cost accountant at Hewlett-Packard in 1979....... Charley taught financial management at the University of Washington and Oregon State, and taught Information Systems at Pepperdine. He also wrote four books about spreadsheets, which were published by McGraw-Hill and Microsoft Press.


Over 40,000 members and the largest corporate finance site on the Web!
Featured in:
Forbes, The Wall Street Journal, TechCrunch, NBC
Find us on:
twitter linkedin facebook g+
Your Purchase is Secure
Proformative, Inc., 99 Almaden Blvd., Suite 975, San Jose, CA 95113, (408) 400-3993, [email protected]
By filling out this form you will become a member of Proformative, and are subject to Proformative's User Agreement. This webinar is provided to you for free by the sponsor, who may contact you later.

There are no CPE Credits for this Solution Demonstration.