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

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

Keyboard Shortcuts

A comprehensive list of 250+ keyboard shortcuts!

064-Earth-Globe-Icon-001 Home

Other Resources

The top Excel sites from around the world wide web!

The Latest Posts

View All

How To Create A Hyperlink To The Current Workbook Folder

This formula will create a hyperlink that opens a file explorer window to the folder location where the current workbook is saved.

Excel Social Communities

These groups are can be a great place for beginners to ask questions to the community or have a go at answering them. Since you're...

How To Get The Current Workbook Folder Path

This formula will return the folder path where the current workbook is saved.

How To Query A Query In Power Query

Today I was using power query to import external data in a CSV file and then do some transformations on the data. I decided I wanted to import my...

How To Extract Data From Multiple Webpages With Power Query

Excel's Power Query (or Get & Transform since Excel 2016) is a great tool for building queries to get data from the web. Within a couple of minutes...

How To Calculate The Volume Of A Sphere

This formula will calculate the volume of a sphere given its radius.

How To Count The Number Of Items Less Than The Average

This formula will take the average of a numerical range then return the count of the items in the range that are less than the average.

Moz Open Site Explorer Template

This template allows you to pull data from Moz Open Site Explorer (OSE) into Excel using Power Query (Get & Transform in Excel 2016). Moz OSE is an...

How To Create Table Relationships

Excel isn't a database, but that hasn't stopped people from using it as one. People have been doing this since early versions of Excel and creating...

101 Advanced Pivot Table Tips And Tricks You Need To Know

Pivot tables are awesome! They’re one of Excel’s most powerful features, they allow you to quickly summarize large amounts of data in a matter of seconds. This collection of awesome tips and tricks will help you master pivot tables and become a data analysis wizard!

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_300x400 Home

Pin It on Pinterest

Share This