
Learn how to create and customize a ribbon tab in Microsoft Office 2010, including adding groups, placing commands, and renaming macros, to tailor the top ribbon to your needs.
Explore Word 2010's picture enhancement tools, including rotate, crop, artistic effects, brightness and contrast adjustments, and compression for print, screen, or email, plus screenshot clipping.
Explore how to use Excel 2010 formulas, access the function library from the home ribbon or formulas tab, and insert functions like sum, average, count, max, and min with arguments.
Explore using named ranges in Excel to replace cell references, apply vlookup with exact matches, and create range names like months and sales to simplify formulas across worksheets.
Set up a Hotmail email account in Outlook 2010 using the setup wizard to auto configure server settings. Connect via the Hotmail connector to access the inbox.
Set up a new POP3 email account in Outlook 2010 by manually configuring incoming and outgoing servers, enabling authentication, and completing the test before finishing.
Discover Access 2010’s new file menu, SharePoint integration, encryption, and tools like compact and repair and database analyzer to manage databases with templates.
Explore Publisher 2010's ribbon interface, file and info menus, and new tools for mail merge, data catalogs, and enhanced templates, designs, and print settings.
Create a product catalog in Publisher 2010 by importing a data file, selecting a landscape blank layout, linking a data source, configuring fields, attaching images, and merging for publication.
Capture content from other programs with OneNote, insert screen clips into notes, adjust and move clips, and rely on automatic saving as you work.
Explore how office applications integrate with Outlook to send Excel, Word, or PowerPoint files as attachments or pda, and view them in Adobe Reader.
This Getting Started with MS Office 2010 training course offers a practical launching point for the suite's many features and tools, from key functionality that has been with the software to the many new features that have been introduced. The whole point of the series is to give you the confidence and understanding you need to get productive and creative on your own in a minimal amount of time. From core tools such as Excel, Word and Powerpoint to accessories such as OneNote and Windows Live Apps, the author explains each program's functionality and gives you the push you need to get started on the right track. Perfect for users who are totally new to MS Office as well as those migrating from older editions, this course goes through the unique features of the new ribbon interface, covers key tasks in each application and explores how the programs can be used together in larger workflows. This is an excellent primer before moving into more detailed InfiniteSkills courses on Microsoft programs.
What You Will Learn
- How to navigate and work within the Microsoft Office productivity suite and its tools, including Word, Excel, Access, Powerpoint, Publisher and OneNote.
- How to configure and create basic documents, emails, spreadsheets, and presentations with the world's leading office communication and productivity tools.
- How to use these core programs within a collaborative environment involving multiple users and workflow involving multiple applications.
Who Should Take This Course
- Anyone who needs an understanding of Microsoft Office software as it applies to a professional, academic, or personal environment.
- New users who want a very easy to understand introduction to the purpose of MS Office programs and their new features.
- Users of old versions of Microsoft Office tools wanting to know what MS Office 2010 has to offer.
What People Are Saying
"Coming over from Office XP, it seemed like quite a bit had changed. These lessons helped me get my bearings, and led me to some of the awesome advanced courses also narrated by Guy."
- Daniel E Clyburn
"Very basic, straightforward office training, but just what I needed to get set up and started for my small business. Thank you."
- Pat LeFebvre