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 worlds 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