How to use Text to Columns in Excel

Nov 06, 2020

To separate the contents of one Excel cell into separate columns, you can use the ‘Convert Text to Columns Wizard’.

#Tutorial#How To#Functions#Text

How to use Time Difference in Excel

Calculating the difference between two times in Excel can be tricky.

#Tutorial#How To#Functions#Date & Time

How to use Time Sheet in Excel

This example teaches you how to create a simple timesheet calculator in Excel.

#Tutorial#How To#Functions

How to use Today's Date in Excel

To enter today's date in Excel, use the TODAY function. To enter the current date and time, use the NOW function.

How to use Two-way Lookup in Excel

This example teaches you how to lookup a value in a two-dimensional range.

#Tutorial#How To#Functions#Lookup & Reference

How to use Vlookup function in Excel

The VLOOKUP function is one of the most popular functions in Excel.

How to Use WEEKDAY Function in Excel

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.

How to use Weighted Average in Excel

To calculate a weighted average in Excel, simply use the SUMPRODUCT and the SUM function.

#Tutorial#How To#Functions#Statistical

How to use RANK Function In Excel

Nov 04, 2020

The RANK function in Excel returns the rank of a number in a list of numbers.

How to count the number of words In Excel

This example describes how to count the number of words in a cell.