Displaying 1-20 of 22 results
Exclusive
Hands-on financial modeling with Excel for Microsoft 365: build your own practical financial models for effective forecasting, valuation, trading, and growth analysis
- eBook
- 2022
- Shmuel Oluwa
- Packt
Financial modeling is a core skill required by anyone who wants to build a career in finance. This book explores financial modeling terminologies with the help of Excel. Starting with the key concepts of Excel, such as formulas and functions, this updated second edition will help you to learn all about referencing frameworks and other advanced components for building financial models.
Exclusive
Guerrilla data analysis using Microsoft Excel: conquering crap data and Excel skirmishes.
- eBook
- 2022
- Oz du Soleil, Bill Jelen
- Holy Macro! Books
Includes examples and case studies that teach users the tricks for analysing data in Excel.
Exclusive
Excel data analysis for dummies
- eBook
- 2022
- Paul McFedries
- John Wiley & Sons, Inc.
For those new to data analysis. Takes the reader on a tour of Excel's data analysis tools.
Exclusive
Financial modeling in Excel for dummies
- eBook
- 2022
- Danielle Stein Fairhurst
- John Wiley & Sons, Inc.
This books provides practical hands-on exercises to help you build powerful models from scratch, and to work with existing financial models in Excel. Includes chapters on tools and techniques for financial modeling, applying scenarios, charting and presenting model output, building an integrated financial statements model, discounted cash flow valuation, and budgeting for capital expenditure and depreciation.
Exclusive
Data visualization with Excel dashboards and reports
- eBook
- 2021
- Dick Kusleika
- Wiley
Large corporations like IBM and Oracle are using Excel dashboards and reports as a Business Intelligence tool, and many other smaller businesses are looking to these tools in order to cut costs for budgetary reasons. An effective analyst not only has to have the technical skills to use Excel in a productive manner but must be able to synthesize data into a story, and then present that story in the most impactful way. Microsoft shows its recognition of this with Excel. In Excel, there is a major focus on business intelligence and visualization. Data Visualization with Excel Dashboards and Repor...
Exclusive
Financial modeling for decision making: using MS-Excel in accounting and finance
- eBook
- 2020
- Ron Messer
- Emerald Publishing Limited
This book provides accounting students in post-secondary institutions with an advanced level understanding of how to use MS-Excel. It reflects real-life applications of this important analytical tool, which has become the industry standard for spreadsheet software. The text focuses on using MS-Excel in situations encountered by accounting and finance students and professionals; these are contextualized in terms of the past, present, and future and reflect a typical operating cycle, which includes initial planning, followed by exercising control, and is completed when feedback is received.
Exclusive
Hands-on financial modeling with Microsoft Excel 2019: build practical models for forecasting, valuation, trading, and growth analysis using Excel 2019
- eBook
- 2019
- Shmuel Oluwa
- Packt
This book will help you understand financial modeling concepts using Excel, and provides you with an overview of the steps you should follow to build an integrated financial model. Later chapters cover using absolute and relative business valuation techniques and testing your model for reasonableness and accuracy, including creating a simple Monte Carlo simulation.
Exclusive
Using Excel for business and financial modelling: a practical guide (3rd edition)
- eBook
- 2019
- Danielle Stein Fairhurst
- Wiley
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.
Exclusive
Building financial models: the complete guide to designing, building, and applying projection models
- eBook
- 2018
- John S. Tjia
- McGraw Hill Education
Teaches how to build financial models using spreadsheets. You will be led through the steps of building an integrated financial statement model that can serve as the core for transactions or analysis in the LBO, M&A, business valuation model or credit underwriting space. This third edition includes additional materials on valuation analysis and sections on scenarios and sensitivity analysis through the use of Data Tables.
Exclusive
Principles of financial modelling: model design and best practices using Excel and VBA
- eBook
- 2018
- Michael Rees
- John Wiley and Sons
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.
Exclusive
Financial modeling in Excel for Dummies
- eBook
- 2017
- Danielle Stein Fairhurst
- John Wiley & Sons
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.
Exclusive
Power Pivot and Power BI: the Excel user's guide to DAX, Power Query, Power BI and Power Pivot in Excel 2010-2016
- eBook
- 2016
- Rob Collie, Avichal Singh
- Holy Macro! Books
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.
Exclusive
M is for (data) monkey: the Excel Pro's definitive guide to Power Query
- eBook
- 2015
- Ken Puls, Miguel Escobar
- Holy Macro! Books
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.
Exclusive
Mastering financial mathematics in Microsoft Excel: a practical guide to business calculations (3rd edition)
- eBook
- 2015
- Alastair Day
- FT Publishing International
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.
Exclusive
Advanced Excel reporting for management accountants
- eBook
- 2014
- Neale Blackwood
- John Wiley and Sons
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.
Exclusive
Excel dashboards and reports for dummies
- eBook
- 2014
- Michael Alexander
- John Wiley and Sons
Introduces Excel functionalities for building better financial reporting mechanisms. Includes tips on exploiting Excel for data analysis and visualisation.
Exclusive
Mastering financial modelling in Microsoft Excel: a practitioner's guide to applied corporate finance (3rd edition)
- eBook
- 2013
- Alastair L Day
- Pearson Education
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...
Exclusive
Using Excel for business analysis: A guide to financial modelling fundamentals (2nd edition)
- eBook
- 2012
- Danielle Stein Fairhurst
- Wiley
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.
Exclusive
Practical financial modelling: a guide to current practice
- eBook
- 2008
- Jonathan Swan
- Elsevier
Guidance on using complex spreadsheets and other business software for financial modelling. Describes good modelling practice and addresses the role of information technology in financial modelling.
Exclusive
Structured finance modeling with object-oriented VBA
- eBook
- 2007
- Evan Tick
- John Wiley and Sons
An aid to using business software for financial modelling in the securities market. It is primarily concerned with Microsoft Excel and Visual Basic but includes general guidance on modelling and corporate finance.
Displaying 1-20 of 22 results
See the A–Z of eBooks for a complete list of titles available across all subjects.