Financial management provides pathways to attain goals and objectives in an organization and in personal life. Excel is the most used spreadsheet program in many business activities, classwork, and even personal data organization worldwide. To master this skill is to elevate your financial decision-making abilities. Notion Press, India’s leading self-publishing platform presents, Practical Finance With Excel by Harrison Okyere Nyarko, a simplified guide to everyday finance operations and decision making with Excel.
The book 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 that could be completed in 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 modeling, 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 to 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 criterion; Excel does some logical and evaluative thinking for you.
With this simplified guide, you would follow through the lessons step-by-step, with real-world examples, screenshots, and downloadable practice files. Moreover, the book can prove to be useful to readers of non-finance backgrounds for professional use. The skills learned from the book can also be put to use in analyzing and organizing financial data for personal use.
Author Harrison Okyere Nyarko has over fourteen years of experience working in financial controlling, planning, and treasury responsibilities for companies within the manufacturing, oil/ gas, and energy sectors, and in the audit practice. Throughout his career, he has used Excel in operational and strategic contexts, including but not limited to financial reporting, financial planning, investment analysis and evaluation, raising capital, and liquidity management. He previously led Excel training for corporate and government entities when he worked for SCG Chartered Accountants (Ghana) as a senior consultant. He has also served in finance leadership positions for multinationals and regional organizations and on boards and committees of international professional accountancy and audit bodies.