Class Schedule

Click on a class below to begin the enrollment process:

Adobe Acrobat DC Pro Training: Essential Skills
Build Productive Work Habits (LIVE Remote)

Changing a work habit can be challenging. It takes self-exploration, practice, and motivation to stay on track. This workshop dives into an easy-to-adopt process of habit formation through a work-focused lens. Participants will revitalize their work routines by exploring the behaviors they want to change and the triggers behind making and breaking habits. Through interactive and self-reflection-driven training, participants will learn how to easily create and stick to healthy work habits by using scientifically proven steps of behavior change and habit formation.

 

Course Outline

What is a habit? 

  • Habit versus behavior 
  • Habit Identity 

The Process of habit formation 

  • Identify the habit 
  • Investigate the habit 
  • Stage of change
  • Transtheoretical model of behavior change 
  • Motivational Interviewing 
  • PBO plan – Prompt Behavior Outcome 
  • Take action

 

Outcomes

  • Discover the science behind behavior change and the psychological process that occurs when we go through or stop a behavior change.
  • Learn about and reflect on obstacles that get in the way of changing behavior and the solutions to excel in your role.
  • Experience motivational interviewing by participating in a guided self-reflection activity to discover your motivations for change.
  • Create a plan to make new habits and break the old ones!
Build Trust with Others
Communicate Across Cultures (LIVE Remote)

Communicating Across Borders will help you better communicate, collaborate, and work together within a multicultural organization. One of the keys to doing this effectively is to recognize and understand the differences between cultures, including how different cultures build trust, ways they communicate, and how they lead and make decisions. Once familiar with these differences, we look at ways to adapt our approach to create strong, effective, and lasting, working relationships. 

Outcomes 

  • Apply a 3-step model to better communicate and collaborate across borders 
  • Recognize and understand the different ways cultures communicate and collaborate 
  • Look at characteristics from multiple viewpoints to further understand the people we work with 
  • Learn how to navigate and appreciate our cultural differences to improve our ability to communicate and collaborate 
  • Appreciate and embrace our cultural diversity to bring a collective strength

Course Outline

  • A model to help communicate and collaborate across borders
  • Characteristics that can help distinguish between cultures
  • The importance of looking at characteristics from multiple viewpoints
  • How to navigate and appreciate our cultural differences and commonalities
  • Learning how to adapt to the tendencies and preferences of others
Communicate with Confidence (LIVE Remote)

Learn to effectively communicate information and ideas in a professional setting, with or without preparation. Not every opportunity to speak is a presentation. What about meetings, water cooler conversations, interviews? There are a host of situations where your ability to verbally present information or ideas in a clear, compelling and concise manner will be called upon. This class is designed to help you handle those situations professionally and skillfully. 

Outcomes

  • Learn a 3-step process for planning your communications
  • Learn to craft messages that are clear and simple
  • Improve confidence while communicating
  • Learn to eliminate the noise that can derail communication

Course Outline

  • Plan your communications in advance using Aim-Compose-Deliver
  • Practice composing messages that are easily and fully grasped
  • PREP framework for composing clear, concise messages on the fly
  • Which channel when guidelines
  • Deliver your message with confidence
Create Belonging at Work

Belonging is the fundamental human need to be accepted and included by those around you, both personally and professionally*

Did you know that a staggering 40% of individuals experience isolation in their workplace? This widespread issue not only hampers organizational commitment and engagement but can also have a detrimental impact on profitability. Seize this opportunity to engage in a dynamic work session, equipping yourself with practical strategies to foster authentic connections, bridge gaps in diverse workplace cultures, and cultivate an authentic sense of belonging for all. Elevate your organization and your leadership with the power of belonging.

*The Value of Belonging at Work (hbr.org)

What We’ll Explore:

  • The Hidden Need for Belonging: Uncover the profound human need for belonging and the significance it plays in the workplace.
  • Exclusion’s Impact and Solutions: Recognize the pain of exclusion, how it hampers teams, and how it can be mitigated.
  • The Role of Allies and Interventions: Explore the importance of allies and practical solutions for fostering workplace belonging.
  • Creating a Culture of Belonging: Discover clear, actionable paths to foster belonging in your workplace.

Course Outline

  • Unearth the profound human need for belonging
  • Engage in real-life stories of the impact of workplace isolation
  • Recognize the high cost of exclusion
  • Learn practical, evidence-based solutions
  • Discover the vital role of allies in fostering belonging
  • Create clear steps to shape a culture of belonging in your organization
  • Understand the financial benefits of fostering belonging
