Do you use Charts and graphs in your reports? If so, then you don’t want to miss this great 1 day course.
There is so much which you can do with Charts and Graphs and we will look at all the nooks and crannies of this great Excel feature.
What you will learn:
- Add a Trendline with 3 clicks
- Business Diagrams & Organizational Charts
- Charting with Time on the X-axis
- Create a Time Line
- Creating a Thermometer Chart
- Creating a Transparent Chart Series
- Creating Combination Charts
- Creating Dynamic Charts
- Demonstrate fractions with a pie Chart
- Drawing with Excel – grid paper
- Expand the Chart Range
- Extending with Data Points
- Histogram – Create a Dual Sided Histogram in Excel
- Gantt Chart with Conditional Formatting
- Handle missing data in a Line Chart
- In-cell Column Chart
- Layouts for Column Charts
- Multiple Charts on a single Chart sheet
- Non-graphic Chart directly in a range
- Saving a Chart as a GIF file
- SmartArt Graphics in Excel
- Create Sparklines – Tiny, Word-sized Charts in Excel with SparkMaker
- Speedometer Charts in Excel
- Students creating bar Charts for survey data
- Summarize Data using a Pivot Charts
- Tips for the ‘Perfect Chart’
- Track Progress Towards a Goal