Best Excel Charts Courses

Find the best online Excel Charts Courses for you. The courses are sorted based on popularity and user ratings. We do not allow paid placements in any of our rankings. We also have a separate page listing only the Free Excel Charts Courses.

Zero to Hero in Microsoft Excel: Complete Excel guide 2021

A Beginner's Guide to Microsoft Excel - Learn Excel Charts, Spreadsheets, Formulas, Shortcuts, Macros and Tips & Tricks

Created by Start-Tech Academy - 3,000,000+ Enrollments | 4+ Rated | 160+ Countries

"]

Students: 368448, Price: $29.99

Students: 368448, Price:  Paid

6 Reasons why you should choose this Excel course

  1. Carefully designed curriculum teaching you only the most used functionalities of Microsoft Excel in business environment

  2. Concise - you can complete this Microsoft Excel course within one weekend

  3. Business related examples, data analysis and case studies solved using Advanced Excel.

  4. You will learn various data analysis techniques using MS Excel

  5. Ample practice exercises on data analysis, MS excel (basic & advanced), because Excel requires practice

  6. Downloadable resources comprising important MS Excel techniques and functionalities

  7. Your queries will be responded by the Instructor himself

Start using Excel to its full potential to become proficient at your Excel tasks today!

Either you're new to Microsoft Excel, or you've played around with Excel since long but want to get more comfortable with MS Excel's advanced features, or maybe you want to enhance your data analysis skills using Microsoft Excel. Either way, this Excel course will be great for you.

A Verifiable Certificate of Completion is presented to all students who undertake this MS Excel course.

Why should you choose this course?

This is a complete and concise tutorial on MS Excel which can be completed within 6 hours. This course will help you learn advanced Excel and various data analysis tools associated with Microsoft excel. We know that your time is important and hence we have created this fast paced MS Excel course without wasting time on irrelevant Excel operations.

What makes us qualified to teach you?

The course is taught by Abhishek and Pukhraj. Instructors of the course have been teaching Data Science and Machine Learning for over a decade. They have an in-depth knowledge in advanced MS Excel and various data analysis tools available in the market.

We are also the creators of some of the most popular online courses - with over 150,000 enrollments and thousands of 5-star reviews like these ones:

I had an awesome moment taking this course. It broaden my knowledge more on the power use of Excel as an analytical tools. Kudos to the instructor! - Sikiru

Very insightful, learning very nifty tricks and enough detail to make it stick in your mind. - Armand

Our Promise

Teaching our students is our job and we are committed to it. If you have any questions about the course content on basic Excel features, or advanced Excel functions or maybe on data analysis tools; practice sheet or anything related to any topic, you can always post a question in the course or send us a direct message.

Download Practice files, take Quizzes, and complete Assignments

With each lecture, there is a practice sheet attached for you to follow along. You can also take quizzes to check your understanding of concepts. Each section contains a practice assignment for you to practically implement your learning. Assignments are aimed at enhancing your skillsets on Microsoft Excel at an advanced level and at analysing data. Solution to Assignment is also shared so that you can review your performance.

What is covered in this course?

This course covers everything you need to crack advanced MS Excel in the professional work place.

Below are the Excel course contents of this complete and concise course on Microsoft Excel:

  • Introduction - In this video, the structure and contents of the course are discussed.

  • Mathematical Functions - This lecture covers Mathematical formulas such as SUM, AVERAGE,RAND, MIN & MAX, SUMPRODUCT.

  • Textual Formulas - This Excel lecture covers Textual formulas such as TRIM, CONCATENATE, SUBSTITUTE, UPPER & LOWER, LENGTH, LEFT, RIGHT & MID

  • Logical Formulas - This lecture covers Logical formulas such as AND & OR, IF, COUNTIF, SUMIF

  • Date-time (Temporal) Formulas - This lecture covers Date-time related functions such as TODAY & NOW, DAY, MONTH & YEAR, DATEDIF & DAYS

  • Lookup Formulas - This Excel lecture covers Lookup formulas such as VLOOKUP, HLOOKUP, INDEX, MATCH

  • Data Tools - This lecture covers Data operating tools such as Data Sorting and Filtering, Data validation, Removing duplicates, Importing Data (Text-to-columns)

  • Formatting data and tables - This Excel lecture covers data formatting options such as coloring, changing font, alignments and table formatting options such as adding borders, having highlighted table headers, banded rows etc.

  • Pivot Tables - This Excel lecture covers Pivot tables end-to-end.

  • Charts - This Excel lecture covers charts such as, Bar/ Column chart, Line Chart, Scatter Plot, Pie & Doughnut charts, Statistical Chart - Histogram, Waterfall, Sparklines

  • Excel Shortcuts - This lecture will introduce you to some important shortcuts and teach you how to find out the shortcut for any particular excel operation.

  • Analytics in Excel - This Excel lecture covers the data analytics options available in Excel such as Regression, Solving linear programming problem (Minimization or Maximization problems), What-if (Goal Seek and Scenario Manager)

  • Macros - This lecture covers the process of recording a Macro, running a Macro and creating a button to run a Macro.

  • Bonus Lectures - Waterfall chart in Excel 2016 and previous versions of Excel, Infographics 1: Cool charts, Infographics 2: Cool charts

  • And so much more!

By the end of this course, your confidence in using MS Excel will soar. You will learn how Microsoft Excel can play a pivotal role in data analysis and related field. You'll also have a thorough understanding of how to use Microsoft Excel for study or as a career opportunity.

Go ahead and click the enroll button, and I'll see you in lesson 1!

Cheers

Start-Tech Academy

FAQ's

Why learn Microsoft Excel?

1. Microsoft Excel helps solve Business Problems

2. MS Excel has some extremely relevant and important data analysis tools.

3. Advanced MS Excel will give you an edge over other candidates in the competitive environment in schools, colleges or workplaces.

4. Microsoft Excel helps you get stuff done

5. Microsoft Excel will make you better at your job (no matter what that is)

6. Microsoft Excel know-how can instantly increase your job prospects as well as your starting salary

How much time does it take to learn Microsoft Excel?

Microsoft Excel is easy but no one can determine the learning time it takes. It totally depends on you. The method we adopted to help you learn Microsoft Excel quickly starts from the basics and takes you to advanced level within hours. You can follow the same, but remember you can learn nothing without practicing it. Practice is the only way to learn Microsoft Excel quickly.

What are the steps I should follow to learn Microsoft Excel?

1. Start learning from the basics of Microsoft Excel. The first 3 sections of the course cover the basics.

2. Once done with the basic try your hands on advanced MS Excel. Next 7 sections cover Advanced Excel topics

3. Next section will help you some cool new tricks of Microsoft Excel.

4. Practice your learning on the exercise provided with every lecture.

What is the difference between basic and advanced level of Excel?

At Basic level of MS Excel a person

  1. Can build excel formulas using: SUM, IF, AVERAGE, COUNT, ROUND

  2. Is comfortable building excel formulas to manipulate text and dates

  3. Understands and can use the Filter and Sort feature of Microsoft Excel.

  4. Can create basic charts like Line chart, bar chart and pie chart

At Advanced level of MS Excel a person

  1. Can implement Excel LOOKUP Formulas like VLOOKUP, HLOOKUP, Index and Match

  2. Can use conditional and logical formulas like IF, SUMIF, COUNTIF, OR, AND etc.

  3. Knows what a Pivot Table is and how to build one.

  4. Knows what an add-in is and how to install one.

  5. Can record a macro and use it later.

  6. Can successfully edit/modify simple recorded macros.

  7. Can create advanced charts like Waterfall chart and overlay chart in Microsoft Excel

  8. Can create solve analytics problem using excel solver.

Start working proficiently on Microsoft Excel and increase your office productivity.

The Authors of this Microsoft Excel course have several years of corporate experience and hence have curated the course material keeping in mind the requirement of advanced MS Excel in today's corporate world.

Microsoft Excel Masterclass for Business Managers

Microsoft Excel for Business - Excel Formulas and Functions, Excel Charts, Excel Analytics, Shortcuts & Excel Macros

Created by Start-Tech Academy - 3,000,000+ Enrollments | 4+ Rated | 160+ Countries

"]

Students: 257260, Price: $29.99

Students: 257260, Price:  Paid

7 Reasons why you should choose this Excel course

  1. Carefully designed curriculum teaching you only the most used functionalities of Microsoft Excel in business environment

  2. Concise - you can complete this Microsoft Excel course within one weekend

  3. Business related examples, data analysis and case studies solved using Advanced Excel.

  4. You will learn various data analysis techniques using MS Excel

  5. Ample practice exercises on data analysis, MS excel (basic & advanced), because Excel requires practice

  6. Downloadable resources comprising important MS Excel techniques and functionalities

  7. Your queries will be responded by the Instructor himself

Start using Excel to its full potential to become proficient at your Excel tasks today!

Either you're new to Microsoft Excel, or you've played around with Excel since long but want to get more comfortable with MS Excel's advanced features, or maybe you want to enhance your data analysis skills using Microsoft Excel. Either way, this Excel course will be great for you.

A Verifiable Certificate of Completion is presented to all students who undertake this MS Excel course.

Why should you choose this course?

This is a complete and concise tutorial on MS Excel which can be completed within 6 hours. This course will help you learn advanced Excel and various data analysis tools associated with Microsoft excel. We know that your time is important and hence we have created this fast paced MS Excel course without wasting time on irrelevant Excel operations.

What makes us qualified to teach you?

The course is taught by Abhishek and Pukhraj. Instructors of the course have been teaching Data Science and Machine Learning for over a decade. They have an in-depth knowledge in advanced MS Excel and various data analysis tools available in the market.

We are also the creators of some of the most popular online courses - with over 150,000 enrollments and thousands of 5-star reviews like these ones:

I had an awesome moment taking this course. It broaden my knowledge more on the power use of Excel as an analytical tools. Kudos to the instructor! - Sikiru

Very insightful, learning very nifty tricks and enough detail to make it stick in your mind. - Armand

Our Promise

Teaching our students is our job and we are committed to it. If you have any questions about the course content on basic Excel features, or advanced Excel functions or maybe on data analysis tools; practice sheet or anything related to any topic, you can always post a question in the course or send us a direct message.

Download Practice files, take Quizzes, and complete Assignments

With each lecture, there is a practice sheet attached for you to follow along. You can also take quizzes to check your understanding of concepts. Each section contains a practice assignment for you to practically implement your learning. Assignments are aimed at enhancing your skillsets on Microsoft Excel at an advanced level and at analysing data. Solution to Assignment is also shared so that you can review your performance.

What is covered in this course?

This course covers everything you need to crack advanced MS Excel in the professional work place.