Cultivate a Growth Mindset (LIVE Remote)

Fascinating research reveals that having a growth mindset is the most highly correlated factor in success—higher than intelligence, education, and talent. In this workshop, we investigate the fascinating research around a growth mindset and learn proven methods of acquiring one.

Outcomes:

  • The ability to keep going when things get tough
  • The ability to bring a growth mindset to those around you

Course Outline

  • Recognize how a growth mindset is tied to success and how a fixed mindset holds us back
  • Concrete insights you can use to adjust your mindset when you meet challenges
  • Leverage the science of neuroplasticity—brain development—to change the way you think
  • Learn how to nurture a growth mindset and how to bring it to others
Deal with Conflict (LIVE Remote)

Learn to recognize when a situation has turned from a simple disagreement into a conflict by understanding the root cause of conflict and the role threat-response plays. Temper your own reactions in a heated moment with a conflict analysis framework. Work toward positive-sum outcomes with a 4-step process for managing your responses and offers.

Outcomes 

  • Understand the root causes of conflict
  • Ask questions to analyze the conflict
  • Follow a four-step process to respond to conflict

Course Outline

  • What is conflict?
  • Perceived threats
  • Using conflict analysis to choose your behavior
  • The 4 steps to responding to conflict
  • How to reformulate your position
  • Compromise or collaborate
  • Own your actions
Design a Vision for Your Team (LIVE Remote)

A vision helps employees personally attach themselves to their role and purpose in the organization. Creating a vision your team can understand and relate to leads to better employee retention, performance, and productivity. This course walks through creative thinking processes to help you create a vision that inspires your team.

Outcomes:

  • Understand what a vision is and who it’s for
  • Use creative thinking techniques to draft a vision
  • Consider how to apply the vision for specific direct reports
Docs & Publication Tools (LIVE Remote)

Google Docs 1 Overview

The Google Docs word-processing software allows writers to create documents and collaborate
with others with more ease than ever. This course is designed to provide relevant and practical
information on the basic functionality of Google Docs. Some of the topics and skills covered
include opening and navigating within a Google Doc, formatting text, adding tables and inserting
objects, managing lists, and customizing a document’s appearance. The objectives covered in
this course will prepare users to comfortably navigate Google Docs for educational,
professional, and personal uses.

Audience


This course is designed for those who want to learn the basic functionality and navigation of
Google Docs. This includes skills such as creating, editing, and formatting documents. In
addition, inserting simple tables, creating lists, and improving the appearance and accuracy of
the document context will be covered.


Prerequisites


To be successful in this course, you should bring your pre-existing, basic computer skills, such
as: controlling the mouse/trackpad, typing text, and opening/navigating a web browser. No prior
knowledge of Google Docs is necessary.


Objectives

Upon completion of this course, you will have the foundational skills to accurately navigate
Google Docs for your educational, professional, and personal needs.
You will:

  • Open, navigate, and perform basic commands in Google Docs, including saving, revising, printing and uploading documents.
  • Format characters, text and paragraphs.
  • Execute repetitive commands efficiently.
  • Manage and format lists.
  • Add, modify and format tables.
  • Insert and modify graphic objects, including special characters, symbols and images.
  • Modify the appearance of the document by applying borders, colors, headers, footers, page layouts and watermarks.
  • Prepare a document for publishing using Google Doc features to identify and correct spelling errors, translate text and save a document as a different file format. 

Lesson 1: Getting Started with Google Docs
Topic A: Navigate in Google Docs
Topic B: Create and Save Google Docs
Topic C: Manage Your Workspace
Topic D: Edit Documents
Topic E: Preview and Print Documents
Topic F: Upload Existing Documents

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: Paragraph Styles

Lesson 4: Managing Lists
Topic A: Format a List
Topic B: Custom Bullets and Numbers

Lesson 5: Adding Tables
Topic A: Adding a Table
Topic B: Modify a Table
Topic C: Format 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 and Word Count
Topic B: Use Research Tools
Topic C: Check Accessibility
Topic D: Save a Document to Other Formats

Empower Customer Service for External Clients (LIVE Remote)

Maintaining strong client relationships can be challenging when what a client requests is beyond the scope of what you are able to offer. Working through those situations requires solid skills in meeting your client where they are and bringing them into alignment with how you can reasonably serve their needs and still deliver a high-quality experience. The skills in this course can help you proactively uncover your client’s deeper needs and work toward favorable solutions for you both.

