Saturday May 19, 2012
There is a group of functions in Excel called the Count Functions.
In general, this group is used to total the number of cells in a selected range. Each function, however, does a slightly different job.
The COUNT function's job is to only add up those cells that contain numbers.
It ignores empty cells or those containing text. So if you need to know how many cells contain numbers or dates in a spreadsheet the COUNT function will do the job for you.
To find out the details about using this function, read the tutorial on the Excel COUNT Function.
Other Excel Count Functions
Tuesday May 15, 2012
Another of Excel's functions that can be used to calculate the number of days between a start and end date is DATEDIF.
Not only can this function help you find the number of days between dates, it can also be used to find the number of months or years as well.
One thing however, DATEDIF is undocumented - which means you won't find it listed with other functions in Excel.
To find out the details of using this function, read this tutorial on the DATEDIF Function.
Related Excel Date Tutorials
Thursday May 10, 2012
Conditional formatting allows you to add special formatting options to specific areas of a
worksheet.
One of these options is to shade alternate rows of data in a worksheet.
Shading alternate rows makes it easier to read across long rows of
data, and while it is easy enough to do manually for a small worksheet; it can be a real chore when trying to do it for larger ones.
Using conditional formatting not only makes it easier to accomplish this task, but it is easy to modify the shaded range in case you later make changes to your worksheet.
To find out all the details, read the tutorial on
Shading Rows with Conditional Formatting in Excel.
Related Tutorials
Saturday May 5, 2012
Finding Duplicates in Excel
© Ted French
Excel's conditional formatting feature is an easy way to add special formatting features to specific areas of your
spreadsheets. Depending on the value in a
cell, you can change things like the font color of specific data or alter the background color of a cell (or cells).
The "conditional" part of the name means that you can control when and where the formatting changes are applied. If the
data meets a certain condition, then the formatting change occurs.
One common use for this feature is to find duplicate data such as duplicate names, dates, or formulas in large tables of data.
To find out all the details read the tutorial on
Find Duplicates in Excel with Conditional Formatting.
Related Tutorials
