A comprehensive, hands-on guide designed specifically for business professionals, *Using Excel for Business and Financial Modelling* provides clear, step-by-step instructions on solving common business problems through effective financial modeling. First published in 2012, this book includes downloadable Excel templates, a comprehensive list of shortcuts, and a wealth of practical tips and techniques that can be applied immediately to enhance your workflow.
While Excel offers hundreds of tools, features, and functions, this book focuses on the most relevant ones for finance professionals. It covers these features in detail from a practical perspective, illustrating their application through real-world examples. Readers will learn how to create financial models that support informed business decision-making, all while adhering to best practice methodologies, tools, and techniques.
The book strikes a perfect balance between practice and theory, helping you become a DIY Excel modeling specialist. It has been updated to include features for Excel 2019/365 and Excel for Mac, ensuring compatibility across different platforms. Additionally, it can serve as an excellent accompaniment to the author’s online and face-to-face training courses.
Many users find Excel overwhelming due to its extensive array of tools. This book aims to bring clarity by highlighting the essential features needed to perform your job more efficiently. It also demystifies the technical, design, logic, and financial skills necessary for effective business and financial modeling, making complex concepts accessible and manageable.