Resources

Rob and Avi do a great job laying out what the future of the “Excel Pro” is going to look like. It’s hard not to agree with them.

Rob and Avi are quite light on the Power Query/ETL portion, and this is where Ken and Miguel come in to fill the gaps. I highly recommend this to anyone wanting to improve their queries and apply best practices when it comes to connecting to data.

While Rob and Avi provide high-energy, Marco and Alberto (aka “the Italians”) are here to take your understanding to the next level. The sky is the limit after you finish studying this book.

A free e-book (links above) published from Microsoft, also written by the Italians. It’s very basic but serves as a nice introduction. You can’t beat free.

Times are a-changin’, with VBA slowly loosing prominence due to the faster and more effective workflows of Power Query and Power Pivot, however, VBA is so deeply embedded in many organizations that it’s still worth your time understanding how it works – and sometimes you just can’t beat its raw flexibility and power.

The authors provide a solid framework for database modelling and allow you to gain a better understanding of the theory behind databases you may be working with.