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 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 Vlookup function in Excel2020/11/6Functions Lookup & ReferenceThe VLOOKUP function is one of the most popular functions in Excel.
How to use Two-way Lookup in Excel2020/11/6Functions Lookup & ReferenceThis example teaches you how to lookup a value in a two-dimensional range.
How to use Today's Date in Excel2020/11/6Functions Date & TimeTo enter today’s date in Excel, use the TODAY function. To enter the current date and time, use the NOW function.
How to use Time Sheet in Excel2020/11/6FunctionsThis example teaches you how to create a simple timesheet calculator in Excel.
How to use Time Difference in Excel2020/11/6Functions Date & TimeCalculating the difference between two times in Excel can be tricky.
How to use Text to Columns in Excel2020/11/6Functions TextTo separate the contents of one Excel cell into separate columns, you can use the ‘Convert Text to Columns Wizard’.
How to use Text Function in Excel2020/11/6Functions TextWhen joining text and a number, use the TEXT function in Excel to format that number.
How to use Tax Rates in Excel2020/11/6Functions Lookup & ReferenceThis example teaches you how to calculate the tax on an income using the VLOOKUP function in Excel.