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

7 Ways to Extract the First or Last N Characters in Excel

by Richard Shepherd | 2020-10-04 | Tutorials | 0 Comments

This article describes seven ways in which you can extract the first or last N characters from a string of text data in Microsoft Excel.

3 Ways to Calculate a Pearson’s Correlation Coefficient in Excel

by John | 2020-08-23 | Statistics, Tutorials | 2 Comments

Learn 3 easy ways to calculate the Pearson’s Correlation Coefficient statistic in Excel.

9 Ways To Add Leading Zeros In Excel

by John | 2020-05-14 | Tutorials | 0 Comments

Learn 9 ways to add or keep leading zeros for your numbers in Microsoft Excel.

25 Awesome Microsoft Teams Tips and Tricks

by John | 2020-05-04 | Teams | 2 Comments

25 of the BEST tips and tricks for working with Microsoft Teams.

5 Ways to Convert Excel Files to PDF

by John | 2020-04-19 | Tutorials | 0 Comments

Learn 5 ways to convert your Excel files to PDF documents.

5 Ways to Get the Current Date or Time in Excel

by John | 2020-04-14 | DAX, Functions, Power Automate, Power Pivot, Power Query, Shortcuts, Tutorials | 1 Comment

Learn 5 different ways to add the current date or time into Excel with keyboard shortcuts, functions, power query, power pivot and power automate.

5 Easy Ways To Create A Data Entry Form In Excel

by John | 2019-12-24 | Tutorials | 0 Comments

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

by John | 2019-12-20 | Tutorials | 2 Comments

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

by John | 2019-11-13 | Tutorials | 3 Comments

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

by John | 2019-09-24 | Functions | 0 Comments

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

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!