Freedom Accounting and Training

08/26/2022

Update your charts easily and quickly!

If you have a chart linked to a range of data and want to expand it, use this quick, easy trick. Mind blown!!!This video answers the question:Is there an ea...

08/24/2022

Paste without losing your formatting!

Use this simple trick to paste your formula without losing the formatting of the cells you are pasting into.

08/24/2022

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

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

08/22/2022

Excel formatting tip.

If you have narrow columns (many narrow columns) with not so narrow headers, then use this trick to rotate the copy!

10/30/2021

Enjoy the video! Its a short one. More on the TIkTok and YouTube pages.

06/22/2021

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.

range multiple formulas, you can make a sales tracking spreadsheet very easily. I have used some...

05/17/2021

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

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

05/12/2021

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

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

04/20/2021

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

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

04/17/2021

Here are two ways to get a unique list of values.

the Unique function or the remove duplicates function to get a list of unique values.If this video is helpful for yo...

04/14/2021

The latest video on vlookup and iferror.

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

04/09/2021

Short video on Excel case functions (Upper case, lower case, proper case).

't you hate it when someone sends you a list of names in ALL CAPS and it needs to be in the proper case?...