50_Tips_to_Master_Excel_hardbackcoverstanding_250x380 Home

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

Sending SMS Text Messages From Excel

by John | 2018-11-16 | Microsoft Flow, Tutorials | 0 Comments

In this post we are going to learn how to send SMS text messages from Excel... because why not? Yep, Excel can do pretty much everything, and that...

Importing and Exporting Data from SharePoint and Excel

by John | 2018-10-02 | Tutorials | 2 Comments

Learn how to import and export data from SharePoint and Excel using built in export features or using power query.

4 Ways to Remove Unwanted Space Characters

by John | 2018-09-27 | Functions, Power Query, Tutorials, VBA | 2 Comments

Learn how to remove unwanted space characters from text data in Excel using various methods.

Sending Emails from Excel with Microsoft Flow

by John | 2018-08-09 | General, Microsoft Flow, Tutorials | 5 Comments

Learn how to build an automated process that schedules and sends emails from Outlook based on the data in an Excel file using Microsoft Flow.

5 Ways to Concatenate Data with a Line Break in Excel

by John | 2018-07-23 | General, Tutorials | 0 Comments

Learn 5 ways to concatenate the data and separate each item with line breaks. Combine many different cells into one but keep each on its own line in the cell.

Import XML Files into Excel

by John | 2018-07-15 | Get & Transform, Power Query | 7 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

7 Ways to Add Running Totals in Excel

by John | 2018-07-06 | General, Tutorials | 1 Comment

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.

25 Amazing Power Query Tips and Tricks

by John | 2018-06-11 | Get & Transform, Power Query, Tips & Tricks | 6 Comments

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.

Create Grouped Serial Numbers with Power Query

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

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

Amazing Excel Tips and Tricks

by John | 2018-05-12 | Tips & Tricks | 1 Comment

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

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!