Mission Statement
We are committed to providing interactive spreadsheets that meet the
computational needs of our clients so that they can devote more time to the
productive side of their enterprise.
We are committed to providing interactive spreadsheets that meet the
computational needs of our clients so that they can devote more time to the
productive side of their enterprise.
Our Business
We construct all types of spreadsheets from basic single sheet workbooks to full
applications utilizing visual basic code. Simple to complex, we do it all .... fast !!
We construct all types of spreadsheets from basic single sheet workbooks to full
applications utilizing visual basic code. Simple to complex, we do it all .... fast !!
"We Excel at spreadsheets"
Chandler, AZ
480.650.7257
480.650.7257
Get More Done In Less Time !
Guarantee
If you are not completely satisfied with our
workbooks, software or training the entire
purchase price will be returned within 90
days of sale. Free support for 6 months.
If you are not completely satisfied with our
workbooks, software or training the entire
purchase price will be returned within 90
days of sale. Free support for 6 months.
Copyright
SpreadSheet Specialties
2011
SpreadSheet Specialties
2011
 |
 |
Some Excel Elements and Capabilities
Formulas
Pivot Tables
Dashboard Reports
Economic Analysis
Budgets
Planning
Forecasting
Scheduling
Data Cleanup
VBA
Macros
User Defined Functions
Add-Ins
Data Cleanup
Formulas
Pivot Tables
Dashboard Reports
Economic Analysis
Budgets
Planning
Forecasting
Scheduling
Data Cleanup
VBA
Macros
User Defined Functions
Add-Ins
Data Cleanup
Why Hire A Consultant ?
Why would I hire a consultant to create a spreadsheet workbook when I can do it
myself ? Good question. Consider this .. a spreadsheet consultant can construct
a spreadsheet that meets the needs of the client in a very short period of time. The
content and capabilities of the workbook can be enhanced in ways never
imagined by the client. The end result is a professional spreadsheet workbook
that saves the client time and money.
Why would I hire a consultant to create a spreadsheet workbook when I can do it
myself ? Good question. Consider this .. a spreadsheet consultant can construct
a spreadsheet that meets the needs of the client in a very short period of time. The
content and capabilities of the workbook can be enhanced in ways never
imagined by the client. The end result is a professional spreadsheet workbook
that saves the client time and money.
Cost Savings - Examples
Monthly Product Specials
Workbook Cost $1,500
Cost Savings $11,500 per year
A California pet supply company published a monthly product brochure for its
customers. Data was extracted from a database via a query and then entered into
a workbook along with thumbnails of each product. The client spent 4 days each
month constructing the speadsheet !! SpreadSheet Specialties constructed a
macro enabled workbook that reduced the task time to 2 minutes with the added
benefit of automatically emailing a .pdf version of the product brochure to each
customer. The client was not aware of Excel's .pdf and auto email capabilities.
Soccer Scheduling
Workbook Cost $2,000
Cost Savings $7,000 per year
A Michigan based indoor soccer arena had the task of creating complex soccer
match schedules 6 times a year. Using an existing workbook with divisional
templates the manager could complete the task in three days. SpreadSheet
Specialties created a macro enabled workbook that reduced the task to 20
minutes and eliminated all scheduling conflicts. The workbook also uploads a
.csv file to the arena's website so that anyone could view the schedules online.
EMail Workbook
Workbook Cost $450
Cost Savings $9,000 per year
Another client had a website that sent an email every time someone registered for
their product. Information was taken from the printed email and typed into a
database. It was time consuming and prone to error. SpreadSheet Specialties
constructed a macro enabled workbook that allowed the user to drag the email to
a color coded box on the main sheet. Excel opened the email, scanned it for the
proper information and then entered the information into the database with no
need for user intervention.
Monthly Product Specials
Workbook Cost $1,500
Cost Savings $11,500 per year
A California pet supply company published a monthly product brochure for its
customers. Data was extracted from a database via a query and then entered into
a workbook along with thumbnails of each product. The client spent 4 days each
month constructing the speadsheet !! SpreadSheet Specialties constructed a
macro enabled workbook that reduced the task time to 2 minutes with the added
benefit of automatically emailing a .pdf version of the product brochure to each
customer. The client was not aware of Excel's .pdf and auto email capabilities.
Soccer Scheduling
Workbook Cost $2,000
Cost Savings $7,000 per year
A Michigan based indoor soccer arena had the task of creating complex soccer
match schedules 6 times a year. Using an existing workbook with divisional
templates the manager could complete the task in three days. SpreadSheet
Specialties created a macro enabled workbook that reduced the task to 20
minutes and eliminated all scheduling conflicts. The workbook also uploads a
.csv file to the arena's website so that anyone could view the schedules online.
EMail Workbook
Workbook Cost $450
Cost Savings $9,000 per year
Another client had a website that sent an email every time someone registered for
their product. Information was taken from the printed email and typed into a
database. It was time consuming and prone to error. SpreadSheet Specialties
constructed a macro enabled workbook that allowed the user to drag the email to
a color coded box on the main sheet. Excel opened the email, scanned it for the
proper information and then entered the information into the database with no
need for user intervention.
Training
We can provide onsite training for all of your Excel users. Course material is geared
to three levels; basic for new users, intermediate for users with some experience
and advanced for experienced users who need to perform tasks in Excel that are
complex and may require programming.
We can provide onsite training for all of your Excel users. Course material is geared
to three levels; basic for new users, intermediate for users with some experience
and advanced for experienced users who need to perform tasks in Excel that are
complex and may require programming.
Password Passport
How do you keep track of all those user ID's, login-in's and
associated passwords? The average person has about 20,
everything from bank accounts to the latest cell phone bill.
Do you write them down in a notebook or on a piece of
paper? Where do you hide that sensitive material? What
happens if it gets lost? There is a better way. Store all
this information in a password protected spreadsheet ! It's
safe and convenient and clicking on the appropriate cells will
take you to the log-in page of your favorite website. Click on
the passport image to the left for a sample workbook
demonstration along with instructions for hyperlinking. Feel
free to save this workbook to your own computer and
use it as a template for your very own Password Passport.
associated passwords? The average person has about 20,
everything from bank accounts to the latest cell phone bill.
Do you write them down in a notebook or on a piece of
paper? Where do you hide that sensitive material? What
happens if it gets lost? There is a better way. Store all
this information in a password protected spreadsheet ! It's
safe and convenient and clicking on the appropriate cells will
take you to the log-in page of your favorite website. Click on
the passport image to the left for a sample workbook
demonstration along with instructions for hyperlinking. Feel
free to save this workbook to your own computer and
use it as a template for your very own Password Passport.
Typical Excel Project
A typical Excel spreadsheet project generally has the following stages:
Initial Needs/Deliverables Assessment
Rough Draft Workbook
Client Approval
Construct Beta Phase Workbook
Test and Debug Workbook with Client Participation
Issue Final Version of Workbook to Client
A typical Excel spreadsheet project generally has the following stages:
Initial Needs/Deliverables Assessment
Rough Draft Workbook
Client Approval
Construct Beta Phase Workbook
Test and Debug Workbook with Client Participation
Issue Final Version of Workbook to Client
Data Summaries
Charts
User Forms
Mobile Forms
Custom User Interfaces
Data Formatting
Wizards
Data Import
Data Export
Data Validation
Error Handling
Custom Command Bars
Hyperlinking
VBA Optimization
Charts
User Forms
Mobile Forms
Custom User Interfaces
Data Formatting
Wizards
Data Import
Data Export
Data Validation
Error Handling
Custom Command Bars
Hyperlinking
VBA Optimization