Below are the Excel course contents of this complete and concise course on Microsoft Excel:

  • Introduction - In this video, the structure and contents of the course are discussed.

  • Mathematical Functions - This lecture covers Mathematical formulas such as SUM, AVERAGE,RAND, MIN & MAX, SUMPRODUCT.

  • Textual Formulas - This Excel lecture covers Textual formulas such as TRIM, CONCATENATE, SUBSTITUTE, UPPER & LOWER, LENGTH, LEFT, RIGHT & MID

  • Logical Formulas - This lecture covers Logical formulas such as AND & OR, IF, COUNTIF, SUMIF

  • Date-time (Temporal) Formulas - This lecture covers Date-time related functions such as TODAY & NOW, DAY, MONTH & YEAR, DATEDIF & DAYS

  • Lookup Formulas - This Excel lecture covers Lookup formulas such as VLOOKUP, HLOOKUP, INDEX, MATCH

  • Data Tools - This lecture covers Data operating tools such as Data Sorting and Filtering, Data validation, Removing duplicates, Importing Data (Text-to-columns)

  • Formatting data and tables - This Excel lecture covers data formatting options such as coloring, changing font, alignments and table formatting options such as adding borders, having highlighted table headers, banded rows etc.

  • Pivot Tables - This Excel lecture covers Pivot tables end-to-end.

  • Charts - This Excel lecture covers charts such as, Bar/ Column chart, Line Chart, Scatter Plot, Pie & Doughnut charts, Statistical Chart - Histogram, Waterfall, Sparklines

  • Excel Shortcuts - This lecture will introduce you to some important shortcuts and teach you how to find out the shortcut for any particular excel operation.

  • Analytics in Excel - This Excel lecture covers the data analytics options available in Excel such as Regression, Solving linear programming problem (Minimization or Maximization problems), What-if (Goal Seek and Scenario Manager)

  • Macros - This lecture covers the process of recording a Macro, running a Macro and creating a button to run a Macro.

  • Bonus Lectures - Waterfall chart in Excel 2016 and previous versions of Excel, Infographics 1: Cool charts, Infographics 2: Cool charts

  • And so much more!

By the end of this course, your confidence in using MS Excel will soar. You will learn how Microsoft Excel can play a pivotal role in data analysis and related field. You'll also have a thorough understanding of how to use Microsoft Excel for study or as a career opportunity.

Go ahead and click the enroll button, and I'll see you in lesson 1!

Cheers

Start-Tech Academy

FAQ's

Why learn Microsoft Excel?

1. Microsoft Excel helps solve Business Problems

2. MS Excel has some extremely relevant and important data analysis tools.

3. Advanced MS Excel will give you an edge over other candidates in the competitive environment in schools, colleges or workplaces.

4. Microsoft Excel helps you get stuff done

5. Microsoft Excel will make you better at your job (no matter what that is)

6. Microsoft Excel know-how can instantly increase your job prospects as well as your starting salary

How much time does it take to learn Microsoft Excel?

Microsoft Excel is easy but no one can determine the learning time it takes. It totally depends on you. The method we adopted to help you learn Microsoft Excel quickly starts from the basics and takes you to advanced level within hours. You can follow the same, but remember you can learn nothing without practicing it. Practice is the only way to learn Microsoft Excel quickly.

What are the steps I should follow to learn Microsoft Excel?

1. Start learning from the basics of Microsoft Excel. The first 3 sections of the course cover the basics.

2. Once done with the basic try your hands on advanced MS Excel. Next 7 sections cover Advanced Excel topics

3. Next section will help you some cool new tricks of Microsoft Excel.

4. Practice your learning on the exercise provided with every lecture.

What is the difference between basic and advanced level of Excel?

At Basic level of MS Excel a person

  1. Can build excel formulas using: SUM, IF, AVERAGE, COUNT, ROUND

  2. Is comfortable building excel formulas to manipulate text and dates

  3. Understands and can use the Filter and Sort feature of Microsoft Excel.

  4. Can create basic charts like Line chart, bar chart and pie chart

At Advanced level of MS Excel a person

  1. Can implement Excel LOOKUP Formulas like VLOOKUP, HLOOKUP, Index and Match

  2. Can use conditional and logical formulas like IF, SUMIF, COUNTIF, OR, AND etc.

  3. Knows what a Pivot Table is and how to build one.

  4. Knows what an add-in is and how to install one.

  5. Can record a macro and use it later.

  6. Can successfully edit/modify simple recorded macros.

  7. Can create advanced charts like Waterfall chart and overlay chart in Microsoft Excel

  8. Can create solve analytics problem using excel solver.

Start working proficiently on Microsoft Excel and increase your office productivity.

The Authors of this Microsoft Excel course have several years of corporate experience and hence have curated the course material keeping in mind the requirement of advanced MS Excel in today's corporate world.

Ms Excel/Excel 2021 – The Complete Introduction to Excel

Master Excel/microsoft Excel- Learn MS Excel - Excel formulas/Excel charts/Excel functions using Excel 2016/Excel 2019

Created by Yassin Marco - Helped over 995 000+ students in 198 countries

"]

Students: 195566, Price: $59.99

Students: 195566, Price:  Paid

Microsoft Excel is definetly not an easy application to learn and to use. This is why sometimes it's better to have someone that help us learning how to properly work with this amazing APP. Indeed, wether you are:

- A student looking to learn how to use this APP for a school project

- Looking to learn microsoft Excel for professional goals

- Want to improve your knowledge and learn new skills

- Understand microsoft Excel just for personal uses

Or any other reason this course is for you. By using this course to learn this Microsoft APP you will have access to many high quality examples tips and tricks. Also, you will get a complete introduction to all Excel basics and you will be able to work with this app on a daily basis with more confidence.

The structure of the course

​The course is created around a very simple concepte. To learn you need to practice as much as you can. This is why from the moment that you will enter the course and start your Excel journey you will have a lot of Examples and cases that are presented in the course to help you practice everything that you will learn. Not only this will help you become a better user of microsoft Excel but it will give the confidence to start using the App by yourself to be able to create way more andvanced Applications tat will be able to perform different tasks. Thoses App will be able to be used in your personnal life as well as in your professional fiel or at school.

Also, not only this course will help you learn a new skill that is the complete understanding of Microsoft Excel but you will also have a lot of practie inside of the course. So basically, in all the course you will be learning and practicing different concepts functions and formulas and at the end of this course you will have create your own project or small app that you will be able to later use for your personnal, proffessional life or simply for scool,

For who is this course designed

This course is designed for people who have no prior excel knowledge. Indeed, this course is really here to give you a complete introduction to microsfot Excel and give you all the basic knowledge to be able to use this amazing app by yourself. Also, this course can be useful for everyone that always wanted to start there Excel journey and to see the potential of Microsoft Excel. This means that even with no excel knoeledge you will be able to create your own Excel Apps by the end of this course and this a guarantee that I can give you.

Why should I take this course

​Yes, of course there is many other microsoft Excel courses that exist on the internet. But, my way of teaching you how to use this application is unique. Indeed, every concept in this course comes with an example. This will give you a lot of practice so you will be able to think very logically when you will create your own Excel apps. First of all, you will know the process of creating an excel basic app, know how create the plan for your app and then finally make all the creation of the app. This means that with just one course, you will be able to put your full potential into using microsoft Excel and having your own applications that can be used for different purposes.

There is no risk involved in taking this course

This course comes with a 100% satisfaction guarantee, this means that if your are not happy with what you have learned, you have 30 days ​to get a complete refund with no questions asked. Also, if there is any concepte that you find complicated or you are just not able to understand, you can directly contact me and it will be my pleasure to support you in your learning.

This means that you can either learn amazing skills that can be very usefull in your professional or everyday life or you can simply try the course and if you don't like it for any reason ask for a refund.

You can't lose with this type of offer !!

This is why more than 100 000 students have already took the course !! Don't wait anymore

ENROL NOW and start learning today :)

Excel – Microsoft Excel Beginner to Advanced [2021]

Excel Course: Microsoft Excel From Beginner to Advanced, Ms Excel Formulas, Chart Tips & Tricks in Excel 2019/Office 365

Created by Tamas Benko - Instructor

"]

Students: 132386, Price: $34.99

Students: 132386, Price:  Paid

In this special Microsoft Excel - Excel From Beginner to Advanced course you can learn the most important features of Excel focusing on data visualization and productivity. I'm using the version Microsoft Excel 2019 which is similar to Office 365 Excel, but the course is 90-95% compatible with Ms Excel 2010, 2013, 2016 versions.

If you're a beginner, in the first section you can learn Excel basics in 30 minutes.

Topics covered in the 30-min Getting Started With Excel lecture:

  • quick overview of the user interface

  • how to save your excel worksheet

  • drag & drop gesture

  • excel rows, columns, cells

  • how to move between cells quickly

  • excel data entry

  • excel data types

  • excel formulas & references

  • excel operators

  • how to select cells, ranges, columns, rows in excel

  • copy & paste data

  • AutoComplete feature

  • AutoFill feature

  • what is function

  • define Name

  • how to sort & filter your data in excel

  • how to create a simple chart with a few clicks

  • multiple worksheets

  • zoom function

Then we're going to go through several data visualization techniques which you can use to create Excel charts that will impress your audience.

Projects covered:

  • highlight max value dynamically on an Excel chart

  • discover Excel's conditional formatting feature to highlight key data in your table

  • how to create a map chart that reads well by the viewer

  • how to use icons in your bar charts to make it exciting

  • how to create a progress chart in infographic style

I dedicated an entire section to Excel shortcut keys showing you over 100 Excel shortcuts. The more keyboard shortcuts you know the faster you can work in Excel and more productive you can be.

Shortcuts covered in seven categories:

  • general shortcuts

  • shortcuts for navigation

  • shortcuts for data entry

  • Excel formatting shortcuts

  • selection shortcuts

  • shortcuts for formulas

  • miscellaneous shortcut keys

I created a section for the most frequently used Excel formulas/functions. You will find lots of real-world examples in these topics:

  • Relative vs Absolute cell references explained

  • working with date functions

  • SUM(), SUMIF(), SUMIFS() functions

  • MIN(), MAX(), AVERAGE(), COUNT() functions

  • VLOOKUP(), HLOOKUP() functions examples

  • INDEX(), MATCH(), XLOOKUP() functions to search data

In the last section we're getting into an advanced Excel topic. I explain how one of the most valuable Excel features works, the PivotTable. Many people are afraid to use it, but I'll make it simple for you. We're going to build several reports, and create a PivotChart too. I will also talk about database design principles. We will create a Data Model, and I will show you how to use PivotTable with multiple tables. So, you'll be able to use Excel as a real database.

By taking this course you can really take your Excel skills to way above the average.

Don't worry if you're an absolute beginner. I'll explain everything step by step.

If you're already familiar with Excel, this course is a great refreshing session, and I'm pretty sure I will be able to show you new, interesting things.

Please watch the Intro video to see what you can expect from this course. Enjoy learning!

Data Visualization in Excel: All Excel Charts and Graphs

25+ Excel charts and graphs - Data Visualization in Microsoft Excel - visualizing data with Excel 2007- Excel 2019

Created by Start-Tech Academy - 3,000,000+ Enrollments | 4+ Rated | 160+ Countries

"]

Students: 129407, Price: $19.99

Students: 129407, Price:  Paid

What are the chart types I will learn in this course?

Excel offers the following major chart types. All of these are covered in this course

  •     Column Chart

  •     Line Chart

  •     Pie Chart

  •     Doughnut Chart

  •     Bar Chart

  •     Area Chart

  •     XY (Scatter) Chart

  •     Bubble Chart

  •     Stock Chart

  •     Surface Chart

  •     Radar Chart

  •     Combo Chart

  •     Pivot Chart

  •     Sparklines

