Office Process & Task Automation
- Creation of VBA macros for Microsoft Word, Excel, PowerPoint, and
Outlook to automate time-consuming tasks and increase productivity
Excel Macros and Visual Basic for Applications
(VBA) Tool Development
- Creation of Excel-based applications and macros
using Visual Basic for Applications (VBA) for use within organizations
and for distribtion to clients.
- Troubleshooting and modification of existing
Excel-based systems built in-house or by other organizations.
- End-to-end report automation using Excel (VBA), SPSS (SAX Basic
Scripting and Syntax), PowerPoint, and/or PageMaker. We have built
extensive reporting systems to handle the creation of 100+ page reports
that include organization-specific data analysis.
- "Touch of a button" report writers to create readable and attractive
reports in Microsoft Word, PowerPoint, or Adobe PDF format based on
data or text in Microsoft Excel spreadsheets or tools and Access databases.
Database Design & Consulting
- Creation of database systems to handle data processing and manipulation using Access, SQL, and web-based technologies
- Integration of database systems with external data sources and structures to simplify report creation and automation.
- Web site design and maintenance (HTML, XML, DTML)
Statistical Analysis, Survey Analysis,
and Data Analysis
- Advanced statistical analysis and survey analysis, including multiple
regression analysis, using SPSS and SAS.
- Survey design and analysis, including creation and development of
Human Resources and Recruiting surveys.