To calculate a weighted average in Excel, simply use the SUMPRODUCT and the SUM function.
Learn 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.
The VLOOKUP function is one of the most popular functions in Excel.
This example teaches you how to lookup a value in a two-dimensional range.
To enter today’s date in Excel, use the TODAY function. To enter the current date and time, use the NOW function.
This example teaches you how to create a simple timesheet calculator in Excel.
Calculating the difference between two times in Excel can be tricky.
To separate the contents of one Excel cell into separate columns, you can use the ‘Convert Text to Columns Wizard’.
When joining text and a number, use the TEXT function in Excel to format that number.
This example teaches you how to calculate the tax on an income using the VLOOKUP function in Excel.