Getting Started With Microsoft Office 2010 Tutorial

Name: Getting Started With Microsoft Office 2010 Tutorial
Rating: 3.6 (14 reviews)

This Microsoft Office 2010 tutorial will quickly get you up to speed. Taught by an expert trainer.

Created byInfinite Skills

Last updated 1/2017

English

English [Auto],

Course content

11 sections • 53 lectures • 4h 30m total length

Working Files - Download These First0:01
What's New In Office 2010?4:16
Discover what’s new in Microsoft Office 2010, including backstage view, customizable ribbons, and improved editing across Word, Excel, and PowerPoint, plus Office Web Apps for real-time collaboration.
What Comes With Office 2010?2:40
Office 2010 comes in five suites, with three across the counter—home and student, home and business, and professional—and two volume licenses: Office Standard and Office Professional Plus.
Backstage View The New File Menu6:58
Explore the backstage file menu in Word 2010, including file operations, properties, recent and pinned documents, print setup and preview, and sharing options.
The Power To Create Customized Ribbons4:53
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.
Office 2010 File Format Issues6:02
Understand how office 2010 file formats affect cross-version compatibility, save-as options, and macro security, ensuring files open smoothly across 2007, 2003, and earlier apps.
Using The Files Included With This Course0:40
Access the working files download area to locate the simple 2000 database, Excel files, a birthday PowerPoint, publish your files, Word documents, and plain text files used in the course.

Getting Started With Word 2010 5:04
Explore Word 2010’s ribbon-based interface, including the file, home, insert, and developer ribbons, with context-sensitive tools, dialog boxes, and floaty toolbars that streamline formatting.
What's New For Word 20102:41
Word 2010 updates the file menu and print options, introduces a customizable ribbon with a new tab, and adds context-sensitive picture tools, background removal, and online translation.
Translation Services Within Word 20104:45
Explore Word 2010 translation tools, including translate document and mini translator with hover word translations. Use online services and language pairs to translate selected text via the research pane.
Image Enhancement Improvements In Word 20106:29
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.
Mail Merging Made Easy In 20107:20
Learn how to perform mail merge in Word 2010 by connecting a data source to a letter, inserting merge fields, previewing results, and finishing the merge to create personalized documents.

Getting Started With Excel 20103:41
Explore Excel 2010 basics, including the file menu, home and insert tabs, clipboard options, format cells dialog, and the developer ribbon, plus three sheets per workbook.
What's New For Excel 20106:33
Explore Excel 2010's enhancements, including the redesigned file menu and ribbon, new templates and sharing options, plus table and pivot table features like slicers, remove duplicates, and export to SharePoint.
Using Formulas In Excel 20106:15
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.
Working With Named Data Ranges7:35
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.
The Data Slicer In Excel 20107:33
Explore how the data slicer in Excel 2010 works with pivot tables to filter by status, department, marital status, and more, using movable and resizable slicer boxes.
Create A Chart In Excel 2010 In 2 Seconds3:00
Create charts in Excel 2010 in two seconds by selecting non-consecutive data and pressing F11, then switch chart types, apply styles, and set a default chart.

Getting Started With PowerPoint 20107:16
Explore PowerPoint 2010 basics, the ribbon interface, file options, and starting a new presentation from templates. Insert content, adjust layouts, apply transitions and animations, and view or share your slides.
What's New For PowerPoint 20105:55
Explore PowerPoint 2010's major updates, including a redesigned file menu with quick info access, recent presentations, print preview, sharing options, plus enhanced ribbon customization and video editing.
Adding An Organization Chart7:25
Learn to add an organization chart in PowerPoint 2010 using SmartArt hierarchy, choose layouts, add subordinates, insert pictures, and customize colors for clear presentation.
Running A Slide Show5:19
Learn to run a PowerPoint slide show from the beginning or current slide, use keyboard shortcuts for navigation, blank or blackout the screen, and annotate with a pen before exiting.
Using The Picture Gallery Tool3:34
Explore PowerPoint 2010's picture gallery to create a photo album slideshow from selected images, insert via the insert menu, order slides, add text, and save.
Create A Video From Your Presentation3:43
Export your PowerPoint as a video via the share option, set slide timings or record narration, and save as a Windows Media file for online viewing or DVD.
Create A CD From Your Presentation4:56
Package a PowerPoint presentation for cd by using the package for cd option, including linked files, embedded items, and fonts, with optional password protection, ready to copy to cd.

