Microsoft Office 2010 Training Courses

Microsoft Word 2010 offers the best of all worlds: enhanced features to create professional-quality documents, easier ways to work together with people, and almost-anywhere access to your files.
Designed to give you the finest document-formatting tools, Word 2010 helps you organize and write your documents more efficiently. In addition, you can save documents online and access, edit, and share them from almost any Web browser. Your documents stay within reach so you can capture your best ideas whenever and wherever they occur.

1
Discover an improved search and navigation experience. Locating the information you need is faster and easier in Word 2010. With the new and improved Find experience, you can now view a summary of search results in a single pane, and click to access any individual result. The improved Navigation Pane provides you a visual outline of your document so you can browse, sort, and find what you need quickly.


2
Work with others without having to wait your turn.Word 2010 redefines the way people can work together on a document. With co-authoring, you can edit papers and share ideas with others at the same time. You can also view the availability of others who are authoring a document with you and can easily initiate a conversation without leaving Word.


3
Access and share your documents from virtually anywhere. Post your documents online and then access, view, and edit them from almost any computer or your Windows phone. With Word 2010, you can take advantage of a best-in-class document experience across multiple locations and devices.
Microsoft Word Web App. Edit documents in a Web browser when you’re away from your office, home, or school without compromising the quality of your viewing experience.

Microsoft Word Mobile 2010. Stay current and take immediate action using an enhanced mobile version of Word specifically suited to your smartphone.


4
Add visual effects to your text. With Word 2010, you can apply formatting effects such as shadow, bevel, glow, and reflection to your document text as easily as applying bold or underline. You can spell-check text that uses visual effects, and add text effects to paragraph styles. Many of the same effects used for images are now available to both text and shapes, enabling you to seamlessly coordinate all of your content.


5
Turn your text into compelling diagrams. Word 2010 offers you more options to add visual impact to your documents. Choose from dozens of additional SmartArt® Graphics to build impressive diagrams just by typing a bulleted list. Use SmartArt to transform basic, bullet-point text into compelling visuals that better illustrate your ideas.


6
Add visual impact to your document.New picture-editing tools in Word 2010 enable you to add special picture effects without additional photo-editing software. You can easily adjust pictures with color saturation and temperature controls. You also get improved tools for easier and more precise cropping and image correction, to help you turn a simple document into a work of art.


7
Recover work you thought was lost.
After working on that document for awhile, did you accidentally close it without saving? No problem. Word 2010 lets you recover draft versions of recently edited files as easily as opening any file, even if you never saved the document.


8
Transcend communication barriers. Word 2010 helps you work and communicate effectively across different languages. Translate a word, phrase, or document more easily than before. Set separate language settings for ScreenTips, Help content, and displays. And, get additional assistance for English as a second language with English text-to-speech playback.


9
Insert screenshots and handwriting into your documents.Capture and insert screenshots directly from Word 2010 to quickly and easily incorporate visual illustrations into your work. When you use a tablet-enabled device such as a Tablet PC or Wacom tablet, you get improved tools for formatting ink as easily as you format shapes.


10
Accomplish more with an enhanced user experience. Word 2010 simplifies how you access features. The new Microsoft Office Backstage™ view replaces the traditional File menu to let you save, share, print, and publish your documents with just a few clicks. With the improved Ribbon, you can access your favourite commands even more quickly by customizing tabs or creating your own to personalize the experience to your work style.

Microsoft Excel 2010 makes it possible to analyze, manage, and share information in more ways than ever before, helping you make better, smarter decisions. New data analysis and visualization tools help you track and highlight important data trends. Easily upload your files to the Web and work simultaneously with others online. Access your important data on the go from almost any Web browser.
Whether you’re producing financial reports or managing personal expenses, Excel 2010 gives you more efficiency and flexibility to accomplish your goals.

1
Create data charts in a single cell. With Sparklines, a new feature in Excel 2010, you can create small charts in a single cell to quickly discover patterns in your data. It’s a quick and easy way to highlight important data trends such as seasonal increases or decreases, saving you time.


2
Zero in on the right data points quickly. Excel 2010 delivers a new and exciting filter enhancement for your PivotTables. The Slicer feature provides you with a rich visualization of your PivotTable view so you can dynamically segment and filter the data to display precisely what you need. With the new search filter, you can spend less time sifting through large data sets in your tables and PivotTable views, and more time analyzing.


