Certificate in Computer Skills for the Office

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.

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.

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.

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.

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.