Copy and Paste List Data from Excel into QuickBooks Pro- Instructions

A picture of the “Add/Edit Multiple List Entries” window that lets you copy and paste list data from Excel into QuickBooks Pro.
Overview of How to Copy and Paste List Data from Excel into QuickBooks Pro:             A feature that improves the speed of company file creation is the ability to copy and paste list data from Excel into QuickBooks Pro. You can copy and paste list data from Excel into QuickBooks Pro to add it into
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

Custom 3D Maps in Excel – Instructions

Custom 3D Maps in Excel - Instructions: A picture of a user setting the custom map options for a custom 3D map in Excel.
Custom 3D Maps in Excel: Overview             You can easily create custom 3D maps in Excel. When you create a new scene in a 3D Maps tour, it is associated with a map. By default, the “World Map” is used for most scenes. However, you can also create custom 3D maps from image files, if
Read more
No Comments

Custom Regions in 3D Maps in Excel – Instructions

Custom Regions in 3D Maps in Excel - Instructions: A picture of the “Import Custom Region Set” dialog box in the 3D Maps window in Excel.
Custom Regions in 3D Maps in Excel: Overview Custom Regions in 3D Maps in Excel: Importing Custom Regions             You can import your own custom regions in 3D Maps in Excel, if needed. Custom regions in 3D Maps in Excel are defined geospatial regions saved as either “kml” or “shp” files. You often create these
Read more
No Comments

Create a 3D Map in Excel – Instructions

Create a 3D Map in Excel - Instructions: A picture of a user creating a new 3D Maps tour in Excel.
Create a 3D Map in Excel: Overview Create a 3D Map in Excel: Creating a New Tour             After enabling the 3D Maps add-in in Excel, you can then create a 3D Map in Excel. To create a 3D Map in Excel, click the “Insert” tab in the Ribbon. Then directly click the “3D Maps”
Read more
No Comments

Sort a Table in Excel – Instructions and Video Lesson

Sort a Table in Excel - Instructions: A picture of the “Sort” dialog box within Excel for Office 365.
Sort a Table in Excel: Overview             You can sort a table in Excel using any of the fields available. Sorting is one of the main reasons that you create tables in Microsoft Excel. It allows you to easily organize information in the table records. By default, Excel can sort alphabetically or numerically in either
Read more
No Comments

Remove Hidden Data in Acrobat – Instructions

Remove Hidden Data in Acrobat - Instructions: A picture of the hidden data shown in the “Results” panel in Acrobat Pro DC.
Remove Hidden Data in Acrobat: Overview             You can remove hidden data in Acrobat Pro DC. To remove hidden data in Acrobat Pro DC, first open a PDF. Then select “Redact” from the Tools Center. Next, click the “Remove Hidden Information” button in the Redact Toolbar. The “Remove Hidden Information” panel then appears in the
Read more
No Comments

Create a Data Model from External Relational Data in Excel – Instructions

Create a Data Model from External Relational Data in Excel - Instructions: A picture of a user selecting the external relational data tables to add to the data model in an Excel workbook by using the “Select Table” dialog box.
Create a Data Model from External Relational Data in Excel: Overview             You can create a data model from external relational data in Excel. Data models in Excel let you store multiple tables of information. They can then be used a data source for PivotTables, PivotCharts, and Power View reports.             The choice to add
Read more
No Comments