And many other creative ones :)

How are charts useful in Excel?

A chart is a tool you can use in Excel to communicate data graphically. Charts allow your audience to see the meaning behind the numbers, and they make showing comparisons and trends much easier.

What are the benefits of using charts in Excel?

Excel charts allow spreadsheet administrators to create visualizations of data sets. By highlighting a set of data within an Excel spreadsheet and feeding it into the charting tool, users can easily create various types of charts in which the data is displayed in a graphical way.

This course will answer all the questions that would pop up while you set to visualize your data using Excel charts such as:

How do you make Excel charts look better?

How do you format a chart in Excel?

What are the different elements of charts?

How do I make those awesome infographics that I see in fancy magazines and TV reports?

How do I create a comparison chart in Excel?

What is the best chart to use for comparison?

And many more...

How is this course different from other resources available online?

Most courses cover only teach how to draw different types of charts in Excel. The main point is missed. The main point of creating a chart is that you want to convey a message or tell a story using the chart. In this course, once you have learnt all the charting tools, you will also learn how you should create a chart. How you can highlight your message and avoid clutter in the chart, so that when your audience looks at the chart, the message is clearly conveyed to them.

Microsoft Excel – Data Visualization, Excel Charts & Graphs

Master 20+ Excel charts, build advanced Excel visuals & learn data analysis with a top Excel instructor (Excel 2016+)

Created by Maven Analytics - Award-Winning Analytics & Business Intelligence Training

"]

Students: 101316, Price: $149.99

Students: 101316, Price:  Paid

Hear why this is one of the TOP-RATED Excel courses on Udemy, and the #1 Excel Data Visualization course:

"Absolutely great stuff. I really enjoyed it! Chris is truly a Excel guru. I strongly recommend this course to all users looking to improve their skills with Excel charts & graphs."

-Nirav M.

"Excellent from start to finish! I picked up a bunch of Excel data visualization tips that will be useful in the workplace, including some very cool advanced Excel visuals and custom charts & graphs. Loved all of it, and hope I can learn more from this wonderful individual!"

-Robert C.

"At the first part I just said to myself, "Wow, Excel is capable of that? It's amazing!" Then at the second part I told myself "This guy is doing magic!", and now I feel like I'm capable of doing the same. I'm definitely buying his other Excel and data visualization courses!"

-Judit B.

__________

FULL COURSE DESCRIPTION:

Ask people what comes to mind when they think of Excel, and odds are they'll say "spreadsheets". The truth is, Excel is an incredibly powerful and dynamic data visualization platform for those willing to think beyond rows, columns, and primitive pie charts -- and I'm here to prove it.

This course gives you a deep, 100% comprehensive understanding of Excel's latest data visualization tools and techniques. I'll show you when, why, and how to use each Excel chart type, introduce key data visualization best practices, and guide you through interactive, hands-on demos and Excel exercises every step of the way.

__________

We'll kick things off by exploring each of the 20+ charts & graphs introduced in Excel 2016, including: 

  • Bar & Column charts

  • Histograms & Pareto charts (Office 365, Excel 2016 or Excel 2019)

  • Line charts & trend lines 

  • Area charts

  • Pies & Donuts

  • Scatter plots & Bubble charts

  • Box & Whisker charts (Office 365, Excel 2016 or Excel 2019)

  • Tree Maps & Sunbursts (Office 365, Excel 2016 or Excel 2019)

  • Waterfall & Funnel charts (Office 365, Excel 2016 or Excel 2019)

  • Radar & Stock charts

  • Heat maps, 3-D Surface & contour charts

  • Chloropleths & Geospatial maps

  • Custom combo charts & graphs

  • Sparklines

  • And more...

__________

From there we'll dive into a series of 12+ advanced Excel demos guaranteed to turn you into an absolute data viz rockstar. These aren't "textbook" demos that you can find on Excel YouTube channels; these are projects adapted from actual, award-winning work featured by Microsoft, MIT, and the New York Times. I've built my analytics career around data visualization, and I can help you do the same.

We'll cover advanced Excel data viz topics that you won't find anywhere else, including:

  • Custom image overlay charts

  • Automation with named ranges and OFFSET/COUNTA functions

  • Scroll & Zoom functionality with Excel form controls

  • Animated charts to visualize changes over time

  • Dynamic, custom Excel dashboards

  • Value-based chart formatting

  • Custom gauge charts & pacing charts

  • Grid visuals using Excel array formulas

Whether you're looking for a quick primer, trying to diversify your Excel skill set, or hoping to step up your Excel data visualization game in a major way, this course is for you.

See you there!

-Chris (Founder, Maven Analytics)

__________

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!

*NOTE: Full course includes downloadable resources and Excel project files, homework and course quizzes, lifetime access and a 30-day money-back guarantee. Most lectures compatible with Excel 2016, Excel 2019 or Office 365.

The Complete Microsoft Excel Pivot Tables and Pivot Charts

Excel Charts, Excel Analytics, Excel Pivot Table , Excel Pivot Charts, Excel Dashboard, Excel Data Analysis & Reporting

Created by A.M.A.M Mubeen (Expert In Tally & Finance & Microsoft Office) - 200,000+ Students | 4+ Rated | 190 + Countries

"]

Students: 73495, Price: $19.99

Students: 73495, Price:  Paid

Recent Student's Reviews

***It Is Very Helpful And Easy To Understand. I Have No Doubts Regarding Pivot Tables And Its Formatting After Going Through It. Thank You For The Wonderful Teaching And Technical Support. - Deepak Kumar Kanaujia***

***Very Detailed Illustration And The Instructor Knows Well How To Use His Tools. Happy To Attend This Course And I Believe I Am Gonna Use It A Lot In My Work. - Mohamed Eltantawi***

***Wonderful Course. I've Been Using Excel For Many Years. But, What I've Learned In This Course Is A Paradigm Shift. - Yousuf Saif Al Hinai***

***Wow! Its Amazing Pivot Tables Course. I've Lots Of Gap On This Topic. Now, I've Clear Concept. - Md. Anisur Rahmen***

Nine Reasons why you should choose this The Complete Microsoft Excel Pivot Tables and Pivot Charts Course

  1. Best Rated Course on Udemy

  2. You will learn various data analysis techniques using MS Excel

  3. Latest updated and Doubts Are Solved in this course

  4. Carefully designed curriculum By Proficient In Microsoft Excel Expert

  5. you can complete this course In Short time

  6. Pivot table & Pivot charts related examples and case studies Provided

  7. 06 Examples And  practice exercises Are Able to Download in The Recourse Section

  8. Your queries will be responded by the Instructor With In Short time

  9. A Verifiable Certificate will Be Provided On the Completion

Microsoft Excel's Pivot table and Pivot charts are  The Powerful Tools to Analysis And Manipulating the data . it helps to Analysis the data in different perspective to take importance and Essential decision making in the organization. The pivot tables and pivot chats help to calculate, summarize the data very quickly. Pivot Tables Allow to see comparisons, patterns, and trends by using our data. The Course Contents Eight Chapters & The Details As Below.

What is covered in this course?

CHAPTER -01 INTRODUCTION TO PIVOT TABLES & PIVOT CHARTS

  • Introduction To Pivot Tables & Pivot Charts

CHAPTER -02 FORMAT DATA FOR PIVOT TABLES IN EXCEL

  • Normalize The Data For Pivot Table

  • Convert Normal Data To Table

CHAPTER -03 CREATE PIVOT TABLE AND FORMAT VALUES IN EXCEL

  • Create The Pivot Table In Excel

  • Format Values In Pivot Table

CHAPTER -04 EXPAND AND COLLAPSE PIVOT TABLE IN EXCEL

  • Expand And Collapse Pivot Table In Excel

  • CHAPTER-05 REPORT FILTER AND REFRESH PIVOT TABLE IN EXCEL

  • Report Filter Pivot Table In Excel

  • Refresh Pivot Table In Excel

CHAPTER-06 CREATE DYNAMIC DASHBOARD & PIVOT CHARTS FROM PIVOT TABLES

  • Create Bar Chart -Clustered Bar

  • Create Column Chart -Clustered Column

  • Create Pie Chart - Doughnut Chart

  • Create Column Chart - 3d Column Chart

  • Create Line Chart- Line With Markers Chart

  • Insert Slicer

CHAPTER -07 MANAGING PIVOT TABLES

  • Connecting To An External Data Source

  • Creating A Recommended Pivot Table

  • Copy And Move Pivot Tables

  • Delete The Pivot Tables

  • Clearing & Reapplying Pivot Tables

  • Copy The Values Only From Pivot Table

CHAPTER-08 COMPLETE PIVOT TABLES AND PIVOT CHARTS EXERCISES WITH ANSWERS

  • Complete Exercises Questions One To Seven

  • Complete Exercises Questions Eight To Fourteen

  • Complete Exercises Questions Fifteen To Seventeen

Go ahead and click the enroll button, and I'll see you in Chapter 1!

Cheers

A.M.A.M.Mubeen

Ultimate Excel Training Course – Intro to Advanced Pro

Accelerate Your Career. Navigation Shortcuts, Formatting Tips, Functions, Formula, Charts, Graphs, Pivot Tables, Macros!

Created by Commerce Curve - Accelerate Your Career - Hands-on Finance/Accounting Courses

"]

Students: 60045, Price: $99.99

Students: 60045, Price:  Paid

15+ Hours of Ultimate Microsoft Excel Training from beginner to advanced. Take this Excel course and become proficient in Excel overnight. Taught hands on from a Silicon Valley CFO with advanced Excel financial modeling knowledge. Over 115+ lessons and examples are taught in this course to provide a practical and hands-on approach.

In this course you'll learn 100+ navigation shortcuts and formatting tips, how to write over 60+ formula in Excel, use functions, learn Excel macros, learn VBA, charts and graphs, and develop beautiful and advanced dashboards. As part of this course you will receive access to the full course materials including over 7 complete workbooks with over 115+ Excel worksheet lessons which accompany each lesson and contain the shortcuts, formula, and course explanations so that you can follow along on your own time. Each course section has it's own exercises so that you can test your knowledge.

Take this course if you're looking for a complete course with end-to-end Excel training. You can pick and choose which lessons you'd like to watch as each lesson contains its own worksheet and video to follow along.

There are 6 parts and a total of 8 workbooks as follows:

Excel Course Part 1 - Navigation & Formatting

Excel Course Part 1.1 - Navigation & Formatting - Data Set Example

Excel Course Part 2 - Functions

Excel Course Part 3 - Formula

Excel Course Part 4 - Charts & Graphs

Excel Course Part 4.1 - Charts & Graphs - Dashboards

Excel Course Part 5 - Pivot Tables

Excel Course Part 6 - Macros

Accelerate your career with our Ultimate Excel Training course today!

Microsoft Excel – Improve your skills quickly

Pivot Tables, Charts, Sparklines, functions, formulas and more - in just a couple of hours

Created by Phillip Burton - Best Selling Instructor - over 350,000 students so far

