Math Student Help

See how to Copy or Export only visible Excel worksheet data retaining all formulas, subtotals and worksheet formatting and deleting all hidden rows and hidden columns.

Duration : 0:6:34

(more…)

Learn how to convert worksheet data to a matrix for Surface and Contour Plots, when x and y values are present in the first column and one of the column lable rows.

Duration : 0:5:12

(more…)

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

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

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

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