Business analysis with Microsoft Excel
Working 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 analysis -- Statement analysis -- Ratio analysis -- Budgeting and planning cycle -- Forecasting and projections -- Measuring quality -- Examining a business case : investment -- Examining decision criteria for a business case -- Creating a sensitivity analysis for a business case -- Planning profits -- Making investment decisions under uncertain conditions -- Fixed assets -- Importing business data into Excel -- Exporting business data from Excel -- Using Excel 2016 and Power bI to analyze QuickBooks data -- Analyzing contributions and margins -- Pricing and costing.