Excel for the CFO
- 4h
- P.K. Hari
- Tickling Keys
- 2013
Written specifically for finance managers, Excel for the CFO explains the best features of Excel that allow for the automation of regular processes and help reduce the processing time spent on analytics. The book explores the entire gamut of finance-related functions and is focused on practical approaches to using Excel—including Pivot Tables, Goal Seek, Scenario Builder, and VBA—in problem solving to deliver quality results. Using case studies across all types of organizations to demonstrate the application of Excel-based automation, the scenarios covered include the automation of financial analysis models, the creation of income statement and balance sheet templates, converting numbers to words for check printing, and much more. Any finance executive who manages the company’s business affairs and makes critical decisions by analyzing data would be directly benefitted by using the tips and techniques presented in this guide.
About the Author
P. K. Hari is the director of finance for a large U.S.-based multinational corporation and the author of Excel for the CEO. He is a certified Guru of Microsoft Excel and is one of the featured experts with experts-exchange.com.
In this Book
-
Brushing Up on Excel 2010 Basics
-
Data, Data Everywhere
-
Using Financial Functions
-
Getting to Know Pivot Tables
-
What's in the Data Tab?
-
Building Business Models Using Excel
-
Using Excel's Security and Audit Features
-
Common Issues and Uncommon Solutions
-
Using VBA with Excel
-
Excel Interoperability with Other Office Apps
-
Excel for the CFO: Case Studies
