Excel 2007: Fill In the Blanks in Spreadsheets the Easy Way

1. Select all the rows in your Microsoft Office Excel spreadsheet data set.
2. On the Home tab, in the Editing group, click Find & Select, click Go To, click Special, click Blanks, and then click OK.
3. Click the equal sign (=) on the toolbar, select the cell above, and then hold down the CTRL key while you press ENTER. Blanks in the spreadsheet will be filled automatically.
4. Copy all the data, click Paste Special, and then click Values. This will overwrite the formulas and enable you to sort the data by filling in each empty cell with the same information as the one above. This tip will work on any size of data set.

Create conditional drop-down lists in Excel

Did you know that by using the INDIRECT function, you can then create additional drop-down lists that are conditional to the first drop-down list? Neither did I, but with a little help, now I can do it. Check out how on the Microsoft Excel Blog.

FREE WEBINAR: Introducing Microsoft Office 2010 for Students and Educators

Sign up at http://educationwebcasts.com/Webcast.aspx?i=5041

Live Nov 24 11:30AM-12:30PM Central Time

Microsoft® Office 2010 will deliver innovative learning experiences by providing rich and powerful new ways to express and share ideas. Join this webcast to discover how Office 2010 will enable students and educators to bring ideas to life with advanced video and picture editing, broadcast capability in Microsoft PowerPoint 2010, easy document preparation through the new Microsoft Office Backstage view, and visualize data in new ways with Microsoft Excel 2010. They can collaborate better and take shared notes with co-authoring in Microsoft Word 2010, Microsoft PowerPoint 2010 and Microsoft OneNote 2010. Work from anywhere with Office Web applications, lightweight browser based companions to Word, PowerPoint, Excel and OneNote that provide access to documents from virtually anywhere and preserve the look and feel of a document regardless of device.

Speakers:

• David Norris—Education Solutions Specialist

Edit and format pictures in PowerPoint 2010

Have you wanted to do more with the formatting of pictures in PowerPoint? With 2010, YES YOU CAN! Check this out.

Office 2010 Betas available!

Worried about what the next upgrade might bring? Check out it out for yourself with a trial download of the Office 2010 betas. Go ahead and try it. It's not as bad as you might think.

VLOOKUP(), MATCH(), and OFFSET()

Some people are aware of the VLOOKUP function, but not as many are familiar with MATCH and OFFSET. If you use VLOOKUP, you should learn about the other two as they may come in handy when the other doesn't quite fit your need.

Instead of recreating the explanation, here is a simple and easy to understand explanation from Chandoo, MVP (@r1c1).

Install Word Add-In to upload your resume to Monster.com

Download an easySubmit resume template from Office.com, and install the add-in from the Word 2007 ribbon. Complete your resume, save it, sign-in to Monster.com, upload, and you're done! You can learn more at the Inside Office Online Blog.