Excel 2016 Automated Charts And Tables Course
4.9 (4 ratings)
20 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2016 Automated Charts And Tables Course to your Wishlist.

# Excel 2016 Automated Charts And Tables Course

Excel 2016 Charts/Tables Course teaching you automated techniques charts and tables. No Excel VBA needed at all.
4.9 (4 ratings)
20 students enrolled
Last updated 9/2017
English
Current price: \$10 Original price: \$70 Discount: 86% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
• 3.5 hours on-demand video
• 25 Supplemental Resources
• Access on mobile and TV
• Certificate of Completion
What Will I Learn?
• Apply several Excel functions to create a dynamic sales chart
• Apply several Excel functions to dynamically add Excel annotations/comments to Excel charts
• Apply several Excel functions to automatically sort and rank Excel chart bars in ascending or descending order
• Increase their productivity in MS Excel
• Use the functions taught individually to apply to their own work tasks
• Be able to use the following functions/features : max(),min(),offset(),named ranges, the & symbol, form control spinners, rank() function
View Curriculum
Requirements
• Students will need a good beginners understanding of Microsoft Excel including how to write formulas
• Students will need a PC and copy of Excel 2016
• Students will need to be familar already with the functions count, counta, vlookup and index/match functions
• Students need to be familiar with if then else statements and how to write them
• Students will need to know how to make a basic line chart and bar chart
• Students will need to know the basics of conditional formatting and how to use it
Description

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.

Who is the target audience?
• Excel users who are at an intermediate level of Excel and wish to further those skills
• Excel users who are comfortable in beginners level Excel and wish to progress to intermediate usage of Excel- but please be aware this is an intensive course
• Do not take this course if you are an advanced user of Excel
• Analysts who need to prepare reports and want to automate them
• Users who know how to use vlookup and index/match
Compare to Other Excel Charts Courses
Curriculum For This Course
26 Lectures
03:15:06
+
Introduction to our Excel course
1 Lecture 02:50

This Excel lecture introduces the course, overviews the aim of the course and best ways to learn from this Excel course.

Preview 02:50
+
Creating a dynamic chart
11 Lectures 01:50:48

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.

Preview 11:10

This Excel lecture covers the use of named ranges in the context of making our chart.

Named ranges
15:06

This lecture covers the min() function

The min function
05:11

This lecture covers the max() function.

The max function
04:03

Quiz on Min and Max functions

Min and Max quiz
2 questions

This Excel lecture covers a really good function- the offset function! This function is critical to our dynamic chart.

The offset function part 1
18:52

The Excel lecture continues our coverage of the offset() function.

The offset function part 2
04:20

This Excel lecture covers spinners (form controls) which are vital to our dynamic chart

Spinners
05:08

This Excel lecture covers the & symbol which helps us construct part of our dynamic chart.

The & Symbol
11:09

The & symbol quiz

The & Symbol quiz
2 questions

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.

Building our dynamic chart part 1
13:26

This Excel lecture continues our building of our dynamic chart.

Building our dynamic chart part 2
11:47

This Excel lecture finalises our dynamic Excel chart.

Building our dynamic chart part 3
10:36
+
Annotating Charts- A good sequel to our Excel sales chart
3 Lectures 19:15

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.

Preview 03:04

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.

How to annotate our Excel sales chart
12:22

This Excel lecture shows you how to add the functionality to toggle our dynamic chart comments on/off from the Excel chart.

How to turn on/off our Excel chart annotations dynamically
03:49
+
How to make a thermometer chart in Excel
3 Lectures 17:28

This Excel lecture overviews our thermometer chart.

Preview 03:40

In this Excel lecture we cover how to make the thermometer shape and overview the initial data preparation.

Steps 1 and 2 - Checking Thermometer Data and Making the Shape!
06:23

This Excel lecture puts everything all together to get our final Excel chart product.

Step 3: Putting the Excel thermometer chart together
07:25
+
Sorting Excel Chart Bars Automatically
4 Lectures 27:23

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.

Preview 02:12

This Excel lecture covers method 1 of sorting chart bars automatically in MS Excel

Sorting Excel Chart Bars Method 1
10:05

This Excel lecture covers method 2 of sorting Excel charts bar automatically.

Sorting Excel Chart Bars Method 2
04:30

This Excel lecture shows you how to account for equal ranking in data.

Sorting Excel Chart Bars - Solving Equal Rank
10:36
+
Making an Excel Funnel Chart in Excel 2016
1 Lecture 04:33

This Excel lecture explains what a funnel chart is and how to make one in Excel 2016

Overview/Making our Excel Funnel Chart
04:33
+
Highlighting the Top Ten performers on a table
2 Lectures 12:07

This Excel lecture overviews how we can highlight the top ten or bottom ten performers in table.

Preview 03:40

This Excel lecture shows you how to construct the rules etc to highlight the top ten or bottom ten performers.

Top Ten performers- Putting it all together
08:27
+
Wrap up
1 Lecture 00:42

This Excel lecture wraps up the course.

End lecture
00:42