50_Tips_to_Master_Excel_hardbackcoverstanding_300x400 Home

50 Tips to Master Excel

  • 40 plus keyboard shortcuts!
  • Packed with hidden features you won’t find anywhere else!
  • Top time saving tips that will reduce your work!
  • Easy to follow illustrated tips!
  • Something for every level from beginner to pro!
dvdcasestandingclosed_300x500 Home

10 Part Video Course

  • A completely FREE course
  • Workbooks to follow along with
  • Downloadable videos to watch offline
  • Clear and concise examples
  • Bonus lesson: conditional formatting!
The-Complete-Guide-To-Keyboard-Shortcuts-300x600 Home

The Mega Book of Excel Shortcuts

  • 350+ shortcuts in total.
  • Includes 100+ Visual Basic Editor shortcuts.
  • Full of shortcuts that will save you time!
  • Packed with hidden shortcuts you won’t find anywhere else!
  • Organised by category.
The-Ultimate-Guide-To-VLOOKUP-Cover-300x500 Home

The Ultimate Guide To VLOOKUP

  • Fully explained: what it does and how it works
  • Detailed syntax with examples
  • Using wildcards with VLOOKUP
  • How to use the approximate match
  • Much much more

Welcome To How To Excel!

John-Macdougall-work-profile-photo-525x525 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

11 Awesome Examples of Data Validation

Data Validation is a very useful Excel tool. It often goes unnoticed as Excel users are eager to learn the highs of PivotTables, charts and formulas.

It controls what can be input into a cell, to ensure its accuracy and consistency. A very important job when working with data.

How To Combine And Unpivot With The Pivot Table Wizard

You've probably come across data that looks something like this before. It's usually created by someone who doesn't know what data should look like...

How to Deal with Changing Data Formats in Power Query

Power Query is an amazing tool since it allows you to set up a query once and then refresh it whenever you get new data files. But what if your data...

The Complete Guide to Power Query

What is power query? Power Query is a business intelligence tool available in Excel that allows you to import data from many different sources and...

How to Create Delete and Rename Folders from a List

I started making videos to go along with my post on pivot tables called 101 Advanced Pivot Table Tips And Tricks You Need To Know. I wanted to be a...

2017 Year in Review for How To Excel

I thought it might be a good idea to review the last year and what's happened with this site since I started it. I know the year end review is a...

How To Access A JSON API With Power Query

In this post I'll show you how to hack into tons of top secret government data using Excel. Ok, by "top secret", I actually mean a database API made...

How To Conditionally Concatenate A Range

This formula will conditionally concatenate a range based on a criteria in another range.

How To Generate All Possible Combinations Of Items From Two Lists

Given two separate lists of items, how can you create a list of all possible combinations from those lists? In this post, I'll show you how this can...

How To Get A List Of File Names From A Folder And All Subfolders

This post will explore how we can easily create a file inventory from a folder and all of its subfolders using Power Query.

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!

Subscribers So Far

50_Tips_to_Master_Excel_hardbackcoverstanding_300x400 Home

Pin It on Pinterest

Share This