Microsoft

Microsoft Office 2016

(ITC-CS1010)
Lab
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Taking Your First Steps with Word

  • Using Word Count
  • Finding Recent Documents and Pinning
  • Undoing and Redoing the Changes
  • Personalizing a Copy of Microsoft Office
  • Getting Help
2

Diving Into Document Creation

  • Creating a Blank Document
  • Creating a Document Using a Template
  • Saving a Document
  • Using the Compatibility Checker
  • Zooming a Document
  • Printing a Document 
  • Changing the Text to Bold
  • Displaying a Document in the Outline View
3

Working with Document Style and Content

  • Changing the Font Style and Font Size
  • Changing the Text Color
  • Showing the Paragraph Marks
  • Increasing the Line Spacing
  • Creating a Signature Line
  • Inserting Page Breaks
  • Inserting Bullets
  • Changing the Heading Style
  • Checking Spelling and Grammar
4

Cutting, Copying, and Pasting Using the Clipboard

  • Using the Cut and Paste Functions
  • Changing the Default Paste Method
  • Searching with the Navigation Pane
  • Using Advanced Find
  • Finding and Replacing Text
5

Cleaning Up with AutoCorrect and AutoFormat

  • Revisiting the AutoCorrect Feature
  • Inserting a Cover Page
  • Creating an Envelope Document
  • Creating Labels
  • Creating PDF Output
6

Building Tables, Charts, and SmartArt to Show Data and Process

  • Using Quick Tables
  • Inserting the Table
  • Formatting the Table Border
  • Inserting Rows and Columns
  • Modifying Table Design
  • Inserting SmartArt 
7

Adding Pictures and WordArt to Highlight Information

  • Inserting Picture from a File
  • Inserting an Online Picture
  • Taking a Screenshot
  • Setting the Wrapping Behavior of a Graphic
  • Inserting the WordArt
  • Arranging a Picture
8

Adding Drop Caps, Text Boxes, Shapes, Symbols, and Equations

  • Applying the Drop Cap
  • Inserting and Formatting the Text Box Style
  • Inserting a Shape
  • Inserting Symbols
  • Inserting a Symbol From the Symbol Dialog Box
9

Setting Up the Document with Sections, Headers/Footers, and Columns

  • Changing the Basic Page Setup
  • Inserting a Section Break
  • Hiding and Unhiding the Document Text
  • Adding the Header
  • Inserting Page Numbers
  • Breaking Content into Columns
  • Changing Columns Using Section Breaks
10

Changing Other Page Features

  • Adding Page Borders
  • Including Background Colors and Images While Printing
  • Adding Page Color
  • Adding a Custom Text Watermark
  • Removing the Watermark
  • Applying a Theme
  • Adding a Bookmark
  • Creating an Email Hyperlink
11

Identifying the Contents and Terms in Your Document: TOCs, Captions, and Indexing

  • Creating a Table of Contents Using the Heading Style
  • Modifying the Table of Contents Style
  • Inserting a Table of Contents Using Marked Entries
  • Deleting Table of Contents
  • Adding a Caption to a Figure
  • Indexing a Document
  • Inserting an Endnote
  • Styling the Endnote
  • Working with Footnote Separator
  • Inserting a Citation
  • Editing a Citation
  • Inserting a Bibliography
12

Data Documents and Mail Merge

  • Typing a New List
  • Choosing the Data Document Type
  • Attaching a Data Source
  • Updating Labels
  • Using the Mail Merge Wizard
13

Managing Document Security, Comments, and Tracked Changes

  • Editing Restrictions
  • Enabling Track Changes
  • Accepting Changes
14

Customizing the Quick Access Toolbar and Ribbon

  • Adding Common Commands to the Quick Access Toolbar
  • Using the Main QAT Customization Dialog Box
  • Customizing the Ribbon
  • Exporting Ribbon Customizations
15

Word Options and Settings

  • Enabling the Reading View for Uneditable Files
  • Setting Page Display Options
  • Hiding Spelling and Grammar Errors
  • Preserving Fidelity When Sharing the Document
  • Choosing the Display Languages
  • Setting Editing Options
16

Macros: Recording, Editing, and Using Them

  • Enabling the Macro Recording Tool on Word's Status Bar
  • Configuring Macro Security Settings
17

