AlchemyJ

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...

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...

For today’s Excel tutorial, You will be learning the TEXTJOIN Function. Similar to the concatenate function, TEXTJOIN join strings from...

For today’s Excel tutorial, I will be showing you how to use the NUMBERVALUE Function. The NUMBERVALUE Function converts a text value to...

For today’s Excel tutorial, I will be showing you an important function called MOD. The MOD function returns the remainder after a number...

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...

Today we will be learning the SUBSTITUTE Function. The function replaces existing text with new text in a text string. In our excel...

Today we will be learning the TRIM Function. The function removes all spaces from a text string except single spaces between words. In...

Today we will be learning the LEN Function. The function returns the number of characters in a text string. In other words, the function...

Today we will be learning a simple and helpful String Function. The Left, Right and Mid Functions. These functions enable us to select...

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...

For today's tutorial, we will be calculating the total cost of Espresso, Milk, Sugar for our café. We will be using the SUMPRODUCT...

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...

How to use the Standard Deviation Function in Excel to calculate the riskiness and the minimum needed return on an investment you wish to...

We will be using the NETWORKDAYS Function for our Waterfall Web Development Process timeline example to calculate the number of workdays....

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...

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...

Index and Match Function is an alternative method from VLOOKUP. For this tutorial, I have created an Excel Sheet of Steve's Laptop Store...

For this tutorial, I have created an Investment Portfolio with some popular Stocks and Cryptocurrencies. These include Tesla, Facebook,...

For this tutorial, I have created an Excel Sheet of Wallmart's Cost of Inventory Replenishment. These Fast-moving consumer goods include...