3
Efficiently model and analyze almost any data. The PowerPivot for Excel add-in, a free download, provides groundbreaking technology such as streamlined integration of data from multiple sources and lightning-fast manipulation of large data sets with up to millions of rows. Business users can effortlessly publish and share analysis through Microsoft SharePoint Server 2010, and have other users enjoy the same Slicer, PivotTable, and fast-query capabilities when working on their Excel Services report.


4
Access your spreadsheets from virtually anywhere. Post your spreadsheets online and then access, view, and edit wherever from just about any computer or your Windows phone. With Excel 2010, you can take advantage of a best-in-class spreadsheet experience across multiple locations and devices.
Microsoft Excel Web App. Edit workbooks in a Web browser when you’re away from your office, home, or school without compromising the quality of your viewing experience.

Microsoft Excel Mobile 2010. Stay current and take immediate action when necessary using the mobile version of Excel specifically suited to your smartphone.


5
Connect, share, and accomplish more when working together. Co-authoring through the Microsoft Excel Web App makes it possible for you to edit the same spreadsheet with others simultaneously from different locations. See changes from others appear as they are made and with the number of editors in the workbook shown on the status bar, you’ll always know who else is editing the workbook with you.


6
Add more sophistication to your data presentations. Conditional Formatting in Excel 2010 gives you more control over styles and icons, improved data bars, and the ability to highlight specific items in a few clicks. You also can display data bars for negative values to more accurately illustrate your data visuals.


7
Take advantage of more interactive and dynamic PivotCharts. Quickly gather more insights with the ability to display different data views directly in a PivotChart, independent of PivotTable views, to analyze and capture the most compelling picture of your numbers.


8
Do things easier and faster. Excel 2010 simplifies how you access features. The new Microsoft Office Backstage™ view replaces the traditional File menu to let you save, share, print, and publish your spreadsheets with just a few clicks. And, with the improved Ribbon, you can access your favorite commands even more quickly by customizing tabs or creating your own to personalize the experience to your work style.


9
Harness more power for building bigger, more complex spreadsheets. Power users and analysts rejoice! With the new 64-bit version of Excel 2010, massive amounts of information are easier to analyze than ever before. Analyze large, complex datasets greater than the 2-gigabyte file size of previous Excel versions.


10
Publish and share through Excel Services. SharePoint Server 2010 and Excel Services integration lets business users share analysis and results across their organization by publishing spreadsheets to the Web. Build a business intelligence dashboard and share sensitive business information more broadly with co-workers, customers, and business partners in a security-enhanced environment.

Microsoft Outlook offers premium business and personal e-mail management tools to more than 500 million users worldwide. With the release of Outlook 2010, you get a richer set of experiences to meet your communication needs at work, home, and school. From a redesigned look to advanced e-mail organization, search, communication, and social networking features, Outlook 2010 provides you with a world-class experience to stay productive and in touch with your personal and business networks. Want information on Outlook 2010 with customer and contact management features? Please see Top 10 benefits of Outlook 2010 with Business Contact Manager.

Top 10 benefits of Outlook 2010
1
Manage multiple e-mail accounts from one place. You can easily manage e-mail messages from multiple mailboxes. Synchronize multiple e-mail accounts from services such as Hotmail, Gmail, or just about any other provider to Outlook 2010. Improved connectivity with Microsoft Exchange Server supports the use and management of multiple Exchange Server e-mail accounts in one location.


2
Manage large volumes of e-mail with ease. Conversation view in Outlook 2010 improves the tracking of e-mail conversations—reducing information overload—and helps you manage large amounts of e-mail with ease. Entire conversations can be condensed and categorized with a single click. And, new conversation management tools enable you to save valuable inbox space by turning dozens of e-mails into just a few conversations using the Clean Up feature. Or, use the Ignore feature to send the entire conversation to your Deleted Items.



3
Customize common tasks into single-click commands. Create and save custom actions in a new way with Quick Steps in Outlook 2010. You can save time by creating and defining multistep tasks that you can execute with a single click, including reply and delete, move to a specific folder, create a new e-mail to assigned groups, and more.