Outcomes:

  • Use curiosity and attunement to identify with the client
  • Validate their situation and recommend solutions based on your experience
  • Make your ask again with structured persuasion
Excel Intermediate – Standard – Full Day
Explore AI Essentials (Live Remote)
GMail & Communication Tools (LIVE Remote)

Gmail Training

Email is one of the most widely used methods of communication, for personal or business communication. No matter the size, most organizations prefer communicating via email among the organization’s employees. As email is becoming a need for many organizations, they are implementing a managing system for their email needs. Gmail is one management system that many organizations use to manage their needs such as email, calendars, contacts, and much more.

In this course, you will use Gmail to send, receive, and manage email messages. manage email messages. You will also manage your contact information, schedule appointments, create tasks, and take notes. This course will provide you with the basic skills you need to start using Gmail.

Audience

This course is intended for people who have a basic understanding and need to know how to use Gmail for email communication. In this course, you will learn how to create and send emails. You will also learn how to organize your mail, work with attachments, and format message text.

Prerequisites

To ensure your success in this course you should have a basic understanding of how to use a computer. This includes being able to start and close applications, navigate basic file structures, and manage files and folders.

Objectives

You will use Gmail to manage your email communications, including composing, reading, and responding to emails.

By the end of this course you will:

  • Read and respond to email by navigating Gmail.
  • Create a new message by using Contacts, format an email, and spell-check.
  • Create an email with attachments.
  • Customize read and response options.
  • Organize messages by using tools like labels.
  • Create and work with Contacts.
  • Use Calendar to create and schedule events.
  • Use Google Keep and Tasks to create and work with lists and notes.

Lesson 1: Getting Started with Gmail 
Topic A: Navigate the Gmail Interface 
Topic B: Work With Messages 
Topic C: Access Gmail Help 

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 
Topic A: Attach Files and Items 
Topic B: Manage Automatic Message Content 

Lesson 4: Customizing Message Options 
Topic A: Customize Reading Options 
Topic B: Track Messages 
Topic C: Recall Messages 

Lesson 5: Organizing Messages 
Topic A: Mark Messages 
Topic B: Organize Messages Using Labels 

Lesson 6: Managing Your Contacts 
Topic A: Create and Edit Contacts 
Topic B: Organize Contacts 
Topic C: Print Contacts 

Lesson 7: Working with the Calendar 
Topic A: View the Calendar 
Topic B: Create An Event
Topic C: Schedule Meetings 
Topic D: Managing Calendars 
Topic E: Print the Calendar 

Lesson 8: Working with Tasks 
Topic A: Open Tasks 
Topic B: Create Lists 
Topic C: Create a Task 
Topic D: Organize and Update Tasks 
Topic E: Complete a Task 

Lesson 9: Working with Notes 
Topic A: Create Notes 
Topic B: Modify Notes 
Topic C: Organize and Find Notes 
Topic D: Set Reminders 
Topic E: Share Notes 
Topic F: Archive and Delete Notes 
Topic G: Customizing Google Keep 

Google Sheets 1 (LIVE Remote)

Google Sheets 1 Training

Google Sheets is a web-based spreadsheet application that allows you to store and organize different types of information, much like Microsoft Excel. While Google Sheets does not offer all of Excel's advanced features, it's easy to create and edit spreadsheets ranging from the simple to the complex. While you might think spreadsheets are only used by certain people to process complicated numbers and data, they can actually be used for a variety of everyday tasks. Whether you're starting a budget, planning an event, creating an invoice, or just about anything else you can think of, spreadsheets are a great way to organize information.

Audience

This course is intended for students who wish to gain the foundational understanding of Google Sheets that is necessary to create and work with online spreadsheets.

Prerequisites

To ensure success, students will need to be familiar with using computers and should have experience using a keyboard and mouse. Students should also have an active G Suite (Google) account.

Objectives

Upon successful completion of this course, you will be able to create and develop Google Sheets spreadsheets to work with and analyze data.

You will:

● Get started with Google Sheets.

● Perform calculations.

● Modify a spreadsheet.

● Format a spreadsheet.

● Print spreadsheets.

● Manage a workbook. 

Lesson 1: Getting Started with Google Sheets

Topic A: Navigate the Google Sheets User Interface

Topic B​: ​Use Google Sheets Commands 

Topic C​: ​Create, Save, and Download a Basic Spreadsheet 

