Class Schedule

Click on a class below to begin the enrollment process:

Adobe Acrobat DC Pro Training: Essential Skills
Build Trust with Others
Coach Your Team (LIVE Remote)

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
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
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
Delegate to Scale Your Impact

A results-oriented workshop designed to elevate team performance through effective delegation. Participants master the art of assigning tasks strategically, ensuring optimal productivity and growth. Learn to identify delegation opportunities, support your team without micromanaging, and focus on high-priority responsibilities. Turn delegation into your secret weapon for multiplying value and driving team success.

What We’ll Explore:

  • Benefits of delegation 
  • Delegation Greenlights 
  • How to Delegate 
  • Helping vs. Micromanaging
 

Course Outline

  • Delegation Greenlights
  • How to know if you should delegate a task or project
  • Test whether you have the necessary resources to delegate
  • Establish criteria for choosing who to delegate to
  • Master the skills of clearly communicating task or project expectations
  • Support by helping rather than micromanaging
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
Enhance Your Emotional Intelligence (LIVE Remote)

Course Description

In this workshop, participants will gain a finer understanding of what emotional intelligence is and how it develops. The course is built on three EQ pillars: self-awareness, self-regulation and self-improvement. The course draws from the latest research and trends in emotional intelligence, topics like interoception and emotional granularity. By the end, participants will leave with enhanced levels of understanding about their own emotional experience and how to navigate that experience within the context of their everyday work and life situations.

Explore AI Essentials (Live Remote)
Give and Receive Feedback for Managers (LIVE Remote)

Giving and Receiving Feedback is a foundational course geared towards managers that covers the basics of a subject many people find difficult. Participants explore a systems approach rooted in allyship to giving and receiving feedback that is flexible and holistic. Our approach is still grounded in observable, situational details but takes giving and receiving feedback a step farther, resulting in unique and authentic feedback that is more likely to be heard, understood, embraced and acted upon.

 

Outcomes

  • Define and prioritize allyship when giving feedback 
  • Learn and practice our FOR-A feedback model through the lens of situational understanding 
  • Learn to “lean into” receiving feedback from a growth perspective 
  • Use the circuitry of giving and receiving feedback to enhance your approach 

Outline

  • Define and prioritize Allyship 
  • Intro to the FOR-A Model for giving impactful feedback 
  • Define & Refine: a model for refining the 4 steps of FOR-A 
  • Applying the models to provide thoughtful, authentic, and impactful feedback 
  • Intro to the Lean in Practice for receiving feedback well 
  • How giving and receiving feedback work together like a circuit
Google Project Management Tools (LIVE Remote)

Google Workspace provides a family of tools that allow for the collaboration of plans, files, schedules, and other components required to manage projects. Students will focus on the end-to-end applications, steps, and tasks to:

  • Efficiently prepare project assets
  • Organize project plans
  • Assign and track tasks
  • Create and report on project final details
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

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

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 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
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 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 3 (LIVE Remote)

Excel Level 3 Overview

Clearly, you use Excel a lot in your role. Otherwise, you wouldn't be taking this course. By now, you're already familiar with Excel 2016, its functions and formulas, a lot of its features and functionality, and its powerful data analysis tools. You are likely called upon to analyze and report on data frequently, work in collaboration with others to deliver actionable organizational intelligence, and keep and maintain workbooks for all manner of purposes. At this level of use and collaboration, you have also likely encountered your fair share of issues and challenges. You're too busy, though, to waste time scouring over workbooks to resolve issues or to perform repetitive, monotonous tasks. You need to know how to get Excel to do more for you so you can focus on what's really important: staying ahead of the competition. That's exactly what this course aims to help you do.

This course builds off of the foundational and intermediate knowledge presented in the Microsoft® Office Excel® 2016: Part 1 and Part 2 courses to help you get the most of your Excel experience. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you'll be able to focus on getting the answers you need from the vast amounts of data your organization generates.

 

Audience

This course is intended for students who are experienced Excel 2016 users and have a desire or need to advance their skills in working with some of the more advanced Excel features. Students will likely need to troubleshoot large, complex workbooks, automate repetitive tasks, engage in collaborative partnerships involving workbook data, construct complex Excel functions, and use those functions to perform rigorous analysis of extensive, complex datasets.

 

Prerequisites