4
Make scheduling a breeze. Conveniently and efficiently schedule appointments, share your calendar availability and manage your work schedule. With the E-mail Calendar feature, you can send your schedule to others so they can quickly find time for your next appointment. And, the new Schedule View provides a horizontal display of multiple calendars. New calendar management tools enable you to save frequently used groups of calendars so they can be quickly redisplayed whenever you need them.


5
Search to easily find what you’re looking for. With Outlook 2010, you can easily sort through high volumes of data. The enhanced Search Tools provide you with ways to quickly find and manage large quantities of e-mail, calendar, and contact items.



6
Create e-mail messages that capture attention. Dynamic graphics and picture editing tools are not just for Word and PowerPoint anymore. With Outlook 2010, you can grab your readers’ attention by using compelling visuals such as pre-built SmartArt™ graphics, Office themes, and Styles. You also can more easily bring your ideas across to your readers by inserting and formatting screenshots in Outlook.



7
Stay connected to your social and business networks.Outlook 2010 is your hub for friends, family, and colleagues. Use Outlook Social Connector to get additional information about people, such as mutual friends and other social information, while staying better connected to your social and business circles.


8
Ensure that your e-mail messages get to the intended audience.For business users, sending unnecessary e-mail messages to out-of-office contacts, accidentally replying to a large distribution list, or distributing confidential information outside the company are frequent concerns. With the new MailTips feature, you’re alerted when you are about to send e-mail to a large distribution list, to someone who is out of the office or to individuals outside the organization.


9
Receive voice mail transcripts in your inbox. With Outlook 2010 and new technology in Exchange Server 2010, voice messages are automatically transcribed. A voice-to-text preview of a recorded voice message is sent along with the voice mail recording directly to your inbox. Access them from almost anywhere using your computer, Microsoft Outlook Mobile, or Microsoft Outlook Web App.


10
Initiate live conversations from Outlook. Keep in touch with your contacts. By using Office Communicator, or your instant messaging application, Outlook 2010 provides presence and status information for those on your buddy or contact list. Hover over a name, see their availability and then easily initiate a conversation directly through instant messaging. With Office Communicator, you can start a voice call without leaving Outlook.

Microsoft PowerPoint 2010 gives you more ways to create and share dynamic presentations with your audience than ever before. Exciting new audio and visual capabilities help you tell a crisp, cinematic story that’s as easy to create as it is powerful to watch. With new and improved tools for video and photo editing, dramatic new transitions, and realistic animation, you can add polish to presentations that will captivate your audience. In addition, PowerPoint 2010 enables you to work simultaneously with other people or post your presentation online and access it from virtually anywhere using the Web or your smartphone.

Top 10 benefits of PowerPoint 2010
1
Bring more energy and visual impact to your presentations. Save time and money by applying sophisticated photo effects without using additional photo-editing software programs. Transform your images into compelling, vibrant visuals by using new and improved picture editing features such as colour saturation and temperature, brightness and contrast, and an advanced cropping tool, along with artistic filters such as blur, paintbrush, and watercolour.


2
Work with others without having to wait your turn. PowerPoint 2010 redefines the way people can work together on presentations. With co-authoring, you can simultaneously edit the same presentation with individuals in different locations. You can also use Office Communicator or your instant messaging application to view the availability of others who are authoring a presentation with you and easily initiate a conversation without leaving PowerPoint.


3
Add a personalised video experience. Embed and edit video files directly in PowerPoint 2010. Easily trim your video to show only relevant sections. Bookmark key points in a video for quick access or trigger animation to begin automatically when those bookmarks are reached. You can also set the video to fade in and out at specified intervals and apply a variety of video styles and effects—such as reflections, bevels, and 3-D rotation—to help you quickly capture your audience’s attention.


4
Imagine just-in-time show and tell. Instantly broadcast your PowerPoint 2010 presentations by sending out a URL so people can view your presentation on the Web. Your audience sees your slides in high fidelity, even if they don’t have PowerPoint installed. You can also turn your presentation into a high-quality video with narration to share with virtually anyone through e-mail, via the Web, or on DVD.


