You're browsing Office Productivity Classes in Online

Learn the basics of working with spreadsheets using Microsoft Excel. Topics include entering data and formulas, moving and copying data, formatting & print previewing worksheets. Please note: Must register with a valid email address. You will receive an email 2 hours prior to the start of the class with the link to join the virtual...

Explore more advanced features of Microsoft Excel. Topics include using formulas and functions, absolute cell references, data sorting and filtering, and conditional formatting. To participate hands-on in this class, it is advised that you have one of the following versions of Excel: PC - 2010, 2013 , 2016 , 2019 Mac - 2016 , 2019 You will...

Course Overview Migrating to AWS focuses on planning and migrating existing workloads to the AWS Cloud. The course covers various cloud migration strategies with a detailed discussion on each phase of the migration process, including portfolio discovery, application migration planning and design, migration execution, and post-migration validation...

Course Overview AWS Technical Essentials introduces you to AWS products, services, and common solutions. It provides you with fundamentals to become more proficient in identifying AWS services so that you can make informed decisions about IT solutions based on your business requirements and get started working on AWS. Target Audience This course...

Course Overview Architecting on AWS covers the fundamentals of building IT infrastructure on AWS. The course is designed to teach solutions architects how to optimize the use of the AWS Cloud by understanding AWS services and how these services fit into cloud-based solutions. This course emphasizes AWS cloud best practices and recommended design...

Course Overview This course demonstrates how to efficiently use AWS security services to stay secure in the AWS Cloud. The course focuses on the security practices that AWS recommends for enhancing the security of your data and systems in the cloud. The course highlights the security features of AWS key services including compute, storage, networking,...

Course Overview DevOps Engineering on AWS demonstrates how to use the most common DevOps patterns to develop, deploy, and maintain applications on AWS. The course covers the core principles of the DevOps methodology and examines a number of use cases applicable to startup, small and medium-sized business, and enterprise development scenarios Target...

In this three-hour session for Windows and Mac users, you will learn how to write complex formulas using Excel's advanced built-in functions. You will expand your library of functions to include lookup and reference functions, conditional logic, database summarization functions, and dynamic array functions. You will also become expert at using mixed...

Learn PivotTables, advanced formatting, sorting and filtering, outlines, subtotals, advanced charting & more! Class Outline: Lesson 1: Working with Functions Topic A: Work with Ranges Topic B: Use Specialized Functions Topic C: Work with Logical Functions Topic D: Work with Date & Time Functions Topic E: Work...

Course Overview Developing on AWS helps developers understand how to use the AWS SDK to develop secure and scalable cloud applications. The course provides in-depth knowledge about how to interact with AWS using code and covers key concepts, best practices, and troubleshooting tips. Target Audience This course is intended for Intermediate-level...

PowerPoint is used to develop presentation materials. We’ll create text, charts and graphs to be used in electronic presentations or handouts. We’ll also work with slide masters and templates, create objects and use clip art. You will also learn how to apply transitions for electronic presentations.

Learn more about creating a slideshow presentation using Microsoft PowerPoint. Topics include creating and editing slides, editing master slides, adding animations, and running your slideshow. More Info Skill prerequisites: Keyboard and mouse skills Audience: Adults Instructors will send out an email two hours before the class starts

Students will learn to move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. They will also learn how to navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks. This course also covers simple functions used in formulas...

Course Overview This course combines Architecting on AWS and Advanced Architecting on AWS to offer a comprehensive, immersive course in cloud architecture. It covers all aspects of how to architect for the cloud over 5 days. You will learn how to design cloud architectures, starting small and working to large-scale enterprise level designs—and everything...

In this class you’ll learn how to create and send messages, sort emails, work with e-mail messages, schedule appointments, insert events, add and edit contacts, create and edit tasks, work with calendar features, and much more!