| Critical Elements of Customer Service · View Details | $395.00 | October 2, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Critical Elements of Customer Service
October 2, 2026 — 6:00 AM PDT–1:30 PM PDT
Critical Elements of Customer Service
While many companies promise to deliver an incredible customer experience, some are better at supplying this than others. This course is designed around six critical elements of customer service that, when a company truly embraces them, bring customers back to experience service that outdoes the competition.
Course Objectives
· Understand what a customer service approach is
· Understand how your own behavior affects the behavior of others
· Demonstrate confidence and skill as a problem solver
· Apply techniques to deal with difficult customers
· Know how to provide excellent customer service
Outline
Session One: Course Overview Learning Objectives
Pre-Assignment
Pre-Course Assessment
Session Two: What is Customer Service?
Who Are Your Customers?
Meeting Expectations
Session Three: Pre-Assignment Review
Pre-Assignment Review
Making Connections
Session Four: Setting Goals
Creating a Personal Values Statement
Step One: Identify Your Values
Step Two: Define Your Values
Step Three: Put It All Together
Identifying and Setting Goals
Our Values Statement
What is a SMART Goal?
How to Create a SMART Goal Statement
Making Connections
Session Five: The Critical Elements of Customer Service
Six Elements of Customer Service
The First Critical Element – A Focus on Customer Service
Session Six: The Second Critical Element – Procedures
What are Our Standards?
Drafting Standards
Making Connections
Session Seven: The Third Critical Element – Culture
What Do You Think?
Creating a Customer Service Culture Quiz
Session Eight: The Fourth Critical Element – Problem-Solving
Seven Steps to Customer Problem Solving
Making Connections
Session Nine: The Fifth Critical Element – Measurement Tools to Use
Measurement in Practice
Session Ten: The Sixth Critical Element – Reinforcement
Reinforcement Techniques
Developing and Maintaining Relationships
Recognizing the Power of Your Behavior
Likeability Works
Session Eleven: Communication Skills Defining Communication
Body Language Basics
Voice
Asking Questions
Empathy
Dangerous Misconceptions
Power Talk
How to Feel Powerful in Your Position
Basics of Good Communication
Session Twelve: Telephone Techniques Telephone Basics
Handling Everyday Requests
Taking a Message
Tips and Tricks
Session Thirteen: Dealing With Difficult Customers
Reducing Conflict
When Discussions Degenerate into Conflict
Caller Behavior
Session Fourteen: Dealing With Challenges Assertively
An Assertiveness Model
An Assertiveness Model Example
Dealing With Challenges
Session Fifteen: Dealing With Difficult People
Getting to the Heart of the Matter
What is Missing?
The Three F’s
Serving Difficult People
The Recovery Process
Session Sixteen: Reflective Practice
Conducting a Reflection
Reflections
Reflective Diary
Reflective Questions
Session Seventeen: Dealing With Stress
About Stress
Personal Action Plan
Starting Point
Where I Want to Go
How I Will Get There
| Adobe InDesign CC: Part 1 · View Details | $395.00 | October 2, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Adobe InDesign CC: Part 1
October 2, 2026 — 6:00 AM PDT–1:30 PM PDT
Adobe InDesign CC: Part 1
Giving your documents a well-designed, professional look will put you a step ahead in the marketplace cluttered with all kinds of communications. Paragraph and character styles that allow you to format pages of text uniformly, layout features that help you to build alternate size configurations of your document, and various panels that enable you to easily customize both text and graphics; Adobe® InDesign® has all the tools you need to elevate the look of your document and get it out to the people who need to see it, whether it be in print or on the web.
This course is a great component of your preparation for the Adobe Certified Professional Print & Digital Media Publication Using Adobe InDesign exam.
This course is the first part of a two-course series that covers the skills needed to gain a foundational understanding of InDesign.
– Adobe InDesign CC: Part 1 (this course)
– Adobe InDesign CC: Part 2
Completion of this course will earn 7.5 CPEs.
Course Objectives:
In this course, you will use Adobe InDesign (2020) to create and deliver professional looking printed and interactive documents.
You will:
– Navigate the InDesign interface
– Create a new document
– Customize a document using color, swatches, gradients, and styles
– Manage page element
– Add tables
– Prepare documents for deployment
Target Student:
This course is intended for students who want to use the basic tools and features of InDesign for creating professional page layouts and designs. It’s also for anyone interested in working toward the Print & Digital Media Publication Using Adobe InDesign certification.
Prerequisites:
To ensure your success in this course, you should be familiar with the functions of your computer’s operating system such as creating folders, launching programs, copying and pasting objects, formatting text, retrieving files, and saving files. You can obtain this level of skill and knowledge by taking one of the following Logical Operations courses:
– Using Microsoft® Windows® 10
– Microsoft® Windows® 10: Transition from Windows® 7
Outline
- Lesson 1: Getting Started with InDesign
- Topic A: Identify Components of the InDesign Interface
- Topic B: Customize the InDesign Interface
- Topic C: Apply the Navigation Controls and Set Preferences
- Lesson 2: Designing a Document
- Topic A: Establish Project Requirements
- Topic B: Apply Design Principles
- Topic C: Create a New Document
- Topic D: Add Text to a Document
- Topic E: Add Graphics to a Document
- Lesson 3: Customizing a Document
- Topic A: Format Characters and Paragraphs
- Topic B: Apply Colors, Swatches, and Gradients
- Topic C: Create and Apply Styles
- Lesson 4: Working with Page Elements
- Topic A: Arrange and Align Objects
- Topic B: Apply Layers
- Topic C: Transform and Manipulate Objects
- Topic D: Thread Text Frames
- Topic E: Edit Text
- Lesson 5: Building Tables
- Topic A: Create and Modify a New Table
- Topic B: Format a Table
- Lesson 6: Preparing a Document for Delivery
- Topic A: Resolve Errors in a Document
- Topic B: Export Files for Printing and for the Web
- Appendix A: Mapping Course Content to the Adobe Certified Professional in Print & Digital Media Publication Using Adobe InDesign Exam
- Appendix B: Productivity Enhancements
| Microsoft Publisher for Office 365/2021 · View Details | $395.00 | October 2, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Microsoft Publisher for Office 365/2021
October 2, 2026 — 6:00 AM PDT–1:30 PM PDT
Microsoft Publisher for Office 365/2021
Microsoft® Publisher for Office 365/2021 is a desktop publishing software application capable of producing greeting cards, certificates, newsletters, and other printed publications. Publisher includes a large collection of templates that provide a great way to start a new publication. Publisher offers a large selection of “building blocks” that can be dragged into your documents, helping you to create page elements such as calendars, newsletter sidebars, and borders. Publisher integrates online sharing and mail merge features, which are handy when you need to send publications to a list of customers, and it’s possible to export publications as HTML web pages or PDF documents. With a user-friendly interface, Publisher makes it easy to create and edit publications.
This course presents information and skills that are appropriate for users of the Office 2019 or Office 365 desktop applications. However, the instructional environment for the delivery of this course utilizes Office 365.
Completion of this course will earn 7.5 CPEs.
Course Objectives:
In this course, you will create, format, edit, and share publications.
You will:
– Perform basic tasks in the Microsoft Publisher interface.
– Add content to a publication.
– Format text and paragraphs in a publication.
– Manage text in a publication.
– Work with graphics in a publication.
– Prepare a publication for printing and sharing.
Target Student:
This course is intended for persons in a variety of job roles such as publishing specialists, layout specialists, graphic designers, or any other knowledge workers who need to use Microsoft Office Publisher to create, lay out, edit, and share publications.
Prerequisites:
To ensure your success in this course, you should have experience with basic Microsoft® Windows® 10 tasks and be comfortable in the Windows 10 environment.
You can obtain this level of skills and knowledge by taking either of the following Logical Operations courses:
Microsoft® Windows® 10: Transition from Windows® 7
Using Microsoft® Windows® 10
Outline
- Lesson 1: Getting Started with Microsoft Publisher
- Topic A: Navigate the Interface
- Topic B: Customize the Publisher Interface
- Topic C: Create a Publication
- Lesson 2: Adding Content to a Publication
- Topic A: Add Text to a Publication
- Topic B: Add Pages and Picture Placeholders to a Publication
- Topic C: Control the Display of Content in Text Boxes
- Topic D: Apply Building Blocks to a Publication
- Lesson 3: Formatting Text and Paragraphs in a Publication
- Topic A: Format Text
- Topic B: Format Paragraphs
- Topic C: Apply Schemes
- Lesson 4: Managing Text in a Publication
- Topic A: Edit Text in a Publication
- Topic B: Work with Tables
- Topic C: Insert Symbols and Special Characters
- Lesson 5: Working with Graphics in a Publication
- Topic A: Insert Graphics in a Publication
- Topic B: Customize the Appearance of Pictures
- Lesson 6: Preparing a Publication for Sharing and Printing
- Topic A: Check the Design of a Publication
- Topic B: Save a Publication in Different Formats
- Topic C: Print a Publication
- Topic D: Share a Publication
- Appendix A: Automating Communication Using Mail Merge
| Microsoft Teams for Business Users (Second Edition) · View Details | $350.00 | October 2, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Microsoft Teams for Business Users (Second Edition)
October 2, 2026 — 6:00 AM PDT–1:30 PM PDT
Microsoft Teams for Business Users
This course is designed to help you master Microsoft Teams®, the key communications tool in the suite of Microsoft 365® productivity apps. Microsoft Teams enables individuals and organizations to chat, share ideas, collaborate on files, and essentially, work together. You can use Teams to have a quick chat with a colleague, participate in a virtual meeting, make an online call, and share files and resources. You can also create and configure Teams to suit your business productivity needs. The Microsoft Teams app is available in three versions: a desktop app, a web app, and a mobile app. Once you are familiar with the Teams desktop app, you can easily transfer that knowledge and work in the web and mobile apps to take advantage of connecting through Teams wherever your work takes you.
Course Objectives:
– Communicate with colleagues in Teams
– Call and meet with people in Teams
– Lead a meeting
– Configure your Teams environment
– Share files and app content
– Create and configure Teams
Outline
- Lesson 1: Messaging in Teams
- Topic A: Navigate in Teams
- Topic B: Chat with Contacts
- Topic C: Post in Team Channels
- Lesson 2: Calling and Meeting in Teams
- Topic A: Call People in Teams
- Topic B: Meet in Teams
- Lesson 3: Leading Meetings in Teams
- Topic A: Conduct Presentations
- Topic B: Manage Meetings
- Lesson 4: Configuring Your Teams Environment
- Topic A: Configure General Application Settings
- Topic B: Configure Notifications and Privacy Settings
- Topic C: Configure Call and Device Settings
- Lesson 5: Sharing Files and App Content in Teams
- Topic A: Share Files
- Topic B: Add Apps and Connectors
- Lesson 6: Creating and Configuring Teams
- Topic A: Create and Manage a Team
- Topic B: Create and Configure Channels
- Topic C: Add and Configure Channel Tabs
| Microsoft Project 2019-2024/365: Part 1 · View Details | $350.00 | October 2, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Microsoft Project 2019-2024/365: Part 1
October 2, 2026 — 6:00 AM PDT–1:30 PM PDT
Microsoft Project 2019-2024/365: Part 1
Welcome to Microsoft® Project® 2019-2024/365: Part 1. This course is designed to familiarize you with the basic features and functions of Microsoft Project so you can effectively and efficiently manage projects in a real-world environment.
This course covers the critical knowledge and skills a project manager needs to create a project plan with Microsoft Project during the planning phase of a project. In other words, if your supervisor assigns you to lead a project, this course will enable you to draft a project plan with Microsoft Project and share it with your supervisor (and others) for review and approval.
This material will benefit users of any current Project desktop version. The classroom environment setup is based on Project 2021.
The subject of this course is the Microsoft Project desktop app. A brief description of the Project for the web and the Project Online apps is presented in the Appendix.
Note: You can procure a license for the Project desktop app in one of two ways: purchasing a cloud-based subscription or an on-premises license. Project Online is included in both of the following purchase options:
– Cloud-based subscription: Project Plan 3 or 5. (Microsoft Project is not included in the Microsoft 365 plans. A separate subscription plan is required.)
– On-premises solution: Project Professional 2021.
Completion of this course will earn 7.5 CPEs.
Course Objectives:
In this course, you will be able to construct basic project plans using Microsoft Project. You will:
– Identify project management concepts and navigate Microsoft Project Professional
– Create a new project plan
– Add tasks to a project
– Manage task relationships within a project
– Manage project resources
– Optimize and share a project plan
Target Student:
This course is designed for professionals who manage projects and need to be able to use Microsoft Project to create basic project plans. Some knowledge and understanding of project management concepts will be helpful, along with general desktop computer skills.
Outline
- Lesson 1: Getting Started with Microsoft Project
- Topic A: Identify Project Management Concepts
- Topic B: Navigate in the Microsoft Project Desktop Environment
- Lesson 2: Defining a Project
- Topic A: Create a New Project Plan
- Topic B: Set Project Plan Options
- Topic C: Assign a Project Calendar
- Lesson 3: Adding Project Tasks
- Topic A: Add Tasks to a Project Plan
- Topic B: Enter Task Duration Estimates
- Lesson 4: Managing Tasks
- Topic A: Create a Work Breakdown Structure
- Topic B: Define Task Relationships
- Topic C: Schedule Tasks
- Lesson 5: Managing Project Resources
- Topic A: Add Resources to a Project
- Topic B: Create a Resource Calendar
- Topic C: Enter Costs for Resources
- Topic D: Assign Resources to Tasks
- Topic E: Resolve Resource Conflicts
- Lesson 6: Finalizing a Project Plan
- Topic A: Optimize a Project Plan
- Topic B: Set a Baseline
- Topic C: Share a Project Plan
- Appendix A: Using Project in the Cloud
| Business Writing That Works · View Details | $395.00 | October 6, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Business Writing That Works
October 6, 2026 — 6:00 AM PDT–1:30 PM PDT
Business Writing That Works
We all know what good writing is. It’s the novel we can’t put down, the poem we never forgot, and the speech that changes the way we look at the world. Good writing is the memo that gets action and the letter that says what a phone call can’t.
In business writing, the language is concrete, the point of view is clear, and the points are well expressed. Good writing is hard work, and even the best writers get discouraged.
However, with practice you can feel more confident about your own writing. This course will give you the tools to become a better writer.
Completion of this course will earn 7.5 CPEs.
Learning Objectives
• Learn the value of good written communication
• Learn how to write and proofread your work so it is clear, concise, complete, and correct
• Apply these skills in real world situations
• Understand the proper format for memos, letters, and e-mails
Outline
- Why Write?
- Becoming a Better Writer
- Communicating a Message
- Be Clear
- Choosing What to Say
- Removing the Noise
- Simplifying Sentences
- Clarify the Convolution
- Be Concise
- Writing Concisely
- Our Tightened Sentences
- Our Updated Language
- Be Complete
- Making Your Writing Complete
- Two Keys: Empathy and Flexibility
- Be Correct
- Common Writing Errors
- Word Agreement
- Making Words Agree
- Modifiers and Describers
- Active and Passive Voice
- Passive and Active Voice Examples
- Passive to Active
- Sentences and Sentence Types
- Breaking Down a Paragraph
- Reorganizing a Paragraph
- Readability Index
- Calculating the Index Automatically
- How Foggy Is My Writing?
- Manners and Courtesy
- Courtesy in Your Writing
- My Letter Writing Style
- Practical Language
- Word Usage Rules
- Using That and Which
- Playing with Language
- Inclusive Language
- Cheat Sheet
- Sentence Construction
- Parallel Construction
- Punctuation
- The Comma
- The Semi-Colon
- The Colon
- The Apostrophe
- Writing Business Letters
- Parts of a Business Letter
- Persuasion Letters
- Beginning Letters
- Expressions and Guidelines
- Strategies and Recommendations
- Writing Effective E-mails
- The Subject Line
- Formatting
- Attachments
- Spell Check
- Reply All
- Privacy
- Shorthand
- E-mail at Work
- Spelling and Proofreading
- Learning to Look
- Being a Good Proofreader
- Proofreading Practices
- Performance Article
- Identifying the Errors
- The Edited Article
- Writing Memos
- The Anatomy of a Memo
- Reviewing Your Writing
- Checking Back
- Reviewing the Checklist
- Writing Challenges
- Top Ten Writing Challenges
- Guidelines for Capitalization
- A Personal Action Plan
- Where I Want to Go
- How I Will Get There
| Microsoft Excel for Office 365 (Desktop or Online): Part 1 · View Details | $320.00 | October 6, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Microsoft Excel for Office 365 (Desktop or Online): Part 1
October 6, 2026 — 6:00 AM PDT–1:30 PM PDT
Microsoft Excel for Office 365 (Desktop or Online): Part 1
Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software. This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation.
Note: Most Office 365™ users perform the majority of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will also enable you to access and effectively utilize many web-based resources provided with your Office 365 subscription. This includes brief coverage of key skills for using Excel for the Web and OneDrive. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version.
This course is the first part of a three-course series that covers the skills needed to gain a foundational understanding of Excel.
– Microsoft Excel for Office 365 (Desktop or Online): Part 1 (this course)
– Microsoft Excel for Office 365 (Desktop or Online): Part 2
– Microsoft Excel for Office 365 (Desktop or Online): Part 3
This course may be a useful component in your preparation for the Microsoft Excel (Microsoft 365 Apps and Office 2019): Exam MO-200 and Microsoft Excel Expert (Microsoft 365 Apps and Office 2019): Exam MO-201 certification exams.
Completion of this course will earn 7.5 CPEs.
Course Objectives:
In this course, you will learn fundamental Excel skills.
You will:
– Familiarize yourself with Excel’s layout, its various parts, its commands, and its terminology
– Outline Excel’s abilities to quickly, efficiently, and accurately calculate data
– Update worksheets without throwing away all of the valuable work you’ve already done
– Format a worksheet and organize your data
– Print workbooks
– Manage the overall structure of your workbooks
Target Student:
This course is intended for students who wish to gain the foundational understanding of Excel that is necessary to create and work with electronic spreadsheets.
Prerequisites:
To ensure your success, you should have end-user skills with any current version of Windows, including being able to start and close applications, navigate basic file structures, manage files and folders, and access websites using a web browser.
Outline
- Lesson 1: Getting Started with Excel
- Topic A: Navigate the Excel User Interface
- Topic B: Use Excel Commands
- Topic C: Create and Save a Basic Workbook
- Topic D: Navigate in Excel for the Web
- Topic E: Enter Cell Data
- Lesson 2: Performing Calculations
- Topic A: Create Worksheet Formulas
- Topic B: Insert Functions
- Topic C: Reuse Formulas and Functions
- Lesson 3: Modifying a Worksheet
- Topic A: Adjust Cells, Columns, and Rows
- Topic B: Search for and Replace Data
- Topic C: Use Proofing and Research Tools
- Lesson 4: Formatting a Worksheet
- Topic A: Apply Text Formats
- Topic B: Apply Number Formats
- Topic C: Align Cell Contents
- Topic D: Apply Colors, Borders, and Styles
- Topic E: Apply Basic Conditional Formatting
- Lesson 5: Printing Workbooks
- Topic A: Preview and Print a Workbook
- Topic B: Set Up the Page Layout
- Topic C: Configure Headers and Footers
- Lesson 6: Managing Workbooks
- Topic A: Manage Worksheets
- Topic B: Manage Workbook and Worksheet Views
- Topic C: Manage Workbook Properties
- Appendix A: Mapping Course Content to Excel Associate (Office 365 and Office 2019): Exam MO-200
- Appendix B: Mapping Course Content to Excel Expert (Office 365 and Office 2019): Exam MO-201
- Appendix C: Microsoft® Excel® Common Keyboard Shortcuts
- Appendix D: Adding Themes and Backgrounds to Worksheets
- Appendix E: Basic Excel Customization
| Microsoft Word for Office 365 (Desktop or Online): Part 1 · View Details | $320.00 | October 7, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Microsoft Word for Office 365 (Desktop or Online): Part 1
October 7, 2026 — 6:00 AM PDT–1:30 PM PDT
Microsoft Word for Office 365 (Desktop or Online): Part 1
These days, most people take electronic word processing for granted. While we may still write out our grocery lists with pen and paper, we expect to use a computer to create the majority of our documents. It’s impossible to avoid word-processing software in many areas of the business world. Managers, lawyers, clerks, reporters, and editors rely on this software to do their jobs. Whether you are an executive secretary or a website designer, you’ll need to know the ins and outs of electronic word processing.
Microsoft® Word is designed to help you move smoothly through the task of creating professional-looking documents. Its rich features and powerful tools can make your work easy, and even fun. In this course, you’ll learn how to use Word on the desktop to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents.
Note: Most Office 365 users perform the majority of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will also enable you to access and effectively utilize many web-based resources provided with your Office 365 subscription. This includes brief coverage of key skills for using Word for the Web and OneDrive. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version.
This course may be a useful component in your preparation for the Microsoft Word (Microsoft 365 Apps and Office 2019): Exam MO-100 and Microsoft Word Expert (Microsoft 365 Apps and Office 2019): Exam MO-101 certification exams.
This course is the first part of a three-course series that covers the skills needed to gain a foundational understanding of Word.
– Microsoft Word for Office 365 (Desktop or Online): Part 1 (this course)
– Microsoft Word for Office 365 (Desktop or Online): Part 2
– Microsoft Word for Office 365 (Desktop or Online): Part 3
Course Objectives:
In this course, you will learn fundamental Word skills.
You will:
– Navigate and perform common tasks in Word, such as opening, viewing, editing, saving, and printing documents, and configuring the application
– Format text and paragraphs
– Perform repetitive operations efficiently using tools such as Find and Replace, Format Painter, and Styles
– Enhance lists by sorting, renumbering, and customizing list styles
– Create and format tables
– Insert graphic objects into a document, including symbols, special characters, illustrations, pictures, and clip art
– Format the overall appearance of a page through page borders and colors, watermarks, headers and footers, and page layout
– Use Word features to help identify and correct problems with spelling, grammar, readability, and accessibility
Target Student:
This course is intended for those with a basic understanding of Microsoft® Windows® and who need to learn basic Word skills, such as creating, editing, and formatting documents; inserting simple tables and creating lists; and employing a variety of techniques for improving the appearance and accuracy of document content.
Prerequisites:
To ensure your success, you should have end-user skills with any current version of Windows, including being able to start and close applications, navigate basic file structures, manage files and folders, and access websites using a web browser.
Outline
- Lesson 1: Getting Started with Word
- Topic A: Navigate in Microsoft Word
- Topic B: Create and Save Word Documents
- Topic C: Edit Documents
- Topic D: Work with Word for the Web
- Lesson 2: Formatting Text and Paragraphs
- Topic A: Apply Character Formatting
- Topic B: Control Paragraph Layout
- Topic C: Align Text Using Tabs
- Topic D: Display Text in Bulleted or Numbered Lists
- Topic E: Apply Borders and Shading
- Lesson 3: Working More Efficiently
- Topic A: Make Repetitive Edits
- Topic B: Apply Repetitive Formatting
- Topic C: Use Styles to Streamline Repetitive Formatting Tasks
- Topic D: Customize the Word Environment
- Lesson 4: Managing Lists
- Topic A: Sort a List
- Topic B: Format a List
- Lesson 5: Adding Tables
- Topic A: Insert a Table
- Topic B: Modify a Table
- Topic C: Format a Table
- Topic D: Convert Text to a Table
- Lesson 6: Inserting Graphic Objects
- Topic A: Insert Symbols and Special Characters
- Topic B: Add Images to a Document
- Lesson 7: Controlling Page Appearance
- Topic A: Apply a Page Border and Color
- Topic B: Add Headers and Footers
- Topic C: Control Page Layout
- Topic D: Add a Watermark
- Lesson 8: Preparing to Publish a Document
- Topic A: Check Spelling, Grammar, and Readability
- Topic B: Preview and Print Documents
- Topic C: Use Research Tools
- Topic D: Check Accessibility
- Topic E: Dictate Text in a Document
- Topic F: Save a Document to Other Formats
- Appendix A: Mapping Course Content to Word Associate (Office 365 and Office 2019): Exam MO-100
- Appendix B: Mapping Course Content to Word Expert (Office 365 and Office 2019): Exam MO-101
- Appendix C: Microsoft® Word Common Keyboard Shortcuts
| Using Microsoft Windows 11 · View Details | $350.00 | October 7, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Using Microsoft Windows 11
October 7, 2026 — 6:00 AM PDT–1:30 PM PDT
Using Microsoft Windows 11
Whether you’re new to computers or have used them in the past, this class will help you become more comfortable using Windows® 11 by familiarizing you with the Windows 11 user interface and its basic capabilities. In this course, you will explore Windows 11 and learn how to work with locally installed apps and cloud-based apps, browse the Internet, and manage basic Windows 11 settings.
Completion of this course will earn 7.5 CPEs.
Course Objectives:
In this course, you will perform basic work-related tasks on a PC running the Windows 11 operating system. You will:
– Access Windows 11
– Access locally installed apps
– Access cloud-based apps and content
– Manage files and folders
– Configure the Windows 11 environment
– Secure your Windows 11 computer
– Use backup and recovery tools
Target Student:
This course is designed for end users who are familiar with computers and who need to use the features and functionality of the Windows 11 operating system.
Prerequisites:
To ensure your success in this course, you should have some experience using a personal computer, desktop apps, and the Internet.
Outline
- Lesson 1: Accessing Windows 11
- Log In to Windows 11
- Navigate the Windows 11 Desktop
- Use the Start Menu
- Lesson 2: Accessing Locally Installed Apps
- Use Apps
- Multitask with Open Apps
- Install Apps
- Lesson 3: Accessing Cloud-Based Apps and Content
- Browse the Web
- Use Cloud-Based Apps
- Lesson 4: Managing Files and Folders
- Manage Files and Folders with File Explorer
- Find Files, Folders, and Apps
- Store and Share Files with OneDrive
- Manage Removable Storage Devices
- Lesson 5: Configuring Windows 11
- Configure Settings
- Use Windows System Commands
- Manage Printers and Other Devices
- Use Accessibility Features
- Use Windows Tools
- Lesson 6: Securing Your Computer
- Manage Passwords and Sign-In Options
- Manage Windows Security
- Manage Windows Updates
- Use Other Security Features
- Lesson 7: Using Backup and Recovery Tools
- Create Backups
- Troubleshoot and Repair Your System
- Appendix A: Switching from Other Operating Systems
- Appendix B: Continuum Navigation
- Appendix C: Keyboard Shortcuts
| Get Smart with QuickBooks 2022 for Windows · View Details | $700.00 | Oct 7–Oct 8, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Get Smart with QuickBooks 2022 for Windows
Oct 7–Oct 8, 2026 — 6:00 AM PDT–1:30 PM PDT
Get Smart with QuickBooks 2022 for Windows
This course covers features that are in QuickBooks Pro and Premier 2022.
QuickBooks software is sold separately.
Prerequisites: You can successfully complete this course without any prior software knowledge or computer experience. A basic understanding of the computer operating system you are using is recommended.
Benefits: First-time QuickBooks users will learn the basic features of the software. Experienced QuickBooks users will quickly learn the new features and functionality of QuickBooks 2022.
Completion of this course will earn 15 CPEs.
Outline
- Getting Started
- Setting Up a Company
- Working with Lists
- Setting Up Inventory
- Selling Your Product
- Invoicing for Services
- Processing Payments
- Working with Bank Accounts
- Entering and Paying Bills
- Memorizing Transactions
- Customizing Forms
- Using Other QuickBooks Accounts
- Creating Reports
- Creating Graphs
- Tracking and Paying Sales Tax
- Preparing Payroll with QuickBooks
- Using the EasyStep Interview
- Using Online Banking
- Managing Company Files
- Estimating, Time Tracking, and Job Costing
- Writing Letters
| Adobe Illustrator CC: Part 1 · View Details | $395.00 | October 7, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Adobe Illustrator CC: Part 1
October 7, 2026 — 6:00 AM PDT–1:30 PM PDT
Adobe Illustrator CC: Part 1
To meet the demands of individuals and organizations for flexible, reusable, and easily modified visual content, Adobe Systems has created a cadre of applications that collectively provide a scalable, end-to-end solution for nearly every type of visual design project one can contemplate. Called Creative Cloud®, the collection of applications perform specialized design tasks while inter-operating among each other to deliver content.
This course focuses on Adobe® Illustrator® CC, the component within Creative Cloud used to create “drawn” graphics, while enabling its users to integrate content from other domains (such as photo-oriented graphics and animation, which belong to Adobe® Photoshop® and other applications). With Illustrator’s many easily used tools, you will discover that not only can you unlock the same creative impulses you’ve always had as you’ve picked up a pencil to sketch out an idea, but also capture those multiple ideas and “what ifs” during the creative process in ways that you never imagined. And for those of you who are just embarking on building your creative skills, you will be surprised at “how good” your work will appear, even at the outset of your exploration of the world of graphic design.
This course is a great component of your preparation for the Adobe Certified Associate (ACA) Graphic Design & Illustration Using Adobe Illustrator exam.
This course is the first part of a two-course series that covers the skills needed to gain a foundational understanding of Illustrator.
– Adobe Illustrator CC: Part 1 (this course)
– Adobe Illustrator CC: Part 2
Completion of this course will earn 7.5 CPEs.
Upon successful completion of this course, you will be able to use Adobe Illustrator CC to create illustrations that include graphics and text.
You will:
– Identify the components and capabilities of Illustrator
– Create basic shapes
– Create custom paths
– Create graphics that contain custom text
– Customize objects
– Customize basic shapes
– Prepare documents for deployment
Target Student:
This course is intended for designers, publishers, pre-press professionals, marketing communications professionals, or people switching to a design job or taking on design responsibilities and who need to use Illustrator to create illustrations, logos, advertisements, or other graphic documents. It is also useful for anyone interested in working toward the Adobe Certified Professional Graphic Design and Illustration Using Adobe Illustrator exam certification.
Prerequisites:
To ensure your success in this course, you should be familiar with the basic functions of your computer’s operating system, such as creating folders, launching programs, and working with windows. You should also have basic Windows application skills, such as copying and pasting objects, formatting text, saving files, and so on.
Familiarity with basic design terminology, such as palettes, color modes, shapes, text, and paths, is highly recommended.
You can obtain this level of skill and knowledge by taking one of the following Logical Operations courses:
– Using Microsoft® Windows® 10
– Microsoft® Windows® 10: Transition from Windows® 7
Outline
- Lesson 1: Introducing Illustrator
- Topic A: Apply Design Principles, Elements, and Graphics Composition
- Topic B: Evaluate Graphics Scalability
- Topic C: Navigate the User Interface
- Topic D: Customize the User Interface
- Lesson 2: Creating Documents Containing Basic Shapes
- Topic A: Create Documents
- Topic B: Save Documents
- Topic C: Draw Basic Shapes
- Lesson 3: Creating Documents Containing Customized Paths
- Topic A: Draw Paths
- Topic B: Modify Paths
- Lesson 4: Creating Graphics Containing Customized Text
- Topic A: Insert Text
- Topic B: Apply Flow Text Along a Path
- Topic C: Insert Bounded and Threaded Text
- Topic D: Apply Text Styles
- Topic E: Insert Typographical Characters
- Lesson 5: Customizing Objects
- Topic A: Import, Place, and Link Graphics
- Topic B: Alter the Appearance of Objects
- Lesson 6: Customizing Basic Shapes
- Topic A: Apply Strokes and Brushes
- Topic B: Fill Shapes
- Topic C: Apply Graphics Styles
- Topic D: Distort Text with Text Envelopes
- Lesson 7: Preparing Documents for Deployment
- Topic A: Update Text
- Topic B: Wrap Text
- Topic C: Hyphenate Text
- Topic D: Optimize Content for Print
- Topic E: Optimize Content for the Web
- Topic F: Optimize Content for PDF Documents
- Appendix A: Mapping Course Content to Adobe Certified Professional in Graphic Design & Illustration Using Adobe Illustrator Exam
| Microsoft PowerPoint for Office 365 (Desktop or Online): Part 1 · View Details | $320.00 | October 8, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Microsoft PowerPoint for Office 365 (Desktop or Online): Part 1
October 8, 2026 — 6:00 AM PDT–1:30 PM PDT
Microsoft PowerPoint for Office 365 (Desktop or Online): Part 1
How do you grab and maintain an audience’s focus when you’re asked to present important information? By being clear, organized, and engaging. And, that is exactly what Microsoft® PowerPoint® can help you do.
Today’s audiences are tech savvy, accustomed to high-impact multimedia content, and stretched for time. By learning how to use the vast array of features and functionality contained within PowerPoint, you will gain the ability to organize your content, enhance it with high-impact visuals, and deliver it with a punch. In this course, you will use PowerPoint to begin creating engaging, dynamic multimedia presentations.
Note: Most Office 365™ users perform the majority of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will also enable you to access and effectively utilize many web-based resources provided with your Office 365 subscription. This includes brief coverage of key skills for using PowerPoint for the Web and OneDrive. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version.
This course may be a useful component in your preparation for the Microsoft PowerPoint (Microsoft 365 Apps and Office 2019): Exam MO-300 certification exam.
This course is the first part of a two-course series that covers the skills needed to gain a foundational understanding of PowerPoint.
Microsoft PowerPoint for Office 365 (Desktop or Online): Part 1 (this course)
Microsoft PowerPoint for Office 365 (Desktop or Online): Part 2
Completion of this course will earn 7.5 CPEs.
Course Objectives:
In this course, you will create and deliver an engaging PowerPoint presentation.
You will:
– Identify the basic features and functions of PowerPoint.
– Develop a PowerPoint presentation.
– Perform text formatting.
– Add and arrange graphical elements.
– Modify graphical elements.
– Prepare to deliver your presentation.
Target Student:
This course is designed for students who wish to gain a foundational understanding of PowerPoint that is necessary to create and develop engaging multimedia presentations.
Prerequisites:
To ensure your success in this course, you should have end-user skills with any current version of Windows®, including being able to start programs, switch between programs, locate saved files, close programs, and access websites using a web browser.
Outline
- Lesson 1: Getting Started with PowerPoint
- Topic A: Navigate the PowerPoint Environment
- Topic B: View and Navigate a Presentation
- Topic C: Create and Save a Basic Presentation
- Topic D: Navigate in PowerPoint for the Web
- Topic E: Use PowerPoint Help
- Lesson 2: Developing a PowerPoint Presentation
- Topic A: Create Presentations
- Topic B: Edit Text
- Topic C: Work with Slides
- Topic D: Design a Presentation
- Lesson 3: Formatting Text
- Topic A: Format Characters
- Topic B: Format Paragraphs
- Lesson 4: Adding and Arranging Graphical Elements
- Topic A: Insert Images
- Topic B: Insert Shapes
- Topic C: Create SmartArt
- Topic D: Insert Icons and 3D Models
- Topic E: Size, Group, and Arrange Objects
- Lesson 5: Modifying Graphical Elements
- Topic A: Format Images
- Topic B: Format Shapes
- Topic C: Customize SmartArt
- Topic D: Format Icons
- Topic E: Format 3D Models
- Topic F: Animate Objects
- Lesson 6: Preparing to Deliver Your Presentation
- Topic A: Review Your Presentation
- Topic B: Apply Transitions
- Topic C: Print or Export a Presentation
- Topic D: Deliver Your Presentation
- Appendix A: Mapping Course Content to PowerPoint Associate (Office 365 and Office 2019): Exam MO-300
- Appendix B: Microsoft® PowerPoint® Common Keyboard Shortcuts
- Appendix C: Guidelines for Presentation Design
| Motivation Training: Motivating Your Workforce · View Details | $395.00 | October 8, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Motivation Training: Motivating Your Workforce
October 8, 2026 — 6:00 AM PDT–1:30 PM PDT
Motivation Training: Motivating Your Workforce
It’s no secret that employees who feel they are valued and recognized for the work they do are more motivated, responsible, and productive. This course will help supervisors and managers create a more dynamic, loyal, and energized workplace. It is designed specifically to help busy managers and supervisors understand what employees want, and to give them a starting point for creating champions.
Completion of this course will earn 7.5 CPEs.
Learning Objectives
– Identify what motivation is
– Describe common motivational theories and how to apply them
– Learn when to use different kinds of motivators
– Create a motivational climate
– Design a motivating job
Outline
- Session 1: Course Overview
- Learning Objectives
- Pre-Assignment
- Pre-Course Assessment
- Session 2: What is Motivation?
- Defining Motivation
- Session 3: Supervising and Motivation
- Why is Motivation Important?
- Identifying Motivators
- Making Connections
- What Do You Think?
- Session 4: Motivational Theories
- A Look at Theory
- Herzberg’s Motivational versus
- Maintenance (or Hygiene) Factors
- Supervisor’s versus Higher Management’s Role
- Motivation Theories
- Pre-Assignment Review
- Session 5: Setting Goals
- Setting Goals with SPIRIT
- Goal Setting and Goal Getting!
- Session 6: The Role of Values
- Developing Targets
- Making Connections
- What Do We Value In Work?
- Identifying Your Values
- Narrowing Down Your Values
- Bringing It All Together
- Session 7: Creating a Motivational Climate
- Behavioral (Reinforcement) Theory
- Reinforcement Theory
- The Big Question
- Expectancy Theory
- McClelland’s Needs Theory
- Session 8: Applying Your Skills
- Situational Analysis
- Case Studies
- Session 9: Designing Motivating Jobs
- Designing My Job
- Five Key Characteristics
- Techniques for Job Design or Redesign
- A Motivational Checklist
- Session 10: A Personal Action Plan
- Starting Point
- Where I Want to Go
- How I Will Get There
| Project Management Training: Understanding Project Management · View Details | $395.00 | October 9, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Project Management Training: Understanding Project Management
October 9, 2026 — 6:00 AM PDT–1:30 PM PDT
Project Management Training: Understanding Project Management
Project management isn’t just for construction engineers and military logistics experts anymore. Today, in addition to the regular duties of your job, you are often expected to take on extra assignments and to get that additional job done well, done under budget, and done on time. This course is not intended to take you from a supervisory or administrative position to that of a project manager. However, this course will familiarize you with the most common terms and the most current thinking about projects.
In this course, we will walk you through the nuts and bolts of project management, from setting priorities to controlling expenses and reporting on the results. You may still have to cope with the unexpected, but you’ll be better prepared.
Completion of this course will earn 7.5 CPEs.
Outline
- Session 1: Course Overview
- Learning Objectives
- Pre-Assignment
- Why a Project?
- How Does This Fit Into the Course?
- Applying the Learning
- Pre-Course Assessment
- Session 2: What is a Project?
- What is a Project?
- Definitions of a Project
- Session 3: Project Management Basics
- What is Project Management?
- Session 4: Pre-Assignment Review
- Eight Project Categori
- Session 5: How Can Projects Help Me?
- The Benefits of Projects
- Case Study: Mary Marvelous
- Session 6: A Project’s Life Cycle
- The Life Cycle
- Phase One
- Phase Two
- Phase Three
- Phase Four
- Milestones
- Why Do Projects Fail?
- Overview of Success Factors
- Three Ways to End a Project
- Session 7: Selling a Project
- Tom Peters
- Bringing Ideas Forward
- Selling Your Project
- The Priority Matrix
- Using the Matrix
- Priority Quadrants
- Session 8: Preparing Your Project
- Things to Consider
- Session 9: Preparing Your Project
- A Project Manager’s Skills
- To Be Completed By Proposer
- To Be Completed By Proposer’s Manager
- Bring the Team Together
- Key Skills
- Session 10: Project Goals
- Goals with SPIRIT!
- Project Goals
- Making Connections
- Session 11: Laying Out the Project
- The Statement of Work
- Defined Purpose
- Project Deliverables
- To Be Completed By Proposer’s Manager
- Goals and Objectives
- SWOT
- Cost and Schedule Estimates
- List of Stakeholders
- Authority Levels
- Assumptions and Agreements
- The Communication Plan
- Individual SOW
- Project Planning Worksheet
- Time Management
- Cost Controls
- Results Expected
- Approvals
- Writing Reports
- Four Stages in Report Writing
- Basic Formats
- Session 12: Project Risks
- Risk Tolerance Exercise
- About Risks
- Reducing Risks
- Sources of Risk
- Constraints
- Session 13: Contingency Planning
- Contingency Planning
- Components of a Contingency Plan
- Session 14: What Really Needs To Be Done?
- Beginning to Plan
- Preparing a Basic Schedule
- Estimating Time
- Float Time
- Scheduling Checklist
- Activity Scheduling
- Scheduling My Project
- Session 15: The Work Breakdown Structure
- The Work Breakdown Structure
- Sample WBS
- Session 16: Planning Tools
- Two Basic Tools
- Milestone Charts
- PERT
- PERT Diagrams
- Along the Critical Path
- Gantt Charts
- The Network Diagram
- Revealing Workflow
- Five Steps to Create a Network Diagram
- More About Network Diagrams
- Network Diagrams Conclusion
- The Flow Chart
- Session 17: Budgets
- Component Costs
- Budget Methods
- Making Connections
- Costs and Time
- Budget Controls
- Session 18: Teamwork
- Why is Teamwork Important?
- Building a Winning Team
- Tips for Building a Winning Team
- Session 19: Developing Teams
- Four Issues to Address with Project Teams
- Checklist for Success
- Team Development
- Forming
- Storming
- Norming
- Performing
- Adjourning
- Session 20: Teamwork
- Introduction
- Individual Action Steps
- Session 21: Communication Tips
- Communicating as Project Manager
- Session 22: Closing Out a Project
- Closing Smoothly
- Session 23: Team Meetings
- Coordinating Team Meetings
- During the Meeting
- Effective Meeting Management
- Making Committees Work
- Assigning Work
- Session 24: Presentation Primer
- Project Management Presentation
- Presentation Strategies
- Speaking with Confidence
- Session 25: Project Presentations
- Preparation Time
- Evaluation Worksheet
- Session 26: A Personal Action Plan
- Starting Point
- Where I Want to Go
- How I Will Get There
| Working with Copilot in Windows and Microsoft Edge · View Details | $199.00 | October 9, 2026 — 6:00 AM PDT–9:00 AM PDT | Book Now |
Working with Copilot in Windows and Microsoft Edge
October 9, 2026 — 6:00 AM PDT–9:00 AM PDT
Working with Copilot in Windows and Microsoft Edge
Microsoft® Copilot is an AI-powered productivity tool that leverages the power of large language models (LLMs) to help you navigate your daily workload, unlock creativity, and get answers. This course is designed to help you work productively with Copilot, which is available as a built-in tool in Windows® 11 and Microsoft Edge®.
This course is designed for people who are familiar with Windows 11 and want to develop the skills needed to put Copilot, Microsoft’s AI-powered productivity tool, to work in their own tasks and workflows.
Outline
- Lesson 1: Using AI-Enhanced Tools in Windows 11
- Topic A: Identify Generative AI Concepts
- Topic B: Work with Copilot in Windows
- Topic C: Use AI-Enhanced Apps
- Lesson 2: Using Copilot in Edge
- Topic A: Use Copilot Chat in Edge
- Topic B: Use the Copilot Compose Tab
- Topic C: Use Copilot on the Web
| Microsoft Access for Office 365: Part 1 · View Details | $350.00 | October 9, 2026 — 6:30 AM PDT–1:30 PM PDT | Book Now |
Microsoft Access for Office 365: Part 1
October 9, 2026 — 6:30 AM PDT–1:30 PM PDT
Microsoft Access for Office 365: Part 1
Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data. A relational database application such as Microsoft® Access® can help you and your organization with this task. This course is the first part of a three-course series that covers the skills needed to perform database design and development in Access.
Microsoft® Access® for Office 365™: Part 1 (this course): Focuses on the design and construction of an Access database —viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.
Microsoft® Access® for Office 365™: Part 2 : Focuses on optimization of an Access database, including optimizing performance and normalizing data, data validation, usability, and advanced queries, forms, and reports.
Microsoft® Access® for Office 365™: Part 3 : Focuses on managing the database and supporting complex database designs , including import and export of data, using action queries to manage data, creating complex forms and reports, macros and VBA, and tools and strategies to manage, distribute, and secure a database.
This course may be a useful component in your preparation for the Microsoft Access Expert (Microsoft 365 Apps and Office 2019): Exam MO-500 certification exam.
Completion of this course will earn 7.5 CPEs.
Target Student:
This course is designed for students looking to establish a foundational understanding of Microsoft Access for Office 365, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.
Prerequisites:
To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites. You can obtain this level of skills and knowledge by taking either of the following Logical Operations courses, or any similar courses in general Microsoft Windows skills:
– Using Microsoft® Windows® 10 (Second Edition)
Experience in another Microsoft Office product such as Excel is recommended. Microsoft® Excel® for Office 365™ (Desktop or Online): Part 1 would be a good choice.
Outline
- Lesson 1: Working with an Access Database
- Topic A: Launch Access and Open a Database
- Topic B: Use Tables to Store Data
- Topic C: Use Queries to Combine, Find, Filter, and Sort Data
- Topic D: Use Forms to View, Add, and Update Data
- Topic E: Use Reports to Present Data
- Topic F: Get Help and Configure Options in Microsoft Access
- Lesson 2: Creating Tables
- Topic A: Plan an Access Database
- Topic B: Start a New Access Database
- Topic C: Create a New Table
- Topic D: Establish Table Relationships
- Lesson 3: Creating Queries
- Topic A: Create Basic Queries
- Topic B: Add Calculated Columns in a Query
- Topic C: Sort and Filter Data in a Query
- Lesson 4: Creating Forms
- Topic A: Start a New Form
- Topic B: Enhance a Form
- Lesson 5: Creating Reports
- Topic A: Start a New Report
- Topic B: Enhance Report Layout
- Appendix A: Mapping Course Content to Access Expert (Office 365 and Office 2019): Exam MO-500
- Appendix B: Microsoft® Access® for Office 365™ Common Keyboard Shortcuts
| Problem Solving and Decision Making · View Details | $790.00 | Oct 12–Oct 13, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Problem Solving and Decision Making
Oct 12–Oct 13, 2026 — 6:00 AM PDT–1:30 PM PDT
Problem Solving and Decision Making
Many people lack the necessary skills to effectively solve problems and make decisions. Having a process in place can help with this.
Completion of this course will earn 7.5 CPEs.
Learning Objectives
– Apply problem-solving steps and tools
– Analyze information to clearly describe problems
– Identify appropriate solutions
– Think creatively and be a contributing member of a problem-solving team
– Select the best approach for making decisions
– Create a plan for implementing, evaluating, and following up on decisions
– Avoid common decision-making mistakes
Outline
- Session One: Course Overview
- Learning Objectives
- Pre-Assignment
- Pre-Course Assessment
- Session Two: Definitions
- Defining Problem-Solving and Decision- Making
- Problem Identification
- Eight Essentials to Defining a Problem
- Problem-Solving in Action
- Session Three: Making Decisions
- Making Winning Decisions
- Three Types of Decisions
- Advice from an Expert
- Facts vs. Information
- Eight Ingredients for Good Decision- Making
- Decision-Making Traps
- Session Four: Getting Real
- Pre-Assignment Review
- Case Study
- Session Five: The Problem-Solving Model
- Model Overview
- The Problem-Solving Model
- Another Perspective
- Keeping an Open Mind
- Solving Problems the “Right” Way
- Real Problems
- Making Connections
- Phase One
- Phase Two
- Phase Three
- Solution Planning Worksheet
- Session Six: Case Study
- The Truck Case Study
- Making Connections
- Session Seven: The Problem-Solving Toolkit
- The Basic Tools
- Legitimizing Problems and Positions
- The Fishbone
- Degrees of Support
- Creative Thinking Methods: Brainstorming
- Limitations of Brainstorming
- Brainwriting
- Mind-Mapping
- Brainstorming and Brainwriting
- More Methods
- Session Eight: Aspirinia
- Decision Information
- Individual Action Steps
- Session Nine: Swotting Up
- SWOT Analysis
- SWOT Matrix
- SWOT Checklist
- Individual Analysis
- Session Ten: Making Good Group Decisions
- Working Toward the Decision
- Avoiding Fatal Mistakes
- New, Appeal and Feasibility (NAF)
- Technique
- Visualization
- Benefits Possibilities Concerns (BPC)
- Technique
- Session Eleven: Analyzing and Selecting Solutions
- Selecting Criteria
- Creating a Cost-Benefit Analysis
- Making Connections
- Session Twelve: Planning and Organizing
- Introduction
- Follow-Up Analysis
- Evaluate
- Adapt, Close, and Celebrate
- Personal Action Plan
- Starting Point
- Where I Want to Go
- How I Will Get There
| Microsoft Excel for Office 365 (Desktop or Online): Part 2 · View Details | $360.00 | October 13, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Microsoft Excel for Office 365 (Desktop or Online): Part 2
October 13, 2026 — 6:00 AM PDT–1:30 PM PDT
Microsoft Excel for Office 365 (Desktop or Online): Part 2
Whether you need to crunch numbers for sales, inventory, information technology, human resources, or other organizational purposes and departments, the ability to get the right information to the right people at the right time can create a powerful competitive advantage. After all, the world runs on data more than ever before and that’s a trend not likely to change, or even slow down, any time soon. But with so much data available and being created on a nearly constant basis, the ability to make sense of that data becomes more critical and challenging with every passing day. You already know how to get Microsoft® Excel® to perform simple calculations and how to modify your workbooks and worksheets to make them easier to read, interpret, and present to others. But, Excel is capable of doing so much more. To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data. In other words, when you have questions about your data, you need to know how to get Excel to provide the answers for you. And that’s exactly what this course aims to help you do.
This course builds upon the foundational knowledge presented in the Microsoft® Excel® for Office 365™ (Desktop or Online): Part 1 course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level.
Note: Most Office 365™ users perform the majority of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will also enable you to access and effectively utilize many web-based resources provided with your Office 365 subscription. This includes brief coverage of key skills for using Excel for the Web and OneDrive. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version.
This course is the second part of a three-course series that covers the skills needed to gain a foundational understanding of Excel.
– Microsoft Excel for Office 365 (Desktop or Online): Part 1
– Microsoft Excel for Office 365 (Desktop or Online): Part 2 (this course)
– Microsoft Excel for Office 365 (Desktop or Online): Part 3
This course may be a useful component in your preparation for the Microsoft Excel (Microsoft 365 Apps and Office 2019): Exam MO-200 and Microsoft Excel Expert (Microsoft 365 Apps and Office 2019): Exam MO-201 certification exams.
Completion of this course will earn 7.5 CPEs.
Course Objectives:
Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.
You will:
– Work with functions
– Work with lists
– Analyze data
– Visualize data with charts
– Use PivotTables and PivotCharts
Target Student:
This course is designed for students who already have foundational knowledge and skills in Excel and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.
Prerequisites:
To ensure success, students should have completed Logical Operations’ Microsoft® Excel® for Office 365™ (Desktop or Online): Part 1 or have the equivalent knowledge and experience.
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 and Time Functions
- Topic E: Work with Text Functions
- Lesson 2: Working with Lists
- Topic A: Sort Data
- Topic B: Filter Data
- Topic C: Query Data with Database Functions
- Topic D: Outline and Subtotal Data
- Lesson 3: Analyzing Data
- Topic A: Create and Modify Tables
- Topic B: Apply Intermediate Conditional Formatting
- Topic C: Apply Advanced Conditional Formatting
- Lesson 4: Visualizing Data with Charts
- Topic A: Create Charts
- Topic B: Modify and Format Charts
- Topic C: Use Advanced Chart Features
- Lesson 5: Using PivotTables and PivotCharts
- Topic A: Create a PivotTable
- Topic B: Analyze PivotTable Data
- Topic C: Present Data with PivotCharts
- Topic D: Filter Data by Using Timelines and Slicers
- Appendix A: Mapping Course Content to Excel Associate (Office 365 and Office 2019): Exam MO-200
- Appendix B: Mapping Course Content to Excel Expert (Office 365 and Office 2019): Exam MO-201
- Appendix C: Microsoft® Excel® Common Keyboard Shortcuts
- Appendix D: Financial Functions
- Appendix E: Working with Graphical Objects
- Appendix F: Using Array Formulas
| Adobe InDesign CC: Part 2 · View Details | $395.00 | October 13, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Adobe InDesign CC: Part 2
October 13, 2026 — 6:00 AM PDT–1:30 PM PDT
Adobe InDesign CC: Part 2
In Adobe® InDesign® CC: Part 1 you were introduced to the many features that help you create professional looking documents. Now you need to create much lengthier interactive documents that need to be accessed across a range of devices. In Adobe® InDesign® CC: Part 2, you will learn advanced InDesign techniques to enhance the look and functionality of your documents.
Using Adobe InDesign, you can create interactive documents and export them for viewing in a web browser with various features such as buttons, page transitions, movies and audio files, hyperlinks, and animation. You have the ability to assign color profiles and establish print presets. In creating longer documents, you’ll be able to include such features as a table of contents, footnotes, cross-references, and an index.
This course is a great component of your preparation for the Adobe Certified Professional Print & Digital Media Publication Using Adobe InDesign CC exam.
This course is the second part of a two-course series that covers the skills needed to gain a foundational understanding of InDesign.
– Adobe InDesign CC: Part 1
– Adobe InDesign CC: Part 2 (this course)
Completion of this course will earn 7.5 CPEs.
Course Objectives:
Upon successful completion of this course, you will be able to use Adobe InDesign (2020) to create and deliver professional looking printed and interactive documents.
You will:
– Prepare documents for multiple formats
– Manage advanced page layouts
– Manage styles
– Build complex paths
– Manage external files and create dynamic documents
– Manage long documents
– Publish InDesign files for other formats and customize print settings
Target Student:
This course is intended for students who want to expand their entry-level knowledge of Adobe InDesign by using advanced features and collaboration tools. It’s also for anyone interested in working toward the Print & Digital Media Publication Using Adobe InDesign certification.
Prerequisites:
To ensure your success, you will need to take the following Logical Operations course:
– Adobe® InDesign® CC: Part 1
Outline
- Lesson 1: Preparing Documents for Multiple Formats
- Topic A: Build Layout Versions
- Topic B: Link Content
- Lesson 2: Managing Advanced Page Elements
- Topic A: Create Repeating Content
- Topic B: Change Text Layouts
- Topic C: Create Transparency
- Topic D: Anchor Objects and Manage a Library
- Lesson 3: Managing Styles
- Topic A: Import Styles from Microsoft Word Documents
- Topic B: Manage Styles
- Lesson 4: Building Complex Paths
- Topic A: Create Bezier Paths
- Topic B: Create Clipping Paths
- Topic C: Create Compound Paths
- Lesson 5: Managing External Files and Creating Dynamic Documents
- Topic A: Import External Files
- Topic B: Create Document Sections
- Topic C: Insert Text Variables
- Topic D: Create Interactive Documents
- Lesson 6: Managing Long Documents
- Topic A: Create a Book
- Topic B: Build a Table of Contents
- Topic C: Create Hyperlinks and Cross-References
- Topic D: Generate an Index and Insert Footnotes
- Lesson 7: Publishing InDesign Files for Other Formats and Customizing Print Settings
- Topic A: Export PDF Files for Print
- Topic B: Export Interactive PDF Files
- Topic C: Export Files for the Web
- Topic D: Manage Colors
- Topic E: Preview the Print Output
- Topic F: Create Print Presets
- Appendix A: Mapping Course Content to the Adobe Certified Professional in Print & Digital Media Publication Using Adobe InDesign Exam
- Appendix B: Productivity Enhancements
- Appendix C: InDesign Language Support
- Appendix D: Extension Manager
| Microsoft Excel for Office 365 (Desktop or Online): Part 1 · View Details | $320.00 | October 13, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Microsoft Excel for Office 365 (Desktop or Online): Part 1
October 13, 2026 — 6:00 AM PDT–1:30 PM PDT
Description
Microsoft Excel for Office 365 (Desktop or Online): Part 1
Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software. This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation.
Note: Most Office 365™ users perform the majority of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will also enable you to access and effectively utilize many web-based resources provided with your Office 365 subscription. This includes brief coverage of key skills for using Excel for the Web and OneDrive. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version.
This course is the first part of a three-course series that covers the skills needed to gain a foundational understanding of Excel.
– Microsoft Excel for Office 365 (Desktop or Online): Part 1 (this course)
– Microsoft Excel for Office 365 (Desktop or Online): Part 2
– Microsoft Excel for Office 365 (Desktop or Online): Part 3
This course may be a useful component in your preparation for the Microsoft Excel (Microsoft 365 Apps and Office 2019): Exam MO-200 and Microsoft Excel Expert (Microsoft 365 Apps and Office 2019): Exam MO-201 certification exams.
Completion of this course will earn 7.5 CPEs.
Course Objectives:
In this course, you will learn fundamental Excel skills.
You will:
– Familiarize yourself with Excel’s layout, its various parts, its commands, and its terminology
– Outline Excel’s abilities to quickly, efficiently, and accurately calculate data
– Update worksheets without throwing away all of the valuable work you’ve already done
– Format a worksheet and organize your data
– Print workbooks
– Manage the overall structure of your workbooks
Target Student:
This course is intended for students who wish to gain the foundational understanding of Excel that is necessary to create and work with electronic spreadsheets.
Prerequisites:
To ensure your success, you should have end-user skills with any current version of Windows, including being able to start and close applications, navigate basic file structures, manage files and folders, and access websites using a web browser.
Outline
- Lesson 1: Getting Started with Excel
- Topic A: Navigate the Excel User Interface
- Topic B: Use Excel Commands
- Topic C: Create and Save a Basic Workbook
- Topic D: Navigate in Excel for the Web
- Topic E: Enter Cell Data
- Lesson 2: Performing Calculations
- Topic A: Create Worksheet Formulas
- Topic B: Insert Functions
- Topic C: Reuse Formulas and Functions
- Lesson 3: Modifying a Worksheet
- Topic A: Adjust Cells, Columns, and Rows
- Topic B: Search for and Replace Data
- Topic C: Use Proofing and Research Tools
- Lesson 4: Formatting a Worksheet
- Topic A: Apply Text Formats
- Topic B: Apply Number Formats
- Topic C: Align Cell Contents
- Topic D: Apply Colors, Borders, and Styles
- Topic E: Apply Basic Conditional Formatting
- Lesson 5: Printing Workbooks
- Topic A: Preview and Print a Workbook
- Topic B: Set Up the Page Layout
- Topic C: Configure Headers and Footers
- Lesson 6: Managing Workbooks
- Topic A: Manage Worksheets
- Topic B: Manage Workbook and Worksheet Views
- Topic C: Manage Workbook Properties
- Appendix A: Mapping Course Content to Excel Associate (Office 365 and Office 2019): Exam MO-200
- Appendix B: Mapping Course Content to Excel Expert (Office 365 and Office 2019): Exam MO-201
- Appendix C: Microsoft® Excel® Common Keyboard Shortcuts
- Appendix D: Adding Themes and Backgrounds to Worksheets
- Appendix E: Basic Excel Customization
| Crystal Reports 2020: Part 1 · View Details | $790.00 | Oct 14–Oct 15, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Crystal Reports 2020: Part 1
Oct 14–Oct 15, 2026 — 6:00 AM PDT–1:30 PM PDT
Crystal Reports 2020: Part 1
Organizations use reporting tools to access data sources and generate customized reports. SAP® Crystal Reports® 2020 enhances report building and report processing techniques with a variety of features that add value to a presentation. In this course, you will create a basic report by connecting to a database and modifying the report’s presentation.
Information is critical to making sound business decisions. Data presented without any formatting or structure holds little or no meaning for interpretation. Crystal Reports 2020 helps you build advanced reports with ease, presenting complex information in an understandable way.
This course is the first part of a two-course series that covers the skills needed to gain a foundational understanding of Crystal Reports.
– Crystal Reports 2020: Part 1 (this course)
– Crystal Reports 2020: Part 2
Completion of this course will earn 15 CPEs.
Course Objectives: In this course, you will connect to a database to extract data and present it as a report.
You will:
– Identify the elements of the Crystal Reports interface
– Create and modify a basic report
– Use formulas to calculate and filter data
– Build a parameterized report
– Group report data
– Enhance a report
– Create a report using data from an Excel workbook
– Distribute data
Target Student: This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, or tools that are not accessible. Learners may or may not have programming or SQL experience.
Prerequisites: Before taking this course, learners should be familiar with basic computer functions, such as creating and navigating folders, opening programs, manipulating windows, copying and pasting objects, formatting text, and saving files in Microsoft Windows. In addition, learners should have taken the Microsoft Office Access 2019: Part 1, or the Microsoft Access for Office 365™: Part 1 course, or have equivalent experience with basic database concepts.
Outline
- Lesson 1: Exploring the Crystal Reports Interface
- Topic A: Explore Crystal Reports
- Topic B: Use Crystal Reports Help
- Topic C: Customize Report Settings
- Lesson 2: Working with Reports
- Topic A: Create a Report
- Topic B: Modify a Report
- Topic C: Display Specific Report Data
- Topic D: Work with Report Sections
- Lesson 3: Using Formulas in Reports
- Topic A: Create a Formula
- Topic B: Edit a Formula
- Topic C: Filter Data by Using a Formula
- Topic D: Work with Advanced Formulas and Functions
- Topic E: Handle Null Values
- Lesson 4: Building Parameterized Reports
- Topic A: Create a Parameter Field
- Topic B: Use a Range Parameter in a Report
- Topic C: Create a Prompt
- Lesson 5: Grouping Report Data
- Topic A: Group Report Data
- Topic B: Modify a Group Report
- Topic C: Group by Using Parameters
- Topic D: Create a Parameterized Top N Report
- Lesson 6: Enhancing a Report
- Topic A: Format a Report
- Topic B: Insert Objects in a Report
- Topic C: Suppress Report Sections
- Topic D: Use Report Templates
- Lesson 7: Creating a Report from Excel Data
- Topic A: Create a Report Based on Excel Data
- Topic B: Modify a Report Generated from Excel Data
- Topic C: Update Data in a Report Based on Excel Data
- Lesson 8: Distributing Data
- Topic A: Export Data
- Topic B: Create Mailing Labels
- Appendix A: Setting Up and Configuring Data Sources
- Appendix B: Using Report Processing Techniques
- Appendix C: Using Functions in Formulas
| Adobe Acrobat Pro: New Experience · View Details | $395.00 | October 14, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Adobe Acrobat Pro: New Experience
October 14, 2026 — 6:00 AM PDT–1:30 PM PDT
Adobe Acrobat Pro: New Experience
Adobe® Acrobat® Pro puts the power of the Portable Document Format, literally, at your fingertips. By taking advantage of the functionality and features available in Acrobat’s new-experience interface, you will ensure the integrity of your electronic documents regardless of who views them, on what devices,
or with what operating systems. And that will give you the confidence and peace of mind that comes with knowing that what you meant to communicate is what your document recipients will see.
Course Objectives:
In this course, you will create and work with PDF documents.
You will:
- Access information in a PDF document
- Create and save PDF documents
- Navigate content in a PDF document
- Modify PDF documents
- Review PDF documents
- Convert PDF documents
Course Content
Lesson 1: Accessing PDF Documents
Topic A: Open a PDF Document
Topic B: Browse a PDF Document
Lesson 2: Creating and Saving PDF Documents
Topic A: Create and Save a PDF Document from an Existing Document
Topic B: Create a PDF Document from a Web Page
Topic C: Combine Multiple PDF Documents
Lesson 3: Navigating Content in a PDF Document
Topic A: Perform a Search in a PDF Document
Topic B: Search Multiple PDF Documents
Topic C: Work with Bookmarks
Topic D: Create Links and Buttons
Lesson 4: Modifying PDF Documents
Topic A: Manipulate PDF Document Pages
Topic B: Edit Content in a PDF Document
Topic C: Add Page Elements
Lesson 5: Reviewing PDF Documents
Topic A: Add Comments and Markup
Topic B: Compare PDF Documents
Topic C: Participate in a Shared Review
Topic D: Digitally Sign PDF Documents
Lesson 6: Converting PDF Files
Topic A: Reduce the File Size of a PDF Document
Topic B: Optimize PDF Files
Topic C: Convert and Reuse PDF Document Content
| Microsoft Access for Office 365: Part 2 · View Details | $380.00 | October 14, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Microsoft Access for Office 365: Part 2
October 14, 2026 — 6:00 AM PDT–1:30 PM PDT
Microsoft Access for Office 365: Part 2
Your training and experience using Microsoft® Access® has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users.
This course is the second part of a three-course series that covers the skills needed to perform database design and development in Microsoft Access.
Microsoft® Access® for Office 365™: Part 1 : Focuses on the design and construction of an Access database —viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.
Microsoft® Access® for Office 365™: Part 2 (this course): Focuses on optimization of an Access database, including optimizing performance and normalizing data; data validation; usability; and advanced queries, forms, and reports.
Microsoft® Access® for Office 365™: Part 3 : Focuses on managing the database and supporting complex database designs , including import and export of data; using action queries to manage data; creating complex forms and reports; macros and Visual Basic for Applications (VBA); and tools and strategies to manage, distribute, and secure a database.
This course may be a useful component in your preparation for the Microsoft Access Expert (Microsoft 365 Apps and Office 2019): Exam MO-500 certification exam.
Completion of this course will earn 7.5 CPEs.
Target Student:
This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases and developing tables, queries, forms, and reports in Microsoft Access for Office 365.
Prerequisites:
To ensure your success in this course, it is recommended you have completed Microsoft® Access® for Office 365™: Part 1 or possess equivalent knowledge.
It is also suggested that you have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites. You can obtain this level of skills and knowledge by taking either of the following Logical Operations courses, or any similar courses in general Microsoft Windows skills:
– Using Microsoft® Windows® 10
Outline
- Lesson 1: Promoting Quality Data Input
- Topic A: Restrict Data Input through Field Validation
- opic B: Restrict Data Input through Forms and Record Validation
- Lesson 2: Improving Efficiency and Data Integrity
- Topic A: Data Normalization
- Topic B: Associate Unrelated Tables
- Topic C: Enforce Referential Integrity
- Lesson 3: Improving Table Usability
- Topic A: Create Lookups within a Table
- Topic B: Work with Subdatasheets
- Lesson 4: Creating Advanced Queries
- Topic A: Create Query Joins
- Topic B: Create Subqueries
- Topic C: Summarize Data
- Lesson 5: Improving Form Presentation
- Topic A: Apply Conditional Formatting
- Topic B: Create Tab Pages with Subforms and Other Controls
- Lesson 6: Creating Advanced Reports
- Topic A: Apply Advanced Formatting to a Report
- Topic B: Add a Calculated Field to a Report
- Topic C: Control Pagination and Print Quality
- Topic D: Add a Chart to a Report
- Appendix A: Mapping Course Content to Access Expert (Office 365 and Office 2019): Exam MO-500
- Appendix B: Microsoft® Access® for Office 365™ Common Keyboard Shortcuts
| Time Management · View Details | $395.00 | October 14, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Time Management
October 14, 2026 — 6:00 AM PDT–1:30 PM PDT
Time Management
Time is money, the saying goes, and lots of it gets lost in disorganization and disruption. We also deal with a constant barrage of technology, people, and tasks that can contribute to that disorganization. Many people find that they flit from one task to another, trying to get everything done, but often falling short. You will learn how to make the most of your time by getting a grip on your workflow and office space, using your planner effectively, and delegating some of your work to other people.
Completion of this course will earn 7.5 CPEs.
Learning Objectives
– Better organize yourself and your workspace for peak efficiency
– Understand the importance of, and the most useful techniques for, setting and achieving goals
– Plan and schedule your time efficiently
– Learn how to set priorities
– Discover the ingredients for good decision-making
– Learn what to delegate and how to delegate well
– Take control of things that can derail your workplace productivity
– Create order and get organized
– Manage your workload
Outline
- Session One: Course Overview
- Learning Objectives
- Pre-Assignment
- Pre-Course Assessment
- Session Two: What Is Time Management?
- Pre-Assignment Review
- Why Time Management Is Important
- Session Three: Setting Goals
- Goals and Targets
- Setting SMART Goals, Part One
- Your Own SMART Goals
- Session Four: Planning Tips and Tricks
- Planning Tools
- Case Study
- Case Study Questions
- Session Five: Setting Priorities
- Prioritizing Your Tasks
- Matrix Overview
- Your To-Do List
- Managing Interruptions and Distractions
- Tips for Controlling Disruptions
- Session Six: Making Decisions
- Eight Ingredients for Good Decision Making
- Weighing the Pros and Cons
- Session Seven: Delegating
- Assigning Tasks
- Guidelines for Success
- The Story about Everybody, Somebody, Anybody, and Nobody
- Case Study: What Should Sheila Do?
- Session Eight: Scheduling
- Organize Your Time
- Creating a Schedule
- Session Nine: Putting an End to Procrastination
- Eating the Frog
- Session Ten: Creating Order
- Decluttering
- Making Connections
- Organizing Your Work Area and Your Paperwork
- Guidelines for Keeping a Piece of Paper
- Session Eleven: Organizing Your Files
- Sorting Based on File Type
- File Categories
- Electronic Files
- The Batching Technique
- Session Twelve: Managing Your Workload
- Managing Email
- Tips for Tackling Your Email
- Case Study: Mary Marvelous
- Workload Analysis
- The 168-Hour Plan
- Personal Action Plan
- Starting Point
- Where I Want to Go
- How I Will Get There
| Microsoft OneNote (Desktop App) · View Details | $350.00 | October 15, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Microsoft OneNote (Desktop App)
October 15, 2026 — 6:00 AM PDT–1:30 PM PDT
Microsoft OneNote (Desktop App)
In our fast-paced digital world, the need to capture ideas, meeting notes, and to-do items is ever present. Microsoft’s® OneNote® app provides a way for you to efficiently create and collect your notes in an electronic notebook. This course will help you use OneNote notebooks to store a wide variety of content in an organized structure, access the content from anywhere, and also share it with others. Additionally, learning how OneNote and other applications in the Microsoft 365 suite are integrated will increase your productivity.
In this course, you will develop note-taking skills by creating, modifying, and managing OneNote notebooks that work with other Microsoft 365 applications.
You will:
– Navigate and customize the OneNote environment and create your first notebook
– Add and format various types of notes and note elements, including text, links, and drawing objects
– Add images, video, audio, Excel spreadsheets, and other types of files to a notebook
– Organize, categorize, and search notebook content
– Finalize notebook content by checking spelling, printing copies, and password-protecting notebooks
– Manage notebooks by exporting content and working with history and backups
– Share notebooks using Outlook and collaborate with colleagues using OneDrive
Target Student:
This course is intended for people in a variety of roles and fields who have a basic understanding of Microsoft 365 and want to incorporate digital note taking and note collaboration by using Microsoft OneNote.
Prerequisites:
To ensure your success in this course, you should have Windows end-user skills that include starting and closing applications, navigating basic file structures, and managing files and folders. Previous experience with OneNote is not required; however, having a basic understanding of the Microsoft 365 productivity suite would be beneficial.
Outline
- Lesson 1: Getting Started with OneNote
- Topic A: Navigate the OneNote Environment
- Topic B: Create Notebook Pages from Page Templates
- Topic C: Customize the OneNote User Interface
- Lesson 2: Adding and Formatting Notebook Content
- Topic A: Format Notebook Content
- Topic B: Add Quick Notes and Linked Notes to a Notebook
- Topic C: Use Drawing Tools in a Notebook
- Topic D: Use Dictation in a Notebook
- Lesson 3: Adding Files to Notebooks
- Topic A: Insert Images, Video, and Audio into a Notebook
- Topic B: Embed Excel Spreadsheets in a Notebook
- Topic C: Attach Other File Types to a Notebook
- Lesson 4: Organizing Notebook Content
- Topic A: Use Tags to Categorize Notes
- Topic B: Organize and Search Notebooks
- Lesson 5: Finalizing Notebooks
- Topic A: Proof and Print a Notebook
- Topic B: Configure Password Protection and Notebook Properties
- Lesson 6: Managing Notebooks
- Topic A: Export Content from a Notebook
- Topic B: Manage Notebook History
- Lesson 7: Sharing OneNote Content
- Topic A: Send Notebook Pages to Others
- Topic B: Work with Integrated Outlook Features
- Topic C: Collaborate on Notebooks
- Appendix A: Microsoft OneNote Common Keyboard Shortcuts
| Building Better Teams · View Details | $395.00 | October 15, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Building Better Teams
October 15, 2026 — 6:00 AM PDT–1:30 PM PDT
Building Better Teams
Teams are an important building block of successful organizations. Whether the focus is on service, quality, cost, value, speed, efficiency, performance, or other similar goals, teams are the basic unit that supports most organizations.
Completion of this course will earn 7.5 CPEs.
Learning Objectives
• Understand the value of working as a team
• Develop team norms, ground rules, and team contracts
• Identify your team player style and how it can be used effectively with your own team
• Build team trust
• Identify the stages of team development and how to help a team move through them
• Recognize the critical role communication skills will play in building and maintaining a team atmosphere
• Identify ways that team members can be involved and grow in a team setting
Outline
- Session One: Course Overview
- Learning Objectives
- What’s Your Team Player Type?
- Identifying Your Characteristics and Preferences
- Session Two: Defining Teams
- What is a Team?
- What Does That Mean?
- Types of Teams
- Making Connections
- Session Three: Establishing Team Norms
- Characteristics of Teams
- Ground Rules
- Team Contracts
- Sample Team Contract
- Session Four: Working as a Team
- Putting it Into Perspective
- No Need for Black and White Thinking
- Degrees of Support
- Session Five: Your Team Player Type
- What’s Your Team Player Type?
- Your Score
- What Does it Mean To Have a Number?
- Mostly A’s – Inquiring Rationals
- Mostly B’s – Authentic Idealists
- Mostly C’s – Organized Guardians
- Mostly D’s – Resourceful Artisans
- What’s Important?
- My Team Style
- Session Six: Building Team Trust
- Why is Trust Important?
- What Happens When Teams Trust Each Other?
- Building Trust
- Session Seven: The Stages of Team Development
- Stage One: Forming
- Stage Two: Storming
- Stage Three: Norming
- Stage Four: Performing
- Stage Five: Adjourning
- Forming an Effective Team
- Making Connections
- Session Eight: Virtual Teams
- Strategies for Virtual Team Success
- Scheduling and Conducting Team Meetings
- Team Building in a Virtual Environment
- Informal Bonding Interaction
- Session Nine: Communication
- Defining Communication
- Listening Skills
- Becoming a Better Listener
- Session Ten: Becoming a Good Team Player
- Attitude is Everything
- Personal Action Plan
- Starting Point
- Where I Want to Go
- How I Will Get There
| Adobe Illustrator CC: Part 2 · View Details | $395.00 | October 15, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Adobe Illustrator CC: Part 2
October 15, 2026 — 6:00 AM PDT–1:30 PM PDT
Adobe Illustrator CC: Part 2
You have created simple artwork by using the basic drawing and painting tools available in Adobe® Illustrator®. You now want to use advanced tools, options, and effects to create complex artwork. In addition, you want to ensure that your artwork is ready for commercial printing and also save it for the web. In this course, you will draw complex illustrations and enhance them by using various painting options. You will also use painting tools, manage colors, format type, work with effects, prepare artwork for commercial printing, and prepare graphics for the web.
This course is a great component of your preparation for the Adobe Certified Professional in Graphic Design & Illustration Using Adobe Illustrator exam.
This course is the second part of a two-course series that covers the skills needed to gain a foundational understanding of Illustrator.
– Adobe Illustrator CC: Part 1
– Adobe Illustrator CC: Part 2 (this course)
Completion of this course will earn 7.5 CPEs.
Course Objectives:
Upon successful completion of this course, students will be able to use Adobe Illustrator to create complex illustrations, format illustrations and type, and prepare documents for print and web.
You will:
– Draw complex illustrations
– Enhance artwork by using painting tools
– Customize colors and swatches
– Format type
– Enhance the appearance of artwork
– Prepare content for deployment
– Set up project requirements
Target Student:
This course is intended for designers, publishers, pre-press professionals, marketing communications professionals, or people taking on design responsibilities who need to use Illustrator to create illustrations, logos, advertisements, or other graphic documents. It is also useful for anyone interested in working toward the Adobe Certified Professional Graphic Design and Illustration Using Adobe Illustrator exam certification.
Prerequisites:
To ensure your success in this course, you should be familiar with basic computer functions such as creating folders, launching programs, and working with Windows. You should also have basic Windows application skills, such as copying and pasting objects, formatting text, and saving files.
Familiarity with basic design terminology, such as palettes, color modes, shapes, text, and paths, is highly recommended.
You can obtain this level of skill and knowledge by taking the following Logical Operations course:
– Adobe® Illustrator® CC: Part 1
Outline
- Lesson 1: Drawing Complex Illustrations
- Topic A: Apply the Grid, Guides, and Info Panel
- Topic B: Combine Objects to Create Complex Illustrations
- Topic C: Organize Artwork with Layers
- Topic D: Create a Perspective Drawing
- Topic E: Trace Artwork
- Lesson 2: Enhancing Artwork Using Painting Tools
- Topic A: Paint Objects Using Fills and Strokes
- Topic B: Paint Objects Using Live Paint Groups
- Topic C: Paint with Custom Brushes
- Topic D: Add Transparency and Blending Modes
- Topic E: Apply Meshes to Objects
- Topic F: Apply Patterns
- Lesson 3: Customizing Colors and Swatches
- Topic A: Manage Colors
- Topic B: Customize Swatches
- Topic C: Manage Color Groups
- Topic D: Adjust Color
- Lesson 4: Formatting Type
- Topic A: Set Character Formats
- Topic B: Apply Advanced Formatting Options to Type
- Lesson 5: Enhancing the Appearance of Artwork
- Topic A: Apply Effects to an Object
- Topic B: Create Graphic Styles
- Topic C: Apply a Mask to an Object
- Topic D: Apply Symbols and Symbol Sets
- Topic E: Work with 3D Objects
- Lesson 6: Preparing Content for Deployment
- Topic A: Prepare Artwork for Printing
- Topic B: Prepare Transparency and Colors for Printing
- Topic C: Create Slices and Image Maps
- Topic D: Save Graphics for the Web
- Topic E: Prepare Documents for Video
- Topic F: Prepare Files for Other Applications
- Lesson 7: Setting Project Requirements
- Topic A: Identify the Purpose, Audience, and Audience Needs
- Topic B: Determine and Evaluate Standard Copyright Rules for Artwork, Graphics, and Graphics Use
- Topic C: Determine and Evaluate Project Management Tasks and Responsibilities
- Appendix A: Mapping Course Content to Adobe Certified Professional in Graphic Design & Illustration Using Adobe Illustrator Exam
| Microsoft Project 2019-2024/365: Part 2 · View Details | $380.00 | October 16, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Microsoft Project 2019-2024/365: Part 2
October 16, 2026 — 6:00 AM PDT–1:30 PM PDT
Microsoft Project 2019-2024/365: Part 2
Welcome to Microsoft® Project® 2019-2024/365: Part 2. This course is designed to familiarize you with some of the advanced features and functions of Microsoft Project so you can use it effectively and efficiently in a real-world environment.
In Microsoft® Project® 2019-2024/365: Part 1, you learned the basic features of Microsoft Project during the planning phase of a project. This course covers the advanced knowledge and skills a project manager needs to update a project plan in Project during the execution, monitoring, and controlling phases of a project. In other words, once your project plan is approved by the project sponsor, this course will enable you to manage the project so that it is completed on time, within budget, and according to scope.
This material will benefit users of any current Project desktop version. The classroom environment setup is based on Project 2021.
Note: You can procure a license for the Project desktop app in one of two ways: purchasing a cloud-based subscription or an on-premises license. Project Online is included in both of the following purchase options:
– Cloud-based subscription: Project Plan 3 or 5. (Microsoft Project is not included in the Microsoft 365 plans. A separate subscription plan is required.)
– On-premises solution: Project Professional 2021
Completion of this course will earn 7.5 CPEs.
Course Objectives:
In this course, you will maintain project plans during the execution, monitoring, and controlling phases of a project. You will:
– Update a project plan
– Generate project views to manage a project
– Create project reports to share a project’s status
– Reuse project plan information
– Work with multiple projects
Target Student:
This course is designed for business professionals with an understanding of project management concepts and who are responsible for creating and maintaining project plans. Target students will be looking to acquire the advanced knowledge and skills needed to update a project plan in Microsoft Project during the execution, monitoring, and controlling phases of a project.
Outline
- Lesson 1: Updating a Project Plan
- Enter Task Progress
- Enter Overtime Work
- Edit Tasks
- Update Cost Rate Tables
- Update a Baseline
- Lesson 2: Viewing Project Progress
- Use View Commands
- Add Custom Fields
- Create Custom Views
- Format and Share the Timeline
- Lesson 3: Reporting on Project Progress
- View Built-in Reports
- Create Custom Reports
- Create Visual Reports
- Lesson 4: Reusing Project Plan Information
- Create a Project Plan Template
- Share Project Plan Elements with Other Plans
- Lesson 5: Working with Multiple Projects
- Share Resources
- Link Project Plans
- Appendix A: Project Management in the Cloud
| Emotional Intelligence · View Details | $395.00 | October 16, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Emotional Intelligence
October 16, 2026 — 6:00 AM PDT–1:30 PM PDT
Emotional Intelligence
Emotional intelligence, also called EQ, is the ability to be aware of and to manage emotions and relationships. It’s a pivotal factor in personal and professional success. IQ will get you in the door, but it is your EQ, your ability to connect with others and manage the emotions of yourself and others, that will determine how successful you are in life. We have all worked with and listened to brilliant people. Some of them were great and… well, some were not so great. The mean and the meek and all those in
between can teach us more than they realize. When we look at the truly extraordinary people who inspire and make a difference you will see that they do this by connecting with people at a personal and emotional level. What differentiated them was not their IQ but their EQ – their emotional intelligence. This course will help you develop your emotional intelligence.
Learning Objectives
Understand what emotional intelligence means
• Recognize how our emotional health and physical health are related
• Learn techniques to understand, use, and appreciate the role of emotional intelligence in the
workplace
• Understand the different emotions and how to manage them
• Create a personal vision statement
• Understand the difference between optimism and pessimism
• Validate emotions in others
Outline
Session 1: Course Overview
· Learning Objectives
· Pre-Assignment
· Pre-Course Assessment
Session 2: History of Emotional Intelligence
· History of Emotional Intelligence, Part One
· Making Connections
· History of Emotional Intelligence, Part Two
Session 3: Emotional Intelligence Defined
· Definitions and Thoughts
· The Six Seconds Model
· Making Connections
Session 4: EI Blueprint
· Instructions
· Identify Emotions
· Understand and Manage
· Use and Communicate
Session 5: Optimism
· Defining Optimism and Pessimism
· Choosing Our Approach
· ABC’s of Optimism
· Pessimism versus Optimism
· VET Process
· Adversities
Session 6: Validating Emotions in Others
· The VALUE Technique
· The SOLER Technique
· Communication Technique
Session 7: Understanding Emotions
· The Seven Human Emotions
· What Do Emotions Tell Us?
· Applying Emotional Intelligence
· Positives and Negatives
· The Emotional Map
· Plutchik’s Wheel of Emotions
Session 8: Setting Your Personal Vision
· Defining Your Principles
· Creating Your Vision
· Understanding Your Values
· Defining Our Values
· Identifying Our Influences
· Think in Terms of Relationships
· Creating Your Vision Statement
· What’s Standing in Your Way?
· Emotional Intelligence
· Think in Terms of Relationships
· Relationship Worksheet
· Creating Your Vision Statement
Session 9: A Personal Action Plan
· Starting Point
· Where I Want to Go
· How I Will Get There
Summary
Recommended Reading List
Post-Course Assessment
| Microsoft Word for Office 365 (Desktop or Online): Part 2 · View Details | $360.00 | October 16, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Microsoft Word for Office 365 (Desktop or Online): Part 2
October 16, 2026 — 6:00 AM PDT–1:30 PM PDT
Microsoft Word for Office 365 (Desktop or Online): Part 2
After you master the basics of using Microsoft® Word for Office 365™ such as creating, editing, and saving documents; navigating through a document; and printing, you’re ready to move on to tackling the more advanced features. These features enable you to create complex and professional documents with a consistent look and feel. They also enable you to automate tedious tasks such as preparing a letter to send to every customer of your organization.
Creating professional-looking documents can help you give your organization a competitive edge. Implementing time-saving features such as document templates and automated mailings helps your organization reduce expenses. Mastering these techniques will make you a valued employee in your organization.
Note: Most Office 365 users perform the majority of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will also enable you to access and effectively utilize many web-based resources provided with your Office 365 subscription. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version.
This course may be a useful component in your preparation for the Microsoft Word (Microsoft 365 Apps and Office 2019): Exam MO-100 and Microsoft Word Expert (Microsoft 365 Apps and Office 2019): Exam MO-101 certification exams.
This course is the second part of a three-course series that covers the skills needed to gain a foundational understanding of Word.
– Microsoft Word for Office 365 (Desktop or Online): Part 1
– Microsoft Word for Office 365 (Desktop or Online): Part 2 (this course)
– Microsoft Word for Office 365 (Desktop or Online): Part 3
Completion of this course will earn 7.5 CPEs.
Course Objectives:
In this course, you will learn fundamental Word skills.
You will:
– Organize content using tables and charts
– Customize formats using styles and themes
– Insert content using Quick Parts
– Use templates to automate document formatting
– Control the flow of a document
– Simplify and manage long documents
– Use mail merge to create letters, envelopes, and labels
Target Student:
This course is designed for students who wish to use Microsoft Word to create and modify complex documents and use tools that allow them to customize those documents.
Prerequisites:
To ensure your success, you should have end-user skills with any current version of Windows®, including being able to start programs, switch between programs, locate saved files, close programs, and access websites using a web browser. In addition, you should be able to navigate and perform common tasks in Word, such as opening, viewing, editing, and saving documents; formatting text and paragraphs; formatting the overall appearance of a page; and creating lists and tables.
Outline
- Lesson 1: Organizing Content Using Tables and Charts
- Topic A: Sort Table Data
- Topic B: Control Cell Layout
- Topic C: Perform Calculations in a Table
- Topic D: Create a Chart
- Topic E: Add an Excel Table to a Word Document
- Lesson 2: Customizing Formats Using Styles and Themes
- Topic A: Create and Modify Text Styles
- Topic B: Create Custom List or Table Styles
- Topic C: Apply Document Themes
- Lesson 3: Inserting Content Using Quick Parts
- Topic A: Insert Building Blocks
- Topic B: Create and Modify Building Blocks
- Topic C: Insert Fields Using Quick Parts
- Lesson 4: Using Templates to Automate Document Formatting
- Topic A: Create a Document Using a Template
- Topic B: Create and Modify a Template
- Topic C: Manage Templates with the Template Organizer
- Lesson 5: Controlling the Flow of a Document
- Topic A: Control Paragraph Flow
- Topic B: Insert Section Breaks
- Topic C: Insert Columns
- Topic D: Link Text Boxes to Control Text Flow
- Lesson 6: Managing Long Documents
- Topic A: Insert Blank and Cover Pages
- Topic B: Insert an Index
- Topic C: Insert a Table of Contents
- Topic D: Insert an Ancillary Table
- Topic E: Manage Outlines
- Topic F: Create a Master Document
- Lesson 7: Using Mail Merge to Create Letters, Envelopes, and Labels
- Topic A: Use Mail Merge
- Topic B: Merge Data for Envelopes and Labels
- Appendix A: Mapping Course Content to Word Associate (Office 365 and Office 2019): Exam MO-100
- Appendix B: Mapping Course Content to Word Expert (Office 365 and Office 2019): Exam MO-101
- Appendix C: Microsoft® Word for Office 365™ for the Desktop Common Keyboard Shortcuts
| Microsoft Excel for Office 365/2019-2024: Dashboards · View Details | $350.00 | October 20, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Microsoft Excel for Office 365/2019-2024: Dashboards
October 20, 2026 — 6:00 AM PDT–1:30 PM PDT
Microsoft Excel for Office 365/2019-2024: Dashboards
Today’s world runs on data more than ever before and that’s a trend not likely to change, or even slow down, any time soon. With the tremendous amount of available data, the ability to make sense of it continues to be an ongoing challenge. You already know how to use Excel to perform simple calculations and modify worksheets to make them easier to read, interpret, and present to others. But Excel is capable of doing so much more.
To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data, and present it in a visually compelling format that enables decision makers to view key trends and gain insights. And that’s exactly what this course aims to help you do.
This course builds upon the foundational knowledge presented in the Microsoft® Excel® for Office 365™ (Desktop or Online): Part 1 course and introduces the basics of data analysis and how to use Excel to create informative dashboards.
This material will benefit users of any current Office version. The classroom environment setup is based on Excel for Office 365.
Completion of this course will earn 7.5 CPEs.
Introduction
Course Objectives:
In this course, you will analyze and visualize data using Microsoft Excel and associated tools.
You will:
– Perform data analysis fundamentals
– Visualize data with Excel
– Analyze data with formulas and functions
– Analyze data with PivotTables
– Present visual insights with dashboards in Excel
Target Student:
This course is designed for students who already have foundational knowledge and skills in Excel and who wish to begin taking advantage of the data analysis functionality with Microsoft Excel by using functions, charts, and PivotTables, and using visualizations in charts and dashboards in Excel.
Outline
- Lesson 1: Data Analysis Fundamentals
- Topic A: Introduction to Data Science
- Topic B: Create and Modify Tables
- Topic C: Sort and Filter Data
- Lesson 2: Visualizing Data with Excel
- Topic A: Visualize Data with Charts
- Topic B: Modify and Format Charts
- Topic C: Apply Best Practices in Chart Design
- Lesson 3: Analyzing Data with Formulas and Functions
- Topic A: Analyze Data with Formulas and Named Ranges
- Topic B: Analyze Data with Functions
- Topic C: Implement Data Validation, Forms, and Controls
- Topic D: Create Conditional Visualizations with Lookup Functions
- Lesson 4: Analyzing Data with PivotTables
- Topic A: Create a PivotTable
- Topic B: Analyze PivotTable Data
- Lesson 5: Presenting Visual Insights with Dashboards in Excel
- Topic A: Visualize Data with PivotCharts
- Topic B: Filter Data Using Slicers and Timelines
- Topic C: Create a Dashboard in Excel
- Appendix A: Using Lookup Functions
| Get Started with QuickBooks Online 2021-2022 · View Details | $700.00 | Oct 20–Oct 21, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Get Started with QuickBooks Online 2021-2022
Oct 20–Oct 21, 2026 — 6:00 AM PDT–1:30 PM PDT
Get Started with QuickBooks Online 2021-2022
In this textbook, learners will be introduced to Intuit’s cloud accounting software program, QuickBooks Online (QBO). Using a fictitious company called Luxury Lodging, Inc, students will learn how to navigate the QBO interface. We cover basic accounting, how to set up a new company, how to customize the chart of accounts and products and services list. In addition, students will learn how to give other users, such as accountants access to their data. In the sales center chapter, students will learn how to invoice customers and stay on top of accounts receivable balances. In the vendor center chapter, students will learn how to
enter bills and expenses from vendors as well as stay on top of the accounts payable balances. The final chapter in the textbook is a final project that encompasses the key topics covered in this course. Refer to the table of contents below for a detailed list of topics covered in this textbook.
Completion of this course will earn 15 CPEs.
Outline
- Chapter 1 – Introduction
- Chapter 2 – An Overview of QBO & Navigation Basics
- Chapter 3 – Accounting Basics
- Chapter 4 – Setting Up A New Company File
- Chapter 5 – Managing the Chart of Accounts list
- Chapter 6 – Managing the Products and Services (Items) List
- Chapter 7 – Adding and Managing Users
- Chapter 8 – The Sales Center
- Chapter 9 – The Vendor Center
- Chapter 10 – 1099 Tracking and Reporting
- Chapter 11 – Managing Bank and Credit Card Accounts
- Chapter 12 – Creating Financial Statement Reports
- Chapter 13 – Entering Historical Data and Opening Balances
- Chapter 14 – Putting It All Together – Final Project
- Appendix A – Intuit Quickbooks User Certification Objectives
| Adobe Photoshop CC: Part 1 · View Details | $395.00 | October 20, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Adobe Photoshop CC: Part 1
October 20, 2026 — 6:00 AM PDT–1:30 PM PDT
Adobe Photoshop CC: Part 1
Adobe® Photoshop® CC: Part 1 focuses on some of the basic features of Photoshop so that the student can navigate the environment and use Photoshop tools to work with photographic images. In addition, the orientation to Adobe® Bridge and organization of files in Bridge is covered. Although Photoshop is used by a variety of professionals, from photographers to designers to videographers, Photoshop Part 1 will focus mainly on the photography component. The illustration and animation techniques are covered in subsequent levels of Photoshop.
This course is a great component of your preparation for the Adobe Certified Professional (ACP) in Visual Design Using Adobe Photoshop exam.
This course is the first part of a two-course series that covers the skills needed to gain a foundational understanding of Photoshop.
– Adobe Photoshop CC: Part 1 (this course)
– Adobe Photoshop CC: Part 2
Completion of this course will earn 7.5 CPEs.
Course Objectives:
This course will prepare you to use the most common basic features of Adobe Photoshop. In this course, you will:
– Identify the components and capabilities of Photoshop
– Create basic images
– Manage selections and layers
– Modify and repair images, and manage color
– Refine images by adjusting layers, using camera raw, and applying advanced image refinement
– Import, export, organize, and save files
Target Student:
Target students include professional or amateur photographers who want to use the robust features of Photoshop to enhance, modify, and organize their photographs, and anyone interested in working toward the Visual Design Using Adobe Photoshop certification.
Prerequisites:
To ensure your success in this course, you should have a basic comfort level with digital photography. For example, you have used a digital camera and have downloaded images to your computer or other storage device.
Outline
- Lesson 1: Getting Started with Photoshop
- Topic A: Organize Photoshop Assets by Using Adobe Bridge
- Topic B: Organize the Photoshop Workspace
- Topic C: Customize the Photoshop Workspace
- Lesson 2: Creating Basic Images
- Topic A: Manage Image Elements and Formats
- Topic B: Apply Design Principles, Elements, and Graphic Composition
- Topic C: Work with Digital Devices
- Lesson 3: Managing Selections and Layers
- Topic A: Use Selection Tools
- Topic B: Manage Layers
- Lesson 4: Adjusting Images
- Topic A: Modify Images
- Topic B: Repair Images
- Topic C: Implement Color Management
- Lesson 5: Refining Images
- Topic A: Adjust Layers
- Topic B: Apply Camera Raw
- Topic C: Refine Images by Using Advanced Tools
- Lesson 6: Managing Files in a Production Workflow
- Topic A: Import, Export, and Organize Files
- Topic B: Save Images for the Web
- Topic C: Save Images for Print
- Topic D: Format Images for Other Programs
- Appendix A: Mapping Course Content to the Adobe Certified Professional in Visual Design Using Adobe Photoshop Exam
| Microsoft Outlook for Office 365 (Desktop or Online): Part 1 · View Details | $350.00 | October 20, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Microsoft Outlook for Office 365 (Desktop or Online): Part 1
October 20, 2026 — 6:00 AM PDT–1:30 PM PDT
Microsoft Outlook for Office 365 (Desktop or Online): Part 1
In this course, you will use Outlook to send, receive, and manage email messages; manage your contact information; schedule appointments and meetings; create tasks and notes for yourself; and customize the Outlook interface to suit your working style.
Note: Most Office 365™ users perform the majority of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will also enable you to access and effectively utilize many web-based resources provided with your Office 365 subscription. This includes brief coverage of key skills for using Outlook on the Web and OneDrive®. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version.
This course may be a useful component in your preparation for the Microsoft Outlook (Microsoft 365 Apps and Office 2019): Exam MO-400 certification exam.
This course is the first part of a two-course series that covers the skills needed to gain a foundational understanding of Outlook.
– Microsoft Outlook for Office 365 (Desktop or Online): Part 1 (this course)
– Microsoft Outlook for Office 365 (Desktop or Online): Part 2
Completion of this course will earn 7.5 CPEs.
Course Objectives:
In this course, you will use Outlook to compose and handle your email communications and also manage your calendar, contacts, and tasks.
You will:
– Navigate Outlook to read and respond to email
– Use the Address Book and format and spell check new messages
– Attach files to and insert illustrations in messages
– Customize read and response options
– Use flags, categories, and folders to organize messages
– Create and work with contacts
– Create appointments and schedule meetings in the calendar
– Create and work with tasks and notes
Target Student:
This course is intended for those with a basic understanding of Microsoft Windows® and who need to know how to use Outlook as an email client to manage their email communications, calendar events, contact information, and other communication tasks.
Prerequisites:
To ensure your success, you should have end-user skills with any current version of Windows, including being able to start and close applications, navigate basic file structures, manage files and folders, and access websites using a web browser.
Outline
- Lesson 1: Getting Started with Outlook
- Topic A: Navigate the Outlook Interface
- Topic B: Work with Messages
- Topic C: Access Outlook Help
- Topic D: Navigate Outlook on the Web
- Lesson 2: Formatting Messages
- Topic A: Add Message Recipients
- Topic B: Check Spelling and Grammar
- Topic C: Format Message Content
- Lesson 3: Working with Attachments and Illustrations
- Topic A: Attach Files and Items
- Topic B: Add Illustrations to Messages
- Topic C: Manage Automatic Message Content
- Lesson 4: Customizing Message Options
- Topic A: Customize Reading Options
- Topic B: Track Messages
- Topic C: Recall and Resend Messages
- Lesson 5: Organizing Messages
- Topic A: Mark Messages
- Topic B: Organize Messages Using Folders
- Lesson 6: Managing Contacts
- Topic A: Create and Edit Contacts
- Topic B: View and Print Contacts
- Lesson 7: Working with the Calendar
- Topic A: View the Calendar
- Topic B: Create Appointments
- Topic C: Schedule Meetings
- Topic D: Print the Calendar
- Lesson 8: Working with Tasks and Notes
- Topic A: Create Tasks
- Topic B: Create Notes
- Appendix A: Mapping Course Content to Outlook Associate (Office 365 and Office 2019): Exam MO-400
- Appendix B: Microsoft® Outlook® Common Keyboard Shortcuts
| Project Management Fundamentals (Third Edition) · View Details | $395.00 | October 20, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Project Management Fundamentals (Third Edition)
October 20, 2026 — 6:00 AM PDT–1:30 PM PDT
Project Management Fundamentals
Successfully managing a project requires effective planning and adherence to the industry’s best practices in every step of the process. By understanding the fundamentals of project management, you will be better prepared to initiate a project in your organization and position it for success. In this course, you will identify effective project management practices and their related processes.
At this point in your professional development, you are ready to take on the responsibility for managing projects. You can manage a project by developing a solid understanding of the fundamentals of project management and its underlying structure and elements, including project phases, project life cycles, stakeholders, and areas of expertise. These, coupled with the ability to identify the project management processes that are recognized industry-wide as good practice, will help you to apply effective project management techniques to improve the efficiency of your projects and ensure their success.
Completion of this course will earn 7.5 CPEs.
Course Objectives:
In this course, you will examine the elements of sound project management and apply the generally recognized practices to successfully manage projects.
You will:
– Identify the key processes and requirements of project management
– Initiate a project
– Plan for time and cost
– Plan for project risks, communication, and change control
– Execute, manage, and control a project
– Close a project
Target Student:
This course is designed for individuals whose primary job is not project management, but who manage projects on an informal basis. Also, anyone who is considering a career path in project management and desiring a complete overview of the field and its generally accepted practices can benefit from this course.
Outline
- Lesson 1: Getting Started with Project Management
- Topic A: Identify the Characteristics of a Project
- Topic B: Identify the Project Management Life Cycle
- Topic C: Identify the Role of a Project Manager
- Lesson 2: Initiating a Project
- Topic A: Determine the Scope of a Project
- Topic B: Identify the Skills for a Project Team
- Topic C: Identify the Risks to a Project
- Lesson 3: Planning for Time and Cost
- Topic A: Create a WBS
- Topic B: Sequence the Activities
- Topic C: Create a Project Schedule
- Topic D: Determine Project Costs
- Lesson 4: Planning for Project Risks, Communication, and Change Control
- Topic A: Analyze the Risks to a Project
- Topic B: Create a Communication Plan
- Topic C: Plan for Change Control
- Lesson 5: Managing a Project
- Topic A: Begin Project Work
- Topic B: Execute the Project Plan
- Topic C: Track Project Progress
- Topic D: Report Performance
- Topic E: Implement Change Control
- Lesson 6: Closing the Project
- Topic A: Close a Project
- Topic B: Create a Final Report
| PowerPoint 365: Visual Information Design · View Details | $275.00 | October 20, 2026 — 10:30 AM PDT–1:30 PM PDT | Book Now |
PowerPoint 365: Visual Information Design
October 20, 2026 — 10:30 AM PDT–1:30 PM PDT
PowerPoint 365: Visual Information Design
This course explores the essential skills and strategies for creating effective virtual presentations using Microsoft PowerPoint. You will learn to design visually engaging slides to
communicate information clearly and efficiently. Emphasizing best practices according to Mayer’s Principles of Design, this course will help you enhance audience engagement and
retention. This workshop assumes learners have experience working with PowerPoint 365 and are ready to increase their efficiency in presenting complex topics.
OUTLINE
Lesson 1: Presentations & Cognitive Load
Topic A: Purpose of a visual presentation
Topic B: How does Cognitive Load affect your message?
Lesson 2: Principles of Design
Topic A: Contrast
Topic B: Space
Topic C: Consistency
Lesson 3: Best Practices with Text
Topic A: Mayer’s Principles of Design
Topic B: Signaling Principle
Topic C: Redundancy Principle
Topic D: Case Study: Writing Concisely
Lesson 4: Best Practices with Objects
Topic A: Spatial Contiguity Principle
Topic B: Using Images for Impact
Topic C: Working with Graphs and Charts
Lesson 5: Putting Your Skills into Practice
Topic A: Create an effective presentation using visual design principles in PowerPoint
| Microsoft Visio 2019-2024: Part 1 · View Details | $350.00 | October 21, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Microsoft Visio 2019-2024: Part 1
October 21, 2026 — 6:00 AM PDT–1:30 PM PDT
Microsoft Visio 2019-2024: Part 1
From the earliest eras of human existence, visual images have been used to represent knowledge, data, and information. Beginning with the Paleolithic cave paintings and continuing to today’s most complex computer networks, these images leverage the ability of the human brain to rapidly perceive patterns and trends from visual representations.
In today’s workplace, visual diagrams are an essential part of communication, from road maps to sales flows to process charts. Microsoft® Visio® provides you with an intuitive, customizable tool to easily create a professional-looking visual product by using its extensive gallery of shapes. By following the exercises in this course, you will create visually engaging diagrams, maps, and drawings, using graphical elements to make information easier to comprehend.
This material will benefit users of any current Visio version. The classroom environment setup is based on Visio 2019.
In this course, you will design, modify, and manage basic diagrams. You will:
– Identify the basic elements of Visio and their use
– Create a workflow diagram
– Build organization chart
– Design a floor plan
– Build a cross-functional flowchart
– Design a network diagram
– Style a diagram
Outline
- Lesson 1: Getting Started with Visio
- Topic A: Perform Basic Tasks in the Visio Environment
- Topic B: Work with Visio Global Options in the Backstage View
- Topic C: Save a File
- Topic D: Work with Visio for the Web
- Lesson 2: Working with Workflow Diagram Tools
- Topic A: Use Drawing Components
- Topic B: Modify a Drawing
- Topic C: Insert Callouts and Groups
- Lesson 3: Building Organization Charts
- Topic A: Create an Organization Chart Manually
- Topic B: Create Organization Charts by Using Starter Diagrams and the Organization Chart Wizard
- Topic C: Modify an Organization Chart
- Lesson 4: Designing a Floor Plan
- Topic A: Make a Basic Floor Plan
- Topic B: Model a Room Layout
- Lesson 5: Building a Cross-Functional Flowchart
- Topic A: Create a Cross-Functional Flowchart
- Topic B: Format a Cross-Functional Flowchart
- Lesson 6: Designing a Network Diagram
- Topic A: Create Network Diagrams
- Topic B: Use Shape Data
- Topic C: Use Layers
- Lesson 7: Styling a Diagram
- Topic A: Modify Shape and Connector Styles
- Topic B: Apply Themes and Variants
- Topic C: Use Containers
| Microsoft PowerPoint for Office 365 (Desktop or Online): Part 2 · View Details | $360.00 | October 21, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Microsoft PowerPoint for Office 365 (Desktop or Online): Part 2
October 21, 2026 — 6:00 AM PDT–1:30 PM PDT
Microsoft PowerPoint for Office 365 (Desktop or Online): Part 2
Meetings, instruction, training, pitches; these are all a part of our daily lives. We are often called upon to deliver presentations with little notice, at multiple venues, and with varying requirements. And, some of these presentations include sensitive information that needs to be guarded. Given all the variables, it may seem an overwhelming task to deliver your content, on time, to all audiences, and to only those who need to see it. Oh, and by the way, you need to make it interesting, informative, and memorable. So, how do you do it? Without the help of a robust set of tools, it would be nearly impossible. But Microsoft® PowerPoint® provides you with a variety of such tools that can help you deliver content in nearly any situation, while saving time and effort. By taking advantage of these tools, you will be creating presentations that not only stand out from the crowd, but also don’t consume all of your available time.
Note: Most Office 365™ users perform the majority of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will also enable you to access and effectively utilize many web-based resources provided with your Office 365 subscription. This includes brief coverage of key skills for using PowerPoint for the Web and OneDrive. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version.
This course may be a useful component in your preparation for the PowerPoint Associate (Microsoft 365 Apps and Office 2019): Exam MO-300 certification exam.
This course is the second part of a two-course series that covers the skills needed to gain a foundational understanding of PowerPoint.
Microsoft PowerPoint for Office 365 (Desktop or Online): Part 1
Microsoft PowerPoint for Office 365 (Desktop or Online): Part 2 (this course)
Completion of this course will earn 7.5 CPEs.
Course Objectives:
In this course, you will use the advanced tools and features in PowerPoint to create and deliver engaging presentations.
You will:
– Customize design templates.
– Add tables.
– Add charts.
– Work with media.
– Build advanced transitions and animations.
– Collaborate on a presentation.
– Customize the delivery of a presentation.
– Modify presentation navigation.
– Secure and distribute a presentation.
Target Student:
This course is intended for students who have a foundational working knowledge of PowerPoint, who wish to take advantage of the application’s higher-level usability, security, collaboration, and distribution functionality.
Prerequisites:
To ensure success, students should have experience using PowerPoint, running within the Windows® 10 operating system, to create, edit, and deliver presentations. To obtain this level of knowledge and skills, you can take the following Logical Operations courses:
Using Microsoft® Windows® 10 or Microsoft® Windows® 10: Transition from Windows® 7
Microsoft® PowerPoint® for Office 365™ (Desktop or Online): Part 1
Outline
- Lesson 1: Customizing Design Templates
- Topic A: Modify Slide Masters and Slide Layouts
- Topic B: Modify the Notes Master and the Handout Master
- Topic C: Add Headers and Footers
- Lesson 2: Adding Tables
- Topic A: Create a Table
- Topic B: Format a Table
- Topic C: Insert a Table from Other Microsoft Office Applications
- Lesson 3: Adding Charts
- Topic A: Create a Chart
- Topic B: Format a Chart
- Topic C: Insert a Chart from Microsoft Excel
- Lesson 4: Working with Media
- Topic A: Add Audio to a Presentation
- Topic B: Add Video to a Presentation
- Topic C: Add a Screen Recording
- Lesson 5: Building Advanced Transitions and Animations
- Topic A: Use the Morph Transition
- Topic B: Customize Animations
- Lesson 6: Collaborating on a Presentation
- Topic A: Review a Presentation
- Topic B: Co-author a Presentation
- Lesson 7: Customizing Presentation Delivery
- Topic A: Enhance a Live Presentation
- Topic B: Record a Presentation
- Topic C: Set Up a Slide Show
- Lesson 8: Modifying Presentation Navigation
- Topic A: Divide a Presentation into Sections
- Topic B: Add Links
- Topic C: Create a Custom Slide Show
- Lesson 9: Securing and Distributing a Presentation
- Topic A: Secure a Presentation
- Topic B: Create a Video or a CD
- Appendix A: Mapping Course Content to PowerPoint Associate (Office 365 and Office 2019): Exam MO-300
- Appendix B: Microsoft®PowerPoint® Common Keyboard Shortcuts
- Appendix C: Using Ink to Hand Draw Elements
| Adobe Acrobat Pro: New Experience (Advanced) · View Details | $395.00 | October 21, 2026 — 10:30 AM PDT–1:30 PM PDT | Book Now |
Adobe Acrobat Pro: New Experience (Advanced)
October 21, 2026 — 10:30 AM PDT–1:30 PM PDT
Adobe® Acrobat® Pro: New Experience (Advanced)
As a business professional, you have some experience using Adobe® Acrobat®. Now you’re ready to take further advantage of all the features of Acrobat Pro to bring your documents to the next level. Whether you are creating PDFs for commercial printing or for viewing digital versions on a range of platforms, Adobe Acrobat Pro enables you to output your content so your audience will be able to access and view the document just the way you intended.
In this course, you will use Adobe Acrobat Pro to enhance PDF documents, create interactive PDF forms, and prepare PDF files for commercial printing.
Course Objectives:
In this course, you will create and manage PDF documents.
You will:
- Customize the Acrobat Pro workspace
- Enhance PDF documents
- Create interactive PDF forms
- Finalize PDF files for commercial printing
Target Student:
The target students for this course are office professionals with a foundational understanding of Adobe Acrobat Pro who want to use the advanced productivity features and the creative features of Acrobat Pro.
Outline
Lesson 1: Customizing the Acrobat Pro Workspace
Topic A: Customize the Quick Tools Toolbar
Topic B: Configure Acrobat Preferences
Lesson 2: Enhancing PDF Documents
Topic A: Embed Multimedia
Topic B: Enhance PDF Document Accessibility
Topic C: Use Guided Actions
Topic D: Manage the Security of PDF Documents
Lesson 3: Creating Interactive PDF Forms
Topic A: Create a PDF Form
Topic B: Compile and Manage PDF Form Data
Lesson 4: Finalizing PDF Files for Commercial Printing
Topic A: Apply Color-Management Settings
Topic B: Preview Printed Effects
Topic C: Perform Preflight on a PDF Document
Topic D: Create ISO-Compliant PDF Files
Topic E: Create a Composite and Color Separations
| SQL Querying: Fundamentals (Third Edition) · View Details | $395.00 | October 22, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
SQL Querying: Fundamentals (Third Edition)
October 22, 2026 — 6:00 AM PDT–1:30 PM PDT
SQL Querying: Fundamentals (Third Edition)
Organizations typically store their most critical information—the information used to manage day-to-day operations—within a database. The ability to retrieve and analyze this information is essential to the functioning of the organization. Structured Query Language (SQL) is the primary language used to accomplish such tasks. Essentially, SQL is the language you use to interact with a database.
The ability to write SQL is an essential job skill for those who need to manage large volumes of data, produce reports, mine data, or combine data from multiple sources. Even if someone else on your team creates reports for you, having a fundamental understanding of SQL querying will help you ask the right questions and know what you’re looking for in your data analysis tools.
This course, SQL Querying: Fundamentals (Third Edition), will teach you to use SQL as a tool to retrieve the information you need from databases.
In this course, you will compose SQL queries to retrieve desired information from a database. You will:
– Connect to the SQL Server database and execute a simple query
– Include a search condition in a simple query
– Use various functions to perform calculations on data
– Organize the data obtained from a query before it is displayed onscreen
– Retrieve data from multiple tables
– Export the results of a query
Outline
- Lesson 1: Executing a Simple Query
- Topic A: Connect to the SQL Database
- Topic B: Query a Database
- Topic C: Save a Query
- Topic D: Modify and Execute a Saved Query
- Lesson 2: Performing a Conditional Search
- Topic A: Search Using One or More Conditions
- Topic B: Search for a Range of Values and NULL Values
- Topic C: Search Data Based on String Patterns
- Lesson 3: Working with Functions
- Topic A: Perform Date Calculations
- Topic B: Calculate Data Using Aggregate Functions
- Topic C: Manipulate String Values
- Lesson 4: Organizing Data
- Topic A: Sort Data
- Topic B: Rank Data
- Topic C: Group Data
- Topic D: Filter Grouped Data
- Topic E: Summarize Grouped Data
- Topic F: Use PIVOT and UNPIVOT Operators
- Lesson 5: Retrieving Data from Multiple Tables
- Topic A: Combine the Results of Two Queries
- Topic B: Compare the Results of Two Queries
- Topic C: Retrieve Data by Joining Tables
- Lesson 6: Exporting Query Results
- Topic A: Save Query Results as a Text File
- Topic B: Save Query Results as an XML File
- Appendix A: The Pub1 Database
| Microsoft Excel for Office 365 (Desktop or Online): Part 3 · View Details | $380.00 | October 22, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Microsoft Excel for Office 365 (Desktop or Online): Part 3
October 22, 2026 — 6:00 AM PDT–1:30 PM PDT
Microsoft Excel for Office 365 (Desktop or Online): Part 3
Clearly, you use Microsoft® Excel® a lot in your role. Otherwise, you wouldn’t be taking this course. By now, you’re already familiar with Excel, its functions and formulas, a lot of its features and functionality, and its powerful data analysis tools. You are likely called upon to analyze and report on data frequently, work in collaboration with others to deliver actionable organizational intelligence, and keep and maintain workbooks for all manner of purposes. At this level of use and collaboration, you have also likely encountered your fair share of issues and challenges. You’re too busy, though, to waste time scouring over workbooks to resolve issues or to perform repetitive, monotonous tasks. You need to know how to get Excel to do more for you so you can focus on what’s really important: staying ahead of the competition. That’s exactly what this course aims to help you do.
This course builds upon the foundational and intermediate knowledge presented in the Microsoft® Excel® for Office 365™ (Desktop or Online): Part 1 and Microsoft® Excel® for Office 365™ (Desktop or Online): Part 2 courses to help you get the most of your Excel experience. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you’ll be able to focus on getting the answers you need from the vast amounts of data your organization generates.
Note: Most Office 365™ users perform the majority of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will also enable you to access and effectively utilize many web-based resources provided with your Office 365 subscription. This includes brief coverage of key skills for using Excel for the Web and OneDrive. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version.
This course is the third part of a three-course series that covers the skills needed to gain a foundational understanding of Excel.
– Microsoft Excel for Office 365 (Desktop or Online): Part 1
– Microsoft Excel for Office 365 (Desktop or Online): Part 2
– Microsoft Excel for Office 365 (Desktop or Online): Part 3 (this course)
This course may be a useful component in your preparation for the Microsoft Excel (Microsoft 365 Apps and Office 2019): Exam MO-200 and Microsoft Excel Expert (Microsoft 365 Apps and Office 2019): Exam MO-201 certification exams.
Completion of this course will earn 7.5 CPEs.
Course Objectives:
Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.
You will:
– Work with multiple worksheets and workbooks
– Share and protect workbooks
– Automate workbook functionality
– Use Lookup functions and formula auditing
– Forecast data
– Create sparklines and map data
Target Student:
This course is intended for students who are experienced Excel users and have a desire or need to advance their skills in working with some of the more advanced Excel features. Students will likely need to troubleshoot large, complex workbooks, automate repetitive tasks, engage in collaborative partnerships involving workbook data, construct complex Excel functions, and use those functions to perform rigorous analysis of extensive, complex datasets.
Prerequisites:
To ensure success, students should have practical, real-world experience creating and analyzing datasets using Excel. Specific tasks students should be able to perform include: creating formulas and using Excel functions; creating, sorting, and filtering datasets and tables; presenting data by using basic charts; creating and working with PivotTables, slicers, and PivotCharts; and customizing the Excel environment.
Outline
- Lesson 1: Working with Multiple Worksheets and Workbooks
- Topic A: Use Links and External References
- Topic B: Use 3-D References
- Topic C: Consolidate Data
- Lesson 2: Sharing and Protecting Workbooks
- Topic A: Collaborate on a Workbook
- Topic B: Protect Worksheets and Workbooks
- Lesson 3: Automating Workbook Functionality
- Topic A: Apply Data Validation
- Topic B: Search for Invalid Data and Formulas with Errors
- Topic C: Work with Macros
- Lesson 4: Using Lookup Functions and Formula Auditing
- Topic A: Use Lookup Functions
- Topic B: Trace Cells
- Topic C: Watch and Evaluate Formulas
- Lesson 5: Forecasting Data
- Topic A: Determine Potential Outcomes Using Data Tables
- Topic B: Determine Potential Outcomes Using Scenarios
- Topic C: Use the Goal Seek Feature
- Topic D: Forecast Data Trends
- Lesson 6: Creating Sparklines and Mapping Data
- Topic A: Create Sparklines
- Topic B: Map Data
- Appendix A: Mapping Course Content to Excel Associate (Office 365 and Office 2019): Exam MO-200
- Appendix B: Mapping Course Content to Excel Expert (Office 365 and Office 2019): Exam MO-201
- Appendix C: Microsoft® Excel® Common Keyboard Shortcuts
- Appendix D: Cube Functions
- Appendix E: Importing and Exporting Data
- Appendix F: Customizing Workbooks
| Leadership Skills for Supervisors · View Details | $395.00 | October 23, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Leadership Skills for Supervisors
October 23, 2026 — 6:00 AM PDT–1:30 PM PDT
Leadership Skills for Supervisors
Supervisors are the crucial interface between the employee on the shop floor or the service desk and the managers of the organization. Although they often have more technical experience than the employees they supervise, some may not have a lot of leadership experience. This one-day course will provide the skills in communication, coaching, and managing conflict that are necessary for success.
Completion of this course will earn 7.5 CPEs.
Learning Objectives
– Learn ways to prioritize, plan, and manage your time
– Identify your primary leadership style
– Develop some flexibility to use other leadership styles
– Determine ways you can meet the needs of employees and co-workers through communication and coaching
– Explore ways to make conflict a powerful force for creative, well-rounded solutions to problems
Outline
- Session One: Course Overview
- Learning Objectives
- Pre-Assignment
- Pre-Course Assessment
- Session Two: Pre-Assignment Review
- Making Connections
- Session Three: What’s Your Type? How About Mine?
- Seeking Information
- Identifying Your Characteristics and Preferences
- Questionnaire
- Analyzing the Results
- Mostly A’s – Inquiring Rationals
- Mostly B’s – Authentic Idealists
- Mostly C’s – Organized Guardians
- Mostly D’s – Resourceful Artisans
- What’s Important?
- Debrief
- Session Four: Introversion/Extroversion
- Questionnaire
- Using the Continuum
- Case Study
- Lessons to Learn
- Session Five: Understanding Leadership
- About Leadership
- The Situational Leadership II® Model
- Understanding Your Comfort Zone
- Choosing Our Style
- Managing Performance
- Making Connections
- Servant Leadership
- Making Connections
- Session Six: Manage Your Time and Your Energy
- Introduction
- Time Management Tips
- Larks and Owls
- Our Top Time Management Tip
- Session Seven: The Commitment Curve
- Onboarding and Orientation
- The Big Picture
- Stages of the Curve
- Stage One: Uninformed Optimism
- Stage Two: Informed Pessimism
- Stage Three: Hopeful Realism
- Stage Four: Informed Optimism
- Summary
- What Can Be Done to Bridge the Commitment Gap?
- Session Eight: Employee Development Models
- The Coaching Model
- Step One: Frame a Conversation
- Step Two: Create Opportunities
- Step Three: Create an Action Plan
- Step Four: Give Feedback
- The Dialogue Model
- I Messages
- The Consequences and Benefits Matrix
- Session Nine: Dealing with Conflict and Difficult Issues
- Reflection
- Conflict
- Conflict Resolution Styles
- Techniques for Resolving Conflict
- Session Ten: What Successful Leaders Do
- Secrets to Success
- List of Practices
- Making Connections
- Creating the Right Environment
- Personal Action Plan
- Starting Point
- Where I Want to Go
- How I Will Get There
| Conflict Resolution: Getting Along in the Workplace · View Details | $395.00 | October 27, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Conflict Resolution: Getting Along in the Workplace
October 27, 2026 — 6:00 AM PDT–1:30 PM PDT
Conflict Resolution: Getting Along in the Workplace
Many people see conflict as a negative experience. In fact, conflict is a necessary part of our personal growth and development. Think of when you were trying to choose your major in college, for example, or trying to decide between two jobs. However, conflict becomes an issue when the people involved cannot work through it. They become engaged in a battle that does not result in growth. When this type of conflict arises, negative energy can result, causing hurt feelings and damaged relationships. This course will give you the tools that will help you resolve conflict successfully and produce a win- win outcome.
Completion of this course will earn 7.5 CPEs.
Learning Objectives
– Understand what conflict is and how it can escalate
– Understand the types of conflict and the stages of conflict
– Recognize the five most common conflict resolution styles and when to use them
– Increase positive information flow through non-verbal and verbal communication skills
– Develop effective techniques for intervention strategies
– Become more confident of your ability to manage conflicts to enhance productivity and performance
Outline
- Session 1: Course Overview
- Learning Objectives
- Pre-Assignment: A Conflict Effectiveness
- Benchmark
- Pre-Course Assessment
- Session 2: Defining Conflict
- Defining Conflict
- Assumptions
- Positives and Negatives
- Session 3: Types of Conflict
- Types of Conflict
- Inner Conflict
- Interpersonal Conflict
- Group Conflict
- Session 4: Open Conflict vs. Hidden
- Conflict
- Dealing with Conflict
- Open Conflict
- Hidden Conflict
- Session 5: Spontaneous and Reflective
- Behavior
- Spontaneous and Reflective Behavior
- Exploring Behaviors
- Session 6: The Johari Window
- Understanding the Johari Window
- Self-Disclosure with the Johari Window
- My Window
- Case Study: Spontaneous and Reflective Behaviors
- Session 7: Stages of Conflict
- The Five Stages of Conflict
- Latent Conflict
- Perceived Conflict
- Felt Conflict
- Manifest Conflict
- Conflict Aftermath
- Conclusion
- Another Version of the Conflict Process
- Stage 1: Mild Difference
- Stage 2: Disagreement
- Stage 3: Dispute
- Stage 4: Campaign
- Stage 5: Litigation
- Stage 6: Fight and/or War
- Conflict Outcomes
- Win-Lose
- Win-Win
- Strategies for Dealing with Conflict
- Win/Lose Strategy
- Lose/Lose Strategy
- Results of Win/Lose and Lose/Lose Strategies
- Win/Win Strategy
- Session 8: Creating the Win/Win
- Case Study
- Instructions
- Session 9: Conflict Resolution Style
- Questionnaire
- Score Sheet
- The Conflict Grid
- Pros and Cons
- Authoritative Command/Competitive Smoothing
- Compromising
- Problem-Solving
- Session 10: The Role of Communication in Conflict Resolution
- Conflict Resolution
- The Communication Chain
- Speaker’s Words
- Speaker’s Facial Expressions
- Speaker’s Tone of Voice
- Other Body Language
- Other Barriers
- Paradigms
- Education
- Assumptions
- Establishing Positive Intent
- Making Connections
- Accepting Differences
- Session 11: Active Listening Skills
- Active Listening Skills
- Responding to Feelings
- Reading Cues
- Demonstration Cues
- Tips for Becoming a Better Listener
- Session 12: Paraphrasing Skills
- What Is Paraphrasing?
- Case Study
- Summary Questions
- Making Connections
- Session 13: Powerful Questions
- Asking Questions
- Open Questions
- Handy Questions
- Making Connections
- Probing Techniques
- Session 14: Body Language
- Body Language Basics
- Making Connections
- Session 15: Pre-Assignment Review
- Pre-Assignment Review
- Session 16: The Conflict/Opportunity Test
- The Conflict/Opportunity Test
- Skills Test
- Situation Two
- Situation Three
- Situation Four
- Session 17: Conflict and Its Resolution
- Visualizing Conflict
- Conflict Resolution Process
- Assumptions when Using the Conflict Resolution Process
- Hands-On Steps
- Template
- A Strategy for Conflict Resolution
- Phase Two: Identify the Common Goal (Use Color 2)
- Phase Three: Identify and Rate Underlying Needs (Use Color 3)
- Phase Four: Explore Assumptions (Use Color 4)
- Phase Five: Brainstorm Solutions and Choose One (Color 5)
- Session 18: Helping Others Through Conflict
- Preparing for Conflict
- Preparation Tips
- Conflict Resolution with Facilitation
- Give It a Name
- Check for Agreement
- Avoid Process Battles
- Echo
- Keep the Group on Track
- Hold Them to Their Word
- Encourage and Compliment
- Deal With/Accept/Legitimize/Defer
- Don’t Be Defensive
- Use Your Body Language
- Keep It Simple
- Setting Norms
- Sample Norms
- Using Norms
- Sample Survey
- Coaching Through Conflict
- Competing Issues
- Managing Your Emotions
- The Positive Effect
- Fifteen Steps for Dealing with Upset People
- Five Tips for Dealing with Difficult People
- Six Steps for Dealing with Angry People
- Session 19: A Personal Action Plan
- Starting Point
- Short-Term Goals and Rewards
- Long-Term Goals
| Data Analysis & Visualization with Microsoft Excel (D.A.V.E.) · View Details | $650.00 | Oct 27–Oct 28, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Data Analysis & Visualization with Microsoft Excel (D.A.V.E.)
Oct 27–Oct 28, 2026 — 6:00 AM PDT–1:30 PM PDT
Data Analysis & Visualization with Microsoft Excel (D.A.V.E.)
Technology and the data that it both collects and makes accessible is now interwoven with businesses and lives. The era of “big data” has exploded due to the rise of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantage.
Analyzing data to find issues, insights, and opportunities is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways.
Microsoft® Excel® is designed for this purpose. Excel can connect to a wide range of data sources, perform robust data analysis, and create diverse and robust data-backed visualizations to show insights and trends, and create reports. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action.
Completion of this course will earn 15 CPEs.
In this course, you will analyze and visualize data using Microsoft Excel and associated tools.
You will:
– Perform data analysis fundamentals
– Visualize data with Excel
– Analyze data with formulas and functions
– Analyze data with PivotTables
– Present visual insights with dashboards in Excel
– Create geospatial visualization with Excel
– Perform statistical analysis
– Get and transform data
– Model and analyze data with Power Pivot
– Present insights with reports
Target Student:
This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using PivotTables, use tools such as Power Pivot and the Data Analysis ToolPak to analyze data, and visualize data and insights using advanced visualizations in charts and dashboards in Excel.
Prerequisites:
To ensure success, you should have baseline skill using Microsoft Excel worksheets, particularly in creating workbooks with formulas and functions.
Outline
- Lesson 1: Data Analysis Fundamentals
- Topic A: Introduction to Data Science
- Topic B: Create and Modify Tables
- Topic C: Sort and Filter Data
- Lesson 2: Visualizing Data with Excel
- Topic A: Visualize Data with Charts
- Topic B: Modify and Format Charts
- Topic C: Apply Best Practices in Chart Design
- Lesson 3: Analyzing Data with Formulas and Functions
- Topic A: Analyze Data with Formulas and Named Ranges
- Topic B: Analyze Data with Functions
- Topic C: Implement Data Validation, Forms, and Controls
- Topic D: Create Conditional Visualizations with Lookup Functions
- Lesson 4: Analyzing Data with PivotTables
- Topic A: Create a PivotTable
- Topic B: Analyze PivotTable Data
- Lesson 5: Presenting Visual Insights with Dashboards in Excel
- Topic A: Visualize Data with PivotCharts
- Topic B: Filter Data Using Slicers and Timelines
- Topic C: Create a Dashboard in Excel
- Lesson 6: Creating Geospatial Visualizations with Excel
- Topic A: Create Map Charts in Excel
- Topic B: Customize Map Charts in Excel
- Lesson 7: Performing Statistical Analysis
- Topic A: Visualize Trendlines and Sparklines with Excel
- Topic B: Analyze Data with the Data Analysis ToolPak
- Lesson 8: Getting and Transforming Data
- Topic A: Connect to Data with Queries
- Topic B: Clean and Combine Data
- Topic C: Shape and Transform Data
- Lesson 9: Modeling and Analyzing Data with Power Pivot
- Topic A: Install Power Pivot in Excel
- Topic B: Create Data Models with Power Pivot
- Topic C: Create Power Pivots
- Topic D: Perform Advanced Data Analysis and Visualization
- Lesson 10: Presenting Insights with Reports (Optional)
- Topic A: Plan a Report
- Topic B: Create a Report
| SQL Querying: Advanced (Third Edition) · View Details | $395.00 | October 27, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
SQL Querying: Advanced (Third Edition)
October 27, 2026 — 6:00 AM PDT–1:30 PM PDT
SQL Querying: Advanced (Third Edition)
In today’s competitive environment, information is one of the most important factors in determining the success of an organization. If you are able to manage and retrieve information efficiently, you can streamline the organization’s processes and give it a competitive edge. Some data analysis tasks may require that you query multiple tables simultaneously or create complex views of data.
In the course SQL Querying: Fundamentals (Third Edition), you learned the basics of SQL querying. In this course, you will build on this foundation, learning advanced querying techniques, such as writing nested queries and using views to simplify repetitive querying tasks. You will also learn how to perform common database administration tasks such as duplicating tables; modifying table structures; inserting, updating, or deleting data; and indexing tables to optimize query performance. You will also learn how to work with multiple tasks as a transaction.
In this course, you will construct advanced queries and apply them to data. You will:
– Use nested queries to generate query output
– Manipulate table data by inserting, modifying, and deleting data
– Manipulate the structure of tables
– Work with views to present data
– Index data to improve querying efficiency
– Manage database transactions
Outline
- Lesson 1: Using Nested Queries
- Topic A: Search Based on Values from a Subquery
- Topic B: Compare Values from a Subquery
- Topic C: Search Based on the Existence of Records
- Topic D: Generate Output Using Correlated Subqueries
- Topic E: Filter Grouped Data Within Subqueries
- Topic F: Perform Multiple-Level Subqueries
- Lesson 2: Manipulating Table Data
- Topic A: Insert Rows
- Topic B: Modify and Delete Data
- Lesson 3: Manipulating the Table Structure
- Topic A: Create a Table
- Topic B: Create a Table with Constraints
- Topic C: Modify a Table’s Structure
- Topic D: Delete Tables
- Lesson 4: Working with Views
- Topic A: Create a View
- Topic B: Manipulate Data in Views
- Topic C: Modify and Delete Views
- Lesson 5: Indexing Data
- Topic A: Create Indexes
- Topic B: Drop Indexes
- Lesson 6: Managing Transactions
- Topic A: Begin and Roll Back Transactions
- Topic B: Commit Transactions
- Appendix A: The Pub2 Database
| Communication Strategies · View Details | $395.00 | October 28, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Communication Strategies
October 28, 2026 — 6:00 AM PDT–1:30 PM PDT
Communication Strategies
Have you ever wondered why it seems so difficult to talk with some people, yet so easy to talk with others? This course explores how to improve your communication skills to make it easier for you to get along in the workplace, and in life.
Completion of this course will earn 7.5 CPEs.
Learning Objectives
• Identify common communication problems that may be holding you back
• Develop skills to ask questions that give you information you need
• Learn what your non-verbal messages are telling others
• Develop skills to listen actively and empathetically to others
• Enhance your ability to handle difficult situations
• Deal with situations assertively
Outline
- Session One: Course Overview
- Learning Objectives
- Pre-Assignment
- Pre-Course Assessment
- Session Two: Creating Positive Relationships
- Ten Quick Wins
- Making Connections
- Session Three: Growing Our Self-Awareness
- Do You Question Your Competence?
- Developing Confidence
- Session Four: Communication Basics
- Defining a Skilled Communicator
- Making Connections
- Session Five: Communication Barriers
- Case Study: New Neighbors
- Common Barriers
- Applying the Answers
- Being Mindful
- Session Six: Asking Questions
- Asking Good Questions
- Probing
- Five Ways to Probe
- Pushing My Buttons
- Session Seven: Listening Skills
- Can You Hear Me?
- How Do You Rate Your Listening Ability?
- Active Listening Skills
- Responding to Feelings
- Reading Cues
- Demonstration Cues
- Tips for Becoming a Better Listener
- What is Said and What is Heard
- Communication Situations
- Session Eight: Body Language
- What Do Our Bodies Say?
- The Signals People Send
- Gestures
- Session Nine: Communication Styles
- Dichotomies in Theory
- Making Connections
- Advantages and Disadvantages
- Dichotomies in Action
- Session Ten: Creating a Positive Self-Image
- Seven Things People Determine from Your Appearance
- Pre-Assignment Review
- Self-Evaluation
- Session Eleven: Frame of Reference
- Your Frame of Reference
- Suspending Belief
- Session Twelve: Techniques for the Workplace
- Prepare, Prepare, Prepare
- Testing Our Theories
- Delivering Your Message
- Check for Understanding
- Session Thirteen: Assertiveness Self-Attitude
- Words to Watch Out For
- Your Inner Self Talk Persuasion
- 30 Ways to Persuade
- Case Study: A Negative Image
- I Messages
- The Assertive Formula
- Expressing Your No
- The Persistent Response
- Guidelines for Saying No
- Personal Action Plan
- Starting Point
- Where I Want to Go
- How I Will Get There
| Programming and Data Wrangling with VBA and Excel · View Details | $995.00 | Oct 28–Oct 30, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Programming and Data Wrangling with VBA and Excel
Oct 28–Oct 30, 2026 — 6:00 AM PDT–1:30 PM PDT
Programming and Data Wrangling with VBA and Excel
VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft® Excel® and other applications in the Microsoft® 365 application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users.
Completion of this course will earn 22.5 CPEs.
Introduction
In this course, you will develop and deploy VBA modules to solve business problems.
You will:
– Identify general components of VBA and their appropriate use in solving business solutions
– Record VBA macros to automate repetitive tasks
– Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment
– Write VBA code to create a custom worksheet function
– Eliminate, avoid, or handle errors in VBA code, and optimize its performance
– Control how and when macros run
– Develop UserForm objects to create custom dialog boxes and windows
– Use VBA to read and write data from local files and cloud services
– Use VBA to clean and transform data
– Run programs and commands outside of Excel and share VBA projects with other users
Target Student:
This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand.
Prerequisites:
To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft® Excel® for Office 365 (Desktop or Online) courses, Parts 1, 2, and 3.
Outline
- Lesson 1: Using VBA to Solve Business Problems
- Topic A: Use Macros to Automate Tasks in Excel
- Topic B: Identify Components of Macro-Enabled Workbooks
- Topic C: Configure the Excel VBA Environment
- Lesson 2: Automating Repetitive Tasks
- Topic A: Use the Macro Recorder to Create a VBA Macro
- Topic B: Record a Macro with Relative Addressing
- Topic C: Delete Macros and Modules
- Topic D: Identify Strategies for Using the Macro Recorder
- Lesson 3: Getting Help on VBA
- Topic A: Use VBA Help
- Topic B: Use the Object Browser to Discover Objects You Can Use in VBA
- Topic C: Use the Immediate Window to Explore Object Properties and Methods
- Lesson 4: Creating Custom Worksheet Functions
- Topic A: Create a Custom Function
- Topic B: Make Decisions in Code
- Topic C: Work with Variables
- Topic D: Perform Repetitive Tasks
- Lesson 5: Improving Your VBA Code
- Topic A: Debug VBA Errors
- Topic B: Deal with Errors
- Topic C: Improve Macro Performance
- Lesson 6: Controlling How and When Macros Run
- Topic A: Prompt the User for Information
- Topic B: Configure Macros to Run Automatically
- Lesson 7: Developing Custom Forms
- Topic A: Display a Custom Dialog Box
- Topic B: Program Form Events
- Lesson 8: Using VBA to Work with Files
- Topic A: Use VBA to Get File and Directory Structure
- Topic B: Use VBA to Read Text Files
- Topic C: Use VBA to Write Text Files
- Lesson 9: Using VBA to Clean and Transform Data
- Topic A: Automate Power Query
- Topic B: Transform Data Using VBA and Workbook Functions
- Topic C: Use Regular Expressions
- Topic D: Manage Errors in Data
- Lesson 10: Extending the Programming Environment Beyond the Workbook
- Topic A: Run Other Programs and Commands
- Topic B: Share Your VBA Projects
| Public Speaking: Presentation Survival School · View Details | $395.00 | October 28, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Public Speaking: Presentation Survival School
October 28, 2026 — 6:00 AM PDT–1:30 PM PDT
Public Speaking: Presentation Survival School
This course will teach you how to manage your thoughts, body language, nervousness, and speech patterns to present yourself professionally. You’ll also learn how to present at meetings, use the five-S pattern to prepare a good presentation, and punch up your presentation with visual aids.
Completion of this course will earn 7.5 CPEs.
Learning Objectives
– Establish rapport with your audience
– Implement techniques to reduce nervousness and fear
– Understand your strengths as a presenter and how to appeal to different types of people
– Recognize how visual aids can create impact and attention
– Develop techniques to create a professional presence
– Learn some different ways to prepare and organize information
– Prepare, practice, and deliver a short presentation
Outline
- Session One: Course Overview
- Learning Objectives
- Pre-Assignment
- Pre-Course Assessment
- Session Two: Communication
- About Communication
- Simple Conversations
- Session Three: Stop! Check Your Mouth!
- Speaking Characteristics
- Gender References Exercise
- Acronyms and Jargon
- Tact
- Five Good Rules
- Session Four: What Is Your Type? How About Mine?
- The Assessment
- Identifying Your Characteristics and Preferences
- Questionnaire
- What Does it Mean to Have a Number?
- What Is Important?
- People That Are Most Like Me
- People That Are Least Like Me
- Session Five: Positive Self-Talk
- Our Thoughts
- The Steps to Feeling Good
- Thinking Positively
- Session Six: Rapport
- Building Rapport
- Making Connections: Self-Disclosure
- Creating an Introduction
- Session Seven: Maximizing Meetings
- Four Areas of Opportunity
- Fifteen Ways to Master a Meeting
- Mastering Your Meeting Exercise
- Learning Names
- Session Eight: Body Language
- Body Language Signals
- Session Nine: Sticky Situations
- Are You Comfortable?
- Dealing with Tough Situations
- Dressing Up
- Session Ten: I Can Just Send an E-mail, Right?
- Advantages of an Oral Presentation
- Oratory Exercise
- Oratory Exercise: Practice Paragraph
- Session Eleven: Overcoming Nervousness
- About Nervousness
- Nervousness Can Have Many Sources
- Putting Yourself in Control
- Mastering Non-verbal Communication
- Session Twelve: The Five S’s
- Five Points for Any Presentation
- Framework Example
- Preparing with the Five-S Pattern
- Session Thirteen: Start Writing!
- Evidence
- Introductions
- Following the Opening Statement
- Exercise: Beginning a Presentation
- Transitioning to the Body
- Example of a Transition in a Presentation
- Enhancing Your Presentation with Stories, Numbers, and Examples
- Endings
- Making Connections: Think Fast!
- Your Fast Thinking Presentation
- Session Fourteen: Audience Profile
- Preparing an Audience Profile
- Making Connections: Your Next
- Presentation
- Session Fifteen: Your Speaking Voice
- Parts of Your Message
- Vocal Variety
- Paying Attention to Your Voice
- Mastering Your Material
- Session Sixteen: Add Punch to Your Presentation
- The Power of Threes
- Well Known Tripling Examples
- Visual Aids
- Tips for Using Visual Aids
- More Tips for Using Visual Aids
- Analyzing Visual Aids
- Adding Punch Summary
- Lessons Learned
- Session Seventeen: Your Presentation
- Preparation
- Introduction
- Body
- Conclusion
- Presentation
- Personal Action Plan
- Starting Point
- Where I Want to Go
- How I Will Get There
| Crystal Reports 2020: Part 2 · View Details | $790.00 | Oct 28–Oct 29, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Crystal Reports 2020: Part 2
Oct 28–Oct 29, 2026 — 6:00 AM PDT–1:30 PM PDT
Crystal Reports 2020: Part 2
Until now, you have used SAP Crystal Reports to build and modify reports. You want to use the advanced functionality of Crystal Reports to generate reports in the format you desire. In this course, you will create complex reports and data sources using the tools in Crystal Reports 2020. You will not only create more sophisticated reports, including sub-reports and cross-tabs, but you will also increase the speed and efficiency of your reports by using SQL queries.
Even though you are familiar with Crystal Reports, you may take some time to study its various tools that enable you to generate reports with the desired data using advanced methods such as SQL querying. This way, you won’t be slowed down by large databases or databases with which you are unfamiliar. By creating sub-reports, cross-tabs, and running totals, you will turn raw data into meaningful, customized reports that will help your business run more smoothly. If you work with large databases, you may find yourself faced with performance issues. In this course, you will also learn to use tools that can increase the speed with which data is retrieved.
This course is the second part of a two-course series that covers the skills needed to gain a foundational understanding of Crystal Reports.
– Crystal Reports 2020: Part 1
– Crystal Reports 2020: Part 2 (this course)
Completion of this course will earn 15 CPEs.
Course Objectives: In this course, you will create complex reports using tools in Crystal Reports 2020.
You will:
– Create automatic and manual running totals
– Work with cross-tab reports
– Add subreports
– Create drill-downs in a report
– Use SQL statements in report processing
– Create complex formulas
– Add charts to reports
– Enhance report functionality
Target Student: This course is designed for people who know how to create basic list and group reports and need to create reports that include subreports, cross-tabs, advanced formulas, and charts based on more than one data series. They may also need to build tools that make it easier for other people to create reports. Learners may or may not have programming or SQL experience, although they should be familiar with the fundamental concepts of data tables and relational databases.
Prerequisites: To ensure your success, a knowledge of programming and/or SQL would also be helpful. You can also take the following Logical Operations course:
– Crystal Reports 2020: Part 1
Outline
- Lesson 1: Creating Running Totals
- Topic A: Create a Running Total Field
- Topic B: Modify a Running Total Field
- Topic C: Create a Manual Running Total
- Lesson 2: Working with Cross-Tabs
- Topic A: Create a Cross-Tab Report
- Topic B: Format a Cross-Tab Report
- Topic C: Create Groups in Cross-Tab Reports
- Lesson 3: Adding Subreports
- Topic A: Insert a Sub-report
- Topic B: Edit a Sub-report
- Topic C: Share Variables
- Lesson 4: Creating Drill-Downs in a Report
- Topic A: Create a Drill-Down
- Topic B: Create Headings for Drill-Down Data
- Lesson 5: Using SQL Statements in Report Processing
- Topic A: Create a Report Using SQL Queries
- Topic B: Summarize Report Data
- Topic C: Create Joins Using SQL
- Topic D: Create Subqueries
- Topic E: Create an SQL Expression Field
- Lesson 6: Creating Complex Formulas
- Topic A: Work with Loops
- Topic B: Work with Arrays
- Lesson 7: Adding Charts to Reports
- Topic A: Create Charts
- Topic B: Drill Down to Chart Data
- Topic C: Create a Top N Chart
- Topic D: Create a Cross-Tab Chart
- Topic E: Create Charts for Grouped Data
- Topic F: Format a Chart
- Topic G: Create a Chart Template
- Lesson 8: Enhancing Report Functionality
- Topic A: Organize Data Based on a Hierarchy
- Topic B: Create a Dynamic Image
- Topic C: Create a Report Alert
- Topic D: Create a Geographic Map
- Appendix A: Managing Reports
- Appendix B: Processing Data on the Server
- Appendix C: Detecting and Fixing Problems
| Microsoft SharePoint Modern Experience: Site Basics · View Details | $450.00 | October 28, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Microsoft SharePoint Modern Experience: Site Basics
October 28, 2026 — 6:00 AM PDT–1:30 PM PDT
Microsoft SharePoint Modern Experience: Site Basics
In many professional environments, people work collaboratively in teams. Information technology and applications facilitate this by enabling people to easily share, access, edit, and save information. Microsoft® SharePoint® is a platform specifically designed to facilitate communication and collaboration, enabling people to use familiar applications and web-based tools to create, access, store, and track documents and data in a central location. In this course, you will use SharePoint to access, store, share, and collaborate with information and documents.
This course is the first part of a three-course series that covers the skills needed to gain a foundational understanding of SharePoint.
– SharePoint Modern Experience: Site Basics (this course)
– SharePoint Modern Experience: Site Owner with Power Platform
– SharePoint Modern Experience: Advanced Site Owner
Completion of this course will earn 7.5 CPEs.
Course Objectives:
In this course, you will use a typical SharePoint team site to work collaboratively with other team members.
You will:
– Launch a SharePoint site and navigate among the pages and resources provided by the site
– Use SharePoint lists to track and view information
– Use document libraries to store and organize documents
– Find, share, and archive content stored in SharePoint
– Author documents as a member of a SharePoint team site
– Use SharePoint workflow automation tools
Target Student:
This course is designed for Microsoft® Windows® and Microsoft Office users who are transitioning to a SharePoint environment, and who need to access information from and collaborate with team members within Microsoft SharePoint.
Prerequisites:
To ensure your success in this course, you should have basic end-user skills with a current version of Microsoft Windows.
OUTLINE
Lesson 1: Navigating SharePoint Sites
Topic A: Launch SharePoint
Topic B: Gain Access to a Site You Didn’t Create
Topic C: Navigate Within a SharePoint Site
Topic D: Access SharePoint from Your Mobile Device
Lesson 2: Using Lists to Track Information
Topic A: Add and Populate Lists
Topic B: Change View Options
Topic C: Create a Custom View
Lesson 3: Using Document Libraries to Share and Organize Documents
Topic A: Store Files in a Document Library
Topic B: Create and Use Document Templates
Lesson 4: Finding, Sharing, and Archiving Content
Topic A: Search for Items in Lists or Libraries
Topic B: Share Through Links
Topic C: Move Files Offline
Lesson 5: Authoring Documents as a Team
Topic A: Work Together on Documents
Topic B: Manage File Versions and Document Recovery
Lesson 6: Automating Business Processes
Topic A: Use Rule-Based Automation
Topic B: Use Power Automate to Automate a Workflow
| Using Microsoft Windows 11 (with Copilot) · View Details | $350.00 | October 29, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Using Microsoft Windows 11 (with Copilot)
October 29, 2026 — 6:00 AM PDT–1:30 PM PDT
Using Microsoft Windows 11 (with Copilot)
Whether you’re new to computers or have used them in the past, this class will help you become more comfortable using Windows® 11 by familiarizing you with the Windows 11 user interface and its basic capabilities. In this course, you will explore the Windows 11 environment, work with locally installed apps, use Copilot in Windows and Copilot in Edge, browse the Internet, access and organize files and folders stored on the computer and in OneDrive®, and manage basic Windows 11 settings.
Target Student:
This course is designed for end users who want to be productive with the Windows 11 features and functionality, especially Copilot.
Outline
- Lesson 1: Accessing Windows 11
- Topic A: Sign In to Windows 11
- Topic B: Navigate the Windows 11 Desktop
- Topic C: Use the Start Menu
- Topic D: Access Copilot in Windows 11
- Lesson 2: Working with Apps
- Topic A: Use Windows 11 Apps
- Topic B: Use AI-Enhanced Apps
- Topic C: Multitask with Multiple Open Apps
- Topic D: Install Apps
- Lesson 3: Using Web Resources
- Topic A: Use Microsoft Edge
- Topic B: Use Copilot in Microsoft Edge
- Topic C: Configure Microsoft Edge
- Topic D: Use Cloud-Based Apps
- Lesson 4: Managing Files and Folders
- Topic A: Manage Files and Folders with File Explorer
- Topic B: Store and Share Files in OneDrive
- Topic C: Find Files, Folders, and Apps
- Lesson 5: Configuring Windows 11
- Topic A: Configure Settings
- Topic B: Use Common Windows System Tools
- Topic C: Manage Printers and Other Devices
- Topic D: Use Accessibility Features
- Lesson 6: Securing Your Computer
- Topic A: Manage Passwords and Sign-In Options
- Topic B: Manage Windows Security
- Topic C: Manage Windows Updates
- Appendix A: Navigation and Selection Techniques
- Appendix B: Keyboard Shortcuts
- Appendix C: Windows Administrative Tools
| Microsoft Word for Office 365 (Desktop or Online): Part 3 · View Details | $380.00 | October 29, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Microsoft Word for Office 365 (Desktop or Online): Part 3
October 29, 2026 — 6:00 AM PDT–1:30 PM PDT
Microsoft Word for Office 365 (Desktop or Online): Part 3
Word for Microsoft 365 enables you to do far more than simple word processing. Word includes advanced image manipulation tools, collaboration features, cross-referencing and linking tools, entry forms and data collection, security features, and tools to automate document production.
Being able to manipulate graphics and efficiently create, manage, revise, and distribute long documents and forms can help your organization create important and interesting documents. Implementing time-saving features that enable you to work well in a collaborative mode will benefit both you and your organization. Constructing document elements that ensure your readers have access to pertinent information at the click of a button, while at the same time protecting sensitive information, is another important skill. Mastering these skills and techniques will make you a valued employee in your organization
Note: Most Office 365 users perform the majority of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will also enable you to access and effectively utilize many web-based resources provided with your Office 365 subscription. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version.
This course may be a useful component in your preparation for the Microsoft Word (Microsoft 365 Apps and Office 2019): Exam MO-100 and Microsoft Word Expert (Microsoft 365 Apps and Office 2019): Exam MO-101 certification exams.
This course is the third part of a three-course series that covers the skills needed to gain a foundational understanding of Word.
– Microsoft Word for Office 365 (Desktop or Online): Part 1
– Microsoft Word for Office 365 (Desktop or Online): Part 2
– Microsoft Word for Office 365 (Desktop or Online): Part 3 (this course)
Completion of this course will earn 7.5 CPEs.
Course Objectives:
In this course, you will explore advanced functionalities in Word.
You will:
– Use images in a document
– Create custom graphic elements
– Collaborate on documents
– Add reference marks and notes
– Secure a document
– Create and manipulate forms
– Create macros to automate tasks
Target Student:
This course is intended for students who want to use more advanced functionalities in Microsoft Word, including image manipulation, collaboration and revision tracking, cross-referencing and linking, document security, forms, and process automation through macros.
Prerequisites:
To ensure your success, you should have end-user skills with any current version of Windows®, including being able to start programs, switch between programs, locate saved files, close programs, and access websites using a web browser. In addition, you should be able to navigate and perform common tasks in Word, such as opening, viewing, editing, and saving documents; formatting text and paragraphs; formatting the overall appearance of a page; and creating lists and tables.
Outline
- Lesson 1: Manipulating Images
- Topic A: Integrate Pictures and Text
- Topic B: Adjust Image Appearance
- Lesson 2: Using Custom Graphic Elements
- Topic A: Create Text Boxes and Pull Quotes
- Topic B: Add WordArt and Other Text Effects
- Topic C: Draw Shapes
- Topic D: Create Complex Illustrations with SmartArt
- Lesson 3: Collaborating on Documents
- Topic A: Share and Co-Author a Document
- Topic B: Mark Up a Document
- Topic C: Review Markups
- Topic D: Merge Changes from Other Documents
- Lesson 4: Adding Document References and Links
- Topic A: Add Captions
- Topic B: Add Cross-References
- Topic C: Add Bookmarks
- Topic D: Add Hyperlinks
- Topic E: Insert Footnotes and Endnotes
- Topic F: Add Citations and a Bibliography
- Lesson 5: Securing a Document
- Topic A: Suppress Information
- Topic B: Set Formatting and Editing Restrictions
- Topic C: Restrict Document Access
- Topic D: Add a Digital Signature to a Document
- Lesson 6: Using Forms to Manage Content
- Topic A: Create Forms
- Topic B: Modify Forms
- Lesson 7: Automating Repetitive Tasks with Macros
- Topic A: Automate Tasks by Using Macros
- Topic B: Create a Macro
- Appendix A: Mapping Course Content to Word Associate (Office 365 and Office 2019): Exam MO-100
- Appendix B: Mapping Course Content to Word Expert (Office 365 and Office 2019): Exam MO-101
- Appendix C: Microsoft® Word Common Keyboard Shortcuts
| AI for Everyday Business Professionals · View Details | $195.00 | October 29, 2026 — 6:00 AM PDT–9:00 AM PDT | Book Now |
AI for Everyday Business Professionals
October 29, 2026 — 6:00 AM PDT–9:00 AM PDT
AI for Everyday Business Professionals
AI tools are increasingly used by professionals to save time and reduce administrative workload. This practical, non-technical course focuses on real-world productivity use cases, helping participants learn how to use AI to work faster and smarter with emails, meetings, and documents—without sacrificing quality or professionalism. Participants will learn how to use AI as a work assistant, not a replacement, while maintaining accountability and personal judgment.
Upon successful completion of this course, you will be able to:
• Use AI to draft and refine professional emails
• Improve meeting preparation, follow-up, and documentation
• Create, organize, and summarize documents more efficiently
• Write better prompts for stronger results
• Apply AI safely and effectively in daily workflows
Materials Provided
• Participant reference guide
• Practical AI prompts and examples
• Post-class job aid
• Microlearning follow-up resources
Outline
1. AI as an Everyday Work Assistant
Understanding where AI fits into a typical workday
2. Saving Time with Emails
Drafting, rewriting, and responding more efficiently
3. Making Meetings More Efficient
Agendas, summaries, and follow-up communication
4. Working Smarter with Documents
Drafting, outlining, and summarizing content
5. Prompting Basics for Better Results
How to ask AI for what you actually need
6. Best Practices & Personal AI Workflow
Applying AI intentionally and responsibly
| Microsoft Excel for Office 365/2021-2024: Data Analysis with PivotTables · View Details | $195.00 | October 29, 2026 — 6:00 AM PDT–9:00 AM PDT | Book Now |
Microsoft Excel for Office 365/2021-2024: Data Analysis with PivotTables
October 29, 2026 — 6:00 AM PDT–9:00 AM PDT
Microsoft Excel for Office 365/2021-2024: Data Analysis with PivotTables
Advances in technology have made it possible to store ever-increasing amounts of data. Along with this, the need to analyze data and gain actionable insight is greater than ever. You already have experience working with Microsoft® Excel® and creating basic PivotTables to summarize data. But Excel is capable of doing much more. Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyze, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved.
This material will benefit users of any current Office version. The classroom environment setup is based on Excel for Office 365.
Completion of this course will earn 3.4 CPEs.
Course Objectives:
In this course, you will use the advanced PivotTable functionality in Excel to analyze your raw data.
You will:
– Prepare data for PivotTable reporting and create PivotTables from various data sources
– Analyze data by using PivotTables
– Work with PivotCharts
Target Student:
Students taking this course are experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables.
Outline
- Lesson 1: Preparing Data and Creating PivotTables
- Prepare Data
- Create a PivotTable from a Local Data Source
- Create a PivotTable from Multiple Local Data Sources
- Create a PivotTable from an External Data Source
- Lesson 2: Analyzing Data by Using PivotTables
- Summarize PivotTable Data
- Organize PivotTable Data
- Filter PivotTable Data
- Format a PivotTable
- Refresh and Change PivotTable Data
- Lesson 3: Working with PivotCharts
- Create a PivotChart
- Manipulate PivotChart Data
- Format a PivotChart
| SharePoint Modern Experience: Site Owner with Power Platform · View Details | $450.00 | October 29, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
SharePoint Modern Experience: Site Owner with Power Platform
October 29, 2026 — 6:00 AM PDT–1:30 PM PDT
SharePoint Modern Experience: Site Owner with Power Platform
Microsoft® SharePoint®, in conjunction with the Microsoft 365 suite of productivity and office automation tools, provides tools to create and manage a corporate intranet, facilitate content sharing and collaboration, and enable users to create, access, store, and track documents and data in a central location. By default, SharePoint provides end users with a generous set of permissions, enabling users to create and customize their own sites as site owners, and create and collaborate on team site content. Users who have grown comfortable with these fundamental content-authoring capabilities may want to move on to more advanced features, such as connecting multiple SharePoint sites through a hub, importing list data from external sources, implementing user input validation features, applying conditional formatting, and using Power Apps® to provide custom user interfaces for data collected in SharePoint. This course focuses on issues related to planning and implementing an intranet with multiple communication sites and team sites interconnected through a hub site to provide unified navigation search, and formatting.
This course is the second part of a three-course series that covers the skills needed to gain a foundational understanding of SharePoint.
– SharePoint Modern Experience: Site Basics
– SharePoint Modern Experience: Site Owner with Power Platform (this course)
– SharePoint Modern Experience: Advanced Site Owner
Completion of this course will earn 7.5 CPEs.
In this course, you will create a SharePoint team site and a communication site, connect them with a hub site, create custom page layouts, perform advanced tasks in libraries and lists, and integrate a Power Apps custom application with SharePoint.
You will:
– Plan and create a SharePoint-based multi-site intranet, including team and communication sites
– Associate multiple sites with a hub site to provide unified navigation, search, and theme
– Use advanced SharePoint features to manage content creation in lists and libraries, including custom page templates and various methods to import data
– Configure lists with various input validation features to improve the quality of data entry and presentation
– Use Power Apps Studio to create a custom user interface for entering data in a SharePoint list
Target Student:
This course is designed for Microsoft SharePoint site users who are already comfortable using SharePoint as a site user (site visitor or site member), but who want to advance to creating new sites and integrating them with features like Power Apps.
Prerequisites:
To ensure your success in this course, you should have basic end-user skills with a current version of Microsoft Windows. You should also have basic SharePoint site user skills such as the ability to view and enter data in SharePoint lists and libraries, and to navigate a typical SharePoint site.
Outline
- Lesson 1: Setting Up a Multi-Site Intranet
- Topic A: Plan Your Organization’s Intranet
- Topic B: Create and Configure SharePoint Sites
- Lesson 2: Connecting Sites to a Hub
- Topic A: Create a Hub to Connect Multiple Sites
- Topic B: Apply a Site Template
- Topic C: Change Site Themes and Navigation
- Lesson 3: Populating a Site with Content
- Topic A: Create Custom Page Layouts
- Topic B: Manage Library Files
- Topic C: Manage List Data
- Lesson 4: Improving List Data Entry and Presentation
- Topic A: Limit What Users Can Enter
- Topic B: Create Calculated Columns
- Topic C: Use Formulas to Validate Entered Data
- Lesson 5: Integrating a Power Apps Application with SharePoint Online
- Topic A: Create a Power Apps Application
- Topic B: Modify an App
- Appendix A: Cleaning Up Unused Resources
| Microsoft Access for Office 365: Part 3 · View Details | $395.00 | October 29, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Microsoft Access for Office 365: Part 3
October 29, 2026 — 6:00 AM PDT–1:30 PM PDT
Microsoft Access for Office 365: Part 3
You’ve covered many of the basic functions of Microsoft® Access®, and now you’re ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers.
This course is the third part of a three-course series that covers the skills needed to perform basic database design and development in Microsoft Access.
Microsoft® Access® for Office 365™: Part 1 : Focuses on the design and construction of an Access database —viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.
Microsoft® Access® for Office 365™: Part 2 : Focuses on optimization of an Access database, including optimizing performance and normalizing data; data validation; usability; and advanced queries, forms, and reports.
Microsoft® Access® for Office 365™: Part 3 (this course): Focuses on managing the database and supporting complex database designs , including import and export of data; using action queries to manage data; creating complex forms and reports; macros and Visual Basic for Applications (VBA); and tools and strategies to manage, distribute, and secure a database.
This course may be a useful component in your preparation for the Microsoft Access Expert (Microsoft 365 Apps and Office 2019): Exam MO-500 certification exam.
Completion of this course will earn 7.5 CPEs.
Course Objectives:
In this course, you will manage an Access database and add complex database features to improve its usability, efficiency, performance, and security.
You will:
– Share data across applications.
– Use action, unmatched, and duplicate queries to manage data.
– Create complex reports and forms.
– Use macros to improve user interface design.
– Use VBA to extend database capabilities.
– Perform database management tasks such as backup, compacting, repairing, performance analysis, checking object dependencies, and documenting.
– Implement security strategies and distribute a database to multiple users.
Target Student:
Students taking this course are database administrators or prospective database administrators who have experience working with Microsoft Access for Office 365 and need to learn advanced skills.
Prerequisites:
To ensure your success in this course, you should have experience working with Access for Office 365, including a working knowledge of database design and creation, form design and creation, report design and creation, and a working knowledge of database querying and the various table relationships. You can obtain this level of skills and knowledge by taking the following Logical Operations courses:
Microsoft® Access® for Office 365™: Part 1
Microsoft® Access® for Office 365™: Part 2
Outline
- Lesson 1: Importing and Exporting Table Data
- Topic A: Import and Link Data
- Topic B: Export Data
- Topic C: Create a Mail Merge
- Lesson 2: Using Queries to Manage Data
- Topic A: Create Action Queries
- Topic B: Create Unmatched and Duplicate Queries
- Lesson 3: Creating Complex Reports and Forms
- Topic A: Create Subreports
- Topic B: Create a Navigation Form
- Topic C: Show Details in Subforms and Popup Forms
- Lesson 4: Creating Access Macros
- Topic A: Create a Standalone Macro to Automate Repetitive Tasks
- Topic B: Create a Macro to Program a User Interface Component
- Topic C: Filter Records by Using a Condition
- Topic D: Create a Data Macro
- Lesson 5: Using VBA to Extend Database Capabilities
- Topic A: Introduction to VBA
- Topic B: Use VBA with Form Controls
- Lesson 6: Managing a Database
- Topic A: Back Up a Database
- Topic B: Manage Performance Issues
- Topic C: Document a Database
- Lesson 7: Distributing and Securing a Database
- Topic A: Split a Database for Multiple-User Access
- Topic B: Implement Security
- Topic C: Convert an Access Database to an ACCDE File
- Topic D: Package a Database with a Digital Signature
- Appendix A: Mapping Course Content to Access Expert (Office 365 and Office 2019): Exam MO-500
- Appendix B: Microsoft® Access® for Office 365™ Common Keyboard Shortcuts
- Appendix C: More Queries and Calculations
- Appendix D: Common SQL Commands
| Adobe Photoshop CC: Part 2 · View Details | $395.00 | October 29, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Adobe Photoshop CC: Part 2
October 29, 2026 — 6:00 AM PDT–1:30 PM PDT
Adobe Photoshop CC: Part 2
Adobe® Photoshop® is a leading graphic creation application, popular among graphic designers, illustrators, and photographers. Photoshop’s numerous features work together to provide a comprehensive toolset for you, the design professional. This course delves into some of the more advanced image creation and editing techniques, and offers you hands-on activities that demonstrate how these techniques can be used in combination to create exciting visual effects.
This course is a great component of your preparation for the Adobe Certified Professional (ACP) in Visual Design Using Adobe Photoshop exam.
This course is the second part of a two-course series that covers the skills needed to gain a foundational understanding of Photoshop.
– Adobe Photoshop CC: Part 1
– Adobe Photoshop CC: Part 2 (this course)
Completion of this course will earn 7.5 CPEs.
Course Objectives:
This course will prepare you to use the most common basic features of Adobe Photoshop.
In this course, you will:
– Use brushes, gradients, and tool presets to create raster images
– Apply vector paths, shape drawing tools, type, and type special effects
– Apply advanced layer techniques with masks, filters, layers, and smart objects
– Apply actions and batch processing to automate tasks
– Edit video by using timelines, transitions, graphics, titles, and animation
– Set project requirements by identifying the purpose, audience, copyright rules, and project management tasks
Target Student:
Target students include professional or amateur photographers who want to use the robust features of Photoshop to enhance, modify, and organize their photographs, and anyone interested in working toward the Visual Communication with Adobe Photoshop exam certification.
Prerequisites:
To ensure your success in this course, you should have experience with the following tasks:
– Identify the basic components of Adobe® Bridge and the Photoshop workspace
– Define image size and resolution
– Add and modify Photoshop layers
– Use tools to select, crop, and move images
– Work with image adjustment properties to correct and retouch photographic images
– Open and modify an image in Adobe® Camera Raw
– Prepare images for print and web
To meet these prerequisites, you can take the Logical Operations course:
– Adobe® Photoshop® CC: Part 1
Outline
- Lesson 1: Creating Raster Images
- Topic A: Draw with Brushes
- Topic B: Create Gradients
- Topic C: Apply Tool Presets
- Lesson 2: Applying Vector Image Tools
- Topic A: Create Images with Vector Paths
- Topic B: Apply the Shape Drawing Tools
- Topic C: Work with Type
- Topic D: Apply Type Special Effects
- Lesson 3: Applying Advanced Layer Techniques
- Topic A: Modify Images with Masks
- Topic B: Apply Special Effects by Using Filters
- Topic C: Apply Special Effects to Layers
- Topic D: Apply Smart Objects for Nondestructive Editing
- Lesson 4: Automating Tasks
- Topic A: Create and Apply Actions
- Topic B: Batch Process Files with Photoshop and Adobe Bridge
- Lesson 5: Editing Video
- Topic A: Edit Video
- Topic B: Add Graphics, Titles, and Animation to Video
- Lesson 6: Setting Project Requirements
- Topic A: Identify Purpose, Audience, and Audience Needs
- Topic B: Adhere to Copyright Rules for Artwork, Graphics, and Graphics Use
- Topic C: Determine and Evaluate Project Management Tasks and Responsibilities
- Appendix A: Mapping Course Content to the Adobe Certified Professional in Visual Design Using Adobe Photoshop Exam
| Microsoft Excel for Office 365/2021-2024: Data Analysis with Power Pivot · View Details | $195.00 | October 29, 2026 — 10:30 AM PDT–1:30 PM PDT | Book Now |
Microsoft Excel for Office 365/2021-2024: Data Analysis with Power Pivot
October 29, 2026 — 10:30 AM PDT–1:30 PM PDT
Microsoft Excel for Office 365/2021-2024: Data Analysis with Power Pivot
We are now living in the age of big data. Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amounts of data quickly. Fortunately, Microsoft® Excel® provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data.
This material will benefit users of any current Office version. The classroom environment setup is based on Excel for Office 365.
Completion of this course will earn 3.4 CPEs.
Course Objectives:
Upon successful completion of this course, you will be able to use Power Pivot along with Excel to analyze data from a variety of sources.
You will:
– Get started with Power Pivot
– Visualize Power Pivot data
– Work with advanced functionality in Power Pivot
Target Student:
Students taking this course are experienced Excel users who are seeking to advance their data-analysis capabilities by using Power Pivot.
Outline
- Lesson 1: Getting Started with Power Pivot
- Topic A: Enable and Navigate Power Pivot
- Topic B: Manage Data Relationships
- Lesson 2: Visualizing Power Pivot Data
- Topic A: Create a Power Pivot Report
- Topic B: Create Calculations in Power Pivot
- Lesson 3: Working with Advanced Functionality in Power Pivot
- Topic A: Create a KPI
- Topic B: Work with Dates and Time in Power Pivot
- Appendix A: Commonly Used DAX Functions
| Using AI Safely at Work · View Details | $195.00 | October 29, 2026 — 10:30 AM PDT–1:30 PM PDT | Book Now |
Using AI Safely at Work
October 29, 2026 — 10:30 AM PDT–1:30 PM PDT
Using AI Safely at Work
AI tools such as ChatGPT, Copilot, and other generative AI platforms are becoming common in the workplace. While these tools can improve efficiency, improper use can create risks related to privacy, data security, accuracy, compliance, and ethics.
This course provides practical guidance on how to use AI safely and responsibly at work, helping participants understand what AI can and cannot do, what information should never be shared, how to evaluate AI-generated content, and how to apply sound professional judgment.
Upon successful completion of this course, you will be able to:
• Understand AI in a workplace context
• Protect confidential and sensitive information
• Identify inaccurate or misleading AI outputs
• Use AI ethically and responsibly
• Apply human oversight and accountability
• Reduce organizational risk while improving productivity
Materials Provided
• Participant reference guide
• Safe AI Use Checklist
• Practical examples and scenarios
Outline
1. AI in the Workplace
- What generative AI is (plain language)
- Common workplace AI tools
- Strengths, limitations, and misconceptions
2. Privacy & Data Protection
- How AI tools handle information
- Public vs. enterprise AI platforms
- What information should never be entered into AI tools
- Practical guidelines for safe prompts
3. Accuracy & AI Limitations
- Why AI can be confidently wrong
- AI hallucinations and bias
- Verification and human-in-the-loop best practices
4. Ethical & Responsible Use
- Appropriate vs. inappropriate use cases
- Transparency and disclosure
- Intellectual property considerations
5. Policies, Compliance & Risk
- Why organizations are implementing AI policies
- Employee responsibility and accountability
- When to pause and seek guidance
6. Best Practices for Safe AI Use
- Do’s and don’ts for workplace AI use
- Red flags and risk indicators
- A simple checklist for responsible AI use
| Delivering Dynamic Virtual Presentations · View Details | $395.00 | October 30, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Delivering Dynamic Virtual Presentations
October 30, 2026 — 6:00 AM PDT–1:30 PM PDT
Delivering Dynamic Virtual Presentations
Managing the virtual workplace isn’t as scary as it sounds. A lot of the basics of management (including communicating with others, managing performance, building teams, and leading meetings) are the same. This course will cover the differences and give you the skills that you need to successfully lead the virtual workplace.
Completion of this course will earn 7.5 CPEs.
Learning Objectives
– Explain the differences between virtual and in-person presentations
– Outline the major challenges (presenter, presentation and technical) with virtual presentations
– Recognize the strengths, weaknesses, and standout features of popular virtual presentation platforms (Zoom, MS Teams, GoToMeeting and Google Meet) and how to set up an account on the platforms.
– Integrate solutions to virtual presentation challenges in your own delivery of virtual presentations
Outline
- Session One: Course Overview
- Learning Objectives
- Pre-Assignment
- Pre-Course Assessment
- Session Two: Why Virtual Presentations and Meetings?
- Working From Home
- Virtual Meeting Experiences
- Types of Presentations
- Session Three: How are Virtual Presentations Different from In-Person?
- Delivering a Presentation Virtually
- Session Four: Virtual Presentation Challenges
- Connecting Virtually
- Remote Meetings — What are People Really Doing?
- Other Challenges and Solutions
- Session Five: Virtual Presentation Essentials — The Presenter
- The Presenter
- Presenter Challenges Activity
- Presenter Challenges
- Etiquette
- Etiquette Reminder Email
- Hospitality
- Considering a Virtual Presentation Team
- Session Six: Virtual Presentation Essentials — The Presentation
- Presentation Tools
- Presentation Challenges
- Using Breakout Rooms for Small Groups
- Engaging All Participants
- What to Do After the Presentation
- Session Seven: Virtual Presentation Essentials — The Technology
- Avoiding Technical Difficulties
- Session Eight: The Tools — Zoom
- Overview
- Key Features
- Setting Up an Account
- Strengths and Weaknesses
- Zoom Standout Features
- Session Nine: The Tools — Microsoft Teams
- Overview
- Key Features
- Setting Up an Account
- Strengths and Weaknesses
- Microsoft Teams Standout Features
- Session Ten: The Tools — GoToMeeting
- Overview
- Key Features
- Setting Up an Account
- Strengths and Weaknesses
- GoToMeeting Standout Features
- Session Eleven: The Tools — Google Meet
- Overview
- Key Features
- Setting Up an Account
- Strengths and Weaknesses
- Google Meet Standout Features
- Session Twelve: Capstone Activity
- Deliver a Virtual Presentation
- Session Thirteen: Personal Action Plan
- Starting Point
- Where I Want to Go
- How I Will Get There
| Microsoft Visio 2019-2024: Part 2 · View Details | $380.00 | October 30, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Microsoft Visio 2019-2024: Part 2
October 30, 2026 — 6:00 AM PDT–1:30 PM PDT
Microsoft Visio 2019-2024: Part 2
Microsoft® Visio® stands out among similar applications because of its unique ability to draw a wide variety of diagrams, flowcharts, workflows, and organization structures—anything that can be represented by shapes connected by lines. Most importantly, these shapes can be rearranged and with corresponding lines remaining intact. Visio has improved over the years as features common among Microsoft® Office applications have been added. Today, Visio is well integrated with other members of the Office family as well as Microsoft’s cloud-based services. This greatly enriches the sharing and publishing of Visio drawings.
In Microsoft® Visio® 2019-2024: Part 1, you learned the basic skills needed to create and modify various Visio drawings. In Microsoft® Visio® 2019-2024: Part 2, you will learn about more advanced features—making you a more efficient and effective Visio user.
This material will benefit users of any current Visio version. The classroom environment setup is based on Visio 2019.
Completion of this course will earn 7.5 CPEs.
Course Objectives: In this course, you will examine advanced features to make you more efficient and effective.
You will:
– Design advanced plans and diagrams
– Enhance the look of drawings
– Create shapes, stencils, and templates
– Connect drawings to external data
– Leverage development tools
– Share drawings
Target Student: The target student for this course is a graphic designer, subject matter specialist, or other knowledge worker with basic Microsoft Visio skills (such as creating basic workflows and other diagrams) who needs to use Visio to create complex graphics and illustrations (such as floor plans, custom maps, and scientific illustrations) that may be linked to external data sources and may be inserted into other Microsoft Office files.
Outline
- Lesson 1: Designing Advanced Plans and Diagrams
- Topic A: Build Advanced Plans
- Topic B: Build Advanced Diagrams
- Lesson 2: Enhancing the Look of Drawings
- Topic A: Use 3-D Shapes
- Topic B: Work with Shape Styles
- Topic C: Define Shape Styles
- Topic D: Apply Backgrounds, Borders, and Titles
- Lesson 3: Creating Custom Shapes, Stencils, and Templates
- Topic A: Create Simple Custom Shapes
- Topic B: Create Custom Stencils
- Topic C: Create Custom Templates
- Lesson 4: Connecting Drawings to External Data
- Topic A: Make an Organization Chart from an Excel Spreadsheet
- Topic B: Generate a PivotDiagram from an Excel Spreadsheet
- Topic C: Create a Gantt Chart from a Project File
- Topic D: Create a Timeline from a Project File
- Topic E: Connect a Map to an Access Database
- Lesson 5: Leveraging Development Tools
- Topic A: Create Macros
- Topic B: Modify ShapeSheets
- Topic C: Build Advanced Shapes
- Lesson 6: Sharing Drawings
- Topic A: Save and Share Drawings with OneDrive
- Topic B: Review Drawings
- Topic C: Insert Drawings into Other Office Files
- Topic D: Export Drawings
- Topic E: Print Drawings
- Appendix A: Using Diagram Standards
| Microsoft SharePoint Modern Experience: Advanced Site Owner · View Details | $450.00 | October 30, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Microsoft SharePoint Modern Experience: Advanced Site Owner
October 30, 2026 — 6:00 AM PDT–1:30 PM PDT
Microsoft SharePoint Modern Experience: Advanced Site Owner
Microsoft® SharePoint®, in conjunction with the Microsoft 365™ productivity and office automation suite, provides tools to create and manage a corporate intranet, facilitate content sharing and collaboration, and enable users to create, access, store, and track documents and data in a central location.
Users who already have experience as SharePoint site members and owners may be ready to move on to more advanced site-building tasks such as using custom site templates, custom themes, applying advanced permissions settings, improving security, and preparing sites to support governance and compliance.
Advanced site builders may be ready to undertake more advanced site management tasks, working in conjunction with their SharePoint Administrator to create and use custom site templates, term sets and metadata, manage information governance and compliance, and get deeper into SharePoint security configuration.
This course focuses on these advanced site-building and administration tasks.
This course is the third part of a three-course series that covers the skills needed to gain a foundational understanding of SharePoint.
– SharePoint Modern Experience: Site Basics
– SharePoint Modern Experience: Site Owner with Power Platform
– SharePoint Modern Experience: Advanced Site Owner (this course)
Completion of this course will earn 7.5 CPEs.
In this course, you will perform advanced site-building and administration tasks.
You will:
– Create a custom site template to reduce the time spent creating similarly configured SharePoint sites
– Configure managed metadata, including custom term sets, content types, and metadata-based navigation
– Control access through permissions
– Improve overall security of sites, lists, libraries, folders, list items, and documents
Target Student:
This course is designed for students who already have experience creating Modern SharePoint sites and populating them with content, who want to learn advanced features to extend SharePoint’s capabilities, make information easier to find and manage, use SharePoint features to improve governance and compliance, and improve the security of information and services within the SharePoint environment.
Prerequisites:
To ensure your success in this course, you should have SharePoint site user skills such as the ability to view and enter data in SharePoint lists and libraries, and to navigate a typical SharePoint site. You should also have intermediate site builder skills such as the ability to create a SharePoint site, apply a site template, populate sites with pages, create lists and libraries, and connect a site to a hub site. You can obtain these skills by taking the following Logical Operations courses:
– Microsoft® SharePoint® Modern Experience: Site Basics
– Microsoft® SharePoint® Modern Experience: Site Owner with Power Platform
Outline
- Lesson 1: Creating Custom Site Templates
- Topic A: Prepare a Site Script
- Topic B: Generate and Use a Custom Site Template
- Lesson 2: Managing Content Services
- Topic A: Plan and Configure Managed Metadata
- Topic B: Create and Manage Content Types
- Topic C: Use Managed Metadata for Navigation and Filtering
- Lesson 3: Controlling Access Through Permissions
- Topic A: Assign Permissions
- Topic B: Manage Permissions Inheritance
- Lesson 4: Improving Security
- Topic A: Manage Access at the Site Level
- Topic B: Manage Access at the Tenant Level
- Appendix A: Cleaning Up Unused SharePoint Resources
| Microsoft Copilot for Microsoft 365 for End Users (with labs) · View Details | $350.00 | October 30, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Microsoft Copilot for Microsoft 365 for End Users (with labs)
October 30, 2026 — 6:00 AM PDT–1:30 PM PDT
Microsoft Copilot for Microsoft 365 for End Users (with labs)
Microsoft Copilot is an AI-powered productivity tool that helps users work more efficiently. It leverages the power of AI to boost productivity, unlock creativity, and helps you understand information better with a simple chat experience.
In this one day practical course we’ll introduce you to the core skills and concepts of using Microsoft Copilot for Microsoft 365.
This course is 15% theory, 25% demo and 60% practical. Delegates will be provided a user account with a Copilot for Microsoft 365 to carry out the practical tasks.
Outline
- An introduction to Generative AI
- The differences between Copilot, Copilot Pro and Copilot for Microsoft 365
- Working with Prompts
- Using Microsoft Copilot with the world wide web
- Using Copilot for Microsoft 365
- Where to access Copilot for Microsoft 365
- Interact with your email, calendar, chats and meetings
- Summarise documents, presentations & meetings
- Analyse and explain documents
- Create content within documents & presentations
- Analyse data in spreadsheets
- Prepare for meetings
- Create new content based on existing files
- Using Copilot Lab to improve your prompting skills
| Microsoft Outlook for Office 365 (Desktop or Online): Part 2 · View Details | $380.00 | October 30, 2026 — 6:00 AM PDT–1:30 PM PDT | Book Now |
Microsoft Outlook for Office 365 (Desktop or Online): Part 2
October 30, 2026 — 6:00 AM PDT–1:30 PM PDT
Microsoft Outlook for Office 365 (Desktop or Online): Part 2
In this course, you will customize command sets, configure mail accounts, set global options, perform advanced searches, apply filters to intercept mail and control spam, create rules to automate mail management tasks, work with calendars and contacts, manage tasks, preserve data with archives and data files, as well as share and delegate access to your Outlook items. In short, you’ll work with a wide range of features and options and, in so doing, understand why Outlook is a leading personal management system.
Note : Most Office 365™ users perform the majority of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will also include helpful notes throughout the material to alert you to cases where the online version of the application may function differently from the primary, desktop version.
This course builds upon the foundational knowledge presented in the Microsoft® Outlook® for Office 365™ (Desktop or Online): Part 1 course and will help you customize a communication system well-suited to your work style.
This course may be a useful component in your preparation for the Microsoft Outlook (Microsoft 365 Apps and Office 2019): Exam MO-400 certification exam.
This course is the second part of a two-course series that covers the skills needed to gain a foundational understanding of Outlook.
– Microsoft Outlook for Office 365 (Desktop or Online): Part 1
– Microsoft Outlook for Office 365 (Desktop or Online): Part 2 (this course)
Completion of this course will earn 7.5 CPEs.
Course Objectives:
In this course, you will use Outlook’s advanced features to customize and manage your email communications, including: using advanced features to organize emails; managing calendar settings and options; managing contact information; scheduling tasks; and managing Outlook archives and data file settings.
You will:
– Insert objects in messages, and modify properties and global options
– Organize, search, and manage messages
– Protect your mailbox and manage its size
– Use rules and Quick Steps to automate message management
– Work with advanced calendar settings
– Import and forward contacts
– Assign delegate permissions and share Outlook items with others
– Archive and back up Outlook items using data files
Target Student:
This course is intended for those with a basic understanding of Microsoft® Outlook® and who need to know how to use its advanced features to manage their email communications, calendar events, contact information, search functions, and other communication tasks.
Prerequisites:
To ensure your success, you should have end-user skills with any current version of Windows, including being able to start and close applications, navigate basic file structures, manage files and folders, and access websites using a web browser. Additionally, it will benefit you to have basic Outlook skills.
Outline
- Lesson 1: Modifying Message Properties and Customizing Outlook
- Topic A: Insert Hyperlinks and Symbols
- Topic B: Modify Message Properties
- Topic C: Add Email Accounts to Outlook
- Topic D: Customize Outlook Options
- Lesson 2: Organizing, Searching, and Managing Messages
- Topic A: Group and Sort Messages
- Topic B: Filter and Manage Messages
- Topic C: Search Outlook Items
- Lesson 3: Managing Your Mailbox
- Topic A: Manage Junk Email Options
- Topic B: Manage Your Mailbox Size
- Lesson 4: Automating Message Management
- Topic A: Use Automatic Replies
- Topic B: Use Rules to Organize Messages
- Topic C: Create and Use Quick Steps
- Lesson 5: Working with Calendar Settings
- Topic A: Set Advanced Calendar Options
- Topic B: Create and Manage Additional Calendars
- Topic C: Manage Meeting Responses
- Lesson 6: Managing Contacts
- Topic A: Import and Export Contacts
- Topic B: Use Electronic Business Cards
- Topic C: Forward Contacts
- Lesson 7: Sharing Outlook Items
- Topic A: Assign and Manage Tasks
- Topic B: Share Your Calendar
- Topic C: Share Your Contacts
- Lesson 8: Managing Outlook Data Files
- Topic A: Use Archiving to Manage Mailbox Size
- Topic B: Work with Outlook Data Files
- Appendix A: Mapping Course Content to Outlook Associate (Office 365 and Office 2019): Exam MO-400
- Appendix B: Selected Advanced Topics
- Appendix C: Microsoft® Outlook® Common Keyboard Shortcuts