Isolating values in an Excel 2007/2010 worksheet or workbook is common in both error-checking and data analysis tasks. While appropriate even for a small worksheet, the functions that isolate a value ...

Entering fractions in Microsoft Excel isn’t exactly intuitive, but it is easy. Learn how to enter and display fractions as either fractions or as decimal values. Fractions are enough to make you cry ...

In Microsoft Excel, learn how to report time values by the hour using the underlying date serial value. Grouping records by dates or time is easy in Microsoft Excel, but it doesn’t make a great report ...

Spreadsheet software is supposed to make life easier, not torture you with endless hours of data entry. Before you curse Excel and wish that you were working back in the good old days of paper ledgers ...