Training and Certification

Rubel Khan's Blog

Archive for the ‘Office 2007’ Category

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: | Leave a Comment »

Microsoft Teacher Lounge – Free popular classroom templates

Posted by Rubel Khan on August 20, 2009

Posted in Office 2007 | Leave a Comment »

Microsoft Student Lounge- Office 301

Posted by Rubel Khan on August 20, 2009

Posted in Office 2007 | Leave a Comment »

How-to articles, and tips

Posted by Rubel Khan on August 6, 2009

Discover the power of the Office 2007 ribbon and toolbar
Whether you are new to Office or an Office expert, check out this overview of the ribbon and toolbar with learning options designed to meet your needs.

Speak visually in Microsoft PowerPoint
Learn how including pictures in presentations is a simple and powerful way of expanding your expressive potential as a speaker.

Manage e-mail while out of the office
Even when you’re away from the office, your e-mail doesn’t take a break and people may be expecting you to respond. Fortunately, several easy strategies can help you handle e-mail when you’re unavailable.

Get quick tips from the Microsoft Word Answer Box
Need help printing labels? Or using mail merge? Check out the Answer Box for responses to frequent questions using Microsoft Word.

Posted in Help and How-to, How Do I? Videos, Office 2007 | Leave a Comment »

Visual How Tos: Office 2007

Posted by Rubel Khan on August 4, 2009

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

Book Excerpts: Programming Microsoft Office Business Applications

Posted by Rubel Khan on August 4, 2009

Read book excerpts from the Microsoft Press book, Programming Office Business Applications.

Programming Microsoft Office Business ApplicationsBuy this book

The following chapters are excerpts from Programming Office Business Applications from Microsoft Press (ISBN 9780735625365, copyright Microsoft Press 2008, all rights reserved).

About the Book

Get practical guidance for creating custom applications by using the capabilities of the Microsoft Office platform. This hands-on reference illustrates how to use Microsoft Visual Studio Tools for the Microsoft Office system and Microsoft Office to create Office Business Applications (OBAs)—an emerging breed of application that bridges the gap between line-of-business (LOB) systems and end-user productivity tools. OBAs enable users to increase productivity by providing a seamless and integrated end-to-end user experience from their desktop to data in enterprise resource planning, customer relationship management, and other business systems. Experts on the Microsoft Office, Visual Studio Tools for Office, and OBA teams at Microsoft adeptly illustrate how to develop smart clients and Web services in the Microsoft Office environment. You’ll also find guidance on custom development for the Microsoft Office Fluent user interface and Windows SharePoint Services, application deployment, and managing workflow. Complete with code samples on the Web, this book delivers the pragmatic information enterprise developers need to know to create and deploy custom business applications to the organization.

About the Authors

  • Steve Fox is a program manager for Visual Studio Tools for Office and OBAs, and coauthor of 6 Microsoft Office Business Applications for Office SharePoint Server 2007.
  • Rob Barker, a senior technical evangelist at Microsoft, creates developer and architectural guidance for Microsoft Office and SharePoint Products and Technologies.
  • Joanna Bichsel is a program manager on the Office Platform Strategy team, where she develops architectural guidance and resources for Office-based solutions.
  • Erika Ehrli Cabral is site manager for the MSDN Office Developer Center. She acquires, authors, and releases technical content for Microsoft Office and SharePoint developers.
  • Paul Stubbs, a program manager on the Office team, develops programmability features for future versions of Microsoft Office. He’s also worked on the Visual Studio Tools for Office team.

Posted in E-Book, Microsoft, Office 2007 | Leave a Comment »

Book Excerpts: Microsoft Office Excel 2007 Visual Basic for Applications Step by Step

Posted by Rubel Khan on August 4, 2009

Read book excerpts from the Microsoft Press book, Microsoft Office Excel 2007 Visual Basic for Applications Step by Step.

Book CoverBuy this book

The following chapters are excerpts from Microsoft Office Excel 2007 Visual Basic for Applications Step by Step from Microsoft Press (ISBN c, copyright Microsoft Press 2008, all rights reserved).

Chapter 1: Make a Macro Do Simple Tasks

Chapter 4: Explore Range Objects

About the Book

The smart way to learn Microsoft Office Excel 2007 VBA—one step at a time!

Quickly teach yourself how to automate tasks and create custom spreadsheet solutions with Excel 2007 Visual Basic for Applications (VBA). With Step By Step, you set the pace—building and practicing the skills you need, just when you need them!

  • Create macros to automate repetitive tasks
  • Automatically format charts, shapes, and text
  • Manipulate tables and other objects—even build PivotTable reports
  • Write your own functions and procedures
  • Use loops and conditions to add decision logic to macros
  • Build custom command buttons, dialog boxes, and user formsYour all-in-one learning experience includes:
  • Files for building skills and practicing the book’s lessons
  • Fully searchable eBook
  • Windows Vista Product Guide eReference—plus other resources on CD

About the Author

Reed Jacobson is an expert in Excel and a popular author. In addition to writing about Excel Visual Basic since its inception, other authoring credits include Microsoft SQL Server™ 2005 Analysis Services STEP BY STEP, Microsoft Excel 97 STEP BY STEP, Advanced Topics, and Microsoft Office 2000 Expert Companion. He has created several training courses on Microsoft Office and Visual Basic, and is a regular presenter at SQL PASS, Tech Ed, and other Microsoft conferences and seminars. He is a senior architect for Hitachi Consulting, specializing in Business Intelligence solutions. Prior to joining Hitachi Consulting, Reed worked as a software application specialist for Hewlett Packard for 10 years and ran his own consulting firm for eight years. Reed received a BA in Japanese and Linguistics, an MBA from Brigham Young University, and he studied linguistics under a graduate fellowship at Cornell University.

Other Books by Reed Jacobson

Posted in E-Book, Microsoft, Office 2007 | Leave a Comment »