Excel tutorial on 4 ways to join cells in Excel. We’ll look at how to use ampersand (&) in Excel, then CONCATENATE, followed by the CONCAT function and, lastly, the TEXTJOIN function. Ampersand and CONCATENATE are both used in Excel to combine contents cells and are pretty much interchangeable. & is a calculation operator (kind of […]
Functions / Formulas
How to Find Cells Used in Formulas in Excel – Tutorial
Excel tutorial on how to find cells used in formulas in Excel using Trace Precedents and Trace Dependents. Sometimes spreadsheets end up with sooo many numbers and formulas that it can be confusing figuring out which formulas are affected by which cells. Using an example, we’ll go over how to use the Trace Precedents and […]
How to use the HLOOKUP Function in Excel – Tutorial
Excel tutorial on how to use the HLOOKUP function in Excel. HLOOKUP allows you to look up data in a horizontal orientation.
How to Use the IF Function in Excel – Tutorial
Excel tutorial on how to use the IF function in Excel spreadsheets. Examples walk you through how to write if-then formula statements in Excel. What is the Excel IF function? The IF function is an if-then formula with conditions that trigger a result. For example, if the conditions in the formula are met, then the […]
How to Use the Payment Function in Excel – Tutorial
Excel tutorial on how to use the payment function to calculate loan payment amount in Excel. What is the payment function in Excel? PMT, the Payment formula, is used to calculate loan payments. Examples of when you could use the PMT formula: You can use the payment formula to calculate a car payment or to […]
Generate Random Numbers Using RAND + RANDBETWEEN functions in Excel – Tutorial
Excel tutorial on how to generate random numbers in Excel. We’ll look at 2 ways of creating random numbers. We’ll look at how to use the RANDBETWEEN function and how to use the RAND function to do this. What is the RANDBETWEEN function in Excel? Use the RANDBETWEEN formula to generate random numbers in Excel […]