This site contains many
materials and examples on Microsoft Excel and Access Programming, Master
Scheduling, Inventory Management and Forecasting Methods, worked 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, 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 in your work or in your studies. If you need my help, you can send me email.
Download free Excel
Add-In Utility ver.2.1
created by me. Compatible for use in
Excel 97, Excel 2000, 2002, 2003.
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
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
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