Topic D​: ​Spreadsheet Settings 

Topic E​: ​Enter Cell Data 

Topic F​: ​Use Google Sheets’ Help 

Lesson 2: Performing Calculations 

Topic A​: ​Create Worksheet Formulas 

Topic B​: ​Insert Functions 

Topic C​: ​Reuse Formulas and Functions 

Lesson 3: Modifying a Spreadsheet 

Topic A​: ​Insert, Delete, and Adjust Cells, Columns and Rows 

Topic B​: ​Search for and Replace Data 

Topic C​: ​Use Proofing Tools 

Lesson 4: Formatting a Worksheet 

Topic A​: ​Apply Text Formats 

Topic B​: ​Apply Number Formats 

Topic C​: ​Align Cell Contents 

Topic D​: ​Apply Styles 

Topic E​: ​Adding Borders and Colors 

Topic F​: ​Apply Basic Conditional Formatting 

Topic G​: ​Create and Use Templates 

Lesson 5: Printing Spreadsheets 

Topic A​: ​Preview and Print a Spreadsheet 

Topic B​: ​Set Up the Page Layout 

Lesson 6: Managing Workbooks 

Topic A​: ​Manage Sheets 

Topic B​: ​Manage Workbook and Sheet Views 

Topic C​: ​Manage Workbook Properties 

Google Sheets 2 (LIVE Remote)

Google Sheets 2 Training

If you need to crunch numbers for sales, information, inventory, or other organizational purposes, the ability to obtain the right data from the right people at the right time can be a great competitive skill to have. Since our world, especially the business world, depends on accurate data, being able to produce the data becomes a competitive skill. Equally important is being able to analyze and make sense of the information.

This course builds upon the skills and knowledge presented in Google Sheets Part 1A and Part 1B courses. This course will help you start your path to creating advanced workbooks and spreadsheets that can help you deepen your understanding of using Google Sheets and the data collected or organized in them.

Audience

This course is intended for students who already have foundational understanding and skills of Google Sheets and who wish to use Google Sheets in a higher-level functionality to analyze and present data.

Prerequisites

To ensure success, students should have completed Google Sheets Part 1A and Part 1B or have the equivalent knowledge and experience.

Objectives

Upon successful completion of this course,

You will:

  • Work with functions.
  • Work with lists.
  • Analyze data.
  • Visualize data with charts.
  • Use Pivot Charts.

Lesson 1: Working With Functions

Topic A: Working With Ranges

Topic B: Use Specialized Functions

Topic C: Work With Logical Functions

Topic D: Work With Date & 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

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 Pivot Tables And Pivot Charts

Topic A: Create a Pivot Table

Topic B: Analyze Pivot Table Data

Topic C: Present Data With Pivot Tables

Google Sites (LIVE Remote)
Hear What Teams Can't Say
Influence Without Authority (LIVE Remote)

Perhaps no topic has garnered more curiosity in recent years than how to build influence in an organization. Master influencers move beyond their position on the org chart and collaborate across departmental lines to get things done. Influence Without Authority explores this topic by examining styles, behaviors and techniques that will help you grow your influence and deepen your relationships.

Outcomes

  • Reframe beliefs about authority to empower people to use influence
  • Gain trust and closeness necessary to become influential
  • Apply principles of social psychology to communicate persuasively
  • Avoid pitfalls that harm influence and erode trust

Course Outline

Module 1: Increase Influence through Trust

Power and Influence

  • Definitions
  • Who to Influence?
  • Proximity Principle

How Trust Affects Influence

  • How Trust Affects Influence, Statistics
  • Building "Trust Bank Account"
  • Trust Currencies

Module 2: Influential Communication

Reciprocity

  • Understanding Reciprocity
  • Building "Reciprocity Bank Account"
  • Avoiding Negative Reciprocity
  • Say “No” Professionally

Persuasive Communication Tools

  • Influencing Timeliness
  • Power of “Because”
  • Psychology of Asking Again
  • Structure for Persuasion in 4 Easy Steps
  • Language that Harms Influence
Lead AI Adoption for Your Team
Lead Inclusive Teams (LIVE Remote)

Inclusive Leadership: A Hands-on Approach to Empowering Diversity and Belonging at Work engages participants in cutting-edge theory and practices of leading groups of heterogenous people at work – people who are diverse in character or content – all while respecting their uniqueness in an empathetic, bias-free way.

