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.
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.
Another great book from J Walk on Programming in Excel. Recommended for those who want to master VBA & Macros in Excel.
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.
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.
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.
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.