The top 10 Microsoft Office tips of 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.

Word

• Don’t use Tab to indent paragraphs in a Word document
• 10+ lesser-known shortcuts for formatting Word text

Excel

• Use Excel’s built-in features to simplify data entry
• Three timesaving Ctrl-key tricks in Excel

PowerPoint

• Create a self-running PowerPoint presentation
• Build a quick training presentation using PowerPoint’s Photo Album feature

Access

• Avoid import glitches when bringing Excel data into Access
• 10 tips for working with dates in Microsoft Access

Outlook

• Colorize your Outlook messages to identify e-mail from specific senders
• Avoid e-mail mistakes with a single setting

---

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.

Top five Career Management blog posts of 2009

Date: December 23rd, 2009

Author: Toni Bowers

It was quite a year over at TechRepublic’s Career Management blog. Here are the five top blogs according to page views:

10 boring phrases you should cut from your resume

You may think it’s not a big deal to use some of those tried-and-true resume phrases like “results oriented” or “team player,” but believe me, no one who has to go through piles of resumes will be impressed by them. Here are some more clichéd phrases that you should do away with.

10 signs of incompetent managers

We run down some of the worst signs of bad managers in this blog, and the TechRepublic community chimed in with dozens more.

12 technology terms that date you

This blog centered on a discussion of a piece written by Carolyn Duffy Marsan and featured on networkworld.com. Marsan listed 12 tech phrases that she says should never be spoken in the workplace. The TechRepublic audience had a huge problem with her list, as you can tell from the discussion.

Three things a manager never wants to hear you say

There are a host of things a manager never wants to hear from a member of his staff. But here are three of them that could strike fear in the heart of your manager simply by their implications.

32 online tools that can help your tech freelancing career

Perhaps due to company staff cutbacks, many people are looking to do freelance IT. In this blog, we offer links to a number of great online tools that can make the day-to-day elements of freelancing and marketing yourself a little easier.

Toni Bowers is the Head Blogs Editor of TechRepublic. She has been in the publishing industry for 20 years, with concentration in IT-related topics. She has edited newsletters, books, and web sites pertaining to software, IT career, and IT management issues

10 Books You Should Read, Say Entrepreneurs and Business Owners : Innovation :: American Express OPEN Forum

Jen Miller wrote here on OPEN Forum about five books for business owners. Hers was a pretty good list, and it encouraged me to share another list – a list chosen by a group of entrepreneurs and business owners.

Last month we asked readers of Small Business Trends to make their choices for best new business book releases of 2009 for small business owners.  In other words, we asked entrepreneurs and small businesspeople to choose a list of books they recommend for their peers, for 2009.

Read full article via 10 Books You Should Read, Say Entrepreneurs and Business Owners : Innovation :: American Express OPEN Forum.

Putting experience to work – ColumbiaTribune.com

Older workers — some looking for work — are receiving technology training through workshops sponsored by grants from the U.S. Department of Labor and the Walmart Foundation.

Read full article via Putting experience to work – ColumbiaTribune.com.

HHS offers $38M for healthcare IT workforce training | Healthcare IT News

WASHINGTON – The government has launched two grant programs totaling $38 million for the training and development of a skilled workforce to support adoption and use of healthcare information technology.

The funding, announced Wednesday, adds to $80 million announced earlier this year.

Read full article via HHS offers $38M for healthcare IT workforce training | Healthcare IT News.

How to Land the Jobs of the Future – WSJ.com

By DIANA MIDDLETON

If you’re gearing up for a job search now as an undergraduate or returning student, there are several bright spots where new jobs and promising career paths are expected to emerge in the next few years.

Technology, health care and education will continue to be hot job sectors, according to the Bureau of Labor Statistics’ outlook for job growth between 2008 and 2018. But those and other fields will yield new opportunities, and even some tried-and-true fields will bring some new jobs that will combine a variety of skill sets.

Read full article via How to Land the Jobs of the Future – WSJ.com.

Microsoft Office 2010 Technical Preview FAQ

