If you have a Gmail or Google Docs account, getting a quick look at a Microsoft Excel file is now supported with the Google Docs Viewer. Just click the View link beside the file name in your email and the Google Docs Viewer will open to give you a quick look. Now you can send …
Given the Date in this spreadsheet, a simple formula using the DATE Function will return the Day of Year. Go ahead and type a Date value in cell A2 to see how the formula works, the spreadsheet is embedded from my SkyDrive. (Date format is US, “m/d/yyyy”) Click here if you can’t see the embedded …
One of the neat programs you get with Microsoft Office 2011 is Microsoft Document Connection. It allows you to interface with your SkyDrive without going through a web browser. Once you open the program and sign in to your SkyDrive account all your online files are accessible. You can open the files in Read Only …
The Equation Editor is new in Excel 2010 and designed to create a mathematical equation as a graphical object. I didn’t find it in Excel 2011 for Mac, but ran across an article showing they put it inside Word 2011. How very strange. Here I’ll review the Excel 2010 version of Equation Editor first, then …
After reading all the great things about Microsoft Excel for Mac 2011 that were written before its release, I decided to purchase a copy. My primary goal was to have an Excel version on my MacBook Pro that allowed VBA macros, however the full Office software suite seemed to be a really great value. I …
Tuesday Google announced a New Charts Editor in Google Docs. This is important because Google continues to improve it’s spreadsheet offering in the cloud. And while in my opinion, Excel will always be the king of spreadsheets, Microsoft has to be aware that many younger people may very well use spreadsheets in Google Docs because …
Sadly, Excel doesn’t have a stock price formula, but Google Docs has just the thing: a GoogleFinance Function. It updates a stock price when you open a Google Docs spreadsheet. The GoogleFinance Function has two arguments, symbol and attribute. The symbol argument represents the stock symbol for company or mutual fund. If the attribute argument …
Documents To Go® Premium lets me open and modify Excel files from my Dropbox folder right on my iPad or iPhone. I can also access and modify spreadsheets from my Google Docs account. Excel email attachments can be downloaded, viewed and edited. This is a big plus when traveling with the iPad, or iPhone for …
I decided to test the new Microsoft Excel Web App and tell you about my experience in creating a simple spreadsheet, give you a look at the interface, and share my initial opinion. The Excel Web App – Getting Started In order to use the Microsoft Excel Web App a Windows Live account is required. …