Certificate in Computer Skills for the Office

Courses Included in this Certificate: 

• PowerPoint for Business
  As technology continues to change the way that we engage in business communications, the art of presenting has also undergone a shift. No longer can presenters rely solely on their spoken words to deliver their messages. Now, audiences expect to see multimedia slideshows that both inform and entertain. This course will consider how to plan and design effective slideshow presentations using Microsoft's PowerPoint software. It includes practical tips and examples for mapping the presentation, incorporating research, using templates, selecting visual elements, and delivering the presentation.
• Excel Basics         
  As big data continues to change the way businesses operate and drive strategy, the ability to efficiently and effectively organize and analyze data is crucial. Managers need to be able to utilize tools to identify trends and help make better business decisions. Microsoft's Excel is a powerful spreadsheet software to organize and manage data related to business operations. This course focuses on mastering the fundamental tasks performed in Excel, including data entry, basic formula calculations, and formatting and style operations. During the course, you will learn how to build a spreadsheet from scratch and gain a greater understanding of the most popular Excel commands and functions.
• Visual PowerPoint
  In today's professional landscape, PowerPoint presentations can be effective platforms for sharing information and garnering audience interest and support. At the same time, a poorly designed PowerPoint slideshow can quickly turn an audience away. By focusing on how to apply basic design principles to slideshow creation, this course will help learners use Microsoft's PowerPoint 365 software to build visually engaging slideshow presentations. Learners will consider how to select images and photographs for use in slides, the importance of arrangement and placement of images, the use of tools like Shapes and SmartArt, methods for presenting data, and the selection of colors and fonts that increase the readability of content.
• Excel Tips & Tricks
  This course features 25 of the most popular Excel tip and tricks for both novice and advanced Excel users. In this course, you will learn time-saving techniques to boost efficiency, increase productivity and workflow, and improve and advance your skills. Topics include data entry, data organization, data cleaning, elements of style, data sorting, data filtering, and spreadsheet display tips. This course also covers three of the most popular lookup and reference functions: VLOOKUP, HLOOKUP, and Find + Replace. To follow along with the content and activities in this course, you will need access to Microsoft Excel. This course features Excel 2019, which may differ from other versions of Excel.
• Excel Advanced Skills
  This course is designed for the learner who already has a solid understanding of Excel's basic tools and functions. The course teaches learners some of the more advanced skills and features available in Excel, which may be useful in data analysis. These skills include style templates, conditional formatting, data validation, data manipulation, and pivot tables.
• Microsoft Word Basics
  This is an introductory-level course designed to both build a foundation of essential skills in Microsoft Word and to gain a greater understanding of its interface and design elements. The course focuses on mastering the fundamental tasks performed in Word, including writing, proofing, finalizing, and printing a document.

This course includes an “Ask the Expert” feature. You can use this feature to submit questions about course content. A subject matter expert will provide guidance or point you to additional resources for the topics you’re studying. Questions are answered as quickly as possible and usually within 24 hours.

Learners must achieve an average test score of at least 70% to meet the minimum successful completion requirement and qualify to receive CEUs.