Introducing Excel

  • Auto-hiding the ribbon in MS Excel 2016
  • Adding commands to a new group in MS Excel 2016
  • Modifying worksheet in MS Excel 2016
  • Adding new commands to Quick Access Toolbar in MS Excel 2016
18

Entering and Editing Worksheet Data

  • Entering text and values in MS Excel 2016
  • Entering date and time in MS Excel 2016
  • Deleting and editing the cell content in MS Excel 2016
  • Changing date format in MS Excel 2016
19

Essential Worksheet Operations

  • Arranging excel windows
  • Freezing the top row in MS Excel 2016
  • Inserting a column in MS Excel 2016
  • Hiding column in MS Excel 2016
20

Working with Cells and Ranges

  • Formatting multisheet ranges
  • Copying and pasting contents in MS Excel 2016
  • Creating names for cell ranges in MS Excel 2016
  • Adding comments in MS Excel 2016
21

Tables, Charts, and Sparklines

  • Formatting data as table in MS Excel 2016
  • Changing table style in MS Excel 2016
  • Removing duplicates in MS Excel 2016
  • Sorting data in MS Excel 2016
  • Filtering data in MS Excel 2016
  • Moving a chart to a chart sheet
  • Inserting a chart in MS Excel 2016
  • Changing chart style in MS Excel 2016
  • Changing chart color in MS Excel 2016
  • Customizing a chart in MS Excel 2016
  • Exploring the format task pane in MS Excel 2016
  • Changing a chart title in MS Excel 2016
  • Editing a legend in the chart in MS Excel 2016
  • Removing gridlines and headings in MS Excel 2016
  • Changing the data range for a data series in MS Excel 2016
  • Creating Sparklines in MS Excel 2016
  • Customizing Sparklines in MS Excel 2016
22

Worksheet Formatting

  • Changing the font in MS Excel 2016
  • Formatting heading in MS Excel 2016
  • Wrapping text in MS Excel 2016
  • Changing the text color in MS Excel 2016
  • Applying border in the MS Excel 2016
  • Applying a theme in MS Excel 2016
  • Formatting numbers in MS Excel 2016
23

Understanding Excel Files

  • Creating a new workbook
  • Saving a workbook in MS Excel 2016
  • Encrypting a workbook in MS Excel 2016
  • Checking compatibility in MS Excel 2016
  • Creating a workbook from a template
24

Printing and Protecting Your Work

  • Printing a workbook
  • Changing page view in MS Excel 2016
  • Setting page margin in MS Excel 2016
  • Setting and saving the print area in MS Excel 2016
  • Adding header in MS Excel 2016
  • Protecting a worksheet
  • Unprotecting a worksheet
  • Protecting a workbook's structure in MS Excel 2016
  • Unprotecting a workbook in MS excel 2016
  • Exporting to a text file in MS Excel 2016
  • Importing from a file in MS excel 2016
25

Introducing Formulas and Functions

  • Using the Concatenate function in MS Excel 2016
  • Using the Average function in MS Excel 2016
  • Using relative, absolute, and mixed references in MS Excel 2016
  • Using the SUMIF function in MS Excel 2016
  • Counting blank cells in MS Excel 2016
  • Using the SUM function in MS Excel 2016
  • Using VLOOKUP in MS Excel 2016
26

Visualizing Data Using Conditional Formatting

  • Applying conditional formatting in MS Excel 2016
27

Enhancing Your Work with Pictures and Drawings

  • Inserting and configuring shape
  • Inserting SmartArt in MS Excel 2016
  • Inserting WordArt in MS Excel 2016
  • Inserting an image in MS Excel 2016
  • Inserting hyperlink to an image in MS Excel 2016
28

Using Data Validation

  • Adding data validation in MS Excel 2016
  • Understanding cell references in MS Excel 2016
29

Introducing Pivot Tables

  • Creating a PivotTable automatically in MS Excel 2016
30

Performing Spreadsheet What-If Analysis

  • Creating data table in MS Excel 2016
31

A First Look at PowerPoint

  • Adding notes in MS PowerPoint 2016
  • Changing document view in MS PowerPoint 2016
  • Zooming in the presentation
  • Adding commands to QAT in MS PowerPoint 2016
32

Creating and Saving Presentation Files

  • Creating a presentation from a template in MS PowerPoint 2016
  • Setting password for file access in MS PowerPoint 2016
33

