Excel Tutorial For Beginners



Microsoft Excel Video Tutorials For Beginners

Excel Tips Tutorial: How to Enter Credit Card Numbers In Excel

Excel Tips Tutorial: How To Make Gantt Chart in Microsoft Excel

Excel Tips Tutorial: Pivot Tables

Excel For Noobs Tutorial: How to use IF function for logical calculation

Excel For Noobs Tutorial: How to use data filtering in MS Excel

Excel Tips Tutorial: How to Use Concatenate Function to Join Cells Together

Excel For Noobs Tutorial: How to create graphs in Excel

Excel Tips Tutorial: How to Insert Cells in Data Tables in MS ExceI

Excel Tips Tutorial: How to Convert Values From One Measurement System to Another

Excel Tips Tutorial: How to Convert Numbers to Text

Excel Tips For Noobs: How To Add Diagonal or Crossed Lines to a Cell

Excel Tips Tutorials: How to Make A Pie Chart in Microsoft Excel

Excel Tips: How to Solve Circularity Errors With Iterations

Excel Tips Tutorial: How To Use Vlookup in Microsoft Excel

Excel Tips Tutorial: How to use SUMIF, COUNTIF and AVERAGEIF Functions in Microsoft Excel

Excel Tips Tutorial: How to Use Conditional Format in Microsoft Excel

Excel Tips Tutorial: How to Connect Links to Excel Worksheets

Excel Tips Tutorial: How To Write Formulas In Excel

Excel Tips Tutorial: How to Find and Replace Values in Microsoft Excel

Excel Tips Tutorial: VBA Visual Basic for Application For Beginners in Microsoft Excel

Excel Tips Tutorial: How to Use Trim, Upper, Lower and Proper In Microsoft Excel

Excel Tips Tutorial: How to Convert a PDF File to Editable Excel File

Excel Tips Tutorial: How to Use Pivot Tables in Microsoft Excel

Excel Tips Tutorial: How to Find and Select Content or Cells in Excel

Excel Tips Tutorial: How to Merge Styles and Themes of Old and New Excel Versions 2003 2007 2010 2013

Excel Tips Tutorial: Microsoft Excel Keyboard Shortcuts

Excel Tips Tutorial: How to Draw a Line Through a Word in Excel - Strikethrough

Excel Tips Tutorial: Horizontal Text Alignment in Excel (General, Left, Center, Right, Fill, Justify, Center across Selection and Distributed)

Excel Tips Tutorial: Vertical Alignment in Excel (Top, Center, Bottom, Justify, and Distributed)

Excel Tips Tutorial: How to Display Text at a 45 Degree Angle (Diagonal Text)

Excel Tips Tutorial: How to add a Background Image (Picture) to an Excel Worksheet

Excel Tips Tutorial: How to Use Format Painter to Copy and Paste Cell Formats

Excel Tips Tutorial: How to Use Cell Styles to Format Cells

Excel Tips Tutorial: How to Change the Default Style of an Entire Excel Workbook Using Cell Styles

Excel Tips Tutorial: How to Create Your Own New Cell Style in Excel

Excel Tips Tutorial: Understanding and Applying Themes in Excel

Excel Tips Tutorial: How to Pin Important Excel File to the Recent Files List

Excel Tips Tutorial: How to Add Folders to the Favorites List in the Open Dialog Box

Excel Tips Tutorial: How to Save Excel Workbook Files

Excel Tips Tutorial: How to Change the Default File Type to Save Excel Workbooks

Excel Tips Tutorial: How to Open and Recover an Unsaved Excel File

Excel Tips Tutorial: Rules for Filenames in Microsoft Excel

Excel Tips Tutorial: How to Print Only an Excel Chart without Printing out the Entire Worksheet

Excel Tips Tutorial: How to Remove Formula Error-Checking Smart Tags

Excel Tips Tutorial: How to Stop Automatically Creating Calculated Columns in Excel Tables

How to Name an Excel Table

Excel 2013 Tutorial: How to Refer to a Named Cell as a Constant

Excel Concatenate Function Tutorial - How to Join Text in Excel

How to Use If Else If Function in Excel 2013 - Nested If Function in Microsoft Excel

Excel Worksheets Tutorial for Microsoft Excel 2013

Absolute, Relative and Mixed Cell Reference Excel Tutorial

Excel 2013 Tutorial Creating and Opening Workbooks in Excel 2013

Excel 2013 Tutorial The Function Library

How to Share Workbooks in Excel 2013 Tutorial

Save and Save As Excel 2013 Tutorial

How to Recover Unsaved Files in Excel 2013 with the Auto Saved Feature

How to Export Excel Files to PDF Other Different File Types

Basic Excel 2013 Functions Tutorial

Excel Tutorial How to Use Nested Functions

How to Use GoTo Special in Microsoft Excel 2013 Tutorial

Excel Page Layout Tutorial

Microsoft Excel Tutorial Page Breaks, Headers and Footers

Excel 2013 Tutorial How to Format Fonts in Excel

How to Create a Custom List in Excel Tutorial

Data Validation Microsoft Excel 2013 Tutorial - How to Restrict Entering Data in a Cell

Understanding Excel Charts Tutorial

How to Create a Basic Chart in Excel Step by Step Tutorial

How to Create and Use a Pivot Table in Microsoft Excel 2013 - Excel Pivot Table Tutorial

How to Pivot Data with Excel Pivot Tables Tutorial

How to Create a Macro in Microsoft Excel 2013

