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
The-Complete-Guide-To-Keyboard-Shortcuts-800x1600 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.

Get The FREE Book

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

How To Count A Specific Character In A Cell (Case Sensitive)

This formula will count the number of occurrences of a given single character within a text string in a single cell. This formula is case sensitive and will consider upper and lower case letters to be different characters.

Read More

How to Get the Last Day of the Month

This formula will return the last day of the month from the date selected.

Read More

How to Get the Current Sheet Name

This formula will return the sheet name of the current sheet.

Read More

How to Extract the First Name From an Email Address

This formula will return the first name with proper capitalization from an email address of the form firstname.lastname@company.com

Read More

12+ Hidden Commands You Can Add to Your Quick Access Toolbar

Excel has a cool feature called the Quick Access Toolbar (QAT) that allows you to add your own frequently used commands to an easily accessible...
Read More

The Complete List Of VBA Keyboard Shortcuts

Visual Basic Editor This is the complete list of visual basic keyboard shortcuts. Some of these will be very familiar like Ctrl + C and Ctrl + V...
Read More

101+ Awesome Resources To Help You Learn Excel

My Top 10 Favourite Websites or Blogs Excel Campus Jon Acampora Jon started Excel Campus in 2009 and has since...
Read More

The Complete List Of Excel Keyboard Shortcuts

Copy And Paste These shortcuts are mostly for copying and pasting objects in the worksheet such as cells, ranges, tables and pivot tables. We can...
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

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