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.

Microsoft Access 2007: Have Access forms automatically close after use

If your users work with multiple Access forms, here’s how to make their work easier by having a form close automatically once they are finished with it:

1. Open the first form in Design view.
2. Double-click the Form Properties button.
3. Click on the Event tab.
4. Click in the On Deactivate text box.
5. Select Event Procedure.
6. Click the Build button.
7. At the prompt, enter: Me.TimerInterval =1.
8. Press ALT+Q.
9. In the Form Properties window, click in the On Timer property text box.
10. Select Event Procedure.
11. Click the Build button.
12. At the prompt, enter: DoCmd.Close.
13. Press ALT+Q.
14. Save the form.