This 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 :

• Microsoft Excel Tips and tricks.

• Most important Excel basic functions and formulas.

• How to use Excel shortcuts.

• 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.

• 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 is made for those who are interested in data analysis. Moreover, it will give you an idea on how can you link up data together following the data modelling principles.

This course will help you to start data analysis from scratch and it will be your first step for developing your analysis skills and finding new work opportunities. Moreover, it will help you to transform your data analysis into beautiful and insightful charts

At the end of this course, you’ll understand the following :

• Understand all Microsoft Excel options and settings, this is explained in a step by step approach.

• Using Excel shortcuts for saving a lot of time and efforts.

• How to customize Excel interface to make you faster in doing analysis tasks.

• Most important basic Excel functions (SUM, IF Statement, COUNT, AVERAGE, SMALL, LRAGE and many more ..).

• How to apply Anchoring and Formatting in a very easy way.

• How to make data grouping in order to organize your data.

• Trace functions and formulas using trace precedents and trace dependents.

• How to use Go to special and Conditional formatting.

• Saving a lot of time by using Excel shortcuts for each and every action you need to take.

• Organizing data using data modeling fundamentals and principles.

• Using date functions in a very professional way.

• Setting up Data tables and Pivot tables.