Freedom Accounting and Training

Update your charts easily and quickly!

Update your chart instantly (almost) 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...

Paste without losing your formatting!

Paste a formula down a column WITHOUT losing the existing formatting!! Use this simple trick to paste your formula without losing the formatting of the cells you are pasting into.

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.

Excel formatting tip.

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

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

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

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

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

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

Excel text case functions (upper, lower, proper) 't you hate it when someone sends you a list of names in ALL CAPS and it needs to be in the proper case?...