About the BookExcel expert Conrad Carlberg shows how to use Excel 2010 to perform the core financial tasks every manager and entrepreneur must master: analyzing statements, planning and controlling company finances, making investment decisions, and managing sales and marketing. Using real-world examples, Carlberg helps you get the absolute most out of Excel 2010’s newest features and functions. Along the way, you’ll discover the fastest, best ways to handle essential tasks ranging from importing business data to analyzing profitability ratios.Becoming an Excel expert has never been easier! You’ll find crystal-clear instructions, insider insights, complete step-by-step projects, and more. It’s all complemented by an extraordinary set of web-based resources, from sample journals and ledgers to business forecasting tools.For Sale in Indian subcontinent onlyFeaturesShows how to use Excel to take total control over company finances Covers everything from financial statements and marketing to investment decision-making and quality management, using real-world examples Demonstrates powerful new features, including Sparklines, Slicer, and the new SolverContentsIntroductionPART I ANALYZING FINANCIAL STATEMENTSWorking with Income Statements Balance Sheet: Current Assets Valuing Inventories for the Balance Sheet Summarizing Transactions: From the Journals to the Balance Sheet Working Capital and Cash Flow AnalysisStatement Analysis Ratio AnalysisPART II FINANCIAL PLANNING AND CONTROLBudgeting and Planning Cycle Forecasting and Projections Measuring QualityPART III INVESTMENT DECISIONSExamining a Business Case: Investment Examining Decision Criteria for a Business Case Creating a Sensitivity Analysis for a Business Case Planning Profits Making Investment Decisions UnderFixed AssetsPART IV SALES AND MARKETINGImporting Business Data into Excel Exporting Business Data from Excel Analyzing Contributions and Margins Pricing and Costing