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

Use a Top 10 AutoFilter in Excel – Instructions

Use a Top 10 AutoFilter in Excel - Instructions: A picture of the “Top 10 AutoFilter” dialog box in Excel.
Use a Top 10 AutoFilter in Excel: Overview             You can use a Top 10 AutoFilter in Excel to show a specified number of the top or bottom percent or items in a field within the table. When you use a Top 10 AutoFilter in Excel, it defaults to showing the top 10 percent of
Read more
No Comments

Goal Seek in Excel- Instructions and Video Lesson

Goal Seek in Excel- Instructions and Video Lesson: A picture of the “Goal Seek” dialog box in Excel.
Goal Seek in Excel: Overview             You can use Goal Seek in Excel when you know the result you want a formula to return, but do not know the value needed to create the desired result. Anytime you have a situation where you know the result that you need to obtain, but are unsure of
Read more
No Comments

Sort a Table in Excel – Instructions and Video Lesson

Sort a Table in Excel - Instructions: A picture of the “Sort” dialog box within Excel for Office 365.
Sort a Table in Excel: Overview             You can sort a table in Excel using any of the fields available. Sorting is one of the main reasons that you create tables in Microsoft Excel. It allows you to easily organize information in the table records. By default, Excel can sort alphabetically or numerically in either
Read more
No Comments

Enable Power Pivot in Excel – Instructions

Enable PowerPivot in Excel - Instructions: A picture of a user enabling the Data Analysis add-ins within the “Excel Options” window in Excel for Office 365.
Enable Power Pivot in Excel: Overview             This lesson shows you how to enable Power Pivot in Excel. Power Pivot expands the abilities of the Excel data model to allow for robust data management and reporting for PivotTables and PivotCharts. Before you can start using Power Pivot, however, you must enable it in Excel. Power
Read more
No Comments