Online Advanced Excel Chart Tutorials

Do you want to improve the graphs in your Excel reports?

Watch the Video to see why this is NOT your usual Excel Chart Course

Take The Course

You’d like to visualize your data for a clear message? Not sure what is easy, effective and possible in Excel? Or you find you spend too much time manually updating your graphs?

If yes, then you need to have a look at my Excel Advanced Chart Course.  Here are a few examples of the Excel charts you will learn:

Excel Pin Chart - Leila Gharani
Excel Professional Bar Chart - Leila Gharani
Excel bullet Chart - Leila Gharani Training
Easiest Excel Waterfall chart - Leila Gharani
Excel conditional formatting in charts and dividers - Leila Gharani
Excel Chart geography - Leila Gharani

They don’t look like the usual Excel charts do they?

Yet they can be made from scratch in Excel in a few steps.  And Yes, in ANY version of Excel. Including Excel 2007 & 2010. They also provide great visualization for variances, comparisons and target achievement. These are just a few examples. Take a look at the course content and reviews to get a more complete picture. The course is top rated with over 100 ratings.

What Participants Say:

View the Rest…
In one word a very great course to learn charts and graphs in depth. The instructor is able to explain every detail in a calm, clear and concise way. There are a lot of tips and trucs to let you create dynamic charts. Thanks to the teaching approach you will also become a lot more creative in your way of thinking about charts and all the possibilities you have. In summary this course is for everyone who wants to go a step further. Take this one to amaze your boss, colleague, friend or anyone else.
Jan Bolhuis
Excellent instructor. The knowledge gained more than pays for itself with the time saved with her great techniques.
John Palardy
Very comprehensive course on Excel charts buiding where the key notes are flexibility and dynamic. Leila Gharani is a top skilled teacher. I strongly suggest this course.
Renato Vianello
This is an amazing course with an amazing teacher. Well organised and structured and really shows you in-depth how to create stylish and dynamic charts. In addition how to set up your data to achieve such charts and the process behind it is a great help. I really enjoyed how to use scatter chart/plot for effective labelling and also the use of error bars for creating vertical and horizontal lines to break up your charts. Lots of best practice as well in keeping you charts simple and to the point.
Clint Nisbet

Without Doubt, With This Advanced Excel Chart Course, You will be the Excel data Visualization star in your department! Significantly Improve your Reports by using Advanced Excel Graph Techniques. 

Get ready to:

  • Learn top tricks to create dynamic Excel charts which will save you tons of time of manually updating your graphs on a monthly basis
  • Enhance readability of your reports by using best practice methods
  • Use new ways to compare performance – as in Actual versus Budget, Forecasts and Previous Year
  • Learn creative and simple Excel techniques that allow you to create your own charts from scratch – no templates or add-ins necessary

The Excel Chart course includes over 7.5 hours of videos and contains Practice and Demo Workbooks. You get to follow the demonstrations in your Demo file and practice what you learnt in the Exercise workbook.

The best part is, you have a 30-day money back guarantee  and if you do like it, you get lifetime access to the material so you can come back and revise the techniques any time you want. In addition to this, I will be adding new lectures and new material to the existing structure. You get to constantly improve your Excel skills at no additional cost, and if you get stuck you can ask your questions on the discussion board. I’ll make sure to get back to you as soon as possible.

Who is the Course for?

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.

Types of Excel Charts & Excel Graphs 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!

Take The Course

Not Yet Ready?

Check out the related posts below and subscribe to my Newsletter to get your FREE Excel Tips and Tricks Booklet and stay up to date for new courses and free information. I hate spam! I only send material I think my subscribers will find valuable – about once a month.

Subscribe to my Newsletter

Advanced Excel Top 10 Tips and Formulas PDF Free Download

Related Blog Posts for Excel Charts and Graphs

Find Multiple Matches in Excel & Create a Dependent Drop Down List

The aim of this tutorial is to create a dependent drop-down list that's based on a messy Excel Table. What do I mean by an unsorted Excel table? The categories for the first drop-down are not in a tabular format and they are not grouped together. You can see an example of the data set below. In a previous tutorial I showed you how you can extract unique items for a data validation drop-down list that was based on a table which had multiple instances of each category. In this tutorial I will take this one step further and

Excel Filter: Basic to Advanced

Filter Basics First Excel's AutoFilter is a great feature to quickly display the rows in your data table that meet a certain criteria. The remaining rows that don't match your criteria are automatically hidden. Once you have your selection in view, you can edit the entries or copy the filtered list to another location. Since there is a lot to filter than meets the eye, I've broken it down to two tutorials. In the filter basic tutorial you'll learn the following: The shortcut key to turn filter on and off in Excel (Ctrl + Shift + L) How to

Copy Excel Formulas Without Changing Cell References

Would you like to copy your Excel formulas from one place to another without the cell references changing? Excel default behavior is to adjust the cell references when you copy a cell and paste to another one. You can choose to fix the cell reference by using the dollar sign ($). A $ for the row number, fixes the row and a $ on the column number fixes the column. You might however need to copy a set of formulas that have relative references from one location to another or from one file to another and keep the existing

Excel VBA: Control WordArt Fill with Macros

How can you get this effect? Find out how you can use Excel Macros to control the fill color of Word Art in VBA. In this specific case we have a dynamic Word Art which shows a percentage value that is connected to a cell with a formula. Anytime the cell value is changed, the Word Art should update AND it's fill color should also adjust based on the percentage value. If we have 50%, only half of the 50% Word Art will be highlighted. This video is more than just about using Excel VBA to control Word Art.

Dynamic WordArt in Excel with Bar in Bar Chart

Let's get creative with Excel! In this tutorial we're going to combine Word Art together with Excel charts to create an impressive progress bar. This progress bar is a part of the % sign of our Word Art. The result is the icon for this blog post. The thing with Word Art is that you can't conditionally format it without using some VBA code. If you'd like to avoid macros, you can still get creative and combine a mini bar chart with the % sign to get the progress bar. This will be an impressive visualization for your project

Excel IF Formula: Simple to Advanced

The IF function is one of Excel's most common Functions The IF formula performs a test and returns a value depending on the outcome of the test. The test it performs can be simple or complex depending on the problem at hand. It's one of those formulas that every Excel user should know. In this tutorial I show you how to use the IF formula in your Excel reports. We cover a few examples including: Simple IF function (also with greater than or less than checks). IF Formula together with AND logical test to decide outcome if more than

Share This