Creating Slides and Text Boxes

  • Showing gridlines in MS PowerPoint 2016
  • Duplicating slide in MS PowerPoint 2016
  • Inserting new slides from an outline
  • Deleting slides
  • Inserting content into a placeholder
  • Creating a manual text box in MS PowerPoint 2016
  • Positioning a text box in MS PowerPoint 2016
  • Changing a layout in MS PowerPoint 2016
  • Applying themes in MS PowerPoint 2016
  • Creating a new theme in MS PowerPoint 2016
  • Changing the color theme in MS PowerPoint 2016
  • Applying background style in MS PowerPoint 2016
  • Creating and deleting slide masters in MS PowerPoint 2016
34

Formatting Text

  • Changing the font theme in MS PowerPoint 2016
  • Changing the font size in MS PowerPoint 2016
  • Changing the font color in MS PowerPoint 2016
  • Applying text attributes in MS PowerPoint 2016
  • Applying WordArt styles in MS PowerPoint 2016
  • Applying text effects in MS PowerPoint 2016
  • Finding and replacing text in MS PowerPoint 2016
  • Setting spelling and grammar options in MS PowerPoint 2016
  • Customizing AutoCorrect Options in MS PowerPoint 2016
  • Marking a document as final in MS PowerPoint 2016
35

Formatting Paragraphs and Text Boxes

  • Formatting bulleted lists
  • Formatting numbered list in MS PowerPoint 2016
  • Formatting text box in MS PowerPoint 2016
36

Creating and Formatting Tables

  • Creating a table from the Table button in MS PowerPoint 2016
  • Inserting rows and columns in MS PowerPoint 2016
  • Applying table styles in MS PowerPoint 2016
  • Applying table margins in MS PowerPoint 2016
37

Drawing and Formatting Objects

  • Inserting Freeform shapes in MS PowerPoint 2016
  • Resizing an object in MS PowerPoint 2016
  • Aligning objects in MS PowerPoint 2016
  • Merging shapes in MS PowerPoint 2016
  • Inserting and formatting shapes in MS PowerPoint 2016
  • Applying color to an object in MS PowerPoint 2016
  • Applying an object border in MS PowerPoint 2016
  • Applying an object fill in MS PowerPoint 2016
  • Applying an object effects in MS PowerPoint 2016
  • Placing an action button on a slide in MS PowerPoint 2016
38

Creating SmartArt Graphics

  • Inserting SmartArt and arranging picture position in MS PowerPoint 2016
  • Applying a SmartArt style in MS PowerPoint 2016
  • Adding screenshot in MS PowerPoint 2016
  • Cropping the object to a shape in MS PowerPoint 2016
  • Applying artistic effects in MS PowerPoint 2016
  • Compressing images in MS PowerPoint 2016
  • Creating an album in MS PowerPoint 2016
39

Working with Charts

  • Inserting a chart in MS PowerPoint 2016
  • Filtering chart data in MS PowerPoint 2016
  • Changing chart type in MS PowerPoint 2016
  • Changing text orientation in chart in MS PowerPoint 2016
  • Applying chart style in MS PowerPoint 2016
40

Adding Sound Effects, Music, and Soundtracks

  • Inserting audio in MS PowerPoint 2016
  • Assigning a sound to an object in MS PowerPoint 2016
  • Configuring sound playback in MS PowerPoint 2016
  • Inserting a video in MS PowerPoint 2016
  • Setting the poster frame in MS PowerPoint 2016
  • Playing the clip on mouseover in MS PowerPoint 2016
41

Creating Animation Effects and Transitions

  • Applying transition on the slide in MS PowerPoint 2016
  • Applying animation on images in MS PowerPoint 2016
  • Adding a motion path to an object
  • Applying animation on an online picture
42

Creating Support Materials

  • Customizing the handout master in MS PowerPoint 2016
  • Previewing the handout master in MS PowerPoint 2016
43

Preparing for a Live Presentation

  • Starting and ending a show in MS PowerPoint 2016
  • Jumping to specific slides in MS PowerPoint 2016
  • Choosing pen color in MS PowerPoint 2016
  • Creating custom show in MS PowerPoint 2016
  • Creating a section break in MS PowerPoint 2016
44

Sharing and Collaborating

  • Adding comment in MS PowerPoint 2016
  • Comparing and merging presentations in MS PowerPoint 2016
45

Getting Started with Access

  • Creating a blank desktop database
  • Encrypting a database
  • Creating a new table

Related Courses

All Courses