How to develop powerful data visualization skills in Excel & Power BI that will instantly catch the attention of anybody reading your reports …. You’ll notice an inmediate uptick in the quality of your presentations. And all without any complicated gimmicks!
How to bend Excel and DAX formulas to your will, the right way. There’s a task for every function and you can be sure Microsoft’s developers thought about it. You’ll find out there were things you didn’t even suspect were possible.
Techniques and best practices you can use to clean up your dirty data. From text formulas in Excel to Power Query connections that automate data cleanup, to full on VBA report automatizations that can tackle even the most complicated formatting schemes.
Exactly how to avoid common (and rare) Excel errors that you are most prone to run into. You will be able to create and deliver bulletproof spreadsheets that can contemplate practically any unforeseen circumnstances.
Powerful VBA Programming Techniques to automate your work away… and your coworkers as well! VBA can take over most of the menial Excel tasks you have to perform repeatedly. Our VBA course will teach you how to get rid of them.
How to automate monthly close procedures so that you never have to create reports repeatedly every single month and quarter again. By leveraging the magic of power pivot, you can and will create an amazing system that self-updates and self calculates. You only have to work once.