50_Tips_to_Master_Excel_hardbackcoverstanding_250x380 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!
Get The FREE Book
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!
Get The FREE Course
The-Complete-Guide-To-Keyboard-Shortcuts-250x500 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.
Get The FREE Book
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…
Get The FREE Book

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

Tutorials

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

Templates

Stylish templates to impress your boss and co-workers!

064-Functions-Icon-001 Home

Formulas

Learn all about Excel’s many functions.

064-VBA-Code-Icon-001 Home

VBA

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

064-Charts-Icon-001 Home

Charts

Learn to visualize your data.

064-Keyboard-Icon-001 Home

Shortcuts

A comprehensive list of 250+ keyboard shortcuts!

064-Earth-Globe-Icon-001 Home

Resources

The top Excel sites from around the world wide web!

The Latest Posts

View All

Import XML Files into Excel

by | 2018-07-15 | Power Query | 0 Comments

In this post we’ll take a look at how to import an XML file into Excel and turn it into a more human readable table format. Excel has support for XML files and it’s actually really easy to import and covert them to tables using Power Query

Read More

7 Ways to Add Running Totals in Excel

by | 2018-07-06 | General | 0 Comments

In this post we’ll cover multiple ways to calculate a running total in Microsoft Excel. We’ll explore how to use worksheet formulas, pivot tables, power pivot with DAX and power query for running totals. We’ll also explore what happens to the running total calculation when inserting or deleting rows of data and how to update the results.

Read More

Amazing Power Query Tips and Tricks

by | 2018-06-11 | Get & Transform, Power Query, Tips & Tricks | 1 Comment

Power query is amazing tool that allows you to import and transform data with ease and helps to create repeatable and robust procedures with your data. Here are some tips and tricks to help you get the most out Power Query.

Read More

Create Grouped Serial Numbers with Power Query

by | 2018-05-26 | Power Query | 0 Comments

Learn how to add grouped serial numbers to your data using Power Query.

Read More

Amazing Excel Tips and Tricks

by | 2018-05-12 | Tips & Tricks | 0 Comments

A compilation of the best Excel tips and tricks ranging from beginner to pro that will save you time and make you more productive.

Read More

Adding Metadata to a Report with Power Query

by | 2018-05-06 | Get & Transform, Power Query | 0 Comments

This post will show you how to import the metadata from a CSV file into our report data with power query (also called Get & Transform).

Read More

Transform a Column to a Table with Power Query

by | 2018-04-28 | Get & Transform, Power Query | 4 Comments

Use power query to transform a single column into a table.

Read More

How To Automate Sorting, Hiding, Unhiding and Listing Your Sheets

by | 2018-04-01 | VBA | 0 Comments

It's often the case that workbooks get very large and end up with a lot of sheets. Excel doesn't have a lot of built in functionality to make...
Read More

How To Get All Sheet Names From All Workbooks In A Folder

by | 2018-03-21 | Get & Transform, Power Query | 3 Comments

It's a task I've had to do before. Get a list of all the sheet names in a workbook with 100+ sheets in it. With a bit of VBA know-how, it can be...
Read More

Everything You Need to Know About Excel Tables

by | 2018-03-18 | Tutorials | 1 Comment

Learn everything there is to know about Excel Tables. This post will tell you about all the awesome features Excel Tables have and why you should start using them.

Read More

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!

Subscribers So Far

50_Tips_to_Master_Excel_hardbackcoverstanding_250x380 Home

Pin It on Pinterest

Share This