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
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
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.
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.
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.
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
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
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