Rating 5.0 out of 5 (1 ratings in Udemy)
What you'll learn- How to combine Excel functions and formulas to make your analysis and models more dynamic.
- Microsoft Excel Dynamic Time Periods (using IF statements)
- Advanced Analysis Techniques (Scenario analysis with XLOOKUP and CHOOSE functions).
- Dynamic outputs using OFFSET and IF statements).
- Data summary with VLOOKUP and INDEX MATCH MATCH combination.
- Using INDIRECT functions and What-if analysis (GOALSEEK tool).
- Creating a very …
Rating 5.0 out of 5 (1 ratings in Udemy)
What you'll learn- How to combine Excel functions and formulas to make your analysis and models more dynamic.
- Microsoft Excel Dynamic Time Periods (using IF statements)
- Advanced Analysis Techniques (Scenario analysis with XLOOKUP and CHOOSE functions).
- Dynamic outputs using OFFSET and IF statements).
- Data summary with VLOOKUP and INDEX MATCH MATCH combination.
- Using INDIRECT functions and What-if analysis (GOALSEEK tool).
- Creating a very professional Cover Page using CELL, RIGHT,LEN and FIND functions.
- Using COUNT, COUNTA and combining IF with AND,OR formulas.
- Setting up Data tables and Pivot tables.
- Pivot tables field settings, filters, calculated fields, slicers and timeline.
- Combining two different chart types (Column and line charts).
- Dynamic Charts (Single and Multi-Array Charts).
- Recording and developing Macros.
DescriptionThis course is made for those who are interested in taking their data analysis skills to another level. Moreover, it will teach you how to combine Excel functions together in order to build up a very advanced Excel formulas.
You’ll learn the following in this course :
How to combine Excel functions and formulas to make your analysis and models more dynamic.
Microsoft Excel Dynamic Time Periods (using IF statements)
Advanced Analysis Techniques (Scenario analysis with XLOOKUP and CHOOSE functions).
Dynamic outputs using OFFSET and IF statements).
Data summary with VLOOKUP and INDEX MATCH MATCH combination.
Using INDIRECT functions and What-if analysis (GOALSEEK tool).
Creating a very professional Cover Page using CELL, RIGHT,LEN and FIND functions.
Using COUNT, COUNTA and combining IF with AND,OR formulas.
Setting up Data tables and Pivot tables.
Pivot tables field settings, filters, calculated fields, slicers and timeline.
Combining two different chart types (Column and line charts)
Dynamic Charts (Single and Multi-Array Charts).
Recording and developing Macros.
This course will help you to transform your data analysis into beautiful and insightful charts
Who can attend this course ?
This course is prepared for those who started the data analysis journey and willing to advance their knowledge as a good preparation for being a successful data analysts.
