Preferred method of contact:

Microsoft Office Training: Streamlining Tasks

COURSE TYPE

Foundation

Course Number

972

Duration

3 Days

PDF Add to WishList

Improve your efficiency and productivity by leveraging the power of Microsoft Office applications. With this training, you gain the knowledge to use the extensive features of Microsoft Word, Excel, and PowerPoint — including integration techniques. The hands-on exercises in this course are designed to maximize your contribution to organizational decision-making capabilities and competitiveness.

You Will Learn How To

  • Leverage the extensive features in Word, Excel, and PowerPoint
  • Streamline Office functionality by customizing the user interface
  • Build professional documents in Word with enhanced functionality
  • Quickly present and summarize data with Excel using PivotTables and PivotCharts
  • Create visually dynamic and effective presentations in PowerPoint

Important Course Information

Recommended Experience:

  • Experience with Office applications at an introductory level

Software:

  • This course is based on Office 2013, but is applicable to earlier versions of Office

Course Outline

  • Introducing Microsoft Office
  • Comparing differences between Office versions
  • Integrating Office with the cloud
  • Retrieving documents using SkyDrive
  • Developing documents in Microsoft Word

Preparing the document

  • Formatting legacy documents quickly
  • Maintaining consistency with Themes
  • Navigating and globally formatting text using Styles

Controlling the document setup

  • Managing documents with Sections
  • Creating custom Section headers and footers

Speeding up document creation

  • Applying reusable content with AutoText
  • Maintaining content with the Building Block Organizer
  • Finishing Documents with Microsoft Word

Managing graphics within a document

  • Inserting images using Guides
  • Manipulating images with graphic tools

Adding hyperlinks, references and tables of contents (TOC)

  • Creating hyperlinks to internal and external documents
  • Adding and modifying an automatic TOC
  • Navigating the document using the TOC and hyperlinks

Proofing and protecting the final document

  • Avoiding mistakes with AutoCorrect
  • Preparing the document for multiple devices
  • Managing document versions
  • Storing the document on SkyDrive
  • Configuring Microsoft Excel

Customizing the user interface

  • Navigating the worksheet with shortcut keys
  • Personalizing the Ribbon and Quick Access Toolbar

Patterning data with AutoFill and Flash Fill

  • Filling list-based information with AutoFill
  • Interpreting data with Flash Fill

Refining data with functions and formulas

  • Applying cell references and Named Ranges
  • Implementing conditional logic using the IF function
  • Presenting Data with Microsoft Excel

Filtering data with conditional formatting

  • Displaying data via text or cell formatting and Filter Search
  • Interpreting data using data bars, color scales and Icon sets

Graphing and charting data

  • Analyzing data rapidly with advanced charting tools
  • Changing chart displays via data selection

Collaborating with Mail Merge in Word

  • Preparing requirements for variable data documents
  • Creating a Mail Merge
  • Setting up a PowerPoint Presentation

Customizing the work area

  • Leveraging views to maximize PowerPoint effectiveness
  • Implementing good presentation design with Slide Master, Master Layouts and Notes Master

Developing a presentation

  • Managing large presentations with Sections
  • Reusing slides from external files
  • Editing content quickly using outlines from Word

Presenting multimedia options

  • Formatting default text boxes
  • Facilitating presentation creation with Alignment guides
  • Turning bulleted lists into graphics via SmartArt
  • Inserting video, audio and tables
  • Finishing a PowerPoint Presentation

Drawing attention to graphics

  • Intensifying a presentation with Transitions, Animations and Motion paths
  • Emphasizing graphics with dynamic custom Motion paths
  • Timing the Slide Show with transitions and animations

Packaging the presentation

  • Protecting the presentation
  • Sharing the presentation via SkyDrive
Show complete outline
Show Less

Convenient Ways to Attend This Instructor-Led Course

Hassle-Free Enrollment: No advance payment required to reserve your seat.
Tuition due 30 days after you attend your course.

In the Classroom

Live, Online

Private Team Training

In the Classroom — OR — Live, Online

Tuition — Standard: $2650   Government: $2355

Aug 9 - 11 (3 Days)
9:00 AM - 4:30 PM EDT
Alexandria, VA / Online (AnyWare) Alexandria, VA / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Sep 27 - 29 (3 Days)
9:00 AM - 4:30 PM EDT
Rockville, MD / Online (AnyWare) Rockville, MD / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Feb 7 - 9 (3 Days)
9:00 AM - 4:30 PM EST
Washington, DC / Online (AnyWare) Washington, DC / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Feb 28 - Mar 2 (3 Days)
9:00 AM - 4:30 PM EST
New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Mar 28 - 30 (3 Days)
9:00 AM - 4:30 PM EDT
Rockville, MD / Online (AnyWare) Rockville, MD / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Guaranteed to Run

Private Team Training

Enrolling at least 3 people in this course? Consider bringing this (or any course that can be custom designed) to your preferred location as a private team training.

For details, call 1-888-843-8733 or Click Here »

Tuition

Standard

Government

In Classroom or
Online

Standard

$2650

Government

$2355

Private Team Training

Contact Us »

Course Tuition Includes:

After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.

After-Course Computing Sandbox
You'll be given remote access to a preconfigured virtual machine for you to redo your hands-on exercises, develop/test new code, and experiment with the same software used in your course.

Free Course Exam
You can take your course exam on the last day of your course and receive a Certificate of Achievement with the designation "Awarded with Distinction."

Prev
Next

Training Hours

Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm

FREE Online Course Exam (if applicable) – Last Day: 3:30 pm – 4:30 pm
By successfully completing your FREE online course exam, you will:

  • Have a record of your growth and learning results
  • Bring proof of your progress back to your organization
  • Earn credits toward industry certifications (if applicable)

Enhance Your Credentials with Professional Certification

Learning Tree's comprehensive training and exam preparation guarantees that you will gain the knowledge and confidence to achieve professional certification and advance your career.

Earn 17 Credits from NASBA

This course qualifies for 17 CPE credits from the National Association of State Boards of Accountancy CPE program. Read more ...

“AnyWare is a great way to attend MS Office training without travel—thank you! The multiple whiteboard class display system was easy to read, and maximizing the shared screen allowed me to follow along with the instructor.”

- L. Hanson, Sr. Technical Training Advisor
National Rural Electric Cooperative Association

Prev
Next
Chat Now

Please Choose a Language

Canada - English

Canada - Français