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

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

Create Group Items in QuickBooks Desktop Pro – Instructions

Create Group Items in QuickBooks Desktop Pro - Instructions: A picture of a user adding items to a Group item in QuickBooks Desktop Pro.
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
Read more
No Comments

Create Payment Items in QuickBooks Desktop Pro – Instructions

Create Payment Items in QuickBooks Desktop Pro - Instructions: A picture of the “New Item” window when you create payment items in QuickBooks Desktop Pro.
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
Read more
No Comments

Create Discount Items in QuickBooks Desktop Pro – Instructions

Create Discount Items in QuickBooks Desktop Pro - Instructions: A picture of a user creating a “Discount” item within QuickBooks Desktop Pro.
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
Read more
No Comments

Change the Color Saturation in Lightroom Classic CC – Instructions

Change the Color Saturation in Lightroom Classic CC - Instructions: A picture of a user changing the color saturation of an image in Lightroom Classic CC by using the sliders at the bottom of the “Basic” panel in the Develop module.
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
Read more
No Comments

Enter Vendor Credits in QuickBooks Desktop Pro- Instructions

Enter Vendor Credits in QuickBooks Desktop Pro- Instructions: A picture of a user entering a vendor credit into QuickBooks Desktop Pro.
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
Read more
No Comments