5
Access your presentations from more locations and on more devices. Post your presentations online and then access, view, and edit them from the Web4 or your Windows phone. With PowerPoint 2010, you can get things done according to your schedule across multiple locations and devices.
Microsoft PowerPoint Web App. Extend your PowerPoint experience to the Web and enjoy full-screen, high-quality viewing of our presentations. Store your presentations online and edit your work through the PowerPoint Web App when you're away from your office, home, or school.

Microsoft PowerPoint Mobile 2010. Stay current and take immediate action when necessary using an enhanced mobile version of PowerPoint specifically suited to your smartphone.


6
Create high-quality presentations with stunning graphics. You don’t have to be a design expert to create professional-looking graphics. Use dozens of additional SmartArt® layouts to create many types of graphics such as organization charts, lists, and picture diagrams. Transform words into impressive visuals that better illustrate your ideas. Create diagrams as easily as typing a bulleted list or convert text and images to a diagram in just a few clicks.


7
Captivate your audience with new transitions and improved animations. PowerPoint 2010 offers new, dynamic slide transitions and animation effects that look similar to graphics you’d see on TV. Easily access, preview, apply, customize, and replace animations. You can also use the new Animation Painter to easily copy animations from one object to another.


8
Organize and print your slides more effectively.Easily organize and navigate through slides using slide sections. Divide a presentation into logical slide groups, rename sections to help you manage content—such as to assign slides to a particular author—or easily print just one section of slides.


9
Get things done faster. PowerPoint 2010 simplifies how you access features. The new Microsoft Office Backstage™ view replaces the traditional file menu to let you save, share, print, and publish your presentations with just a few clicks. And, with the improved Ribbon, you can access your favorite commands even more quickly by customizing tabs or creating your own to personalize the experience to your work style.


10
Work on multiple presentations and multiple monitors. PowerPoint 2010 gives you a completely separate window for each presentation that you open. So, you can view and edit multiple presentations independently, side-by-side, or even on separate monitors.

Microsoft Access 2010 is all about simplicity. Access 2010 empowers you to make the most of your information—even if you’re not a database expert. And, through newly added Web databases, it amplifies the power of your data, making it easier to track, report, and share with others. Your data will never be further away than your closest Web browser.

Top 10 benefits of Access 2010
1
Get started faster and easier than ever before.

Harness the power of the community in Access 2010. Build on database templates created by others and share your own designs. Use new prebuilt database templates available on Office Online, designed for frequently requested tasks, or select from community-submitted templates and customize them to meet your specific needs.


2
Create a centralized landing pad for your data.

Integrate your Access reports using multiple data connections and information linked or imported from other sources. With improved Conditional Formatting and calculation tools, you can create rich and dynamic reports with visual impact. Access 2010 reports now support data bars, enabling you and your audience to more easily track trends and gain insight.


3
Access your application, data, or forms from virtually anywhere.

Extend your database to the Web so that users without an Access client can open Web forms and reports via a browser and changes are automatically synchronized. Or work on your Web database offline, make your design and data changes, and then sync them to Microsoft SharePoint Server 2010 when you’re reconnected. With Access 2010 and SharePoint Server 2010, your data can be protected centrally to meet data compliance, backup, and audit requirements, providing you with increased accessibility and manageability.


4
Apply professional designs across your Access database.

Take advantage of familiar and appealing Office themes and apply them to your databases with high fidelity both on the Access client and the Web. Choose from a variety of themes, or design your own custom theme, to get great looking forms and reports.


5
Add navigation to your database using drag-and-drop functionality.

Create professional looking, Web-like navigation forms to make your frequently used forms or reports more accessible without writing any code or logic. Choose from six predefined navigation templates with a combination of horizontal tabs or vertical tabs. Applications with a large number of Access forms or reports can be displayed using multi-level horizontal tabs. Simply drag-and-drop forms or reports to display.


6
Accomplish your work more quickly and easily.

Access 2010 simplifies how you find and use features. The new Microsoft Office Backstage™ view replaces the traditional File menu to let you publish, back up, and manage your database with just a few clicks. And, with the improved Ribbon, you can access your favourite commands even more quickly by customizing tabs or creating your own to personalize the experience to your work style.


7
Build your expressions effortlessly using IntelliSense.

The simplified Expression Builder makes it faster and easier for you to build out logic and expressions in your database. IntelliSense — Quick Info, ToolTips, and AutoComplete — enables you to reduce errors, spend less time memorizing expression names and syntax, and spend more time focusing on building application logic.


