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:
-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 chart 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.
This lecture overviews our dynamic chart and demonstrates it. This lecture will serve as a setting for the rest of the section which will break down the various components that have gone into this chart.
This Excel lecture covers the use of named ranges in the context of making our chart.
This lecture covers the min() function
This lecture covers the max() function.
Quiz on Min and Max functions
This Excel lecture covers a really good function- the offset function! This function is critical to our dynamic chart.
The Excel lecture continues our coverage of the offset() function.
This Excel lecture covers spinners (form controls) which are vital to our dynamic chart
This Excel lecture covers the & symbol which helps us construct part of our dynamic chart.
The & symbol quiz
This Excel lecture focuses on building our dynamic chart. This is a fairly long lecture since it draws on everything we have learnt so far from this section so please bear that in mind.
This Excel lecture continues our building of our dynamic chart.
This Excel lecture finalises our dynamic Excel chart.
This Excel lecture overviews our dynamic sales chart; now modified to display chart annotations which can be toggled on/off by the user as well as dynamically 'move' along with the chart.
This Excel lecture shows you how we modify our dynamic Excel sales chart to add automated comments in. The next Excel lecture will show us then how to add the toggle on/off switch.
This Excel lecture shows you how to add the functionality to toggle our dynamic chart comments on/off from the Excel chart.
This Excel lecture overviews our thermometer chart.
In this Excel lecture we cover how to make the thermometer shape and overview the initial data preparation.
This Excel lecture puts everything all together to get our final Excel chart product.
This Excel lecture overviews the various ways we can sort Excel chart bars automatically and explains why we are using an Excel native function method over the other options presented.
This Excel lecture covers method 1 of sorting chart bars automatically in MS Excel
This Excel lecture covers method 2 of sorting Excel charts bar automatically.
This Excel lecture shows you how to account for equal ranking in data.
This Excel lecture explains what a funnel chart is and how to make one in Excel 2016
This Excel lecture overviews how we can highlight the top ten or bottom ten performers in table.
This Excel lecture shows you how to construct the rules etc to highlight the top ten or bottom ten performers.
This Excel lecture wraps up the course.
Our Udemy Excel courses have been developed to cover a wide range of needs for the Excel user. There is a course to suit everyone from beginners level to advanced. We provide all workbooks and full support via the discussion forums. Simply put our Excel courses use real life examples and not just theory to help you learn and improve yourself and give you proper skills you can use in your workplace.
Our Excel IT Consultant/Instructor Navin has been in the IT industry for approximately ten years. Recently featured nationwide in Costco Magazine, Navin has over 6 years experience as an Analyst. Having self-taught himself Microsoft Excel and VBA, he achieved MCAS (now known as Microsoft Office Specialist) certification in Excel in 2010. His work in Excel has been varied having worked on automating and streamlining reports to building and deploying real time dashboards to monitor performance.
During his time as an Analyst, he often assisted colleagues who needed problems solved in Excel. By relating the functions to use, to the context of their problem, his colleagues were able to grasp the concepts of what functions to use and in what context.
This spurned Navin's need to develop these range of Excel courses which to date have over 17,100 students enrolled. So please have a look at our range of fantastic courses and join us on our journey. You won't be disappointed.