Newbarry College of Business Services and Technology Crown Academy Innunco Academy

Microsoft Office Suite

  • Description
  • Knowledge & Skills
  • Curriculum
  • Textbooks/Manuals
  • Teaching & Evaluation

This course will enable learners to navigate the functionalities of Microsoft Office, PowerPoint, Outlook, and Excel. This course provides learners with essential foundational excel skills for all areas of business. Learners will also learn how to create impactful PowerPoint presentations by customizing animation effects and including media. This course offers learners with the ability to efficiently perform daily Outlook tasks and work confidently with Microsoft Office. The course is intended to advance learners’ knowledge and understanding of Microsoft Suites which are an integral part of all business activities and careers.

Knowledge & Skills

  • Microsoft Word

Learn the basic features of Microsoft Word and how to efficiently utilize this software in student’s future career. Including features such as modify the structure and appearance of text, collaborate on documents, and merge data with documents and labels.

  • Microsoft PowerPoint

Students will learn how to use PowerPoint to build presentations for different purposes. We will cover some PowerPoint functions such as, creating slides, managing simple graphics, and adding sound and movement to slides.

  • Microsoft Outlook

Through this course you will learn how to effectively use Microsoft Outlook email. This course includes basics such as how to set up Outlook, send and receive email messages, and organize student’s inbox. Students will also learn how to manage your scheduling with the Calendar and Tasks features.

  • Microsoft Excel

In this course students will be able to learn how to perform calculations on Excel with data, manage worksheet data, reorder and summarize data, and analyze alternative data sets. Upon completion of this course, students will be comfortable navigating the Excel user interface, entering, manipulating and formatting data.

Course Content

