Class Schedule

Click on a class below to begin the enrollment process:

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!

Coaching is a future-focused question-centric process leaders use to support growth and hold people accountable. Coaching revolves around listening, asking questions, and leading people to solve their own problems. This course focuses on situational coaching in which managers and leaders informally incorporate coaching throughout a typical workday.

 

 

Outcomes

  • Understand the benefits of promoting a coaching culture within your organization and team
  • Develop the pre-requisites for a coaching mindset
  • Apply a series of suggested questions to any coaching situation
  • Learn how to support your employee the best by knowing when to ask and when to tell

Course Outline

  • Managing vs Coaching
  • 4 styles of coaching
  • Pre-requisites for a coaching mindset
  • OARS
  • Situational Coaching Model: A series of suggested questions
  • When to ask vs When to tell
  • Incorporating coaching into a workday
  • Preparing for common coaching problems

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

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

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

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

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

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 

It’s easy to feel overwhelmed with the rapid changes taking place in technology, communication, and working conditions during this global pandemic. So how can you foster a positive mindset and develop strategies to stay resilient and growth-oriented? This training will give you the mental framework and tools you need to prepare for change and to maintain a growth mindset amidst challenging or uncertain times.

Outcomes:

  • Discover your ability to keep going when things get tough.
  • Learn how to drive more success at work and home and how to stop giving up.
  • Gain an ability to bring a growth mindset to those around you.

Google Workspace Tools Introduction

Google Workspace provides a full suite of productivity applications. In this Task Targeted Training, students focus on the tools they all have in common. Google Drive allows for collaboration and sharing of the things users create, Google Forms enables collecting information from users, and Google Meet connects teams of all sizes.

Google Drive

  • Navigate the Drive Interface
  • Organize Files in Drive
  • View Files in Drive
  • Upload Files to Drive

Google Forms

  • Create a Survey
  • Sending a Survey
  • View Survey Responses

Google Meet

  • Get Started with Google Meet
  • Options in Google Meet
  • Presentation Tools with Google Meet
  • Manage Meetings in Google Meet

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

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

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.

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

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

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

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

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

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

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

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

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

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

PowerPoint Level 1 Overview

It's hard to imagine a day going by without people passing along large amounts of information. Messages are everywhere, and the number of messages we receive seems to be increasing each day. Whether via phone, email, mass media, or personal interaction, we are subjected to a constant stream of information. With so much communication to contend with, it can be difficult to grab people's attention. But, we are often called upon to do just that. So, 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® Office PowerPoint® 2016 can help you do.

Gone are the days of flip charts or drawing on a white board to illustrate your point. 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 2016, 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 2016 to begin creating engaging, dynamic multimedia presentations.

 

Audience

This course is designed for students who wish to gain a foundational understanding of Microsoft PowerPoint 2016 that is necessary to create and develop engaging multimedia presentations.

 

Prerequisites

To ensure success, students should be familiar with using personal computers, and should have experience using a keyboard and mouse. Students should be comfortable 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: launching and closing applications, navigating basic file structures, and managing files and folders.

 

Objectives

Upon completing this course, you will be able to create and deliver engaging multimedia presentations that convey the key points of your message through the use of text, graphics, and animations.

You will:

  • Identify the basic features and functions of PowerPoint 2016.
  • Develop a PowerPoint presentation.
  • Perform advanced text editing operations.
  • Add graphical elements to your presentation.
  • Modify objects in your presentation.
  • Add tables to your presentation.
  • Add charts to your presentation.
  • Prepare to deliver your presentation.

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 PowerPoint Presentation

Topic D: Use PowerPoint Help

 

Lesson 2: Developing a PowerPoint Presentation

Topic A: Select a Presentation Type

Topic B: Edit Text

Topic C: Build a Presentation

 

Lesson 3: Performing Advanced Text Editing Operations

Topic A: Format Characters

Topic B: Format Paragraphs

Topic C: Format Text Boxes

 

Lesson 4: Adding Graphical Elements to Your Presentation

Topic A: Insert Images

Topic B: Insert Shapes

 

Lesson 5: Modifying Objects in Your Presentation

Topic A: Edit Objects

Topic B: Format Objects

Topic C: Group Objects

Topic D: Arrange Objects

Topic E: Animate Objects

 

Lesson 6: Adding Tables to Your Presentation

Topic A: Create a Table

Topic B: Format a Table

Topic C: Insert a Table from Other Microsoft Office Applications

 

Lesson 7: Adding Charts to Your Presentation

Topic A: Create a Chart

Topic B: Format a Chart

Topic C: Insert a Chart from Microsoft Excel

 

Lesson 8: Preparing to Deliver Your Presentation

Topic A: Review Your Presentation

Topic B: Apply Transitions

Topic C: Print Your Presentation

Topic D: Deliver Your Presentation

 

Appendix A: Microsoft Office PowerPoint 2016 Exam 77-729

 

Appendix B: Microsoft PowerPoint 2016 Common Keyboard Shortcuts

Word Level 2 Overview

After you master the basics of using Microsoft® Word 2016 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.

 

Audience

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 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. 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; format the overall appearance of a page; and create lists and tables.

 

Objectives

In this course, you will learn to create and modify complex documents and use tools that allow you to customize those documents.

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.

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 (Optional)

 

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: Simplifying and 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: The Mail Merge Feature

Topic B: Merge Envelopes and Labels

 

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

Word Level 2 Overview

After you master the basics of using Microsoft® Word 2016 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.

 

Audience

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 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. 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; format the overall appearance of a page; and create lists and tables.

 

Objectives

In this course, you will learn to create and modify complex documents and use tools that allow you to customize those documents.

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.

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 (Optional)

 

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: Simplifying and 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: The Mail Merge Feature

Topic B: Merge Envelopes and Labels

 

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

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

No matter your role or leadership level, negotiation is an everyday workplace occurrence that can leave a sour taste with lasting consequences. In this workshop, you will deepen your negotiation skills to help you achieve positive-sum outcomes for everyone involved, allowing you to maintain trust and strong relationships with colleagues, clients and vendors.

Outcomes:

  • Understand the value of negotiation skills in the workplace
  • Learn a four-part model to achieve successful win/win negotiations
  • Develop communication strategies for more effective negotiations
  • Strategize negotiation plans utilizing collaboration and empathy

Course Outline:

  • The value of negotiation for employees and employers
  • Four main reasons to negotiate
  •  What is win/win negotiation
  • 4’s of Successful Negotiation: Achieving a favorable deal for both parties
  • Negotiation case study

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

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