Understanding the chart and graph functions in Excel can help you to illustrate worksheet data so that others can more easily decipher key information. Luckily, the Chart Wizard in Excel makes it easy! In this course we will explore bar graphs, line graphs, conditioning or panel graphs, pie charts and much more. Dennis McGovern, will also discuss chart and customization tools during this exciting 2-hour webcast presentation.
The following information will be presented:
-
Creating Range Names in a SERIES formula
-
Using OFFSET and Count functions for charting purposes
-
Self Expanding Charts
-
Displaying the last x number of datapoints
-
Selecting a beginning and ending point for a dataseries
-
Creating and using Spinners
- Linking a Chart Title to a Cell
During this interactive course, time will be allotted for attendees to test out what their learning after each “tip or trick” is presented. This allows users to ask questions, and receive assistance to insure they understand the information before applying what they’ve learned at work or at home. Course materials, including a reference sheet and powerpoint will be distributed upon sign up. Room is limited so please sign up today!
