• Login
  • Courses
  • Books
  • Cheat Sheets
  • Tutorials Archive
  • VBA Code Generator
  • Contact

Power Spreadsheets

Excel and VBA tutorials and training. Learn how to use Microsoft Excel and Visual Basic for Applications now.

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
    • Power Query
    • DAX, Power Pivot, Power BI
    • Macros and VBA
    • SQL, Python, R
    • Data Visualization
  • Courses
    • Excel
    • Power Query, Power Pivot, Power BI
    • Macros and VBA
  • Software and Add-Ins
    • Microsoft 365
    • Excel Add-Ins
    • Other Software and Add-Ins
  • Cheat Sheets
  • Hardware
  • Tools I use to run Power Spreadsheets

Books

Excel

Excel All-in-One for Dummies book

Excel All-in-One for Dummies

Walks through every feature and technique you need to know to get the most out of Excel.

Get this Book at Amazon now

Microsoft Excel 365 Bible book

Microsoft Excel 365 Bible

A hands-on guide to the latest and most useful features in Excel 365.

Get this Book at Amazon now

Microsoft Excel Formulas and Functions (Office 2021 and Microsoft 365) book

Microsoft Excel Formulas and Functions

Use Excel core features to build spreadsheets that solve business problems and deliver reliable answers.

Get this Book at Amazon now

Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365) book

Microsoft Excel Pivot Table Data Crunching

Use Excel Pivot Tables and Pivot Charts to produce powerful, dynamic reports in minutes.

Get this Book at Amazon now

Advanced Excel Essentials book

Advanced Excel Essentials

Learn the building blocks of advanced development, and go through the development of your own advanced spreadsheet application.

Get this Book at Amazon now

Advanced Excel Success book

Advanced Excel Success

Learn advanced Excel features.

Get this Book at Amazon now

Power Query

M is for Data Monkey book

M Is for (Data) Monkey

Learn how to use the Power Query tool to get difficult data sets into both Excel and Power Pivot.

Get this Book at Amazon now

Power Query for Power BI and Excel book

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.

Get this Book at Amazon now

Master Your Data with Excel and Power BI book

Master Your Data with Power Query in Excel and Power BI

Take Power Query to new levels.

Get this Book at Amazon now

Collect, Combine, and Transform Data Using Power Query in Excel and Power BI book

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.

Get this Book at Amazon now

DAX, Power Pivot, Power BI

The Definitive Guide to DAX book

The Definite Guide to DAX

A guide to Microsoft's DAX language for business intelligence, data modeling, and analytics.

Get this Book at Amazon now

Learn to Write DAX book

Learn to Write DAX

Gain hands-on practice and become competent at writing such DAX.

Get this Book at Amazon now

Analyzing Data with Microsoft Power BI and Power Pivot for Excel book

Analyzing Data with Microsoft Power BI and Power Pivot for Excel

Introduces the basic techniques for shaping data models in Excel and Power BI.

Get this Book at Amazon now

Microsoft Power BI for Dummies book

Microsoft Power BI For Dummies

A start-to-finish guide to applying Power BI to your own firm’s data.

Get this Book at Amazon now

Analyzing Data with Microsoft Power BI book

Analyzing Data with Microsoft Power BI

Demonstrate your real-world mastery of Power BI data analysis and visualization.

Get this Book at Amazon now

Macros and VBA

Excel Macro and VBA Books at The Power Spreadsheets Library

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 book

Data Analysis Using SQL and Excel

Learn how to leverage SQL and Excel to perform sophisticated data analysis.

Get this Book at Amazon now

Advancing into Analytics book

Advancing into Analytics

Gain a solid understanding of analytics and the data stack.

Get this Book at Amazon now

Python for Excel book

Python for Excel

Learn how to integrate Excel with Python efficiently.

Get this Book at Amazon now

Data Visualization

Data Visualization with Excel Dashboards and Reports book

Data Visualization with Excel Dashboards and Reports

Fill the gap between handling data and synthesizing data into meaningful reports.

Get this Book at Amazon now

Data at Work book

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.

Get this Book at Amazon now

Storytelling with Data book

Storytelling with Data

Learn the fundamentals of data visualization and how to communicate effectively with data.

Get this Book at Amazon now

The Functional Art book

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.

Get this Book at Amazon now

The Truthful Art book

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.

Get this Book at Amazon now

Courses

Excel

Excel Expert online course

Excel Expert

Designed to take you from zero to hero so you can confidently list “Advanced Excel Skills” on your resume/CV.

Enroll in this Course now

Excel Tables online course

Excel Tables

Learn everything you need to work with Tables in less than 1 hour.

Enroll in this Course now

Advanced Excel Formulas online course

Advanced Excel Formulas

Learn about the functions that are going to give you the biggest efficiency gains at work.

Enroll in this Course now

Master NEW Excel Functions in Office 365 & Office 2021 online course

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.

