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

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

Create Building Blocks in Word – Instructions

Create Building Blocks in Word - Instructions: A picture of a user creating a building block in Microsoft Word.
Create Building Blocks in Word: Overview             You can create building blocks in Word to make reusable content you can insert into your future documents, when needed. For example, you could save your company’s logo and name as a custom building block. Doing this then lets you insert it into future documents without recreating all
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

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