Accounting and Finance Business Productivity Bundle

Open Excel, import data, and practice copy and paste for organization. Use Xlookup to fetch prices across sheets with exact match and optional rules.

Master the Getdata function to import data from web sources, text files, and other sources in Excel, and apply conditional formatting to highlight insights in price data.

Master Excel sorting, filtering, formatting, and data validation to turn raw data into a narrative, with QuickBooks reporting and customer filtering to craft precise insights.

Learn double-entry bookkeeping: debits and credits balance assets, liabilities, equity, revenue, and expenses. See how journal entries underpin the balance sheet, income statement, and cash flow statement.

Record assets and liabilities with journal entries, using debits for increases and credits for increases in liabilities and income, illustrated by asset purchases, payables, and rent and meal sales.

Explore journal entries for expenses and income through debit and credit entries, illustrated with San Mart's rent, inventory, catering, and gift card sales, and compare cash and accrual accounting.

Explore accrual accounting and cash accounting, recognizing expenses and revenue when events occur versus when cash moves, with examples like utilities, catering revenue, accounts payable, and prepaid insurance.

explore the classification of assets into tangible and intangible, and learn how depreciation and amortization reflect asset value across the balance sheet, income statement, and cash flow statement.

Practice journalizing a month of Smart Burgers transactions, recording debits and credits across bank, capital, drawings, sales, cost of goods sold, accounts payable/receivable, utilities, and preparing T accounts.

Explore how the general ledger records and summarizes every financial move, supporting double-entry bookkeeping and the creation of financial statements. Classify transactions into assets, liabilities, equity, and income and expenses.

Master the general ledger by recording transactions, analyzing accounts, and balancing debits and credits in QuickBooks online to prepare journal entries and financial statements.

Link QuickBooks online to the general ledger by converting an Excel transaction tab to CSV and uploading it to a bank account.

Balance the trial balance by reconciling debits and credits across the general ledger, ensuring assets, liabilities, revenues, and expenses stay in double-entry harmony.

Master accuracy checks for the trial balance and general ledger by ensuring debits equal credits, and prevent, detect, and reconcile errors with SOPs, automation, and real-time QuickBooks Online integration.

Master adjusting entries to ensure accurate financial reporting and reflect revenue and expenses in the proper period, guided by the matching principle, with practical QuickBooks Online examples.

Apply journal entries for January transactions of a California burger joint, posting to T-accounts and compiling a trial balance. Then perform five adjusting entries and prepare an adjusted trial balance.

Analyze how a balance sheet captures a company’s financial health by detailing assets, liabilities, and shareholders’ equity, using the equation assets = liabilities plus shareholders’ equity, current and non-current categories.

Explore the income statement, detailing revenue, cost of goods sold, gross profit, operating expenses, and net income, with annual and monthly examples using QuickBooks.

Explore how cash flow statements illuminate a company's true financial health and guide strategic decisions through operating, investing, and financing activities.

Master adding formulas and links in Excel to create interconnected income statements, balance sheets, and cash flow statements using sum, countif, and sumif for consistent reporting.

Learn to use ratio analysis to assess liquidity, solvency, profitability, and efficiency through financial statements, with practical Excel calculation and a San Martin case study.

Explore practical ratio analysis in Excel to assess San Mart's profitability, liquidity, efficiency, and solvency, including net revenue growth, margins, turnover, and debt management.

Decode financial health using ratio analysis, trend analysis, and common size analysis, and visualize net revenue growth with bar charts and sparklines for year-over-year insights.

Learn to forecast with Excel using simple and weighted averages, build pro forma income statements from historical data, and use goal seek and what-if analysis for strategic planning.

Work through a trial balance to turn numbers into an income statement and balance sheet, then compute net income and total equity.

Gather bank and company records and reconcile statements to ensure complete, accurate financial reporting. Leverage QuickBooks online and strong security measures to streamline collection and protect sensitive data.

Master the reconciliation process to ensure accurate general ledger balances and data integrity, address discrepancies, and prepare journal entries. Compare ledger data with statements and generate a reconciliation report.

Learn to reconcile bank transactions in QuickBooks Online, address discrepancies, and use bank statements, PDF-to-Excel conversion, and tools like journal entries and bank register to ensure accurate records.

Prevent reconciliation issues by using best practices and QuickBooks Online to connect bank accounts and payment gateways like Stripe, Square, and Shopify, ensuring consistent categorization.

Import the CSV from Excel into QuickBooks Online, categorize payroll as cost of labor and Grubhub, Uber Eats, and DoorDash sales, then reconcile the 001 checking account ending at 1509.24.

Close by reflecting on mastering Excel for data import, Xlookup and ratios, transitioning to QuickBooks Online for balanced transactions, dashboards, and budgeting insights.

Master financial forecasting and Excel fundamentals to improve decision making, resource allocation, and profitability by building informed projections using historical data and key drivers.

Access essential training information, download and unzip exercise and instructor files, and learn to optimize playback and high definition viewing for a video-based accounting and finance course.

Learn how forecasts support budgeting, planning, cash management, and investor communications. Assess reliability through governance, range forecasts, scenario planning, and simulations.

