Cloud Computing | Excel Semi-Pro

Cloud Computing

View Excel Spreadsheets with the Google Docs Viewer

March 7, 2011 Beginner

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 […]

Get the full story …

Convert Coordinates for Your GPS with Excel

March 1, 2011 Beginner

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 […]

Get the full story …

What Day of the Year is It?

January 14, 2011 Formulas

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 […]

Get the full story …

Microsoft Office 2011 Document Connection

December 3, 2010 Intermediate

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 […]

Get the full story …

Equation Editors in Excel 2010 and Word 2011

December 1, 2010 Features

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 […]

Get the full story …

Excel 2011 for Mac – Installation, Preferences, and VBA

November 2, 2010 Product Review
Thumbnail image for Excel 2011 for Mac – Installation, Preferences, and VBA

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 […]

Get the full story …

A New Charts Editor – Google Docs Keeps Improving

October 28, 2010 Product Review
Thumbnail image for A New Charts Editor – Google Docs Keeps Improving

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 […]

Get the full story …

Stock Price Formula in a Spreadsheet

September 7, 2010 Formulas
Thumbnail image for Stock Price Formula in a Spreadsheet

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 […]

Get the full story …

Excel Files on the iPad or iPhone

July 25, 2010 General Update
Thumbnail image for Excel Files on the iPad or iPhone

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 […]

Get the full story …

Excel on the Web – Another Spreadsheet in the Cloud

June 30, 2010 General Update
Thumbnail image for Excel on the Web – Another Spreadsheet in the Cloud

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. […]

Related Posts Plugin for WordPress, Blogger...
Get the full story …