Office
Data Entry with Microsoft Excel and Docparser
Fast, accurate data entry and document data extraction for office work.
Course roadmap
- 1
Excel essentials
Formatting and data validation · Formulas: SUM, IF, VLOOKUP/XLOOKUP · Sorting and filtering
- 2
Productivity
Pivot tables · Charts · Keyboard shortcuts
- 3
Docparser
Parsing rules · Extracting from PDFs and invoices · Exporting to Excel
Implementation steps
- Set up Excel and a Docparser trial account.
- Build a clean data-entry sheet with validation rules.
- Summarise the data with formulas and a pivot table.
- Create a Docparser parser for sample invoices.
- Export the parsed data to Excel and reconcile it.