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
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
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
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
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
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
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
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
Using HLOOKUP function to generate grades from marks (can be adapted)