Text Functions
If you want to convert numbers to text or simple text manipulation in your worksheet, Excel has many text functions that you can use. Like for example, you can easily convert a date in number into a text date format. Here …
msfreetuts Archive
Date and Time Functions
Date and time are very important in Excel project, like in making a timesheet, you need to get the elapsed time to compute the total number of regular hours and overtime. In this lesson you will learn some basic date …
Cell Reference
A worksheet also known as the spreadsheet is composed of a box-like structure called a cell. Every cell has an address location called cell reference. A cell reference consists of a column letter and row number (e.g. A1, D63, F120), this …
Logical Functions
One of the best thing in Excel is to compare data in different cells, using logical functions you can easily compare each cell that you want to compare and get the output that you need. In this lesson you will …
Count and Sum Functions
Count and Sum are one of the most used functions in Excel. You can easily count or sum the content of the worksheet based on one or multiple criteria. There are 6 functions included in count and sum (Count, Countif, Countifs, …