Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel Skills - Basic Level
Module 1: Basic Excel Functions To Analyze Large Data
Lecture 1: Introduction to this course (3:44)
Lecture 2: Download the Excel spreadsheet for this module (0:34)
Lecture 3: Let us look at the data for this illustration (2:55)
Lecture 4: Extraction of data: understanding the SUMIF function (8:14)
Lecture 5: Extraction of data: calculating growth rates (3:58)
Lecture 6: Extraction of data: understanding the VLOOKUP function (11:40)
Lecture 7: Extraction of data: understanding the HLOOKUP function (9:31)
Lecture 8: Extraction of data: understanding the INDEX and MATCH function (13:56)
Lecture 9: Extraction of data: understanding the IF, COUNTIF and COUNTIFS function (9:09)
Lecture 10: Presentation of data: understanding the LINE chart (12:33)
Lecture 11: Presentation of data: understanding the PIE chart (11:45)
Lecture 12: Presentation of data: understanding the COLUMN chart (13:03)
Lecture 13: Presentation of data: understanding the STACKED COLUMN chart (10:56)
Lecture 14: Presentation of data: understanding the CONDITIONAL FORMATTING function (6:58)
Lecture 15: Practice Assignment #1 - Difficulty level: MEDIUM
Lecture 16: Solution to Practice Assignment #1
Lecture 17: End of course
Lecture 18: Please provide us with your valuable feedback
Lecture 1: Introduction to this course
Complete and Continue