Explore the Excel interface, from the quick access toolbar and file tab to the Home ribbon and its groups, and learn to manage multiple spreadsheets, rename sheets, and adjust zoom.

Enter text and numbers in a worksheet, edit with the formula bar. Format as accounting, center and merge cells, and build a balance sheet with assets, liabilities, and equity.

Format cells to accounting and set decimals, and use format painter to copy formatting. Enter formulas with = to verify assets = liabilities + stockholders' equity, using +, -, *, /.

Learn to format financial data in Excel with accounting formatting, adjust decimals, calculate net profit margin by dividing net income by sales, and use drag fill to copy formulas.

Learn to create and customize charts in Excel, including inserting a two-column chart, adjusting the axis to millions, and using spark lines to reveal trends.

Explore the five key financial ratios: liquidity, efficiency, leverage, coverage, and profitability, and learn how each reveals a company’s ability to meet obligations, invest, finance, and profit.

Compute and interpret the current ratio by dividing current assets by current liabilities, analyze year-by-year trends, and discuss creditor versus investor perspectives on liquidity.

Explore the accounts receivable turnover ratio in Excel, interpreting how credit sales relate to accounts receivable and what a higher or lower ratio implies for collections and credit practices.

Explain how total debt ratio shows how assets are financed by debt, using Coca-Cola as an example to illustrate shifts in capital structure and effects on earnings and tax benefits.

Examine the long-term debt ratio by dividing long-term debt by total assets, revealing a 20.71% leverage level and guiding balance sheet discussions.

Calculate the debt to equity ratio by dividing total debt by total equity, showing how the debt to equity ratio compares and that it has increased.

Learn how to compute the cash coverage ratio by adding depreciation back to earnings before income taxes to reflect cash available to cover interest, using the cash flow statement.

Learn how to calculate and interpret the times interest ratio in Excel for financial analysis and decision making.

Compute net profit margin by dividing net income by sales; analyze the decline caused by other expenses despite cost of goods sold remaining steady, and assess what remains for investors.

Explore how return on assets measures investor returns by dividing net income by total assets, and why declines may result from falling net income or rising assets.

Analyze cash flows from operating, investing, and financing activities to assess company health. Learn to interpret inflows and outflows and use scenario comparisons to distinguish growing firms from startups.