Preferred method of contact:

Microsoft Office: 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 Enrolment: 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: $2745   Government: $2415

Feb 7 - 9 (3 Days)
9:00 AM - 4:30 PM EST
Alexandria, VA / Online (AnyWare) Alexandria, VA / 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

Jun 27 - 29 (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

Aug 15 - 17 (3 Days)
9:00 AM - 4:30 PM EDT
New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Guaranteed to Run

Private Team Training

Enroling 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

$2745

Government

$2415

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 Learning Tree course exam on the last day of your course or online at any time after class 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


FREE Online Course Exam (if applicable) – Last Day:3:30 pm – 4:30 pm


By successfully completing your FREE online course exam, you will:

  • Earn College Credit Units — Many Learning Tree courses are recommended for College Credits, which are accepted by over 2,000 colleges and universities, and may qualify you to receive Tuition Reimbursement.
  • Receive a Certificate of Achievement with the designation "Awarded with Distinction."

Each Course Day - Informal discussion with instructor about your projects or areas of special interest:4:30 pm – 5:30 pm

“I definitely recommend taking a Learning Tree Course. The comprehensive materials, the excellent instructor, the hands-on exercises—I don’t think you can beat it.”

- B. Williams, LAN Administrator
TWD

Prev
Next
Chat Now

Please Choose a Language

Canada - English

Canada - Français