Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel on Fingertip
Introduction
Introduction (1:08)
Course Overview (2:22)
LEVEL 1: Beginner- Formatting
#1: Mastering 15 Excel shortcut keys (0:55)
#2: How to Add Today's Date & Current Time (0:32)
#3: How to Add Quick Date Series (0:37)
#4: How to Add Quick Days Series (0:34)
#5: How to Add Quick Number Sequences (0:36)
#6: Add Data Picker Calendar (0:36)
#7: Transpose Data (0:33)
#8: Copy & Move Worksheet (0:25)
#9: Add More Data in One Cell (0:30)
#10: Change Title Case (0:31)
#11: Freeze Panes (0:26)
#12: Quick Color Formatting (0:28)
#13: Paste Values (0:23)
#14: Sort Cells by Colors (0:26)
#15: Insert 3D Model (0:36)
LEVEL 1: QUICK QUIZ QUEST!!
LEVEL 2: Intermediate- Formatting
#16: Intermediate Level Keyboard Shortcuts (0:57)
#17: Quick Fill in Blank Cells (0:36)
#18: Flash Fill Feature in Excel (0:26)
#19: Alternate To Merging & Centre Cells (0:38)
#20: Create a Table & Format Tables (0:38)
#21: Find & Remove Unwanted Text (0:34)
#22: Highlight Duplicates-Conditional Formatting (0:33)
#23: Percentage Formatting Cell (0:45)
#24: Quick Move Data Rows Up & Down (0:29)
#25: Insert Multiple Rows in One Click (0:39)
#26: Data Validation (1:03)
#27: Checklist Strikethrough (1:16)
#28: Auto Fill Email Address (0:29)
#29: Remove Background Image (0:49)
#30: Shrink Text to Fit Cell (0:31)
#31: Add Background Image (0:40)
#32: Insert PDF Data into Excel (0:41)
#33: Insert Data Bar (0:47)
#34: Split Text in a Cell (0:34)
#35: Compare Differences (0:36)
Level 2: Quick Quiz Quest!!
LEVEL 3: Intermediate- Function
#36: Quick Auto Sum (0:36)
#37: Add or Collapse Formula Breakdown (0:44)
#38: Percentage Calculation (0:34)
#39: Mix & Max (0:37)
#40: Remove Blank Multiple Rows in a Data (0:41)
#41: Quick Join Text Column (0:48)
#42: Repeat Last Action (0:31)
#43: CountA Function (0:26)
#44: Trim Function (0:31)
#45: Add Bullet Points (0:46)
Level 3: Quick Quiz Quest!!
LEVEL 4: Advanced- Formatting
#46: Adding Custom Format KG/ $ (0:57)
#47: Custom Format Thousands (K) & Millions (M) (1:08)
#48: Create Form for Data Entry (1:19)
#49: Define Names in Formula (0:49)
#50: Insert Data from Web (0:45)
#51: Collapse Image on Filter (0:58)
#52: Sparkline (0:51)
#53: Pivot Table (1:09)
#54: Slicer & Timeline Slider (1:04)
#55: Spin Button (1:04)
Level 4: Quick Quiz Quest!!
LEVEL 5: Advanced- Function
#56: Insert Subtotals (1:02)
#57: CONCATENATE (1:07)
#58: MATCH Function (1:06)
#59: $-Lock Cell Reference (1:01)
#60: IF Function (1:17)
#61: SUMIF Function (1:09)
#62: SUMIFS Function (1:11)
#63: Convert Units (1:02)
#64: Find Smallest Value (0:39)
#65: XLOOKUP (1:01)
#66: VLOOKUP (1:27)
#67: Refresh Pivot Table (1:27)
#68: Pivot Table Running Total (0:59)
#69: Custom with Indication (1:22)
#70: Dynamic Calendar (2:12)
Level 5: Quick Quiz Quest!!
LEVEL 6: Advanced- Chart
#71: Slicer with Chart (1:12)
#72: Ring Chart (1:46)
#73: Grouping Chart (2:20)
#74: Pivot Chart (1:59)
#75: Create Radio Button & Filter Chart (1:53)
#76: Vertical Bullet Chart (2:20)
#77: 3D Glass Effect Chart (2:34)
#78: Geo-Chart (2:43)
#79: Infographic (1:39)
#80: Dashboard (4:20)
Level 6: Quick Quiz Quest
LEVEL 7: Advanced- Google Sheets
#81: VSTACK Function (1:08)
#82: TOCOL Function (1:01)
#83: IF Function (0:56)
#84: COUNTIF Function (0:45)
#85: Sparkline (1:21)
#86: Dropdown with Colors (0:56)
#87: Calendar Dropdown (0:54)
#88: Split Text (1:00)
#89: Google Translate (1:18)
#90: SheetGPT (2:57)
Level 7: Quick Quiz Quest!!
Closing
Congratulation!! Well Done!! (1:15)
#83: IF Function
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock