Seminar Info:
Random Links of Goodness:
· Save time on importing with Excel by using the smart tag. http://www.alsde.edu/html/EdDirToTextSchool.asp
· Good Info from Ozgrid http://www.ozgrid.com/Excel/excel-faq.htm
· Generate unique random numbers http://www.ozgrid.com/VBA/RandomNumbers.htm
· Working with Worksheets http://www.ozgrid.com/VBA/working-with-worksheets.htm
· Working with Dates and Times in an Excel http://www.ozgrid.com/Excel/dates-times.htm
· 10 ways to reference Excel workbooks and sheets using VBA http://blogs.techrepublic.com.com/10things/?p=967
Macros that you can’t afford to not have if you deal in data:
Delete Blank Rows- http://www.ozgrid.com/VBA/VBACode.htm
Name a sheet based on what’s enter in A1- http://www.mrexcel.com/forum/showthread.php?p=1462814
Stop the Screen Flickering – https://knowledgeworkerblog.com/2008/05/hide-macros-in-excel-while-they-run.html
Functions you need to know
· Concatenation, HP10062562
· VLOOKUP, HP10069835
· IF, HP10069829
· ISNA, HP10069827
Data Validation
· Create Names, HA10147120
o http://www.accountingweb.co.uk/cgi-bin/item.cgi?id=175623&d=1032&h=1033&f=1026
· Create a drop down list of cells, HP10072600
Must Know Data Features
· Remove Duplicates, HP10073943
· Text To Columns, HP01216399
Email Me: [email protected] or [email protected]
Visit my blog: www.knowledgeworkerblog.com
Follow Me On Twitter: RobinECooper (I don’t tweet much! J)
Facebook: Robin Hunt Cooper
LinkedIn: http://www.linkedin.com/pub/robin-cooper/7/2a/92b
