Excel

Excel

Learn how to get the most out of Microsoft Excel.
Save time, work smarter and improve your understanding with our in-depth articles, tips, hacks, video and step-by-step examples.
We’ve organised our posts into different levels and topics so that you can easily find what you need.

Learn how to get the most out of Microsoft Excel. Save time, work smarter and improve your understanding with our in-depth articles, tips, hacks, video and step-by-step examples. We’ve organised our posts into different levels and topics so that you can easily find what you need.


Most Popular Blogs


How to Remove Empty Rows in Excel
Excel Ctrl End goes too far
Best Keyboard Shortcuts for Excel Beginners | Tips and Tricks

Just starting out? If you're an Excel Beginner you’ll want to check out these blogs. Learn the essential skills needed to confidently create Excel worksheets that are both professional in look and design.

Excel Basics

Just starting out? If you're an Excel Beginner you’ll want to check out these blogs. Learn the essential skills needed to confidently create Excel worksheets that are both professional in look and design.

Filter & Sort

How to Remove Empty Rows in Excel
How to Sum only visible cells in Excel when using Filter
5 Reasons why your Excel filter may not be working

Learn how to Filter and Sort your data in Excel. Step-by-step articles and examples to help you get the best results.

Filter & Sort

Learn how to Filter and Sort your data in Excel. Step-by-step articles and examples to help you get the best results.

Excel Filter Not Working?

Are you are having a few hassles when filtering?

Is the filter not working properly or as you would like it to?

Here are some reasons why your Excel filter may not be working.

Excel Filter Not Working?

Are you are having a few hassles when filtering? Is the filter not working properly or as you would like it to? Here are some reasons why your Excel filter may not be working.

Learn how to become a pro at Pivot Tables...

Average formula in Excel – AVERAGE, AVERAGEIF, AVERAGEIFS function
Excel – How do I change a Pivot Table back to the classic (version 2003 and earlier) display?
Excel – Group dates by month in a Pivot Table
Remove spaces Excel TRIM function misses
How to add 0 in front of a Number in Excel
How to create a list of Working Days – Excel WORKDAY function

Need to master Excel functions? This may be the best place for you to start. Learn the most Excel popular functions and super useful formulas.

Excel Stage 3 - Combine, Analyse & Report

Popular Functions

Need to master Excel functions? This may be the best place for you to start. Learn the most Excel popular functions and super useful formulas.

Excel Stage 3 - Combine, Analyse & Report

How To: Compare Two Columns in Excel using VLOOKUP

If you want to save yourself a huge amount of time when reconciling data, learn how to use VLOOKUP to compare two columns in Excel.

How To: Compare Two Columns in Excel using VLOOKUP

If you want to save yourself a huge amount of time when reconciling data, learn how to use VLOOKUP to compare two columns in Excel.

Learn Excel essential formulas

How to create basic Excel formulas
Average formula in Excel – AVERAGE, AVERAGEIF, AVERAGEIFS function
How to do a VLOOKUP with multiple criteria in Excel

Free Email Bonus

Best Excel Shortcuts Cheat Sheet

Need to learn how to quickly remove spaces in Excel? Extra spaces can appear in your worksheet for lots of different reasons such as someone ...continue reading >

It can be frustrating when you’re trying to type a zero in front of a value or a number in Excel and it just disappears.In ...continue reading >

How To: Do Subtract Formula in Excel 

Are you wanting to learn how to subtract in Excel?

In this video I will teach you multiple ways to use a subtract formula that will help you become confident with subtraction in Excel.

How To: Do Subtract Formula in Excel 

Are you wanting to learn how to subtract in Excel?

In this video I will teach you multiple ways to use a subtract formula that will help you become confident with subtraction in Excel.

All Excel Posts


Page [tcb_pagination_current_page] of [tcb_pagination_total_pages]

Free Email Bonus

100+ Steps to Becoming Proficient in Excel

>