Estimate with a Linear or Power Demand Curve

In Excel you can chart out an estimation of demand with a demand curve. A demand curve gives us an estimation for the relationship between price and the number of units that a customer would demand or the units of what we’d expect to sell. There are two common types of demand curves: a linear demand curve and a power demand curve. With a linear demand curve, the number of units demanded increases in a linear way as price decreases. Supposedly there are very few examples where a linear demand curve exist but it’s useful because it’s simple to grasp. The second common demand curve is the power demand curve. It’s probably something more identifiable for real world examples in the cases where the effect of price changes may have a bigger impact on demand. So you might have a question on which one to use and the best way to do that is to get some data to chart it out. See the video to learn how.

Embed and Caption Name an Excel File in PowerPoint

When you shared PowerPoint and Excel files, sometime you just want to share one item instead of two. You can embed your Excel file into PowerPoint and have it clicked to open up. It works well when you don't expect the contents of the Excel file to change though it could increase the PPT file size depending on the size of the Excel data. You can even give the name to the caption of the embedded file or just give it a click to open text so users know what to do.

Lookup the Last Value in Excel [XLOOKUP & INDEX / MATCH]

Looking up the last value is usually not the default when you perform lookups with various lookup functions. However there are times when you want to find the last item in a list or array that matches a criteria. With the newer XLOOKUP function, it makes this job very easy. The only catch is that XLOOKUP is on newer version of Excel. If you didn't have the latest Excel version, you can still perform a lookup for the last item and that can be done with a combination of the INDEX and MATCH functions.