"]

Students: 49142, Price: Free

Students: 49142, Price:  Free

Welcome to this course about Microsoft Excel.

A lot of people use some of the features in Excel and just muddle through - not many use all of the functions.

In this course, I take my favorite features and functions, and show you how you can make your Excel life easier by using them.

  • Learn more about formatting, filters and conditional formatting.
  • Create tables, PivotTables, Chart, PivotCharts and Sparklines.
  • Find out how powerful Visual Basic for Applications (VBA) is.
  • And learn functions such as SUM, SUMIF, VLOOKUP, OFFSET and iNDIRECT - translated into 15 different languages.

In just a couple of hours, you can see how much time and frustration you can save knowing a few additional features - and you'll find out how much more you can learn.

Excellence in Excel! Create a dynamic block chart in Excel!

Excel by creating your own dynamic block chart in Excel. Discover advance dynamic chart displaying tactics in Excel!

Created by Nicky Wong - Data Analyst, Market Researcher, Data Visualizer!

"]

Students: 32883, Price: $19.99

Students: 32883, Price:  Paid

Excel, create by Doing!

  1. Are you looking for a useful Excel course where you truly learn something practical and create a valuable tool?
  2. Do you want to create those cool looking infographic block charts?
  3. Do you want to know a more impressive way to display data professionally?
  4. Do you want to see instantly the most value information by using a graph?
  5. Do you struggle with too much facts and tool less visuals?

If any of these are a yes, than this course is for you!

This course will teach you how to use Excel functions and create a useful block chart. Many people learn Excel functions and all the possible options that you can do with Excel. The real thing is that you will probably not use 80% of the power of Excel.

Excel is powerful but if you do not understand how to use it, your knowledge remains powerless. This course will show you how to use just a few functions and create in the meanwhile a very useful tool. This learning method is named CREATE BY DOING!

If you feel intimidated by Excel do not worry! The real issue is not Excel or You but by the method of learning it! Yes, the way you learn something can be successful or unsuccessful. This course uses the SPEED LEARNING methods of the learning cone. What is that? This is a method development make sure you truly remember 90% of everything you learn. How? Just by doing and following the exercises.

This course is active, and you have to do the exercises and follow along.

Yes you have to do something! I truly want to do it! Learning is 50% of the success! The other 50% is taking the necessary action to master what you learn. I will show you what I do and how you need to do it step by step. And I give you a challenge ACTION EXERCISE to challenge you to take action!

Why should I take this course? Your competitor has a bigger course!

I understand you point, but do you know the difference between have a toolbox and understanding to use just only 2 tools. I can teach you every tool you want that you can add all the tools in your toolbox. But would you be able to see the practical value out of it? I do not think so.

What if I give you just 2 tools, a screwdriver and a saw and teach you how to create a great piece of furniture? That would be 100% more valuable and that is what I do! I teach you to make useful tools that you can use for your personal life. By doing you create your furniture! That has a lifelong value!

There is a real difference between knowledge and power. Knowledge is only potential power, without the practical use of it, it becomes powerless. Power is the knowledge that you apply in your daily life! This course is powerful because you use the tools and put it into great use.

I never succeeded in Excel, is this course suitable for me?

Success is a path you walk. Learning Excel is exactly the same. Did you fail before; perhaps you took the wrong path. You learned from a bad teacher or a boring book. If you took the wrong path all you need is readjust your path and start walking again. This course truly is a very easy and slow paced course with much repetitions and exercises. The way to learn is by doing and by great explanations. This course has it both many times over!

Just check it and test it out for a month!

To make it even better, I offer this course as 30 day money back. This basically means that if this course is not right for you, you can get your money back in a blink of an eye. There is truly no reason not to do it and it has no risk at all.

Start taking actions right now and take this course. In life you have winners and losers. The winners take action at once and the losers keep on looking and waiting for the right time. In life there is never a right time except NOW! I truly belief you are winner because you are looking and reading this course.

Alright winner, it is time to take action! Click on “Take this course" and start making great pieces of Excel Furniture!

Microsoft Excel 2016 Beginners & Intermediate Excel Training

Excel 2016 for the office: Excel Formatting, Excel functions, Excel charts, Excel pivot tables made easy for you

Created by 365 Careers - Creating opportunities for Business & Finance students

"]

Students: 30720, Price: $129.99

Students: 30720, Price:  Paid

Do you want to learn how to work with Excel 2016?

Even if you don’t have any prior experience?

If so, then this is the right course for you!

A Verifiable Certificate of Completion is presented to all students who complete this course.

Microsoft Excel 2016 is here, and it promises to be one of the greatest versions that we’ve seen so far.

However, it’s essential that you learn how to work with it effectively.

If you want to become any of the following…

  • Executive Assistant

  • Office Clerk

  • Auditor

  • Accountant

  • Business Analyst

  • Financial Analyst

  • Credit Counselor

  • Sales Representative

  • Sales Manager

  • Financial Manager

  • Investment Banker

  • Real Estate Agent

  • Market Research Analyst

  • Financial Advisor

  • Business Operations Manager

  • Entrepreneur 

  • Someone who is involved with a business and would like to be successful

Then you simply have to learn Microsoft Excel 2016. There is no way around it.

But how can you do that if you have very limited time and no prior training? And how can you be certain that you are not missing an important piece of the puzzle?

Microsoft Excel 2016 Beginners & Intermediate Excel Training is here for you. One of the best Excel courses available on Udemy, it includes everything you’ll need. We will start from the very basics and then gradually build a solid foundation that will serve you well throughout your career.

What makes this course different from the rest of the Excel courses out there?

  • High quality of production – HD video and animated slides (this isn’t a collection of boring lectures!)

  • Knowledgeable instructor (experience in Big 4 Accounting + Commercial Finance)

  • Downloadable materials: The course comes with a complete set of downloadable materials (handouts, Excel files, etc.)

  • Extensive Case Studies that will help you reinforce everything that you’ve learned

  • Excellent support: If you don’t understand a concept or you simply want to drop us a line, you’ll receive an answer within 24 hours

  • Dynamic: We don’t want to waste your time! The instructor maintains a very good pace throughout the whole course

How come Microsoft Excel is so important?

Every large company uses it, right? So if you want to learn a new skill that is highly valued by all employers, you should start here.

Here are 5 more reasons why you should take this course and learn Excel:

  • Jobs. A solid understanding of Excel opens the door for a number of career paths

  • Promotions. Top Excel users are promoted very easily inside large corporations

  • Bill Gates knows how to work with Excel

  • Secure Future. Excel skills remain with you and provide extra security. You won’t ever have to fear unemployment

This course is suitable for people without any previous experience in Excel. We will start from the very basics and will gradually move on to some of the more advanced features, such as lookup functions, functions with conditions, goal seek, pivot tables, custom formatting, Excel 2016 charts, and other tools that are often used for the purposes of Financial Modeling.

Additionally, the course includes practical case studies that will reinforce everything that you learn. One of the exercises that we will see in the course consists of building a complete Profit & Loss statement from scratch.

This course is perfect for University students, Entry-level Finance, Business and Marketing professionals who would like to grow faster than their peers.

Please don’t forget that the course comes with Udemy’s 30-day unconditional money-back-in-full guarantee. And why not give such a guarantee, when we are convinced that it will provide a ton of value for you?

Enrol today and let's start this journey together!

Excel Charts – Visualization Secrets for Impressive Charts

Gain Highly Advanced Excel Skills to Create Impressive Excel Graphs for your Management Reports (Excel 2010)

Created by Leila Gharani - Microsoft MVP, Bestselling Instructor

"]

Students: 22678, Price: $89.99

Students: 22678, Price:  Paid

Without Doubt, With This Advanced Microsoft Excel Chart Course, You will be the Excel data Visualization star in your Department! 

Significantly Improve your Reports by using Advanced Excel Graph Techniques. 

This Course Includes:

  • Downloadable Workbook to follow the demonstrations (and use the charts as your templates).

  • Downloadable Exercise Book (answers included).

  • Full set of Cheat Sheets for download in Lecture 3. This PDF document is a quick reference guide for whenever you need to create any of the charts in this training.

If you use Excel to generate reports and graphs, my
hands-on Excel training provides you with an extremely advanced toolkit worth
of knowledge that will take the design of your Excel charts, tables and reports to the next
level. It will provide you with the best tricks to create dynamic charts.
It will save you tons of time of manually updating your Excel graphs on a monthly
basis. The visualization techniques introduce you to some unusual methods to
handle and create charts which will enhance readability of your reports as well
as impress your readers. 

Lauren says: "I wish she had more courses on advanced excel and access that are formatted like this one. She frames the content in ways that are applicable to my current job. I will be able to improve my current processes and project turnaround time as well as the look/feel of my tables and charts."

John says: "Leila does a fantastic job of walking you thru the process of creating various charts from scratch. From which formula to use to step by step chart creation. As a bonus you have actual exercises to practice your new skills, Absolutely one of the best instructional courses I have taken"

Paul says: "Course is clear, to the point and very dynamic. Excellent!"

Types of Excel Charts & Excel Graphs are presented:

The content and type of Excel charts presented are those that are typical to corporate reporting. Given my background in controlling, finance and project management, I designed the training with this audience in mind and the typical methods used to report, communicate, analyze, check and plan quantitative information.

If you are a student taking this course, rest assured that you are well equipped with advanced Excel visualization & chart design techniques to impress any employer who requires you to create graphs & reports in Excel.

Demonstration will be done using Excel 2010, but all methods will be compatible with older as well as future versions of Excel unless otherwise stated in the video. My main focus is to introduce you to new “methods” of doing things which you can do no matter which Excel version you have.

Why this course is different to other Excel courses:

I will not only demonstrate to you, but you
will be able to follow each demonstration in your own Excel workbook. To make sure you have understood the
techniques, you will complete an exercise at the end of each section (answers are included but you have to try on your own first).

I place great value on keeping the training not only informative but also interesting. I know technical courses can be boring, especially when taken online. For this reason, I have mixed screen-casts together with talking head and flip chart type of demonstrations to get it as close to a classroom training style as possible.

I have also been told by many students that I have the ability to explain complex topics in an easy to understand manner. I think you will benefit from that.

This course is split to 5 major parts:

  1. Methods to effectively communicate and present data trends – In this section I will also provide you with a crash course in best practices for table and graph design.

  2. Behind the scenes secrets of dynamic charts in Excel, where I introduce you to key functions you need to use to never manually update your Excel charts again –The functions you learn here go beyond graphs and charts. They enable you to do complex look ups in large data tables.

  3. Techniques that highlight Excel chart and table elements to direct the reader attention where it is needed most.

  4. New ways to compare performance: as in Actual data versus Budget, forecasts and previous year

  5. Effective Chart Combinations that are pivotal to management reports

This is an Excel Advanced Chart Course BUT you will be surprised how simple the techniques are once you know them!

Excellence in Excel! Make any chart dynamic in Excel!

Excel dynamic charts, a more efficient why to create 1 chart that displays many values by pressing a button in Excel!

Created by Nicky Wong - Data Analyst, Market Researcher, Data Visualizer!

"]

