Product Review

Break Even Calculation with an Unlocked iPhone and International Rates

April 23, 2012 Formulas

I just upgraded my wife to a new iPhone 4S and since she’s finished with her contract, AT&T will now unlock her old iPhone 4. Having an unlocked phone is advantageous when traveling overseas because you can pick up a Sim card with a phone plan and save some money. The question I want to [...]

Get the full story …

Microsoft Excel 2010 on the iPad with the OnLive Desktop

February 29, 2012 Product Review

The gold standard for Microsoft Excel is the latest Windows version, Excel 2010, and the gold standard for tablets is the iPad. The OnLive Desktop App brings them together. If you love Microsoft Excel and have an iPad, then this app is for you. I could go on and on and on about what a [...]

Get the full story …

Microsoft Query Incompatible with Mac OS X Lion [Updated]

July 12, 2011 Advanced

The other day I read an article on how to prepare my MacBook Pro for Lion, the new Mac OS X coming out this month, and discovered that any application that requires PowerPC is incompatible with Lion and will not work. See update at the end of this post. So I followed the instructions to [...]

Get the full story …

Pivot Tables in Google Docs

May 19, 2011 Product Review

Mark my words, “This is the beginning of the end for Excel.” To be sure this is a long way off and I probably won’t see this in my lifetime, but make no mistake Pivot Tables in Google Docs spreadsheets marks the eventual decline of Microsoft Excel. Of course, part of me will refute this [...]

Get the full story …

VBA Help System Lacking in Excel 2011

December 14, 2010 Intermediate

Since never using the VBA Editor in Excel 2011 for Mac was a slight embarrassment, I thought to give it a whirl with a half-written function that was started in Excel 2010. I quickly found out the Editor’s windows have more of a free-floating style, but the programming looked to be quite the same. Until [...]

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 …

Excel 2011 Ribbon Screen Shots

November 9, 2010 Product Review
Thumbnail image for Excel 2011 Ribbon Screen Shots

There are eight default tabs on the Excel 2011 Ribbon, and nine if you unhide the Developer tab. They are Home, Layout, Tables, Charts, SmartArt, Formulas, Data, Review, and Developer. Comparing the Excel 2010 Ribbon, the new Windows version, where the tabs are Home, Insert, Page Layout, Formulas, Data, Review, View, and Developer. The Tables, [...]

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 …

Introduction to PowerPivot

October 21, 2010 Features
Thumbnail image for Introduction to PowerPivot

In the year 2000, I began to use Microsoft Query to pull data from corporate client’s database tables, using their raw data to create PivotTable reports. Each table required a different query, each linked by using VLOOKUP formulas. And of course the data had to be restricted to Excel’s 65,536 rows. Soon I was having [...]

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