Excel Charts: Visualization Secrets for Impressive Charts (Udemy.com)

Gain Highly Advanced Excel Skills to Create Impressive Excel Graphs for your Management Reports (Excel 2010)

Created by: Leila Gharani

Produced in 2020

icon
What you will learn

  • Significantly improve your Excel reports to create more powerful graphs that communicate your information in the best manner
  • Learn creative & simple techniques that allow you to create your own Excel charts from scratch
  • Create dynamic Excel charts. Why? To save time! I have seen many cases where people are unnecessarily manually updating graphs. This costs considerable time and nerves.
  • Impress your management by including new Excel graphs in your reports (such as my Pin chart for variances)
  • Apply Best Practice methods to considerably improve the design of your Excel charts and tables
  • Apply techniques that highlight chart and table elements to direct the reader attention where it is needed most
  • Use effective Chart Combinations that are pivotal to management reports
  • Apply best methods to compare performance in your Excel graphs: as in Actual data versus Budget, forecasts and previous year
  • Learn by doing. Download

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 94 / 100

icon
Course Description

Without Doubt, With This Advanced Microsoft Excel Chart Course, You will be the Excel data Visualization star in your Department!
Significantly Improve your Reports by using Advanced Excel Graph Techniques.
This Course Includes:
  • Downloadable Workbook to follow the demonstrations (and use the charts as your templates).
  • Downloadable Exercise Book (answers included).
  • Full set of Cheat Sheets for download in Lecture 3. This PDF document is a quick reference guide for whenever you need to create any of the charts in this training.
If you use Excel to generate reports and graphs, myhands-on Excel training provides you with an extremely advanced toolkit worthof knowledge that will take the design of your Excel charts, tables and reports to the nextlevel. 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 monthlybasis. The visualization techniques introduce you to some unusual methods tohandle and create charts which will enhance readability of your reports as wellas impress your readers.
Lauren says: "I wish she had more courses on advanced excel and access that are formatted like this one. She frames the content in ways that are applicable to my current job. I will be able to improve my current processes and project turnaround time as well as the look/feel of my tables and charts."
John says: "Leila does a fantastic job of walking you thru the process of creating various charts from scratch. From which formula to use to step by step chart creation. As a bonus you have actual exercises to practice your new skills, Absolutely one of the best instructional courses I have taken"
Paul says: "Course is clear, to the point and very dynamic. Excellent!"
Types of Excel Charts & Excel Graphs are 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 youwill be able to follow each demonstration in your own Excel workbook. To make sure you have understood thetechniques, 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!Who this course is for:
  • Controller or financial analyst responsible for creating monthly, quarterly or yearly reports
  • Finance or department manager looking for new effective visualization methods
  • A student planning to work as a business or financial analyst or in any function that will require data visualization
  • All in all, if you're responsible for presenting your data graphically and you need to do this with Excel, you will benefit from the methods I teach in this course

*Some courses are excluded from this sale. Coupon not working? If the link above doesn't drop prices, clear the cookies in your browser and then click this link here.
Also, you may need to apply the coupon code directly on the cart page to get the discount.

Coupon Code

icon
Instructor Details

Leila Gharani

Leila Gharani is a Microsoft Excel MVP (Most Valuable Professional) dedicated to helping you create outstanding tools and reports in Excel. Her courses are for those who want to learn Excel, accelerate their careers and achieve more in less time.
Leila' background is Masters in Economics, Economist, Consultant, Oracle HFM Accounting Systems Expert & Project Manager. For over 15 years she has worked in the Finance and IT departments implementing reporting systems based on Oracle and SAP. All the while using Excel VBA to automate and improve processes.
Since 5 years, Leila runs her own Excel site and has an active YouTube channel with many engaging, high quality videos. She provides customized Excel dashboard seminars, enhanced visualization techniques, and advanced Excel seminars to large corporations. She also teaches at the University of Applied Sciences in Upper Austria.
Her courses include examples based on her experience as well as the consulting work she has done for international companies. Many of the Excel tips and tricks she shares is based on the questions received from experienced professionals in her Excel training sessions.
She places great value on keeping her Excel courses not only informative but also engaging. For this reason, students will find enough challenges, exercises and downloadable files to practice so they can maximize the value gained from each course.
Leila's p

icon
Students also recommend

Free

Free

$14.53

icon
Reviews

4.7

100 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Heather MacDonald on a month ago

If you want to know excel inside out Leila is the best. I am so happy I purchased this course. She is easy to understand, there are lots of exercises for you to test your skills, and the reference documentation is excellent. I would recommend this course to anyone who wants to be an advanced excel user. I will be buying more of her courses.

By Abhilash Nandan Sahu on a month ago

One of best course in excel chart where one would learn the technicalities in very simple way.the way Leila explains adds value to it.

By Tesh seven52nine on 2 months ago

I really think this course is exceptional. Easy , clear and very informative. The only thing I would have liked is a small overview section on the different chart type, settings and options. However this is covered during the course. My personal preference would be to have a small overview first.

By Lina Winny on 3 months ago

Leila always points the chart by the reader side. in the working field, many bosses don't understand chart or excel, so no need to show up chart artistically, it's better than they understand what data we bring in the chart. And Leila makes it "chicks" and elegant. I learned this course by practicing all sections more and more, not only doing exercise that Leila has given but repeat the section by making chart self because she has given us data in demo file so why not I try by myself. thanks, Leila for a great course.

By John Morgan on 3 months ago

A very thorough explanation of the chart functionality in Excel that provides the student with a very impressive set of skills. The instructor has great attention to detail and explains the chart creation clearly in an easy to understand step-by-step approach.

By Juan a. Casal m. on 2 months ago

excelente.sencillo de entenderinstructor super..

By Elma Kennedy on 2 months ago

It was indeed a great match. My learning experience in this course was OUTSTANDING...

By Janie Carter on 3 weeks ago

I loved this course! I learnt so many new cool Excel chart techniques and the section exercises were great to practice with.

By Jose Ignacio Lopez Diaz on 4 months ago

De momento se centra bastante en explicar los conceptos bsicos para que el seguimiento del curso sea ms fcil. Adems, diferencia el aspecto tcnico de la herramienta de los aspectos culturales de la organizacin, para dejar claro que hay cosas que dependen de nuestra experiencia o de la audiencia a quienes se presenta la informacin.Estoy teniendo problemas con la versin de Excel que utilizo para practicar, no coinciden las opciones de men ni los textos, a parte de la lgica diferencia por el idioma

By Chee Teck Tan on 2 weeks ago

I would like to say the instructor is a SUPERWOMEN on udemy learning platform. She really impress me a lot along the way I'm taking the course where I learn a lot of valuable concept & hand on experience while doing my analyst report! I will strongly recommend her course to anyone they need to to chart visualization! I'm rarely found a instructor like her on udemy! Look forward to buy all excel course she taught in the future! Lastly word to describe, excellent! valuable content! interactive teaching! beautiful appearance and much more!

By Philip on 2 months ago

New ways of creating dashboards unraveled in this course. Very useful in presenting data from the usual humdrum way.

By Rafiq Jennings on 3 months ago

I never knew that they are so many ways to create a chart. You won't be doing basic pie charts after this course :D