Students: 21993, Price: $19.99

Students: 21993, Price:  Paid

Excel, create by Doing!

  1. Are you looking for a useful Excel course where you truly learn something practical and create a valuable tool?
  2. Do you want to place more charts in Excel only to notice there is too less space in the tab?
  3. Do you want to make your data more clear and reduce the clutter in your spreadsheet?

If so, this course is for you!

This course will teach you how to use Excel functions and create dynamic charts. Many people learn Excel functions and all the possible options that you can do with Excel. The real thing is that you will probably not use 80% of the power of Excel.

Excel is powerful but if you do not understand how to use it, your knowledge remains powerless. This course will show you how to use just a few functions and create in the meanwhile a very useful tool. This learning method is named CREATE BY DOING!

If you feel intimidated by Excel do not worry! The real issue is not Excel or You but by the method of learning it! Yes, the way you learn something can be successful or unsuccessful. This course uses the SPEED LEARNING methods of the learning cone. What is that? This is a method development make sure you truly remember 90% of everything you learn. How? Just by doing and following the exercises.

This course is active, and you have to do the exercises and follow along.

Why should I take this course? Your competitor has a bigger course!

I understand you point, but do you know the difference between have a toolbox and understanding to use just only 2 tools. I can teach you every tool you want that you can add all the tools in your toolbox. But would you be able to see the practical value out of it? I do not think so.

What if I give you just 2 tools, a screwdriver and a saw and teach you how to create a great piece of furniture? That would be 100% more valuable and that is what I do! I teach you to make useful tools that you can use for your personal life. By doing you create your furniture! That has a lifelong value!

There is a real difference between knowledge and power. Knowledge is only potential power, without the practical use of it, it becomes powerless. Power is the knowledge that you apply in your daily life! This course is powerful because you use the tools and put it into great use.

I never succeeded in Excel, is this course suitable for me?

Success is a path you walk. Learning Excel is exactly the same. Did you fail before; perhaps you took the wrong path. You learned from a bad teacher or a boring book. If you took the wrong path all you need is readjust your path and start walking again. This course truly is a very easy and slow paced course with much repetitions and exercises. The way to learn is by doing and by great explanations. This course has it both many times over!

No risk to take a peak and try it out!

To make it even better, I offer this course as no risk. This basically means that if this course is not right for you, you can get your money back in a blink of an eye. There is truly no reason not to do it and it has no risk at all.

Start taking actions right now and take this course. In life you have winners and losers. The winners take action at once and the losers keep on looking and waiting for the right time. In life there is never a right time except NOW! I truly belief you are winner because you are looking and reading this course.

Press "Take this course" now!

Alright winner, it is time to take action! Click on “Take this course" and start making great pieces of Excel Furniture!

Excel Data Visualization for Business Analysts

Become an expert in data visualization using Excel as your canvas. Go past basic Excel charts to up your data vis game.

Created by Excel TV - Excel MVPs, Authors and Bloggers

"]

Students: 19847, Price: Free

Students: 19847, Price:  Free

Master Data Visualization Using Microsoft Excel

Whether you've just started working in Excel or you've been using it forever, chances are you've heard about data visualization and understand how important is. More than that, you've probably made a few charts you were proud of.

I was there, too. I could make any basic Excel chart my boss asked for. But I knew my charts - and many of those that I saw presented - did a poor job communicating data. Looking back, I think I was being asked to make charts just so we would have more to present.

Sound familiar? I've been where you are.

So I wanted to create a data visualization course for the business analysts who work with a lot of data and use Microsoft Excel regularly within their workflows. Chances are - you can already create a bar chart, a pie chart, and more. If that's you, read on.

Because I think a course for people like us has been missing. So I decided to distill everything I knew into a course that shows:

  • The important research behind which charts show the best information.

    That way you're always communicating the best results. And when your boss challenges you, you can point to the research. (Just point him or her to the module on why Pie Charts are the worst!)

  • How to create advanced charts not included in Excel.

    Most business problems can't be captured in Excel's native chart library. Do you know how to create Bullet Charts? Charts with multiple banding? This course will show you how.

  • How to create charts for analysis and how to create charts to tell a story.

    In this course, we'll talk about the difference between data graphics and info graphics. The former is for investigation, the latter for narration. You won't find this content elsewhere - I know, because I came up with it organically while working as a management consultant.

  • How to layout your charts and info graphics when you deliver them to executives.

    I'll introduce you to the camera tool, one of Excel's most powerful features. You'll see how it will allow you to drag-and-drop a chart, much like in Power BI.

  • Labs and Quizzes

    It's not enough to learn this information. You need to apply. I have created labs and quizzes based on the content. Take the quizzes to reinforce your knowledge. Complete the labs and then use them immediately in your own work.

  • No VBA or Macros

    I love VBA and Macros too but they're way over deployed. In many cases, the advanced chart you're thinking of making doesn't need lines and lines of code. I'll show you how quickly.

Here's what you can look forward to in this course: 

  • Data visualization principles including closure, proximity, common group and preattentive attributes

  • Theory and practice for why data visualization is so important

  • Why 3d charts cause issues when communicating data

  • Problems pie charts present to the audience

  • How to create charts with graded banding in Excel

  • How to create Bullet Charts in Excel

  • How to create Progress Meter Charts in Excel

  • How to create Waffle Charts in Excel

  • Microsoft Excel's camera tool

  • Resources to help you continue your learning

Like you, I work in the trenches, hustling to solve every new data challenge that comes my way. I wanted to create a course for people like me to learn from. If you want to stand out in the crowd and take your Excel and data skills to a whole new level, then you're the person I created this course for.

See you there,

Jordan

Microsoft Excel Pro Tips: Go from Beginner to Advanced Excel

Master 75+ Excel tips to build advanced Excel skills: formulas, pivot tables, charts, data analysis & data visualization

Created by Maven Analytics - Award-Winning Analytics & Business Intelligence Training

"]

Students: 19037, Price: $174.99

Students: 19037, Price:  Paid

COURSE DESCRIPTION:

This course is designed to transform everyday people into Excel POWER USERS.

It's not about comprehensive, 101-style deep dives into Excel's core capabilities, or about showing off cheesy, impractical Excel "hacks". It's about featuring some of the most powerful and effective tools & techniques used by Excel professionals, and sharing them through crystal clear demos and unique, real-world case studies.

Unlike most Excel courses, this one is non-linear and constantly evolving. This means that you can jump to different sections or individual lectures freely, and explore brand new Excel tips added on a regular basis.  Each video is designed to be an independent and self-contained Excel demo, to help you learn these tools and techniques in quick, bite-sized lessons.

The best part? I'm including a downloadable Excel workbook and solution file containing every single Excel demo and dataset covered in the course, ranked by difficulty (1-5 stars), organized by category, and hyperlinked for quick and easy access.

The Excel tips and techniques covered in this course fall into six core categories:

  • Excel Productivity Tips (navigation, flash fill, cell protection, advanced sorting & filtering, etc.)

  • Excel Formatting Tips (freeze panes, row/column grouping, advanced custom formats, etc.)

  • Excel Formula Tips (formula auditing tools, fuzzy lookups, detecting duplicates, randomization, etc.)

  • Excel Visualization Tips (sparklines, filled maps, custom templates, Excel form controls, etc.)

  • Excel Pivot Table Tips (slicers & timelines, custom layouts, value calculations, etc.)

  • Excel Analytics Tips (outlier detection, monte carlo simulation, forecasting, CUBE functions, etc.)

While the level of difficulty varies considerably, the Excel demos generally start simple and become progressively more complex within each section. There are no strict prerequisites for this course, but keep in mind that some demos may be challenging without a strong foundational knowledge of the underlying Excel concepts (like Excel Pivot Tables or formulas, for example).

It's time to start working smarter, not harder. If you're looking to maximize your efficiency, supercharge your productivity, and become an absolute Excel POWER USER, this is the course for you.

Join today and get immediate, lifetime access to the following:

  • 10+ hours of high-quality video

  • Downloadable PDF ebook

  • Excel project files & solutions

  • Expert-support and Q&A forum

  • 30-day money-back guarantee

Happy learning!

-Chris (Founder, Maven Analytics)

NOTE: Most Excel demos are compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019 or Office 365 (some may be unavailable in Excel for Mac or Excel Online)

__________

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!

See why this is one of the TOP-RATED Excel courses on Udemy:

"At first I just said to myself, "Wow, Excel is capable of that? It's amazing!" Then as I continued through the course I told myself "This guy is doing magic!", and now I feel like I'm capable of doing the same. I'm definitely buying his other Excel courses!"

- Judit Bekker

"One of the very best Excel classes I've taken - great instructor, awesome production, very comprehensive and exceptionally useful. Well worth your time if you want to become an Excel pro!"

- Ernie Atkins

"I've been using Excel for over 20 years and consider myself to be an Excel "power user". As with every single course by Chris, I go in with pretty solid knowledge of the material (formulas, VBA, Power Query, etc) and walk out twice as powerful as I walked in. This course is no different -- I PROMISE you, you will find absolute gems in this course. You will never regret an investment in your future with Maven Analytics!"

-Ryan Hughes

Microsoft Excel – Getting Started With The MS Excel Basics

Excel Formulas and Functions, MS Excel Charts and Graphs, Data Entry, Beginner Excel Training, Microsoft, Excel 2016

Created by Martyn Blythin - Data Minded Excel Training, 30,000+ students

"]

Students: 17757, Price: $34.99

Students: 17757, Price:  Paid

Microsoft Excel - Getting Started With The Basics, is an Excel Course where you can learn how to get the most out of Microsoft Excel, even if you are a complete Excel beginner!

You will learn all about MS Excel cells, Excel rows & columns, how to speed up your work with Excel spreadsheets and easiest ways of sorting & filtering data in Excel 2010 and onwards. We will explore some of the most popular Excel charts and graphs, and Excel formulas and functions and from there we will dive into best practices to make sure you know Excel Essentials for the real world.

"Useful and easy to follow. Great teacher. I'm self-taught on excel and have used for 17 years.... learning so much from this course that is already speeding up my work!"
-  G Wilkinson

"This course is exactly as described: a beginner's tutorial on the most basic and fundamental aspects of Excell. I haven't used Excel in almost a decade and needed a refresher to see if I still remembered the most important aspects, and while I definitely do, I also learned a lot of new and interesting tips and techniques (like different ways to force a worksheet to print on a single page). The instructor was articulate, friendly, and concise. This was a perfect "Basics" course!"
-  Vivian P.

"The pace of tutoring and interactivity made the information easy to understand."
- G Parker

As your instructor, I will use my experience of Excel training in some of the top UK companies to guide you step by step on your way of mastering the Microsoft Excel Basics.  Whether you're looking to do your job faster, wow your boss, step up your Excel data analysis game using Microsoft Excel or to improve your resume, you are in the right place.

Course access includes comprehensive workbook with examples, 1-on-1 tutor support, lifetime access and a 100% money-back guarantee!

"The pace of tutoring and interactivity made the information easy to understand."
- Garith Parker

  "Useful and easy to follow. Great teacher. Im self taught on excel and have used for 17 years.... learning so much from this course that is already speeding up my work!"
