Advanced
Business Analytics
Business Intelligence
Nexlab (Pvt) Ltd
-
Course Content Intro
1Lessons
·
-
Week 1
7Lessons
·
2 hr 28 min
-
Introducation of Ms Excel (Formatting and Data Entry) Part-1
-
Introducation of Ms Excel (Data Entry and Text Formatting) Part-2
-
Introducation of Ms Excel (Numric Formatting and Cell References Intro) Part-3
-
Introducation of Ms Excel (Conditional Formatting) Part 4
-
Introducation of Ms Excel Excel (Tables and Basic Formulas) Part 5
-
Introducation of Ms Excel (Data Validation and Home Tab Intro) Part 6
-
Week-One Rescourses File
-
Week-2
7Lessons
·
3 hr 13 min
-
Excel Week Two (Mangining Sheets, View Tab, Auto Fill ) Part-7
-
Excel Week Two (Logicial Formulas) Part-8
-
Excel Week Two (Math Formulas) Part-9
-
Excel Week Two (Static Formulas Lookup) Part-10
-
Excel Week Two (Date, Others Formulas) Part-11
-
Excel Week Two (Sum Formulas Details) Part-12
-
Week-2 Resources Files
-
Week-3
7Lessons
·
3 hr 3 min
-
Excel Week 3 Index Match Formula Part 13
-
Excel Week 3 Picture Lookup Formula Part 14
-
Excel Week 3 Cleaning Data Part 15
-
Excel Week 3 Dated Funcation Part 16
-
Excel Week 3 Offset Nameranges Part 17
-
Excel Week 3 Sorting Filtring Data Part 18
-
Week-3 Resources Files
-
Week-4
5Lessons
·
2 hr 5 min
-
Excel Week4 Pivot Table Part 19
-
Excel Week4 Pivot Table Part 20
-
Excel Week4 Charts Part 21
-
Excel Week4 Charts Saniro Manger Part 22
-
Week-4 Resources Files
-
Week-5
2Lessons
·
1 hr 17 min
-
Nexlab (Pvt) Ltd