Top 10 Excel Formulas for Analysts
Speaker(s):
Chandoo (Purna Duggirala)
Duration: 60 minutes
Track: Analyze & Interpret
There are more than 200 different formulas in Excel. So when it comes to learning & mastering them, it can take forever. In this session, understand top 10 powerful, useful & important Excel formulas. We will discuss how you can creatively combine these formulas to answer most analysis questions, how to avoid common mistakes and fight formula errors.
1. References - relative, absolute & structural
2. SUMIFS formula
3. VLOOKUP formula
4. INDEX + MATCH formula
5. SMALL, LARGE formulas
6. NETWORKDAYS formula
7. Basic text formulas
8. AND OR NOT formulas
9. Basic date formulas
10. IFERROR formula
Who can attend: Anyone familiar with basic Excel formulas and already using them to analyze data. Recommended for analysts or people who create reports.