You're browsing Office Productivity Classes in Online

Course Overview The Advanced Developing on AWS course uses the real-world scenario of taking a legacy, on-premises monolithic application and refactoring it into a serverless microservices architecture. This three-day advanced course covers advanced development topics such as architecting for a cloud-native environment; deconstructing on-premises,...

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 System Operations on AWS is designed to teach those in a Systems Administrator or Developer Operations (DevOps) role how to create automatable and repeatable deployments of networks and systems on the AWS platform. The course covers the specific AWS features and tools related to configuration and deployment, as well as common techniques...

Shotgrid Production Tracking, Review, and Management Using Shotgrid During this 8-week course focusing on Autodesk Shotgrid (formerly known as Shotgun,) bring your lunch and feed your brain with new info, too! Starting with Shotgrid Basics, each online session will focus on different aspects of Producing, Tracking, Reviewing and Managing your project...

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

Learn to perform mail merges. Create forms and master documents that include a table of contents; table of figures; footnotes; endnotes; and more. Create macros, customize the ribbon and Quick Access toolbar. Course Content Lesson 1: Manipulating Images Topic A: Integrate Pictures and Text Topic B: Adjust Image Appearance Topic C: Insert Other...

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.

The focus of this class is the design of an Access database. You will learn how to create tables and basic forms, basic queries, and basic reports. We will cover planning a database, finding records, editing data, and using sorting and filters. Input masks and validation will be covered to help get correct information into your database. Class Outline...

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 In this course, you will learn about the process of planning and designing both relational and nonrelational databases. You will learn the design considerations for hosting databases on Amazon Elastic Compute Cloud (Amazon EC2). You will learn about our relational database services including Amazon Relational Database Service (Amazon...

Learn how to use action queries, use calculated fields, adjust data types, set field properties, and perform database maintenance. You will also use input masks, use controls in forms, learn the lookup feature, and work further with queries and reports. Class Outline Unit 1: Designing a Relational databases Topic A: Relational database 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,...

Learn Excel to edit and manipulate your spreadsheets This Advanced Excel Class focuses solely on solving complex problems with your data. We will walk you all the way through the basics of formula creation to advanced logical and look-up functions. Learn Excel with our hands-on training in this Advanced Excel class – Formulas & Functions. You...

Learn the principles of table relationships; advanced query techniques; an introduction to functions, macro actions, advanced form techniques including using macros in forms; database security, and advanced report techniques. Class Outline Unit 1: Implementing Advanced Form Design Topic A: Add Controls to Forms Topic B: Enhance navigation...

Course Overview Data Warehousing on AWS introduces you to concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift, the petabyte-scale data warehouse in AWS. This course demonstrates how to collect, store, and prepare data for the data warehouse by using other AWS services such as Amazon...