Record a Macro in Excel – Instructions and Video Lesson

Record a Macro in Excel - Instructions and Video Lesson: A picture of the “Record Macro” dialog box in Excel.
Record a Macro in Excel: Overview              You can easily record a macro in Excel. Macros are small programs that record your actions as you perform a task in Excel. The actions are then saved as a Visual Basic Module, which is a type of program. When you run the macro later, it repeats your
Read more
No Comments

Adjust Inventory in QuickBooks Desktop Pro- Instructions

Adjust Inventory in QuickBooks Desktop Pro- Instructions: A picture of a user making an inventory adjustment in QuickBooks Desktop Pro.
Adjust Inventory in QuickBooks Desktop Pro: Overview             When you have loss, spoilage, or send out samples of your products, you need to manually adjust inventory in QuickBooks Desktop Pro. To adjust inventory in QuickBooks Desktop Pro, you use the “Adjust Quantity/Value on Hand” window. To view this window, select “Vendors| Inventory Activities| Adjust Quantity/Value
Read more
No Comments

Outline Excel Data in Microsoft Excel – Instructions

Outline Excel Data in Microsoft Excel - Instructions: A picture of an Excel worksheet with an outline applied.
Outline Excel Data in Microsoft Excel: Overview             You can outline Excel data to add an organizational quality to a long or wide worksheet. When you outline Excel data, you group worksheet data into different levels based on column and row headings. Lower level data is associated with the headings in the rows or columns.
Read more
No Comments

Print a Report in QuickBooks Desktop Pro – Instructions

Print a Report in QuickBooks Desktop Pro - Instructions: A picture of the “Print Reports” window within QuickBooks Desktop Pro.
Print a Report in QuickBooks Desktop Pro: Overview             You can easily print a report in QuickBooks Desktop Pro. To print a report in QuickBooks Desktop Pro, first open the report you want to print. Then click the “Print” button in the toolbar of the report. Then select the “Report” command from the drop-down menu.
Read more
No Comments

Non-Inventory Part Items in QuickBooks Desktop Pro- Instructions

Non-Inventory Part Items in QuickBooks Desktop Pro - Instructions: A picture of a user creating a new “Non-Inventory Part” item in QuickBooks Desktop Pro.
Non-Inventory Part Items in QuickBooks Desktop Pro: Overview             You can create Non-Inventory Part items in QuickBooks Desktop Pro within the Item List. These types of items are bought and/or sold, but not tracked as “inventory part” items. QuickBooks Desktop Pro tracks neither the quantity on hand nor the value of “non-inventory part” items.            
Read more
No Comments

Split Panes in Excel – Instructions and Video Lesson

Split Panes in Excel - Instructions and Video Lesson: A picture of a large Excel workbook that is horizontally split into two separate panes.
Split Panes in Excel: Overview             To split panes in Excel when viewing a large worksheet, use the “Split” command in Excel. This command lets you split the Excel worksheet into different panes. Each pane contains its own horizontal and vertical scroll bars. Therefore, you can scroll each pane separately to view information from different
Read more
No Comments

Change the Chart Type in Excel – Instructions

Change the Chart Type in Excel - Instructions: A picture of a user changing the chart type of a selected chart in Excel.
Change the Chart Type in Excel: Overview             After creating a chart, you can change the chart type in Excel. Alternatively, you can also choose a different sub-type of the same general chart type you first selected. Either way, note that if you change the chart type, you may lose custom formatting you have applied
Read more
No Comments

Create Subtotal Items in QuickBooks Desktop Pro – Instructions

Create Subtotal Items in QuickBooks Desktop Pro - Instructions: A picture of a user creating a subtotal item within QuickBooks Desktop Pro.
Create Subtotal Items in QuickBooks Desktop Pro: Overview             You can create Subtotal Items in QuickBooks Desktop Pro in the Item List. A “Subtotal” item totals all the previous items within an invoice or sales receipt. It totals all items up to the last subtotal entered, if one was entered. This helps total all the
Read more
No Comments