Participants will leave this learning session with new practical approaches to expand their capacity to lead themselves and others with an authentic experience of inclusion and belonging for all.

Outcomes:

  • You will discover how inclusive you are in your current role.
  • You will discover the warning-signs and unintended consequences of failing to create and foster environments of belonging and inclusion in your organization.
  • You will learn immediate actions you can take that will leave people with an authentic experience of being included.

Course Outline

Getting Connected Exercise

Inclusion as a Mindset

  • The Impact of Exclusion
  • The Practice of Inclusion
  • Pop-quiz: How Inclusive Are You?

Actions to Stop, Start & Continue

  • 7 Acts of Inclusive Leadership
  • Applying this to Your Team
Lead with Merit and Excellence
Lead with Trust
Lead Your Team Through Change (LIVE Remote)

In this workshop, you will increase your confidence and adaptability by learning the principles behind the change cycle and behavioral change readiness.

Outcomes:

  • Develop a better understanding of the psychology of change
  • Better Methodologies for announcing change
  • The ability to lead through the cycle of change
  • Techniques to get people moving

Course Outline

Module 1: Understanding and Working with Change

The Challenge of Change

  • Why Do People Resist Change?
  • Avoid Mistakes When Announcing Change
  • Announcing Normal, Everyday Change
  • Change: Guiding Principles
  • The Mindset of Change
  • Choose to See Change as a Choice

The Cycle of Change

  • The Change Cycle
  • The Change Cycle: What Not to Do
  • The Change Cycle: What to Do

Module 2: Working with Sensitive Change and Getting Momentum

Preparing to Communicate Change

  • Difficult Change Requires Something Positive
  • Pre-Work for Communicating Major or Sensitive Change
  • Communicate Sensitive Change: A Script

Building Momentum Around Change

  • Working with Resistance: Late Adopters and Diehards
  • Influence Late Adopters
  • Die Hard: Corrective Conversation
Learn AI to Boost Your Productivity
Make High-Quality Decisions (LIVE Remote)

This course is designed around a handful of common decision-making challenges leaders face, such as personnel and strategy. It provides tangible frameworks beyond the usual sort and sift, pros and cons, or just follow your gut. How to choose between a variety of uncertain or ambiguous outcomes is the question this course will help you navigate.

Make Listening Your Superpower (LIVE Remote)

Learn to be a better listener with a clear, actionable process to really hear what others have to say and give others the experience of feeling heard. You will gain an understanding of the current state of your listening skills and clarity on where to improve. The class is very interactive with lots of practice opportunities and designed to help you immediately improve.

Outcomes

  • Hone your ability to deeply listen with our 3-step active listening model 
  • Learn a surefire way to listen every time 
  • Reliably give others the experience of feeling heard

Course Outline

Active Listening

  • Self-assessment 
  • Why listening is hard 
  • 3-step model to be a great, active listener 
  • In-session practice

Reflective Listening

  • The one thing you can do to make sure you always listen
  • What is reflective Listening
  • Paraphrasing
  • Clarifying and diagnostic questions
  • Giving others the experience of feeling heard
Manage Projects with Confidence (LIVE Remote)

Whether you are starting a new project or currently executing an existing project, this course will help participants better understand essential information and best practices that will improve project performance. This course helps project teams align on terminology, roles & responsibilities, and provides techniques for breaking project deliverables into manageable tasks.

Outcomes 

  • Understand project management terminology
  • Know how to align stakeholders to key project management roles
  • Outline project objectives, deliverables, requirements, and success metrics
  • Understand how to align on project changes using the Project Management Triangle 
  • Develop a project task list to ensure ownership in creating deliverables

Course Outline

  • Project and Project Management Defined 
  • Project roles defined: Project Sponsor, Project Manager, Project Requestor, Project Team, Stakeholders, Subject Matter Experts 
  • An introduction to Agile, Waterfall, and Hybrid Project Management Methodologies
  • Project Management Triangle: Scope, Time, Cost 
  • The Five Project Phases 
  • Project Objectives, Deliverables, and Requirements 
  • Task Management and Creating a Task List
Manage Up (LIVE Remote)

Managing up creates a healthy, productive relationship with your manager and moves your development forward. Relationships can be particularly challenging in the hybrid workplace where your interactions with managers may be more limited. Intentionally managing up using key practices makes both your job and your manager’s job easier and more collaborative, whenever and wherever you may be working.

Outcomes:

  • Understanding what managing up is and how it works
  • Communicating with your manager using best practices
  • Collaborative problem solving for accountability and consensus
  • Developing plans to document and share continuous feedback

 

 

