Macros: the Excel version of having minions!
Excel Explained
Macros: the Excel version of having minions!
0:47
Macros: the Excel version of having minions!
Excel Explained
Macros: the Excel version of having minions!
10:19
Manual Input, Automatic Ranking - Excel VBA in action!
Excel Explained
Manual Input, Automatic Ranking - Excel VBA in action!
6:35
Combine rows from multiple sheets into 1 tidy list. No copy-paste needed!
Excel Explained
Combine rows from multiple sheets into 1 tidy list. No copy-paste needed!
1:24
Tracking Leaves in Excel
Excel Explained
Tracking Leaves in Excel
1:28
Create a new worksheet in Excel with just one click
Excel Explained
Create a new worksheet in Excel with just one click
1:28
Convert numbers to letters in Excel with ease!
Excel Explained
Convert numbers to letters in Excel with ease!
1:23
Excel SWITCH function
Excel Explained
Excel SWITCH function
1:28
One Click, Many Reports. The Magic of Filter Pages!
Excel Explained
One Click, Many Reports. The Magic of Filter Pages!
0:53
How to prevent duplicate entries in Excel.
Excel Explained
How to prevent duplicate entries in Excel.
1:04
How to restrict cells with error handling.
Excel Explained
How to restrict cells with error handling.
1:28
How to restrict cells in Excel to accept only phone numbers.
Excel Explained
How to restrict cells in Excel to accept only phone numbers.
1:21
Update the dates on your Annual templates with just a few easy steps!
Excel Explained
Update the dates on your Annual templates with just a few easy steps!
1:23
Reset you Annual templates in just a few seconds!
Excel Explained
Reset you Annual templates in just a few seconds!
0:45
Sum all sheets with 1 easy step!
Excel Explained
Sum all sheets with 1 easy step!
0:43
Happy Father's day!!!
Excel Explained
Happy Father's day!!!
0:49
Creating Inventory Costing and Product Listing from scratch. Final part.
Excel Explained
Creating Inventory Costing and Product Listing from scratch. Final part.
1:26
Creating Inventory Costing and Product Listing from scratch, part 4. (Pricing)
Excel Explained
Creating Inventory Costing and Product Listing from scratch, part 4. (Pricing)
1:22
Creating Inventory Costing and Product Listing from scratch, part 3. (Costing)
Excel Explained
Creating Inventory Costing and Product Listing from scratch, part 3. (Costing)
1:20
Creating Inventory Costing and Product Listing from scratch, part 2.
Excel Explained
Creating Inventory Costing and Product Listing from scratch, part 2.
1:05
Creating Inventory Costing and Product Listing from scratch, part 1.
Excel Explained
Creating Inventory Costing and Product Listing from scratch, part 1.
1:26
Costing and Product Listing Template. Ideal for Milk Tea or Coffee shop businesses.
Excel Explained
Costing and Product Listing Template. Ideal for Milk Tea or Coffee shop businesses.
1:07
Learn how to use XLOOKUP in 30 seconds. #excel #xlookup
Excel Explained
Learn how to use XLOOKUP in 30 seconds. #excel #xlookup
0:40
Learn how to use VLOOKUP in 30 seconds.
Excel Explained
Learn how to use VLOOKUP in 30 seconds.
0:40
Stop copying your formula.
Excel Explained
Stop copying your formula.
0:53
How to change the case of your text in 1 easy step.
Excel Explained
How to change the case of your text in 1 easy step.
1:09
How to combine the names on a list according to their group.
Excel Explained
How to combine the names on a list according to their group.
1:28
How to extract text using MID and LEN functions.
Excel Explained
How to extract text using MID and LEN functions.
1:27
How to extract text using TEXTSPLIT.
Excel Explained
How to extract text using TEXTSPLIT.
1:05
How to extract specific text using TEXTBEFORE and TEXTAFTER functions
Excel Explained
How to extract specific text using TEXTBEFORE and TEXTAFTER functions
1:26
Post to FB Groups with just 1 click.
Excel Explained
Post to FB Groups with just 1 click.
1:28
How to create a dynamic text string using the FILTER and TEXTJOIN functions.
Excel Explained
How to create a dynamic text string using the FILTER and TEXTJOIN functions.
1:28
How to get the total sales or amount using the FILTER function.
Excel Explained
How to get the total sales or amount using the FILTER function.
1:19
FILTER function with multiple criteria and conditions.
Excel Explained
FILTER function with multiple criteria and conditions.
1:09
How to add multiple criteria in the FILTER function.
Excel Explained
How to add multiple criteria in the FILTER function.
1:29
How to extract times from a text string using VBA.
Excel Explained
How to extract times from a text string using VBA.
1:11
How to extract times from a text string using SEARCH and MID functions.
Excel Explained
How to extract times from a text string using SEARCH and MID functions.
1:05
How to filter your table to include only the list with numerical values.
Excel Explained
How to filter your table to include only the list with numerical values.
1:03
How to create a voting form using Google Forms
Excel Explained
How to create a voting form using Google Forms
1:31
Dynamic schedule template with Gantt chart.
Excel Explained
Dynamic schedule template with Gantt chart.
1:12
How to automatically add numbers and borders in Excel. #excel #excel #excelforbeginners #exceltips
Excel Explained
How to automatically add numbers and borders in Excel. #excel #excel #excelforbeginners #exceltips
1:30
3 quick ways to get data from the web.
Excel Explained
3 quick ways to get data from the web.
1:30
Dynamic Time Interval list
Excel Explained
Dynamic Time Interval list
1:30
How DATEVALUE works and how to counter-check errors in formulas.
Excel Explained
How DATEVALUE works and how to counter-check errors in formulas.
7:01
How to compute Holiday hours and pay.
Excel Explained
How to compute Holiday hours and pay.
1:23
How to compute Restday Overtime
Excel Explained
How to compute Restday Overtime
1:30
How to compute work hours in Excel (with overnight computation)
Excel Explained
How to compute work hours in Excel (with overnight computation)
1:13
How to convert pictures into Excel data in 2 easy ways.
Excel Explained
How to convert pictures into Excel data in 2 easy ways.
2:22
Simple DTR
Excel Explained
Simple DTR
2:17
Use this Excel function to create a calendar or group your data per week.
Excel Explained
Use this Excel function to create a calendar or group your data per week.
8:28
DATE and TIME functions
Excel Explained
DATE and TIME functions
6:39
EOMONTH
Excel Explained
EOMONTH
5:38
Now and Today Functions
Excel Explained
Now and Today Functions
9:16
How to use Excel Solver.
Excel Explained
How to use Excel Solver.
5:13
How to use SUBTOTAL in Excel
Excel Explained
How to use SUBTOTAL in Excel
5:44
Excel joke of the day. #excelexplained #exceltech #excelformula #exceltips #jokes #excel #capcut
Excel Explained
Excel joke of the day. #excelexplained #exceltech #excelformula #exceltips #jokes #excel #capcut
0:16
Why is Excel hated by many? #excelexplained #excelformula #exceltips #jokes #fypシ゚ #capcut
Excel Explained
Why is Excel hated by many? #excelexplained #excelformula #exceltips #jokes #fypシ゚ #capcut
0:16
How to use SUMPRODUCT.
Excel Explained
How to use SUMPRODUCT.
7:09
Nested functions and How to Manage Complex Formulas.
Excel Explained
Nested functions and How to Manage Complex Formulas.
19:02
AVERAGE, AVERAGEIF and AVERAGEIFS functions in Excel
Excel Explained
AVERAGE, AVERAGEIF and AVERAGEIFS functions in Excel
8:43
SUM, SUMIF and SUMIFS.
Excel Explained
SUM, SUMIF and SUMIFS.
5:15
How to draw lots or raffle using Excel RANDARRAY
Excel Explained
How to draw lots or raffle using Excel RANDARRAY
1:10
Index Match
Excel Explained
Index Match
8:04
How to use xlookup and double xlookup
Excel Explained
How to use xlookup and double xlookup
14:11
HLOOKUP
Excel Explained
HLOOKUP
6:59
Freeze Top Row and Left column at the same time.
Excel Explained
Freeze Top Row and Left column at the same time.
0:42
VLOOKUP
Excel Explained
VLOOKUP
1:17
How to use VLOOKUP
Excel Explained
How to use VLOOKUP
3:25
Automatic Border in Excel
Excel Explained
Automatic Border in Excel
1:29
Advanced IF Function
Excel Explained
Advanced IF Function
13:39
How IF Function works (Basic)
Excel Explained
How IF Function works (Basic)
5:15
Types of references in Excel
Excel Explained
Types of references in Excel
6:41
Loan Amortization Calculator with auto computation of adjusted monthly dues
Excel Explained
Loan Amortization Calculator with auto computation of adjusted monthly dues
0:25