1. Basic Excel Business Analytics #01: Basic Business Analytics using Excel

2. Basic Excel Business Analytics #02: Good Spreadsheet Model Design, Fixed Variable Cost Example

3. Basic Excel Business Analytics #03: Goal Seek For What-If Analysis

4. Basic Excel Business Analytics #04: Excel Formula for Units Break Even Point and a Unit Defect Rate

5. Basic Excel Business Analytics #05: 1 Variable Data Table For What-If Analysis

6. Basic Excel Business Analytics #06: 2 Variable Data Table For What-If Analysis

7. Basic Excel Business Analytics #07: X-Y Scatter Chart: Fixed Cost Variable Cost Model

8. Basic Excel Business Analytics #08: Total Revenue Calculation: VLOOKUP or LOOKUP/SUMPRODUCT?

9. Basic Excel Business Analytics #09: Shortest Distance Shipping Costs: INDEX, MATCH, & IF Functions

10. Basic Excel Business Analytics #10: Find & Fix Excel Formula Errors in Spreadsheet Models

11. Basic Excel Business Analytics #11: Dynamic Grading Model: Excel Table feature & VLOOKUP

12. Basic Excel Business Analytics #27: Clean & Transform Data: Formulas, Flash Fill, Power Query, TTC

13. Basic Excel Business Analytics #28: Power Query: Import Multiple Text Files & Build Grade Dashboard

14. Basic Excel Business Analytics #29: Power Query: Import Multiple Large CSV Files Into Data Model

15. Basic Excel Business Analytics #31: Power Query: Import Multiple Excel Files with 1 Sheet Each

16. Basic Excel Business Analytics #32: Power Query Import Multiple Excel Files with Multiple Sheets

17. Basic Excel Business Analytics #33: Power Query: Transform Many Bad Data Files into Proper Data Set

18. Basic Excel Business Analytics #34: Power Query: Import & Merge Multiple Sources Access, Text, Excel

19. Basic Excel Business Analytics #35: Power Query to Get Data From Web Site & Import into Excel.

20. Basic Excel Business Analytics #37: Excel 2016 Data Tab, Get & Transform: Unpivot feature

21. Excel Business Analytics #39: Import Related Tables: Power Query Merge? Data Model Relationships?