Members of the Power Spreadsheets Community often ask me about tools related to Excel and Power Spreadsheets.
This webpage is your destination for the tools (books, courses, software, add-ins, hardware, and more) related to Excel or Power Spreadsheets that I like. I plan to periodically update this webpage.
I'm an affiliate for some of the tools in this webpage. I may make a commission if you make a purchase through Power Spreadsheets. This commission:
- Comes at no additional cost to you; and
- Helps support the development of Power Spreadsheets.
Read our Affiliate Disclosure.
Table of Contents
Books
Excel
Excel All-in-One for Dummies
Walks through every feature and technique you need to know to get the most out of Excel.
Microsoft Excel 365 Bible
A hands-on guide to the latest and most useful features in Excel 365.
Microsoft Excel Formulas and Functions
Use Excel core features to build spreadsheets that solve business problems and deliver reliable answers.
Microsoft Excel Pivot Table Data Crunching
Use Excel Pivot Tables and Pivot Charts to produce powerful, dynamic reports in minutes.
Advanced Excel Essentials
Learn the building blocks of advanced development, and go through the development of your own advanced spreadsheet application.
Power Query
M Is for (Data) Monkey
Learn how to use the Power Query tool to get difficult data sets into both Excel and Power Pivot.
Power Query for Power BI and Excel
A complete guide to Power Query, and how to use it to solve all your Excel data-loading problems.
Master Your Data with Power Query in Excel and Power BI
Take Power Query to new levels.
Collect, Combine, and Transform Data Using Power Query in Excel and Power BI
Learn how to wrangle any data, and transform it into actionable knowledge.
DAX, Power Pivot, Power BI
The Definite Guide to DAX
A guide to Microsoft's DAX language for business intelligence, data modeling, and analytics.
Learn to Write DAX
Gain hands-on practice and become competent at writing such DAX.
Analyzing Data with Microsoft Power BI and Power Pivot for Excel
Introduces the basic techniques for shaping data models in Excel and Power BI.
Microsoft Power BI For Dummies
A start-to-finish guide to applying Power BI to your own firm’s data.
Analyzing Data with Microsoft Power BI
Demonstrate your real-world mastery of Power BI data analysis and visualization.
Macros and VBA
The Power Spreadsheets Library
My comprehensive and actionable step-by-step guides for aspiring Excel macro and VBA users.
Get the Books in the Power Spreadsheets Library now
SQL, Python, R
Data Analysis Using SQL and Excel
Learn how to leverage SQL and Excel to perform sophisticated data analysis.
Advancing into Analytics
Gain a solid understanding of analytics and the data stack.
Data Visualization
Data Visualization with Excel Dashboards and Reports
Fill the gap between handling data and synthesizing data into meaningful reports.
Data at Work
Learn how to think about, and organize, data in ways that directly relate to your work, using the Excel skills you already have.
Storytelling with Data
Learn the fundamentals of data visualization and how to communicate effectively with data.
The Functional Art
Learn how to use data visualizations as tools to see beyond lists of numbers and variables, and achieve new insights into the complex world around us.
The Truthful Art
Learn how to work with data, discover the stories hidden within, and share those stories with the world in the form of charts, maps, and infographics.
Courses
Excel
Excel Expert
Designed to take you from zero to hero so you can confidently list “Advanced Excel Skills” on your resume/CV.
Excel Tables
Learn everything you need to work with Tables in less than 1 hour.
Advanced Excel Formulas
Learn about the functions that are going to give you the biggest efficiency gains at work.
Master NEW Excel Functions in Office 365 & Office 2021
Learn how to use some of Excel's new functions (FILTER, UNIQUE, SORT, XLOOKUP…) to dramatically simplify the work you do in Excel.
Pivot Tables: Quick Start
Quickly start building your own Pivot Tables with confidence.
Excel Pivot Tables
Quickly transform data into meaningful information, and create reports that are easy to update and change.
Excel Dashboards
Dashboards provide insight, analysis, and alerts by displaying key trends, comparisons, and data in interactive reports.
Power Query, Power Pivot, Power BI
Power Query
Get data from almost any source (for example, a database, the web, Excel, SharePoint, Salesforce, OData). Clean, transform, merge, and append data to your query.
Power Pivot and DAX
Quickly transform huge volumes of data into meaningful information to get the answers you need.
Power BI
Power BI enables you to quickly develop stunning interactive dashboards.
Macros and VBA
Excel Macros for Beginners
My introductory-level course on Excel macros and VBA.
Easy Excel UserForms
My introductory-level course on Excel UserForms.
PSA Platinum
My most comprehensive Training Bundle for learning how to automate Excel and save time with macros and VBA.
Software and Add-Ins
Microsoft 365
Microsoft 365 Personal
Subscribe to Microsoft 365 Personal now
Microsoft 365 Family
Subscribe to Microsoft 365 Family now
Microsoft 365 Business Basic
Subscribe to Microsoft 365 Business Basic now
Microsoft 365 Apps for Business
Subscribe to Microsoft 365 Apps for Business now
Microsoft 365 Business Standard
Subscribe to Microsoft 365 Business Standard now
Microsoft 365 Business Premium
Subscribe to Microsoft 365 Business Premium now
Excel Add-Ins
Productivity Suite
Saves time and makes Excel easier to use by adding many new features to Excel. It consists of a set of add-ins and downloadable macro books.
Spreadsheet Assistant
Add many useful features and functions to Excel to make it even easier to use.
Kutools for Excel
Handy Excel add-in that combines 300+ advanced functions and tools for Microsoft Excel.
Other Software and Add-Ins
ExcelFIX
Repair corrupt Excel files (xlsx and xls) even if they are truncated or overloaded.
Cheat Sheets
VBA Cheat Sheets
6 Cheat Sheets filled with everything you need to know to become an Excel VBA expert. 200+ tips and macros covering the 125 most important VBA topics.
Hardware
Tools I use to run Power Spreadsheets
Email Marketing and CRM
ActiveCampaign gives me the email marketing, marketing automation, and CRM tools I need to create incredible customer experiences.
Course Hosting
I use Teachable to host, and manage, the Power Spreadsheets Academy.
Screen Recorder and Video Editor
I use Camtasia to record and create videos and GIFs.