melow you will find links to short 15 to 20 minutes modules focused on helping you
gain essential skills in Office 2019 and 365, including Microsoft Access, Excel, PowerPoint, and Word.

If you have questions about a module, email prlshields@gmail.com or meet with our Digital Navigator any 
Wednesday from 2 to 3:30 PM EDT by clicking this link.

Word 2019

In this Word tutorial, learn how to format text, save and share documents, modify line and paragraph spacing, use tables and columns, and do more with your documents.

Module Titles & Links

Word Basics

• Getting Started with Word
• Understanding OneDrive
• Creating & Opening Documents
• ​Saving & Sharing Documents

Working With Text

• Text Basics
• Formatting Text
• Using Find & Replace
• Indents & Tabs
• Line & Paragraph Spacing
• Lists
• Links

Layout & Printing

• Page Layout
• Printing Documents
• Breaks
• Columns
• Headers & Footers
• Page Numbers

Working With Objects

• Pictures & Text Wrapping
• Formatting Pictures
• Shapes
• Text Boxes
• Aligning/Ordering & Grouping Objects
• Tables​
• Charts

Collaboration & Reviewing

• Checking Spelling & Grammar
• Track Changes & Comments
• Inspecting & Protecting Documents

Doing More With Word

• SmartArt Graphics
• Applying & Modifying Styles
• ​Mail Merge

Quiz

• Word Quiz

Word

word-2019-basic-quick-reference.pdf
File Size:	624 kb
File Type:	pdf

Download File

---

word-2019-intermediate-quick-reference.pdf
File Size:	603 kb
File Type:	pdf

Download File

---

word-2019-advanced-quick-reference.pdf
File Size:	578 kb
File Type:	pdf

Download File

---

​Excel

excel-2019-basic-quick-reference.pdf
File Size:	607 kb
File Type:	pdf

Download File

---

excel-2019-intermediate-quick-reference.pdf
File Size:	665 kb
File Type:	pdf

Download File

---

excel-2019-advanced-quick-reference.pdf
File Size:	955 kb
File Type:	pdf

Download File

---

​Excel Ebook​s

excel_tipstricks_e-bookv1.1.pdf
File Size:	1089 kb
File Type:	pdf

Download File

---

​Link To Another Excel 2019 ebook

Excel 2019

In this Excel tutorial, learn how to create formulas and charts, use functions, format cells, and do more with your spreadsheets.

​​

Module Titles & Links

Excel Basics

• ​Getting Started with Excel
• ​Understanding OneDrive
• ​Creating & Opening Workbooks
• ​Sharing & Saving Workbook

Working With Cells & Sheets

• Cell Basics​
• Modifying Columns, Rows, & Cells
• ​Formatting Cells
• Understanding Number Formats
• Working With Multiple Worksheets
• Using Find & Replace
• Checking Spelling
• Page Layout & Printing

Formulas & Functions

• Intro To Formulas
• Creating More Complex Formulas
• Relative & Absolute Cell References
• Functions

Working With Data

• Working With Data
• Freezing Panes & View Options
• Sorting Data
• Filtering Data
• Groups and Subtotals
• Tables
• Charts
• Conditional Formatting

Doing More With Excel

• Comments & Co-authoring
• Inspecting & Protecting Workbooks
• Intro To Pivot Table
• Doing More With Pivot Tables
• What-If Analysis

Quiz​

• Excel Quiz

Here's another website link for
Excel training & tips!
Easy Excel