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