Math Student Help

More Excel 2007 videos at http://www.LearnMicrosoftExcel.com. You can also download and print the free Excel 2007 tutorial and sample files from the site. The course can be used for both self instruction for Excel beginners and those moving to Excel from an earlier version. The course is structured into session and lessons make it ideal for teachers who wish to run Excel 2007 courses. Weve used years of experience from our classroom courses to perfect our teaching method which will enable you to learn Excel 2007 in a fraction of the time needed when learning from conventional text books.

Duration : 0:7:39

(more…)

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

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

Rod sends in today’s question. He has to export several tab-delimited text files for a third-party application. He has the data for each file on a separate worksheet in a workbook and would like a macro to save those worksheets as individual text files. In Episode 894, I record a simple macro, then edit it to solve Rod’s problem.

Duration : 0:4:42

(more…)

Rename an Excel worksheet by either clicking on the name part of the file and retyping a new name or by right clicking the file and renaming it. Change the name of an Excel worksheet file 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:25

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

See more Excel 2007 demos at http://office.microsoft.com/en-us/help/FX100485311033.aspx In Microsoft Office Excel 2007, you can quickly insert new rows, columns, cells, and worksheets and just as easily delete them — with a few clicks.
Watch the demo to see how fast you can insert and delete individual or multiple rows, columns, cells, and worksheets.

Duration : 0:3:44

(more…)

Another interesting method to access cells when writing VBA macro code in the Visual Basic Editor. Accessing cells using the ‘cells’ property has major advantages when using ‘do while’ and ‘for… next’ loops.

Duration : 0:2:56

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

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

(more…)