Publisher's Synopsis
This book teaches practical Excel skills for effective finance operations and decision making. It focuses on two groups of Excel functions - financial and mathematical - that can help simplify the life of finance professionals. In many cases, the average finance professional is unaware of the existence of these functions and ends up spending several hours performing tasks which could be completed in a few seconds. To achieve the objective of equipping readers with the necessary Excel skills, the functions have been re-grouped according to the work they are designed to perform.
Subgroups within the financial functions category include capital budgeting, borrowing decision-making, fixed-income investment, and depreciation. Make go or no-go decisions in capital budgeting, perform sensitivity analysis and risk modelling, build loan repayment schedules, evaluate project loans, price and sell your investments, prepare financial statements, etc.
The mathematical functions are grouped into three:
- Rounding and number display functions will help you format big numbers and get your head around smaller ones;
- Operation catalysts will quicken task delivery for you. On a normal day, you would go through two or three steps to get results, but with this subgroup of functions, you'll get your result in a single step; and
- Conditional arithmetic functions perform mathematical or statistical operations based on a given criteria; Excel does some logical and evaluative thinking for you.
You would follow through the lessons step-by-step with real-world examples, screenshots, and downloadable practice files.
