Excel With Excel Charts - Now With CC

Create amazing Excel charts to make better Excel reports, presentations and dashboards in under 1 hour
5.0 (3 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.
502 students enrolled
$19
$30
37% off
Take This Course
  • Lectures 11
  • Length 1 hour
  • Skill Level All Levels
  • Languages English, captions
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 6/2015 English Closed captions available

Course Description

*Latest updates: Dec 2015: Course is now fully English Captioned/Subtitled*

Want to learn how to make great charts in very little time (no matter what your skill level?)

Want to know how to make those Excel reports even more better?

Then take our short Udemy course in Excel charts.

This Udemy Excel course is great if you want to add charts to the following:

  • Presentations – Dazzle your clients!
  • Reports- Make your reports more meaningful and clearer
  • Dashboards- Most of these charts can be adapted to include in dashboards

This course teaches you how to create charts in Excel to illustrate your work! Super handy charts! With this course you will learn how to:

  • Make charts which show before and after changes
  • Create mini sparkline charts –perfect for Excel dashboards!
  • Learn the secret to why 3D charts are so bad
  • Create thermometer charts
  • Create super easy text based charts

Like with all our Udemy Excel courses made by us (Mach 42 Productions), full support is given via the discussion forums, all the workbooks are available for download and all lectures are full English CC enabled.

What are you waiting for?

What are the requirements?

  • A basic working knowledge of Excel
  • Excel 2010+
  • Willingness to learn

What am I going to get from this course?

  • Apply these Excel chart skills to their own reports, dashboards and presentations
  • Be able to create sparkline charts, thermometer charts, before and after effect charts and text based charts
  • Be confident in using Excel charting techniques for the topics covered in the lectures

What is the target audience?

  • This course is aimed at beginners to intermediate level. It assumes a working basic knowledge of Excel charts.
  • The course is also suitable for junior level data and business analysts who regularly write reports
  • This course is also suitable for both undergraduates and postgraduates who want to enhance their job skills in a competitive market

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
03:08

This lecture overviews the Excel charts course

Section 2: How to create 'before' and 'after' effect Excel charts
10:35

This lecture explains how to make the popular 'before and after' effect chart

2 questions

Quiz on before and after effect charts

Section 3: 3D charts- Why you should avoid them
06:18

This lecture explains the secrets to why 3D charts are so bad.

2 questions

Quiz on 3D charts

Section 4: Making thermometer Excel charts
10:32

This lecture explains how to make really cool thermometer charts in Excel.

Section 5: Making sparkline Excel charts
06:30

This lecture shows you how to make sparkline charts in Excel.

3 questions

Quiz on sparklines

Section 6: Making text based Excel charts
10:50

This lecture explains how to make using just one formula in Excel, text based charts. This lecture further expands on this method by using conditional formatting and several other syntax's in Excel to make easy to read text charts.

05:24

This lecture shows you some of the creative things you can do with text based charts.

3 questions

Quiz on text based charts

Section 7: Scales and charts
08:01

Lecture covers the importance of scales in charts

Section 8: After you finish the course: Add your course certificate to LinkedIn
Adding your certificate to LinkedIn
Article
Section 9: End lecture
00:59

This lecture closes up the course and summarises what you have learnt.

Bonus lecture: Discounts for our other Excel courses
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Mach 42 Productions, Excel Tutoring/Consulting Services

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

Ready to start learning?
Take This Course