MS Office 2016 Video tutorials (GCF)

Word | Excel | Access | PowerPoint | Back to Computer Apps Page

Word 2016
  1. New Features in Office 2016
  2. Getting to Know Word
  3. Creating and Opening Documents
  4. Text Basics
  5. Formatting Text
  6. Page Layout
  7. Printing Documents
  8. Indents and Tabs
  9. Line and Paragraphs Spacing
  10. Lists
  11. Hyperlinks
  12. Breaks
  13. Columns
  14. Headers and Footers
  15. Page Numbers
  16. Pictures and Text Wrapping
  17. Formatting Pictures
  18. Background Removal
  19. Shapes
  20. Text Boxes and Word Art
  21. Aligning, Ordering, and Grouping Objects
  22. Tables
  23. Charts
  24. Spelling and Grammar
  25. Track Changes and Comments
  26. Inspecting and Protecting Documents
  27. SmartArt Graphics
  28. Applying and Modifying Styles
  29. Themes and Quick Styles
  30. Mail Merge

Excel 2016

  1. Getting to Know Excel
  2. Creating and Opening Workbooks
  3. Cell Basics
  4. Saving and Sharing Workbooks
  5. Modifying Columns, Cells, and Rows
  6. Formatting Cells
  7. Worksheet Basics
  8. Page Layout and Printing
  9. Intro to Formulas
  10. Creating More Complex Formulas
  11. Solving Real0Life Problems in Excel
  12. Relative and Absolute Cell References
  13. Functions
  14. Freezing Panes and View Options
  15. Sorting Data
  16. Filtering Data
  17. Groups and Subtotals
  18. Tables
  19.  Charts
  20. Sparklines
  21. Conditional Formatting
  22. Track Changes and Comments
  23. Inspecting and Protecting Workbooks
  24. Pivot Tables Intro
  25. Doing More with Pivot Tables
  26. What-if Analysis

Word | Excel | Access | PowerPoint | Back to Computer Apps Page

Top

Access 2016

  1. Introduction to Databases
  2. Getting Started in Access 2016
  3. Introduction to Objects
  4. Working with Databases
  5. Working with Tables
  6. Customizing Tables
  7. Working with Forms
  8. Sorting and Filtering
  9. Designing a Simple Query
  10.  Multi-Table Queries (Part 1)
  11. Multi-table Queries (Part 2)
  12. Modify Queries
  13. Creating a Totals Query
  14. Creating Reports
  15. Printing Reports
  16. Using the Report Wizard
  17. Formatting Reports
  18. Modifying Tables
  19. Creating Forms
  20. Customizing Form Settings
  21. Formatting Forms

 PowerPoint 2016

  1. Getting to Know PowerPoint
  2. Creating and Opening Presentations
  3. Saving Presentations
  4. Slide Basics
  5. Text Basics
  6. Applying Themes
  7. Applying Transitions
  8. Animating Text and Objects
  9. Animating Text One Line at a Time
  10. Managing Slides
  11. Printing Presentations
  12. Presenting Your Slide Show
  13. Lists
  14. Indents and Line Spacing
  15. Inserting Pictures
  16. Formatting Pictures
  17. Background Removal
  18. Shapes
  19. Aligning, Ordering, and Grouping Objects
  20. Inserting Video
  21. Inserting Audio
  22. Tables
  23. Charts
  24. SmartArt Graphics
  25. Checking Spelling and Grammar
  26. Reviewing Presentations
  27. Inspecting and Protecting Presentations
  28. Modifying Themes
  29. Slide Master View
  30. Inserting Hyperlinks
  31. Using Action Buttons
  32. Rehearsing and Recording
  33. Sharing Presentation Online  

Word | Excel | Access | PowerPoint | Back to Computer Apps Page

Top of Page