Microsoft Office Training

Excel Scripting and Spreadsheet Model Design

Excel 2007

Have you upgraded to Office 2007?  Do you find the new Office Ribbon in Excel 2007 to be confusing?  Do you have problems finding the same functions that you are used to using from prior versions in the 2007 version?

We can help.  We can help you overcome the learning hurdle when you upgrade from a prior version of Excel to Excel 2007.

Excel Scripting & Model Design

Our knowledgeable staff are Expert Excel Specialists and can help you design advanced, automated spreadsheet models. 

Key Benefits

• We can create functions in your Excel spreadsheet to do all kinds of data manipulations. 
• We can import data into your Excel spreadsheet directly from a web site source, from an Access database, from another Excel spreadsheet or from a text file. 
• We can write scripts to clean up imported data formats, to remove duplicate records, to prepare address data for a mail merge, to sort and filter the data, or to do any other kind of calculations that you need to have created.
• We have many years of experience working on advanced budgeting spreadsheets and complex budgeting templates.  These templates can be created to handle multiple branch locations, multiple sales people, multiple customers and provide comparison to prior years.  This budget data can also flow seamlessly into cash flow and balance sheet projections.
• We have worked extensively in the lumber and building materials environment to assist with inventory management and analysis.  We have developed complex models to analyze SKU movement, profitability and aged value.

Let us help you achieve more with the tools you already have today.  Contact our office to schedule a consultation today.

Send mail to info@knowmooregroup.com with questions or comments about this web site.
Copyright © 2010 Moore Knowledge Group, Inc.