This video show you how to use the TREND function to predict future monthly sales (from one to multiple months) based on historical values. Use this Excel statistical function to help you forecast your sales and potential revenues for products or services.
Monday, June 3, 2019
Wednesday, May 29, 2019
Show Only a Few Rows or Columns
How to show only a few rows or columns in a worksheet. Two examples one using the Hide feature (2:19) and the other limiting the scrolling area (4:37).
Tuesday, May 28, 2019
Use VLOOKUP to Find the 2nd Match (or nth Match)
If you are familiar with the VLOOKUP function it's a great tool to lookup values in a range or table. However it will only bring back the first instance of the looked up value. What if you wanted the second instance of the value or even have all the instances of the value brought back? This could be done by using a helper column and the COUNTIF function. Watch the video to see how it's done!
Subscribe to:
Posts (Atom)