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.

Create a Hyperlink in Excel

Almost like a web page, you can create hyperlinks in Excel. This vidoe show how to create hyperlinks in Excel using the Insert Hyperlinks feature and also with the HYPERLNKS function. In addition it will cover how to turn off that sometime annoying feature of automatic hyperlink creation.

Create an X Y Scatter Chart with Data Labels

How to create an X Y Scatter Chart with Data Label. There isn't a function to do it explicitly in Excel, but it can be done with a macro. The Microsoft Knowledge base article describes it. See the link to the article (along with the Macro code) at http://support.microsoft.com/kb/213750

Create a Header or Footer in Excel

How to create a header or footer for your excel document. You can provide information such as date printer, page numbers, or the file name in the header or footer areas when the file is printed out. Show two way to configure this.