Last month, we used conditional formatting to highlight holidays in a matrix-style calendar; we added this enhancement to an earlier article that used conditional formatting to highlight weekends. By ...

Excel is a very handy tool for working with data. It has many built-in features, like conditional formatting, which helps you to format and highlight data based on certain rules. The rules can be ...

Have you ever stared at a massive spreadsheet, feeling overwhelmed by rows and columns of data that all seem to blur together? You’re not alone. Whether you’re tracking project deadlines, analyzing ...

As you create Excel spreadsheets for your small business, time and date functions frequently add both convenience and programming capability to your workbooks. There's good news with date functions.

Excel is one of the most popular Office applications, if the email I receive from readers is any indication. This month, two Excel users asked for guidance using two of Excel's most popular features - ...

Understanding Excel’s conditional formatting rules can help prevent unintended results Your email has been sent Avoid frustration and unintended formatting by learning how Excel applies conditional ...

Have you ever found yourself endlessly dragging that little Excel fill handle, trying to populate rows or columns with numbers, dates, or formulas? It’s tedious, time-consuming, and let’s be ...

There are two kinds of Microsoft Excel users in the world: Those who make neat little tables, and those who amaze their colleagues with sophisticated charts, data analysis, and seemingly magical ...

Excel functions, or formulas, lie at the heart of the application’s deep well of capabilities. Today we’ll tackle IF statements, a string of commands that determine whether a condition is met or not.

This week's tutorial covers a number functions in Google's Spreadsheet app, Google Sheets. Here we take a practical look at using weekdays in calculations, introduce "if" statements and learn how to ...