What you'll learn
Microsoft Office 2016 introduced several core productivity applications designed with an emphasis on cloud integration and real-time collaboration. Common across Word, Excel, and PowerPoint 2016 is the "Tell Me" assistant, a search box that allows users to type commands to find them quickly.
Microsoft Word 2016
A word processing application used for creating and formatting text-based documents such as reports, letters, and resumes.
- Real-time Co-authoring: Allows multiple users to edit the same document simultaneously when saved to OneDrive or SharePoint.
- Smart Lookup: Uses Bing to provide web-based research, definitions, and images directly within the app.
- PDF Integration: Enables opening, editing, and saving PDF files directly, maintaining the original structure.
- Ink Equation: Users can write math equations by hand using a stylus or mouse, which Word then converts to typed text.
Microsoft Excel 2016
A spreadsheet program used for complex data analysis, calculations, and visualization.
- New Chart Types: Introduced modern visualizations like Treemap, Sunburst, Waterfall, Histogram, and Box & Whisker.
- Power Query Integration: Fully integrated "Get & Transform" tools to extract, transform, and load (ETL) data from various sources.
- One-Click Forecasting: New "Forecast Sheet" tool uses historical data to predict future trends with a single click.
- 3D Maps: Formerly "Power Map," this tool for visualizing geographic data is now built-in under the Insert tab.
Microsoft PowerPoint 2016
A presentation application for creating high-impact visual slideshows.
- Morph Transition: A revolutionary transition that creates smooth, cinematic animations by tracking changes between consecutive slides.
- Designer: AI-powered feature that provides automatic layout and design suggestions when you add an image to a slide.
- Zoom: Allows presenters to create interactive summaries by jumping between specific slides or sections in any order.
- Screen Recording: Built-in tool to record any part of your computer screen and insert it directly into a presentation slide.
Microsoft Access 2016
A database management system (DBMS) used to store, organize, and manage large amounts of information.
- Relational Database: Stores data in related tables, allowing for complex queries and reporting.
- Custom Web Apps: Design tools for creating browser-based database applications that can be shared via SharePoint.
- Data Export/Import: Features enhanced connectors to import data from sources like Excel, SQL Server, and SharePoint.
- Report Generation: Advanced tools for creating professional, printable summaries of database records.
Show More
Course Syllabus
The syllabus for Microsoft Office 2016 covers a range of skills from basic document creation to advanced data management. Below is a summarized syllabus for Word, Excel, Access, and PowerPoint 2016 based on industry standards and certification objectives.
Microsoft Word 2016 Syllabus
- Getting Started: Introduction to the Ribbon, Backstage view, Quick Access Toolbar, and "Tell Me" feature.
- Text & Paragraph Formatting: Font styles, alignment, line and paragraph spacing, indents, tabs, and using the Format Painter.
- Layout & Visuals: Setting margins, page orientation, columns, and page/section breaks.
- Objects & Illustrations: Inserting and formatting tables, shapes, SmartArt, images, and charts.
- References: Creating a Table of Contents (TOC), footnotes, endnotes, citations, and bibliographies.
- Advanced Tools: Mail Merge (envelopes and labels), Track Changes, document protection, and macros.
Microsoft Excel 2016 Syllabus
- Basics: Cell operations (AutoFill, relative/absolute referencing), formatting numbers, and managing worksheets.
- Formulas & Functions: SUM, AVERAGE, COUNT, MIN/MAX; logical functions (IF, AND, OR); and lookup functions (VLOOKUP, HLOOKUP).
- Data Management: Sorting, filtering, advanced filters, and data validation.
- Data Visualization: Creating and formatting charts (Treemap, Sunburst, etc.) and using Sparklines.
- Data Analysis: PivotTables, PivotCharts, Slicers, and "What-If" Analysis (Goal Seek, Scenario Manager).
- External Data: Importing data from Text/CSV, Access, or the web; working with Power Query.
Microsoft PowerPoint 2016 Syllabus
- Presentation Basics: Using templates, managing slides, and utilizing various PowerPoint views.
- Content Creation: Inserting and formatting text, WordArt, shapes, images, and tables.
- Multimedia: Inserting and managing audio, video clips, and screen recordings.
- Transitions & Animations: Applying slide transitions (including Morph), animating slide content, and setting timing options.
- Slide Masters: Modifying Slide Masters, Handout Masters, and Note Masters for consistent design.
- Delivery & Sharing: Configuring slide shows, rehearsing timings, and protecting/exporting presentations.
Microsoft Access 2016 Syllabus
- Database Fundamentals: Relational database concepts, data types, and the Access environment.
- Tables & Relationships: Creating tables in Design View, defining primary keys, and establishing table relationships (one-to-many, etc.).
- Queries: Designing simple and advanced queries to filter and analyze data.
- Forms: Creating and designing forms for data entry, including subforms and conditional formatting.
- Reports: Generating, formatting, and customizing professional reports.
- Database Management: Importing/exporting data, using macros for automation, and securing the database.
Bestseller
