{"product_id":"business-analysis-with-microsoft-excel-9780789759580","title":"Business Analysis with Microsoft Excel","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cp style=\"margin:0px;\" ft=\"\"\u003e\u003cb\u003eConrad G. Carlberg\u003c\/b\u003e is president of Network Control Systems, Inc., a software- development and consulting firm that specializes in statistical and database applications. He holds a PhD in statistics and is a many-time recipient of Microsoft's Most Valuable Professional (MVP) award. He lives near San Diego, California.\u003c\/p\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003cp\u003e\u003cb\u003eChapter 1\u003c\/b\u003e Working with Income Statements\u003c\/p\u003e \u003cp\u003eKeeping Score\u003c\/p\u003e \u003cp\u003e    Choosing the Right Perspective\u003c\/p\u003e \u003cp\u003e    Defining Two Purposes for Accounting\u003c\/p\u003e \u003cp\u003eUsing the Income Statement\u003c\/p\u003e \u003cp\u003e    Choosing a Reporting Method\u003c\/p\u003e \u003cp\u003e    Cells in Excel\u003c\/p\u003e \u003cp\u003e    Measuring the Operating and Nonoperating Segments\u003c\/p\u003e \u003cp\u003eMoving from the General Journal to the Income Statement\u003c\/p\u003e \u003cp\u003e    Getting the General Journal into Excel\u003c\/p\u003e \u003cp\u003e    Understanding Absolute, Relative, and Mixed References\u003c\/p\u003e \u003cp\u003e    Getting the Journal Data to the Ledger\u003c\/p\u003e \u003cp\u003e    Getting the Ledger Data to the Income Statement\u003c\/p\u003e \u003cp\u003eManaging the Financial Analyses with Accrual Accounting\u003c\/p\u003e \u003cp\u003e    Using Straight-Line Depreciation\u003c\/p\u003e \u003cp\u003e    Preparing the Trial Balance\u003c\/p\u003e \u003cp\u003e    Moving Information into an Income Statement\u003c\/p\u003e \u003cp\u003eOrganizing with Traditional Versus Contribution Approaches\u003c\/p\u003e \u003cp\u003eAbout Power BI\u003c\/p\u003e \u003cp\u003e    Power BI Desktop\u003c\/p\u003e \u003cp\u003e    Power BI Service and Mobile Apps\u003c\/p\u003e \u003cp\u003eSummary\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2\u003c\/b\u003e Balance Sheet: Current Assets\u003c\/p\u003e \u003cp\u003eDesigning the Balance Sheet\u003c\/p\u003e \u003cp\u003e    Understanding Balance Sheet Accounts\u003c\/p\u003e \u003cp\u003e    Understanding Debit and Credit Entries\u003c\/p\u003e \u003cp\u003eGetting a Current Asset Cash Balance\u003c\/p\u003e \u003cp\u003e    Using Sheet-Level Names\u003c\/p\u003e \u003cp\u003e    Getting a Cash Balance for Multiple Cash Accounts\u003c\/p\u003e \u003cp\u003e    Handling Restricted Cash Accounts\u003c\/p\u003e \u003cp\u003eGetting a Current Asset Accounts Receivable Balance\u003c\/p\u003e \u003cp\u003e    Allowing for Doubtful Accounts\u003c\/p\u003e \u003cp\u003e    Using the Aging Approach to Estimating Uncollectibles\u003c\/p\u003e \u003cp\u003e    Using the Percentage of Sales Approach to Estimating Uncollectibles\u003c\/p\u003e \u003cp\u003e    Displaying Doubtful Account Balances with Power BI\u003c\/p\u003e \u003cp\u003e    Managing the Sort Order Via the Axis Values\u003c\/p\u003e \u003cp\u003e    Managing the Sort Order with Another Field\u003c\/p\u003e \u003cp\u003eGetting a Prepaid Expenses Balance\u003c\/p\u003e \u003cp\u003e    Dealing with Insurance as a Prepaid Expense\u003c\/p\u003e \u003cp\u003eGetting a Current Asset Balance\u003c\/p\u003e \u003cp\u003e    Understanding the Inventory Flow\u003c\/p\u003e \u003cp\u003e    Closing the Inventory Account\u003c\/p\u003e \u003cp\u003e    Closing the Revenue and Expense Accounts\u003c\/p\u003e \u003cp\u003eSummary\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3\u003c\/b\u003e Valuing Inventories for the Balance Sheet\u003c\/p\u003e \u003cp\u003eUnderstanding Perpetual and Periodic Inventory Systems \u003c\/p\u003e \u003cp\u003e    Perpetual Inventory Systems \u003c\/p\u003e \u003cp\u003e    Periodic Inventory Systems \u003c\/p\u003e \u003cp\u003eValuing Inventories \u003c\/p\u003e \u003cp\u003e    Valuation Methods Summarized \u003c\/p\u003e \u003cp\u003e    Using Specific Identification \u003c\/p\u003e \u003cp\u003e    Using Average Cost \u003c\/p\u003e \u003cp\u003e    Using the Moving Average Method \u003c\/p\u003e \u003cp\u003e    Using FIFO\u003c\/p\u003e \u003cp\u003e    Using LIFO\u003c\/p\u003e \u003cp\u003eComparing the Four Valuation Methods \u003c\/p\u003e \u003cp\u003e    Specification Identification \u003c\/p\u003e \u003cp\u003e    Average Cost \u003c\/p\u003e \u003cp\u003e    FIFO \u003c\/p\u003e \u003cp\u003e    LIFO \u003c\/p\u003e \u003cp\u003eHandling Purchase Discounts \u003c\/p\u003e \u003cp\u003eCalculating Turns Ratios \u003c\/p\u003e \u003cp\u003eSummary \u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4\u003c\/b\u003e Summarizing Transactions: From the Journals to the Balance Sheet \u003c\/p\u003e \u003cp\u003eUnderstanding Journals \u003c\/p\u003e \u003cp\u003e    Understanding Special Journals \u003c\/p\u003e \u003cp\u003e    Structuring the Special Sales Journal \u003c\/p\u003e \u003cp\u003e    Structuring the Special Purchases Journal \u003c\/p\u003e \u003cp\u003e    Structuring the Cash Receipts Journal \u003c\/p\u003e \u003cp\u003e    Structuring the Cash Payments Journal \u003c\/p\u003e \u003cp\u003eExcel Tables and Dynamic Range Names \u003c\/p\u003e \u003cp\u003e    Building Dynamic Range Names \u003c\/p\u003e \u003cp\u003e    Using Dynamic Range Names in the Journals \u003c\/p\u003e \u003cp\u003e    Choosing Between Tables and Dynamic Range Names \u003c\/p\u003e \u003cp\u003eUnderstanding Ledgers \u003c\/p\u003e \u003cp\u003e    Creating the General Ledger \u003c\/p\u003e \u003cp\u003e    Using Subsidiary Ledgers \u003c\/p\u003e \u003cp\u003e    Automating the Posting Process \u003c\/p\u003e \u003cp\u003eGetting a Current Liabilities Balance \u003c\/p\u003e \u003cp\u003eSummary \u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5\u003c\/b\u003e Working Capital and Cash Flow Analysis \u003c\/p\u003e \u003cp\u003eMatching Costs and Revenues \u003c\/p\u003e \u003cp\u003eBroadening the Definition: Cash Versus Working Capital \u003c\/p\u003e \u003cp\u003e    Determining the Amount of Working Capital \u003c\/p\u003e \u003cp\u003e    Determining Changes in Working Capital \u003c\/p\u003e \u003cp\u003eAnalyzing Cash Flow \u003c\/p\u003e \u003cp\u003e    Developing the Basic Information \u003c\/p\u003e \u003cp\u003e    Summarizing the Sources and Uses of Working Capital \u003c\/p\u003e \u003cp\u003e    Identifying Cash Flows Due to Operating Activities\u003c\/p\u003e \u003cp\u003e    Combining Cash from Operations with Cash from Nonoperating Transactions\u003c\/p\u003e \u003cp\u003eSummary \u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6\u003c\/b\u003e Statement Analysis \u003c\/p\u003e \u003cp\u003eUnderstanding a Report by Means of Common-Sizing \u003c\/p\u003e \u003cp\u003e    Using Common-Sized Income Statements \u003c\/p\u003e \u003cp\u003e    Using Common-Sized Balance Sheets \u003c\/p\u003e \u003cp\u003e    Using Comparative Financial Statements \u003c\/p\u003e \u003cp\u003eUsing Dollar and Percent Changes in Statement Analysis \u003c\/p\u003e \u003cp\u003e    Assessing the Financial Statements \u003c\/p\u003e \u003cp\u003e    Handling Error Values \u003c\/p\u003e \u003cp\u003e    Evaluating Percentage Changes \u003c\/p\u003e \u003cp\u003eCommon-Sizing for Variance Analysis \u003c\/p\u003e \u003cp\u003eCommon-Sizing by Headcount \u003c\/p\u003e \u003cp\u003eShowing Common-Sized Statements with Power BI \u003c\/p\u003e \u003cp\u003eSummary \u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7\u003c\/b\u003e Ratio Analysis \u003c\/p\u003e \u003cp\u003eInterpreting Industry Averages and Trends \u003c\/p\u003e \u003cp\u003eComparing Ratios Within Industries \u003c\/p\u003e \u003cp\u003e    Analyzing Ratios Vertically and Horizontally \u003c\/p\u003e \u003cp\u003e    Getting a Basis for Ratios \u003c\/p\u003e \u003cp\u003eAnalyzing Profitability Ratios \u003c\/p\u003e \u003cp\u003e    Finding and Evaluating Earnings Per Share \u003c\/p\u003e \u003cp\u003e    Determining Gross Profit Margin \u003c\/p\u003e \u003cp\u003e    Determining Net Profit Margin \u003c\/p\u003e \u003cp\u003e    Determining the Return on Assets \u003c\/p\u003e \u003cp\u003e    Determining the Return on Equity \u003c\/p\u003e \u003cp\u003eAnalyzing Leverage Ratios \u003c\/p\u003e \u003cp\u003e    Determining the Debt Ratio \u003c\/p\u003e \u003cp\u003e    Determining the Equity Ratio \u003c\/p\u003e \u003cp\u003e    Determining the Times Interest Earned Ratio \u003c\/p\u003e \u003cp\u003eAnalyzing Liquidity Ratios \u003c\/p\u003e \u003cp\u003e    Determining the Current Ratio \u003c\/p\u003e \u003cp\u003e    Determining the Quick Ratio \u003c\/p\u003e \u003cp\u003eAnalyzing Activity Ratios \u003c\/p\u003e \u003cp\u003e    Determining the Average Collection Period \u003c\/p\u003e \u003cp\u003e    Determining Inventory Turnover \u003c\/p\u003e \u003cp\u003eDisplaying Financial Ratios in Power BI Reports \u003c\/p\u003e \u003cp\u003eSummary \u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8\u003c\/b\u003e Budgeting and Planning Cycle \u003c\/p\u003e \u003cp\u003eCreating Pro Forma Financial Statements \u003c\/p\u003e \u003cp\u003e    Forecasting by Percentage of Sales \u003c\/p\u003e \u003cp\u003eUsing Excel to Manage the Analysis \u003c\/p\u003e \u003cp\u003e    Performing Sensitivity Analysis \u003c\/p\u003e \u003cp\u003eMoving from the Pro Forma to the Budget \u003c\/p\u003e \u003cp\u003e    Projecting Quarterly Sales \u003c\/p\u003e \u003cp\u003e    Estimating Inventory Levels \u003c\/p\u003e \u003cp\u003e    Fitting the Budget to the Business Plan \u003c\/p\u003e \u003cp\u003eSummary \u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 9\u003c\/b\u003e Forecasting and Projections\u003c\/p\u003e \u003cp\u003eMaking Sure You Have a Useful Baseline \u003c\/p\u003e \u003cp\u003eMoving Average Forecasts \u003c\/p\u003e \u003cp\u003e    Creating Forecasts with the Moving Average Add-In \u003c\/p\u003e \u003cp\u003e    Dealing with the Layout of Excel’s Moving Averages \u003c\/p\u003e \u003cp\u003e    Creating Moving Average Forecasts with Excel’s Charts \u003c\/p\u003e \u003cp\u003eForecasting with Excel’s Regression Functions \u003c\/p\u003e \u003cp\u003e    Making Linear Forecasts: The TREND Function \u003c\/p\u003e \u003cp\u003e    Making Nonlinear Forecasts: The GROWTH Function \u003c\/p\u003e \u003cp\u003e    Creating Regression Forecasts with Excel’s Charts \u003c\/p\u003e \u003cp\u003eForecasting with Excel’s Smoothing Functions \u003c\/p\u003e \u003cp\u003e    Projecting with Smoothing\u003c\/p\u003e \u003cp\u003e    Using the Exponential Smoothing Tool \u003c\/p\u003e \u003cp\u003e    Choosing a Smoothing Constant \u003c\/p\u003e \u003cp\u003e    Making Smoothed Forecasts Handle Seasonal Data \u003c\/p\u003e \u003cp\u003eUsing the Box-Jenkins ARIMA Approach: When Excel’s Built-In Functions Won’t Do \u003c\/p\u003e \u003cp\u003e    Understanding ARIMA Basics \u003c\/p\u003e \u003cp\u003e    Charting the Correlograms\u003c\/p\u003e \u003cp\u003e    Starting with Correlograms to Identify a Model \u003c\/p\u003e \u003cp\u003e    Identifying Other Box-Jenkins Models \u003c\/p\u003e \u003cp\u003eDisplaying Forecast Data with Power BI \u003c\/p\u003e \u003cp\u003e    Displaying Forecasts with Power BI \u003c\/p\u003e \u003cp\u003e    Using Power BI to Display Correlograms \u003c\/p\u003e \u003cp\u003eSummary \u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 10\u003c\/b\u003e Measuring Quality\u003c\/p\u003e \u003cp\u003eMonitoring Quality Through Statistical Process Control \u003c\/p\u003e \u003cp\u003e    Using Averages from Samples \u003c\/p\u003e \u003cp\u003e    Using X-and-S Charts for Variables \u003c\/p\u003e \u003cp\u003e    Interpreting the Control Limits \u003c\/p\u003e \u003cp\u003e    Manufacturing \u003c\/p\u003e \u003cp\u003e    Publishing Control Charts with Power BI \u003c\/p\u003e \u003cp\u003e    Using P-Charts for Dichotomies \u003c\/p\u003e \u003cp\u003e    Choosing the Sample Size \u003c\/p\u003e \u003cp\u003e    Determining That a Process Is Out of Control \u003c\/p\u003e \u003cp\u003e    Using X-and-MR Charts for Individual Observations \u003c\/p\u003e \u003cp\u003e    Creating SPC Charts Using Excel \u003c\/p\u003e \u003cp\u003ePerforming Acceptance Sampling \u003c\/p\u003e \u003cp\u003e    Charting the Operating Characteristic Curve \u003c\/p\u003e \u003cp\u003eUsing Worksheet Functions for Quality Control \u003c\/p\u003e \u003cp\u003eSampling Units from a Finite Population \u003c\/p\u003e \u003cp\u003eSampling Units from a Nonfinite Population \u003c\/p\u003e \u003cp\u003e    Using NORM.S.DIST to Approximate BINOM.DIST \u003c\/p\u003e \u003cp\u003e    Sampling Defects in Units\u003c\/p\u003e \u003cp\u003e    Using the BINOM.INV Function\u003c\/p\u003e \u003cp\u003eSummary\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 11\u003c\/b\u003e Examining a Business Case: Investment\u003c\/p\u003e \u003cp\u003eDeveloping a Business Case \u003c\/p\u003e \u003cp\u003e    Getting Consensus for the Plan \u003c\/p\u003e \u003cp\u003e    Showing Your Work \u003c\/p\u003e \u003cp\u003eDeveloping the Excel Model \u003c\/p\u003e \u003cp\u003e    Developing the Inputs \u003c\/p\u003e \u003cp\u003e    Identifying the Costs \u003c\/p\u003e \u003cp\u003e    Moving to the Pro Forma \u003c\/p\u003e \u003cp\u003e    Preparing the Cash Flow Analysis \u003c\/p\u003e \u003cp\u003eSummary \u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 12\u003c\/b\u003e Examining Decision Criteria for a Business Case \u003c\/p\u003e \u003cp\u003eUnderstanding Payback Periods \u003c\/p\u003e \u003cp\u003eUnderstanding Future Value, Present Value, and Net Present Value \u003c\/p\u003e \u003cp\u003e    Calculating Future Value \u003c\/p\u003e \u003cp\u003e    Calculating Present Value\u003c\/p\u003e \u003cp\u003e    Calculating Net Present Value \u003c\/p\u003e \u003cp\u003e    Optimizing Costs \u003c\/p\u003e \u003cp\u003eSummary \u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 13\u003c\/b\u003e Creating a Sensitivity Analysis for a Business Case \u003c\/p\u003e \u003cp\u003eReviewing the Business Case \u003c\/p\u003e \u003cp\u003eManaging Scenarios \u003c\/p\u003e \u003cp\u003e    Saving a Scenario for the Base Case \u003c\/p\u003e \u003cp\u003e    Developing Alternative Scenarios \u003c\/p\u003e \u003cp\u003e    Developing Scenarios That Vary Expenses \u003c\/p\u003e \u003cp\u003e    Summarizing the Scenarios \u003c\/p\u003e \u003cp\u003eMeasuring Profit \u003c\/p\u003e \u003cp\u003e    Calculating Internal Rate of Return \u003c\/p\u003e \u003cp\u003e    Calculating Profitability Indexes \u003c\/p\u003e \u003cp\u003e    Estimating the Continuing Value \u003c\/p\u003e \u003cp\u003eVarying the Discount Rate Input \u003c\/p\u003e \u003cp\u003eUsing the Goal Seek Tool \u003c\/p\u003e \u003cp\u003eSummary \u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 14\u003c\/b\u003e Planning Profits \u003c\/p\u003e \u003cp\u003eUnderstanding the Effects of Leverage \u003c\/p\u003e \u003cp\u003e    The Effect of Business Risk \u003c\/p\u003e \u003cp\u003eAnalyzing Operating Leverage \u003c\/p\u003e \u003cp\u003e    Evaluating the Financial Implications of an Operational Change \u003c\/p\u003e \u003cp\u003e    Evaluating Fixed Expenses \u003c\/p\u003e \u003cp\u003e    Evaluating Effect of Increasing Fixed Costs \u003c\/p\u003e \u003cp\u003e    Planning by Using the DOL \u003c\/p\u003e \u003cp\u003eAnalyzing Financial Leverage \u003c\/p\u003e \u003cp\u003e    Distinguishing Business from Financial Risk \u003c\/p\u003e \u003cp\u003e    Determining the Debt Ratio \u003c\/p\u003e \u003cp\u003e    Determining the Times Interest Earned Ratio \u003c\/p\u003e \u003cp\u003eSummary \u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 15\u003c\/b\u003e Making Investment Decisions Under Uncertain Conditions \u003c\/p\u003e \u003cp\u003eUsing Standard Deviations \u003c\/p\u003e \u003cp\u003e    Using Excel’s Standard Deviation Functions \u003c\/p\u003e \u003cp\u003eUnderstanding Confidence Intervals \u003c\/p\u003e \u003cp\u003e    Using Confidence Intervals in a Market Research Situation \u003c\/p\u003e \u003cp\u003e    Calculating a Confidence Interval \u003c\/p\u003e \u003cp\u003e    Interpreting the Interval \u003c\/p\u003e \u003cp\u003e    Refining Confidence Intervals \u003c\/p\u003e \u003cp\u003eUsing Regression Analysis in Decision Making \u003c\/p\u003e \u003cp\u003e    Regressing One Variable onto Another \u003c\/p\u003e \u003cp\u003e    Interpreting the Trendline \u003c\/p\u003e \u003cp\u003e    Avoiding Traps in Interpretation: Association Versus Causation \u003c\/p\u003e \u003cp\u003e    Regressing One Variable onto Several Other Variables: Multiple Regression \u003c\/p\u003e \u003cp\u003e    Using Excel’s Regression Add-In \u003c\/p\u003e \u003cp\u003e    Interpreting Regression Output \u003c\/p\u003e \u003cp\u003e    Estimating with Multiple Regression \u003c\/p\u003e \u003cp\u003e    Using Excel’s TREND Function\u003c\/p\u003e \u003cp\u003eCreating Charts in Power BI \u003c\/p\u003e \u003cp\u003e    Creating a Scatter Chart \u003c\/p\u003e \u003cp\u003e    Creating a Clustered Column Chart in Power BI \u003c\/p\u003e \u003cp\u003eSummary \u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 16\u003c\/b\u003e Fixed Assets \u003c\/p\u003e \u003cp\u003eDetermining Original Cost \u003c\/p\u003e \u003cp\u003e    Determining Costs \u003c\/p\u003e \u003cp\u003e    Choosing Between Actual Cost and Replacement Cost \u003c\/p\u003e \u003cp\u003eDepreciating Assets \u003c\/p\u003e \u003cp\u003e    Understanding the Concept of Depreciation \u003c\/p\u003e \u003cp\u003e    Matching Revenues to Costs \u003c\/p\u003e \u003cp\u003e    Using Straight-Line Depreciation \u003c\/p\u003e \u003cp\u003e    Using the Declining Balance Method \u003c\/p\u003e \u003cp\u003e    Using the Double Declining Balance Function to Calculate Depreciation \u003c\/p\u003e \u003cp\u003e    Using Variable Declining Balance Depreciation \u003c\/p\u003e \u003cp\u003e    Using Sum-of-Years’-Digits Depreciation \u003c\/p\u003e \u003cp\u003eSummary \u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 17\u003c\/b\u003e Importing Business Data into Excel \u003c\/p\u003e \u003cp\u003eCreating and Using ODBC Queries \u003c\/p\u003e \u003cp\u003e    Preparing to Import Data \u003c\/p\u003e \u003cp\u003e    Specifying Data Sources \u003c\/p\u003e \u003cp\u003e    Creating Queries with the Query Wizard \u003c\/p\u003e \u003cp\u003e    Creating Queries with Microsoft Query \u003c\/p\u003e \u003cp\u003e    Creating Parameterized Queries in Microsoft Query \u003c\/p\u003e \u003cp\u003e    Using Joins in Microsoft Query \u003c\/p\u003e \u003cp\u003eWorking with External Data Ranges \u003c\/p\u003e \u003cp\u003e    Include Row Numbers \u003c\/p\u003e \u003cp\u003e    Adjust Column Width \u003c\/p\u003e \u003cp\u003e    Preserve Column Sort\/Filter\/Layout \u003c\/p\u003e \u003cp\u003e    Preserve Cell Formatting \u003c\/p\u003e \u003cp\u003e    Insert Cells for New Data, Delete Unused Cells \u003c\/p\u003e \u003cp\u003e    Insert Entire Rows for New Data, Clear Unused Cells \u003c\/p\u003e \u003cp\u003e    Overwrite Existing Cells with New Data, Clear Unused Cells\u003c\/p\u003e \u003cp\u003e    Managing Security Information \u003c\/p\u003e \u003cp\u003e    Arranging Automatic Refreshes \u003c\/p\u003e \u003cp\u003e    Setting Other Data Range Options \u003c\/p\u003e \u003cp\u003e    Importing Data to Pivot Tables and Charts\u003c\/p\u003e \u003cp\u003eCreating and Using Web Queries \u003c\/p\u003e \u003cp\u003e    Get External Data and Get Data From Web \u003c\/p\u003e \u003cp\u003e    Using Get Data with a Website \u003c\/p\u003e \u003cp\u003e    Using Get External Data and VBA \u003c\/p\u003e \u003cp\u003eSummary \u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 18\u003c\/b\u003e Exporting Business Data from Excel\u003c\/p\u003e \u003cp\u003eUsing VBA to Update an External Database\u003c\/p\u003e \u003cp\u003e    Getting at VBA \u003c\/p\u003e \u003cp\u003e    Structuring the Worksheet\u003c\/p\u003e \u003cp\u003e    Establishing Command Buttons \u003c\/p\u003e \u003cp\u003eEditing the Record’s Values \u003c\/p\u003e \u003cp\u003e    Using Database Objects \u003c\/p\u003e \u003cp\u003eUsing With Blocks \u003c\/p\u003e \u003cp\u003e    Finding the Right Record \u003c\/p\u003e \u003cp\u003e    Editing the Record \u003c\/p\u003e \u003cp\u003eAdding New Records to the Recordset \u003c\/p\u003e \u003cp\u003eChoosing to Use ADO \u003c\/p\u003e \u003cp\u003eSummary \u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 19\u003c\/b\u003e Using Excel 2016 and Power BI to Analyze QuickBooks Data \u003c\/p\u003e \u003cp\u003eExporting an Income Statement to Excel \u003c\/p\u003e \u003cp\u003ePublishing a QuickBooks Report in Power BI\u003c\/p\u003e \u003cp\u003e    Preparing the Data in Excel \u003c\/p\u003e \u003cp\u003e    Moving the Report to Power BI \u003c\/p\u003e \u003cp\u003eUsing the QuickBooks Software Development Kit \u003c\/p\u003e \u003cp\u003e    Parsing a Simple Subroutine \u003c\/p\u003e \u003cp\u003e    Invoking QBFC \u003c\/p\u003e \u003cp\u003e    Identifying the Sources of the Variables \u003c\/p\u003e \u003cp\u003e    Understanding then Rationale \u003c\/p\u003e \u003cp\u003eRunning the Assembly Tracker \u003c\/p\u003e \u003cp\u003e    Opening the QuickBooks Company File \u003c\/p\u003e \u003cp\u003e    Opening the Excel File \u003c\/p\u003e \u003cp\u003e    Allowing Access to QuickBooks Data \u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 20\u003c\/b\u003e Analyzing Contributions and Margins \u003c\/p\u003e \u003cp\u003eCalculating the Contribution Margin \u003c\/p\u003e \u003cp\u003e    Classifying Costs \u003c\/p\u003e \u003cp\u003e    Estimating Semivariable Costs \u003c\/p\u003e \u003cp\u003eUsing Unit Contribution \u003c\/p\u003e \u003cp\u003e    Producing Digital Video Discs (Continued) \u003c\/p\u003e \u003cp\u003e    Increasing the Contribution Margin \u003c\/p\u003e \u003cp\u003e    Creating an Operating Income Statement \u003c\/p\u003e \u003cp\u003eFinding the Break-Even Point \u003c\/p\u003e \u003cp\u003e    Calculating Breakeven in Units \u003c\/p\u003e \u003cp\u003e    Calculating Breakeven in Sales \u003c\/p\u003e \u003cp\u003e    Calculating Breakeven in Sales Dollars with a Specified Level of Profit \u003c\/p\u003e \u003cp\u003e    Charting the Break-Even Point\u003c\/p\u003e \u003cp\u003e    Choosing the Chart Type \u003c\/p\u003e \u003cp\u003eDisplaying a Break-Even Chart in Power BI \u003c\/p\u003e \u003cp\u003eMaking Assumptions in Contribution Analysis \u003c\/p\u003e \u003cp\u003e    Linear Relationships \u003c\/p\u003e \u003cp\u003e    Assignment of Costs \u003c\/p\u003e \u003cp\u003e    Constant Sales Mix \u003c\/p\u003e \u003cp\u003e    Worker Productivity \u003c\/p\u003e \u003cp\u003eDetermining Sales Mix \u003c\/p\u003e \u003cp\u003eSummary \u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 21\u003c\/b\u003e Pricing and Costing \u003c\/p\u003e \u003cp\u003eUsing Absorption and Contribution Costing \u003c\/p\u003e \u003cp\u003e    Understanding Absorption Costing \u003c\/p\u003e \u003cp\u003e    Understanding Contribution Costing \u003c\/p\u003e \u003cp\u003eApplying the Contribution Approach to a Pricing Decision: Goal Seek \u003c\/p\u003e \u003cp\u003eApplying the Contribution Approach to a Pricing Decision: Solver \u003c\/p\u003e \u003cp\u003eUsing Contribution Analysis for New Products \u003c\/p\u003e \u003cp\u003e    Allocating Expenses to Product Lines \u003c\/p\u003e \u003cp\u003e    Varying the Inputs \u003c\/p\u003e \u003cp\u003eEstimating the Effect of Cross-Elasticity \u003c\/p\u003e \u003cp\u003eSummary \u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e \u003cp\u003e\u003c\/p\u003e \u003cp\u003e9780789759580   TOC   11\/12\/2018 \u003c\/p\u003e","brand":"Pearson Education (US)","offers":[{"title":"Default Title","offer_id":49371765539159,"sku":"9780789759580","price":29.69,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9780789759580.jpg?v=1730154468","url":"https:\/\/bookcurl.com\/products\/business-analysis-with-microsoft-excel-9780789759580","provider":"Book Curl","version":"1.0","type":"link"}