Basic Excel Function - Wildcards Function in Excel
For today’s Excel tutorial, you will be learning the Wildcard Excel Function. In our example, we are given a table of the biggest box...
top of page
Search
terrylin9
- Oct 6, 2021
- 3 min
Basic Excel Function - How to use SEARCH Function
For today’s Excel tutorial, You will be learning the SEARCH Function. In our example, we are given a list of emails addresses. First, I...
100 views0 comments
terrylin9
- Sep 29, 2021
- 3 min
Basic 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...
87 views0 comments
celsiushb.tan
- Sep 26, 2021
- 3 min
Basic Excel Function - How to use NUMBERVALUE Function
For today’s Excel tutorial, I will be showing you how to use the NUMBERVALUE Function. The NUMBERVALUE Function converts a text value to...
79 views0 comments
terrylin9
- Sep 15, 2021
- 3 min
Basic Excel Function - How to use MOD Function in Excel
For today’s Excel tutorial, I will be showing you an important function called MOD. The MOD function returns the remainder after a number...
39 views0 comments
celsiushb.tan
- Sep 9, 2021
- 3 min
Basic Excel Function - How to use SUM Function Across Multiple Tabs
Do 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...
195 views0 comments
terrylin9
- Aug 31, 2021
- 3 min
Basic Excel Function - How to use SUBSTITUTE Function
Today we will be learning the SUBSTITUTE Function. The function replaces existing text with new text in a text string. In our excel...
48 views0 comments
terrylin9
- Aug 24, 2021
- 3 min
Basic Excel Function - How to use TRIM Function
Today we will be learning the TRIM Function. The function removes all spaces from a text string except single spaces between words. In...
41 views0 comments
terrylin9
- Aug 17, 2021
- 3 min
Basic Excel Function - How to use LEN Function
Today we will be learning the LEN Function. The function returns the number of characters in a text string. In other words, the function...
47 views0 comments
terrylin9
- Aug 10, 2021
- 3 min
Basic Excel Function - How to use LEFT, RIGHT and MID Functions
Today we will be learning a simple and helpful String Function. The Left, Right and Mid Functions. These functions enable us to select...
52 views0 comments
terrylin9
- Aug 3, 2021
- 3 min
Basic Excel Function - How to use UPPER, LOWER and PROPER Functions
We 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...
33 views0 comments
terrylin9
- Jul 28, 2021
- 3 min
Basic Excel Function - How to use SUMPRODUCT Function in Excel
For today's tutorial, we will be calculating the total cost of Espresso, Milk, Sugar for our café. We will be using the SUMPRODUCT...
51 views0 comments
celsiushb.tan
- Jul 20, 2021
- 3 min
Basic Excel Function - How to use CHOOSE Function in Excel
We will be using the CHOOSE Function for today's tutorial to determine each company we had Dollar-cost Averaging in. For the examples, we...
49 views0 comments
terrylin9
- Jul 13, 2021
- 3 min
Basic Excel Function - How to use Standard Deviation Function in Excel
How to use the Standard Deviation Function in Excel to calculate the riskiness and the minimum needed return on an investment you wish to...
50 views0 comments
celsiushb.tan
- Jul 6, 2021
- 3 min
Basic Excel Function - How to use NETWORKDAYS Function in Excel
We will be using the NETWORKDAYS Function for our Waterfall Web Development Process timeline example to calculate the number of workdays....
44 views0 comments
celsiushb.tan
- Jun 30, 2021
- 3 min
Basic Excel Function - How to use HLOOKUP Final Function in Excel
I 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...
34 views0 comments
celsiushb.tan
- Jun 23, 2021
- 3 min
Basic Excel Function - How to use VLOOKUP Function in Excel
How to use the VLOOKUP Function in Excel? For this tutorial, I have created a staff COVID-19 vaccination program and we will be using...
52 views0 comments
celsiushb.tan
- Jun 16, 2021
- 3 min
Basic Excel Function - How to use INDEX and MATCH Function in Excel
Index and Match Function is an alternative method from VLOOKUP. For this tutorial, I have created an Excel Sheet of Steve's Laptop Store...
39 views0 comments
celsiushb.tan
- Jun 8, 2021
- 3 min
Basic Excel Function - How to use IFERROR Function in Excel
For this tutorial, I have created an Investment Portfolio with some popular Stocks and Cryptocurrencies. These include Tesla, Facebook,...
71 views0 comments
celsiushb.tan
- Jun 2, 2021
- 3 min
Basic Excel Function - How to use SUMIFS Function in Excel
For this tutorial, I have created an Excel Sheet of Wallmart's Cost of Inventory Replenishment. These Fast-moving consumer goods include...
54 views0 comments
bottom of page