EN
USD
Course
Advanced Microsoft Excel for Business Analytics (Swahili Course)
T
TechTrain Academy
(3 Ratings)
$21.00
Includes:
Certificate on Completion
Buy now
Course Content
Details
Reviews
Module 1: Advanced Formulas and Functions
5:52:15
Formula Auditing Tools
15:26
Understanding Cell References
14:26
Intro to Logical Functions And IF Function
12:40
Using IF with AND and OR Functions
7:58
Nested IF Function
15:07
IFS Function
6:48
LOOKUP Function
8:30
VLOOKUP With Approximate Match
8:39
HLOOKUP With Approximate Match
5:53
VLOOKUP and HLOOP With Approximate Match - Further Example
4:48
VLOOKUP and HLOOKUP with Exact Match
3:04
Handling VLOOKUP and HLOOKUP Errors
2:13
MATCH Function - Exact Match
5:12
MATCH Function - Approximate Match Part 1
3:14
MATCH Function - Approximate Match Part 2
5:30
INDEX-MATCH Functions - Approximate Match
9:36
INDEX-MATCH Functions - Exact Match
3:40
INDEX-MATCH Functions - 2D Lookup
5:06
CHOOSE Function
10:51
SWITCH Function
5:30
SWITCH Function - SWITCH TRUE
10:58
OFFSET Function
7:58
LEFT, RIGHT, LEN and REPT Functions
3:37
FIND And SEARCH Functions
5:03
MID Function
4:25
TEXTBEFORE And TEXTAFTER Functions
5:13
& Symbol, CONCATENATE And CONCAT Functions
9:51
TEXTJOIN Function
6:25
SUBSTITUTE And REPLACE Functions
8:42
TRIM, PROPER, LOWER And UPPER Functions
5:41
TEXT Function
13:21
Intro to Dates, TODAY And NOW Functions
2:22
DATE, EDATE And EOMONTH Functions
5:23
DATEDIFF, YEAR, MONTH And DAY Functions
4:32
NETWORKDAYS (INTL) And WORKDAY (INTL) Functions
14:44
SUM, COUNT, COUNTA And AVERAGE Functions
7:39
MIN, MAX, SMALL, And LARGE Functions
3:39
RAND And RANDBETWEEN Functions
3:32
ROUND Function
4:02
ROUNDUP Function
12:16
ROUNDDOWN Function
3:44
COUNTIF, SUMIF And AVERAGEIF Functions
5:52
COUNTIFS, SUMIFS And AVERAGEIFS Functions
18:14
RANK, RANK.AVG and RANK.EQ Functions
10:48
LET Function
6:17
Summarize Multiple Sheets with 3D Formulas
5:27
Flash Fill
8:19
Module 2: Dynamic Array Functions
1:07:32
Module 3: LAMBDA Functions
1:33:42
Module 4: Advanced Formatting Techniques
1:48:47
Module 5: Conditional Formatting
57:45
Module 6: Data Validation
59:06
Module 7: Data Analysis with Pivot Tables
1:06:12
Module 8: Data Visualization with Charts
1:49:26
Module 9: Macros and VBA
6:39:14
Module 10: Data Management and Using AI with Excel
1:05:19
Module 11: Dashboard Designing
2:19:19
Introduction
Frequently bought together