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
- 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!