Udemy – Excel: Master Excel and convert Data into powerful Charts [100% off]
—————– UPDATED: APRIL 2015 | OVER 1500 STUDENTS SO FAR—————
Note: This course is regularly updated with new lectures, guides and projects.
Do you struggle drawing professional charts in Excel?
Have you wasted your time searching countless hours for YouTube videos, trying to find useful content about Excel Charts?
Do you want to learn how to make amazing Dynamic Excel Charts, Dashboards and Pivot Charts in a few weeks?
While Excel offers dozens of chart types and hundreds of formatting options, making the right chart is the trickiest part. In order to use charts effectively, you’ll need to understand how different charts are used.
In this course my goal is to give my students the practical knowledge, with real-world examples and step-by-step instructions, to create professional and designer-quality charts in Excel.
With over 70 Lectures, quizzes, assignments, real-life Excel projects and weekly updates, learning advanced Excel techniques has never been easier. This course is a concise and practical go-to guide for creating Interactive Charts and awesome Dashboards in Excel. It also expands in to Pivot Tables, Pivot Charts, Conditional Formatting, Functions, Formulas and Macros.
GIFT: You also get full, FREE access to my amazing Excel: Stunning Excel Dashboards with PowerPivot-Power View Course – which sells here on Udemy
You’ll have lifetime access to watch the videos whenever you like. If you’re not 100% satisfied there is a 30 day money back guarantee!
Plus you will get fast and responsive support within 24 hours.
Full English subtitles are included in every lecture!
What are you waiting for? Enroll now and make your charts look amazing!
(it is 100% no risk deal)
Why is this course different?
It’s super practical. Free downloadable Excel working files are included to allow you to follow along using the same material I use throughout the lectures. You can download all of them.
It’s comprehensive and fast. Excel charts are complex, that’s why the course is broken down into bite-sized pieces
The course also expands in to Conditional Formatting and Functions-Formulas
Closed captions included
I update the course monthly with new lectures!
It has a quiz after section so to prove that you have learned the material.
You will learn the most current version of Microsoft Excel (2013) but the concepts are compatible with Excel 2010 and Excel 2007
Compatible with Microsoft Office for Macintosh
Contents and Overview
With over 16 Sections, 80 Lectures and 6 hours of high-quality content you’ll learn:
How to select the correct chart type for your data.
How to create amazing data visualizations in a matter of seconds!
The most important elements of a chart, like chart and plot area, Design and Format tab, data labels, gridlines, legends, titles, axes, layouts and much more
Modifying a chart visually: styles and colors, create a pictograph, Excel’s camera tool, shapes, effects, text etc.
Basic chart types like Column charts, Bar charts, Pie charts, Line charts, 3D charts, Scatter charts, Bubble charts, Stock charts, Surface charts and Radar charts.
How to create mini charts like Sparklines and make data analysis fun!
Advanced chart types like Combo charts, Pareto charts, Gantt charts, Gauge-Speedometer charts, Waterfall Charts, Bullet charts and Frequency charts.
How to create impressive Dynamic Professional Charts with 5 different methods
How to create Business Dashboards and Reports
How to create Pivot Tables, Pivot Charts and how to add Slicers to help you filtering your data.
Create a Histogram using Frequency Distribution.
How to create all types of Sparklines.
The secrets of linking charts with other programs and printing charts
Bonus material : Excel most useful shortcuts etc
How to create and use Functions-Formulas for Charts.
Who is this course for?
Everyone who wants to master Excel Charts
Students with willingness for learning
Only basic prior experience in Excel or spreadsheets is required to get the most out of this Excel course.
At the end of this Excel class you will be given a Certificate of Completion.
SOME OF 5-STAR REVIEWS OF OUR STUDENTS
“Highly recommend! I have been very impressed by this course. The material is well organized and thorough. It covers the basics really well and does include some more advanced content. Thank you Andreas!” – Ioanna, Udemy Student
“The course is split in very small chunks makes it easy to find exactly the information that I am looking for. Andreas is an excellent instructor. This is a great course.Thank you for such a comprehensive and detailed course!” – Vanzel, Udemy Student
About the instructor
“Hi, I am Andreas and I’m a teacher. I really love learning and teaching whenever i can.
I have over 16 years of experience in teaching as an instructor. I have my own computer learning school, called Futurekids, from 2001 to now. I am the founder of Mellon Training, an online video tutorials learning school.
I have a passion for software products that make people’s lives easier.
Thank you and I’ll see you inside!“
<<…learning is more effective when it is an active rather than a passive process>> Euripides – Ancient Greek dramatist
Enrol now and enjoy the course!