Without Doubt, With This Advanced Excel Chart Course, You will be the Excel data Visualization star in your Department!
Here's what you will achieve at the end of the course:
- 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 the Demo Excel Workbook and follow each section with me.
- Learn advanced Excel lookup methods (such as matrix lookups) which you can use in your larger data files. The methods learnt in Behind the scenes secrets of dynamic charts can be applied to many other areas.
- Become the Excel data Visualization star in your department by creating impressive Excel charts and graphs in your reports.
This course is split to 5 major parts
- 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.
- 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.
- Techniques that highlight Excel chart and table elements to direct the reader attention where it is needed most.
- New ways to compare performance: as in Actual data versus Budget, forecasts and previous year
- 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!
This is an excellent course. Lelia's mastery of Excel is undeniable. She provides thorough explanations but does it swiftly. Her program is excellently designed. It builds well upon each section, utilizing previous methods which really helps it all sink in. This is the second course of of hers that I have taken and the level of professionalism in her classes is top notch. I have already implemented items from this and her dashboard course to get real results at my job.
- Lucas Hildebrand
Highly recomended course if you want to get into charting or data visualization with Excel. I really enjoyed Leila´s pace with explaining the video. A truly gifted instructor. Cheers Leila, you are phenomenal!
- Carlos Alberto
Get started now!
Valued at $80
Get it for
$22 ex VAT
(why so cheap? See FAQ section below)
Types of Excel Charts & Excel Graphs Covered
The content and type of Excel charts presented are those that are typical for 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.
BONUSES (Only included here)
BONUS 1: Downloadable Workbook to follow along and Exercise workbook to practice after each section (answers included).
BONUS 2: Cheat sheets so you can create any of the charts shown in the course quickly from scratch.
BONUS 2: Downloadable videos so you don't have to worry about internet connection.
I gained lot new knowledge especially with charts. Knowledge I never new was there. This increased my confidence and would help me in my work and be more professional. The instructor was experienced with in depth knowledge and her way of explaining and getting things done made it easy to grasp the knowledge. Moreover her after course material especially her website and youtube tutorials are also source of great knowledge and interaction. Thanks
- Salahuddin Abdul Rahim
My courses & tutorials are for those who use Excel at work and want to become better. For those that want to contribute by coming up with solutions to problems.
I don’t just want to show you solutions, but to inspire you to experiment, create and share that with others.
On my YouTube channel, I share Excel tips & tricks based on questions I get from the Excel online community & professionals at my training sessions.
I am a Certified Microsoft Excel Expert and was given the Microsoft Excel MVP award in 2017. I have over 15 years of experience implementing and training users on Management Information Systems of different sizes and nature - these include SAP BW and Oracle HFM.
My background is: Masters in Economics, Economist, Consultant, Oracle HFM Accounting Systems Expert & Project Manager. My passion is teaching and solving difficult Excel problems. I am also addicted to learning and enjoy taking online courses on a variety of topics.
I founded XelPlus in 2015. My aim with my site is to help people gain the knowledge they need so they can create useful tools, solve problems and get more done.
Let's start now.
StartEffective Presentation of Quantitative Data - Overview (1:51)
StartTable Design - Best Practices (2:57)
StartExcel Chart Design - Best Practices (5:00)
StartUnderstanding the Chart Tools Environment (18:13)
StartSimple Shortcuts to Save Time (8:30)
StartQUIZ: Best Practice & Chart Options
Frequently Asked Questions
What differentiates this course from other chart 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 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.