In an increasingly challenging financial environment, reporting variances will be even more important. This course will show you how to use templates to create six advanced Excel charts that you can start using right away. You'll also learn the expert-level techniques used to create the charts so you can apply those skills to create your own advanced charts to communicate variances between actual results and budget, forecast, or previous year values. These key insights are what executives are looking for and you will stand out by using the advanced charts learned in this course.
The course includes:
- A preview of the six visuals so you can decide which one will work best in your situation.
- The Excel file with all six chart worksheets. The worksheets are complete templates because they contain all the calculations, formatting, and setup that you can use to get started quickly creating your first advanced chart.
- Videos on how to use the template worksheets and adapt them to your own situation. You will get an in-depth tour of how the worksheet is built so you can adapt it and use the techniques to create your own advance charts. The training is split into multiple video sessions so it is easy to fit watching them into your schedule and easier to manage if you have the kids at home as well
- Links to additional videos and articles on topics or techniques covered in the videos so you can take your learning deeper.
These templates do not use VBA so you don't have to know or learn any programming. They use Excel functions that have been around for years, not any new functions that you need to be on an Insider build to use. This means that you can get up and running quickly without hitting any roadblocks.