Developing information management systems with Excel
- Automate the collection of all or subsets of data from spreadsheets, databases or external sources into
user-friendly reports. - Generate individual workbooks from a single or multiple source files by client, employee, product, region,
salesperson, etc. - Create custom user input forms and graphic interfaces to easily capture information from clients and/or
employees. - Transfer data to generate proposals, reports or letters in Microsoft Word or information management files
in Excel. - Build calculations; create filters & sorting buttons; generate graphs; and deliver professional-looking reports
automatically.