Manage Your Stress (LIVE Remote)

Stress is a normal part of every day. We may think of it as only bad or distress, but we also experience eustress, a positive type of stress. This interactive workshop investigates the causes of stress at work and teaches how to differentiate between distress and eustress. Participants will first master stress management strategies by creating an action plan that mitigates or regulates their stress triggers. Participants will then learn how to optimize eustress to use it to their advantage. 

Outcomes

  • Understand the cause and experience of stress.
  • Differentiate between eustress and distress.
  • Follow an action plan to manage stress by using E.A.S.E., Learnit’s 4-step method for regulating and mitigating stress triggers.

Course Outline

What is stress?

  • Good stress, bad stress, eustress, distress
  • The stress experience

Workplace stress management

  • E.A.S.E
  • Promoting eustress
Manage Your Teams Performance (LIVE Remote)

This workshop explores some of the more challenging situations managers face in performance management. These challenges include how to deal with an employee who is underperforming, how to handle conflict between members of your team, and how to hire and fire someone on your team. These topics aren’t always fun or easy, but we are confident that preparing for these situations will help develop a holistic approach to managing teams for performance and development.

 
Microsoft Excel 1 (LIVE Remote)

Excel Level 1 Overview

Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, this is where the power of Microsoft® Office Excel® 2016 can help. 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.

 

Audience

This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel 2016 that is necessary to create and work with electronic spreadsheets.

 

Prerequisites

To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows® 10 environment and be able to use Windows 10 to manage information on their computers. Specific tasks the students should be able to perform include: opening and closing applications, navigating basic file structures, and managing files and folders.

 

Objectives

Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization.

You will:

  • Get started with Microsoft Office Excel 2016.
  • Perform calculations.
  • Modify a worksheet.
  • Format a worksheet.
  • Print workbooks.
  • Manage workbooks.

Lesson 1: Getting Started with Microsoft Office Excel 2016

Topic A: Navigate the Excel User Interface

Topic B: Use Excel Commands

Topic C: Create and Save a Basic Workbook

Topic D: Enter Cell Data

Topic E: Use Excel Help

 

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: Insert, Delete, and 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 Styles and Themes

Topic E: Apply Basic Conditional Formatting

Topic F: Create and Use Templates

 

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

Microsoft Excel 1A (LIVE Remote)

Excel 1A

Introduction to Spreadsheets and Basic Formulas

Prerequisites:

To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows® 10 environment and be able to use Windows 10 to manage information on their computers. Specific tasks the students should be able to perform include: opening and closing applications, navigating basic file structures, and managing files and folders

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
  • Topic F: Use Excel Help

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: Insert, Delete, and Adjust Cells, Columns, and Rows
  • Topic B: Search for and Replace Data
  • Topic C: Use Proofing and Research Tools
Microsoft Excel 1B (LIVE Remote)

Excel 1B

Introduction to Spreadsheet Appearance and Organization

Prerequisites:

To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows® 10 environment and be able to use Windows 10 to manage information on their computers. Specific tasks the students should be able to perform include: opening and closing applications, navigating basic file structures, and managing files and folders

Lesson 1: 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
  • Topic F: Create and Use Templates
  • Topic A: Preview and Print a Workbook
  • Topic B: Set Up the Page Layout
  • Topic C: Configure Headers and Footers
  • Topic A: Manage Worksheets
  • Topic B: Manage Workbook and Worksheet Views
  • Topic C: Manage Workbook Properties

Lesson 2: Printing Workbooks

Lesson 3: Managing Workbooks

Microsoft Excel 2 (LIVE Remote)

Excel Level 2 Overview

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 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® Office Excel® 2016: 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.

 

Audience

This course is designed for students who already have foundational knowledge and skills in Excel 2016 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® Office Excel® 2016: Part 1 or have the equivalent knowledge and experience.

 

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.

Lesson 1: Working with Functions

Topic A: Work with Ranges

Topic B: Use Specialized Functions

Topic C: Work with Logical Functions

Topic D: Work with Date & Time Functions

Topic E: Work 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

Microsoft Excel Data Analysis with PivotTables (LIVE Remote)

Overview:

Advances in technology have made it possible to store ever-increasing amounts of data. Along with this, the need to analyze that data and gain actionable insight is greater than ever. You already have experience working with 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.

 

