betterskill.io

Menu
Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
Login/Signup
Course Content
Module 1: Introduction to Excel & the Interface
0/11
Lecture 1: What is Excel & its Uses
04:09
Lecture 2: Overview of the Excel Interface
03:31
Lecture 3: What is Workbook & Worksheet?
02:56
Lecture 4: Manage Your Worksheet (Part 1)
05:24
Lecture 5: Manage Your Worksheet (Part 2)
01:39
Lecture 6: Navigate into Your Worksheet
06:59
Lecture 7: Data Types in Excel
02:20
Lecture 8: Data Entry Basics
01:37
Lecture 9: Cut, Copy and Paste
07:43
Lecture 10: Other Paste option & Transpose Function
06:18
Lecture 11: Saving and Managing Files
02:04
Module 2: Basic Formatting and Tools
0/7
Lecture 1: Formatting Numbers, Text, and Dates
04:16
Lecture 2: Cell style Alignment, Wrapping & Merging
02:32
Lecture 3: Custom Cell Style Font, Borders, and Cell Color
02:29
Lecture 4: Using Format Painter
01:38
Lecture 5: Fill Handle & Autofill
14:02
Lecture 6: Understanding cell references Relative, Absolute, Mixed
08:54
Lecture 7: Inserting and Deleting Rows Columns
03:02
Module 3: Data Sorting and Filtering
0/2
Lecture 1: Sorting data (A–Z, Z–A, custom sort)
07:46
Lecture 2: Filtering Data
07:29
Module 4: Basic Formulas and Functions
0/8
Lecture 1: Formula and Functions (Understanding its differences with Basic math operations +, –, ,)
05:44
Lecture 2: Excel Functions Basic and Types
03:13
Lecture 3: Excel Function- SUM
02:46
Lecture 4: Excel Function- AVERAGE
00:31
Lecture 5: Excel Function- MAX
00:27
Lecture 6: Excel Function- MIN
00:30
Lecture 7: Excel Function Count
01:04
Lecture 8: Excel Quick Analysis
01:59
Module 5: Logical and summarizing Functions
0/3
Lecture 1: Logical Operators
02:19
Lecture 2: Logical Functions (If, Or, And, Not)
07:11
Lecture 3: Advanced Logical Functions (SUMIF, COUNTIF, AVERAGE IF, MAXIF, MIN IF)
07:19
Module 6: Everyday functions
0/11
Lecture 1: Text Join Functions
09:33
Lecture 2: Text Extracting Functions
04:54
Lecture 3: Find, Search & Len function
Lecture 4: Value Converting Functions
06:25
Lecture 5: Text Converting Functions
02:31
Lecture 6: Data Cleaning (Part 1)
02:00
Lecture 7: Data Cleaning (Part 2)
04:10
Lecture 8: VLOOKUP
07:57
Lecture 9: Index With Match
09:09
Lecture 10: Xlookup
04:39
Lecture 11: Extracting Day, Month, Year, Date data
02:30
Module 7: Name range, Table, and Validation
0/2
Lecture 1: Name Range
01:41
Lecture 2: Creating Name Range
05:52
Microsoft Excel for Everyone
Previous
Next
0% Complete