How to use Excels Filtering Tool to examine your spreadsheet data.

Excel’s filtering tool is an incredibly useful feature that allows you to sift through large amounts of spreadsheet data with ease.

With the filtering tool, you can filter data based on criteria you define, such as text or number values. This makes it easy to find the data you need and focus on the information that’s most important to you.

The filtering tool is also incredibly versatile. You can use it to filter data in a table or range of cells, and you can filter data based on multiple criteria at once. Additionally, Excel’s filtering tool is easy to use and can be accessed with just a few clicks.

Overall, Excel’s filtering tool is an essential feature for anyone who works with large amounts of spreadsheet data.

It saves time and effort by allowing you to quickly find the information you need and focus on the data that’s most important to you.

In this short video we will ‘Walk you Through’ the process of how to use Filtering within your Excel application and then explain the use of Macros in the context of our EASY Accounting Spreadsheet products.

We have also created a further 3 support videos covering:

How to keep your Monthly Accounts using Excel
How to create Trusted Locations in Excel and store files that use Macros.
And A comprehensive overview of the VAT processes including the your MTD submissions to HMRC.

These additional videos can be viewed by following the links in the description section below.

.....................................................................................................................................................................

Here are the links to the various Mr.SpreadSheet resources available to you.
Please help support our channel by subscribing.
Many thanks

The other support videos in this series are:

How to use Spreadsheets to keep your Monthly Accounting Records
How to create Trusted Locations in Excel and store files that use Macros.
Making Tax Digital – How to use spreadsheets to collect and submit your VAT

Visit our websites at:
USA & Canada & World - https://www.MrSpreadSheet.com
UK & Europe - https://www.MrSpreadSheet.co.uk

Our Social channels:-

FaceBook -   / mrspreadsheets  
Instagram -   / mrspreadsheet  
Twitter -   / mr_spreadsheet  

#MrSpreadSheet #Excel #spreadsheet #exceltutorial #msexcel #Accounting