-  Graham Wilkinson

 Learning Excel is a bit like building a brick wall. Many beginners have a basic foundation - they understand the essentials of spreadsheets. Then they start piling on a few bricks here and there. But as their wall of knowledge is constructed, it's full of holes. Eventually they hit a point where their wall can't sustain any more weight and it collapses. What a waste of time! 

 This course takes a step-by-step approach to working with ms Excel. Each lesson builds upon the previous one, so your wall is solid. So whether you're looking to do your job better, or if you're looking to improve your resume, you are in the right place. 

 A comprehensive workbook with examples is included to save you time. You can also ask me any questions via the course discussion board. 

Beginners to Expert Excel and Excel VBA 38 Hours Mega Course

Learn Excel formulas, Pivot Tables, Excel VBA macros, charts and the basics with our Microsoft Excel 38+ hours tutorial

Created by Mach 42 Productions - Excel Consulting | 21,000+ Students

"]

Students: 15848, Price: $19.99

Students: 15848, Price:  Paid

This comprehensive 38 hours+ Microsoft Excel and Excel VBA course includes content from our Mach 42 Productions Excel courses 1 through 11 and our IT careers course, to take you from beginner to expert level:

  • Excel Course 1- Step By Step Beginners Excel

     

  • Excel Course 2- How To Use Excel comments

     

  • Excel Course 3- Excel Charts And Tips To Make Better Charts

     

  • Excel Course 4- How To Make Waterfall Charts

     

  • Excel Course 5 - Advanced Excel Charts

     

  • Excel Course 6- Automated Excel Charts And Tables

     

  • Excel Course 7- Learn How To Use Excel Text Functions

     

  • Excel Course 8- Advanced Excel tips

     

  • Excel Course 9- Quick Excel Tips For Excel Reports

     

  • Excel Course 10- Advanced Excel Skills And Career Tips

     

  • Excel Course 11- Spreadsheet Protection

     

  • 8 Ways to Further your IT Career

If you are enrolled on any of our above courses, please bear this in mind before considering this one.

 

Our in-depth Excel syllabus takes you from beginner level to advanced level in Excel and will help build you a solid understanding of Excel and use it effectively in your work. Over 38 hours of Excel content is provided in this course including:   

  • How to use the basics of Excel e.g. create new worksheets, copy, cut and paste, the Excel ribbon and how to print documents properly

     

  • How to sort, find and replace Excel data quickly

     

  • How to understand, write, use, audit formulas and coverage of Excel text functions, maths operators and advanced functions including vlookup via worked examples/case studies. We provide hours of material on this to build your confidence levels (11 sections)   

  • Coverage of Excel charts from beginner level to advanced automated charts. We cover charts such as bar charts, line charts, waterfall charts and funnel charts. We also provide tips on how to make better charts.

  • A thorough grounding in Excel Pivot Tables- from scratch. This tool alone can save you a lot of time in your data work.   

  • Essential Excel tips to boost your work and help you make better Excel reports e.g. how to watermark Excel sheets

     

  • How to protect your Excel spreadsheets using Excel’s security model.

  • Excel VBA- We teach from ground up Excel’s powerful VBA programming language which can be used to automate tasks, clean up data (very fast) and overall increase your productivity. Our VBA learning culminates in building real life (and actually useful) programs/macros which you can use in your everyday work. Further the skills taught will enable you to build your own macros. All the source code is provided in our examples in addition to testing your knowledge with assignments and tasks. We have over 7 hours of lecture videos covering Excel VBA.   

  • Excel career tips- Advice on how to write Excel examples for your CV/Resume

Full support is given on this Excel course by means of our course discussion forum, lecture quizzes and tasks/activities are provided right from the start of the course. All Excel workbooks used in the lectures are provided too.   

Remember by picking up essential Excel skills, you can significantly increase your productivity, save time and money and furthermore be confident that you can use one of the most popular office business tools today.

Excel Charts and Graphs : Master Data Visualization

Master the art of Data Visualization by creating informative charts in Excel which deliver clear & concise message

Created by Start-Tech Academy - 3,000,000+ Enrollments | 4+ Rated | 160+ Countries

"]

Students: 13226, Price: Free

Students: 13226, Price:  Free

What are the chart types I will learn in this course?

Excel offers the following major chart types. All of these are covered in this course

  •     Column Chart

  •     Line Chart

  •     Pie Chart

  •     Doughnut Chart

  •     Bar Chart

  •     Area Chart

  •     XY (Scatter) Chart

And many other creative ones :)

How are charts useful in Excel?

A chart is a tool you can use in Excel to communicate data graphically. Charts allow your audience to see the meaning behind the numbers, and they make showing comparisons and trends much easier.

What are the benefits of using charts in Excel?

Excel charts allow spreadsheet administrators to create visualizations of data sets. By highlighting a set of data within an Excel spreadsheet and feeding it into the charting tool, users can easily create various types of charts in which the data is displayed in a graphical way.

This course will answer all the questions that would pop up while you set to visualize your data using Excel charts such as:

How do you make Excel charts look better?

How do you format a chart in Excel?

What are the different elements of charts?

How do I make those awesome infographics that I see in fancy magazines and TV reports?

How do I create a comparison chart in Excel?

What is the best chart to use for comparison?

And many more...

How is this course different from other resources available online?

Most courses only cover only teach how to draw different types of charts in Excel. The main point is missed. The main point of creating a chart is that you want to convey a message or tell a story using the chart. In this course, once you have learnt all the charting tools, you will also learn how you should create a chart. How you can highlight your message and avoid clutter in the chart, so that when your audience looks at the chart, the message is clearly conveyed to them.

The course is created on the basis of three pillars of learning:

  1. Know (Study)

  2. Do (Practice)

  3. Review (Self feedback)

Know

We have created a set of concise and comprehensive videos to teach you all the Excel related skills you will need in your professional career.

Do

With each lecture, we have provide a practice sheet to complement the learning in the lecture video. These sheets are carefully designed to further clarify the concepts and help you with implementing the concepts on practical problems faced on-the-job.

Review

Check if you have learnt the concepts by comparing your solutions provided by us. Ask questions in the discussion board if you face any difficulty.

Lookup Functions, Advanced Charts and Pivot tables

Excel charts and pivotes made it easy

Created by MKCL India - Creating a Knowledge Lit World

"]

Students: 11553, Price: Free

Students: 11553, Price:  Free

Graphics, images, and charts are great ways to visualize and represent the data, and Excel does exactly same thing for us by automatically creating the charts. After you enroll and complete this course, you will be proficient in all kinds of charts in Excel: Bar Charts, Column Charts, Line Charts, Pie Charts, Area Charts, X Y Scatter Charts, Bubble Charts. You will be able not only to create these charts in Excel, but also to format them quickly and easily.

This course also provides an in-depth coverage of pivot tables and pivot charts. These are two of the powerful data analysis tools in Excel's arsenal, and they should definitely be mastered by anyone who aspires to becoming an Excel “power user. Pivot Tables and Pivot Charts allow you to dynamically reorganize and display your data in many different ways and they help you get meaningful information from large amounts of data.   

Microsoft Excel – From Excel Beginner to Excel Expert

Learn Pivot Tables, Formulas, Charts, Data Analysis, Dashboards, VBA, Macros & More for Excel 2010, 2013 or Excel 2016

Created by Martyn Blythin - Data Minded Excel Training, 30,000+ students

"]

Students: 11099, Price: $59.99

Students: 11099, Price:  Paid

Just imagine what it would feel like if using Excel was effortless - if you could create charts, functions, and analyse data with ease. Becoming an Excel expert isn't about learning what every button and every formula does - it's about learning methods you can use over and over again to effortlessly clean, enrich and analyse data.

I bet your a bit like me, you've tried learning through trial and error, but it takes a long time and involves a lot of mistakes along the way! I've been using Excel for over 15 years and there's still a few functions I've never used. The good news is that you can become an Excel expert in just a few hours by learning the right tools and approaches to use. How would it feel to have those skills on your resume and at your next job interview?

So, you want to become an Excel expert but you don't want to overwhelm yourself with stuff you're never going to use and you need the skills for your job, or the next job you hope to get. As I see it, you have three options. First, you could take a classroom based course and try to learn it all in a day, but from experience I know many people who have just been overwhelmed with the amount of information and the pace of learning. Second, you could do absolutely nothing, stay exactly where you are right now with your Excel skills. Or third, you could give this a try, work it alongside your current job and be genuinely good at Excel within a week or two.

We designed this Microsoft Excel - Excel from Beginner to Advanced using feedback received from over 30,000 students over years who told us they wanted opportunities to advance Excel skills. This course has it all, including:

  • Downloadable challenges to test your knowledge.

  • Multiple choice quizzes at the end of each module.

  • Each lesson has a downloadable Excel file containing the examples used.

  • Cheat sheets for functions & excel keyboard shortcuts that you can have at your desk for reference.

  • Ask me any Excel question on the course message boards.

  • A certificate of completion at the end of the course.

The course covers all levels, from beginner to advanced, so you don't have to worry about if the course is right for you, and you don't have to buy multiple courses for each level of your Excel knowledge! The course is split into 6 core modules:

  • Module 1: Master The Basics - Useful excel for beginners, including Excel fundamentals

  • Module 2: Your Data Gameplan - cover how to organise your data including Excel filters

  • Module 3: Your Functions Toolkit - Learn Excel advanced formulas and functions

  • Module 4: Your Data Analysis Strategy - The Complete Microsoft Excel Pivot Tables and Pivot Charts including Excel pivot table basics and data analysis Excel

  • Module 5: Your Dashboard Playbook - Learn how to create an Excel Dashboard

  • Module 6: Your Excel Automation Machine - Learn how to create an Excel macro and use Excel VBA code to automate your work. Excel vba programming is an extremely powerful tool, once you know the basics.

The course also comes with everything you'd expect from a great online course, including:

  • Lifetime access to the material

  • Unlimited free updates to the course

  • 30 day money back guarantee

If you're prepared to give this a try, then we're certain you will see the results as early as the first day you try it.

Here is what students said about this Excel course:

"Love the tips. Best practices quite relevant and to be kept in mind. Also, there are quizzes to test your understanding of the previous lessons as well as links to the lectures for the answers that you missed. I love this course. Highly recommended!"

- Mary J. de Guzman

"This is a really great course. He started at what I would definitely consider an intermediate Excel level--and I even learned some things during that part--and then took us well into advanced Excel, as promised. Martyn was also very responsive, answering in-depth questions I had, even when they were beyond the scope of the course."

- Randy Crane

"Thoroughly enjoyed the course as it was very well paced. Bite-sized yet providing clear concise detailed instructions that I could follow the activities in a separate local spreadsheet and learn by doing. Good clarity in speech and good examples help. Martyn also reverts back quickly if you have a question or suggestion."

- Kaushal Vyas

Who is this course for?

This course can be used whatever your industry - anything from Excel for Accounting and Bookkeeping to excel for investment banking or Excel for data science. Anyone who is looking to achieve excellence in Excel and advance excel skills at work and on their resume.

Excel certification

