Difference between revisions of "Listware for Excel:Express Entry Tutorial"

From Melissa Data Wiki
Jump to navigation Jump to search
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
[[Listware for Excel:Reference|← Listware for Excel Reference]]
{{LWEExpressEntryNav}}
 
{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''Express Entry Navigation'''
|-
| style="padding-right:220px;"|
|-
|style="border-bottom:1px solid #aaaaaa;"|[[Listware for Excel:Basics|← Listware for Excel Basics]]
|-
|[[Listware for Excel:Express Entry|Overview]]
|-
|[[Listware for Excel:Express Entry Tutorial|Tutorial]]
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|Steps
|-
|[[Listware for Excel:Express Entry:Main|Main]]
|-
|[[Listware for Excel:Express Entry:Settings|Settings]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|Result Codes
|-
|[[Returned Result Codes:Software#Listware for Excel|Returned Result Codes]]
|-
|[[Result Codes]]
|}
|}
 


{{CustomTOC}}
{{CustomTOC}}


After you install Listware and set your Customer License String, you are ready to use Listware.
After you install Listware and set your License Key, you are ready to use Listware.
Follow along with the steps below to perform a sample autocomplete with Express Entry for Listware.
Follow along with the steps below to perform a sample autocomplete with Express Entry for Listware.


Line 76: Line 43:
When you’ve entered enough characters, to where the address you are looking for is present, select it. If your selection contains a Zip+4, <Enter>, <Tab> or Keyboard Mouse selection will insert the record into your sheet and consume a credit.
When you’ve entered enough characters, to where the address you are looking for is present, select it. If your selection contains a Zip+4, <Enter>, <Tab> or Keyboard Mouse selection will insert the record into your sheet and consume a credit.


If Express Entry determines that there are available Suites, you can enter one at this point. However, Express Entry does not validate Suites, so when you insert that record into your sheet, it will not contain a Zip+4, and you will not be charged with a credit consumption.
If Express Entry determines that there are available Suites, it will return a drop down list of validated options. If an unavailable option is typed in, it will be saved, but not verified with the plus4.





Latest revision as of 18:32, 16 December 2016

← Listware for Excel Reference

Express Entry Navigation
← Listware for Excel Overview
Overview
Tutorial
Steps
Main
Settings
Result Codes



After you install Listware and set your License Key, you are ready to use Listware. Follow along with the steps below to perform a sample autocomplete with Express Entry for Listware.

Open a Spreadsheet

Open a spreadsheet containing your data in Excel.


Select Express Entry

Select the Listware Ribbon followed by the Express Entry button.

LWE ExpressEntry Tutorial Select.png

The Express Entry panel will open.


Configure Settings

Select settings to configure which fields you want the express entry interface to prompt you for data entry.

Unselected fields will be skipped over.

You’re ready to start entering data. If you’ve configured Express Entry Settings to include other data types like Name or Company, there will be only a single edit box to enter your data.

When the focus is moved to the Address input, you will see two edit boxes, one for the Primary Address, and another for Suite information, should Express Entry determine that the entered address has multiple delivery points.


Start Typing

Start typing in the Express Entry Address 1 field.

LWE ExpressEntry Tutorial Address.png

When you start typing, as little as two characters may start to give you valid possibilities, as a dropdown list.


Select Data

Select the desired data.

LWE ExpressEntry Tutorial FilledOut.png

When you’ve entered enough characters, to where the address you are looking for is present, select it. If your selection contains a Zip+4, <Enter>, <Tab> or Keyboard Mouse selection will insert the record into your sheet and consume a credit.

If Express Entry determines that there are available Suites, it will return a drop down list of validated options. If an unavailable option is typed in, it will be saved, but not verified with the plus4.


Credit Usage

When you have exhausted all your credits, Express Entry will no longer give suggested addresses, and will give you direct access to purchase more credits.

LWE ExpressEntry Tutorial NoCredit.png