Welcome to XLDataSoft Consulting Services
We provide various kinds of project oriented Spreadsheet
development and consulting services.
The project consulting service can be either on-site or remote via internet and phone.
We use our expertise in data analysis to take care of those boring, repetitive and time-consuming data processing/analysis tasks for you and thus let you focus more on your expertise and your real "work".
Qualifications and Capabilities
Special Expertise:
Task Automation - Automate time consuming, repetitive tasks using macros and forms
User Defined Function - Achieve complicated computation/calculations through user defined
functions
Database Design - Excel is a perfect database tool for small business, upto 65,000 records
and 256 fields
Data Query - Extract useful data from data files, csv files, closed Excel files, Access
database and text files
Interaction - Control, access and I/O with Word, Outlook, Access, Internet and other
programs
Interface - Build standard Windows-style user-friendly-interface for input & output
(menu and dialog)
Reporting - Create all kinds of charts and pivot table, export Excel chart and table into
Word for reporting
Web Development - Static and dynamic website design using FrontPage, PHP, Access and MySQL
For MS Excel:
File Password Protection, Sheets/Range Password Protection, Conditional Formatting and
Custom Formatting, Data Validation, List, Forms and Controls, Array Functions, Database
Functions, Value Lookup Functions, Range Names, Customize Menu and Toolbar, Solver, Goal
Seek, Scenario Analysis, Statistic Analysis, Group and Outline, Subtotal, Filter and
Advanced Filter, Sort, Database Query and Web Query, Pivot Table and Pivot Chart, XML, and
Macros.
For Excel VBA:
User-Defined Functions, Macros, Work with
Ranges/Charts/Sheets/Workbooks/Files/Directories, Forms and Controls for GUI (Graphic User
Interface), Customize Menu/Toolbars, API, External Database Access via SQL, Extraction of
Data from Internet, Extraction of Data from External ASCII Files, Interact with Other
Offices Applications (like Word, Outlook), Class Module, etc.
For VB6/Access/Others:
MS Access(Table, Form, Query, Reports, Stored Procedure, Macro, VBA, Database
Application), VB6(ADO, DAO, Objects, API, ActiveX), Java, PHP, MySQL, Apache, HTML, C/C++,
SPSS, Matlab, etc.
Payment Method
We Accept: Personal Check, Company Check, Money Order, PayPal and 4 Major Credit Cards via PayPal.
No matter what problem you have, even you think it is
impossible or has nothing to do with Excel, try our consulting services!
You will get an affordable and satisfactory solution.