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

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

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

Name an Embedded Chart in Excel – Instructions

Name an Embedded Chart in Excel - Instructions: A picture of a user naming an embedded chart by using the “Name Box” in the Formula Bar in Excel.
Name an Embedded Chart in Excel: Overview             You can easily name an embedded chart in Excel. To name an embedded chart in Excel, first select the chart to name within a worksheet. You can then click into the “Name Box” at the left end of the Formula Bar. Then simply type a new name
Read more
No Comments

Create Calculated Columns in Power Pivot in Excel – Instructions

Create Calculated Columns in Power Pivot in Excel - Instructions: A picture of a user creating a calculated column in the data model window of Power Pivot in Excel by typing a simple formula.
Create Calculated Columns in Power Pivot in Excel: Overview             This lesson shows you how to create calculated columns in Power Pivot in Excel. You can create calculated columns and measures from the tables in the Power Pivot data model. Doing this lets you create table values that you can then add to PivotTables and
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