About Microsoft Office 2010        

	What are some of the major updates to the Microsoft® Office 2010 suites from previous versions?
	Microsoft Office 2010 offers you rich and powerful new ways to deliver your best work ¾ at work, home or school ¾ on your computer, from a Windows Mobile-based Smartphone or via a Web browser.1 Quickly and creatively grab your audience’s attention and inspire them with your ideas by using enhanced and easy-to-use tools, customizable templates, color schemes, and photo-editing capabilities. With a new co-authoring experience, you can work with people from different locations at the same time. And by offering more ways to access your files from almost anywhere, Office 2010 puts you in control of getting things done according to your schedule. Simplify your tasks and create amazing results with Office 2010 — wherever life takes you.
	What products are included in the Office 2010 suites?
	Microsoft Office Professional Plus 2010 — only available via volume licensing Includes: Microsoft® Excel® 2010 Microsoft® Outlook® 2010 with Business Contact Manager Microsoft® PowerPoint® 2010 Microsoft® Word 2010 Microsoft® Access® 2010 Microsoft® InfoPath® 2010 Microsoft Communicator Microsoft® Publisher 2010 Microsoft® OneNote® 2010 New addition to suite Microsoft® SharePoint® Workspace 2010 New addition to suite Microsoft Office Web Apps Integrated solution capabilities such as enterprise content management (ECM), electronic forms, and information rights and policy capabilities
	Microsoft Office Professional 2010 Includes: Microsoft Excel 2010 Microsoft Outlook 2010 Microsoft PowerPoint 2010 Microsoft Word 2010 Microsoft Access 2010 Microsoft Publisher 2010 Microsoft OneNote 2010 New addition to suite	Microsoft Office Home and Business 2010 New! Includes: Microsoft Excel 2010 Microsoft Outlook 2010 Microsoft PowerPoint 2010 Microsoft Word 2010 Microsoft OneNote 2010
	Microsoft Office Standard 2010 — only available via volume licensing Includes: Microsoft Excel 2010 Microsoft Outlook 2010 Microsoft PowerPoint 2010 Microsoft Word 2010 Microsoft OneNote 2010 New addition to suite Microsoft Publisher 2010 New addition to suite Microsoft Office Web Apps	Microsoft Office Home and Student 2010 — licensed for noncommercial use Includes: Microsoft Excel 2010 Microsoft PowerPoint 2010 Microsoft Word 2010 Microsoft OneNote 2010
	Microsoft Visio 2010 and Microsoft Project 2010 are also available but are not part of the suites.
	What are the Office Web Apps?
	The Office Web Apps allow you to work with your Microsoft Office files from more places and on more devices by providing browser-based viewing and lightweight editing of Word 2010, Excel 2010, PowerPoint 2010 and OneNote 2010 files. Access your work at any time from a Smartphone or computer with an Internet connection.2 The Office Web Apps are designed to work with Internet Explorer, Safari and Firefox and requires SharePoint 2010 or a Windows Live account. Note: Office Web Apps will be available through Windows Live at a later date during Technical Preview and will have limited functionality at this milestone.
	Why should I use Office 2010?
	Office 2010 can help you express your ideas more visually. With Office 2010, you can easily create powerful visuals and apply professional-looking designs to photos and text, and to videos in PowerPoint. From new and improved picture-editing effects such as saturation and watercolor to video editing and formatting capabilities such as trimming, fades and reflections, Office 2010 opens up a world of design options to give life to your ideas.
	Enjoy the familiar Microsoft Office experience on the web. With Office Web Apps, you can take advantage of greater flexibility when working in Microsoft Word, Excel, PowerPoint and OneNote. That’s because you can access your work at any time from a Smartphone or computer with an Internet connection.2 Create amazing documents using Office 2010 and then easily post them online so you can share your work with others from across town or around the world. It’s convenient and easy.
	Connect, share and accomplish more when working together. Now you can get more done when working in groups. The new co-authoring experience with Word 2010, PowerPoint 2010 and OneNote 2010 lets you work on a file with multiple people simultaneously from different locations. Brainstorm ideas, control versions better and meet deadlines faster — it’s a snap with Office 2010.
	Store and track all your ideas and notes in one place. With Microsoft OneNote 2010, you get the ultimate digital notebook for tracking, organizing and sharing your text, photos, and video and audio files. New features such as version tracking, highlighting and Linked Notes give you more control over your notes so you’re always on top of the latest changes and sources of your information.
	Create powerful data insights and visualization. With new data analysis and visualization features in Excel 2010, you can easily track and highlight important data trends. For example, the new Sparklines feature delivers a clear and compact visual representation of your data with small charts in a cell. The new Slicers feature lets you filter and segment your PivotTable data in multiple layers so you can spend more time analyzing and less time formatting.
	Access your work across devices and platforms. Office 2010 gives you a familiar and intuitive experience across PCs, Smartphones1 and various Web browsers so that you have the freedom to use the system from more locations and on multiple devices.
	Deliver more compelling presentations. With PowerPoint 2010, you can effectively engage your audience by embedding and personalizing videos within your presentation. The embedded video file can be customized by adding video triggers and styles directly within PowerPoint 2010, saving you time and money.
	Create sophisticated business process forms with little or no code. InfoPath 2010 is designed for both advanced business users and developers, depending on the type of forms-based solution and organization needs. Without writing code, advanced business users can use InfoPath 2010 to design sophisticated electronic forms to quickly and cost-effectively gather information. Developers can create advanced forms for departmental and enterprise business processes, including composite applications and workflow sequences, with InfoPath 2010, Microsoft SharePoint Server 2010 and SharePoint Designer 2010 — using little or no code.
	What is the Microsoft Office Backstage™ view?
	Microsoft Office Backstage view replaces the file menu across the core Microsoft Office 2010 applications. Backstage view helps you find commonly accessed commands when opening or finishing a document, including opening new or existing files, defining document properties, and sharing your information. Designed using data on product feature usage generated by the Customer Experience Improvement Program, the Backstage view also brings together related tasks, making it easier to work with your documents. For instance, printing tools — previously spread across several commands (page layout, preview, print) — are all together in one Print tab within the Backstage view. You can assign metadata to a file, check it for accessibility, or make sure it’s finalized and ready to share with others. Backstage lets you share, print, and publish your documents with just a few clicks. Backstage view is extensible. For businesses, IT can incorporate work and information flows from other systems and highlight them right within the most useful Microsoft Office application. For example, Backstage view lets you bring those back-end accounting or HR workflows right into Office 2010.
	What is the Ribbon?
	The Ribbon replaces traditional menus and toolbars with a fresh, highly visual layout of commands, organized into a set of tabs, to help you find the features you need fast. The Ribbon was introduced in Office 2007, when it enhanced a few of the Microsoft Office applications. It made the available commands and tools more visible and easier to access so you could focus more easily on your content. In Office 2010, every application has the Ribbon, including favorites such as OneNote 2010, Publisher 2010, InfoPath 2010, SharePoint Workspace 2010 (the new name for Microsoft Office Groove 2007) and the new Office Web Apps. The Ribbon brings new features such as Outlook 2010 Quick Steps to your attention and is customizable so you can personalize it to your work style.
	Can I customize Office 2010 based on how I use the product?
	With an improved Ribbon across all the Office 2010 applications, you can access your favorite commands quickly and create custom tabs to personalize the experience. Ribbon tabs can be customized or replaced with your own custom tabs. Through the Options menu in the Backstage view, you can easily create new tabs that bring together your favorite commands and groups. Existing tabs can also be customized to fit your needs. If you’re a business IT professional, take advantage of the new Microsoft Office Backstage view to incorporate work and information flows from other systems and highlight them right within the most useful Microsoft Office application. For example, Backstage view lets you bring those back-end accounting or HR workflows right into Office 2010.
	What does co-authoring mean in Office 2010?
	Co-authoring refers to the ability for multiple authors to edit a document, presentation, spreadsheet or notebook at the same time, allowing you to connect, share and accomplish more when working together. With the new co-authoring experience available for Word 2010, PowerPoint 2010, OneNote 2010 and Excel 2010 (through Excel Web App), you and your co-workers can work on a file from different locations, brainstorm ideas, control versions better and meet deadlines faster.
	Will Office 2010 products be available in 64-bit versions?
	Office 2010 products will be available in 32-bit and 64-bit versions.
	What other related products does Office 2010 work with?
	Here are some examples of products that Office 2010 will work with: Microsoft SharePoint 2010 Use Backstage view to easily share your work to SharePoint Server from Microsoft Word, Excel, Outlook, PowerPoint, OneNote, Access, InfoPath and SharePoint Workspace. Co-author your documents using SharePoint 2010 together with Word, Excel, PowerPoint and OneNote. Use SharePoint 2010 to access your Office Web Apps with Word, Excel, PowerPoint and OneNote, and access business forms with InfoPath 2010.   Windows Live Use Windows Live to access, store and share your documents via Office Web Apps for Word, Excel, PowerPoint and OneNote so you can access your files from virtually anywhere.   Microsoft Exchange Server 2010. Together with Microsoft Exchange Server, Outlook provides an enterprise-grade messaging platform. With Microsoft Exchange Server, you can receive voice mail and faxes directly to your inbox, and they can be accessed virtually anywhere using your PC, Outlook Mobile1 or Outlook Web Access. Compliant, security-enhanced messaging is simple and effective across the organization using Outlook 2010 and Exchange Server 2010. Innovative tools such as MailTips notify users when they are about to send an e-mail to a group or an individual who is outside the organization. Tools such as Retention Policy and Automated Policy Application use Windows Rights Management Services to allow corporate messaging to be transmitted with advanced security and retained for records management. Improved connectivity with Microsoft Exchange Server 2010 will support the use of multiple Exchange accounts in Outlook 2010, making it simple for a user to manage several accounts in one place.   Office Communications Server 2007 R2 Microsoft Office Communicator 2007 R2 works with Microsoft Office Communications Server 2007 R2 to provide a streamlined communications experience from within Office 2010 applications. Rich presence is available throughout Office 2010 applications to provide information about a person’s availability and status. Wherever you see a presence icon, hovering over it will reveal a menu of communications options from which you can initiate a real-time conversation without having to switch applications. It’s easy to move from one communication modality to another with Office Communications Server 2007 R2. Start a conversation with an instant message from within an Office application such as Outlook, escalate to a call, add video or share a document. A desktop-sharing session can be initiated directly from Backstage view in Word 2010, Excel 2010 and PowerPoint 2010.   Microsoft SQL Server 2008 R2. By using Microsoft SQL Server 2008 R2 with SharePoint 2010, you can now share and collaborate on powerful analyses that refresh automatically. In addition, SQL Server allows IT to manage user-generated Excel spreadsheets directly from SharePoint, giving you peace of mind that your analysis is continuously available, up-to-date and security-enhanced.

 

