http://www.TeachExcel.com
How to protect a worksheet and workbook in excel. This will prevent unauthorized people from editing, deleting, or changing data in excel.
Follow along with the spreadsheet used here and get more stuff including templates, macros, keyboard shortcuts, etc. on the website:
http://www.TeachExcel.com
Duration : 0:7:44
http://www.ExcelisHell.com
How to print multiple worksheets and workbooks in excel.
Follow along with the spreadsheet used here and get more stuff including templates, macros, keyboard shortcuts, etc. on the website:
www.ExcelisHell.com
Duration : 0:4:36
Create multiple identically formatted Excel worksheets by automatically splitting the data in one Excel worksheet by all values or only selected values in any one column. Easily exclude data in hidden columns and hidden rows. Create new split worksheets in one workbook or in multiple workbooks.
Duration : 0:3:11
http://www.ExcelisHell.com
How to link cells between separate worksheets in the same file (workbook) within excel. This method also allows you to add formulas and functions in one cell and have those formulas affect data on a separate worksheet.
Follow along with the spreadsheet used here and get more stuff including templates, macros, keyboard shortcuts, etc. on the website:
www.ExcelisHell.com
Duration : 0:4:10
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