-
Microsoft Excel zero to hero Course Introduction 1
-
1.1 An Introduction To The CourseLecture1.1
-
-
Microsoft Excel Fundamentals 5
-
2.1 Excel InterfaceLecture2.1
-
2.2 Customizing Excel ToolbarsLecture2.2
-
2.3 Working with filesLecture2.3
-
2.4 Common Excel shortcutsLecture2.4
-
2.5 Excel fundamentals quizQuiz2.11 question
-
-
Editing & Formatting Data 7
-
3.1 Editing dataLecture3.1
-
3.2 Numeric Data In excelLecture3.2
-
3.3 Formatting dataLecture3.3
-
3.4 Characteristics of a cellLecture3.4
-
3.5 Cell ReferenceLecture3.5
-
3.6 Copying & fillingLecture3.6
-
3.7 Excel workbook managementLecture3.7
-
-
Basic Excel Functions 6
-
4.1 Introduction to excel functionsLecture4.1
-
4.2 The SUM() functionLecture4.2
-
4.3 The MIN() & MAX() functionLecture4.3
-
4.4 The AVERAGE() & COUNT() functionsLecture4.4
-
4.5 More on basic excel functionsLecture4.5
-
4.6 Basic Excel Functions QuizQuiz4.10 question
-
-
Shapes | Images |Charts In Excel Worksheet 6
-
5.1 Inserting images and shapesLecture5.1
-
5.2 Formatting Excel ShapesLecture5.2
-
5.3 Working with smart artLecture5.3
-
5.4 Creating excel chartsLecture5.4
-
5.5 Modifying Excel ChartsLecture5.5
-
Excel Charts QuizQuiz5.10 question
-
-
Conditional Functions 4
-
6.1 IF() functionLecture6.1
-
6.2 Nested IF() functionLecture6.2
-
6.3 Nesting of IF() & AND() | OR() functionsLecture6.3
-
6.4 Stat functionsLecture6.4
-
-
Lookup Functions 9
-
7.1 VLOOKUP() & HLOOKUP()Lecture7.1
-
7.2 NESTED VLOOKUP()Lecture7.2
-
7.3 CHOOSE() functionLecture7.3
-
7.4 MATCH() functionLecture7.4
-
7.5 INDEX() functionLecture7.5
-
7.6 Nested MATCH() & INDEX()Lecture7.6
-
7.7 VLOOKUP() & MATCH() NestingLecture7.7
-
7.8 TRANSPOSE() functionLecture7.8
-
7.9 OFFSET() functionLecture7.9
-
-
Text Functions 9
-
8.1 Basic Text FunctionsLecture8.1
-
8.2 LEFT(), MID(), RIGHT()Lecture8.2
-
8.3 SEARCH & FIND()Lecture8.3
-
8.4 SUBSTITUTE() & REPLACE()Lecture8.4
-
8.5 Nesting LEFT() RIGHT() FIND()Lecture8.5
-
8.6 Nesting MID() FIND()Lecture8.6
-
8.6 Nesting SUBSTITUTE() & FIND()Lecture8.7
-
8.7 TRIM() FunctionLecture8.8
-
8.8 Text Functions QuizQuiz8.10 question
-
-
Date & Time Functions 1
-
9.1 Date & Time Function WorkbookLecture9.1
-
-
Pivot Charts 1
-
10.1 Pivot Charts WorkbookLecture10.1
-
This content is protected, please login and enroll course to view this content!