Getting Started With Outlook 20109:26
Explore Outlook 2010 basics by navigating the ribbon, composing and sending emails, and organizing mail with folders, favorites, and rules; switch between mail, calendar, contacts, and tasks.
What's New For Outlook 20109:45
Explore Outlook 2010's ribbon-based interface, the redesigned file menu, and integrated mail, calendar, contacts, and tasks that enable swifter connections and streamlined management.
Setting Up An Email Account For Hotmail2:45
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.
Setting Up An Email Account For A POP3 Account3:56
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.
Adding An Appointment To The Calender4:49
Learn how to add appointments in Outlook 2010 across day, work week, week, and month views, using new appointment, typing details, and dragging to resize or move.

Getting Started With Access 20105:53
Open and explore Microsoft Access 2010 by starting from the desktop, loading an existing database, and navigating objects grouped by type, including tables, queries, forms, and reports.
What's New For Access 20109:48
Discover Access 2010’s new file menu, SharePoint integration, encryption, and tools like compact and repair and database analyzer to manage databases with templates.
Creating A Database From A 2010 Template4:35
Explore how to create a database quickly in Access 2010 by using a contact management template from Office.com, download and customize tables, queries, macros, forms, and mailing labels.
Creating A 2010 Access Query4:55
Learn to create an access 2010 query with query design, join the employees table and the chefs table with a left outer join, and filter for non-share purchases by date.
Adding A Macro To Access 201012:19
Learn to add a macro to an Access 2010 database, using the macro designer and action catalog to perform salary updates by amount or percentage with conditional checks.

Getting Started With Publisher 20105:38
Learn to create publications in Publisher 2010 using templates for brochures and newsletters, placing text and images in frames, and printing with duplex options.
What's New For Publisher 201010:10
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.
Creating A Product Catalog5:57
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.
A Quick 2012 Calender3:43
Learn to create a 2012 calendar in Publisher using calendar templates and one-year-per-page layout. Customize each page with photos, adjust cropping, and publish.
Linked Or Embedded Images You Decide With The New Graphics Manager4:18
Explore when to link or embed images in publisher 2010 using the graphics manager, compare file sizes, update links, and convert between linked and embedded images.

OneNote 2010 - What Is It?4:15
Explore OneNote 2010 to understand its notebook structure with sections and pages. Create and rename sections and pages, and auto save as you work across notebooks.
Screen Capture Using OneNote1:48
Capture content from other programs with OneNote, insert screen clips into notes, adjust and move clips, and rely on automatic saving as you work.
Adding Sound And Video Recordings To OneNote2:01
learn how to insert and playback audio and video recordings in OneNote using the insert ribbon, adjust quality and device settings, and record video with a webcam.
Adding External Documents To OneNote 20103:10
Learn to insert external documents into OneNote 2010 by attaching files or adding file printouts, including Word, Excel, and PowerPoint, with options for live links or on-screen copies.

Getting Signed Up For A Windows Live Account2:49
Create and sign in to a Windows Live account (Windows Live ID), set up a user name and email, and enable Office 2010 web apps for sharing calendars and presentations.
Sharing An Outlook Calender Via The Internet7:30
Create a new calendar in Outlook, publish it online with a Windows Live ID, and share via office.com so others can subscribe and view with chosen permissions.
Broadcast A PowerPoint Presentation Across The Internet4:25
PowerPoint 2010 lets you broadcast a slideshow live on the web. Viewers see the same slides as you advance, with the link shared by email.
Getting Started With Web Apps5:12
Learn to save Word, Excel, and PowerPoint files to Microsoft Sky Drive from Office 2010, then access and edit them via a web browser using Windows Live ID.
Accessing Your SkyDrive Files Online With Web Apps4:03
Learn to access your SkyDrive files online with web apps, sign in with Windows Live ID, and manage, share, or edit documents across devices.

Embedding Or Linking Office Documents Inside Office Documents5:04
Show how to embed or link Excel data in PowerPoint or Word using paste special, comparing embedded objects with linked files and explaining update and save behavior.
Word Mail Merge Using Excel Or Access Data4:06
Attach a Word mail merge document to a data source such as an Access database or Excel file, then match fields, preview results, and switch sources as needed.
Email Office Files From Their Relevant Application2:38
Explore how office applications integrate with Outlook to send Excel, Word, or PowerPoint files as attachments or pda, and view them in Adobe Reader.

Description

A Verifiable Certificate of Completion is presented to all students who undertake this course.

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

Getting Started With Microsoft Office 2010 Tutorial

Explore related topics

Course content

Office 2010 Introduction7 lectures • 26min

Office Word 20105 lectures • 26min

Office Excel 20106 lectures • 35min

Office PowerPoint 20107 lectures • 38min

Office Outlook 20105 lectures • 31min

Office Access 20105 lectures • 38min

Office Publisher 20105 lectures • 30min

Office OneNote 20104 lectures • 11min

Windows Live And Web Apps5 lectures • 24min

Office 2010 Integration3 lectures • 12min

Description

A Verifiable Certificate of Completion is presented to all students who undertake this course.