Microsoft 365 Word Basics
Update Windows 7 to 8.1 Differences document
2.5 Hours Objectives:
-
Review mouse controls and special keyboard keys
-
Learn Word Panel layout
-
Loading and saving documents
-
Selecting text and moving around document
-
Copy/Cut and pasting text
-
Insert a picture
-
Formatting paragraphs
-
Changing font, size, bold and underline
-
Adding text to the document
-
Add header to document with date
-
Spelling and grammar check
-
Printing document with Header
Create movie announcement flyer
2.5 Hours Objectives:
-
Add page borders
-
Import and position pictures
-
Create Text Boxes
-
Format and align paragraphs
-
Create bullet lists
-
Create hyperlinks
-
Add page footer
-
Create tables of data
-
Insert special symbols
-
Save document as Word and PDF (Adobe Portable Document File)
-
Print document
Microsoft 365 Word Intermediate
Computer Basics I
Computer Basics II
4 Sessions 2.5 Hours Each
-
Computer hardware and mouse usage: Review computer hardware components, turning computer on/off, review mouse functions, perform mouse exercise.
2. Keyboard functions and Windows: Review unique keyboard functions
and perform typing exercise. Review Windows 7, 8.1 and 10. Define
libraries, folders and files.
3. Overview Internet, Browsers, Search: Objectives: Review Internet
Explorer (Edge), Chrome, and Firefox browsers, review Ask, Bing,
DuckDuckGo, Google, Yahoo search engines, perform efficient
searches, review several web sites
4. E-mail overview using Google gmail: Create a gmail.com account,
open and reply to emails, attach pictures and other documents to
emails.
4 Sessions 2.5 Hours each
-
Microsoft Word Basics: Word menu structure, loading & saving documents, highlighting text, copy/cut & paste, formatting paragraphs, insert pictures, spelling & grammar checks, printing with header
2. Microsoft Excel Basics: Excel menu structure, typing formulas,
loading & saving spreadsheets, copy/cut & paste, formatting cells,
using AUTOSUM, sorting, keyboard shortcuts, printing with header
3. Storage Management: Use the File Explorer utility to create and
populate Libraries, Folders and Files. Learn how to organize your
data on storage devices, copy, rename and delete files.
4.Windows 10: Review the many capabilities of Windows 10 such as the
Start Menu, Cortana digital assistant, revised Edge web browser,
download programs and manage essential settings.
Microsoft 365 Word Advanced
Microsoft 365 Excel Basics
Mail Merge, Templates, Track Changes & Macros
2.5 Hours Objectives:
-
Defining and using Mail Merge
-
Creating and using an online forms template (.dotx Word file)
-
Using an article publishing template with Table of Contents and bibliography
-
Track changes and comments in a document
-
Optional: Record and Execute a macro with Word
Update Candle Order Workbook
2.5 Hours Objectives:
-
Learn Excel workbook layout
-
Understand Excel menus and tool bars
-
Loading and saving workbooks
-
Positioning cursor and highlighting ranges of cells
-
Using Autosum and entering formulas
-
Copy and pasting formulas and text
-
Formatting columns and text
-
Sorting workbook data
-
Inserting cell comments
-
Printing workbook with Header
Microsoft 365 Excel Intermediate
Microsoft 365 Excel Advanced
Manipulate Sales Order Workbook
2.5 Hours Objectives:
-
Prerequisite review questions
-
Start Excel and import text file with over 900 rows of data into Excel
-
Review contents of imported data
-
Clean up and freeze headers
-
Sort data by Sales Person and Date Sold
-
Use =COUNTIF function to determine number of items sold in each Region
-
Calculate Total Sales Commission using =VLOOKUP
-
Create Total Sales and Total Commissions Subtotals by Sales Person
-
Add filters to answer business questions
-
Encrypt and Assign workbook password
-
Do Save As, close workbook and stop Excel
-
Open workbook with password
-
Creating Bar Chart of Total Sales for each Sales Person
-
Use Goal Seek Tool to determine Bonus amounts
-
Define print area, define print header and print
Appendix: Common Shortcuts
Microsoft 365 Excel Macros
Use Pivot Tables/Charts with Sales Order Workbook
2.5 Hours Objectives:
-
Overall objective: Create management Dashboard presentation of sales data
-
What is a Pivot Table?
-
Open Sales Order 2015-2016 workbook in Excel
-
Review contents of Excel workbook
-
Create Table of data
-
Create Pivot Table, review Filters, Columns, Rows and Values fields display
-
Create (5) Pivot Charts for Dashboard presentation
-
Create Dashboard worksheet
-
Add Slicer for the Year
-
Print Dashboard worksheet
Microsoft 365 PowerPoint Intermediate
Microsoft 365 Excel Formulas & Functions
PowerPoint Functionality Presentation
2.5 Hours Objectives:
1. How to insert the following items into your presentations:
-
Animation and text boxes
-
Audios
-
Charts
-
Equations
-
External Hyperlinks
-
Images and pictures
-
Shapes
-
SmartArt
-
Tables
-
Transitions and Screenshots
-
Videos
-
Word Art
2. Last checks before presenting
3. Using Presenter View
4. Printing Options
5. Keyboard Shortcuts
Microsoft 365 PowerPoint Basics

Microsoft Windows 10 Overview
Windows 10 Overview
2.5 Hours
-
The Windows 10 Operating System
-
Lock screen, Log-in screen
-
Windows Settings Menu, Control Panel and GodMode
-
Windows 10 Desktop and Jump Lists
-
“Hey Cortana”
-
Review of the Windows 10 Start screen
-
Ctrl + Alt + Del key sequence
-
Libraries / Folders / Files storage hierarchy and File Explorer
-
Managing multiple windows – Task View and Virtual Desktops
-
Microsoft Edge
-
Microsoft OneDrive (Cloud Storage)
-
Microsoft Windows Defender (Security)
-
Keyboard shortcuts
Creating and Using Excel Macros
2.5 Hours
a. What is a macro?
b. VBA terminology
c. Defining lower- or upper-case letters to invoke a macro
d. Record and run Absolute macro to total North and South Sales
e. Record and run Relative macro to total North and South Sales
f. Save As workbook containing macros with .xlsm file extension
g. Define button to invoke sort of sales amount in descending order
h. Record and run Absolute macro to sort North sales amounts
i. Assign sort macro to button for Sort_by_Sales test
j. Copy and edit VBA macro code to sort South sales amounts
