Mel'shunum Office Assistant

Objectives: To experience using Microsoft Designer & Canva, learn and practice basic features listed below: Topics: A great overview/tutorial on how to use Microsoft Designer: https://heyzine.com/how-to/use-microsoft-designer/ Activity Using Microsoft Designer, create an 8.5” x 11” (A4 Portrait or A4 Landscape) … Continue reading →

Objectives: To practice using Excel features including conditional formatting, freezing panes and view options, charts, and printing. OCFP – Excel Lessons.docx OCFP – GCF Global – Excel Activities.docx Mel’shunum Shared Documents – Colin Practice Typing

Objectives: To practice using Excel features including named ranges, sorting and filtering with tables, and conditional formatting. OCFP – Excel Lessons.docx OCFP – GCF Global – Excel Activities.docx Mel’shunum Shared Documents – Colin Practice Typing

Objectives: To practice using Excel features including cell references, basic functions, absolute and relative cell references, sort, filter, tables. OCFP – Excel Lessons.docx OCFP – GCF Global – Excel Activities.docx Mel’shunum Shared Documents – Colin Practice Typing

Objectives: To practice using Mail Merge in Word and develop an understanding of how to use the basic features of Excel. OCFP – Mail Merge Practice Activity.docx OCFP – Excel Lessons.docx OCFP – GCF Global – Excel Activities.docx Practice Typing

Collaborating on a Microsoft Document https://support.microsoft.com/en-us/office/what-is-onedrive-work-or-school-10f5c3fd-b0f6-40e2-9059-04735ffe01b7 – A good introduction to OneDrive. https://learn.microsoft.com/en-us/sharepoint/introduction – Everything you want to know about Microsoft OneDrive and SharePoint and a lot more. Mail Merges For information on using GroupWise for mail merges in Word … Continue reading →

Practicum Week Work Review We’ll start today by reviewing the work that you completed during the practicum week. I understand that with my absence due to illness things were a bit confused and for that, I apologize. Objective: Collaborating on … Continue reading →

Word Skills Quick Parts Working with Templates Creating a protected form Information on Microsoft Signature services Saving Default Settings – the Normal template (“normal.dotm”) Finding and Importing a Custom Dictionary Collaborating on a Word Document Using 365 Word Activities Activity … Continue reading →

Word Skills Working with Paragraphs Check Spelling and Grammar Enable revision tracking in a document Accept or reject a revision Insert a comment in a document Delete a comment from a document Customize the Ribbon Bar Word Activity Download the … Continue reading →

Word Topics Covered in Week One Keyboard shortcuts: Word Practice Activity Create a new Word Document and complete the instructions below. Read the sample email exchange below: Negative communications can be tricky to navigate. How would you have delivered the … Continue reading →

Create and Edit Tables Work with Styles Modify Page Layout Use Graphics Activity #1 Recreate a Word document to look exactly like the image below using the features that we practiced yesterday. (You don’t have to use keyboard shortcuts unless … Continue reading →

File Management File Management Terminology File Management Activity Beginner Word Skills Move, Copy and Find and Replace Text Format Characters and Paragraphs Word Keyboard Shortcuts <Ctrl> + C = Copy <Ctrl> + X = Cut <Ctrl> + V = Paste … Continue reading →

Welcome to the Mel’shunum Office Assistant Program! On the first class we will start to get to know each other. See Colin’s biography and education statement. Classes will typically balance some Office skills with technology skills. Specific topics will be … Continue reading →