Surman s.r.o.
We teach your people to work efficiently in Excel!
We train your staff to get their work done faster with Microsoft Office: above all Excel, but also Word, PowerPoint and Access.
We have extensive experience of hands-on training for auditors, tax advisers, accountants, economists, administrative staff, managers and lawyers, and we can prepare training tailored entirely to you. The emphasis is not on the tools and functions themselves but on the speed and efficiency with which you use them: we do not want you to know every Excel function, but we teach you a handful of them so thoroughly that your work becomes much easier.
Who we train
- Auditors
- Tax advisers
- Accountants
- Economists and controllers
- Administrative staff
- Management
- Lawyers
Training topics
Excel for economists, accountants and auditors
- Working with large accounting exports
- Lookup and aggregation functions
- Pivot tables and Power Query
- Data validation and workbook protection
Excel VBA and automation
- Recording and editing macros
- Custom functions and forms
- Automating recurring reports
- Maintaining inherited macros
Word for lawyers and advisers
- Styles, numbering and cross-references
- Contract templates and mail merge
- Track changes and document comparison
- Long documents and tables of contents
PowerPoint and Access
- Presentations for clients and management
- Charts from Excel and corporate templates
- Access: records and small databases
- Linking Office applications
How the training works
On-site or online
In your meeting room or by video conference, on a date that suits you.
On your own files
We build the content around what participants deal with every day and ask for typical files beforehand.
Czech, German, English
We train in all three languages, including mixed Czech–Austrian teams.
We tailor the training to your team
Tell us what your team struggles with and we will propose an outline and a date.