Excel Tips for the Final Exam

A solid command of Excel is a fundamental requirement for success as an audit assistant or professional in the field of auditing. Therefore, this book focuses specifically on the professional practice of annual financial statement audits and presents suitable, practical solutions in Excel for selected tasks. All functions used in the examples are transferable to general questions in Excel. Each chapter begins with an overview of the topic from an auditor's perspective, followed by a step-by-step guide to developing the respective solution approach.

The completely revised and newly visualized second edition has been expanded to include new tools and functions related to the presented solutions. The range of topics now includes examples for selected balance sheet items—such as inventories, receivables, vacation provisions, and bank liabilities—as well as data preparation for processing the trial balance of accounts and data visualization for analytical review purposes.

The proposed and systematically documented solutions are supplemented at many points with practical tips and tricks regarding keyboard shortcuts and other Excel features. In addition to the texts in the book, selected functions and further tips are presented in short videos.