Microsoft Office 2010 System Requirements & Compatibility

 

	Are there special system requirements for running Office 2010?
	Preliminary system requirements for Office 2010 include the following: Windows XP SP3, Windows Vista or Windows 7 You don’t need to replace hardware that is capable of running Office 2007; it will support Office 2010.  Processor: 500 MHz or higher Memory: 256 MB or higher Hard Disk: 1.5 GB; a portion of the disk space will be freed after installation if the original download package is removed from the hard drive.
	Which browsers are supported for the new Office Web Apps?
	The Office Web Apps are designed to work with Internet Explorer, Safari and Firefox.

 

Microsoft Office 2010 Beta & Purchase

 

	When will the Office 2010 Beta be available?
	The Office 2010 Beta is scheduled to be available later this year.
	When will Office 2010 be available for purchase?
	Office 2010 is entering a limited technical preview starting in July and will release to manufacturing in the first half of 2010.
	How much will Office 2010 cost?
	Pricing will be announced at a later date.
	Is there a Macintosh version of Microsoft Office 2010?
	Office 2008 for Mac is the current version of Office for Mac users. Office 2008 launched in January 2008 and is the leading productivity suite available on the Mac platform, delivering a full and compatible Office suite for Mac users. While we haven’t shared a launch for the next release of Office for Mac, we typically ship a new version of Office every two to three years.
	Are Office Web Apps free? What are the different ways people can get them?
	For business use, Office Professional Plus and Office Standard 2010 licenses will each include access to the Office Web Apps. A customer will then be able to run the Office Web Apps on SharePoint 2010. For personal use, Office Web Apps will be available as a free ad-supported service to consumers via Windows Live.

 

