|
Books > Computing & IT > Computer software packages > Spreadsheet software
Maximize the power of Excel 2013 formulas with this must-have
Excel reference
John Walkenbach, known as "Mr. Spreadsheet," is a master at
deciphering complex technical topics and Excel formulas are no
exception. This fully updated book delivers more than 800 pages of
Excel 2013 tips, tricks, and techniques for creating formulas that
calculate, developing custom worksheet functions with VBA,
debugging formulas, and much more. Demonstrates how to use all the
latest features in Excel 2013 Shows how to create financial
formulas and tap into the power of array formulasServes as a guide
to using various lookup formulas, working with conditional
formatting, and developing custom functionsShares proven solutions
for handling typical (and not-so-typical) Excel formula
challengesIncludes links to the "Mr. Spreadsheet" website, which
contains all the templates and worksheets used in the book, plus
access to John Walkenbach's award-winning Power Utility Pak.
From charts to PivotTables and everything in between, "Excel
2013 Formulas" is your formula for Excel success.
You’re beyond the basics—so dive in and really put your spreadsheet skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It’s all muscle and no fluff. Learn how the experts tackle Excel—and challenge yourself to new levels of mastery. Includes companion eBook and sample files.
Topics include:
•Customizing the Excel workspace
•Best practices for designing and managing worksheets
•Creating formulas and functions
•Performing statistical, what-if, and other data analysis
•Core to advanced charting techniques
•Using graphics and sparklines
•Managing databases and tables
•Automating Excel with macros and custom functions
•Collaborating in Excel online, in the cloud, and more
•Extending Excel
Explore a variety of Excel features, functions, and productivity
tips for various aspects of financial modeling Key Features Explore
Excel's financial functions and pivot tables with this updated
second edition Build an integrated financial model with Excel for
Microsoft 365 from scratch Perform financial analysis with the help
of real-world use cases Book DescriptionFinancial modeling is a
core skill required by anyone who wants to build a career in
finance. Hands-On Financial Modeling with Excel for Microsoft 365
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. As you proceed, you'll explore the
advantages of Power Query, learn how to prepare a 3-statement
model, inspect your financial projects, build assumptions, and
analyze historical data to develop data-driven models and
functional growth drivers. Next, you'll learn how to deal with
iterations and provide graphical representations of ratios, before
covering best practices for effective model testing. Later, you'll
discover how to build a model to extract a statement of
comprehensive income and financial position, and understand capital
budgeting with the help of end-to-end case studies. By the end of
this financial modeling Excel book, you'll have examined data from
various use cases and have developed the skills you need to build
financial models to extract the information required to make
informed business decisions. What you will learn Identify the
growth drivers derived from processing historical data in Excel Use
discounted cash flow (DCF) for efficient investment analysis
Prepare detailed asset and debt schedule models in Excel Calculate
profitability ratios using various profit parameters Obtain and
transform data using Power Query Dive into capital budgeting
techniques Apply a Monte Carlo simulation to derive key assumptions
for your financial model Build a financial model by projecting
balance sheets and profit and loss Who this book is forThis book is
for data professionals, analysts, traders, business owners, and
students who want to develop and implement in-demand financial
modeling skills in their finance, analysis, trading, and valuation
work. Even if you don't have any experience in data and statistics,
this book will help you get started with building financial models.
Working knowledge of Excel is a prerequisite.
This book is of paramount importance in the fields of engineering
and applied sciences, given that through the values obtained by
these procedures, many structures, like spillways of dams and
highway culverts, are designed and constructed. The main aim of
this book is to provide procedures for implementing many
probability distribution functions, all of them based on using a
standard and a common computational application known as Excel,
which is available to any personal computer user. The computer
procedures are given in enough detail, so readers can develop their
own Excel worksheets. All the probability distribution functions in
the book have schemes to estimate its parameters, quantiles, and
confidence limits through the methods of moments and maximum
likelihood.
|
|