Performing complex calculations efficiently

GreyCampus I., Training for working professionals

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
8 Lessons (1h 2m)
    • 1. Using Lookup functions – easy demonstration of VLOOKUP and HLOOKUP-Part 1

      5:45
    • 2. Using Lookup functions – easy demonstration of VLOOKUP and HLOOKUP-Part 2

      14:16
    • 3. Using Lookup functions – easy demonstration of VLOOKUP and HLOOKUP-Part 3

      9:21
    • 4. Using Lookup functions – easy demonstration of VLOOKUP and HLOOKUP-Part 4

      1:32
    • 5. Reverse lookup functions

      10:37
    • 6. Effective error handling

      6:01
    • 7. Tracing formula dependents and precedents

      8:52
    • 8. Using formula auditing tools to avoid errors

      5:41

About This Class

Excel is by far the world’s most popular spreadsheet program and is used for everything from maintaining simple household budgets to building sophisticated financial, models or designing complex dashboards. Analyzing Business Data with Excel shows you how to solve real-world business problems by taking Excel's data analysis features to the maximum, rather than focusing on individual Excel functions and features.