50_tips_hardcover_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!

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

4 Ways to Wrap Text in Excel

Learn 4 ways to apply a wrap text formatting to your text data in Excel.

3 Ways to Transpose Data in Excel

Learn 3 easy ways to transpose your data in Microsoft Excel.

8 Ways to Split Text by Delimiter in Excel

When data is imported into Excel it can be in many formats depending on the source application that has provided it. For example, it could contain...

9 Ways to Copy and Paste as Values in Excel

Copying and pasting is a very frequently performed action when working on a computer. This is also true in Excel. It's so common that almost...

8 Ways to Extract the Month Name from a Date in Excel

Learn how to extract the month name from a date in Microsoft Excel.

7 Ways to Extract the First or Last N Characters in Excel

This article describes seven ways in which you can extract the first or last N characters from a string of text data in Microsoft Excel.

3 Ways to Calculate a Pearson’s Correlation Coefficient in Excel

Learn 3 easy ways to calculate the Pearson’s Correlation Coefficient statistic in Excel.

9 Ways To Add Leading Zeros In Excel

Learn 9 ways to add or keep leading zeros for your numbers in Microsoft Excel.

25 Awesome Microsoft Teams Tips and Tricks

25 of the BEST tips and tricks for working with Microsoft Teams.

5 Ways to Convert Excel Files to PDF

Learn 5 ways to convert your Excel files to PDF documents.

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

Downloads So Far

50_tips_hardcover_250x380 Home

Pin It on Pinterest

Share This