Google Docs supports .docx and .xlsx
You can now upload Word and Excel 2007 files to Google’s online editor.Today Google announced that their Google Docs service will support Word 2007 .docx files and Excel 2007 .xlsx files. That saves Office 2007 users from having to ‘Save As’ to another format before uploading to Google Docs. Larger documents Google Docs has a […]
Excel 2010 – first look
A look at the ribbons and menus in the next version of Excel. A look at the ribbons and menus in the next version of Excel. We’ve already looked at Word 2010, OneNote 2010 and Outlook 2010 plus the new look Office button menu. Click on any image to see a full size version. Home […]
How to Twitter from Excel
Tweeting directly from Excel A month ago we wrote about how to import your Twitter feed into Excel and also Twitter searches into Excel. At the time we said “There’s no direct way to send tweets or direct messages – but I suspect it’s only a matter of time before someone cuts some VBA for […]
Simple monitor rotation utility
An easy way to rotate your display to portrait mode. iRotate is a simple and cross-graphics way to switch display modes. Many LCD monitors have the ability to physically rotate from the standard landscape mode to portrait orientation with the narrow side of the screen at the top. This can be a useful way to […]
A Guide to Microsoft Excel 2007 for Engineers and Scientists
From: Academic Press Completely updated guide for scientists, engineers and students who want to use Microsoft Excel 2007 to its full potential. Electronic spreadsheet analysis has become part of the everyday work of researchers in all areas of engineering and science. Microsoft Excel, as the industry standard spreadsheet, has a range of scientific functions that […]
More Office 2007 patches
Even after Service Pack 2, there are more fixes for Office 2007. Service Pack 2 has been out less than a week and already there are more fixes for Office 2007. These ‘hotfixes’ are temporary and ‘ not fully tested’ updates. Most are dated 30 April 2009 – only a few days after Service Pack […]
Excel 2007 Service Pack 2 – the official fix list
Official fix list for Excel 2007 SP2 both the summary and the complete list Here’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 […]
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 […]
