excel tip
Master the Excel IF Function
3:30AM Gina Trapani | The spreadsheet formula experts at the Productivity Portfolio blog offer an introduction to Excel’s crazy-useful IF function. In short, IF sets the contents of a spreadsheet cell conditionally, based on a test. A formula like =IF(A1>90, "A", "Less than an A") would set the cell to equal A if A1’s value was greater than 90, and Less than an A if A1’s value was 90 or lower. This works in all modern spreadsheet proggies, not just Excel—including Google Spreadsheets. If you haven’t used IF, go check out the tutorial which has an example sheet to download and try it yourself. Excel IF Function Tutorial [Productivity Portfolio] More »
Create an Excel Gantt Chart with Conditional Formatting
1:00PM Gina Trapani | Software engineer Chandoo shares some Excel conditional formatting tricks that make for good-looking and useful spreadsheets, like a Gantt chart. Conditional formatting makes a cell look a certain way based on its contents. A Gantt chart maps out deadlines within a project. Chandoo’s Excel Gantt chart combines a calendar and to-do list to display what has to be completed when in a good-looking table layout. If you don’t want to set up the sheet yourself, download an Excel Gantt chart template here. Here’s more on using conditional formatting in your spreadsheets. More »
