Freedom Accounting and Training

How to use the advanced filter feature. Filter using multiple criteria.

Filter using multiple criteria using the Advanced Filter feature You can filter a table of data to a new location with multiple criteria using the advanced filter feature.

Get a total amount given a range of dates. If you have a spreadsheet of individual sales and would like to pull a total by rep for a range of dates, this is for you. Other functions like unique, filter, sumif, sumifs are also used.

Also, there is a link to download the spreadsheet used in the video.

Total Sales for a Range of Dates - Tracking Sales Spreadsheet in Excel range multiple formulas, you can make a sales tracking spreadsheet very easily. I have used some...

Date functions in Excel videohttps://youtu.be/VcAK4Z9XAYo

Date functions in Excel simple date functions in excel. If you want to track your time on a project, break, exercise, etc. If this video...

Latest excel video on creating a helper row. I use this quite a bit.

Using an IF formula to create a helper column $Use an IF statement and the filter function to create a helper column to filter your spreadsheet. Useful for filte...

Need to find the last value in a column of (continuous) values? Check out the latest.

Find the last value in a column using Index and CountA functions. Ever need to find the last value in a column? Either as part of a formula or just to show it at the top of the list? Use ...

The latest video on vlookup and iferror.

vlookup and iferror excel functions look at the vlookup formula and a neat look at the iferror function. vlookup has been a staple when pulling da...