Using Excel for business and financial modelling: a practical guide (3rd edition)
A hands-on guide to using Excel in the business context. Contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates, a list of shortcuts and tons of practical tips and techniques you can apply straight away.
Principles of financial modelling: model design and best practices using Excel and VBA
A practical guide to financial modelling, demonstrating how to plan, design and build financial models. The book provides an introduction to modelling and discusses model design, the process of building models and sensitivity and scenario analysis, with practical examples of using Excel functions and Visual Basic for Applications (VBA) within financial modelling.
Financial modeling in Excel for Dummies
A beginner's guide to financial modeling using Microsoft Excel - this book shows you how to harness Excel's capabilities to determine profitability, develop budgetary projections, model depreciation, project costs, value assets and more. You'll learn the fundamental best practices and know-how of financial modeling, and how to put them to work for your business and your clients.
Power Pivot and Power BI: the Excel user's guide to DAX, Power Query, Power BI and Power Pivot in Excel 2010-2016
Microsoft PowerPivot is a free add-on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before, and this book is the first to tackle DAX formulas, the core capability of PowerPivot, from the perspective of the Excel audience.
Mastering financial mathematics in Microsoft Excel: a practical guide to business calculations (3rd edition)
Fully updated and compliant with Excel 2013, this clearly explains the basic calculations for mathematical finance, backed up with simple templates for further use and development, and a workbook with exercises and solutions at the end of each chapter.
Contains chapters on: basic Financial Arithmetic; cash flows; bonds calculations; bond risks; floating rate securities; amortisation and depreciation; swaps; forward interest rates; futures; foreign exchange; options; real options; valuation; leasing; basic statistics.
M is for (data) monkey: the Excel Pro's definitive guide to Power Query
Power Query is one component of the Power BI (Business Intelligence) product from Microsoft, and "M" is the name of the programming language created by it. As more business intelligence pros begin using Power Pivot, they find that they do not have the Excel skills to clean the data in Excel; Power Query solves this problem. This book shows how to use the Power Query tool to get difficult data sets into both Excel and Power Pivot, and is solely devoted to Power Query dashboarding and reporting.
Advanced Excel reporting for management accountants
Learn about the Excel functions that can automate the process of financial reporting for management accountants. The book demonstrates how to create and run reports and apply software tools to two case studies.
Excel dashboards and reports for dummies
Introduces Excel functionalities for building better financial reporting mechanisms. Includes tips on exploiting Excel for data analysis and visualisation.
Mastering financial modelling in Microsoft Excel: a practitioner's guide to applied corporate finance (3rd edition)
Comprehensive tools and methods to help you build, develop and apply financial models using Microsoft Excel, enabling you to get better, more accurate results, faster. The new edition of this bestselling title begins by explaining basic modelling techniques before moving through to more complex models. The book is divided into two parts: the first part outlines model designs and gives templates, key features and techniques. The second part of the book shows how to build corporate financial models in Excel. This new edition includes a reworking of the book in Excel 2010 (but with older material still included), inclusion of Apple Mac, addition of specific 2010 features and end of chapter exercises.
Using Excel for business analysis: A guide to financial modelling fundamentals (2nd edition)
Practical guidance on how to design, build and test financial models. The book opens with a general guide to financial modelling, followed by step-by-step instructions to walk you through modelling in Excel 2013. Finally, advice is given on effectively presenting your model's results via a written report or oral presentation.