Using Microsoft Office 2010

	Can I access my files when I am away from my primary computer?
	Yes. Office 2010 gives you a familiar and intuitive online experience across individual computers (including Macs) and operating systems, Smartphones and browsers so that you have the freedom to use Microsoft Office from more locations and on multiple devices. The Office Web Apps let you work online from anywhere, in multiple browsers, and Office Mobile 2010 helps you stay connected while on the go.1
	How do I access Office 2010 files from the browser?
	For businesses: You can access your Word, Excel, PowerPoint and OneNote files from a SharePoint Server that is running the Office Web Apps by selecting Open in Web from the drop-down menu next to the file. When you are ready to access the document, simply log back on to your company’s network for access from your Internet Explorer, Safari or Firefox browser. You can publish and access InfoPath 2010 Forms in a browser powered by SharePoint Server 2010 as well. For personal tasks: You can access your Word, Excel, PowerPoint and OneNote files by posting your documents online. When you are ready to edit or view the document online, simply log on to Windows Live from Internet Explorer, Safari or Firefox. A Windows Live ID is required for accessing the Windows Live Document account.
	How do I access Office 2010 from my phone?
	You can access your Office 2010 files from your phone in the following ways: Office Mobile 2010. Office Mobile 2010 can be launched from your Start menu on any phone running Windows Mobile 6.5.4 You can also open Office file attachments within your e-mail or documents stored on your Windows® phone directly. Smartphone Web browser. Publish your documents to SharePoint Server 2010 or Windows Live services, and access and view documents from your Smartphone browser.5 You can access InfoPath forms via a full-featured mobile browser powered by SharePoint Server 2010.

