Conditional Formatting in Excel – Instructions

Conditional Formatting in Excel - Instructions: A picture of a user selecting a custom conditional formatting choice from the “Conditional Formatting” button’s drop-down menu.
Conditional Formatting in Excel: Overview             Conditional formatting in Excel lets you define criteria for cells which change the way the cells look in the worksheet, but only if the cells’ values match the criteria. For example, you could create a conditional formatting criterion that makes a worksheet cell appear with a red fill color
Read more
No Comments

Workbook Protection in Excel- Instructions

Workbook Protection in Excel- Instructions: A picture of the “Protect Structure and Windows” dialog box that is used to apply workbook protection in Excel.
Workbook Protection in Excel: Overview             When you apply workbook protection in Excel, users cannot add, delete, hide, rename, or move workbook worksheets. You can also provide an optional password that must be entered before the workbook can be unprotected. This option is also a bit risky, because if you forget the password, you cannot
Read more
No Comments

Inserting and Deleting Worksheets in Excel- Instructions

Inserting and Deleting Worksheets in Excel- Instructions: A picture of a user inserting a new worksheet into an Excel workbook.
Inserting and Deleting Worksheets in Excel: Overview             In this tutorial, you will learn about inserting and deleting worksheets in Excel. Inserting and deleting worksheets in Excel is a critical skill to possess when working with Microsoft Excel workbooks.             To insert a single new worksheet to the right of the currently selected worksheet, click
Read more
No Comments

Change Worksheet Tab Color in Excel – Instructions

Change Worksheet Tab Color in Excel - Instructions: A picture of a user changing the worksheet tab color in Excel.
Change Worksheet Tab Color in Excel: Overview             You can change worksheet tab color in Excel, if desired. To do this, first select the worksheet tab whose tab color you wish to change. Next, click the “Home” tab in the Ribbon. Then click the “Format” button in the “Cells” button group. Then roll your mouse
Read more
No Comments

Create a New Workbook in Excel- Instructions

Create a New Workbook in Excel - Instructions: A picture of the workbook templates in Excel.
Create a New Workbook in Excel: Overview             You can easily create a new workbook in Excel. A workbook is the default file type in Excel, much like a document is the default file type in Word. A workbook can contain multiple worksheets where the data is stored and manipulated in the columns and rows.
Read more
No Comments

Freeze Panes in Excel – Instructions and Video Lesson

Freeze Panes in Excel - Instructions: A picture of a user selecting the Freeze Panes button in Excel.
Freeze Panes in Excel: Overview             You can freeze panes in Excel to view data in two separate sections of a long worksheet simultaneously. You can freeze panes in Excel to freeze one or two sections of a worksheet to prevent scrolling. Then you can then scroll the unfrozen section of the worksheet to view
Read more
No Comments

Forecast Sheets in Excel – Instructions

Forecast Sheets in Excel - Instructions: A picture of a forecast sheet created in Excel.
Forecast Sheets in Excel: Overview             You can insert forecast sheets in Excel into a workbook to predict future trends from existing time-based data. To create forecast sheets in Excel, you must have a series of date or time entries for the timeline. You must also have corresponding values for those time or date entries.
Read more
No Comments

Apply Password Protection to an Excel File – Instructions

Apply Password Protection to an Excel File - Instructions: A picture of a user adding a password for opening the Excel file to a workbook.
Apply Password Protection to an Excel File: Overview             When you apply password protection to an Excel file, you prevent people from opening it without knowing the required password. After password protection is enabled on a file, no one can open it without the password. Therefore, password-protecting files poses some risk. This is because if
Read more
No Comments