Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

Microsoft Office - Streamlining Tasks

( Duration: 3 Days )

The Microsoft Office - Streamlining Tasks training course is designed to improve efficiency and productivity by leveraging the power of Microsoft Office applications. In this course, you will 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.

By attending Microsoft Office - Streamlining Tasks workshop, delegates will learn 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 AGENDA

1

Introducing Microsoft Office

  • Comparing differences between Office versions
  • Integrating Office with the cloud
  • Retrieving documents using SkyDrive
2

Preparing the document

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

Controlling the document setup

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

Speeding up document creation

  • Applying reusable content with AutoText
  • Maintaining content with the Building Block Organizer
5

Managing graphics within a document

  • Inserting images using Guides
  • Manipulating images with graphic tools
6

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
7

Proofing and protecting the final document

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

Customizing the user interface

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

Patterning data with AutoFill and Flash Fill

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

Refining data with functions and formulas

  • Applying cell references and Named Ranges
  • Implementing conditional logic using the IF function
11

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
12

Graphing and charting data

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

Collaborating with Mail Merge in Word

  • Preparing requirements for variable data documents
  • Creating a Mail Merge
14

Customizing the work area

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

Developing a presentation

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

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
17

Drawing attention to graphics

  • Emphasizing graphics with dynamic custom Motion paths
  • Timing the Slide Show with transitions and animations
18

Packaging the presentation

  • Protecting the presentation
  • Sharing the presentation via SkyDrive

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X