Excel document hacks
Excel Table of Data to a Form
Make a form for entering data.
Highlight the information you have in Excel
CTRL+T
Check Headers Box if it has Headers
Click the Quick Access Dropdown
More Commands…
Select All Commands from the Commands from Menu
Select Form
Highlight and click the Add >> button
Click OK – This gives you a quick access for forms
Click on your table and then click the form button
OR you can do this...
Make a form for entering data.
Put in your table headers
Highlight headers
Press ALT+D (you will get a warning about being an old command, but you can continue)
Then ALT+O
This will give you a table pop-up window for your data, just tab down the list and new for the next line.
PDF document table to Excel File
Click Data tab across the top
Click get Data on the left side
From File / From PDF
Find your PDF document and Import
Select the table you want to import to excel
Click load
Flash Fill a List
Example: A list of email addresses and you want to extract their names.
Enter in the first and last name for the first couple of fields.
With the cursor in the next field Pres CTRL+E
It will present you with a flash filed document based on your example entries