Accounting with Excel

Course overview

This training includes accounting with Excel without proprietary accounting software: booking tables, calculation methods, evaluations, and charts. Your competencies Build booking tables in Excel with uniform columns and document numbers Design calculation methods in accounting tables that are traceable and error-free Evaluate income and expenses by categories and months Record booking data in Excel comprehensively and observe the lack of changeability of tables Table structure in Excel Column structure for date, document, amount, and category Functions for conditional sums and references Data validation and protected cells Evaluations in Excel Monthly and annual overviews from booking data Filtering, sorting, and grouping of bookings Charts for the development of income and expenses Application in professional everyday life Transfer documents of a month into accounting with Excel Search for formula errors and gaps in booking tables before the end of the month Provide monthly overviews for the tax office Secure table statuses and clearly name versions Professional fields of application Accounting in clubs and small organizations Office organization with accounting support The document entry in the accounting program with counter accounts and account framework, on the other hand, addresses the offer "Accounting with DATEV", cash book, chart of accounts, and advance VAT return, while the offer "Financial Accounting with Lexware" covers these topics.

Upcoming dates

• 2026-10-30T23:00:00.000Z · 2027-01-22T23:00:00.000Z · Aachen · Combined Learning
• 2026-10-30T23:00:00.000Z · 2027-04-16T22:00:00.000Z · Zwickau · Combined Learning
• 2026-10-30T23:00:00.000Z · 2027-01-22T23:00:00.000Z · Zwickau · Combined Learning
• 2026-10-30T23:00:00.000Z · 2027-04-16T22:00:00.000Z · Zittau · Combined Learning
• 2026-10-30T23:00:00.000Z · 2027-01-22T23:00:00.000Z · Zittau · Combined Learning