Use the Consolidate Feature to Combine Data

Do you want to combine tables together?  Lets say you have sales data that span multiple columns but there rows and rows of values.  Also there are multiple worksheets (or tabs) that have the same format.  The only difference is that one worksheet if for salesperson A and the other worksheet is for salesperson B.  Now with two sales people the act of combining this together would be a simple copy/paste.  However if you have more sales people (like 10, 15, or more!), that would be a lot of copying and pasting.  Instead of doing that, just use the consolidate feature in Excel to do the heavy lifting.  See how it's done with this video.

Create an Invoice in Excel

Do you own a small business or run side hustle? You have customer and want to create some kind of invoice to bill them. If you've got Excel, you can create a basic invoice with lookup and auto-sum features that can be used and re-used. See the video to learn how.

Use a VLOOKUP to Get Values for Multiple Columns

If you're familiar with VLOOKUP, you may have usually used it to match some value and bring back another value from one cell. With some combination of function you can actually bring back multiple values with the VLOOKUP function. Take a look at this video show how to bring back values from multiple columns from a VLOOKUP. The values could then be used in another function like SUM or AVERAGE.