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 ...

Build stable, high-performance dashboards using REPT formulas and UNICHAR symbols instead of conditional formatting.

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 ...

Checkboxes in Microsoft Excel are a great tool for tracking progress, improving data organization, and adding an extra layer of automation to your spreadsheet. What's more, you can format a whole row ...

Add Yahoo as a preferred source to see more of our stories on Google. Excel holiday information Last year, I showed you a dynamic approach to using conditional formatting to highlight weekends in a ...

Microsoft Excel 2007's conditional formatting feature allows you to format cells based on certain criteria. As an example, you might want the row color to change based upon a credit or debit on a ...

Formatting every other row is easily accomplished using conditional formatting. Fortunately, conditional formatting can handle something more specific, formatting every even or odd row. Many users ...

Create a self-updating Excel checklist with checkboxes, IFS due-date priority, and a progress data bar for faster tracking.