Offer ends in:
What you'll get
- 2h 35m
- 14 Videos
- Course Level - Beginner
- Course Completion Certificates
- One-Year Access
- Mobile App Access
Curriculum:
Excel for Data Analyst:
Excel is by far the world’s most popular spreadsheet program and is useful 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.
Through this course, you will learn Advanced Data Sorting and Filtering techniques and how to use Lookup & reverse Lookup techniques – easy demo of VLOOKUP, HLOOKUP, INDEX and MATCH
The training will help you learn about
- Advanced Data Sorting
- Advanced Filtering
- Conditional Formatting
- Cell Referencing in Excel
- Text Formulas
- Removing Duplicates
- Generate Pivot tables from datasets
- VLOOKUP, HLOOKUP, INDEX & MATCH
- Advanced functions- Transpose, Fibonacci, Skip blanks
- What-if analysis
Target Customers:
- Market Analysts
- Research Analysts
- Data Analysts
- Business Analysts
Pre-Requisites:
- Basic computer knowledge
- Familiarity with the Microsoft Office work environment
Offer ends in:
Training 5 or more people?
Get your team access to 5,000+ top courses, learning paths, mock tests anytime, anywhere.
Drop an email at: [email protected]
2h 35m | 14 Videos | 
Beginner 
