00:00 Start
01:10 General Replay and downloading the sample file - www.vidoport.com/egitim.xlsx
03:20 Remove duplicate values
06:00 Count Spaces-Count Spaces Function
07:00 Using the COUNTIF Formula
13:30 Using the COUNTIF Formula
15:00 Using the COUNTIF Function in Reporting
20:10 Using the SUMIF function
30:30 Using the textual functions
32:30 Using the UPPER, LOWER CASE, PROTECTION functions
34:00 LEFT, RIGHT, PARTIAL Functions
37:10 Using the TRIM function
41:00 Separating Dates and Times
44:00 Using the IF Function
52:30 Combining Date and Time with TEXT
54:00 Q&A
Негізгі бет Excel Learning Lessons - Lesson 4, COUNTIF, SUMIF, IF Functions - 708 | Omer BAGCI
Пікірлер: 128