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

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

The Pv Function- Excel for Lawyers Tutorial and Video Lesson

The Pv Function- Excel for Lawyers Tutorial: A picture of a user creating a formula that uses the Pv function in Excel.
The Pv Function: Overview             This lesson shows you how to use the Pv function in Excel. Most of the functions that a lawyer needs to know assist them in business and financial computations. You can use these functions to help both the law firm as well as its clients.
Read more
No Comments