Math Student Help

See how to quickly format data, create a reusable Excel worksheet format template, and reuse the format template to auto create an identically formatted worksheet in seconds.

Duration : 0:3:21

(more…)

This macro will consolidate data from all the worksheets in a workbook and present the total from all the worksheets. The video here is on consolidating data from preparing income tax returns forms.

Duration : 0:5:51

(more…)

Save an Excel worksheet as HTML by going to format on the top menu and clicking options and choosing HTML after saving the document first. Save an Excel worksheet as an HTML document with tips from an istant certified public accountant in this free video on Microsoft Excel.

Expert: Amar Enhsaihan
Bio: Amar Enhsaihan is an istant certified public accountant (CPA) and works with Excel applications everyday on his job.
Filmmaker: Bing Hu

Duration : 0:1:24

(more…)

Microsoft Excel worksheet protection demo

Duration : 0:5:26

(more…)

Using HLOOKUP function to generate grades from marks (can be adapted)

Duration : 0:2:12

(more…)

http://www.TeachExcel.com
This will teach and show you how to use the vlookup function between separate worksheets and workbooks in excel.

You will learn how to use the vlookup to search through lists in closed workbooks and in separate excel files.

To follow along with the excel spreadsheet seen here and to find more excel stuff including free macros, keyboard shortcuts, and a forum, go to:

http://www.TeachExcel.com

Duration : 0:6:23

(more…)

Using VLOOKUP in one worksheet to look up values located in a second worksheet

Duration : 0:2:8

(more…)

Learn how to create worksheet and workbook references in formulas.

This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Duration : 0:8:41

(more…)

How to use worksheet tabs in excel

Duration : 0:0:56

(more…)