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.
I want to use the data set to lookup the items associated by month. At any given month, I want to lookup the values for the revenue and expenses per ID. The IDs are listed above but they are located in merge cells. This creates a problem because typically tables do not have merge cells. But with using the index and match function I can lookup the data I want. I will need to create 3 range names. One for the data range, one for the horizontal labels, and the other for the vertical labels. The index function has 3 arguments. First I use the data range, then I need a row number to go [...]
You can import up to 16 fields into your QuickBooks Online account. Watch this video to learn how. Name Company Customer Type Email Phone Mobile Fax Website Street City State ZIP Country Opening Balance Date Resale Number
This video will teach you how to troubleshoot an address list in Excel. Learn a formula trick to deal with missing zeros in zip codes. Also perform a vlookup to find state abbreviations. And you will learn how to format proper case for names.
In this video I teach you a simple way to add similar items in Excel. I was doing a roster update for my Cub Scout den and needed to get a count of how many boys are in each den. So I used the Countif function.