Microsoft Excel

MS Excel Specialist (Class 12) – LOOKUP Functions (LOOKUP, VLOOKUP, INDEX & MATCH)

2 weeks ago

0 26

Welcome to Class 01 of our SQL for Data Analytics series! Watch this before starting your data career, it’s the…

MS Excel Specialist (Class 11) – Conditional Functions (SUMIFS, AVERAGEIFS) | Sparklines

2 weeks ago

0 26

Welcome to Class 01 of our SQL for Data Analytics series! Watch this before starting your data career, it’s the…

MS Excel Specialist (Class 10) – Conditional Functions (COUNTIFS) for Data Analysis

2 weeks ago

0 27

Welcome to Class 01 of our SQL for Data Analytics series! Watch this before starting your data career, it’s the…

MS Excel Specialist (Class 09) – Logical Functions (AND, OR, Mixed AND-OR)

2 weeks ago

0 26

Welcome to Class 01 of our SQL for Data Analytics series! Watch this before starting your data career, it’s the…

MS Excel Specialist (Class 08) – Logical Functions (IFS, SWITCH, TRUE)

2 weeks ago

0 26

Welcome to Class 01 of our SQL for Data Analytics series! Watch this before starting your data career, it’s the…

MS Excel Specialist (Class 07) – Logical Functions (IF, Nested IF, IF ELSE) | Order of Execution

2 weeks ago

0 26

Welcome to Class 01 of our SQL for Data Analytics series! Watch this before starting your data career, it’s the…

MS Excel Specialist (Class 06) – Advanced Text Functions

2 weeks ago

0 35

Welcome to Class 01 of our SQL for Data Analytics series! Watch this before starting your data career, it’s the…

MS Excel Specialist (Class 05) – Text Functions in Excel (LEFT, RIGHT, MID, FIND, LEN, SEARCH)

2 weeks ago

0 32

Welcome to Class 01 of our SQL for Data Analytics series! Watch this before starting your data career, it’s the…

MS Excel Specialist (Class 04) – Function Syntax | Text Functions in Excel | Formula Nesting

2 weeks ago

0 32

Welcome to Class 01 of our SQL for Data Analytics series! Watch this before starting your data career, it’s the…

MS Excel Specialist (Class 03) – Mathematical Calculation | Absolute, Relative & Mixed Referencing

2 weeks ago

0 33

Welcome to Class 01 of our SQL for Data Analytics series! Watch this before starting your data career, it’s the…

Microsoft Excel

MS Excel Specialist (Class 12) – LOOKUP Functions (LOOKUP, VLOOKUP, INDEX & MATCH)

MS Excel Specialist (Class 11) – Conditional Functions (SUMIFS, AVERAGEIFS) | Sparklines

MS Excel Specialist (Class 10) – Conditional Functions (COUNTIFS) for Data Analysis

MS Excel Specialist (Class 09) – Logical Functions (AND, OR, Mixed AND-OR)

MS Excel Specialist (Class 08) – Logical Functions (IFS, SWITCH, TRUE)

MS Excel Specialist (Class 07) – Logical Functions (IF, Nested IF, IF ELSE) | Order of Execution

MS Excel Specialist (Class 06) – Advanced Text Functions

MS Excel Specialist (Class 05) – Text Functions in Excel (LEFT, RIGHT, MID, FIND, LEN, SEARCH)

MS Excel Specialist (Class 04) – Function Syntax | Text Functions in Excel | Formula Nesting

MS Excel Specialist (Class 03) – Mathematical Calculation | Absolute, Relative & Mixed Referencing

SQL for Data Analytics (Class 07) – String Functions (RIGHT, SUBSTRING, Dynamic String Functions

MS Excel Specialist (Class 22) – Interactive Excel Dashboard Design

SQL for Data Analytics (Class 05) – Date Types & Parts | Date Function (DATEDIFF, GETDATE, DATEADD)

SQL for Data Analytics (Class 06) – String Functions (CONCAT, LEFT, UPPER, LOWER, REPLACE)

SQL for Data Analytics (Class 04) – Aggregation (SUM, COUNT, AVG) | Numeric (ROUND, CEILING, FLOOR)

SQL for Data Analytics (Class 03) – WHERE and GROUP BY Clauses in SQL