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.
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.
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.
This video will teach you how to master the Vlookup in Excel.
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.
In this video, I share 3 examples of formatting text in Excel. This often becomes a very useful time saver for me.