
About this Course
Syllabus
About this Course
Excel is considered one of the most common programs in the world of data. Its friendliness and convenience make the data analysis process simple and easy for the novice user. And at the same time – Excel is a very powerful and sophisticated tool for the experienced user.
This course teaches in depth the use of complex functions and formulas, through which dynamic and powerful data analysis can be performed.
Audience
Various units in the organization that wish to deepen their Excel knowledge and use it for advanced data analysis.
Prerequisites
Previous background and experience in Excel
- Simple Conditional Statements (If Statements)
- Combining (Nesting) Multiple If Statements
- Integrating And and Or Statements
- Using The Not (Or <>) Clause
- Using Excel’s IFERROR Statement
- IS Statements
- Basic Excel Statistical Functions
- Using SMALL,LARGE,RANK/PERCENTRANK
- Generating Random Values
- Applying A Row-Level Calculations
- Conditional Stats Functions
- Using Named Ranges To Simplify Excel Formulas
- Introducing ROW,ROWS,COLUMN,and COLUMNS Functions
- Using VLOOKUP/HLOOKUP
- Error Handling With IFERROR & VLOOKUP
- VLOOKUP Array Options
- Approximate Match Lookups
- Navigating Cell Ranges
- Matching Values
- Defining Ranges With OFFSET
- Common Text Functions
- Concatenating Text
- Extracting Sub-Texts
- Converting Text To Values
- Using The Search and Find Functions
- Categorizing Data
- Replacing Text
- Formatting Dates
- Automatically Generate Lists Of Dates
- Extracting Time Periods
- Defining Time Periods
- Calculating Differences Between Dates
- Managing Formula-Based Functions
- Highlighting Rows
- Formatting Rules Based On Another Cell
- Apply Formats Based On Statistical Operations
- Apply Formats Based On Logical Operator
- Introduction To Excel’s Dynamic Array
- Common Dynamic Array Functions
- Formatting Data With Pivot Table
- Filtering, Sorting & Aggregating Data Using Pivot Table
- Calculated Fields And Values
- Visualizing Data With Excel Pivot Charts