More than 20 years of experience with spreadsheets: VisiCalc, SuperCalc, Lotus 1-2-3, Lotus Symphony, Quattro, Quattro Pro, Quattro Pro for Windows, and finally Excel that took over the market (QPW was better!).
- Basics: Data Filtering; Data Validation; Lists; Pivot Tables; Web Queries; Database Queries; etc.
- General VBA Macros: Custom Functions; Data Input Automation; Forms.
- Dynamic Charts Generation: series, axis ranges, data labels and others based on users' selections.
- SQL Integration: queries defined in cells,...