8
Design your macros faster than before.

Access 2010 has a revamped Macro Designer that makes it easier to create, edit, and automate database logic. The Macro Designer enables you to be more productive, reduce coding errors, and easily incorporate more complex logic to create robust applications. Increase code maintainability by using Data Macros to attach logic to your data, centralizing the logic on the source tables. With the more powerful Macro Designer and Data Macros, you can extend automation outside the Access client to SharePoint Web databases and other applications that update your tables.


9
Turn portions of your database into reusable templates.

Save time and effort by reusing database parts built by other users in your database. You can now save frequently used Access objects, fields, or collections of fields as templates that you can add to your existing databases and make you more productive. Application Parts can be shared across your organization to create consistency in building database applications.


10
Integrate your Access data with live Web content.

You can now connect to data sources via Web service protocol. Include Web services and line-of-business applications data right in the databases you build through Business Connectivity Services. 2 And, the new Web Browser control enables you to integrate Web 2.0 content in your Access forms.

The advanced diagramming tools of Visio 2010 help you simplify complexity with dynamic, data-driven visuals and new ways to share on the Web in real-time.

Start by building your diagram with professional-looking templates and modern, pre-drawn shapes. Then, easily link your diagram to popular data sources (such as Excel). You’ll see data automatically refresh right within your diagram, reflected in vibrant visuals such as icons, symbols, colours, and bar graphs. Finally, with just a few clicks, publish your data-linked diagram to SharePoint, and provide access to others on the Web, even if they don’t have Visio.

Together, simplicity, data-driven shapes, and Web sharing make Visio 2010 one of the most powerful ways to see and understand important information.

1
Jump-start diagramming with templates. With modern, pre-drawn shapes, intelligent templates, and sample drawings, Visio 2010 offers a wide variety of options to meet your diagramming needs for IT, business, process management, and more.


2
Find and access the tools you need quickly. Every step in creating a diagram is more intuitive, with the logical groupings of features in Ribbon tabs, an enhanced Shapes window for easy access to shapes and stencils, and a new status bar that helps you move more efficiently within and between your diagrams.


3
Draw diagrams faster with improved automatic features. Whether you are creating a diagram from scratch, or modifying an existing diagram, Visio 2010 helps you add and align shapes easily and accurately with features such as the Quick Shapes Mini Toolbar, enhanced dynamic grid, page Auto Size, and automatic alignment and layout adjustment.


4
Simplify large and complex diagrams. Add clarity to diagrams using Subprocesses and Containers to group related shapes visually and logically. As a diagram grows larger or becomes more complex, Subprocesses and Containers help you to keep information more organized and understandable.


5
Make your diagrams professional-looking and appealing in seconds. Visio 2010 helps you make diagrams look attractive with a wide range of formatting tools and design options, including modern shapes and visuals, a rich gallery of themes, and Live Preview.


6
Bring your diagrams to life with real-time data. See the entire picture with dynamic, data-driven diagrams. Simply connect your diagram to one or more data sources such as Excel or SQL Server. Then, display real-time data right within your diagrams, based on conditions you define, using vibrant colors, icons, symbols, and data bars.


7
Share diagrams with others on the Web. Easily share dynamic, data-linked Visio diagrams in Microsoft SharePoint Server. Online users can see your real-time information in their browsers at a high level, right on the diagram, or delve into the details—even if they don’t own Visio. They can pan and zoom in the diagram, follow hyperlinks in shapes, and refresh the data.


8
Ensure consistency and accuracy with diagram validation. Check for common errors and support diagramming standards across your organization using diagram validation. With one click, you can validate a diagram against a set of rules to make sure it’s logical and properly constructed.


9
Model and monitor SharePoint workflows. Create and monitor SharePoint workflows more easily than ever with a new, advanced template that contains SharePoint workflow rules and logic, and supports the ability to export and import workflows between Microsoft SharePoint Designer 2010 and Visio 2010.


10
Create visual mashups using Visio Services. Publish and share visually compelling dashboards that contain interactive Visio diagrams and other application services. Visio Services and SharePoint Server integration supports visual mashups of actionable data and diagrams for an information-rich viewing experience.

