Excel Consulting
VB Programming
Solutions

Accmatrix
Accounting

Download
Accmatrix

Financial and
Management
Solutions

Microsoft Office
Training

Case Studies

Excel Links

About Us

FAQ

MICROSOFT EXCEL CONSULTING AND MICROSOFT VISUAL BASIC PROGRAMMING SOLUTIONS

Some of the many applications that we have developed to date are

A full range of integrated Excel based accounting programs including cash book, accounts payable, accounts receivable, petty cash, inventory, job control, general ledger, pivot tables, management accounts and interactive graphs. <Accmatrix Accounting>
Many customised budgets and advanced forecasting solutions.
Advanced quantitative modeling techniques.
Standard costing and reporting programs.
Product importing and costing programs.
Pension fund and employee recording programs.
Fixed asset programs. Including depreciation and wear and tear formulas.
Property project management programs. Incorporating PV, NPV and PMT formulas.
Company and share valuation programs.
Very powerful integrated Job control and management programs.
Hotel booking and management program.
Biokinetic programs plus many interactive graphs.
Insurance risk management, underwriting formulations and bordereau statistical analysis.
Property management.
International and airfreight handling and export documentation system.
Plus many more ...

Frequently Asked Questions >

Please contact mclulow@webmail.co.za for more information.

We can also assist you with the training and/or implementing of the following Data Analysis and Business Modeling Solutions. On-site or remotely.

Excel Operations
  Range Names
  Natural Language Range Names
  Lookup Functions
  The INDEX Function
  The MATCH Function
  Text Functions
  Dates and Date Functions
  Evaluating Investments with Net Present Value Criteria
  Internal Rate of Return
  Functions for Personal Financial Decisions:
  The PV, FV, PMT, PPMT, and IPMT Functions
  Circular References
  IF Statements
  The Paste Special Command
  The Auditing Tool
  Sensitivity Analysis with Data Tables
  The Goal Seek Command
  Using the Scenario Manager for Sensitivity Analysis
  Creating and Using Spinners for Sensitivity Analysis
  The COUNTIF, COUNT, COUNTA, and COUNTBLANK Functions
  The SUMIF Function
  The OFFSET Function
  The INDIRECT Function
  Conditional Formatting
  Creating SUBTOTALS
  Array Formulas and Functions

Data Analysis
  Using Solver to Determine the Optimal Product Mix
  Using Solver to Solve Transportation or Distribution Problems
  Using Solver to Schedule Your Workforce
  Using Solver for Capital Budgeting
  Using Solver for Financial Planning
  Using Solver to Rate Sports Teams
  Importing Text or Microsoft Word Data into Excel
  Importing Data from the Web into Excel
  Validating Data
  Summarizing Data with Histograms
  Summarizing Data with Descriptive Statistics
  Using PivotTables to Describe Data
  Summarizing Data with Database Statistical Functions
  Filtering Data
  Consolidating Data
  Estimating Straight Line Relationships
  Modeling Exponential Growth
  The Power Curve
  Using Correlations to Summarize Relationships
  Introduction to Multiple Regression
  Incorporating Qualitative Factors into Multiple Regression

Business Modeling Solutions
  Modeling Nonlinearities and Interactions
  Analysis of Variance: One-Way Analysis of Variance
  Randomized Blocks and Two-Way Analysis of Variance
  Using Moving Averages to Understand Time Series
  Forecasting with Moving Averages
  Forecasting in the Presence of Special Events
  Random Variables
  The Binomial and Hypergeometric Random Variables
  The Poisson and Exponential Random Variable
  The Normal Random Variable
  Weibull and Beta Distributions: Modeling Machine Life and Duration of a Project
  Monte Carlo Simulation
  Calculating an Optimal Bid
  Simulating Stock Prices and Asset Allocation Modeling
  Using Resampling to Analyze Data
  Pricing Stock Options
  Determining Customer Value
  The Economic Order Quantity Inventory Model
  Determining the Reorder Point: How Low Should I Let My Inventory Level Go Before I Reorder?
  Queuing Theory: The Mathematics of Waiting in Line
  Estimating a Demand Curve
  Pricing Products with Tie-ins
  Pricing Products Using Subjectively Determined Demand
  Nonlinear Pricing