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

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

Format Trendlines in Excel Charts – Instructions

Format Trendlines in Excel Charts - Instructions: A picture of a user formatting a trendline in an Excel chart using the “Trendline Options” section of the “Format Trendline” task pane.
Format Trendlines in Excel Charts: Overview             You can easily format trendlines in Excel charts if you applied them to one or more chart series. To format trendlines in Excel, click the “Format” tab within the “Chart Tools” contextual tab in the Ribbon. Then select a trendline to format from the “Chart Elements” drop-down in
Read more
No Comments