Excel Tables Tips and Tricks
In this Excel video, I will teach how to take advantage of Excel tables. There are plenty of tips and tricks to manage your data tables.
How to use PivotTables for Bookkeepers
This video will teach you some tips and tricks on how to use Excel PivotTables for bookkeepers. It will show you things that can trip you up in a PivotTable and how to effectively report on your expenses.
How to conditionally format budget items in Excel row by row
In this video, I share a favorite trick of mine to format an entire transaction's row in Excel with a fill color based on a budget item.
How to do a Vlookup in Excel
This video will teach you how to master the Vlookup in Excel.
Use Goal Seek in Excel to find a target value
Goal Seek is a great feature in Excel to find a target value. You can find Goal Seek within the Data Tab under the what-if button. In this example, I will share with you how to answer how much new revenue much we achieve to produce $10,000 in profit. Goal Seek options setup Goal Seek Results: The value is $8,050 in new product revenue will yield a profit of 10K.
Conditional Format certain text in Excel
In this video, I share 3 examples of formatting text in Excel. This often becomes a very useful time saver for me.