celsiushb.tanOct 15, 20213 minBasic Excel Function - Wildcards Function in ExcelFor today’s Excel tutorial, you will be learning the Wildcard Excel Function. In our example, we are given a table of the biggest box...
terrylin9Oct 6, 20213 minBasic Excel Function - How to use SEARCH FunctionFor today’s Excel tutorial, You will be learning the SEARCH Function. In our example, we are given a list of emails addresses. First, I...
terrylin9Sep 29, 20213 minBasic Excel Function - How to use TEXTJOIN Function For today’s Excel tutorial, You will be learning the TEXTJOIN Function. Similar to the concatenate function, TEXTJOIN join strings from...
celsiushb.tanSep 26, 20213 minBasic Excel Function - How to use NUMBERVALUE FunctionFor today’s Excel tutorial, I will be showing you how to use the NUMBERVALUE Function. The NUMBERVALUE Function converts a text value to...
terrylin9Sep 15, 20213 minBasic Excel Function - How to use MOD Function in ExcelFor today’s Excel tutorial, I will be showing you an important function called MOD. The MOD function returns the remainder after a number...
celsiushb.tanSep 9, 20213 minBasic Excel Function - How to use SUM Function Across Multiple TabsDo you know that SUM Function is not limited to a single sheet and can be used across multiple tabs? In our example, we are task to sum...
terrylin9Aug 31, 20213 minBasic Excel Function - How to use SUBSTITUTE FunctionToday we will be learning the SUBSTITUTE Function. The function replaces existing text with new text in a text string. In our excel...
terrylin9Aug 24, 20213 minBasic Excel Function - How to use TRIM FunctionToday we will be learning the TRIM Function. The function removes all spaces from a text string except single spaces between words. In...
terrylin9Aug 17, 20213 minBasic Excel Function - How to use LEN FunctionToday we will be learning the LEN Function. The function returns the number of characters in a text string. In other words, the function...
terrylin9Aug 10, 20213 minBasic Excel Function - How to use LEFT, RIGHT and MID FunctionsToday we will be learning a simple and helpful String Function. The Left, Right and Mid Functions. These functions enable us to select...
terrylin9Aug 3, 20213 minBasic Excel Function - How to use UPPER, LOWER and PROPER FunctionsWe will learn how to change to case of value in your Excel spreadsheet to UPPER, LOWER and PROPER Cases for today's tutorial. We will be...
terrylin9Jul 28, 20213 minBasic Excel Function - How to use SUMPRODUCT Function in ExcelFor today's tutorial, we will be calculating the total cost of Espresso, Milk, Sugar for our café. We will be using the SUMPRODUCT...
celsiushb.tanJul 20, 20213 minBasic Excel Function - How to use CHOOSE Function in ExcelWe will be using the CHOOSE Function for today's tutorial to determine each company we had Dollar-cost Averaging in. For the examples, we...
terrylin9Jul 13, 20213 minBasic Excel Function - How to use Standard Deviation Function in ExcelHow to use the Standard Deviation Function in Excel to calculate the riskiness and the minimum needed return on an investment you wish to...
celsiushb.tanJul 6, 20213 minBasic Excel Function - How to use NETWORKDAYS Function in ExcelWe will be using the NETWORKDAYS Function for our Waterfall Web Development Process timeline example to calculate the number of workdays....
celsiushb.tanJun 30, 20213 minBasic Excel Function - How to use HLOOKUP Final Function in ExcelI have created a staff COVID-19 vaccination program, and we will be using HLOOKUP to find out which staff is vaccinated. We will be using...
celsiushb.tanJun 23, 20213 minBasic Excel Function - How to use VLOOKUP Function in ExcelHow to use the VLOOKUP Function in Excel? For this tutorial, I have created a staff COVID-19 vaccination program and we will be using...
celsiushb.tanJun 16, 20213 minBasic Excel Function - How to use INDEX and MATCH Function in ExcelIndex and Match Function is an alternative method from VLOOKUP. For this tutorial, I have created an Excel Sheet of Steve's Laptop Store...
celsiushb.tanJun 8, 20213 minBasic Excel Function - How to use IFERROR Function in ExcelFor this tutorial, I have created an Investment Portfolio with some popular Stocks and Cryptocurrencies. These include Tesla, Facebook,...
celsiushb.tanJun 2, 20213 minBasic Excel Function - How to use SUMIFS Function in ExcelFor this tutorial, I have created an Excel Sheet of Wallmart's Cost of Inventory Replenishment. These Fast-moving consumer goods include...