Microsoft Visio 2010: A Diagram Is Worth a Thousand Words

The biggest release of Microsoft Visio in 10 years makes it easy to share diagrams connected to data in real time.

REDMOND, Wash. — Dec. 17, 2009 — The world is more complex than ever, and people need an easy way to simplify information, communicate it to others and ultimately make better decisions. Diagramming has always been a way to help organize information into easy-to-see, digestible parts. Whether on napkins, white boards or paper, diagramming helps convey thoughts and ideas.  Dynamic, data-linked organization chart with the new Visio 2010 user interface. As data changes, the data graphics can be refreshed with one-click. Click for larger image. “Humans have always communicated visually, to make sense of the world and communicate quickly with others,” said Chris Crane, director of Visio Product Management at Microsoft Corp. “That’s why the diagram is so powerful, and even more relevant in today’s fast, global, news-intensive society.” Diagramming is so popular that about half of all Microsoft Office users diagram. In the world of diagramming, Microsoft Visio stands out as a way to easily simplify complexity and communicate with others. In fact, over 15 million customers worldwide have Visio for diagramming as do over 70 percent of the global 100 companies. Now the next evolution of diagramming is here — Visio 2010. The most significant Visio release in 10 years, it delivers tools that help create dynamic, data-driven diagrams, shareable via the Web. Changing the Way People Diagram As information becomes more complex, the way people interact with that information has evolved. Diagrams are an easy, simple way to convey ideas — and Visio 2010 is the next step in this diagramming evolution. Five Reasons to Try Visio 2010 Identify operational inefficiencies. Use Visio’s comprehensive and robust business process analysis capabilities to capture, explore and communicate current business processes and identify operational inefficiencies. Reduce IT costs and risks. Document IT infrastructure and improve critical IT processes to enhance compliance and reduce IT costs. Improve project management. Create, edit and modify project plans using Visio to better understand and more effectively communicate key information. Gain valuable business insights. Link data to diagrams to visualize and explore complex data and make better decisions, faster. Reduce costs using server consolidation planning. Quickly assess server usage at both the rack and individual server level to help support decisions around shifting workloads. The advanced diagramming tools in Visio 2010 are easy to use, can create dynamic data-driven visuals, and provide new ways to share on the Web in real-time. Visio 2010 is simple and easy to use. Out of the box it comes with 66 preset templates and now has the Office Ribbon incorporated into its user interface — making it easier for all types of workers to find the tools they need to build, update or view a diagram. “Whether it’s an organizational chart, network diagram or a business process, the latest tools in Visio 2010 help create visually-pleasing diagrams that simplify complexity and get everyone on the same page,” Crane said. “With a large collection of pre-drawn shapes, pictures and templates, and the dramatically improved user experience, every step is easier and more intuitive.” Visio 2010 also brings diagrams to life with dynamic visuals that are connected to data in real time, refreshing automatically when the data changes. This ultimately increases productivity by bringing together separate silos of information — such as a business process diagram and the Excel data related to that process — into a single, up-to-date view, saving time and speeding up decisions. For example, IT departments can visualize how their systems all work together by connecting network diagrams with data from Microsoft System Center Operations Manager. “Anyone can easily place real-time data right onto the shapes of a diagram,” Crane said. “The icons, symbols, colors and bar graphs give a clear view of the information that matters to your business — and automatically links to popular data sources like Excel or Access to help you display visuals that are always current.” Finally, using Visio Services on SharePoint Server 2010, diagrams connected to real-time, interactive data can be shared with others on the Web, making it easy to keep everyone working on a project up-to-date. Users can connect a visual to one or more data sources and publish a data-linked diagram to SharePoint Server 2010. Co-workers with SharePoint access can then view the diagram via a Web browser and drill down into more details — even if they don’t have Visio. Information that had been “locked” in a spreadsheet or database and a diagram can now be linked together and communicated broadly with Visio 2010. This helps organizations get a clear picture of different islands of information that need to be in perfect step together and communicated across the organization. “If a picture is worth a thousand words, Visio 2010 is priceless,” Crane said. “Check out the next evolution of diagramming tools as soon as you can — you’ll be surprised at how easy it is to create and share expert diagrams that help you communicate your information and viewpoint better than ever.”

