Here is a complete list of tutorial videos available on my channel:
Windows 10:
Perform basic operations with the mouse
Create folders
Explore the Windows 10 Desktop, Taskbar, and Start Menu
Select multiple files and folders
Download a file from a website
Use File Explorer to access OneDrive and download student data files
Capture an image of the entire screen
Explore the Control Panel and Settings app
Personalize the desktop
Change screen brightness and resolution
Word 2016:
Create a new document and insert text
Insert and format graphics
Insert and edit text boxes
Create a table
Format a table
Present a Word document online
Create a research paper in MLA format
Insert footnotes in a research paper
Create citations and a bibliography
Save a document
Correct errors as you type
How to format a document in APA format
Convert Word document to PDF file
Microsoft Office Specialist Certification Exam Practice Study Guide
APA format from default formatting
Table of Contents Tutorial
Format paragraphs
Create a custom Word template
Excel 2016:
Create, save and browse an Excel workbook
Enter data into a spreadsheet
How to export access to Excel and apply conditional formatting
Use Flash Fill, SUM, Average, Median, and MAX functions and formulas
Move data and rotate text
Graph data with a pie chart
Format a pie chart
MOS Prep – Basic Certification Exam Practical Study Guide
Change fonts, font style and font color
The NOW function
Export an Excel spreadsheet to an Access table
The VSearch function
The MIN or MINIMUM function
Histogram charts
Use the Sum button to add a range of cells
Enter formulas using the keyboard
Access 2016:
Identifying Good Database Design
Create a table and define fields in an empty desktop database
The primary key
Import an Excel spreadsheet into Access
Create a table in Design view
Modify the structure of a table
Create a subform
MOS Prep – Basic Certification Exam Practical Study Guide
Add existing fields to a form
PowerPoint 2016:
Create a new presentation
Edit a presentation in normal view
Add images to a presentation
Format numbered and bulleted lists
Customize slide backgrounds and themes
Animate a slideshow
Apply a theme used in another presentation
Find and download a theme online
Microsoft Office Specialist Exam Certification
Print and view a presentation
Outlook 2016
Basic tutorial
YouTube Analytics:
100 subscribers
200 subscribers
300 subscribers
500 subscribers
Computer fundamentals:
Computer Case Types – Dell Inspiron AMD 3656
Printer ports and types
The startup process
How to get answers to your IT questions
Undo your errors on Windows 10 or Apple Mac
Routers and modems
What is the Cloud? Storage as a Service
Types of Internet Services on Google Android or Apple iPhone
Web browsing
Why use the Cloud?
Microsoft OneDrive – Create Upload, Upload and Sync
Explain the importance of file management
Troubleshoot common computer problems
Job search skills:
Values, attitude and goals
Top 5 job search sites
Prepare for your interview
Negotiate your salary
Video requests:
Download GMetrix test preparation software
Remember that the purpose of my channel is for you to learn. You can request a video at any time in the comments section, and I will make the video for you. I will do tutorials, simulations and demos for anything you would like to learn in our class. So I encourage you to apply. I also broadcast Live YouTube once a week to answer your questions!
Instructor A Morgan
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
No Comments