Although this course does not issue an official microsoft excel certification, it includes a Udemy certificate of completion which you can use to illustrate your Excel skills on your resume and in interviews.

Excel Charts & Graphs and SmartArt Graphics for Beginners

Learn to visualize data using Excel Charts and Graphs and SmartArt Graphics. Build 7 Charts that you use your daily work

Created by Kawser Ahmed - Founder ExcelDemy.com | Data Analyst

"]

Students: 7313, Price: $39.99

Students: 7313, Price:  Paid

Teaching 11 Courses on Excel and Data Analysis!

OVER 25,000 visitors visit my blog ExcelDemy dot com every month!!

OVER 15,000 successful students have already taken my online courses since November, 2015 with 375 total Reviews!!!

Course Updated:  Nov 01. 2016

Excel is probably the most commonly used software in the world for creating charts. And charts are the main tools to visualize the insights from some numbers. Welcome to this Excel Charts and Graphical Objects learning course.

Let’s discuss now what you will learn from this course.

Basics of Excel Charts: At first you will learn the basics of Excel charts: how to create them quickly and how to choose the right chart type for your data.

Advanced Chart Techniques: Then you will work with the advanced tools within different task panes to work with excel charts.

Build some useful Excel charts: Then I will show you how to build some useful excel charts like: Combo Chart, Picture Chart, Thermometer Chart, Gauge Chart, Comparative Chart and finally the Gantt chart.

Graphical Objects: Then we shall work with Graphical objects. Graphical objects have many uses when you will present your data for an audience.

Here is not the end of the course. Time to time, I shall add more lectures to the course that will teach you how to face real life data visualization using Excel Charts and Graphical Objects.

By the completion of this training course, you will be fully versed in creating and using Excel charts. So, if you are interested to learn Charts and Graphical objects in Excel, then this course is for you. Thanks for reading. Enjoy the course!

Learn Microsoft Excel Charts (Basic to Advanced)

Create awesome charts in Microsoft Excel

Created by Rahim Zulfiqar Ali - Chief Executive Officer at Excel Basement (Private) Limited

"]

Students: 6372, Price: Free

Students: 6372, Price:  Free

Learn to create awesome charts in Microsoft Excel. In Microsoft Excel, a chart is often called a graph. It is a visual representation of data from a worksheet that can bring more understanding to the data than just looking at the numbers. A chart is a powerful tool that allows you to visually display data in a variety of different chart formats such as Bar, Column, Pie, Line, Area, Doughnut, Scatter, Surface, or Radar charts. With Excel, it is easy to create a chart.

Excel Data Analytics With Pivot Tables & Pivot Charts – 2021

Data analysis excel, data analysis, Pivot Chart, Microsoft excel, advanced excel, ms excel, Data Analytics, Excel, Data

Created by A.M.A.M Mubeen (Expert In Tally & Finance & Microsoft Office) - 200,000+ Students | 4+ Rated | 190 + Countries

"]

Students: 6329, Price: $19.99

Students: 6329, Price:  Paid

Eight Reasons why you should choose this Excel Data Analytics With  Tables and Pivot Charts Course

  1. You will learn various data analysis techniques using MS Excel

  2. Latest updated and Doubts Are Solved in this course

  3. Carefully designed curriculum By Proficient In Microsoft Excel Expert

  4. you can complete this course In Short time

  5. Pivot table & Pivot charts related examples and case studies Provided

  6. Practical Examples And practice exercises Are Able to Download in The Recourse Section

  7. Your queries will be responded by the Instructor With In Short time

  8. A Verifiable Certificate will Be Provided On the Completion

Excel Pivot Tables & Pivot Charts are an absolutely Fundamental tool for anyone working with data in Excel. Pivots Table allow you to quickly explore and analyze raw data in Excel. It is powerful tools to analyze Excel Data in Different perspective. Excel Pivot Tables provide fast, accurate and intuitive solutions to even the most complicated analytics questions.

This course gives you a deep & comprehensive understanding of Excel Pivot Tables and Excel Pivot Charts. I'll show you how to use Excel Pivot Tables & Pivot charts and introduce advanced sorting, filtering, and calculation tools, and guide you through interactive, hands-on demos and Excel exercises every step of the way. After Completing This Course Your Are Able To Create Interactive & Visually Effective Pivot Charts Based On Your Pivot Table.

What is covered in this course?

Chapter -01 Introduction Of Data Analytics With Pivot Tables & Charts

  • Introduction Of Data Analytics

  • Introduction Of Pivot Table And Pivot Charts

Chapter -02 The Five Steps For Data Analytics With Pivot Tables And Charts

  • The Five Steps For Data Analytics With Pivot Table And Pivot Charts

  • Chapter -03 Pivot Table & Pivot Chart Example -01

  • Data Analytics With Pivot Table & Pivot Chart Example-01

Chapter -03 Data Analytics With Pivot tables & Pivot Charts Example -01

  • Introduction Of Data Analytics With Pivot tables & Pivot Charts Example -01

Chapter -04 Format The Raw Data For Pivot Tables (Step 01)

  • Format The Raw Data For Pivot Tables

  • Insert New Column

Chapter -05 Convert The Raw Data To Table (Step 02)

  • Create Pivot Table By Using Range

  • Convert Raw Data To Table

  • Modify The Table

Chapter -06 Create Pivot Tables (Step-03)

  • Create Pivot Table

  • Create Recommended Pivot Table

  • Change Pivot Table Name & Design

  • Pivot Table Builder & Clear & Rearrange

  • Copy , Move And Delete The Pivot Table.

  • Creating Groups In Pivot Table – Date Group

  • Creating Groups In Pivot Table – Number Group

  • Custom Calculation In Pivot Table.

  • Sorting , Filtering In Pivot Table.

  • Working With Slicer.

  • Update The Data In Pivot Table.

Chapter -07 Create Pivot Charts (Step-04)

  • Create Pivot Table For Pivot Chart

  • Create Line Charts.

  • Create Bar Charts.

  • Create Column Charts.

  • Create Pie Charts.

  • Insert Slicers & Connect With Reports

Chapter -08 Analysis The Pivot Table & Pivot Charts (Step-05)

  • Analysis The Pivot Table & Pivot Charts

Chapter -09 Pivot Table & Pivot Chart Example-02

  • Introduction Of Question

  • Answer Question 1 & 2

  • Answer Question 3

  • Answer Question 4 & 5 & 6

  • Answer Question 7

  • Answer Question 8

Ultimate Excel Waterfall Chart Course

Impressive Excel Waterfall Charts for Your Reports - From Scratch. No Add-ins, No VBA - For ANY Excel Version!

Created by Leila Gharani - Microsoft MVP, Bestselling Instructor

"]

Students: 5137, Price: $94.99

Students: 5137, Price:  Paid

Want to Include impressive Waterfall / Bridge Charts in your Corporate Reports?

Waterfall graphs or bridge charts provide great visualizations for Management Reports.

In this course you learn how to include different variations of the Waterfall Chart in your reports. No VBA or Add-ins are required.

The best part is you can use ANY version of Excel too. 

You'd like to impress your Management and colleagues by introducing new techniques to create simple and effective Waterfall charts? Then this course is for you!

Course includes:   

  • Downloadable Excel Workbook of all Waterfall Charts covered. Feel free to use these as your Waterfall Templates.   

  • Cheat Sheets in PDF format as your Quick Reference Guide for the future.

 Why use a Waterfall Chart?

A waterfall chart or a bridge chart is a very liked chart by Management. For good reason too. They provide an effective way of visualizing your data that helps you understand how you got from one balance to another balance. They are common for financial figures – they allow you to see the profit development – how you got from gross sales to net income or how your earnings developed from last year to this year. But they are also a good story teller for non-financial data.

Do you use Excel add-ins for your Waterfall or struggle with your data preparation?

Many people use Excel add-ins to create the Waterfall chart. Why? Because they save on the frustration and headache that comes with preparing the data properly for the charts. On the downside, sometimes add-ins can't do exactly what you'd like and for some charts you might want to do it from scratch. You might also be interested to find out what the best method is for creating Waterfall charts from scratch in Excel. If you are, this is the right course for you!

Waterfall Charts Covered

  • Excel 2016 Waterfall chart (for those that have Excel 2016)

  • The most flexible method to create the Waterfall chart (for any Excel version)

  • How to tweak the Waterfall chart for presentation purposes, e.g. long category labels can result in an "untidy" look for the chart and divert attention from your message, adding dynamic, moving arrows that reflect the total difference between end and beginning values, etc.

  • Vertical Waterfall chart - bar Waterfall version - (for any Excel version)

  • and much more - new lectures will be added to address different business issues

Excel Version

You can take this course no matter which Excel version you have. The course is done on Excel 2016 but you can follow along on your version as well. Everything can be recreated in older version of Excel – 2007, 2010 & 2013, except of course the new Excel 2016 waterfall chart. Whenever I use a technique that’s available from a specific Excel version, I do state it in the video. You don’t need to worry about compatibility when you share your charts. Something you need to worry about if you use Excel 2016 standard waterfall chart.

Praise for Visualization Secrets for Impressive Reports 

"She frames the content in ways that are applicable to my current job..." -- Lauren Brown, Udemy Student

"She has me thinking of different ways to organize my data...and to better present my results to my readers..." -- Robert Goodman, Udemy Student

"I have purchased several courses on this topic from Udemy, but this is by far the best..." --Merchant, Udemy Student

"Every video I learn something new." -- Darshan Patel, Udemy Student

"Leila does an excellent job to show how to easily update graphs dynamically, and best visualize your data..." -- Ugur, Udemy Student

"Course is clear, to the point and very dynamic. Excellent!" -- Paul Guirlet, Udemy Student

Excel Charts – Excel Charts and Graphs Basic Training

Learn how to use Excel 2013 to create impressive data visualizations - ExcelChart and Graphs Basic Training

Created by R-Tutorials Training - Data Science Education

"]

Students: 4815, Price: $19.99

Students: 4815, Price:  Paid

Do you work with charts but struggle to identify which chart to use?

Are you new to data analysis?

Do you want to learn about the charting options Excel 2013/2010 offers?

Are you looking for a structured way to learn about the Excel charting tools?

If your answer was YES to some of the questions, this course might be of interest to you.

When I created this course I put full emphasis on a structured and didactically sound way to gently show you how data visualization in Excel 2013 works. This course is especially suited towards a beginners audience to data visualization with Excel.

Most of the concepts of this course also apply to Excel 2010, so you might also consider this course if you are on 2010.

Beginners to data analysis often need a clear understanding of which chart type is suitable for a given dataset. I will give you this important knowledge right at the beginning so that you know from the start what you are dealing with and how you can utilize that knowledge.

I will also show you step by step all you need to know about the basic chart formatting tools. You will learn how to add elements, format axes, change colors and so on.

There is also a section about the frequently used types of charts and how you can easily create them in Excel.

At the end of this beginners course you should be confident in using Excel for standard charts. You will be also able to format already existing charts and tailor them in accordance with your needs.

I highly recommend to take a close look at the introductory videos on which type of chart to use for a given circumstance. Only if you know which chart type is suitable for a dataset will you be able to make full use of the many options Excel has to offer.

