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.

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

Create A Dynamic Traffic Light Visual For Your Excel Dashboards

by John | 2019-02-12 | Charts | 0 Comments

I learnt a cool new trick in PowerPoint yesterday. I learnt about merging shapes. Like Excel, PowerPoint has the ability to draw various shapes into...

Integrating Power BI And PowerApps

by John | 2019-02-03 | Power BI, PowerApps | 0 Comments

Learn how to integrate Power BI and PowerApps. Embed a PowerApp into a Power BI dashboards or embed a Power BI visual into PowerApps.

Bulk Find And Replace In Power Query

by John | 2019-01-28 | Get & Transform, Power Query | 0 Comments

Learn how to do a bulk find and replace in power query based on a list of values.

Replicate Excel’s TRIM Function In Power Query

by John | 2019-01-17 | Get & Transform, Power Query | 0 Comments

Learn how to build a custom query function in power query that will replicate Excel’s TRIM function.

Summarizing Text Data With Pivot Tables

by John | 2019-01-13 | DAX, Pivot Tables, Power Pivot | 0 Comments

Learn how to summarize text data in the values area of a pivot table using the data model and DAX formulas.

Introduction To Power Query M Code

by John | 2018-12-23 | Get & Transform, Power Query | 7 Comments

Learn the basics of power query’s M code language with this complete guide to M code.

Create Amazing Key Performance Indicator Data Cards In Excel

by John | 2018-12-19 | Charts, Pivot Tables | 1 Comment

Learn how to create some super cool key performance indicator (KPI) data cards in Excel to show off important metrics in your dashboards.

Sending SMS Text Messages From Excel

by John | 2018-11-16 | Microsoft Flow, Tutorials | 4 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.

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!