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

Quick Gantt Chart

How can you create a Quick Gantt Chart in Excel? 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? This video will show you how: Feel free to Download the Workbook HERE.

Excel WORKDAY & NETWORKDAYS Functions: Exclude Weekends and Holidays

Excel's workday function is great when you need to calculate an end date based on a given number of working days - which means you need to exclude weekends and holidays. Some examples are: creating a project timeline creating a reporting timetable Excel's standard WORKDAY formula assumes weekends fall on Saturdays and Sundays. In case the weekends in your country fall on other days, you will need to use Workday.intl where you have an additional option to select the weekend days. Watch the video to find out how to use the WORKDAY function: On the other hand,

Excel Charts: Special Excel Graphs (InfoCharts)

How can you create this chart in Excel? The first time I saw a similar chart was in a report published by Udemy called Learning Trends & predictions in 2017. They used a similar chart to the one below (this one just has sample data though). I found the chart informative, visually effective and interesting. It really grabbed my attention and I set out to create it in Excel. Of course in a dynamic manner. There were two obstacles: One was to get the exact same shape proportions for each category (i.e. no stretched out bars) and second to get the

5 Design Tips for Better Excel Dashboards

What results do you want to show in your Excel dashboard? What should readers take away from it? These five design tips will help you showcase your data clearly and directly. Scroll down for the video. Learn how to create this interactive Excel report in the upcoming ‘Visually Effective Excel Dashboards’ Course. 1. Create emphasis Add a strong contrast to headings to show at a glance the KPIs on display in your dashboard. Contrast on the heading: Actual Revenue VS. Budget A subtle contrast on alternating table rows visually separates them, improving readability. Subtle contrast on the table rows

3 Ways to Improve Readability of Excel Stacked Charts

Add Total Values, Percentages & Dynamic Legends   There is so much potential to improve the standard Excel stacked chart. For one, adding total values outside the last stack would ease comparison between categories. Adding percentages to the stacks would also help identify and compare the stack sizes to one another. One method I specially like, is to create a dynamic legend and to put the labels of each of the stacks (so not the data labels but the name of the stack) on the right hand side of the last category - as shown in the graph below.

Excel SumIFS – Sum Alternate Columns Based on Criteria and on Header

How to SUM Different Columns based on Header? Excel's SUMIFS function makes it easy to sum columns based on different criteria. But how can you use the SUMIFS function to not just sum based on criteria, but also sum different columns based on the column header? This video shows you how you can sum different columns based on user selection. This is great technique when you want to create dashboard / interactive type of reports. Here is a version to SUM using the SUMPRODUCT FORMULA: Download the Jumping Sum Workbook Here: The

Share This