Lab 3: Accounts Receivable Summary by Customer (Excel)
Lab 4: Inventory Management by Customer Profitability (Excel)
Lab 5: Inventory Management by SKU Profitability (Tableau)
Lab 6: Identify and Work with Different Data Types (Excel)
Lab 7: Identify and Work with Different Data Types (Tableau)
Lab 8: Working with Data in Excel: Ranges, Tables, and PivotTables
Lab 9: Linking Two Tables Using VLOOKUP for State Tax Rates (Excel)
Lab 10: Descriptive Statistics for the Retail Industry
Lab 11: Using Conditional Formatting to Perform Bank Reconciliations
Lab 12: Accounts Receivable Aging (Excel)
Lab 13: Accounts Receivable Aging (Tableau)
Lab 14: Vertical Analysis of Financial Performance (with Sparklines)
Lab 15: DuPont Analysis of Financial Performance
Lab 16: Days of the Week Journal Transactions
Lab 17: Benford’s Law
Lab 18: Fuzzy Matching Add-In Installation (PC)
Lab 18: Fuzzy Matching and Fake Employees/Vendors (PC)
Lab 18: Fuzzy Matching and Fake Employees/Vendors (Mac)
Lab 19: Looking for Fraud by Examining Relationships within a Data File: Accounts Payable Clerks and Company Vendors
Lab 20: Evaluating the Relationship between Sales and Advertising Expense
Lab 21: Predicting Bankruptcy Using Altman's Z Score
Lab 22: Classifying Loan Acceptance Using Lending Club Data
Lab 23: Estimating Activity-Based Cost Drivers Using Regression Analysis
Lab 24: Estimating Borrower Interest Rates Using Regression Analysis with Lending Club Data
Lab 25: Forecasting Future Performance (Sales and Earnings for IBM and Microsoft)
Lab 26: What-If/Solver/Breakeven/Goal Seek