Advanced Data Analysis - المستوى الاحترافى لتحليل البيانات
Advanced Data Analysis using Excel - تحليل البيانات بشكل احترافى عن طريق ميكروسوفت اكسيل
4.20 (5 reviews)
7
students
2 hours
content
Aug 2022
last update
$24.99
regular price
What you will 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.
Screenshots
Related Topics
4672106
udemy ID
5/4/2022
course created date
7/20/2022
course indexed date
Bot
course submited by