Top 10 Benefits of Office 2010 Beta

Microsoft Office 2010 Beta

Get It Now

For home, small business, and school Download the Office 2010 beta if you’re a student, running a small business, or using Office at home. Download Now

For enterprise and mid-sized business Download if you’re an IT professional or a developer or want to use Office at work. Download Now

Microsoft® Office 2010 offers rich and powerful new ways to deliver your best work at the office, home, or school. Grab your audience’s attention and inspire them with your ideas visually. Create results with people at the same time and stay connected to your files across the town or around the world.¹ With Office 2010, you’re in control of getting things done and delivering amazing results according to your schedule.

1 Express your ideas more visually Office 2010 opens up a world of design options to help you give life to your ideas. The new and improved picture formatting tools such as color saturation and artistic effects let you transform your document visuals into a work of art. Combined with a wide range of new pre-built Office themes and SmartArt® graphic layouts, Office 2010 gives you more ways to make your ideas stick.

2 Accomplish more when working together Brainstorm ideas, provide better version control, and meet deadlines faster when you work in groups. The co-authoring experience for Microsoft® Word 2010, Microsoft PowerPoint 2010, Microsoft® Excel Web App and Microsoft OneNote shared notebooks let you work on a file with several people at once – even from different locations.2

3 Enjoy the familiar Office experience from more locations and more devices With Office 2010, you can get things done more easily, from more locations and more devices. Using a smartphone or virtually any computer with an Internet connection, you can work when and where you want to work.3 Microsoft Office Web Apps Extend your Office 2010 experience to the Web. Store your Word, Excel, PowerPoint, and OneNote files online and then access, view, edit, and share content through the web.  Microsoft Office Mobile 2010 Stay current and respond quickly using enhanced mobile versions of Office 2010 applications, specifically suited to your Windows Mobile-based smartphone.

