Type to search LearningTree.com

Do you mean "{{response.correctedQuery}}" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.

 

Microsoft Office Training









Preferred method of contact?

Microsoft Office: Streamlining Tasks

COURSE TYPE

Foundation

Course Number

972

Duration

3 Days

Enroll

About This Course: This course is designed to improve efficiency and productivity by leveraging the power of Microsoft Office applications. In this course, you gain the skills needed to stand out in a competitive market by maximizing the innovative features and integration techniques required to streamline day-to-day tasks and enable better decision-making in the workplace.

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

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

Course Schedule

Attend this live, instructor-led course In-Class or Online via AnyWare.

Hassle-Free Enrollment: No advance payment required.
Tuition due 30 days after your course.

Oct 12 - 14 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Nov 9 - 11 Alexandria, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Dec 14 - 16 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Feb 22 - 24 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Mar 22 - 24 Alexandria, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Apr 11 - 13 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jun 28 - 30 AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware

Aug 9 - 11 Alexandria, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Aug 30 - Sep 1 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Guaranteed to Run

Bring this Course to Your Organization and Train Your Entire Team
For more information, call 1-888-843-8733 or click here

Tuition

Standard

$2650

Government

$2355

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.

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

Questions

Call 1-888-843-8733 or click here »

An experienced training advisor will happily answer any questions you may have and alert you to any tuition savings to
which you or your organization may be entitled.

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)
  • Make progress toward one or more Learning Tree Specialist & Expert 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