Excel Resources

Following are the Books which I refer and Tools which I use to create my Tutorials.

Disclosure: Some of the links are Affiliate Links! If you buy something through one of those links, you won’t pay a penny more, but we will get a small commission, which helps keep the lights on. Thank you for your support!

Books on Excel

John Walkenbach‘s Excel Bible is the best recommended Excel book for beginners as well as intermediate Excel users. A complete guide covering every essentials aspects of Excel.

Start Learning

Written by Greg Harvey, who has sold more than 4.5 million copies of his previous books combined. A great guide on Excel which offers everything you need to get started.

Start Learning

Another great book from J Walk on Programming in Excel. Recommended for those who want to master VBA & Macros in Excel.

Start Learning

Books on Power Query, Power BI and Power Pivot

Super Charge Power BI written by Matt Allington clearly explains the necessary concepts while at the same time giving hands-on practice to engage the reader and help new knowledge stick.

Start Learning

Written by Ken Puls and Miguel Escobar, M is for (Data) Monkey shows how to use the Power Query tool to get difficult data sets into both Excel and Power Pivot, and is solely devoted to Power Query dashboarding and reporting.

Start Learning

Rob Collie & Avi Singh’s, book on Power Pivot and Power BI is the first to tackle DAX formulas, the core capability of PowerPivot, from the perspective of the Excel audience.

Start Learning

Camtasia from TechSmith makes it simple to record your screen, add video effects, transitions and create professional-looking videos. Sharing information with video is quite easy with Camtasia.

Create Video

Snagit from TechSmith lets you quickly capture a process, add your explanation, and create visual instructions. I use Snagit to add visuals for all my blog posts.

Capture Screen