4 Create powerful data insights and visuals Track and highlight important trends with new data analysis and visualization features in Excel 2010. The new Sparklines feature delivers a clear and compact visual representation of your data with small charts within worksheet cells. Filter and segment your PivotTable data in multiple layers using Slicers to spend more time analyzing and less time formatting.

5 Deliver compelling presentations Captivate your audience with personalized videos in your presentation. Insert and customize videos directly in PowerPoint 2010—trim, add fades and effects, or bookmark key points in the video to call attention to selected scenes. Videos you insert are now embedded by default, relieving you from managing and sending additional video files.

6 Manage large volumes of e-mail with ease Compress your long e-mail threads into a few conversations that can be categorized, filed, ignored, or cleaned up. The new Quick Steps feature let you perform multi-command tasks, such as reply and delete an e-mail in a single click, saving you time and in-box space.

7 Store and track all your ideas and notes in one place Get the ultimate digital notebook for tracking, organizing, and sharing your text, picture, video and audio notes with OneNote 2010. New features such as version tracking, automatic highlighting, and Linked Notes give you more control over your notes so you’re always on top of where your ideas came from and the latest changes when working in teams.4

8 Get your message out instantly Broadcast your PowerPoint presentation to a remote audience, whether or not they have PowerPoint installed.5 The new Broadcast Slide Show feature allows you to share your presentation through a web browser quickly without additional set up.

9 Get things done faster and easier Microsoft Office Backstage™ view replaces the traditional File menu to give you a centralized space for all of your file management tasks, such as the ability to save, share, print, and publish. The enhanced Ribbon across Office 2010 applications lets you access commands quickly and customize tabs to personalize the experience to your work style.

10 Access work across devices and platforms Enjoy the freedom of using Office 2010 from more locations on more devices. When you use Microsoft® Office 2010, you’re getting the familiar and intuitive Office experience across PCs, Smartphones, and Web browsers on the go.

Sample chapters: Microsoft Exchange Server 2010 Administrator’s Pocket Consultant

Here are the outlines of the chapters:

Chapter 1 Microsoft Exchange Server 2010 Administration Overview
Exchange Server 2010 and Your Hardware
Microsoft Exchange Server 2010 Editions
Exchange Server and Windows
Services for Exchange Server
Exchange Server Authentication and Security
Exchange Server Security Groups
Exchange Server and Active Directory
Understanding How Exchange Stores Information
Understanding How Exchange Routes Messages
Using the Graphical Administration Tools
Using the Command-Line Administration Tools

Chapter 6 Mailbox Administration
Creating Special-Purpose Mailboxes
Using Room and Equipment Mailboxes
Creating Room and Equipment Mailboxes
Creating Linked Mailboxes
Creating Forwarding Mailboxes
Creating Archive Mailboxes
Managing Mailboxes: The Essentials
Viewing Current Mailbox Size, Message Count, and Last Logon
Setting Alternate Mailbox Display Names for Multilanguage Environments
Hiding Mailboxes from Address Lists
Defining Custom Mailbox Attributes for Address Lists
Moving Mailboxes
Moving Mailboxes: The Essentials
Performing Offline Mailbox Moves
Performing Online Mailbox Moves
Importing and Exporting Mailbox Data
Configuring Mailbox Delivery Restrictions, Permissions, and Storage Limits
Setting Message Size Restrictions for Contacts
Setting Message Size Restrictions on Delivery to and from Individual Mailboxes
Setting Send and Receive Restrictions for Contacts
Setting Message Send and Receive Restrictions on Individual Mailboxes
Permitting Others to Access a Mailbox
Forwarding E-mail to a New Address
Setting Storage Restrictions on an Individual Mailbox
Setting Deleted Item Retention Time on Individual Mailboxes

The sample chapters add up to 74 pages.  Download them as XPS.  Or download them as PDF.

Enjoy!