lyndaLibrary

Learn Microsoft Office

Lynda.com logo on a tablet.The following courses are appropriate for learning basics about Microsoft Office.

There are many more courses on these topics available in lyndaLibrary.

Access

Access 2016: Essential Training

Topics include:

  • Creating a new database
  • Importing and entering data 
  • Sorting and filtering table data
  • Designing forms
  • Creating reports

& much more!

Learn Access:  The Basics

Topics include:

  • Loading a premade template database
  • Defining data types
  • Creating tables & editing forms
  • Creating queries and reports
  • Editing reports in Layout view

& much more!

Excel

Excel 2016 Essential Training

Topics include:

  • Creating formulas and functions
  • Formatting rows, columns, cells, and data
  • Creating charts and PivotTables
  • Sorting data
  • Creating and running macros

& much more!

Learn Excel 2016: The Basics (1hr 10min)

Topics include:

  • What is Excel?
  • Adding formulas and functions
  • Using AutoFill
  • Formatting, text, numbers, dates, and times
  • Inserting charts and pictures

& much more!

Office 365

Learn Office 365:  The Basics

Topics include:

  • Logging in as an administrator
  • Defining and adding users  
  • Reading and sending email with the Outlook Web App
  • Working with calendars and contacts in Outlook
  • Editing a team site

& much more!

PowerPoint

Learn PowerPoint 2016: The Basics (1h 3min)

Topics include:

  • Creating a new PowerPoint presentation
  • Adding slides and sections
  • Presenting and navigating your slide deck
  • Printing slides and notes
  • Sharing and collaborating with others

& much more!

PowerPoint 2016: Essential Training

Topics include:

  • Connecting PowerPoint to OneDrive
  • Creating presentations from themes and templates
  • Using and editing slide masters
  • Adding speaker notes and comments
  • Running a slideshow

& much more!

Windows 10

Windows 10 Essential Training (7h 57min)

Topics include:

  • Installing or upgrading to Windows 10
  • Connecting to the Internet & browsing the web with Edge
  • Launching, quitting, and managing applications
  • Using Cortana to search
  • Sending email

& much more!

Word

Learn Word 2016: The Basics (1hr 14 in)

Learn how to get up and running with Microsoft Word 2016, the world's most popular word-processing software. This short course for novice Word users will introduce the Word interface and explain how to open, save, and create documents and templates. The course then explores basic formatting and adding images, tables, and charts as well as working with styles, creating long documents, and collaborating with Track Changes.

Word 2016 Essential Training (5hr 41min)

Topics include:

  • Using templates to create new documents
  • Creating and editing text
  • Adding headers, footers, and page numbers
  • Working with tables, macros, and building blocks
  • Proofing, reviewing, and printing documents

& much more!