Excel 2016 Course- Excel Advanced Charts
4.5 (2 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.
517 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2016 Course- Excel Advanced Charts to your Wishlist.

Add to Wishlist

Excel 2016 Course- Excel Advanced Charts

Learn how to do advanced charts in Excel 2016.
4.5 (2 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.
517 students enrolled
Last updated 10/2016
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Be able to confidently apply these dynamic charts to your work
Be able to reduce time when preparing frequent reports
View Curriculum
Requirements
  • A copy of Excel 2007-2016
  • Willingness to learn
Description

This Excel 2016 course will teach you how to do 3 advanced Excel charts. These charts will really enhance your reports and can be used to illustrate your data effectively. They will also reduce the amount of time it takes for you to prepare your reports.

A lot of courses teach the basic Excel charts built in but this Excel course uses a combination of Excel formulas and charts to really make some useful (and cool!) charts.

All the workbooks are provided and full support is given via the discussion forum. Stuck? Well don't be shy! Ask a question!

This course is also a bite size course. In less than one hour you will know these techniques. Give it a try. You have nothing to loose..but everything to gain.

Who is the target audience?
  • Beginners+ to intermediate users of Excel- Students should be able to make basic charts already
  • This course is suitable for analysts both business and data and mid level Managers
  • This course is not suitable for complete beginners of Excel
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 6 Lectures Collapse All 6 Lectures 47:35
+
Introduction to Excel 2016 course
1 Lecture 02:24

Lecture introduces Excel 2016 course and advises on what the course is, aim of the course and best ways to learn from this course!

Preview 02:24
+
Colour changing charts
1 Lecture 17:37

This lecture shows you how to make chart bars that change colour automatically. Automate your reports and save time!

Chart bars that change colour automatically
17:37

Quiz on chart bars

Chart bars quiz
4 questions
+
Showing the max and min value on charts
1 Lecture 12:45

This lecture shows you how to make a chart which shows the max and min values dynamically! This method is great for weekly and monthly reports.

Preview 12:45

Quiz on max and min charts

Max and Min quiz
4 questions
+
Self expanding charts
1 Lecture 12:05

This lecture will teach you how to make charts that self expand dynamically. This is a real cool way to automate your weekly reports.

Charts that self update dynamically
12:05

Quiz on self expanding charts

Self expanding charts quiz
3 questions
+
Wrap up lecture
2 Lectures 02:53

Wrap up lecture to course:)

End lecture
00:30

Bonus lecture: Discounts to our other courses
02:23
About the Instructor
Mach 42 Productions
4.5 Average rating
407 Reviews
14,144 Students
13 Courses
Excel Tutoring/Consulting Services, 14,000+ students

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 14,000 students enrolled. So please have a look at our range of fantastic courses and join us on our journey. You won't be disappointed.