To ensure success, students should have practical, real-world experience creating and analyzing datasets using Excel 2016. Specific tasks students should be able to perform include: creating formulas and using Excel functions; creating, sorting, and filtering datasets and tables; presenting data by using basic charts; creating and working with PivotTables, slicers, and PivotCharts; and customizing the Excel environment. To meet these prerequisites, students can take the following Logical Operations courses, or should possess the equivalent skill level:

  • Microsoft® Office Excel® 2016: Part 1
  • Microsoft® Office Excel® 2016: Part 2

 

Course Objectives

Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.

You will:

  • Work with multiple worksheets and workbooks.
  • Use Lookup functions and formula auditing
  • Share and protect workbooks.
  • Automate workbook functionality.
  • Create sparklines and map data.
  • Forecast data.

Lesson 1: Working with Multiple Worksheets and Workbooks

Topic A: Use Links and External References

Topic B: Use 3-D References

Topic C: Consolidate Data

 

Lesson 2: Using Lookup Functions and Formula Auditing

Topic A: Use Lookup Functions

Topic B: Trace Cells

Topic C: Watch and Evaluate Formulas

 

Lesson 3: Sharing and Protecting Workbooks

Topic A: Collaborate on a Workbook

Topic B: Protect Worksheets and Workbooks

 

Lesson 4: Automating Workbook Functionality

Topic A: Apply Data Validation

Topic B: Search for Invalid Data and Formulas with Errors

Topic C: Work with Macros

 

Lesson 5: Creating Sparklines and Mapping Data

Topic A: Create Sparklines

Topic B: Map Data

 

Lesson 6: Forecasting Data

Topic A: Determine Potential Outcomes Using Data Tables

Topic B: Determine Potential Outcomes Using Scenarios

Topic C: Use the Goal Seek Feature

Topic D: Forecasting Data Trends

 

Appendix A: Microsoft Office Excel 2016 Exam 77-727

Appendix B: Microsoft Office Excel 2016 Expert Exam 77–728

Appendix C: Microsoft Excel 2016 Common Keyboard Shortcuts

Appendix D: Cube Functions

Appendix E: Importing and Export Data

Appendix F: Internationalizing Workbooks

Appendix G: Working with Power Pivot

Appendix H: Advanced Customization Options

Appendix I: Working with Forms and Controls

Microsoft Excel Data Analysis with Power Pivot (LIVE Remote)

Overview:

We are now living in the age of big data. Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amounts of data quickly. Fortunately, Excel provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data.

 

Course Objectives:

 

  • Get started with Power Pivot.
  • Visualize Power Pivot data.
  • Work with advanced functionality in Power Pivot.

Lesson 1: Getting Started with Power Pivot

Topic A: Enable and Navigate Power Pivot

Topic B: Manage Data Relationships

 

Lesson 2: Visualizing Power Pivot Data

Topic A: Create a Power Pivot Report

Topic B: Create Calculations in Power Pivot

 

Lesson 3: Working with Advanced Functionality in Power Pivot

Topic A: Create a Key Performance Indicator

Topic B: Work with Dates and Time in Power Pivot

Motivate Your Team (LIVE Remote)

Teams with motivated employees are highly adaptable, exude positive attitudes, and show improved performance and productivity. This workshop takes team leaders through the process of self-reflecting on how their attitudes and beliefs impact employee motivation and focuses on strategic and practical actions they can take to create a work environment that optimizes motivation for their team.

  • Benefits of Motivated Employees
  • Self-reflection:
    • Attitude
    • Beliefs
  • Optimize Motivation
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 
Present Like a Pro (LIVE Remote)

Run Better Meetings (LIVE Remote)

In this workshop, participants will learn how to leverage the power of psychological safety to run more effective, productive and high performing meetings. Participants begin with an assessment of the current state of their meetings which can be mapped onto the six core components of psychologically safe meetings. Participants will leave with a thorough understanding of our meeting framework leading to greater levels of inclusion, interaction, engagement, and productivity. 

Outcomes 

  • Learn what psychological safety is and how it relates to meetings
  • Assess your meetings for psychological safety
  • Apply 6 components to run a psychologically safe meeting 
  • Discover how power, privilege, and access can impact a meeting 

 

Course Outline

  • What is psychological safety
  • Assess your meetings for psychological safety
  • 6 components of a psychologically safe meeting, including:
    • Establishing what type of meeting this will be 
    • Strategically reduce meeting size while promoting inclusion 
    • Set the tone for a high performing meeting 
    • Agendas, time management, and roles for predictability
    • Collect inclusive contributions while staying on track 
    • Use feedback for continuous improvement and collective engagement 
  • How power, privilege, and access impact a meeting
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
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