Freeze Panes in Excel – Instructions and Video Lesson
Wednesday, September 18 2019
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
- Published in Excel 2016, Excel 2019, Excel for Office 365, Latest, Microsoft, Office 2016, Office 2019, Office 365
No Comments
Sort a Table in Excel – Instructions and Video Lesson
Monday, September 16 2019
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
- Published in Excel 2013, Excel 2016, Excel 2019, Excel for Office 365, Latest, Microsoft, Office 2013, Office 2016, Office 2019, Office 365
Create Calculated Columns in Power Pivot in Excel – Instructions
Thursday, September 12 2019
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
- Published in Excel 2016, Excel 2019, Excel for Office 365, Latest, Microsoft, Office 2016, Office 2019
The Fv Function- Excel for Lawyers Tutorial
Thursday, August 29 2019
The Fv Function: Overview The Fv function assists you in determining the future value of an investment based on periodic but constant payments with a constant interest rate. The future value is the total amount that a series of payments will be worth at a specified future time. For example, if you saved $100