Course Objectives:

 

  • Prepare data for PivotTable reporting and create PivotTables from various data sources.
  • Analyze data by using PivotTables.
  • Work with PivotCharts.

Lesson 1: Preparing Data and Creating PivotTables

Topic A: Prepare Data

Topic B: Create a PivotTable from a Local Data Source

Topic C: Create a PivotTable from Multiple Local Data Sources

Topic D: Create a PivotTable from an External Data Source

 

Lesson 2: Analyzing Data by Using PivotTables

Topic A: Summarize PivotTable Data

Topic B: Organize PivotTable Data

Topic C: Filter PivotTable Data

Topic D: Format a PivotTable

Topic E: Refresh and Change PivotTable Data

 

Lesson 3: Working with PivotCharts

Topic A: Create a PivotChart

Topic B: Manipulate PivotChart Data

Topic C: Format a PivotChart

Microsoft Word 3 (LIVE Remote)

Word Level 3 Overview

Microsoft® Word 2016 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.

 

Audience

This course is intended for students who want to use advanced capabilities in Word, including image manipulation, collaboration and revision tracking, cross-referencing and linking, document security, forms, and process automation through macros.

 

Prerequisites

To ensure success, you should be comfortable in the Windows® 10 environment, and be able to use Windows 10 to manage information on your computer. Specific tasks you should be able to perform include opening and closing applications, navigating basic file structures, and managing files and folders.

 

Objectives

In this course, 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.

Lesson 1: Manipulating Images

Topic A: Integrate Pictures and Text

Topic B: Adjust Image Appearance

Topic C: Insert Other Media Elements

 

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: Prepare a Document for Collaboration

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: Microsoft Office Word 2016 Exam 77-725

 

Appendix B: Microsoft Office Word 2016 Expert Exam 77-726

 

Appendix C: Microsoft Word 2016 Common Keyboard Shortcuts

Own Your Time (LIVE Remote)

Learn to prioritize projects among the changing and competing demands on your time. You will also gain an understanding of how your current workplace requires you to constantly retool to work strategically instead of working harder. This course will help you to focus on key practices for managing your time effectively. You will learn practical tools that can help you to better align your daily activities to accomplish your goals.

Outcomes

  • What gets in our way?
  • Finding our flow
  • Ways to shut down distractions
  • How to navigate shifting priorities

Course Outline

  • What gets in our way? 
    • Multitasking is a myth 
    • Flow State 
  • Controlling your distractions 
    • Pomodoro technique
    • How to say “no” professionally
  • How to navigate shifting priorities
    • Reactive vs Proactive Time
    • Distinguishing urgent vs important
    • 2-minute rule 
Set Goals for Your Team
Solve Problems Creatively (LIVE Remote)

This workshop is a structured approach to out-of-the-box thinking. You’ll learn real-world tools and techniques you can use alone and with your teams to help solve complicated problems when a solution is not readily apparent.

Outcomes:

  • Better and more innovative decisions
  • The ability to solve problems that felt like “stumpers”
  • More fun and job satisfaction

Course Outline

  • Why we become less creative as we get older
  • Real-World practices we can put in place to bring creativity back
  • A step-by-step method to solve problems creatively
  • How to rationally evaluate creative ideas
Streamline Your Business Processes (LIVE Remote)

In this data-driven process improvement workshop, we focus on how to get better business results by understanding root causes of process challenges and directly addressing them using problem solving techniques. Teams are constantly asked to deliver more results with less resources, therefore we will help you shift your mindset and look for ways to work more efficiently and effectively.

Objectives

  • Understand the DMAIC model and how to apply this problem-solving approach when improving processes
  • Develop a Project Charter to clarify scope in the Define phase of process improvement
  • Identify how and when to appropriately use root cause analysis (RCA) tools
  • Learn techniques to successfully execute process improvement working sessions

 

Course Outline

  • Process improvement defined
  • Reasons for evaluating and improving processes
  • An introduction to the DMAIC process improvement model: Define, Measure, Analyze, Improve, Control
  • How to create a Project Charter to support the process improvement efforts
  • Root cause analysis (RCA) tools that can be used to support the current process state: fishbone diagram, affinity diagram, pareto chart, flowchart
  • Getting the team aligned on process improvements
Supercharge Collaboration with Team Styles (LIVE Remote)

This is a practice-oriented workshop designed to help learners navigate the 4 most common communication styles in the workplace. It teaches learners to find value, build rapport, and create communication harmony with those they might find difficult to understand.

