Excel Course 6- Automated Excel Charts And Tables

Course details

Please note:

This courses content is also used as part of our 19 hours Excel course. If you are an enrolled student of the latter, please do not buy this individual course since the content will be the same. If you are not a student of the latter mentioned course and decide to buy this sub-individual course, please note this courses content is repeated in certain parts of our 19 hours Excel course. 

This Excel 2016 charts, graphs and tables course aims to teach you how to use several of Excel's features by means of learning by examples - the first being building a dynamic line chart which does the following:

• Automatically shows data based on the last xyz days (which the user sets by a spinner)
• Automatically works out the minimum value and maximum value for that selected data- and shows it on the chart
• Automatically changes the chart title to reflect the amount of days shown

-the second example being how to dynamically add Excel chart comments/annotations which 'move' with the data points and give the user the ability to toggle them on/off.

-the third example being how to make an Excel thermometer chart which can be used to simply highlight how far a target has been met.

-the forth example learning how to automatically sort and rank Excel chart bars in ascending or descending order....no more wasting time each week sorting out your data for that deadline driven report.

-the fifth example being how to make an Excel funnel chart in Excel 2016

-and the sixth example showing you how to highlight the Top Ten performers on an Excel table dynamically 

We start off each example with overviewing the final Excel product and then explore each topic individually so you learn why you doing a technique and the purpose for it.

This course is aimed at intermediate users of Excel. It assumes a good knowledge of Excel so please bear that in mind. Those who are comfortable with beginners Excel (including writing formulas) and wish to progress to intermediate usage can also take this course. All techniques are in Excel- No VBA is needed!

Quizzes are provided and for the more advanced topics exercises are given.

Our Excel intermediate course is backed by a full 30 day money back guarantee so its risk free. Our lectures are all filmed in Excel 2016 and come with tasks/quizzes as well as the workbooks with one sheet showing the content at the start of the lecture and another showing the content at the end of the lecture basically 'before' and 'after' sheets which will aid your learning.