About this Course
You’ve used Microsoft® Office 2007 or Office 2010 to create various types of business materials, from documents in Word to spreadsheets in Excel® to presentations in PowerPoint®. Perhaps you use Outlook® to manage your calendar, contacts, and email; or Access® to manage inventory and trouble tickets.
However you use Office, the fact is the Office suite of applications is the de-facto standard for business productivity software. Each new release of Office builds upon the successes of the previous generations.
This course builds upon the foundational Microsoft Office 2007/2010 knowledge and skills you’ve already acquired. It focuses on the enhanced features you’ll want to leverage to improve the way you manage, organize, present, and distribute your company’s data and information.
You’ll explore a variety of enhancements, from Word’s ability to edit PDF files to the new Flash Fill functionality in Excel that dramatically increases the speed at which you can add data to a spreadsheet. You’ll discover how the cloud has been deeply integrated into your Office experience and how collaborating with colleagues has never been easier.
This course is designed for individuals who already have foundational knowledge and skills in Office 2007 or Office 2010, and are interested in transitioning from an earlier Office version to Office 2016.
At Course Completion
In this course, you will explore the new features available in Office 2016 applications.
- Identify new and enhanced features that are common across all applications in Office 2016.
- Modify documents using Microsoft Word 2016.
- Enhance worksheet data using Microsoft Excel 2016.
- Augment a presentation using Microsoft PowerPoint 2016.
- Create a database using Microsoft Access 2016.
- Utilize mail, calendars, contacts, and tasks in Microsoft Outlook 2016.
Lesson 1: Getting Started with Microsoft Office 2016
Topic A: Common Features
Topic B: Office 2016 and the Cloud
Lesson 2: Working with Microsoft Word 2016
Topic A: Edit a PDF
Topic B: Work with Tables
Topic C: Embed Videos
Topic D: Edit Documents
Topic E: Read Documents
Lesson 3: Working with Microsoft Excel 2016
Topic A: Streamline Workflow in Excel Using Templates
Topic B: Accelerate Data Entry with Flash Fill
Topic C: Incorporate Charts
Topic D: Analyze Data
Lesson 4: Working with Microsoft PowerPoint 2016
Topic A: Apply a Theme
Topic B: Incorporate Objects
Topic C: Leverage the Enhanced Presenter View
Topic D: Collaborate with Others on a Single Presentation
Lesson 5: Working with Microsoft Access 2016
Topic A: Explore Web Apps
Topic B: Utilize Templates in Access
Lesson 6: Working with Microsoft Outlook 2016
Topic A: Navigate Through Mail, Calendars, People, and Tasks
Topic B: Manage Your Mailbox
To ensure your success in this course, you will need to have familiarity with either the Office 2007 or Office 2010 suite of products, including Word, Excel, PowerPoint, Access, and Outlook.