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.

Advanced Excel Top 10 Tips and Formulas PDF Free Download

Related Blog Posts for Excel Charts and Graphs

Excel SCAN Function

Learn how to use the new Excel SCAN function! This function is a Lambda helper function. You can use it to "scan" a range and apply a calculation to each cell. In this example you'll learn how to use SCAN to get to-date values and how you can tweak it to return YTD values.

Percentile and Percentile Rank Calculation in Excel

Learn the meaning of percentile in introductory statistics and how to calculate Percentile in Excel. There are two functions: one is PERCENTILE.INC and the other PERCENTILE.EXC. I'll explain the difference and also how you can calculate PERCENTRANK in Excel.

Office 2021 new Features

Here's why you should upgrade to Office 2021 if you're on 2019 or 2016 (and for some reason you can't upgrade to 365). You get life-changing Excel functions like XLOOKUP, UNIQUE, FILTER, SORT and a lot more. I cover what you get when you upgrade in this post.

Excel Repeat blocks of Values x times

With this trick you can easily combine and repeat blocks of values together in Excel. You don't need copy pasting or complicated formulas. Just a tiny bit of Power Query. This keeps your solution dynamic too.

Power Automate with Forms

It's super easy to setup an automation in Power Automate to get notified when someone submits their answers in a Microsoft Form. You can also add a condition, so you get an email or mobile notification only when a specific answer is submitted.

Excel BYROW and BYCOL Functions

Find out how you can use the new Excel BYROW and BYCOL functions. These are called Lambda helper functions and they can help you save a lot of time if your analysis is based on a whole row or an entire column. Check out this practical example to find out more.