Excel and QBO videos

#textjoin #excel #concatenate Three different ways to join contents of cells as one string each slightly different in its technique. If this video is helpful for you or would be helpful for others you know, please pass this along. Please like the video and subscribe to the page to be alerted when new content is released. Please visit our website for more information on how to contact us or set up an in person training session. Our website is: Freedomact.us

when you have a large range of data and want to eliminate the duplicates, DON'T sort and delete and re-sort! Use this handy built in function instead to save time.

Convert exported data from text to date or from text to number. Works for large amounts of exported data.

How to format rows in Excel with alternate colors and maintain formatting even after a sort.

How to create a drop down list. This function will help maintain consistency between choices and help to eliminate errors created by misspelled entries in your spreadsheet.

A quick video about the xlookup function. Replaces index and match and is 10 times easier and much more intuitive.