Office

Data Entry with Microsoft Excel and Docparser

Fast, accurate data entry and document data extraction for office work.

Course roadmap
  1. 1

    Excel essentials

    Formatting and data validation · Formulas: SUM, IF, VLOOKUP/XLOOKUP · Sorting and filtering

  2. 2

    Productivity

    Pivot tables · Charts · Keyboard shortcuts

  3. 3

    Docparser

    Parsing rules · Extracting from PDFs and invoices · Exporting to Excel

Implementation steps
  1. Set up Excel and a Docparser trial account.
  2. Build a clean data-entry sheet with validation rules.
  3. Summarise the data with formulas and a pivot table.
  4. Create a Docparser parser for sample invoices.
  5. Export the parsed data to Excel and reconcile it.
Software to install