Excel 2016 Automated Charts And Tables Course
4.9 (4 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
20 students enrolled
Wishlisted Wishlist

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

Add to 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)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent 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
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Add interactivity to your Excel charts/reports - No VBA required
  • 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
About the Instructor
Mach 42 Productions
4.4 Average rating
621 Reviews
18,133 Students
13 Courses
Excel Consulting | 18,100+ Students | 13 Courses

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 18,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.