Posts Tagged ‘workbook’

Excel Magic Trick 326: Hyperlink Worksheet To Worksheet

Friday, August 14th, 2009

See how to create a hyperlink from one sheet to another sheet in the same workbook.

Duration : 0:3:0

(more…)

Potect a Worksheet and Workbook in Excel

Thursday, July 16th, 2009

http://www.ExcelisHell.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:

www.ExcelisHell.com

Duration : 0:7:44

(more…)

Split Excel Worksheet to New Workbooks

Friday, July 3rd, 2009

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

(more…)

Excel Export Worksheet Data to Notepad, Wordpad or Any Text File

Sunday, June 21st, 2009

http://www.ExcelVisualBasics.com - Tutorial on how to export worksheet data in your Excel worksheet to a file on your hard drive like a notepad file, a text file, a wordpad file, or even other file types. You can export an Excel workbook in this fashion.

ExcelVisualBasics shows you visually what vb code actually does BEFORE you waste your time trying to tweak it.

Duration : 0:6:53

(more…)

Highline Excel Class 06: Worksheet & Workbook References

Thursday, May 14th, 2009

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…)