You're browsing Office Productivity Classes in Online

WorkShop Includes:  Logical Test  IF, AND, OR Functions  SUMIFS Function  INDEX & MATCH Merge Data with INDEX, MATCH Functions Text Manipulation and Cleaning Data  Date Function Table Objects

Learn how to create a slideshow presentation using Microsoft PowerPoint. Topics include creating and editing slides, inserting images, and running your slideshow. Skill prerequisites: Computer Basics You will receive an email 2 hours prior to the start of the class with the link to join the virtual class. *Please note that some people using older...

Learn how to build basics spreadsheets & get comfortable using Microsoft Excel in working environment. This workshop is best suited for those who have very little or no experience with Microsoft Excel. Workshop Includes: Overview Of Microsoft Excel User Interface Working with Workbook Working with Worksheets Working With Worksheet Tabs ...

Course Overview This course covers fundamental AWS cloud security concepts, including AWS access control, data encryption methods, and how network access to your AWS infrastructure can be secured. Based on the AWS Shared Security Model, you learn where you are responsible for implementing security in the AWS Cloud and what security-oriented services...

The leader in creating spreadsheets and data presentation, topics include: Basic worksheet navigation, entry techniques, cell references, using the command groups & settings, formulas & functions, charts & graphs and simple database operations.  Continuing classes include a overview of Excel's vast collection of formulas and functions....

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...

Create vector-based graphics that can be easily rescaled without loss of quality. Learn basic tools & fundamentals, features for creating distinct designs include painterly/fluid brushes, shape-building tools, and path controls.  There are also different transparency and gradients tools available for a variety of illustrations and mediums....

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...

WorkShop Includes: How to Record and Use Macros VBA Syntax Introduction to VBA Development Writing to Cells & Ranges Modifying Recorder Macros If Then Else Statement Simple For Loops Workshop is led by an Excel Power User/Excel VBA Developer/Data Driven Application Developer. We recommend having a USB flash drive if you want to keep your work...

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...

Students will gain proficiency in creating procedures that run in response to specific events, working with control structures,developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code.

MS Word for Windows allows you to create and format personal and professional documents and tables of all kinds. Level 1 teaches basic skills to create, edit, and format texts. Students must have MS Office Word software installed on their computer. Previous knowledge or experience: Understanding of the basics of Windows Note: Class time...

Analyze, manage, and share data of all kinds, from personal and professional budgeting to scheduling. In Level 2 learn to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas. Students must have MS Office Excel software installed on their computer to participate in class. Overview: Learn how to create advanced...

Learn the basics of creating spreadsheets in Excel. Enter data, formulas, format and print workbooks. Target Student This course is for individuals whose job responsibilities include creating, inputting and printing basic spreadsheets. Prerequisites Basic Windows, keyboarding and mouse skills. Course Outline Getting Started Starting Excel Opening...

The fundamental-level full day course is intended for individuals who seek an overall understanding of the AWS Cloud, independent of specific technical roles. It provides a detailed overview of cloud concepts, AWS services, security, architecture, pricing, and support. It includes lab exercises reinforcing some of the core concepts of the lecture....