Microsoft Excel 2013 Worksheet Template Tutorial How to Create

Drop Down Lists Tutorial in Excel 2013

How to Reference Formulas and Data on other Excel Worksheets Worksheets Microsoft Excel 2013 Tutorial

Excel Data Forms Tutorial Microsoft Excel 2013

How to Insert Drawing Objects into your Excel Spreadsheets Microsoft Excel 2013 Tutorial

Excel LOOKUP Function Tutorial Microsoft Excel 2013

Excel Workbook and Worksheet Objects Tutorial

Excel Tutorial: Variables in Microsoft Excel Visual Basic Application (VBA)

Excel VBA Tutorial: If Then and Else Statement in Microsoft Excel (VBA) Visual Basic Application

Excel Events Tutorial: Visual Basic Application Evens in Microsoft Excel 2013



Listen to a Bestseller for $7.49 at audible.com

Excel For Noobs Tutorial: Excel Worksheet Operations (Adding, Editing, Deleting, Hiding and Protecting)

Worksheets are excellent tools for organizing your data because you can separate different types of data instead of placing everything on a single worksheet. For example, if you were tracking the performance of several items, you could use a single worksheet for each item, and then another worksheet to summarize the overall performance of all your items.

Adding a New Worksheet

To add a worksheet there will be a button to the right of the worksheet tabs. If you press this button a new worksheet will be added. You can also press Shift+F11 to insert a new sheet before the sheet that is activated. Another way to add a new sheet is to right click on a sheet tab, click Insert and then select what you want to insert from the Insert dialog box. This method allows you to enter other workbooks, templates such as time cards, invoices and other templates from Office.com.

Deleting Worksheets

If you want to delete a worksheet in your workbook you can right click the sheet tab and select Delete from the shortcut menu.

Another method is to use the Delete command which is located in the Home ribbon under the Cells group.

If you want to delete multiple sheets you need press CTRL, select all the sheets you want to delete and then follow the steps above.

Naming a Worksheet

To name or rename your worksheet right-click the worksheet tab, select rename from the short-cut menu and then type in the new name.

You can also double-click the worksheet and Excel will allow you to rename your worksheet.

Worksheet Tab Color

Some people like to color code their worksheets. To do this, right-click the tab, select Tab Color from the shortcut menu and then select the color of your preference.

Changing the Default Sheet Setting

You may want to change the number of sheets Excel opens by default. In Excel 2010 by default Excel opens a workbook with 3 sheets. For many workbooks only one sheet is necessary, and if more are needed you can just add them. To change the default number of worksheets:

Click File then Options and the Excel Options dialog box will appear. In General enter the default number of sheets you prefer where it says Include This Many Sheets and click OK.

Copying and Moving Worksheets

You can also copy and move worksheets in the current workbook or in a different or new workbook. To move or copy a worksheet right-click the worksheet tab and select Move or Copy to access the Move or Copy dialog box. Use this box to make your commands.

To move a worksheet in its current workbook you can also click on the worksheet tab and drag it to the location you prefer.

To make a copy of a worksheet click and drag the worksheet while pressing CTRL.

You can move and copy multiple worksheets simultaneously by pressing CTRL to selecting multiple sheets.

Protecting Your Workbook and Worksheets

If you want to prevent someone from making changes to your workbook or to specific worksheets you can do this by requiring users to enter a password before making changes to your workbook or worksheet. This could be a very useful tool if you have employees working on a computer where Excel files can be accessed or within a workbook where certain sheets need to be protected.

Protect Workbook

To prevent others from making structural changes to you workbook such as adding, deleting and moving sheets, you can use the protect workbook command. Click the Review tab, then in the Changes group click on the Protect Workbook Command, make sure that the Structure box is checked, enter a password and press OK, then re-enter your password in the Confirm Password dialog box and click OK.

Now to make structural changes the workbook will have to be unlocked with the password. To do this simply click on the Protect Workbook command and enter your password.

Protect Worksheet

You may also have worksheets within a workbook that you want to protect from others. By using the Protect Worksheet command you can keep others from making changes by disabling certain commands or keep others from making any changes at all.

Click the Review tab, then click Protect Sheet and the Protect Sheet dialog box will appear. Make sure the Protect worksheet and contents of locked cells box is check, and then check the commands you want to allow users to perform without unprotecting the worksheet. Now enter your password and click OK, then reenter your password in the Confirm Password dialog box and click OK.

Hiding Worksheets

There may be some worksheets that you don’t want others to see. If this is the case you can hide worksheets. Right click the worksheet and select Hide from the shortcut menu. If you want to unhide the worksheet simply click on any worksheet tab and select Unhide. From the Unhide dialog box select the sheet that you want to unhide.

Making a Worksheet Very Hidden

You can also make a worksheet “very hidden” where it can’t simply be unhidden using the Unhide Dialog box.

Step 1: Activate your worksheet

Step 2: Click the Developer tab, then in the Controls group click on Properties. The Properties dialog box will appear.

Step 3: In the Visible box click on the drop-down arrow and select 2 – xlSheetVeryHidden.

Now your worksheet is “very hidden” and will not appear in the Unhide Dialog Box.

How to Unhide a Very Hidden Worksheet

Step 1: Press Alt+F11 to activate the Visual Basic Editor.

Step 2: Locate and select the sheet that is “very hidden” and then press F4. The properties box will appear.

Step 3: In the Visible box click on the drop-down menu and select -1 – xlSheetVisible.

Find the next tutorial in the links below.