Excel 2007 Service Pack 2 – the official fix list
Official fix list for Excel 2007 SP2 both the summary and the complete listHere’s the official fix list for Excel 2007 SP2 both the summary and the complete list. We’ve published it here for easy reference instead of hunting around Microsoft’s web site and an Excel worksheet. This list does NOT include details of past […]
Printing a selection in Office
A trick for quickly printing part of a document, worksheet or slides plus when it does NOT work. Sometimes you just want to print part of a document, maybe a few paragraphs or many pages. One option available is to print the current selection. The basics are simple. In Word, select any block of text […]
Bring Twitter searches into Excel
How to import any Twitter search into an Excel worksheet and update it automatically In our article Using Excel (the real one) to read Twitter we talked about importing your incoming and sent tweets into an Excel worksheet. You can do this to disguise Twittering from your boss however there can be good reasons for […]
Excel’s IF function
IF statement and some variatons – nested IF, CountIF and SumIF. by David Goodmanson IF a picture paints a thousand words, then how many words have 5 characters or more? The answer? Use the IF function. The IF function is a simple and easy-to-use function that can be widely applied in the design of your […]
MS Office updates for April 2009
Details on Word & Excel updates from Office 2000 onwards plus Office for Mac. The usual security updates for Microsoft products this month include updates for Word and Excel from Office 2000 to Office 2007 plus Office for Mac. Security holes in Word’s text converter and Excel headline this month’s patches plus some for our […]
Match and Index lookup in Excel
Let’s have some INDEX() and MATCH() fun in our Lookup function series. by David Goodmanson On their own, the INDEX() and MATCH() functions are fairly straightforward but when they are combined they create a very powerful Lookup tool. Both functions have 3 parts to their arguments. INDEX(range, row_number, column_number) and MATCH(lookup_value, range, match_type) Let’s use […]
Fitting a Word or Excel doc to your printer
How to print a document when the paper sizes are different. On our new Twitter account we saw this question: “When I send an Excel file to someone, should I have to set it up so they can print? I don’t know the printer/size they use.” Part of that answer is preparing the document but that’s […]
Calculating with Vlookup
Using Vlookup in Excel to work out tax, fees or commission from a table by David Goodmanson In part 1 we covered the basics of VLookup, let’s use it to calculate tax for a list of employees and their salaries. We’ve chosen this practical example because it contains a fixed amount plus a marginal percentage […]
Excel 2007 exploit ‘in the wild’
An UNpatched Excel security flaw is being exploited publicly. According to Symantec, there’s an unfixed Excel security hole which makes vulnerable Excel 2007 (with or without Service Pack 1) and maybe other versions of Excel. The Trojan is a variation on Mdropper which takes advantage of a ‘Remote code Execution’ flaw in Excel. Symantec is […]
Paper sizes on another computer
How to format a Word or Excel document to print on someone else’s computer. On our new Twitter account we saw this question: ” When I send an Excel file to someone, should I have to set it up so they can print it? I don’t know the printer/size paper they use. “ It should […]
Where did my numbers go?
Office Watch explains what can happen with Show Formulas in Excel and the simple fix. A slip of the fingers can make all your numbers disappear! An Office Watch reader wrote in a panic, her vital worksheet had gone crazy showing only formulas instead of numbers! She was the victim of a misplaced keystroke which […]
Lookup from a list in Excel
Vlookup scares too many Excel users but it should not. David Goodmanson shows how easy and incredibly useful it can be. How can your grab a value from a separate Excel list and insert it into your current calculation? Vlookup or Hlookup is the main answer in Excel. We’ll show you Vlookup since it’s […]
Excel ideas – More or Less
There’s a nifty BBC program all about the abuse of numbers. Excel is about numbers and numbers can be used or abused. In the media numbers are often abused for the sake of a headline or to push a certain product or ideology. There’s a nifty BBC program all about the abuse of numbers. More […]
Many shapes in Excel 2007 can slow you down
At the very end of 2008, Microsoft finally admitted to something Excel users had long suspected … that adding a lot of shapes to a worksheet can greatly affect Excel’s performance. At the very end of 2008, Microsoft finally admitted to something Excel 2007 users had long suspected … that adding a lot of shapes […]
December 2008 security patches for Office
More security patches for lapses in Microsoft products including various versions of Office from Office 2000 to 2007 plus some incarnations of FrontPage. More security patches for lapses in Microsoft products including various versions of Office from Office 2000 to 2007 plus some incarnations of FrontPage. As usual, we’ll list the updates according to product […]
A humble submission to their Lordships
Even after two years, the Lords and Members of Parliament in the UK can’t easily open Office 2007 documents. We explain the simple options available to the honorable members. Silicon.com is reporting that the UK’s Members of Parliament and the House of Lords are having trouble opening documents that are delivered in the Office 2007 […]
