Posts Tagged ‘Microsoft’

Using Microsoft Excel for Beginners : Deleting & Renaming Worksheets in Microsoft Excel

Friday, September 4th, 2009

How to delete and rename worksheets in Microsoft Excel; learn more about spreadsheet software in this free instructional video.

Expert: Gary Zier
Bio: Gary Zier, originally from Florida, is a systems administrator with 10 years of computer networking experience and an expertise in conditional access security systems.
Filmmaker: Gary Zier

Duration : 0:1:52

(more…)

Copy Visible Excel Worksheet Data

Saturday, August 8th, 2009

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

PPT2003: Embed an Excel worksheet that is modified regularly

Thursday, July 30th, 2009

PowerPoint 2003 Lesson 15: Embed an Excel worksheet that is modified regularly

Duration : 0:6:45

(more…)

MrExcel’s Learn Excel #894 - Export Each Worksheet

Thursday, July 16th, 2009

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

Microsoft Excel Tips : How to Rename an Excel Worksheet

Thursday, July 9th, 2009

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

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 2007: Insert and delete rows, columns, and worksheets

Sunday, June 28th, 2009

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

Quickly Format Excel Worksheets

Tuesday, June 16th, 2009

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

Microsoft Excel Tips : How to Save an Excel Worksheet as HTML

Wednesday, June 10th, 2009

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

Sunday, June 7th, 2009

Microsoft Excel worksheet protection demo

Duration : 0:5:26

(more…)