Excel Charts – Online Training

Charts - Thermometer Chart, 2-axis Chart, Exploded Pie Charts, Trendline, 80:20, Tips-n-tricks

Created by Rishabh Pugalia - CA | ex-KPMG, ex-J.P. Morgan | Taught @ PwC, EY, Deloitte

"]

Students: 4162, Price: $24.99

Students: 4162, Price:  Paid

CA. Rishabh Pugalia (Founder, Excel Next) presents a crisp Online Training Program on Excel Charts.

The program covers popular charts like Thermometer Charts, Exploded Pie Charts, 2-axis Charts, 80:20 Stacked Column Charts, Trendline in addition to intricate settings and shortcuts.

The accompanying eHandBook will help you recollect the steps to make these Special Charts and it also enumerates the key application areas. In other words, when to use which chart.

His training program on Advanced Excel can be accessed from this UDEMY link - Click Here.

Excel Charts, Graphs & Data Visualization in Excel

Master 20+ Advanced Dynamic Excel Charts and Create Impressive Excel Graphs & Data Visualization in Microsoft Excel

Created by Andreas Exadaktylos - Best Selling Teacher | Msc Computer Scientist

"]

Students: 3467, Price: $99.99

Students: 3467, Price:  Paid

Have you wasted your time searching countless hours for YouTube videos, trying to find useful content about Excel Dynamic Charts? What if you could learn how to make designer-quality Excel Charts and Graphs in a few hours?

Think about what your Excel charts look like if you could follow a concise and practical go-to guide course for creating Advanced Graphs and Data Visualizations in Excel.

While Excel offers dozens of chart types and hundreds of formatting options, making the right Chart is tough. The adage "A picture is worth a thousand words" is also related to Excel Charts. A good Chart can clearly tell the story in your data.

What this course is about:

In this course my goal is to give my students the practical knowledge, with real-world examples and step by step instructions, to create designer-quality Charts in Excel.

As a bonus I've included all the Excel Templates plus Sample Files plus Cheat Sheets for every section.

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.

Here is what you'll get:

  • How to select the correct Excel chart type for your data.

  • The most important elements of a Microsoft Excel chart, like chart and plot area, Design and Format tab, data labels, gridlines, legends, titles, axes, layouts and much more

  • Modifying an Excel Graph visually: styles and colors, create a pictograph, shapes, effects, text etc.

  • Basic Excel Charts like Column charts, Bar charts, Pie charts, Line charts.

  • Advanced Excel Charts like Speedometer, Pareto, Gantt, Thermometer and Bullet Chart

  • Updating and printing charts

  • Bonus material: Excel templates + Sample files + cheat sheets

  • Bonus Lecture : Excel most useful shortcuts etc

Only basic prior experience in Microsoft Excel or Spreadsheets is required to get the most out of this Excel course.

At the end of this Microsoft Excel class you will be given a Certificate of Completion.

So what are you waiting for? Begin creating the kind of charts you want and enroll now!

Thank you and I'll see you inside the course.

Advanced Excel – Beginner to Ninja level (includes Charts)

Learn Excel Online for MIS Reporting, Data Cleaning, Data Analysis, Charting, Time-saver tricks with Examples

Created by Rishabh Pugalia - CA | ex-KPMG, ex-J.P. Morgan | Taught @ PwC, EY, Deloitte

"]

Students: 2767, Price: $99.99

Students: 2767, Price:  Paid

"Advanced Excel Ninja" is a comprehensive online training program on Microsoft Excel. It is divided in 12 sections and covers exhaustive list of topics. There are 90+ tutorial videos and the duration is 13 hrs. Topics often ignored in other advanced online programs have been included. Demo Preview Lecture 89 and 90 to find the difference.

  • VLOOKUP() with MATCH()
  • HLOOKUP() with MATCH()
  • INDEX() with multiple arrays & two MATCH()
  • Using TRANSPOSE() formula
  • Form Control Buttons for Dashboard
  • SUMIF() vs. SUMIFS()
  • SUM() vs. SUBTOTAL() while using Filter
  • Hidden Text-to-Columns tricks
  • Using IFERROR() vs. IF() + ISERROR()
  • Applications of INDIRECT() and OFFSET()
  • Pivot Table tricks on calculating automatic sum, count, percentage and generating grouped data headings
  • 3-Data Consolidation
  • Power of "GO TO - Special" along with Ctrl+Enter
  • Using "Find and Replace" with wildcard characters
  • Combo techniques for Data cleaning
  • Formula-based Conditional formatting
  • Charts - Thermometer, 2 axis, Trendline, Axis value settings
  • Inserting Picture in Comments... and the list of such tricks is very long

So if you intend to take your Excel application skills multiple notches higher, gain from the experience of a training instructor who -

  • Is a qualified Chartered Accountant
  • Has worked with KPMG and J.P. Morgan
  • Has trained 12,500+ professionals (Apr 2010 - June 2016) in face-to-face training programs
  • Has incorporated in this online program 100s of tip-n-tricks, which he has acquired over the years through various forums, experimentation, problem solving challenges and training interaction

And by the way he has conducted more than 200 (two hundred) workshops for one of the Big Four firms, where the participants are from numerous departments and domains. The insights acquired have been meticulously incorporated in to the program.

Instructor: CA. Rishabh Pugalia, Founder, Excel Next

The participants will be provided lifetime access to videos plus downloadable Excel Case Studies and picture-based HandBook (PDF).

Complete Introduction to Excel Pivot Tables and Pivot Charts

Learn to analyze & summarize data in seconds using Excel's most powerful data feature - Pivot Tables & Pivot Charts!

Created by Ian Littlejohn - Excel Power Tools, Power BI and Google Data Studio Trainer

"]

Students: 2509, Price: $99.99

Students: 2509, Price:  Paid

Recent reviews:

"I would rate the course a 4.8 out of 5.0 I Iike the fact that the instructor applies pivot tables to business situations. I love that he gives a video solution to all the problems and not just give the answers He shows us how to solve the homework. BUY HIS COURSE!"

"I just passed my Excel 70-779 test to complete my BI Solutions MCSA . Thank you Ian...watched all your videos on here for both tests."

"Really good informative course, at the right pace, I'm substantially increasing my excel know for data and pivot tables, I would highly recommend."

**** Life time access to course materials and practice activities. ****

This course is lead by Ian Littlejohn - an international trainer, consultant and data analyst with over 125 000 enrollments & 100 000 students on Udemy. Ian specializes in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI, Google Data Studio & Amazon Quicksight & his courses average over 4.5 stars out of 5. 

Skills in data analysis, reporting and the creation of dashboards are HIGHLY valued in today's business environment. Excel is now recognized as the most commonly used data analysis tool in the world for the development of reports, data analysis and dashboards.

In this course you will learn the INCREDIBLE power of Pivot Tables to analyze and summarize data in seconds.  Pivot Tables are without doubt the most powerful feature in Microsoft Excel. 

In this class (the last module of my 3 part "Excel Master Class" Series), you will cover:

  1. Introduction and Course Content

  2. Creating Pivot Tables

  3. Methods of Aggregation and Grouping

  4. Trend Analysis

  5. Filtering and Slicing Pivot Tables

  6. Show Value As Calculations

  7. Frequency Analysis

  8. Conditional Formatting

  9. Interactive Dashboards

  10. Excel and Power BI

We look forward to having you on our course as we learn and explore the incredible power of Excel Pivot Tables and Pivot Charts.

Please note that this course is the third course in a series of three courses for the Excel Master Class series.  Search for my instructor profile to purchase these other courses.

  1. Course 1 - Power Query - Prepare and Transform Data

  2. Course 2 - Power Pivot - Data Modeling and DAX Formulas

  3. Course 3 - Pivot Tables and Pivot Charts

Master Business Reporting with Pivot Tables & Charts – Excel

Master Excel Pivot Tables with your highly experienced trainer. Excel 2010, Excel 2013, Excel 2016, Office 365.

Created by Rushabh Shah - Product Manager, Blogger, Entrepreneur

"]

Students: 77, Price: $74.99

Students: 77, Price:  Paid

Whether you are a Freelancer, a StartUp, an Established Business, or even if still working on a new Business Idea, Pivot Tables can do brilliant magic for you! Decision making will become so much easier and faster!

In this course, learn how to use Pivot Tables & Charts Super Effectively and create meaningful, actionable Reports for your Business, in a flash!

Why should you invest your time in learning pivot tables in-depth? 

Pivot Tables in Excel is one tool that will give you the power to analyze data in an unbelievable and quick manner! Instead of using tons of formulas and spending time in creating error-free formaulas, using Pivot Tables, your report will be ready in no time! ;-)

Case Scenarios we will use to learn everything

  • T-shirt Sales dataset
  • Facebook posts analysis
  • Warehouse inventory analysis 

What all will you learn (completely hands-on) in this course?

  • Good versus Bad Data data structures (what works, what doesn’t)
  • Create single & multilayer pivot tables
  • Display options
  • Custom Sorting & Filtering
  • Copying, Moving & Deleting quickly
  • Drilldown
  • Summarizing values in various ways
  • Showing values differently to make more sense out of data
  • Applying Pareto's 80/20 principle
  • Ranking
  • Grouping
  • Report filter & pages
  • Calculated Fields
  • Securing your Pivot Tables
  • GETPIVOTDATA function's awesome applications
  • Pivot Charts
  • Connecting slicers & timelines
  • Build your 1st DASHBOARD! No programming required!
  • 2 awesome real-life data Projects
  • SURPRISE BONUS!

_________________________________

This is what our Participants have to say:

“The training provided by Rushabh Shah was excellent. His understanding of the subject is very deep and his methodical approach to train his participants ensures that the learning imparted will never be forgotten.”
- CA Mihir Sheth, Managing Director - Vision 3K Technologies (I) Pvt. Ltd.

“Rushabh is an excellent trainer. Not only is he knowledgeable in his skill, his presentation is flawless and extremely interactive. He makes sure that no one in the class is left behind in understanding of the concepts. This course has been of great help to me to make a sound beginning in the world of data analytics.”
- Abhijit Audhya, Head - Global Data Infrastructure Services at Société Générale

“Rushabh Shah explained so well, even a 6th grade student would have excelled in Excel.
- Praveen Udayakumar, Executive - Production (Tier Manufacturing) at MRF Tyres

“You want to learn Microsoft Excel Rushabh Shah is the man! Trust me i just finished with a workshop and it was amazing, the way he teaches step by step. He forces you to think logically which i think is amazing and they way he drills you, you can remember it for the rest of your life. I absolutely loved it and i am hoping he does more courses.
- Dimpy Bhalotia, Fashion designer at Dimpy Bhalotia

“Rushabh Shah is one of the finest instructor I have ever come across. It was fun learning excel from him. Suddenly Excel seems so exciting !!”
- Abhimanyu Dass

“Excel Trainer Rushabh has thorough knowledge of Excel and he is very good at delivering it in class. He makes sure that he carries the entire class with him. Extremely happy with his Training. Thanks a ton Rushabh !!!”
- Yashodhan Watve, Assistant Project Manager - Cyient Ltd.

___________________________________________________