AlchemyJ

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

SUMIF Function is useful when you have a long list of specified cells you wish to find the total sum. I have created an Excel of Wallmart...

Learn how to use the AND Function in Excel to decide which Stocks (Tesla, Facebook, Alibaba and Amazon) and Cryptocurrencies (Bitcoin,...

How to use and what is an IF Function? An IF function "Checks whether a condition is met, and returns one value if TRUE, and another...

A COUNTIFS function "Counts the number of cells specified by a given set of conditions of criteria". As for today's tutorial, we will...

A COUNTIF function “counts the number of cells within a range that meet the given condition”. The COUNTIF function can count both texts...

How to use the Count Function in Excel? I have created an Excel sample template of the IQ test result of the participants for this...

How to use the Concatenate Function in Excel? There are 2 methods of doing it. If you are using Excel 2013 or 2016, there is only...

I'll teach you how to calculate average in Excel. This function enables you to calculate the average value of any set of numbers.

There are 2 ways of using Sum Function in Excel. 1) You can add values individually. 2) You can add values in ranges. Let me show you how...

Are you part of the Amazon Ecosystem that use their product or services daily and was thinking to join Amazon to improve their Web...

Microsoft Excel can execute both straightforward and sophisticated mathematical equations and functions. The basic function includes data...

Being a good programmer is not just about writing error-free codes. Other intangible traits defer an good programmer to other average...