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
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
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.
Create Group Items in QuickBooks Desktop Pro: Overview You can create Group items in QuickBooks Desktop Pro within the Item List. You can create Group items in QuickBooks Desktop Pro for items you may purchase individually but want to display as a single line item in a sales form. For instance, if you sold
Create Payment Items in QuickBooks Desktop Pro: Overview You can create payment items in QuickBooks Desktop Pro within the Item List. Payment items subtract the customer payment amount from the total invoice amount shown when creating an invoice. Payment items receive and apply a partial payment to an invoice at, or before, the time
Create Discount Items in QuickBooks Desktop Pro: Overview This lesson shows you how to create Discount items in QuickBooks Desktop Pro in the Item List. When added to a sales form, a Discount item applies its discount to the line item amount directly above it. However, it is not applied to any other line
Change the Color Saturation in Lightroom Classic CC: Overview You can change the color saturation in Lightroom Classic CC to adjust a photo’s overall color saturation. Color saturation in photography describes the intensity of a color. It is expressed as the degree to which the color differs from white. To change the color
Enter Vendor Credits in QuickBooks Desktop Pro: Overview You can easily enter vendor credits in QuickBooks Desktop Pro to later use them against the next bill you receive. To enter vendor credits in QuickBooks Desktop Pro, select “Vendors| Enter Bills” from the Menu Bar. Doing this then opens the “Enter Bills” window. Select