Enroll in this Course now

Pivot Tables: Quick Start online course

Pivot Tables: Quick Start

Quickly start building your own Pivot Tables with confidence.

Enroll in this Course now

Excel Pivot Tables online course

Excel Pivot Tables

Quickly transform data into meaningful information, and create reports that are easy to update and change.

Enroll in this Course now

Excel Dashboards online course

Excel Dashboards

Dashboards provide insight, analysis, and alerts by displaying key trends, comparisons, and data in interactive reports.

Enroll in this Course now

Power Query, Power Pivot, Power BI

Power Query online course

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.

Enroll in this Course now

Power Pivot and DAX online course

Power Pivot and DAX

Quickly transform huge volumes of data into meaningful information to get the answers you need.

Enroll in this Course now

Power BI online course

Power BI

Power BI enables you to quickly develop stunning interactive dashboards.

Enroll in this Course now

Macros and VBA

Excel Macros for Beginners online course

Excel Macros for Beginners

My introductory-level course on Excel macros and VBA.

Enroll in Excel Macros for Beginners now

VBA Fundamentals online course

VBA Fundamentals (Part I and II)

My founding courses on Excel VBA.

Enroll in VBA Fundamentals now

Easy Excel UserForms online course

Easy Excel UserForms

My introductory-level course on Excel UserForms.

Enroll in Easy Excel UserForms now

Power Spreadsheets Platinum online course training bundle

PSA Platinum

My most comprehensive Training Bundle for learning how to automate Excel and save time with macros and VBA.

Enroll in PSA Platinum now

Software and Add-Ins

Microsoft 365

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 add-in

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.

Get the Productivity Suite now

Spreadsheet Assistant add-in

Spreadsheet Assistant

Add many useful features and functions to Excel to make it even easier to use.

Get the Spreadsheet Assistant now

More than 300 advanced functions and tools for Microsoft Excel

Kutools for Excel

Handy Excel add-in that combines 300+ advanced functions and tools for Microsoft Excel.

Get Kutools for Excel now

Other Software and Add-Ins

ExcelFIX file recovery

ExcelFIX

Repair corrupt Excel files (xlsx and xls) even if they are truncated or overloaded.

Get ExcelFIX now

AutoMacro example

AutoMacro

Add-in for VBA that installs directly into the Visual Basic Editor.

Get AutoMacro now

Able2Extract PDF converter

Able2Extract

Convert, create, edit, OCR, compare, secure, and sign your PDFs.

Get Able2Extract now

Cheat Sheets

VBA 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.

Get the VBA Cheat Sheets now

Hardware

Lenovo IdeaPad Laptop

Lenovo IdeaPad Laptop

Find a Lenovo IdeaPad at Amazon now

Microsoft Surface Pro Business Laptop

Microsoft Surface

Find a Microsoft Surface at Amazon now

Lepow Portable Monitor

Lepow Portable Monitor

Get this Portable Monitor at Amazon now

Logitech Craft Advanced Wireless Keyboard

Logitech Craft Advanced Wireless Keyboard

Get this Keyboard at Amazon now

Logitech MX Master 3S Wireless Mouse

Logitech MX Master 3S Wireless Mouse

Get this Mouse at Amazon now

Bose QuietComfort Noise-Cancelling Headphones

Bose QuietComfort Noise-Cancelling Headphones

Get these Headphones at Amazon now

Blue Snowball USB Microphone

Blue Snowball USB Microphone

Get this Microphone at Amazon now

Tools I use to run Power Spreadsheets

WPX website hosting

Website Hosting

I use WPX to host Power Spreadsheets.

Host your site(s) on WPX

ActiveCampaign email marketing and CRM

Email Marketing and CRM

ActiveCampaign gives me the email marketing, marketing automation, and CRM tools I need to create incredible customer experiences.

Try ActiveCampaign for free now

Teachable course hosting

Course Hosting

I use Teachable to host, and manage, the Power Spreadsheets Academy.

Create online courses and coaching services with Teachable

 

Use Camtasia to record and create professional looking videos

Screen Recorder and Video Editor

I use Camtasia to record and create videos and GIFs.

Download Camtasia now

I publish a lot of Tutorials and Training Resources about Microsoft Excel and VBA. Here are some of my most popular Excel Training Resources:

  1. Free Excel VBA Email Course
  2. Excel Macro Tutorial for Beginners
  3. Excel Power Query (Get and Transform) Tutorial for Beginners
  4. Excel Keyboard Shortcut Cheat Sheet
  5. Excel Resources
Terms and Conditions

Privacy Policy

Limit of Liability and Disclaimer of Warranty

Affiliate Disclosure

Copyright © 2015–2023 PDS Intelligence Pte. Ltd. All rights reserved.
Excel ® is a registered trademark of the Microsoft Corporation. Power Spreadsheets is not affiliated with the Microsoft Corporation.