50_Tips_to_Master_Excel_hardbackcoverstanding_800x1200 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_794x1145 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

Welcome To How To Excel!

Picture-of-me-e1493567754338 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


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


Stylish templates to impress your boss and co-workers!

064-Functions-Icon-001 Home


Learn all about Excel’s many functions.

064-VBA-Code-Icon-001 Home


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

064-Charts-Icon-001 Home


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

101+ Awesome Resources to Help You Learn Excel

My Top 10 Favourite Websites or Blogs Excel Campus Jon Acampora Jon's posts are so detailed and thorough that...
Read More

The Complete List Of Excel Keyboard Shortcuts

  Relying on the mouse to navigate in Excel all the time can be very inefficient. Learning keyboard shortcuts can save you massive amounts of...
Read More

How To Build Your Pivot Tables

What questions do we want to answer about our data?   Let's create pivot tables to answer these questions about our sales data. What were the...
Read More

How To Transform Data by Example

Microsoft Excel has just released a cool new add-in called Transform Data by Example to help make cleaning and transforming data easier. This...
Read More

How To Create A Pivot Table

In this tutorial, we'll take you through the steps to create a new Pivot Table. It's generally a good idea to turn the data for your pivot table...
Read More

How To Export Your Data Into Separate Workbooks Based On The Values In A Column

Something that comes up time and time again in any kind of work is separating data out into separate workbooks based on the values of a field in the...
Read More

How To Make A Pizza Pie Chart

Get The Completed...
Read More

About Pivot Tables

What Are Pivot Tables?   Pivot tables are one of Excel's most powerful tools. They allow you to quickly turn thousands of rows of data into...
Read More

6 Keyboard Shortcuts For Moving Within A Range Selection

  These are keyboard shortcuts for moving the active cell around a selected range of cells. Enter - Move the active cell one cell in a...
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.


Pune, India

How To Excel is the best free site I’ve found for learning anything excel related. I would highly recommended it!


Seattle, USA

I’ve never seen such well thought out Excel lessons before. Thank you so much and keep up the good work!


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.


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