Microsoft

Microsoft Office 2016 for MCNY

(MCNY-Office-2016)
Lessons
Lab
TestPrep
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Taking Your First Steps with Word

  • Welcome to a New Word
  • The Office Look
  • Using the Word Start Screen
  • Touring the Word Screen
  • Exploring the File Tab
  • Undoing and Redoing Actions
  • Setting Word Options
  • Getting Help
  • Exiting Word
  • Summary
2

Diving Into Document Creation

  • Creating a Blank File
  • Creating a File from a Template
  • Opening an Existing File
  • Saving and File Formats
  • Compatibility with Previous Versions of Word
  • Choosing the Right Word View for the Task at Hand
  • Printing a Document
  • Achieving Attractive Documents with Styles
  • Constructing Documents Faster with Outlining
  • Cleaning Up Content with AutoCorrect
  • Summary
3

Working with Document Style and Content

  • Reviewing the Ways You Can Format Text in Word
  • Applying Character Formatting
  • Structuring Text with Paragraph Formatting
  • Setting Off Text with Paragraph Decoration
  • Using the Styles Group to Apply Styles
  • Checking Spelling and Grammar
  • Summary
4

Cutting, Copying, and Pasting Using the Clipboard

  • Adding and Moving Document Content with Cut, Copy, and Paste
  • Managing Pasting Options
  • Searching with the Navigation Pane
  • Starting an Advanced Find from the Ribbon
  • Replacing Text via the Ribbon
  • Summary
5

Introducing Excel

  • Identifying What Excel Is Good For
  • Seeing What's New in Excel 2016
  • Understanding Workbooks and Worksheets
  • Moving Around a Worksheet
  • Using the Ribbon
  • Customizing the Ribbon
  • Creating Your First Excel Workbook
  • Customizing the Quick Access Toolbar
  • Summary
6

Entering and Editing Worksheet Data

  • Entering Text and Values into Your Worksheets
  • Entering Dates and Times into Your Worksheets
  • Modifying Cell Contents
  • Applying Number Formatting
  • Summary
7

Essential Worksheet Operations

  • Learning the Fundamentals of Excel Worksheets
  • Controlling the Worksheet View
  • Working with Rows and Columns
  • Summary
8

Working with Cells and Ranges

  • Understanding Cells and Ranges
  • Copying or Moving Ranges
  • Using Names to Work with Ranges
  • Adding Comments to Cells
  • Summary
9

A First Look at PowerPoint

  • Who Uses PowerPoint and Why?
  • Learning Your Way around PowerPoint
  • Changing the View
  • Zooming In and Out
  • Customizing the Quick Access Toolbar
  • Summary
10

Creating and Saving Presentation Files

  • Starting a New Presentation
  • Saving Your Work
  • Setting Passwords for File Access
  • Summary
11

Creating Slides and Text Boxes

  • Creating New Slides
  • Inserting Content from External Sources
  • Managing Slides
  • Using Content Placeholders
  • Creating Text Boxes Manually
  • Working with Text Boxes
  • Understanding Layouts and Themes
  • Changing a Slide's Layout
  • Applying a Theme
  • Managing Themes
  • Changing Colors, Fonts, and Effects
  • Changing the Background
  • Managing Slide Masters
  • Summary
12

Formatting Text

  • Changing the Font
  • Changing the Font Size
  • Changing Font Color/Text Fill
  • Applying Text Attributes
  • Applying WordArt Styles
  • Applying Text Effects
  • Finding and Replacing Text
  • Correcting Your Spelling and Grammar
  • Using AutoCorrect to Fix Common Problems
  • Using the Research Tools
  • Summary
13

Getting Started With Outlook 2016

  • Navigate the Outlook Interface
  • Perform Basic Email Functions
  • Use Outlook Help
  • Summary
14

Composing Messages

  • Create an Email Message
  • Check Spelling and Grammar
  • Format Message Content
  • Attach Files and Items
  • Enhance an Email Message
  • Manage Automatic Message Content
  • Summary
