SUBSCRIBE so you don't miss my next videos
COUNT COUNTA COUNTIF COUNTIFS SUMIF SUMIFS SUBTOTAL
• COUNT COUNTA COUNTIF C...
Format Cells Date, TEXT(), SUM(), MAX(), MIN(), AVERAGE(), MEDIAN(), MODE(), ROUND(), Copy Paste Transpose
• Format Hari, TEXT(), S...
Conditional Formatting, Filter Formulas, Data Validation, Wingdings, Webdings
• Conditional Formatting...
CONCATENATE, CONCAT, TEXT TO COLUMNS, SUBSTITUTE, RANK EQ, Basic Math, Overtime Pay, DATEDIF
• CONCATENATE, CONCAT, T...
GMETRIX FULL TRAINING EXCEL EXPERT 365 MO-211
• GMETRIX FULL TRAINING ...
Use of Format Cells (Number, Alignment, Font, Border, Fill, Protection)
• Penggunaan Format Cell...
Wrap Text, Merge Cells, Insert Rows, Delete Blank Rows, Diagonal Lines, Remove Duplicates
• Wrap Text, Merge Cells...
DATA ENTRY (NO CODING). Menu Data Validation and Developer (Macro). Part 2
• DATA ENTRY (NO CODING)...
DATA ENTRY (NO CODING). Menu Data Validation and Developer (Macro). Part 1
• DATA ENTRY (NO CODING)...
HOW TO USE IF FUNCTION FORMULA. =IF(), =IF(AND()), =IF(OR()), =IF(OR(AND())). (Part 2)
• CARA MENGGUNAKAN FUNGS...
HOW TO USE THE IF FUNCTION WITH 1 CONDITION, 2 CONDITIONS, 3 CONDITIONS (Part 1)
• CARA MENGGUNAKAN FUNGS...
FORMULA FUNCTIONS : EDATE, DATEDIF, DAYS & HOW TO CALCULATE OVERTIME PAY
• FUNGSI RUMUS : EDATE, ...
Formula Functions: XLOOKUP, HLOOKUP, VLOOKUP FALSE, VLOOKUP TRUE
The XLOOKUP function displays values in a result range based on the position of matches found in the search range
• Fungsi Formula : XLOOK...
EASY WAY TO CONNECT TABLE CONTENTS WITH THE FORMULA =SWITCH()
• CARA MUDAH MENGHUBUNGK...
Formula Function: TRIM, UPPER, LOWER, PROPER, LEN
• Fungsi Rumus : TRIM, U...
A QUICK & NEAT WAY TO MAKE A POINT ( : ) IN COLUMNS & ROWS
• CARA CEPAT & RAPI MEMB...
COMPANY ENTRANCE TEST QUESTIONS & ANSWERS (PART 4). IF + AND + VLOOKUP
• SOAL & JAWABAN TES BUM...
COMPANY ENTRANCE TEST QUESTIONS & ANSWERS (PART 3) VLOOKUP + LEFT, HLOOKUP + MID, DATEVALUE, VLOOKUP + IF
• SOAL & JAWABAN TES BUM...
COMPANY ENTRANCE TEST QUESTIONS & ANSWERS (PART 2). VLOOKUP+LEFT, MID, IF+VLOOKUP, DATEDIF, SUMIF
• SOAL & JAWABAN TES BUM...
COMPANY ENTRANCE TEST QUESTIONS & ANSWERS (PART 1). VLOOKUP + LEFT, RIGHT, MID, IF(OR)
• HOW TO PASS EXCEL JOB ...
How to Download, Install & Create Barcode / IDAutomation In Excel • DOWNLOAD, INSTALL & CR...
bit.ly/IDAutomation
TUTORIAL FOR CREATING AN AUTOMATIC SYNCHRONIZED ITEM RECAP IN EXCEL
• TUTORIAL MEMBUAT REKAP... bit.ly/IDAutomation
4 Tricks for Setting Row & Column Sizes in Excel
• 4 Trik Mengatur Ukuran...
How to make a simple invoice/receipt/shopping receipt
• HOW TO CREATE INVOICE/...
Excel Tricks How to insert a blank row in each cell
• Excel Tricks How to in...
8 Tricks for Making Sequential Numbers in Ms. Excel 2021 / 365
• 8 TRICKS TO CREATE SEQ...
GMetrix Excel Expert 365 MOS - 211 :
1. Practice Exam 1 Training
• GMetrix Practice Exam ...
2. Practice Exam 2 Training
• GMetrix Practice Exam ...
3. Practice Exam 3 Training
• GMetrix Practice Exam ...
4. Skill Review 1 Training
• GMetrix Skill Review 1...
5. Skill Review 2 Training
• GMetrix Skill Review 2...
I will upload the next learning video. Please wait for my next video. Thank you for watching my videos.
Like, Subscribe, Comment, Share All my videos @EvaWahyuni-Learn-IT
#exceltricks #excel #exceltutorial #excel365 #excelfunctions #exceltips #excelformula #vlookup #hlookup #videoyoutube #microsoft #microsoftexcel #informationtechnology #microsoftoffice365 #microsoftoffice #ifformula #iffunction #rumusif #database #data #dataentry #datavalidation #office365 #excelbasics #formatcells #excelexpert #excelbeginners #count #counta #countif #countifs #sumif #sumifs #subtotal