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!

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.

Tutorials

The best FREE tutorials on the web!

Tips & Tricks

Tips & tricks to super charge your Excel skills!

Templates

Stylish templates to impress your boss and co-workers!

Formulas

Learn all about Excel’s many functions.

VBA

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

Charts

Learn to visualize your data.

Shortcuts

A comprehensive list of 250+ keyboard shortcuts!

Resources

The top Excel sites from around the world wide web!

The Latest Posts

View All

8 Ways to Merge Cells in Microsoft Excel

by John MacDougall | 2021-09-08 | Tutorials | 0 Comments

Merged cells are one of the most popular options used by beginner spreadsheet users. But they have a lot of drawbacks that make them a not so great...

6 Ways to Count Colored Cells in Microsoft Excel [Illustrated Guide]

by John MacDougall | 2021-09-07 | Tutorials | 0 Comments

You have probably used color coding in your Excel data or seen it in a workbook you had to use. It's a popular way to visualize your data! While...

15 Clever Ways to Add Serial Numbers to Your Excel Data

by John MacDougall | 2021-08-16 | Tutorials | 1 Comment

If you're working with large sets of data in Excel, then it's a good idea to add a serial number, row number or ID column to the data. A serial...

15 Ways to Add Checkmarks in Microsoft Excel

by John MacDougall | 2021-08-06 | Tutorials | 0 Comments

Check marks or tick marks can help add a visual indicator to your spreadsheets. You might use them to indicate a task has been completed or a...

6 Ways to Add Strikethrough Format in Excel

by John MacDougall | 2021-05-17 | Tutorials | 0 Comments

Strikethrough formatting is a seldom used but extremely useful font formatting in most applications. Strikethrough font can be a good great way to...

4 Ways to Wrap Text in Excel

by John MacDougall | 2021-03-05 | Tutorials | 0 Comments

Learn 4 ways to apply a wrap text formatting to your text data in Excel.

3 Ways to Transpose Data in Excel

by John MacDougall | 2021-02-14 | Tutorials | 0 Comments

Learn 3 easy ways to transpose your data in Microsoft Excel.

8 Ways to Split Text by Delimiter in Excel

by Richard Shepherd | 2020-12-28 | Tutorials | 7 Comments

When data is imported into Excel it can be in many formats depending on the source application that has provided it. For example, it could contain...

9 Ways to Copy and Paste as Values in Excel

by John MacDougall | 2020-12-25 | Tutorials | 4 Comments

Copying and pasting is a very frequently performed action when working on a computer. This is also true in Excel. It's so common that almost...

8 Ways to Extract the Month Name from a Date in Excel

by John MacDougall | 2020-12-06 | Tutorials | 5 Comments

Learn how to extract the month name from a date in Microsoft Excel.

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.

Nayem

Pune, India

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

Janet

Seattle, USA

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

Hans

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.

Joe

Galway, Ireland

Get the FREE Book!

Subscribe to our newsletter to get awesome in Excel!