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.

Tips & Tricks

Tips & tricks to super charge your Excel skills!

Templates

Stylish templates to impress your boss and co-workers!

VBA

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

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 Find And Remove Duplicate Values In Microsoft Excel

by John | 2019-07-13 | General, Tutorials | 0 Comments

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

by John | 2019-07-05 | PowerApps, Tutorials | 0 Comments

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]

by John | 2019-06-24 | General, Tutorials | 3 Comments

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

by John | 2019-06-10 | General | 2 Comments

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

The Complete Guide to Rich Data Types in Excel

by John | 2019-05-09 | General, Tutorials | 0 Comments

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.

6 New Functions in Excel 2019 and Office 365 You Must Learn

by Aprajita Sharma | 2019-05-07 | Functions | 5 Comments

Microsoft Excel is a Powerful Tool, Period. And once you are loaded with all the basics of Microsoft Excel, it’s important for you to master the...

5 Ways To Change Text Case In Excel

by John | 2019-04-30 | DAX, Functions, Power Pivot, Power Query, Tutorials | 0 Comments

Learn how to change text case between lower, upper and proper case in Excel using Excel functions, flash fill, power query, DAX and power pivot.

Create A Thermometer Visual To Display Actual Versus Target

by John | 2019-04-23 | Charts | 0 Comments

In this post, we're going to take a look at how we can build a custom thermometer visual to display a current value against a goal. This is a pretty...

37 Awesome Excel Mouse Tips & Tricks You Should Know

by John | 2019-04-15 | Shortcuts, Tips & Tricks | 0 Comments

While the keyboard is generally quicker, you shouldn’t completely ignore the mouse. There are also some great time saving mouse shortcuts as well. In this post we’ll take a look at some of the best Excel mouse time saving tips and tricks.

Copy And Paste Data From Excel Into Power BI

by John | 2019-04-03 | Power BI | 0 Comments

Learn how to copy and paste data from an Excel workbook or text file into Power BI using the Enter Data feature.

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 recommended 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!