Notes
Slide Show
Outline
1
 
2
Other Application Ideas
  • Create Form Letter emails to clients
  • Document Archiving Schemes / Web Access by clients or automated email attachments.
  • Task management Outlook Add-ins.
  • Classification of Line Items by string recognition.  FIND()
  • Excel or Word Templates for clients.
3
Methods of transferring data into Excel
  •   Hand re-entry of data
  •   Excel File-Open the ASCII files directly
  •   Interface allows cut and paste of text
  •   Read and parse text files using VisualBASIC
  •   Acquire reports as text strings using OLE
  •   Open-DataBase-Connectivity using SQL
4
 
5
 
6
 
7
 
8
 
9
 
10
 
11
 
12
 
13
 
14
 
15
Services for Clients
  • Help them with organizing their spreadsheets.
  • Set-up central data stores in Access, SQL Server or Excel.
  • Task management Outlook Add-ins
  • Tools that will help them improve service to their customers
  • Integration of software packages
  • Automation of repetitive tasks
16
Capabilities
  • Websites that connect that pull from databases, which can even be an Excel file. (CRM)
  • Design, setup and populate SQL Server, MS Access or Excel databases
  • Bar-code scanning of data
  • Visual Basic programming to tie all kinds of software package data and/or any MS Office components together.
  • Project Management templates
  • Operational Assessments for process improvement opportunities
  • Document Imaging and/or inventory systems