Select Page

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

## 10 Part Video Course

• A completely FREE course
• Workbooks to follow along with
• Clear and concise examples
• Bonus lesson: conditional formatting!

## 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

• 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

# 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.

#### Keyboard Shortcuts

A comprehensive list of 250+ keyboard shortcuts!

#### Other Resources

The top Excel sites from around the world wide web!

# The Latest Posts

View All

## Right Click for a Drop Down List

Did you know you can make a drop down list for selecting an item with just a right click? Yep! I never really noticed it, but there's an option in...

## How to Create a Normally Distributed Set of Random Numbers in Excel

What is a Normal Distribution? From a purely mathematical point of view, a Normal distribution (also known as a Gaussian distribution) is any...

## How To Select A Random Item With A Given Distribution

Not all data is numeric, so when creating random sets of sample data it can be very useful to know how to randomly select some text data from a...

## How To Select A Random Item From A List

This formula will return a random selection from a given list with each item in the list having an equal probability of being selected.

## How To Unpivot Data With Power Query

This situation happens a lot. Someone creates a pivot table based on some source data. They copy and paste it as values and that becomes your new...

## How To Parameterize Your Power Query

When you create a power query in Excel to import and or transform your data, Excel is creating the query behind the scenes in a language called M....

## 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 can be a great place for beginners to ask questions to the community or have a go at answering them. Since you're likely...

## 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...

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