Improve Your Reports by Introducing Simple, New & Elegant Charts
Smart Charts are Simple
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. 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. Not only that but you will also learn the best tricks to create them in a dynamic manner. It will save you tons of time of manually updating your Excel graphs on a monthly basis.
A Column Chart is not a Column Chart
Take this Column chart for example. It’s not your usual column chart:
This is also not your usual Waterfall Chart:
Nor is this your usual time-series graph:
What You will Gain:
Create Impressive Charts: Significantly improve your Excel re.ports to create more powerful graphs that communicate your information in the best manner.
Think Outside the Box: 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.
Apply Best Practice Methods: Considerably improve the design of your Excel charts and tables. Learn new methods to compare performance in your Excel graphs – as in Actual data versus Budget, forecasts and previous year.
Impress Your Management: Include new graphs in your reports to help them visualize trends and variances in ways they will appreciate.
Choose Your Visualization: Let me know which graphs you’d like to include in your reports and I’ll make sure everyone will learn how to create them from scratch.
Not Sure What to Include? I’ll send you suggestions depending on your existing reports. You can pick and choose which graphs you’d like covered.
Learn by doing: I design hands-on exercises to ensure each topic is sufficiently covered.
The Excel Visualization training help me discover new techniques that will: 1) Save time which is crucial in the controlling and Finance Departments and 2) Better illustrate the message of the graphs. The training was practical, click here, click there… and when you see how nice & fast the results are, you think about the time you could have saved. I recommend the training to anyone who needs to prepare reports/presentations and needs to prepare them fast.
Sergiu Bors, Controlling / Telekom Austria Group
You’d Rather Start with a Standard Chart Training?
No problem! Excel charts have many powerful features to visualize your data in ways that go beyond “standard” graphs. The aim is to learn to effectively combine these techniques to get the outcome you want.
This would be our agenda:
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 pivotal to management reports.
“Tell me and I’ll forget, show me and I may remember, involve me and I’ll understand.”
After covering each topic, you will complete an exercise. Especially with topics like Excel, you learn most when you make mistakes and are trying to fix them, because that is when you are most concentrated.
For an effective training, it’s best to group the participants based on their existing Excel knowledge.
The Excel Chart course assumes that you have been working with Excel for some time and are familiar with general Excel features and formulas.
If not, you might be interested in a more Basic or fully tailored Excel training.
Add a Workshop
Learning new concepts and methods at a seminar is easy, implementing them in your daily tasks is the real challenge. To support the effectiveness of the training and to make sure the new concepts are also applied in real work life, I recommend a one day workshop to be scheduled at a later date. This ensures the topics learnt will be applied to real-life cases.