15

Reading and Responding to Messages

  • Customize Reading Options
  • Work with Attachments
  • Manage Your Message Responses
  • Summary
16

Managing Your Messages

  • Manage Messages Using Tags, Flags, and Commands
  • Organize Messages Using Folders
  • Summary
17

An Introduction to Database Development

  • The Database Terminology of Access
  • Relational Databases
  • Access Database Objects
  • A Five-Step Design Method
18

Getting Started with Access

  • The Access Welcome Screen
  • How to Create a Blank Desktop Database
  • The Access 2016 Interface
  • Bulletproofing an Application
19

Creating Access Tables

  • Table Types
  • Creating a New Table
  • Creating tblCustomers
  • Changing a Table Design
  • Understanding tblCustomers Field Properties
  • Setting the Primary Key
  • Saving the Completed Table
  • Manipulating Tables
  • Adding Records to a Database Table
  • Understanding Attachment Fields
20

Understanding Table Relationships

  • Building Bulletproof Databases
  • Data Normalization and Denormalization
  • Table Relationships
  • Integrity Rules
  • Keys

1

Taking Your First Steps with Word

  • Using the Word Count Option
  • Exploring the File tab
  • Understanding undoing and redoing actions
2

Diving Into Document Creation

  • Understanding Inserting versus Overtyping
  • Creating a file from a template
  • Saving a Document
  • Identifying file formats
  • Zooming in the Document
  • Changing the Text to Bold
3

Working with Document Style and Content

  • Modifying the Font
  • Changing the Text Color
  • Showing Paragraph Marks and Zooming in the Document 
  • Increasing the Line Spacing
  • Creating a Signature Line
  • Inserting Page Breaks
  • Inserting Bullets
  • Changing the Heading Style
4

Cutting, Copying, and Pasting Using the Clipboard

  • Using the Cut and Paste Functions
  • Understanding the Navigation pane
  • Finding and Replacing the Text
5

Introducing Excel

  • Identifying elements of Excel
  • Identifying keys of Worksheet
  • Modifying worksheet in MS Excel 2016
6

Entering and Editing Worksheet Data

  • Modifying cell contents
  • Identifying key combinations
  • Changing date format in MS Excel 2016
7

Essential Worksheet Operations

  • Freezing the top row in MS Excel 2016
  • Inserting a column in MS Excel 2016
8

Working with Cells and Ranges

  • Understanding cell range address
  • Understanding paste options
  • Adding comments in MS Excel 2016
9

A First Look at PowerPoint

  • Identifying font dialog controls
  • Adding notes in MS PowerPoint 2016
  • Changing document view in MS PowerPoint 2016
10

Creating Slides and Text Boxes

  • Showing gridlines in MS PowerPoint 2016
  • Duplicating slide in MS PowerPoint 2016
  • Understanding Outline view
  • Understanding themes and template
  • Adding a layout in MS PowerPoint 2016
  • Applying themes in MS PowerPoint 2016
11

Formatting Text

  • Identifying text effects
  • Customizing AutoCorrect Options in MS PowerPoint 2016
  • Marking a document as final in MS PowerPoint 2016
12

Getting Started With Outlook 2016

  • Identifying Message Form tabs
  • Creating and Sending an Email
  • Deleting Email Messages
13

Composing Messages

  • Understanding AutoCorrect feature
  • Checking Spelling and Grammar in a Message
  • Identifying paste options
  • Attaching a File to a Message
  • Understanding SmartArt
14

Reading and Responding to Messages

  • Understanding reading options
  • Working with Attachments
15

Managing Your Messages

  • Using Flags to Manage Messages
16

Getting Started with Access

  • Creating a blank desktop database
  • Encrypting a database
17

Creating Access Tables

  • Creating a new table
  • Opening table in Design view
  • Creating a primary key
  • Saving a table
  • Renaming a table
  • Adding records to a database table

Related Courses

All Courses