About Lesson
Class 1: Introduction & Terminology
0/3
Class 2: Data Entry, Editing and Freeze Panes
0/3
Class 3: Data Navigation, Selection and Dragging
0/3
Class 4: Formula
0/3
Class 5: Formula Application
0/3
Class 6: Percentage
0/3
Class 7: Fonts & Borders
0/3
Class 8: Alignment
0/3
Class 9: Format Painter
0/3
Class 10: Format Cells
0/3
Class 11: Auto Fill
0/3
Class 12: Cell Styles & Themes
0/3
Class 13: Rows & Columns
0/3
Class 14: Find & Replace
0/3
Class 15: Data Filtering
0/3
Class 16: Data Sorting
0/3
Class 17: Conditional Formatting
0/3
Class 18: Format as Table
0/3
Class 19: Text to Columns
0/3
Class 20: Remove Duplicates
0/3
Class 21: Data Validation: Dropdown
0/3
Class 22: Data Validation: Data Limit
0/3
Class 23: Page Layout: Margin, Orientation, Size
0/3
Class 24: Page Layout: Print Area, Print Titles, Page Break Preview
0/3
Class 25: Insert Page Number
0/3
Class 26: Bar/Column Chart
0/3
Class 27: Pie Chart
0/3
Class 28: Line Chart
0/3
Class 29: Formula vs Functions
0/3
Class 30: Sum & AutoSum
0/3
Class 31: Average, Min & Max
0/3
Class 32: Count Functions
0/3
Class 33: Large & Small
0/3
Class 34: Absolut & Relative
0/3
Class 35: Data Ranking
0/3
Class 36: Combining Texts: &, CONCATENATE
0/3
Class 37: Function: RIGHT/LEFT/MID
0/3
Class 38: Function: FIND & RIGHT/LEFT Application
0/3
Class 39: Adding “+” and Zero before a number
0/3
Class 40: Function: LOWER/UPPER/PROPER
0/3
Class 41: Function: TEXT
0/3
Class 42: Function: DAY/MONTH/YEAR
0/3
Class 43: Function: IF
0/3
Class 44: Nested IF
0/3
Class 45: Function: COUNTIFS
0/3
Class 46: Function: SUMIFS
0/3
Class 47: Function: TRIM
0/3
Class 48: VLOOKUP (Exact Match)
0/3
Class 49: VLOOKUP (Approximate Match)
0/3
Class 50: Function: IFERROR
0/3
Class 51: Learning functions from Excel
0/3
Class 52: Pivot Table
0/3
Class 53: Pivot Chart
0/3
Class 54: Slicer
0/3
Class 55: Mail Merge
0/3