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.
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
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
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
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
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
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
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,
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
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
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
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
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
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
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’
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
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
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
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
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
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
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
It’s a simple question about ordering monthly data in Word – there’s many answers which give a glimpse into what you can do with Office. ” I want to have a monthly log of items, each month separated by a page or section break, but be able to “toggle” the
Microsoft has released a series of updated help files for Office 2007 programs. Microsoft has released a series of updated help files for Office 2007 programs. Each program has a separate download. In most cases the download includes updates for both the main user help file and the developers help
