Excel VBA codes. Excel complete Formulas. Access Database. Inventory Management. Scheduling. Production Planning, etc

Hello ! Welcome to my site !

This site contains many materials and examples on Microsoft Excel and Access Programming, Master Scheduling, Inventory Management and Forecasting Methods, to work with Visual Basic programs and formulas. VBA, ADO & SQL especially, provides you the automation and infallible solution to all sorts of routine or complex office tasks, data mining and statistical analysis, for which recording macros, standard spreadsheet functions and standard Access queries simply aren't enough to help. Here you will find many source codes and examples. I hope you will find this site useful for your works or in your studies.

Share on Facebook

Excel VB6.0 Programming

VBA Beginner's Basic
Excel Main Objects
Rows, Columns, Range, Cells...
Working around your Worksheet...
Statements
Functions
Looping Methods & Conditional Decisions
Errors Debugging and Handling
UserForms and Dialogs
Pivot Tables
Charting
AutoFilters, Advanced Filters
ADO and DAO - integrating Excel/Access
Tips and fun staff for Excel VBA

Last Updated: March 2008

Materials Management_{with Excel & VBA}

Effective Inventory Management
What is the "Right" amount of inventory?
Reorder Point (ROP) and Safety Stock
More on Safety Stock...
Order Quantity techniques
Pareto "80/20" rule
Inventory Attributes and Classifications
Material Requirement Planning (MRP)
Problems with Inventory Turns
Measuring Customer Service
Vendor Managed Inventory (VMI)
Managing Suppliers
Key Performance Indicators (KPI)
Just-in-time (JIT) system
SAP Transaction Codes, Tables, Reports
Six-Sigma Methods and Tools

Master Scheduling_{with Excel & VBA}

Close-Loop Production Planning
Master Production Scheduling
Master Scheduling in Make-To-Order Environment
Rough-Cut Capacity Planning
Capacity Requirements Planning

Access Programming (1997 to 2003)

Access database basics
Access Collections and Objects
Forms, Controls and Events Procedures
Methods, Properties and examples
DoCmd Objects and examples
ADO, ADOX and SQL examples
Reports
Strings manipulation
Integrating Access with Excel
Access Automation

Last Updated: March 2008

Excel Spreadsheet Functions

Lookup and reference functions
Text functions
Date and time functions
Information functions
Logical functions
Database functions
Examples of commonly used formulas
Complex formulas for workplace solutions

Last Updated: March 2008

Forecasting Methods & Techniques _{with Excel & VBA}

Single & Multiple Moving Averages
Single & Multiple-Parameters Exponential
Smoothing
Exponential Smoothing with Seasonality
Methods
Decomposition Methods
Linear, Nonlinear and Multiple Regression
Analysis
Box-Jenkins (ARIMA) Time-Series Models
Multivariate Data Analysis

Note:

The expositive modules on MS Office Excel formulas, Inventory management, Forecasting techniques - these are still very much applicable to modern days as the processes hardly vary, albeit these modules were written more than a decade or so ago. The only drawback is concerning the detailed works for Excel VBA and Access Database applications, as some of these codes were written at that time based on Office 32 bit version and you may run into some problems if you are using MS Office 64-bit Excel and Access database applications. If you are able to modify some of the VBA codes to run in your 64-bit MS Office Excel, they should work just as fine. Enjoy using them !

Jun-19-2024.

This website was created by William Tan in February, 2007.
This single front page was updated in June 2024.