Excel in the Office with Matze

EINFACH MIT MATZE · ENGLISH PRACTICAL COURSE

Excel in the Office with Matze

Build skills. Check your results.

Build and check an office report from 120 order lines, use lookups and conditional totals, investigate dirty data, create a PivotTable and chart, and complete a separate 20-line July project.

Buy for €79Buy for US$79Buy for £79

Written digital download · unconditional 60-day money-back guarantee

Excel in the Office with Matze illustrated course cover

Learn Excel by building and checking a complete office project.

Office beginners who can open and save files and want to build dependable spreadsheet skills through a complete fictional order-reporting project.

Move from cell addresses and simple formulas to exact product lookups, conditional reports and a new-month project. Every lesson includes a practical task, a worked answer and a knowledge check.

What you receive

20 written lessons with exercises and worked answers, coursebook (27 pages), workbook (23 pages) with 115 fillable fields, offline lessons, a local workshop with JSON export/import, 5 practice files and a final project.

120 lines to practise with

A six-sheet starting workbook and a matching worked solution with formulas, native tables and a linked region chart.

A separate July challenge

Import 20 new order lines, build your own PivotTable and chart, then prove that a quantity change updates the results.

A ten-part toolbook

Ten pages of formula cards, import and handover templates, a debugging guide and a self-assessment rubric.

Written self-study. No videos, coaching, instructor assessment, certificate or software licence. You create the PivotTable and Power Query connection yourself; neither is preinstalled. Fictional EUR data and example rates are for practice and are not tax advice.

Try an exercise

An invoice is due on the report cut-off date. Under the course rule, is its positive open balance already overdue?

Compare the worked answer

No. The rule requires a positive open balance AND a due date before the cut-off. A due date equal to the cut-off is not overdue. Practise this boundary test in a copy of the workbook.

Your learning path

  1. 1. Find your way around a workbook
    Create a safe working copy and locate the project inputs.
  2. 2. Numbers, text and real dates
    Check stored types before calculating.
  3. 3. Tables, sorting and filters
    Keep every order line intact.
  4. 4. Calculate quantities and discounts
    Use readable formulas and deliberate rounding.
  5. 5. Relative and absolute references
    Copy a formula without moving a shared assumption.
  6. 6. Totals and visible-row totals
    Choose the calculation that matches the question.
  7. 7. IF and AND express a rule
    Make zero cases and boundary dates explicit.
  8. 8. Conditional sums and counts
    Align ranges and define all criteria.
  9. 9. Look up products with exact keys
    Link prices and costs to a unique product master.
  10. 10. Modern lookups and table references
    Understand an alternative without breaking compatibility.
  11. 11. Open amounts and cut-off dates
    Apply a fixed reporting date consistently.
  12. 12. Investigate dirty data
    Clean formatting without inventing business facts.
  13. 13. Validation and visual checks
    Reduce entry mistakes and make exceptions visible.
  14. 14. Build a PivotTable
    Summarise records with a native Excel tool.
  15. 15. Make a chart that answers a question
    Compare four regions without a misleading extra bar.
  16. 16. Import a CSV deliberately
    Choose encoding, delimiter, types and locale.
  17. 17. Refresh and extend a recurring report
    Distinguish replacing a month from appending records.
  18. 18. Hand over a readable report
    Explain the result, its source and its limits.
  19. 19. Debug systematically
    Trace the first wrong result to its cause.
  20. 20. Complete the July project
    Demonstrate the skills on a new dataset.

Suggested pace: 25–45 minutes per lesson plus your project. Try each exercise before reading the solution.

Before you buy

A computer with Microsoft Excel Desktop for Windows and your own licence. Microsoft 365 or Excel 2021/2024 recommended for the complete path. XLOOKUP is not available in Excel 2016/2019; the supplied solution uses INDEX/MATCH. Mac and web menus and import features differ. Written self-study: you create the PivotTable and Power Query import yourself; neither is preinstalled. English instructions and formulas; regional Excel settings may use different function names or argument separators. Fictional examples remain in EUR; the checkout currency does not convert exercise amounts.

Is this suitable for beginners?

Yes, if you can open and save files. The path starts with cell addresses, types and simple calculations, then builds up to reporting and imports.

Are the practice files fully translated?

Instructions, headers and labels are English. The CSVs intentionally retain German decimal/date conventions for a controlled import exercise; all example amounts remain EUR.

Is there a completed PivotTable?

No. You build a native PivotTable yourself and compare its totals with the supplied controls. The worked solution includes formulas, tables and a chart.

How do I use the download?

Extract the complete ZIP and read START.txt. Open index.html or Coursebook.pdf. Use a PDF reader with form support for Workbook.pdf. Open Workshop.html and export notes before closing; no autosave or cloud account is provided. Follow the practice-file instructions and check the supplied controls in your software.

What is the return policy?

EUR 79 / USD 79 / GBP 79 one-time. No subscription. unconditional 60-day money-back guarantee, including US, UK and Ireland purchases. Applicable additional local taxes are shown at checkout. Request a return through your Digistore24 order confirmation.

Build office skills you can explain and check.

EUR 79 / USD 79 / GBP 79 one-time. No subscription. unconditional 60-day money-back guarantee, including US, UK and Ireland purchases. Applicable additional local taxes are shown at checkout.

Buy for €79Buy for US$79Buy for £79

Payment and delivery through Digistore24. Support: info@einfachhaltbar.de.

Unconditional 60-day money-back guarantee

Request a full refund within 60 days of your first payment through the support link in your Digistore24 order confirmation or email info@einfachhaltbar.de with your order number. No reason or proof of results is required. Downloading or using the materials does not remove this guarantee. Your statutory rights remain unaffected.