Microsoft® Project 2010 delivers powerful, visually enhanced ways to effectively manage a wide range of projects and programs. From meeting crucial deadlines to selecting the right resources and empowering your teams, Project 2010 offers easier and more intuitive experiences to help you simply be more productive and realize amazing results.

1. Familiar and intuitive.

The Ribbon makes finding and using your favourite tools simpler with new graphical menus and a familiar experience to help you easily create and manage projects. Tooltips and contextual guidance provide information and shortcuts so you can accomplish more in less time. In the new Microsoft® Office Backstage™ view, simply save, share, print, or publish your projects from one location.


2. Save time and effort.

Save time and effort with familiar and essential functions like text wrapping, filtering, auto-complete, scroll and zoom, and more. Insert new columns on the fly—data types are readily identified so that you can quickly and effectively organize and analyze details. Quickly share schedule details through enhanced copy-and-paste, and retain key formatting between Project 2010 and other Microsoft Office applications.


3. Flexible and powerful.

User-controlled scheduling puts you in control and brings together the flexibility and ease of use of a tool like Microsoft Excel® 2010 and the power of the Project 2010 scheduling engine. Create project schedules at the level of detail that’s right for your project. Work with summary data initially or shift to a more detailed approach when it’s convenient. Place notes as reminders of where additional schedule information is needed, or simply add information as it becomes available.


4. Easier to see and share.

With a completely new and visually enhanced timeline view, you’ll have a clearer view of tasks, milestones, and phases. Newly expanded color palettes and text effects help you make every timeline and plan look their best—and help you to swiftly see and share important dates and deliverables.


5. At-a-glance.

(Team Planner – Pro only)

See the right mix of people and resources: simply drag tasks to effectively plan work for your entire team and project. The new Team Planner view in Project Professional 2010 shows resources and work over time, to help you spot problems and resolve issues. New in Project 2010, the Task Inspector offers additional analysis and intuitive guidance to resolve scheduling conflicts derived from a task’s attributes and assigned resources, which you can choose to act upon or not.


6. Control and deliver.

Quickly compare budget versus actual versus forecasted values to measure an initiative's progress with the flexibility of setting multiple baselines. Create high-level time-phased budgets with user-defined categories for costs and labor. Validate budgets against bottom-up estimates built by using labor, material, and cost resources. Control project costs by comparing budgets to completed tasks and forecasted totals. Use built-in earned-value metrics for predictive analysis and integrated performance management.


7. Evaluate possibilities.

(Inactive Tasks – Pro only)

Often you'll need to evaluate scenarios and consider options when planning new projects or monitoring ongoing work. Using inactive tasks, new in Project Professional 2010, you can easily experiment with your project plan and perform what-if analysis. A simple toggle removes or inserts one or more tasks, along with their effect on the project schedule. Project 2010 also offers more built-in tools to help support what-if analysis and scenario comparison, including multiple-level undo and change highlighting.


8. Collaborate with others.

(Task Status Updates – Pro only)

Connect your teams by synchronizing with Microsoft SharePoint® Foundation 2010. Using Project Professional 2010, you can synchronize SharePoint Foundation 2010 and Project Professional 2010 project task status updates for you and your team members. You can also save your project files to SharePoint Foundation 2010 team sites to communicate plans and collaborate on progress.


9. Grow capabilities.

(Connect to Project Server 2010 – Pro only)

Realize the power of unified project and portfolio management by combining Project Professional 2010 with Microsoft Project Server 2010. Together, Project Professional 2010 and Project Server 2010 create the Microsoft Enterprise Project Management (EPM) Solution, and deliver end-to-end capabilities to help organizations prioritize investments and optimize resources, gain control of all types of work, and visualize performance by using powerful dashboards.


10. Enhance performance.

Use the 64-bit options of Project 2010 to enhance performance and support very large projects and programs. Project Standard 2010 and Project Professional 2010 are offered in 32-bit and 64-bit options to support a diverse range of project types and sizes. 64-bit options take advantage of the expanded memory and optimized capabilities of the latest processors and of the 64-bit versions of Windows 7 and Windows Vista. 64-bit Project Professional 2010 also offers enhanced performance and handles extremely large project files with ease when connected to Project Server 2010.