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 Excel files to people who have a Gmail or Google Docs account and they will be able to view your spreadsheet information. Not the greatest view of a spreadsheet file, but it’s better than nothing.
In the Google Docs Viewer you have the option … Read the rest
A few years ago I found myself just south of Paris, France one Sunday with a car and the inclination to do some sight-seeing. Since I was alone and don’t speak French my saving grace was Google Earth and a Tom Tom GPS navigation device.
Tom Tom allows GPS coordinates to be entered as a destination, but Google Earth lists those coordinates in a different format. In researching this article I found out that GPS coordinates can be presented in at least four different formats, making it difficult to understand the coordinates.
Google Maps view of the Eiffel
… Read the rest
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 worksheet.
The Day of Year Formula
The formula in cell B2 is:
The DATE Function takes the Year from the Date you type in cell A2, and uses the zero (0) day of month 1 (January), which is the last day … Read the rest
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 or Edit mode.
In Preferences I set all my files to open in Edit mode so that when I double click on a file, Excel 2011 downloads, then opens the file so I can make changes.
Once changes are saved the file uploads … Read the rest
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 briefly compare Mathematical Equations in Google Docs, and come back to the Word 2011 version of Equation Editor.
Excel 2010 Equation Editor
The Equation Editor in Excel 2010 is difficult to navigate at first. The second time I tried creating an equation it got … Read the rest
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 paid $174.99 USD for the Microsoft Office for Mac Home and Business 2011 – 1 Pack edition on amazon.com after pre-ordering and receiving a $25 discount from their price assurance guarantee.
Excel 2011 Software Installation
What you get with the Office 2011 Home and Business … Read the rest
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 it’s free. Hence, a new generation of people that may grow up without Excel.
There’s a short video on the Google Docs Blog about the new Charts Editor in Google Docs. They also show a few screen shots of some, but not all of the … Read the rest
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 is left blank, price is returned by default. Both arguments are to be enclosed in quotes.
A list of common attributes — high, low, volume, marketcap, etc. — can be found here, just click on the link: View a list of common attributes… Read the rest
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 that matter.
I have an Excel file in Dropbox that serves as a reference and is password protected. Docs To Go® Premium opens this file and is the reason I purchased it.
The app has 111 functions and while this seems like a lot, one … Read the rest
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. It’s relatively easy to sign up for an account and you get 25 GB of storage on a Sky Drive. You also get access to the rest of the Office Web Apps: Word, PowerPoint and OneNote.
Excel Web App vs Google Docs Spreadsheet
The … Read the rest