Excel customization, data entry, programming, and automation:
- Data entry, validation, and revision
- Data protection
- Creating tailor-made functions and macros
- Creating Excel add-ins called from: ribbons, key shortcuts, popup menus, tool boxes, and user interactions
- Creating Excel databases
- Developing advanced search filters and sorting techniques
- Procedure automation
- Iterative solvers
- Simultaneous non-linear equation solvers
- Advanced optimization and ranking techniques
- Advanced numerical and statistical analysis
- Automatic report generation: automatic tables, charts, drawings, exporting, and emailing
- Building fancy interactive user-forms (GUI) for data entry and data visualization
- Advanced string processing and formatting
- Advanced 2D and 3D charting
- Interfacing with barcode scanners, RFID detectors, PLCs, and serial communication devices
- Automatic mail notifications
- Web scraping and web auto
- Reading and writing files on network server