Master the VLOOKUP

Everything you need to know to master the VLOOKUP What is a VLOOKUP Function? Whenever you keep track of anything with spread sheets, there’ll come a time when you want to find information without having to scroll through a list or Table. That’s when the...

How to use the SUM Function in Microsoft Excel

How to use the SUM Function in Microsoft Excel This quick video explains how to use the SUM Function in Excel. Learn how to add rows and columns of data quickly and easily using Excel’s built-in SUM function – use the ribbon or type the function directly into a cell....

Page width and height settings/Scaling

Page Width and Height Settings/Scaling This quick video explains the Page Width and Height Setting for Printing your worksheet in Excel. When printing a spreadsheet there are many situations that arise when trying to get a spreadsheet to fit on a page. Dealing with...

Date / Time Formatting

Date / Time Formatting This quick video will show you how to change the appearance of the Time and Date in your worksheet. Changing the appearance of the date and time is very useful in presenting spreadsheets. Many errors in Excel occur because of incorrectly...

Copy and paste into other worksheets

Copying and Pasting into other Worksheets This quick video will show you how to Copy and Paste into other Worksheets in Excel. Learn to move and copy data between worksheets on the same workbook. If you find your spreadsheet results misbehaving after a copy paste you...

Copy and paste into Word and PowerPoint

Copy and Paste into Word and PowerPoint This quick video will show you how to Copy and Paste from Excel into Word and PowerPoint. Learn to copy Excel spreadsheets tables and charts from Excel in Microsoft Word and PowerPoint. This is very useful when preparing reports...