Publisher's Synopsis
Do you feel intimidated by how complex Excel Pivot tables or VBA Programming can seem?
Excel is essentially one of the most powerful software tools for collecting and analysing data when used to its full potential. But all too often you may not be making the most of what excel has to offer.
It is estimated that on average people only use 20% of functions available on excel because they are unaware of what each button and function does, are you part of the average? Well go beyond being average and learn new skills that will set you apart from the rest.
Whether you want to enhance your productivity at work, in business or use it as a tool to help you organise your personal finances this is for you.
Topics Covered In This Book Include:
Book 1) Pivot Tables
- The history of the Pivot table and the mechanics of how it works.
- A step by step guide on when is best to use Pivot Tables and navigate you through an example
- The first steps of feeding data into the pivot table and techniques on advanced visualisation.
- What you can use Visual Basic Application and will go into detail how VBA can help automate documents such as word processing.
- How to navigate your way around an IDE (Integrated Development Environment) and what each window represents.
- Clear steps on how to write a program and the 5 important questions you must think about before you start to write.
And much more!
