Archive for December, 2008UARC Finishes 6th in FSAEThursday, December 11th, 2008Dear UARC Supporters, Last week we left for Melbourne, to compete in the 9th Australasian Formula SAE Competition. A few extra days before the competition allowed us to prepare for our static events. The competition is split into four days, each with a specific set of events run that day. Meaning that if your vehicle is out of [...] Export MS Project Tasks to Excel and Keep IndentationWednesday, December 10th, 2008Ever wondered how to export the tasks from MS Project to Excel and not have to spend hours indenting the text in the cells just for neatness? Hide Series in Excel Charts with a Cell ClickWednesday, December 3rd, 2008When you need to plot several series on a chart (like 3 or 4 different forecasts in an S-curve) you can sometimes want to hide different series temporarily. This little trick helps do just that! Step one is to (somewhere in the workbook) define a Yes, No list. Type in “Yes” and “No” in two cells Ignoring #N/A in Excel SumsWednesday, December 3rd, 2008A quick way of ignoring the infamous #N/A in an excel sum |