Outcomes 

  • Learn and navigate the 4 main communication styles
  • Identify natural accommodation patterns and transcend them 
  • Reduce the friction and frustration that happens when differing communication styles interact 
  • Learn a 5-step process for navigating between any combination of communication styles

Course Outline

  1. Intro to the 4 Styles 
    • Self-assessment 
    • All 4 styles in detail, with examples 
    • Practice: learn to speak and listen with an opposite style 
  2. Application of learning 
    • Avoiding mimicry 
    • Active listening to gain understanding 
    • 5 Steps to Communication Hygiene 
    • Role-play: Apply the 5 Steps of Communication Hygiene
Think Critically (LIVE Remote)

Critical Thinking is the skill and practice of examining our thoughts in order to expose the flaws and biases inherent in our thinking.

Outcomes:

  • Develop attributes and use inquiry to activate personal critical thinking
  • Expose our thinking process and improve its quality to lead to better decisions
  • Learn different proven models to analyze ideas methodically from multiple perspectives
  • Spark creative thinking and idea generation

Course Outline

The Mindset and Tools of Critical Thinking

  • How critical thinking helps your thinking get better
  • How to quickly check your thinking in real-world situations
  • How to develop a mindset so you’ll think critically when it matters
  • How emotions block thinking and what you can do about it

Outcomes

  • The ability to quickly question your thinking when it matters
  • The ability to get intelligent thought going, even when emotions are high

Problem Solving – Make Thoughtful Decisions

  • Understanding how we build our worldview and how to check it for biases
  • Cognitive biases. How your brain fools you into believing something that isn’t true.
  • Critical thinking methodology for problem solving
  • Fighting the “First Solution” bias

Outcomes

  • Understanding of how we jump to conclusions and what to do about it
  • The ability to make fast, clear, and thoughtful decisions
Think Strategically (LIVE Remote)

You've heard the term strategic thinking and you're aware of your company's strategy, but what does strategic thinking mean for you? Being a strategic thinker can set you apart and allows you to see the big picture. This course will teach you what it means to be a strategic thinker and gives you powerful strategic thinking tools to apply to the situations you commonly find yourself in at work.

 
Transcend Bias (LIVE Remote)

Unconscious Bias Training: an innovative approach to inclusion is designed to provide participants with a hands-on experience of Nobel Prize-winning author Daniel Kahneman’s research on fast and slow thinking when dealing with complex social issues at work. Our innovative approach empowers people to act and lead in uncomfortable situations with expanded levels of confidence and empathy.

Participants will leave this learning session with practical approaches to identify hidden biases, notice the impact of unconscious bias on others and expand their capability to disrupt behaviors and actions that exclude vs. include others.

Outcomes:

  1. You will discover how your thinking and decision-making are often automatic tasks / unconscious biases.
  2. You will experience how you biases unwittingly impact the actions/conversations that occur in your organization.
  3. You will discover immediate actions you can take that will leave people with an authentic experience of being included.

Course Outline

  • Getting Connected Exercise
  • Unconscious Bias: What It Is, How It Works and How to Disrupt It (in real-time)
  • The neuroscience behind Unconscious Bias
  • Thinking Slow vs. Fast
  • The Practice of Cultural Humility
  • Moving into Action (application of this training back at work)
    • Practicing the 5 Steps for Disrupting Unconscious Bias
    • Calling-In vs. Calling-Out
    • Creating your own Action Plan
    • Recommended Reading & Video Clips
Trello (Live Remote)
Use AI to Upgrade Your Writing
Write with Impact (LIVE Remote)

The ability to write simply and specifically is a powerful skill that will improve your effectiveness no matter the reason you’re writing. In this workshop participants will explore the rules of excellent business writing and learn how to incorporate these rules into their daily communication. Participants will discover how to write for the reader in order to maximize the readability of their writing while also learning to error-proof their writing to avoid judgment.

Outcomes:

  • The challenges of digital communication and business writing
  • Learnit’s WRITE model for clear and effective business writing
  • Tips to improve your email efficiency and etiquette 

Course Outline:

  • Writing for your audience
  • Exploring your reason for writing 
  • How to write effectively and empathetically
  • Checking the tone 
  • Proofreading and editing

Secure Site

Secure Site

Please be assured that your information is protected and secure. We value your privacy and do not provide customer information to any third parties.

Contact Us

Training To You
 2200 North Central Avenue
Suite 400
Phoenix, AZ 85004

phone (602)266-1500