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

Reset Week Number Every Month (start from Week # 1 every new month)

In this video I show you two ways to reset the week number to start from 1 at the beginning of every month. 1st case: We use Excel's WEEKNUM function to start from 1 every time we reach the 1st of the next month. 2nd case: We reset the week number to 1 every time we reach the first Monday of the next month. Here we use Excel's WEEKDAY function as the main formula driver. In addition you will learn how to: 1. Get Week Number from a date with the WEEKNUM formula 2. How to Get the Day

Excel Dynamic Chart with Drop-Down

Excel Dynamic Column Chart with Average Line Learn how to create an interactive chart in Excel that switches views depending on the selection from the drop-down list. In addition to creating dynamic chart ranges, I also show you how to create combination charts in Excel; This means charts that have different series types in one graph. In this specific example, I show you how to add a horizontal average line to your column chart. This makes it simple to compare the values of the bars not just with one another but also with the average. The key to dynamic

Optimized Excel Line Charts: Prevent Drop to Zero

You'll face two main problems when creating dynamic line charts in Excel: Problem 1: Line series crashes to zero once you attempt to cut-off the series from a certain point. For example you'd like to control the length of the line based on a drop-down. So when the user selects June, the line series shows data only until June. Problem 2: Positioning the series legend at the end of the line series poses a problem. The line can get longer or shorter, but you'd like the series label to dynamically adjust its position. In this tutorial you learn 4

Lookup values across multiple worksheets in Excel

Lookup values across multiple worksheets: VLOOKUP & INDEX MATCH in Excel In Excel, it’s relatively easy to lookup values in one specific tab. But how do you lookup values in multiple tabs using only one formula? In this tutorial, I'll show you different methods for achieving this. One method uses VLOOKUP and direct worksheet and cell references. The other approach uses INDEX & MATCH and Excel Table names and references. The key here is that the INDIRECT function acts as the messenger that returns the correct sheet address in a dynamic way to the different lookup formulas.

Excel Dependent Drop Down List with Tabular Data

Handle dynamic data validation lists that refer to parts of your table only  Excel Dependent Drop Down List with Tabular Data without Named Ranges   There are some cases where you need to create a dependent drop down list using a source table. However, while some instances would have the list in separate columns, it's also possible to have them stacked over each other like this: In this example, the user should be able to select a Division. There are three Divisions: Productivity, Game, and Utility.  From the selected Division, the corresponding App options will be shown

Dependent Drop-Down Lists in Excel with Multiple Words & Spaces in 1st List

A simple approach to create dependent lists Realistic Case: Dependent Drop-Down Lists in Excel with Multiple Words & Spaces in 1st List This video builds on the methods shown in a previous tutorial which showed you how to create an Excel dynamic drop-down data validation list that was dependent on the selection of another drop-down.In that video the first list contained numbers whereas in this video we take a look at a more realistic case where the first list contains text with multiple words and spaces. This approach works if your drop downs are in different worksheets as

Share This