A look at nested IF statements and alternatives that are easier to make and understand later. by David Goodmanson In my last article I looked at a simple Excel IF statement plus their useful cousins CountIf and SumIF. I also touched on the nested IF statement, where there are many IF functions in one cell. […]
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 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 […]
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 […]
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 […]