Saturday, August 25, 2012

Learning to Use Excel 2007

Excel 2007 is very similar to Excel 2010.  Both use the "ribbon" which was a major change to Excel from earlier versions.  Below are some videos to help you learn Excel 2007 quickly!  Click on the links to watch videos on YouTube.

Excel 2007 - Get up to Speed Fast

Excel 2007 - Overview 

Excel 2007 - The Ribbon

Excel 2007 - Setup

Excel 2007 - Cells

Excel 2007 - Insert & Delete Rows and Columns

Excel 2007 - Creating Your First Spreadsheet

Excel 2007 - Use Simple Formulas to Do Math

Excel 2007 - Formulas

Excel 2007 - Create Charts

Excel 2007 - Create Gant Chart

Excel 2007 - Creating a Pivot Table 

Excel 2007 - VLookup  (Perfects for Teacheres)

Excel 2007 - Left, Mid and Find Function

Excel 2007 - Highlight Active Row

Exce; 2007 - Find and Replace Data

Excel 2007 - How to Sort Data

Excel 2007 - Filtering Data


There are hundreds of more video tutorials on YouTube teaching you how to do various things in Excel 2007.  The links above are designed to help you learn the basics of Excel 2007 quickly!

Friday, August 3, 2012

Upgrading to Windows 8

A lot of my clients have been anxious to buy a new computer but have been concerned about the upcoming release of Windows 8.  Why buy a computer with Windows 7, only to have Windows 8 come out shortly afterwards?  Good question!  Here's some information to help put your mind at ease!

First, if you've been wondering what's new about Windows 8, you can watch a preview video, by clicking here.   Watching the video preview, it appears that Windows 8 is geared more towards social networking (i.e., communicating with others through Instant Messaging, Facebook, etc.).   So if you're really into all the social networking, you'll love Windows 8!  For those who aren't - no doubt Windows 8 will be an interesting experience. 

The good thing is that Microsoft has FINALLY made it easier to upgrade your operating system if you're buying (or already own) a computer running Windows 7.  Here's the deal ....

If you buy a new computer with Windows 7 per-installed between June 2, 2012 and January 31, 2013, you can get Windows 8 Pro for about $14.99!  Of course, you still have to register before February 2013 and follow the instructions in order to take advantage of this offer ... but it really is a GOOD deal .... and you don't have to worry about buying a new computer with Windows 7 installed.

Microsoft is also offering Windows 8 to folks who have recently bought a new computer with Windows 7 installed.   And by recently, I mean you have to have bought your new computer on or after June 2, 2012. If you bought your computer prior to June 2, 2012, you're out of luck!  You'll have to go out and buy a retail copy of Windows 8 upgrade software if you want to upgrade.