Learn Office 2016 for Microsoft Office 20161.0 - App Store

Learn Office 2016

Acquire essential skills for producing professional work with the Microsoft Office suite including Word, Excel, PowerPoint, and Access.

Learn Microsoft Excel 2016

Video Training

Start mastering Excel, the world's most popular and powerful spreadsheet program. Learn how to best enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data and cells, build charts and PivotTables and automate tasks with macros.

Over 8 Hours of High Quality Video Tutorials

Includes Project files that you follow step by step

Topics include:

Entering data

Creating formulas and functions

Formatting rows, columns, cells, and data

Working with alignment and text wrap

Adjusting rows and columns

Finding and replacing data

Printing and sharing worksheets

Creating charts and PivotTables

Inserting and deleting sheets

Using power functions such as IF and VLOOKUP

Password-protecting worksheets and workbooks

Sorting data

Analyzing data with Goal Seek and Solver

Creating and running macrosWorking with the Excel interface

Learn Microsoft Word 2016

Video Training

Learn howto create, format, share, and print a wide variety of documents in Word 2016. This Video course covers creating new documents from templates and scratch, formatting text and pages, working with headers and footers, using themes and styles, adding multimedia, and more. It will also show how to share documents with others and enhance your productivity with macros.

Over almost 6 Hours of High Quality Video Tutorials

Includes Project files that you follow step by step

Topics include:

Using templates to create new documents

Creating and editing text

Formatting text, pages, and paragraphs

Adjusting line spacing and page breaks

Adding headers, footers, and page numbers

Applying styles and themes to documents

Creating bulleted and numbered lists

Working with tables, macros, and building blocks

Illustrating documents

Proofing, reviewing, and printing documents

Collaborating with others via OneDrive and email

Customizing Word

Learn Microsoft Access 2016

Video Training

Learnhow to build databases to store and retrieve your data more efficiently with Access 2016. This course shows how to use the powerful program to wrangle your data and create your first table, and highlights smart strategies to edit and modify fields and records.

Thecourse also shows you how to build queries and action queries, create and design forms, use macros, integrate Access with the rest of the Office 2016 suite, and maintain your databases over time.

Almost 7 Hours of High Quality Video Tutorials

Includes Project files that you follow step by step

Topicsinclude:

Creating a new database

Creating tables and new data types

Importing and entering data

Setting up relationships and primary keys

Adding validation rules

Sorting and filtering table data

Building queries

Designing forms

Creating reports

Attaching macros to buttons and tables

Working with Excel and Outlook data

Maintaining an Access database

Requires iOS 9.3 or later. Compatible with iPhone, iPad, and iPod touch.