How to use Vlookup function in Excel2020-11-6Functions Lookup & ReferenceThe VLOOKUP function is one of the most popular functions in Excel.
How to Use WEEKDAY Function in Excel2020-11-6Functions Date & TimeLearn how to get the day of the week of a date in Excel and how to get the number of weekdays or workdays days between two dates.
How to use Weighted Average in Excel2020-11-6Functions StatisticalTo calculate a weighted average in Excel, simply use the SUMPRODUCT and the SUM function.
How to use RANK Function In Excel2020-11-4Functions StatisticalThe RANK function in Excel returns the rank of a number in a list of numbers.
How to count the number of words In Excel2020-11-4FunctionsThis example describes how to count the number of words in a cell.
How to Create a Roll the Dice In Excel2020-11-4Functions LogicalThis example teaches you how to simulate the roll of two dice in Excel.
How to Generate Random Numbers In Excel2020-11-4Functions StatisticalExcel has two useful functions when it comes to generating random numbers.
How to Split a String In Excel2020-11-4Functions TextThis example teaches you how to separate strings in Excel.
How to use Calculate Quarter in Excel2020-11-4Functions Date & TimeAn easy formula that returns the quarter for a given date.
How to use Offset function In Excel2020-11-4Functions Lookup & ReferenceThe OFFSET function in Excel returns a cell or range of cells that is a specified number of rows and columns from a cell or range of cells.
How to use Or function in Excel2020-11-4Functions LogicalThe OR function in Excel returns TRUE if any of the conditions are true and returns FALSE if all conditions are false.
How to use Percent Change Formula In Excel2020-11-4Functions Cell ReferencesThe percent change formula is used very often in Excel.
How to use Percentiles and Quartiles In Excel2020-11-4Functions StatisticalThis example teaches you how to use the PERCENTILE and QUARTILE function in Excel.
How to use PMT function In Excel2020-11-4Functions FinancialThe PMT function in Excel calculates the payment for a loan based on constant payments and a constant interest rate.
How to use Search function In Excel2020-11-4Functions TextUse the SEARCH function in Excel to find the position of a substring in a string.