Course Content
0/ 61 0% Complete
1. Moving Ahead with Microsoft Excel
0/6
1. Getting Started
01:23
2. Product Function
00:30
3. SumProduct Function
01:53
4. Conditional Formatting I
02:27
5. Conditional Formatting II
01:39
6. Conditional Formatting III
01:48
2. Tools for Organizing Data
0/9
1. Freezing Cells, Rows and Columns
04:51
2. Table Format
02:30
3. Table Format II
01:15
4. Sort and Filter
04:53
5. Sort and Filter II
01:11
6. PIVOT
05:14
7. Join and Concatenate
02:50
8. Text to Columns
03:00
9. Sub Total
03:48
3. Be smarter with Excel Tools
0/7
1. Format Painter
02:14
2. Freeze Panes
01:58
3. Paste Values
02:50
4. Remove Duplicates
03:28
5. Paste Formats
01:29
6. Paste – Divide
01:48
7. Transpose
01:24
4. More Excel Tools
0/12
1. Rank
02:53
2. Large and Small
02:28
3. Pie Chart
02:35
4. Print Options
02:57
5. Round
03:15
6. Odd and Even
01:37
7. Vlookup
05:00
8. Hlookup
01:59
9.True and False
01:43
10. Left, Right and Mid
04:03
11. Find
01:01
12. Hyperlink
03:23
5. Logical Excel Formulas
0/11
1. IF Function
04:54
2. IF Function II
01:05
3. IF Function III
04:36
4. AND
03:14
5. IF AND
01:29
6. IF OR
02:32
7. IF Error
02:36
8. CountIf
02:27
9. Count IFs
01:57
10. Sum If
01:38
11. Sum IFs
01:35
6. More Smart Functions
0/8
1. TRIM
01:35
2. Case
01:19
3. Customizing Quick Access
03:15
4. Excel Security
04:55
5. Shortcuts
01:50
6. Adding Shapes
02:55
7. Adding Smart Art
03:01
8. Apostrophe
00:46
7. Getting Advanced with Excel
0/8
1. Data Validation
05:19
2. PIVOT Charts
02:25
3. PIVOT Slicers
02:14
4. LEN
00:42
5. Search
00:40
6. Dependents and Precedents
03:00
7. Date Time
01:22
8. Adding Formulas
01:28
Microsoft Excel Course: From Zero to Hero
Please complete previous Lesson first
4. Conditional Formatting I
0% Complete