IT Training and Certification

Rubel Khan's Blog

Archive for the ‘Office 2007’ Category

New TechNet Resource Center: Outlook 2010 Resources

Posted by Rubel Khan on January 12, 2011

Learn about Outlook 2010 with resources for IT professionals, developers, and end users. CLICK HERE

Springboard Series

From exploring the latest features to assessing compatibility and customizing configurations, the Springboard Series is your destination for technical resources, free tools, and expert guidance to ease the deployment and management of the Microsoft Optimized Desktop, which comprises:

  • The Windows Client operating system
  • Microsoft Office products
  • Windows Internet Explorer
  • Microsoft Desktop Optimization Pack (MDOP) technologies such as Microsoft Application Virtualization (App-V) and Microsoft Enterprise Desktop Virtualization (MED-V)

Posted in How Do I? Videos, Learning Snacks, Microsoft Learning, Microsoft Press, Office 2007, Office 2010, TechNet, Tips and Tricks | Tagged: , , | 1 Comment »

MOS 2007 Master New Year’s Resolution

Posted by Rubel Khan on December 22, 2010

Make your new year’s resolution now to finish that coveted Microsoft Office Specialist 2007 Master certification… the Master requirements will be getting tougher next year!

What’s Coming? Starting March 1, 2011, to earn your MOS 2007 Master credential, you will need to pass the new Expert level Word and Excel exams. These exams are set to tentatively launch in English at the end of January, 2011, which means we’ll be giving a grace period before triggering the new requirements.

What’s Going? Prior to March 1, you can still become a MOS 2007 Master by passing these exams: Word, Excel, PowerPoint, and your choice of Outlook or Access. Please note that due to a system issue, if you complete the original 2007 Master requirements between November 1, 2010 and February 18, 2011, the Master certification will not immediately appear on your Microsoft transcript. After February 18, your transcript will be automatically updated. You will, however, receive your Master certificate, and your Master status will appear on your online transcript at

Why? To date all versions of MOS have required an Expert level Word and Excel exam to achieve the Master credential, with the exception of MOS 2007. We’re bringing MOS 2007 back in line with the rest of the certifications in terms of what it takes to gain the coveted MOS Master status.

All of these same details are outlined on the MOS Master Certifications page here. If you have any questions though, please let Microsoft team know.

Posted in MOS, Office 2007 | Tagged: , , | Leave a Comment »

Resume Help with Microsoft Office

Posted by Rubel Khan on May 1, 2010

As a college student, or someone new to the workforce, you may not be aware that Microsoft Office Online has some great tools to help you get started in creating your resume and cover letter. Read through our job search strategies and even run a job search query directly from our site. 

For more information, visit

Posted in Job, Office 2007, Office 2010 | Leave a Comment »

Technical and Educational Resources for IT Pros

Posted by Rubel Khan on March 6, 2010

I usually provide links to free certification programs that cover specializations in IT. But, today I thought I’d share with you some college level resources. If you are interested in a more in-depth and broad IT education, a full fledged college program might be a good choice for you. The websites Online IT Degree has a good information if you choose the online route. If you wish to choose a more prestigious institution and live on campus, Tech Republic has produced a nice report on the Top 10 US College Programs for IT. These programs will obviously require more funding and commitment than a certification course, but could pay off in the long run. Now, back to more free resources.
Technical Resources on TechNet – get the details you need about the products that bring people and information together and give them powerful user experiences. Plus, you’ll learn about deployment flexibility and control via the choice of on-premise, hosted, or hybrid solutions.

Posted in Exchange Server, Office 2007, Office 2010, SharePoint 2010 | Tagged: , , | Leave a Comment »

The top 10 Microsoft Office tips of 2009

Posted by Rubel Khan on December 31, 2009

Time for that final look back at the year’s most popular tips for each Office app.

Here in the Office blog, we kicked off 2009 with a technique for using a formula to trigger conditional formatting in Excel — followed by more than 300 additional tips and tutorials covering the Office suite and individual apps. During the year, we launched two new features — our Office poll and Office challenge. And we had more than a few lively discussion threads going. Now, before the year gets away from us completely, we thought we’d revisit a few of the most popular tips of 2009.

Special thanks to Office expert and blog host, Susan Harkins, and to everyone who contributed their own tips, shortcuts, workarounds, and insights during the year.

Note: These tips are also available as a PDF anthology in our downloads library.






Get a steady supply of Office tips

Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, Access, PowerPoint, and Outlook tips, delivered each Wednesday.

Jody Gilbert has been writing and editing technical articles for the past 20 years, including a stint with The Cobb Group/ZD Journals. She’s been with TechRepublic since Day One. Read her full bio and profile.

Posted in Office 2007, Tips and Tricks | Leave a Comment »

2007 Microsoft Office Suites Solution Center

Posted by Rubel Khan on December 19, 2009

Update Office 2007

Installation error messages

Keeping Office up to date

Office 2007 installation help

Security and privacy

Posted in Office 2007 | Leave a Comment »

Microsoft Learning Portal Index

Posted by Rubel Khan on October 15, 2009

Posted in Office 2007, Virtualization, Visual Studio (.NET), Windows 7, Windows Server, Windows Vista | Tagged: , , , , , , , , , , , , | Leave a Comment »

Microsoft Office – How-to articles tips and more

Posted by Rubel Khan on October 14, 2009

Video: Create drop-down lists in Excel 2007
To make data entry easier, you can create a drop-down list in your worksheet. Watch this video to see how to use Excel 2007 to create a drop-down list from a range of cells.
Share Office 2007 documents with users of previous versions of Microsoft Office
If you have friends or colleagues with pre-2007 versions of Microsoft Office, they can download the Compatibility Pack and easily open, edit, and save Word, Excel, and PowerPoint 2007 documents.
Copy Excel data or charts to PowerPoint
Learn how you can simply insert data or charts from Excel into a PowerPoint presentation by selecting what you want in Excel and then using the Paste or Paste Special commands in PowerPoint.
Why did the line-spacing change in Word 2007?
Microsoft Office Word 2007 uses a newly designed default template for creating documents. Find out more about this template and how to change it if you wish.

Posted in Help and How-to, Office 2007 | Leave a Comment »

Open XML and Office 2007: Available and Upcoming Training and Webcast Schedule

Posted by Rubel Khan on September 2, 2009

Microsoft Press author, and Microsoft Office MVP, Stephanie Krieger, has a series of live webcasts – the first started this week. The training is free and self-paced, offered by Microsoft Office Online.

Here are the links to the Open XML series:

Open XML I: Exploring the Open XML File Formats

Open XML II: Editing documents in the XML

And here’s the series on Office 2007 – introduced in previous post.

Build Your Own Custom Themes – September 15th

Extend the 2007 Office system – September 29th

And here’s the recording of the first held earlier this week: Create Professional Quality Graphics with the 2007 Microsoft Office System (Level 200).

Much of this material builds on concepts and content found in Stephanie’s book Advanced Microsoft® Office Documents 2007 Edition Inside Out.

Source: Born to Learn

Posted in Office 2007 | Tagged: | 1 Comment »

Microsoft Teacher Lounge – Free popular classroom templates

Posted by Rubel Khan on August 20, 2009

  • One teacher’s favorite 6th and 7th grade templates
  • Periodic table
  • Multiplication table
  • Electronic grade book for Excel
  • Emergency contact info
  • Classroom materials sign-out sheet
  • Multiple choice test kit 
  • Posted in Office 2007 | Leave a Comment »


    Get every new post delivered to your Inbox.

    Join 33 other followers

    %d bloggers like this: