50_tips_hardcover_250x380 Home

Sign Up To My Newsletter And Get All This!

  • 50 Tips To Master Excel Ebook
  • 10 Part Video Course
  • The Mega Book Of Excel Keyboard Shortcuts Ebook
  • The Ultimate Guide To VLOOKUP Ebook

Welcome To How To Excel!

John-Macdougall-work-profile-photo-525x525-e1521506913655 Home
Microsoft-MVP Home

I’m John, and my goal is to help you master Excel!

You’ll find a ton of awesome tips & tricks, full tutorials, templates and other great stuff here to help you save time and effort in your everyday work.

064-Tutorials-Icon-001 Home


The best FREE tutorials on the web!

064-Tips-and-Tricks-Icon-001 Home

Tips & Tricks

Tips & tricks to super charge your Excel skills!

064-Template-Icon-001 Home


Stylish templates to impress your boss and co-workers!

064-Functions-Icon-001 Home


Learn all about Excel’s many functions.

064-VBA-Code-Icon-001 Home


Unlock Excel’s hidden power with Visual Basic for Applications.

064-Charts-Icon-001 Home


Learn to visualize your data.

064-Keyboard-Icon-001 Home


A comprehensive list of 250+ keyboard shortcuts!

064-Earth-Globe-Icon-001 Home


The top Excel sites from around the world wide web!

The Latest Posts

View All

5 Easy Ways To Create A Data Entry Form In Excel

Data entry can sometimes be a big part of using Excel. With near endless cells, it can be hard for the person inputting data to know where to put...

9 Ways to Delete Blank Rows in Excel

Blank rows of data can be a big annoyance. They'll make certain things like navigating around our data much more difficult. But the good news is...

7 Ways To Get The Weekday Name From A Date In Excel

In this post we’re going to take a look at 5 ways to find the weekday name from a date in Excel.

Everything You Need To Know About XLOOKUP

There was big news in the Excel world recently. A new replacement for the most famous Excel function was announced. Move over VLOOKUP, your time in...

The Complete Guide To Slicers And Timelines In Microsoft Excel

Do you want to make impressive looking and functioning Excel workbooks without too much effort? Of course you do! If you want to create interactive...

7 Ways To Find And Remove Duplicate Values In Microsoft Excel

In this tutorial we are going to look at 7 easy methods to find and remove duplicate values from your data.

The Complete Guide To Microsoft PowerApps

Learn about the Microsoft PowerApps drag and drop formula based app building platform. Quickly build useful business apps using the intuitive PowerApps visual builder that doesn’t require traditional coding.

Everything You Need To Know About Flash Fill In Microsoft Excel [15 Examples]

In this post you're going to learn everything you need to know about Flash Fill in Microsoft Excel. What's so great about it? It's quick and easy to...

An Introduction to Microsoft Forms for Excel

Learn how to use Microsoft Forms to quickly and easily create surveys, quizzes and polls.

The Complete Guide to Rich Data Types in Excel

Learn all about rich data types in Excel and how to use them to get more from your data such as current financial data, currency rates, cryptocurrency values and geographical data with just a couple clicks.

Get Social!

Join the thousands of others who are following How To Excel and saving time and effort in their work!

What Everyone Is Saying

This site is really helping me learn Excel. The sample files are a big help. I look forward to every new post.


Pune, India

How To Excel is the best free site I’ve found for learning anything excel related. I would highly recommended it!


Seattle, USA

I’ve never seen such well thought out Excel lessons before. Thank you so much and keep up the good work!


Trier, Germany

I’d like to thank you for your absolutely brilliant site. This is one of the best Excel tutorial sites I’ve come across.


Galway, Ireland

Get the FREE Book!

Subscribe to our newsletter to get awesome in Excel!

Downloads So Far

50_tips_hardcover_250x380 Home

Pin It on Pinterest

Share This