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

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

Microsoft Office: Streamlining Tasks

Thank you for your interest in this event, but there are no available seats at this time. Please select another date. You may also contact a customer service representative or training advisor about your training needs, from single courses to large enterprise solutions.

You have used Passport or Voucher Number for this event. Please contact our Customer Service Representative or Training Advisor and they will work with your payment options.

Jun 27 - 29 (3 Days) 9:00 AM - 4:30 PM EDT Alexandria, VA / Online (AnyWare)
Please select the quantity Please select the quantity
Optional Discounts
?
Have a Promo Code?

Enter a promo code for additional savings.

{{vm.lineItem.$DiscountValidationMessage}} Please enter a valid Promo Code
?
Don't know your Voucher or Passport Number?

Contact us via live chat or call us at 1-888-843-8733 and one of our representatives will assist you with your order.

{{vm.lineItem.$VoucherNumberValidationMessage}} Please enter a valid Voucher or Passport Number
Your Work Email is required Please enter a valid Email
?
BY CLICKING THE GOVERNMENT BOX, YOU AGREE TO THESE TERMS OF USE; IF YOU DO NOT AGREE, LEAVE THAT BOX BLANK TO RECEIVE COMMERCIAL PRICING.

By clicking the Government box – you certify that you/your firm is eligible to receive discounted price available only to Federal, Provincial and Municipal agencies. Colleges, universities and non-for profits are not eligible for the government discount.

Learning Tree reserves the right, at its sole discretion, to change, modify, add or remove portions of these Terms of Use, at any time. It is your responsibility to ensure that you qualify to receive a Government discounted rate. Please contact your Government Account Coordinator for any questions.

Not sure if you qualify? See the ? for details. Terms and Conditions
Price
Pay now -or- pay later
Pay by credit card at checkout
-or- pay later by invoice, as always.

Added to cart

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

Microsoft Office: Streamlining Tasks

Thank you for your interest in this event, but there are no available seats at this time. Please select another date. You may also contact a customer service representative or training advisor about your training needs, from single courses to large enterprise solutions.

You have used Passport or Voucher Number for this event. Please contact our Customer Service Representative or Training Advisor and they will work with your payment options.

Aug 15 - 17 (3 Days) 9:00 AM - 4:30 PM EDT New York / Online (AnyWare)
Please select the quantity Please select the quantity
Optional Discounts
?
Have a Promo Code?

Enter a promo code for additional savings.

{{vm.lineItem.$DiscountValidationMessage}} Please enter a valid Promo Code
?
Don't know your Voucher or Passport Number?

Contact us via live chat or call us at 1-888-843-8733 and one of our representatives will assist you with your order.

{{vm.lineItem.$VoucherNumberValidationMessage}} Please enter a valid Voucher or Passport Number
Your Work Email is required Please enter a valid Email
?
BY CLICKING THE GOVERNMENT BOX, YOU AGREE TO THESE TERMS OF USE; IF YOU DO NOT AGREE, LEAVE THAT BOX BLANK TO RECEIVE COMMERCIAL PRICING.

By clicking the Government box – you certify that you/your firm is eligible to receive discounted price available only to Federal, Provincial and Municipal agencies. Colleges, universities and non-for profits are not eligible for the government discount.

Learning Tree reserves the right, at its sole discretion, to change, modify, add or remove portions of these Terms of Use, at any time. It is your responsibility to ensure that you qualify to receive a Government discounted rate. Please contact your Government Account Coordinator for any questions.

Not sure if you qualify? See the ? for details. Terms and Conditions
Price
Pay now -or- pay later
Pay by credit card at checkout
-or- pay later by invoice, as always.

Added to cart

Dec 12 - 14 (3 Days)
9:00 AM - 4:30 PM EST
Alexandria, VA / Online (AnyWare) Alexandria, VA / Online (AnyWare) Reserve Your Seat

Microsoft Office: Streamlining Tasks

Thank you for your interest in this event, but there are no available seats at this time. Please select another date. You may also contact a customer service representative or training advisor about your training needs, from single courses to large enterprise solutions.

You have used Passport or Voucher Number for this event. Please contact our Customer Service Representative or Training Advisor and they will work with your payment options.

Dec 12 - 14 (3 Days) 9:00 AM - 4:30 PM EST Alexandria, VA / Online (AnyWare)
Please select the quantity Please select the quantity
Optional Discounts
?
Have a Promo Code?

Enter a promo code for additional savings.

{{vm.lineItem.$DiscountValidationMessage}} Please enter a valid Promo Code
?
Don't know your Voucher or Passport Number?

Contact us via live chat or call us at 1-888-843-8733 and one of our representatives will assist you with your order.

{{vm.lineItem.$VoucherNumberValidationMessage}} Please enter a valid Voucher or Passport Number
Your Work Email is required Please enter a valid Email
?
BY CLICKING THE GOVERNMENT BOX, YOU AGREE TO THESE TERMS OF USE; IF YOU DO NOT AGREE, LEAVE THAT BOX BLANK TO RECEIVE COMMERCIAL PRICING.

By clicking the Government box – you certify that you/your firm is eligible to receive discounted price available only to Federal, Provincial and Municipal agencies. Colleges, universities and non-for profits are not eligible for the government discount.

Learning Tree reserves the right, at its sole discretion, to change, modify, add or remove portions of these Terms of Use, at any time. It is your responsibility to ensure that you qualify to receive a Government discounted rate. Please contact your Government Account Coordinator for any questions.

Not sure if you qualify? See the ? for details. Terms and Conditions
Price
Pay now -or- pay later
Pay by credit card at checkout
-or- pay later by invoice, as always.

Added to cart

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

Microsoft Office: Streamlining Tasks

Thank you for your interest in this event, but there are no available seats at this time. Please select another date. You may also contact a customer service representative or training advisor about your training needs, from single courses to large enterprise solutions.

You have used Passport or Voucher Number for this event. Please contact our Customer Service Representative or Training Advisor and they will work with your payment options.

Feb 13 - 15 (3 Days) 9:00 AM - 4:30 PM EST New York / Online (AnyWare)
Please select the quantity Please select the quantity
Optional Discounts
?
Have a Promo Code?

Enter a promo code for additional savings.

{{vm.lineItem.$DiscountValidationMessage}} Please enter a valid Promo Code
?
Don't know your Voucher or Passport Number?

Contact us via live chat or call us at 1-888-843-8733 and one of our representatives will assist you with your order.

{{vm.lineItem.$VoucherNumberValidationMessage}} Please enter a valid Voucher or Passport Number
Your Work Email is required Please enter a valid Email
?
BY CLICKING THE GOVERNMENT BOX, YOU AGREE TO THESE TERMS OF USE; IF YOU DO NOT AGREE, LEAVE THAT BOX BLANK TO RECEIVE COMMERCIAL PRICING.

By clicking the Government box – you certify that you/your firm is eligible to receive discounted price available only to Federal, Provincial and Municipal agencies. Colleges, universities and non-for profits are not eligible for the government discount.

Learning Tree reserves the right, at its sole discretion, to change, modify, add or remove portions of these Terms of Use, at any time. It is your responsibility to ensure that you qualify to receive a Government discounted rate. Please contact your Government Account Coordinator for any questions.

Not sure if you qualify? See the ? for details. Terms and Conditions
Price
Pay now -or- pay later
Pay by credit card at checkout
-or- pay later by invoice, as always.

Added to cart

Guaranteed to Run

When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time, location — will run. Guaranteed.

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 any time after class.

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

“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