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

Complex Lookup: INDEX & SUMPRODUCT

Find Header based on Lookup Criteria in Matrix with INDEX & SUMPRODUCT In this video I show you the answer to one of the questions that was asked some time ago on the Mr. Excel message board (the sample data was changed for the video) - The question is a complex LOOKUP problem - the task is to find the header of the lookup criteria, which is in a matrix. The lookup value could be in any column and any row - that's what makes the problem complex. How would you get the header based on a lookup value

Smart Uses of Custom Formatting

Use Custom Formatting instead of Conditional Formatting in Excel. Smart Uses of Custom Formatting  We normally use custom formatting to show numbers with thousand separator, as percentage or even to show green for positive and red for negative values. But we hardly ever use custom formatting to show deviations with symbols. I compared the custom to conditional formatting using 40,000 lines of data and the custom formatting method was three times faster than conditional formatting. Custom formatting is also faster to implement - even if you want to build in thresholds. In this guide, I’m going

Quick Gantt Chart

Create a Gantt Chart now in Excel with this step-by-step guide. Quick Gantt Chart A Gantt Chart is great for visualizing and presenting your project plan. But let's say, you just setup a preliminary project plan in Excel. You did that with the help of WORKDAY and NETWORKDAY functions. You now need to present this to the team and your meeting is in 10 minutes. How do you quickly put together a Ganntt chart? Contents CHAPTER 1 Quick Gantt Chart CHAPTER 2 Fully Featured Excel Gantt Chart

Stacked Column With Connectors

How do you create this chart in Excel? In this video you'll learn how to add series lines to stacked column charts. Instead of series lines, you might want to add a shaded background to each of the stacked sets. We can do that using stacked area chart and combine it with our stacked column chart in Excel. Watch the steps in this video: Feel free to Download the Workbook HERE. The new Excel Dashboards course is here! Now available on Udemy Visually Effective Excel Dashboards for your reports. Redeem your coupon

3 Steps To Make Great Excel Charts

Are you unsure how to improve the charts and tables in your Excel reports? How to visualize your data for a clear message? Not sure what is easy, effective, or even possible in Excel? An effective chart clearly communicates the intended message to the reader. Charts should be "SCC" - Simple, Clear & Consistent. Simple Strip charts of components, colors, images and other elements that aren’t central to the core message. Take away background color. Lighten the grid lines or take them away entirely. If data labels are shown, remove the Y axis. Alternatively, enable the Y axis but

Excel Reverse Matrix Lookup

Are you familiar with INDEX MATCH? If you're familiar with Index and Match you know how to solve a matrix lookup problem. You want to find a value inside the matrix by looking up the row and column headers. What happens though when it's reversed? You want to find the column header based on the value inside the matrix as well as the row header. To solve this Excel problem, we will take a look at INDEX & MATCH and use two sets of INDEX MATCH to get our result. We will actually use the row argument of index

Share This