Assess profitability, cash flow, and net worth to gauge business health using assets, liabilities, and equity in the balance sheet, income statement, and cash flow statement.

Leverage financial forecasting as a strategic tool to guide long-term revenue and cash flow planning, align with strategic objectives, and assess growth scenarios using an Excel PNL template.

Discover the three dimensions of business understanding—the business model, the operating model, and competitive positioning—and learn to analyze five years of ABC's financial statements to forecast.

Apply web research on the automotive sector to inform ABC's financial forecasting in Excel, analyzing profits, growth in emerging markets, and regulation-driven costs.

Calculate how profitability declines impact revenue, gross profit, and net income for automobile manufacturers using reductions and formulas, and determine gross and net profit margins for 2021.

Examine ABC’s balance sheet to understand assets, liabilities, and equity at a point in time, including tangible and intangible assets and current and long-term liabilities, to assess financial position.

Trace abc’s income statement from net sales to the bottom line, detailing gross profit, sg&a, other income or expenses, ebit, interest and taxes, and net income including noncontrolling interests.

Explore how ABC's cash flow statement links net income to cash through operating, investing, and financing activities, with noncash items, capex, and balance sheet connections.

Define forecasting objectives for ABC to build core financial statements, ensure reliable monthly forecasts, and drive senior management decisions by monitoring key drivers across subsidiaries.

Identify historical forecasting, research-based forecasting, and qualitative forecasting, and select historical forecasting as most appropriate for the established ABC, then use rolling forecasts with 12–18 month horizons.

Identify the data required to build a 2020 financial forecast for XYZ in Excel, and construct a 12-month rolling forecast using monthly data from September 2018 to August 2019.

Identify drivers to make forecasts dynamic through driver-based forecasting, focusing on the 80/20 Pareto principle to select drivers like time spent on calls and call volumes for what if analysis.

Identify key drivers for a driver based model by discovering business variables, engaging departments, and building organized formulas. Focus on measurable drivers, revenue and expenses, with collaborative, flexible modeling.

Identify key drivers through driver-based forecasting and non-financial factors, apply historical growth rates to project net sales, costs, and balance sheet items using turnover ratios.

Forecast a complete Excel financial plan by building the income statement and schedules, linking to cash flow and balance sheet; apply historical sales growth and color coding.

Forecast revenues in Excel using top-down and bottom-up approaches, modeling sales, volumes, and prices for ABC to generate realistic 2021 projections.

Explore diverse revenue projection approaches in Excel, such as sales growth, inflationary volume effects, unit volume, dollar market size methods, and capacity-utilization impacts, applying them to forecast ABC's revenues 2021–2025.

apply vertical analysis to forecast all income statement line items from net sales, using historical margins to project cost of sales, SG&A, taxes, and net income attributable to noncontrolling interests.

Forecasts ABC's income statement from 2021 to 2025 by applying line-item margins to forecasted net sales, calculating cost of sales, gross profit, SG&A, EBIT, and taxes using vertical analysis.

Forecast working capital in Excel by linking income statement to balance sheet and forecasting non-cash current assets and non-debt current liabilities using days sales outstanding and inventory days.

Forecast non-debt current assets and liabilities (receivables, inventories, and payables) using historical ratios, then apply days payable and cost-of-sales percentages to estimate changes in working capital and cash flow.

Forecast depreciation and capital expenditures using an Excel-based approach, linking net sales, past CapEx, and depreciation notes, and applying asset proportions to project future CapEx.

Forecast depreciation using CapEx projections with straight-line depreciation and mid-year convention, calculating annual depreciation for building improvements, machinery, and other equipment to derive ending net PPE.

Forecast intangibles by linking net sales to additions, estimate additions as a percent of net sales, apply amortization of 160 million, and project ending net intangibles with zero goodwill.

Forecast shareholders' equity by projecting ending balance, dividends, share repurchases, option proceeds, and shares outstanding, using eps multiples and RSUs to derive diluted shares.

Forecast long term assets and liabilities on the balance sheet, link deferred income taxes and other assets and liabilities, and establish a debt schedule with depreciation, amortization, and capital expenditures.

Finalize the debt forecast by calculating ending balances, current portions, and revolving credit activity using the liquidity note and a $750 million minimum cash balance for 2021–2025.

Forecast a 2021–2025 cash flow statement by linking net income, depreciation and amortization, capex, and intangibles to compute cash from operations and the overall cash position, applying the sign convention.

Forecast the ABC balance sheet by linking cash from the cash flow statement and current assets from working capital. Integrate non-current assets, liabilities, debt, and non-controlling interests across 2021–2025.

Navigate rolling forecasts that refresh budgets quarterly to adapt to changing macro factors, and use variance analysis in Excel to measure forecast accuracy for revenue, labor, and other line items.

Explore ratio analysis and how vertical balance sheet and horizontal income statement analyses reveal trends, comparisons to prior years, and forecasted improvements in ABC’s financials.

Analyze forecasted figures using trend analysis and key ratio techniques, including accounts receivable turnover, inventory turnover, and payables turnover. Assess solvency and liquidity via current, quick, and cash ratios.

Calculate the average receivables collection period, inventory processing period, and average payable days using turnover ratios by dividing 365 by each ratio.