1. Explore Office (1 Hour) Work in the Office user interface (2 Minutes) Identify app window elements (7 Minutes) Sidebar: Tell me what you want to do (5 Minutes) Work with the ribbon and status bar (5 Minutes) Sidebar: Adapt exercise step (5 Minutes) Change Office and app options (2 Minutes) Manage account information (2 Minutes) Manage app options (7 Minutes) Customize the Quick Access Toolbar (7 Minutes) Customize the ribbon (9 Minutes) Skills review (4 Minutes) Practice tasks (5 Minutes) 2. Create and Manage Files (1 Hour) Create files (6 Minutes) Open and move around in files (10 Minutes) Display different views of file (10 Minutes) Display and edit file properties (3 Minutes) Sidebar: File types and compatibility with earlier versions of Office apps (9 Minutes) Save and close files (8 Minutes) Sidebar: Save files to OneDrive (4 Minutes) Skills review (5 Minutes) Practice tasks (5 Minutes) 3. Modify the structure and appearance of text (2 Hours) Apply paragraph formatting (5 Minutes) Configure alignment (5 Minutes) Configure vertical spacing (8 Minutes) Configure indents (5 Minutes) Sidebar: configure paragraph borders and shading (2 Minutes) Structure content manually (19 Minutes) Apply character formatting (19 Minutes) Sidebar: Character formatting and case considerations (5 Minutes) Create and modify lists (8 Minutes) Sidebar: Format text as you type (5 Minutes) Apply built-in styles to text (2 Minutes) Apply styles (7 Minutes) Manage outline levels (5 Minutes) Change document theme (15 Minutes) Skills review (5 Minutes) Practice tasks (5 Minutes) 4. Collaborate on Documents (2 Hours) Mark up documents (2 Minutes) Insert comments (5 Minutes) Track changes (14 Minutes) Display and review document markup (2 Minutes) Display markup (10 Minutes) Review and respond to comments (5 Minutes) Review and process tracked changes (7 Minutes) Sidebar: Remember to check for errors (3 Minutes) Compare and mere documents (5 Minutes) Compare and combine separate copies of a document (5 Minutes) Compare separate versions of a document (5 Minutes) Control content changes (5 Minutes) Restrict actions (15 Minutes) Restrict access by using password (15 Minutes) Sidebar: Restrict access by using rights management (2 Minutes) Coauthor documents (10 Minutes) Skills review (5 Minutes) Practice tasks (5 Minutes) 5. Merge data with documents and labels (2 Hours) Understand and mail merge process (5 Minutes) Start the mail merge process (5 Minutes) Get started with letters (8 Minutes) Get started with labels (5 Minutes) Get started with email messages (2 Minutes) Choose and refine data source (19 Minutes) Select an existing data source (19 Minutes) Refine the data source records (5 Minutes) Sidebar: Refresh data (8 Minutes) Insert merge fields (5 Minutes) Preview and complete the merge (2 Minutes) Create individual envelopes and labels (7 Minutes) Generate individual envelopes (5 Minutes) Generate individual mailing labels (15 Minutes) Skills review (5 Minutes) Practice tasks (5 Minutes) 6. Perform calculations on data (1 Hour) Name groups of data (5 Minutes) Define Excel tables (5 Minutes) Create formulas to calculate values (15 Minutes) Sidebar: Operators and precedence (2 Minutes) Summarize data that meets specific conditions (8 Minutes) Set iterative calculation options and enable or disable automatic calculation (5 Minutes) Use array formulas (3 Minutes) Find and correct errors in calculations (8 Minutes) Skills review (4 Minutes) Practice tasks (5 Minutes) 7. Manage worksheet data (1 Hour) Limit data that appears on your screen (10 Minutes) Manipulate worksheet data (6 Minutes) Sidebar: Select list rows at random (6 Minutes) Summarize data in worksheets that have hidden and filtered rows (8 Minutes) Find unique values within a data set (10 Minutes) Define valid sets of values for ranges of cells (10 Minutes) Skills review (5 Minutes) Practice tasks (5 Minutes) 8. Reorder and summarize data (1 Hour) Sort worksheet data (10 Minutes) Sort data by using custom lists (10 Minutes) Organize data into levels (10 Minutes) Look up information in a worksheet (10 Minutes) Skills review (10 Minutes) Practice tasks (10 Minutes) 9. Analyze alternative data sets (1 Hour) Examine data by using the Quick Analysis Lens (4 Minutes) Define an alternative data sets (5 Minutes) Define multiple alternative data sets (5 Minutes) Analyze data by using data table (6 Minutes) Vary your data to get a specific result by using Goal Seek (8 Minutes) Find optimal solutions by using Solver (12 Minutes) Analyze data by using descriptive statistics (10 Minutes) Skills review (5 Minutes) Practice tasks (5 Minutes) 10. Create and manage slides (1 Hour) Add and remove slides (4 Minutes) Insert new slides (2 Minutes) Copy and import slides and content (8 Minutes) Sidebar: SharePoint slide libraries (3 Minutes) Hide and delete slides (3 Minutes) Divide presentations into sections (3 Minutes) Rearrange slides and sections (8 Minutes) Apply themes (5 Minutes) Change slide backgrounds (10 Minutes) Sidebar: Non-theme colors (4 Minutes) Skills review (5 Minutes) Practice tasks (5 Minutes) 11. Insert and manage simple graphics (2 Hours) Insert, move and resize pictures (10 Minutes) Sidebar: Graphic formats (6 Minutes) Edit and format pictures (6 Minutes) Draw and modify shapes (6 Minutes) Draw and add text to shapes (10 Minutes) Sidebar: Locate additional formatting commands (6 Minutes) Move and modify shapes (5 Minutes) Format shapes (6 Minutes) Sidebar: Connect shapes (5 Minutes) Capture and insert screen clippings (25 Minutes) Create a photo album (25 Minutes) Skills review (5 Minutes) Practice tasks (5 Minutes) 12. Add sound and movement to slides (1 Hour) Animate text and pictures on slides (7 Minutes) Sidebar: Animate this (6 Minutes) Customize animation effects (10 Minutes) Sidebar: Bookmark points of interest in media clips (6 Minutes) Add audio content to slides (7 Minutes) Add video content to slides (6 Minutes) Compress media to decrease file size (4 Minutes) Skills review (5 Minutes) Sidebar: Hyperlink to additional resources (4 Minutes) Practice tasks (5 Minutes) 13. Send and receive email messages (1 Hour) Create and send messages (2 Minutes) Create messages (4 Minutes) Troubleshoot message addressing (4 Minutes) Save and send messages (4 Minutes) Sidebar: Send from a specific account (5 Minutes) Attach files and Outlook items to messages (6 Minutes) Sidebar: New mail notifications (4 Minutes) Display messages and message attachments (2 Minutes) Display message content (2 Minutes) Display attachment content (3 Minutes) Display message participant information (5 Minutes) Respond to messages (4 Minutes) Sidebar: Resending and recalling messages (5 Minutes) Skills review (5 Minutes) Practice tasks (5 Minutes) 14. Organize your inbox (1 Hour) Display and manage conversations (7 Minutes) Arrange messages by specific attributes (7 Minutes) Categorize items (6 Minutes) Sidebar: Store information in Outlook notes (8 Minutes) Organize messages in folders (12 Minutes) Sidebar: Print messages (8 Minutes) Skills review (5 Minutes) Practice tasks (5 Minutes) 15. Manage scheduling Schedule appointments and events (4 Minutes) Sidebar: Add holidays to your calendar (4 Minutes) Convert calendar items (5 Minutes) Configure calendar item options (8 Minutes) Schedule and change meetings (10 Minutes) Respond to meeting requests (6 Minutes) Display different views of a calendar (8 Minutes) Sidebar: Use the Date Navigator (5 Minutes) Skills review (5 Minutes) Practice tasks (5 Minutes)

  • Textbook: Joan Lambert, Curtis Frye, Microsoft Office 2019: Step by Step (2019)
  • BYOD: Computer/laptop with webcam
  • Excel, Word, PowerPoint, Teams and Outlook installed on PC/ Mac
  • Office 2019 or Office 365 recommended 

Students will have three options of delivery method for this course: Online Streaming, Free Self-study Online, and On-campus. For inquiries regarding course tuition and other fees, please contact our Admission Officer at +1 (416) 230-1816 or email info@newbarryc.com.

Related Courses


Certificate Program

Enrolled


Microsoft Office Suite

This course will enable learners to navigate the functionalities of Microsoft Office, PowerPoint, Outlook, and Excel. This course provides learners with essential foundational excel skills for all areas of business. Learners will also learn how to create…

See more…

Enrolled


Air Ticketing: Amadeus

This course offers field-specific content on the operations of the common professional system: Amadeus ticketing platform. Students will become proficient with basic functions of…

See more…

Enrolled


Air Ticketing: Sabre

This course offers field-specific content on the operations of the common professional system: Sabre ticketing platform. Students will have hands-on learning on…

See more…



Registered as a private career college under the Private Career College Act, 2005.

The Newbarry College of Business, Service and Technology is a member of the National Association of Career Colleges.

 The Newbarry College of Business, Service and Technology is a member of the Career Colleges of Ontario.

© 2020 NEWBARRY. ALL RIGHTS RESERVED.