.jpg){kind=logo}
MCNY-Office-2016
Microsoft Office 2016 for MCNY
Beginner Self-paced · 1 year access
62 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
01 / Lessons & labs
See exactly what you will learn and practice
Lessons
20 Interactive Lessons · 133 topics01 Taking Your First Steps with Word 10 topics · 3 LiveLab +
- 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
3 LiveLab in this lesson — see the labs panel →
02 Diving Into Document Creation 11 topics · 6 LiveLab +
- 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
6 LiveLab in this lesson — see the labs panel →
03 Working with Document Style and Content 7 topics · 8 LiveLab +
- 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
8 LiveLab in this lesson — see the labs panel →
04 Cutting, Copying, and Pasting Using the Clipboard 6 topics · 3 LiveLab +
- 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
3 LiveLab in this lesson — see the labs panel →
05 Introducing Excel 9 topics · 3 LiveLab +
- 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
3 LiveLab in this lesson — see the labs panel →
06 Entering and Editing Worksheet Data 5 topics · 3 LiveLab +
- Entering Text and Values into Your Worksheets
- Entering Dates and Times into Your Worksheets
- Modifying Cell Contents
- Applying Number Formatting
- Summary
3 LiveLab in this lesson — see the labs panel →
07 Essential Worksheet Operations 4 topics · 2 LiveLab +
- Learning the Fundamentals of Excel Worksheets
- Controlling the Worksheet View
- Working with Rows and Columns
- Summary
2 LiveLab in this lesson — see the labs panel →
08 Working with Cells and Ranges 5 topics · 3 LiveLab +
- Understanding Cells and Ranges
- Copying or Moving Ranges
- Using Names to Work with Ranges
- Adding Comments to Cells
- Summary
3 LiveLab in this lesson — see the labs panel →
09 A First Look at PowerPoint 6 topics · 3 LiveLab +
- Who Uses PowerPoint and Why?
- Learning Your Way around PowerPoint
- Changing the View
- Zooming In and Out
- Customizing the Quick Access Toolbar
- Summary
3 LiveLab in this lesson — see the labs panel →
10 Creating and Saving Presentation Files 4 topics +
- Starting a New Presentation
- Saving Your Work
- Setting Passwords for File Access
- Summary
11 Creating Slides and Text Boxes 14 topics · 6 LiveLab +
- 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
6 LiveLab in this lesson — see the labs panel →
12 Formatting Text 11 topics · 3 LiveLab +
- 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
3 LiveLab in this lesson — see the labs panel →
13 Getting Started With Outlook 2016 4 topics · 3 LiveLab +
- Navigate the Outlook Interface
- Perform Basic Email Functions
- Use Outlook Help
- Summary
3 LiveLab in this lesson — see the labs panel →
14 Composing Messages 7 topics · 5 LiveLab +
- Create an Email Message
- Check Spelling and Grammar
- Format Message Content
- Attach Files and Items
- Enhance an Email Message
- Manage Automatic Message Content
- Summary
5 LiveLab in this lesson — see the labs panel →
15 Reading and Responding to Messages 4 topics · 2 LiveLab +
- Customize Reading Options
- Work with Attachments
- Manage Your Message Responses
- Summary
2 LiveLab in this lesson — see the labs panel →
16 Managing Your Messages 3 topics · 1 LiveLab +
- Manage Messages Using Tags, Flags, and Commands
- Organize Messages Using Folders
- Summary
1 LiveLab in this lesson — see the labs panel →
17 An Introduction to Database Development 4 topics +
- The Database Terminology of Access
- Relational Databases
- Access Database Objects
- A Five-Step Design Method
18 Getting Started with Access 4 topics · 2 LiveLab +
- The Access Welcome Screen
- How to Create a Blank Desktop Database
- The Access 2016 Interface
- Bulletproofing an Application
2 LiveLab in this lesson — see the labs panel →
19 Creating Access Tables 10 topics · 6 LiveLab +
- 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
6 LiveLab in this lesson — see the labs panel →
20 Understanding Table Relationships 5 topics +
- Building Bulletproof Databases
- Data Normalization and Denormalization
- Table Relationships
- Integrity Rules
- Keys
Hands-On Labs Our edge
62 LiveLabs- Using the Word Count Option
- Exploring the File tab
- Understanding undoing and redoing actions
- 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
- 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
- Using the Cut and Paste Functions
- Understanding the Navigation pane
- Finding and Replacing the Text
- Identifying elements of Excel
- Identifying keys of Worksheet
- Modifying worksheet in MS Excel 2016
- Modifying cell contents
- Identifying key combinations
- Changing date format in MS Excel 2016
- Freezing the top row in MS Excel 2016
- Inserting a column in MS Excel 2016
- Understanding cell range address
- Understanding paste options
- Adding comments in MS Excel 2016
- Identifying font dialog controls
- Adding notes in MS PowerPoint 2016
- Changing document view in MS PowerPoint 2016
- 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
- Identifying text effects
- Customizing AutoCorrect Options in MS PowerPoint 2016
- Marking a document as final in MS PowerPoint 2016
- Identifying Message Form tabs
- Creating and Sending an Email
- Deleting Email Messages
- Understanding AutoCorrect feature
- Checking Spelling and Grammar in a Message
- Identifying paste options
- Attaching a File to a Message
- Understanding SmartArt
- Understanding reading options
- Working with Attachments
- Using Flags to Manage Messages
- Creating a blank desktop database
- Encrypting a database
- 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
Labs run in your browser — nothing to install.
02 / FAQs
Questions before you start
Prepare for Microsoft Office 2016 for MCNY
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.
- 1 year of full access
- 62 LiveLab included
- Certificate of completion
No credit card required