Excel for the CFO / / by P. K. Hari Hara Subramanian

• Autore: Hara Subramanian P. K. Hari
• Pubblicazione: Uniontown, Ohio, : Holy Macro! Books, c2011
• Descrizione fisica: 1 online resource (247 p.)
• Disciplina: 005.54
• Soggetto topico: Accounting - Data processing; Electronic spreadsheets
• Note generali: Includes index.
• Nota di contenuto: Cover -- Copyright -- Acknowledgements -- Dedications -- 1- Brushing Up on Excel 2010 Basics -- 2- Data, Data Everywhere -- 3- Using Financial Functions -- 4- Getting to Know Pivot Tables -- 5- What's in the Data Tab? -- 6- Building Business Models Using Excel -- 7- Using Excel's Security and Audit Features -- 8- Common Issues and Uncommon Solutions -- 9- Using VBA with Excel -- 10- Excel Interoperability with Other Office Apps -- 11- Excel for the CFO: Case Studies -- Index.
• Sommario/riassunto: 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.
• Titolo autorizzato: Excel for the CFO
• ISBN: 1-61547-211-8; 1-61547-331-9
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Lingua di pubblicazione: Inglese
• Record Nr.: 9910822124903321
• Lo trovi qui: Univ. Federico II