Class Schedule

Click on a class below to begin the enrollment process:

Allyship: Being an Advocate for All moves participants from thinking about one to acting for all. Our Allyship learning session prepares people in your organization to intervene in situations where they spot non-inclusive behaviour, such as hearing a colleague unconsciously stating a bias in a meeting or observing someone being constantly interrupted. This training equips you to act confidentially and Ally with confidence, not only for colleagues who are from underrepresented groups, but for your entire organization.

Participants will leave this learning session with practical approaches to work in solidarity with people from groups in which they do not belong. By doing so, people will expand their capability to disrupt behaviours and actions that exclude vs. include others.

Outcomes:

  • You will discover and practice the 3 Stages of Growth for Effective Allies Model.
  • You will discover immediate actions you can take that will leave people with an authentic experience of being included

Course Outline

Brave Space vs. Safe Space

The Four Agreements to having Courageous Conversations

Allyship: what it is and what it isn’t

  • Why Allyship in the 1st Place?
  • Journey vs. Destination
  • The Business Case for Inclusion
  • The Allyship Model: For One, Some & All
  • The Empathy Triangle

Moving into Action (application of this training back at work)

  • The Empathy Triangle
  • Allyship Questions before Engaging
  • The Power of Research

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!

Trust is an essential component of leadership that can be challenging to build and easy to lose. We’ve built this class around six key traits of trust, the THREAD model: together, honest, resourceful, empowering, approachable, and dependable. In this course, you will discover where you need to grow and which traits to develop. You will learn actionable steps for becoming a more trustworthy leader. And you learn what to watch out for when applying these key traits.

 

  • The THREAD Model
    • Together
    • Honest
    • Resourceful
    • Empowering
    • Approachable
    • Dependable
  • Discover
    • Where you need to grow
    • Which traits to develop
  • Actionable Steps
    • Become a more trustworty leader

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

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

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

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

What We’ll Explore:

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

Course Outline

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

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

Course Description

We believe stories are an essential tool for business because stories are how people make sense of the world. If you want others to remember what you say, to care about your ideas, and to act on them then this class will be a good fit for you. Our Storytelling for Business course takes storytelling beyond the confines of once-upon-a-time stories to include metaphors, analogies and everyday information sharing. This is our most interactive class. In it, you will learn to apply the four key story elements to a variety of business situations including at least one of your own.

Outcomes:

Learn the four key story elements Practice applying each one in a series of scaffolded, small group breakouts Broaden your application of story elements to include situation-problem-solution frameworks, metaphors and analogies Leave with a fully developed story, analogy or SPS framework that you build for yourself and can immediately apply

Course Outline

Explore your own, unique business storytelling needs Learn the four key story elements Sequentially build your storytelling skills by practicing each one in small group breakouts Discover the difference between just-for-fun social stories and business stories Learn to apply situation-problem-solution frameworks to your everyday business communication Practice developing metaphors and analogies Apply the lessons learned to your own situation by developing a business story you can immediately use

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

Outcomes:

  • Use curiosity and attunement to identify with the client
  • Validate their situation and recommend solutions based on your experience
  • Make your ask again with structured persuasion

Excel Advanced- Standard – Full Day

After you’ve mastered formatting tables of data, creating formulas between cells, using built-in functions, and creating charts, there is a standard set of more powerful features you’ll eventually need. Whether you’re looking at someone else’s spreadsheet and wondering “how did they do that?” or simply lacking enough firepower to get your own spreadsheets to do what you want, this class will probably solve that problem.

  • Use Database Functions: XLOOKUP(), SUMIF(), and AVERAGEIF()
  • Fix errors using auditing, or handle inevitable errors with backup values
  • Apply data cleanup and isolation/consolidation techniques.
  • Find optimal values for a single cell or a set of inter-related cells. 
  • Create and run basic macros to automate repetitive tasks.
  • Add macros to the Excel ribbon
 

Module 3: List/Table Essentials & Charting

  • Create tables to help make analyzing large data sets easier with table tools
  • Using Filters and Sorting tools on a data sets show the data you are looking for
  • Create and save visuals and charts for data sets
  • What is a well-defined list?
  • Inserting Tables 
  • Flash fill
  • Multi-Level Sorting
  • Removing Duplicates
  • Filtering Records
  • Using Slicers to filter
  • Automatic Subtotals
  • The Quick Analysis Tools
  • Inserting Data Charts
  • Recommended Charts
  • Editing Chart Elements
  • Adding/Removing Data From A Chart
  • Creating Custom Chart Templates
  • Printing Charts
  • Inserting Sparkline

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 

  •  Increasing our awareness of time
  • 4 concepts to think realistically about time
  • Improving our regulation of time
  • Prioritize using the REP plan and calendar blocking

Course Outline

  • Time awareness
    • Efficiency vs effectiveness
    • Pareto principle
    • Energy peaks and valleys
    • Sunk cost fallacy
  • Regulating your time
    • REP Plan 
    • The Planning Fallacy
    • Calendar Blocking

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

 

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

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

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

Audience

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

Prerequisites

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

Objectives

Upon successful completion of this course,

You will:

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

Lesson 1: Working With Functions

Topic A: Working With Ranges

Topic B: Use Specialized Functions

Topic C: Work With Logical Functions

Topic D: Work With Date & Time Functions

Topic E: Work With Text Functions

Lesson 2:  Working With Lists

Topic A: Sort Data

Topic B: Filter Data

Topic C: Query Data With Database Functions

Lesson 3: Analyzing Data

Topic A: Create And Modify Tables

Topic B: Apply Intermediate Conditional Formatting

Topic C: Apply Advanced Conditional Formatting

Lesson 4:  Visualizing Data With Charts

Topic A: Create Charts

Topic B: Modify And Format Charts

Topic C: Use Advanced Chart Features

Lesson 5:  Using Pivot Tables And Pivot Charts

Topic A: Create a Pivot Table

Topic B: Analyze Pivot Table Data

Topic C: Present Data With Pivot Tables

 

Google 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

Gmail Training

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

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

Audience

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

Prerequisites

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

Objectives

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

By the end of this course you will:

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

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

Lesson 2: Formatting Messages 
Topic A: Add Message Recipients 
Topic B: Check Spelling and Grammar 
Topic C: Format Message Content 

Lesson 3: Working with Attachments 
Topic A: Attach Files and Items 
Topic B: Manage Automatic Message Content 

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

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

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

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

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

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

Google 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 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 Docs 1 Overview

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

Audience


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


Prerequisites


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


Objectives

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

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

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

Lesson 2: Formatting Text and Paragraphs
Topic A: Apply Character Formatting
Topic B: Control Paragraph Layout
Topic C: Align Text Using Tabs
Topic D: Display Text in Bulleted or Numbered Lists
Topic E: Apply Borders and Shading

Lesson 3: Working More Efficiently
Topic A: Make Repetitive Edits
Topic B: Apply Repetitive Formatting
Topic C: Paragraph Styles

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

Lesson 5: Adding Tables
Topic A: Adding a Table
Topic B: Modify a Table
Topic C: Format a Table

Lesson 6: Inserting Graphic Objects
Topic A: Insert Symbols and Special Characters
Topic B: Add Images to a Document

Lesson 7: Controlling Page Appearance
Topic A: Apply a Page Border and Color
Topic B: Add Headers and Footers
Topic C: Control Page Layout
Topic D: Add a Watermark

Lesson 8: Preparing to Publish a Document
Topic A: Check Spelling and Word Count
Topic B: Use Research Tools
Topic C: Check Accessibility
Topic D: Save a Document to Other Formats

Google Docs 1 Overview

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

Audience


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


Prerequisites


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


Objectives

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

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

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

Lesson 2: Formatting Text and Paragraphs
Topic A: Apply Character Formatting
Topic B: Control Paragraph Layout
Topic C: Align Text Using Tabs
Topic D: Display Text in Bulleted or Numbered Lists
Topic E: Apply Borders and Shading

Lesson 3: Working More Efficiently
Topic A: Make Repetitive Edits
Topic B: Apply Repetitive Formatting
Topic C: Paragraph Styles

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

Lesson 5: Adding Tables
Topic A: Adding a Table
Topic B: Modify a Table
Topic C: Format a Table

Lesson 6: Inserting Graphic Objects
Topic A: Insert Symbols and Special Characters
Topic B: Add Images to a Document

Lesson 7: Controlling Page Appearance
Topic A: Apply a Page Border and Color
Topic B: Add Headers and Footers
Topic C: Control Page Layout
Topic D: Add a Watermark

Lesson 8: Preparing to Publish a Document
Topic A: Check Spelling and Word Count
Topic B: Use Research Tools
Topic C: Check Accessibility
Topic D: Save a Document to Other Formats

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

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

Sleep and self-care are two of the first things to go when we are faced with busy, challenging, or changing times. Long work hours and skipped vacation time take away from our need to rest, reset and rejuvenate. In this relaxation-driven training, discover the research behind the importance of sleep and why we must practice self-care. Learn how to implement strategies for your environment, your mind, and your body to build a clear mind and energy boost for your workdays. 

Outcomes:

  • Gain an understanding of sleep patterns, sleep interruptions, and best sleep practices.
  • Take part in self-discovery activities to analyze your sleep and self-care strategies.
  • Learn ways to prioritize your daily self-care and put into action new sleep habits.

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

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

Every person in an organization initiates difficult conversations from time to time, whether about policies, performance, expectations, or boundaries. Preserving good relationships in the midst of those conversations can be difficult without specific tools to help you navigate the complexities. This course equips you with those tools and enables you to keep positive, helpful relationship with your colleagues, even when a difficult circumstance arises.

Outcomes:

  • Use empathy and curiosity to build relationships
  • Actively listen to gain trust and understand deeper needs
  • Pivot toward shared-interest solutions

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

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

 

 

Access Level 1 Overview

Data is everywhere. Whether you are at the grocery store, office, laboratory, classroom, or ballpark, you are awash in data: prices, schedules, performance measures, lab results, recipes, contact information, quality metrics, market indices, grades, and statistics.

Most job roles today involve some form of data management. In the case of data workers, it may be their primary job task. For some, such as research scientists and accountants, data management may be a strong component of the job. And for others, such as sales clerks or those in the skilled trades, data management may consist of incidental job responsibility, for example, time reporting or recording a sale. Virtually everyone is affected in some way by the need to manage data.

A relational database application such as Microsoft® Office Access® 2016 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, you will use Access 2016 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016.

 

Audience

This course is designed for students who wish to establish a foundational understanding of Microsoft Office Access 2016, including the skills necessary to create a new database, construct data tables, design forms, and reports, and create queries.

 

Prerequisites

To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites.

 

Objectives

In this course, you will create and manage an Access 2016 database.

You will:

  • Navigate within the Microsoft Access application environment, create a simple database, and customize Access configuration options.
  • Organize and manage data stored within Access tables.
  • Use queries to join, sort, and filter data from different tables.
  • Use forms to make it easier to view, access, and input data.
  • Create and format custom reports.

Lesson 1: Getting Started with Access

Topic A: Orientation to Microsoft Access

Topic B: Create a Simple Access Database

Topic C: Get Help and Configure Options in Microsoft Access

Lesson 2: Working with Table Data

Topic A: Modify Table Data

Topic B: Sort and Filter Records

Lesson 3: Querying a Database

Topic A: Create Basic Queries

Topic B: Sort and Filter Data in a Query

Topic C: Perform Calculations in a Query

Lesson 4: Using Forms

Topic A: Create Basic Access Forms

Topic B: Work with Data on Access Forms

Lesson 5: Generating Reports

Topic A: Create a Report

Topic B: Add Controls to a Report

Topic C: Enhance the Appearance of a Report

Topic D: Prepare a Report for Print

Topic E: Organize Report Information

Topic F: Format Reports

Appendix A: Microsoft Office Access 2016 Exam 77-730

Appendix B: Microsoft Access 2016 Common Keyboard Shortcuts

Access Level 1 Overview

Data is everywhere. Whether you are at the grocery store, office, laboratory, classroom, or ballpark, you are awash in data: prices, schedules, performance measures, lab results, recipes, contact information, quality metrics, market indices, grades, and statistics.

Most job roles today involve some form of data management. In the case of data workers, it may be their primary job task. For some, such as research scientists and accountants, data management may be a strong component of the job. And for others, such as sales clerks or those in the skilled trades, data management may consist of incidental job responsibility, for example, time reporting or recording a sale. Virtually everyone is affected in some way by the need to manage data.

A relational database application such as Microsoft® Office Access® 2016 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, you will use Access 2016 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016.

 

Audience

This course is designed for students who wish to establish a foundational understanding of Microsoft Office Access 2016, including the skills necessary to create a new database, construct data tables, design forms, and reports, and create queries.

 

Prerequisites

To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites.

 

Objectives

In this course, you will create and manage an Access 2016 database.

You will:

  • Navigate within the Microsoft Access application environment, create a simple database, and customize Access configuration options.
  • Organize and manage data stored within Access tables.
  • Use queries to join, sort, and filter data from different tables.
  • Use forms to make it easier to view, access, and input data.
  • Create and format custom reports.

Lesson 1: Getting Started with Access

Topic A: Orientation to Microsoft Access

Topic B: Create a Simple Access Database

Topic C: Get Help and Configure Options in Microsoft Access

Lesson 2: Working with Table Data

Topic A: Modify Table Data

Topic B: Sort and Filter Records

Lesson 3: Querying a Database

Topic A: Create Basic Queries

Topic B: Sort and Filter Data in a Query

Topic C: Perform Calculations in a Query

Lesson 4: Using Forms

Topic A: Create Basic Access Forms

Topic B: Work with Data on Access Forms

Lesson 5: Generating Reports

Topic A: Create a Report

Topic B: Add Controls to a Report

Topic C: Enhance the Appearance of a Report

Topic D: Prepare a Report for Print

Topic E: Organize Report Information

Topic F: Format Reports

Appendix A: Microsoft Office Access 2016 Exam 77-730

Appendix B: Microsoft Access 2016 Common Keyboard Shortcuts

Access Level 2 Overview

Your training and experience using Microsoft® Access® 2016 has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, validate data entered into a database, and customize reports. Extending your knowledge of Microsoft Access 2016 will result in a robust, functional database for your users.

 

Audience

This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, or creating advanced queries and reports.

 

Prerequisites

To ensure your success, it is recommended you have completed Microsoft® Office Access® 2016: Part 1or possess equivalent knowledge. It is also suggested that you have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites.

 

Objectives

In this course, you will create and manage an Access 2016 database.

You will:

  • Design a relational database.
  • Join tables to retrieve data from unrelated tables.
  • Validate data entered into a database.
  • Use advanced queries to manipulate your data.
  • Organize a database for efficiency and performance, and to maintain data integrity.
  • Customize reports to organize the displayed information and produce specific print layouts.

Lesson 1: Designing a Relational Database

Topic A: Relational Database Design

Topic B: Create a Table

Topic C: Create Table Relationships

 

Lesson 2: Joining Tables

Topic A: Create Query Joins

Topic B: Relate Data Within a Table

Topic C: Work with Subdatasheets

 

Lesson 3: Using Data Validation

Topic A: Use Field Validation

Topic B: Use Form and Record Validation

 

Lesson 4: Creating Advanced Queries

Topic A: Create Parameter Queries

Topic B: Summarize Data

Topic C: Create Subqueries

Topic D: Create Action Queries

Topic E: Create Unmatched and Duplicate Queries

 

Lesson 5: Organizing a Database for Efficiency

Topic A: Data Normalization

Topic B: Create a Junction Table

Topic C: Improve Table Structure

 

Lesson 6: Using Advanced Reporting Techniques

Topic A: Include Control Formatting in a Report

Topic B: Add a Calculated Field to a Report

Topic C: Add a Subreport to an Existing Report

 

Appendix A: Microsoft Office Access 2016 Exam 77-730

 

Appendix B: Microsoft Access 2016 Common Keyboard Shortcuts

Access Level 2 Overview

Your training and experience using Microsoft® Access® 2016 has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, validate data entered into a database, and customize reports. Extending your knowledge of Microsoft Access 2016 will result in a robust, functional database for your users.

 

Audience

This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, or creating advanced queries and reports.

 

Prerequisites

To ensure your success, it is recommended you have completed Microsoft® Office Access® 2016: Part 1or possess equivalent knowledge. It is also suggested that you have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites.

 

Objectives

In this course, you will create and manage an Access 2016 database.

You will:

  • Design a relational database.
  • Join tables to retrieve data from unrelated tables.
  • Validate data entered into a database.
  • Use advanced queries to manipulate your data.
  • Organize a database for efficiency and performance, and to maintain data integrity.
  • Customize reports to organize the displayed information and produce specific print layouts.

 

Lesson 1: Designing a Relational Database

Topic A: Relational Database Design

Topic B: Create a Table

Topic C: Create Table Relationships

 

Lesson 2: Joining Tables

Topic A: Create Query Joins

Topic B: Relate Data Within a Table

Topic C: Work with Subdatasheets

 

Lesson 3: Using Data Validation

Topic A: Use Field Validation

Topic B: Use Form and Record Validation

 

Lesson 4: Creating Advanced Queries

Topic A: Create Parameter Queries

Topic B: Summarize Data

Topic C: Create Subqueries

Topic D: Create Action Queries

Topic E: Create Unmatched and Duplicate Queries

 

Lesson 5: Organizing a Database for Efficiency

Topic A: Data Normalization

Topic B: Create a Junction Table

Topic C: Improve Table Structure

 

Lesson 6: Using Advanced Reporting Techniques

Topic A: Include Control Formatting in a Report

Topic B: Add a Calculated Field to a Report

Topic C: Add a Subreport to an Existing Report

 

Appendix A: Microsoft Office Access 2016 Exam 77-730

 

Appendix B: Microsoft Access 2016 Common Keyboard Shortcuts

Access Level 3 Overview

You've covered many of the basic functions of Microsoft® Office Access® 2016, and now you're ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more. Knowledge of these features separates database professionals from casual database users or occasional designers. Today's training, added to that which you've gained from the Microsoft® Office Access® 2016: Part 1 and Microsoft® Office Access® 2016: Part 2 courses, rounds out your Access education and provides you with marketable job skills.

 

Audience

Students taking this course are database administrators or prospective database administrators who have experience working with Access 2016 and need to learn advanced skills.

 

Prerequisites

To ensure your success in your course you should have experience working with Microsoft Access 2016, including a working knowledge of database design and creation, form design and creation, report design and creation, a working knowledge of database querying and the various table relationships. You can obtain this level of skill and knowledge by taking the following Logical Operations courses:

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

 

Objectives

In this course, you will learn to create and manage a fundamental Access 2016 database.

You will:

  • Customize a form layout to improve usability and efficiency of data entry.
  • Share data across applications.
  • Use macros to improve user interface design.
  • Use VBA to enhance tasks.
  • Organize data into appropriate tables to ensure data dependency and minimize redundancy.
  • Lockdown and prepare a database for distribution to multiple users.
  • Create and modify a database switchboard and set the start-up options.

Lesson 1: Implementing Advanced Form Design

Topic A: Add Controls to Forms

Topic B: Enhance Navigation and Organization of Forms

Topic C: Apply Conditional Formatting

 

Lesson 2: Sharing Data Across Applications

Topic A: Import Data into Access

Topic B: Export Access Data

Topic C: Link Tables to External Data Sources

Topic D: Create a Mail Merge

 

Lesson 3: Using Macros to Improve User Interface Design

Topic A: Create a Macro

Topic B: Restrict Records by Using a Condition

Topic C: Validate Data by Using a Macro

Topic D: Automate Data Entry by Using a Macro

 

Lesson 4: Using VBA

Topic A: Getting Started with VBA

Topic B: Enhance Access by Using VBA

 

Lesson 5: Using Advanced Database Management

Topic A: Manage a Database

Topic B: Determine Object Dependency

Topic C: Document a Database

 

Lesson 6: Distributing and Securing a Database

Topic A: Splitting a Database for Multiple-User Access

Topic B: Implement Security

Topic C: Convert an Access Database to an ACCDE File

Topic D: Package a Database with a Digital Signature

 

Lesson 7: Managing Switchboards

Topic A: Create a Database Switchboard

Topic B: Modify a Database Switchboard

Topic C: Set Start-up Options

 

Appendix A: Microsoft Office Access 2016 Exam 77-730

 

Appendix B: Microsoft Access 2016 Common Keyboard Shortcuts

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

Excel 365 Part 2A

Intermediate Formulas and Basic Data Lists

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

Students should also have attended Excel 365 Parts 1A and 1B or have previous experience working in the Excel environment particularly with formula construction.

Lesson 1: Working with Functions

  • Topic A: Work with Ranges
  • Topic B: Use Specialized Functions
  • Topic C: Work with Logical Functions
  • Topic D: Work with Date and Time Functions
  • Topic E: Work with Text Functions

Lesson 2: Working with Lists

  • Topic A: Sort Data
  • Topic B: Filter Data
  • Topic C: Query Data with Database Functions
  • Topic D: Outline and Subtotal Data

 

Excel 365 Part 2B

Intermediate Data Structure and Visualization

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

Students should also have attended Excel 365 Parts 1A and 1B or have previous experience working in the Excel environment.

Lesson 1: Analyzing Data

  • Topic A: Create and Modify Tables
  • Topic B: Apply Intermediate Conditional Formatting
  • Topic C: Apply Advanced Conditional Formatting

Lesson 2: Visualizing Data with Charts

  • Topic A: Create Charts
  • Topic B: Modify and Format Charts
  • Topic C: Use Advanced Chart Features

Lesson 3: 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 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

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

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

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

OneNote Overview

In our fast-paced digital world, the need to capture ideas, meeting notes, and to-do items is ever present. Microsoft® Office OneNote® 2016 provides a way for you to efficiently create and collect your notes in an electronic notebook. This course will introduce you to using OneNote notebooks to store a wide variety of content in an organized structure, access the content from anywhere, and also share it with others.

 

Audience

This course is intended for people in a variety of roles and fields who have a basic understanding of Microsoft Office 2016 and want to incorporate digital note-taking and note collaboration by using Microsoft OneNote 2016. In addition to creating and modifying OneNote notebooks, this course will introduce you to inserting images and embedding files into notebooks, categorizing content, sharing content with OneDrive®, and exporting content to other file formats.

 

Prerequisites

To ensure your success in this course, you should have Windows end-user skills that include starting and closing applications, navigating basic file structures, and managing files and folders. Previous experience with OneNote is not required; however, having a basic understanding of the Microsoft Office productivity suite would be beneficial.

 

Objectives

In this course, you will develop digital note-taking skills by creating, modifying, and managing OneNote notebooks that work with other Microsoft Office programs.

You will:

  • Navigate and customize the OneNote interface and environment.
  • Add and format text, images, audio, links, and drawing objects to a notebook.
  • Embed Excel spreadsheets and attach other files to a notebook.
  • Categorize, organize, and search notebook content.
  • Check spelling in, print, and password-protect notebooks.
  • Use Outlook and OneDrive to send and share notebook content.
  • Export notebook content and manage notebook history and backups.

Lesson 1: Getting Started with OneNote

Topic A: Navigate the OneNote 2016 Environment

Topic B: Use Templates

Topic C: Customize the OneNote User Interface

 

Lesson 2: Adding and Formatting Notebook Content

Topic A: Apply Formatting to Notebook Content

Topic B: Insert Images and Audio into a Notebook

Topic C: Add Quick Notes and Links

Topic D: Use Drawing Tools

 

Lesson 3: Embedding and Attaching Files

Topic A: Embed Excel Spreadsheets

Topic B: Attach Other File Types

 

Lesson 4: Organizing and Searching Notebooks

Topic A: Use Tags

Topic B: Organize and Search Notebooks

 

Lesson 5: Finalizing a Notebook

Topic A: Proof and Print a Notebook

Topic B: Configure Password Protection and Notebook Properties

 

Lesson 6: Managing Notebook Files

Topic A: Export Content from OneNote Notebooks

Topic B: Back Up and Restore Notebook Content

 

Lesson 7: Sending and Sharing OneNote Content

Topic A: Send OneNote Content in Other Formats

Topic B: Share OneNote Content by Using OneDrive

 

Appendix A: Microsoft OneNote 2016 Common Keyboard Shortcuts

OneNote Overview

In our fast-paced digital world, the need to capture ideas, meeting notes, and to-do items is ever present. Microsoft® Office OneNote® 2016 provides a way for you to efficiently create and collect your notes in an electronic notebook. This course will introduce you to using OneNote notebooks to store a wide variety of content in an organized structure, access the content from anywhere, and also share it with others.

 

Audience

This course is intended for people in a variety of roles and fields who have a basic understanding of Microsoft Office 2016 and want to incorporate digital note-taking and note collaboration by using Microsoft OneNote 2016. In addition to creating and modifying OneNote notebooks, this course will introduce you to inserting images and embedding files into notebooks, categorizing content, sharing content with OneDrive®, and exporting content to other file formats.

 

Prerequisites

To ensure your success in this course, you should have Windows end-user skills that include starting and closing applications, navigating basic file structures, and managing files and folders. Previous experience with OneNote is not required; however, having a basic understanding of the Microsoft Office productivity suite would be beneficial.

 

Objectives

In this course, you will develop digital note-taking skills by creating, modifying, and managing OneNote notebooks that work with other Microsoft Office programs.

You will:

  • Navigate and customize the OneNote interface and environment.
  • Add and format text, images, audio, links, and drawing objects to a notebook.
  • Embed Excel spreadsheets and attach other files to a notebook.
  • Categorize, organize, and search notebook content.
  • Check spelling in, print, and password-protect notebooks.
  • Use Outlook and OneDrive to send and share notebook content.
  • Export notebook content and manage notebook history and backups.

Lesson 1: Getting Started with OneNote

Topic A: Navigate the OneNote 2016 Environment

Topic B: Use Templates

Topic C: Customize the OneNote User Interface

 

Lesson 2: Adding and Formatting Notebook Content

Topic A: Apply Formatting to Notebook Content

Topic B: Insert Images and Audio into a Notebook

Topic C: Add Quick Notes and Links

Topic D: Use Drawing Tools

 

Lesson 3: Embedding and Attaching Files

Topic A: Embed Excel Spreadsheets

Topic B: Attach Other File Types

 

Lesson 4: Organizing and Searching Notebooks

Topic A: Use Tags

Topic B: Organize and Search Notebooks

 

Lesson 5: Finalizing a Notebook

Topic A: Proof and Print a Notebook

Topic B: Configure Password Protection and Notebook Properties

 

Lesson 6: Managing Notebook Files

Topic A: Export Content from OneNote Notebooks

Topic B: Back Up and Restore Notebook Content

 

Lesson 7: Sending and Sharing OneNote Content

Topic A: Send OneNote Content in Other Formats

Topic B: Share OneNote Content by Using OneDrive

 

Appendix A: Microsoft OneNote 2016 Common Keyboard Shortcuts

Outlook 1 Overview

Email has become one of the most widely used methods of communication, whether for personal or business communications. In most organizations, large or small, email is the preferred form of communicating information amongst employees. As email grows in popularity and use, most organizations have found the need to implement a corporate mail management system such as Microsoft® Office Outlook® to handle the messages and meeting invitations sent among employees.

 

In this course, you will use Outlook to send, receive, and manage email messages, manage your contact information, schedule appointments and meetings, create tasks and notes for yourself, and customize the Outlook interface to suit your working style.

 

This course is the first in a series of two Microsoft® Office Outlook® 2016 courses. It will provide you with the basic skills you need to start using Outlook 2016 to manage your email communications, contact information, calendar events, tasks, and notes.

 

You can also use this course to prepare for the Microsoft Office Specialist (MOS) Certification exams for Microsoft Outlook 2016.

 

Audience

This course is intended for people who have a basic understanding of Microsoft® Windows® and need to know how to use Outlook as an email client to manage their email communications, calendar appointments, contact information, and other communication tasks. In addition to creating and sending email, this course will introduce you to organizing your mail, working with attachments, formatting message text, scheduling meetings, and responding to meeting invitations. 

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 and close applications, navigate basic file structures, and manage files and folders is recommended. 

Objectives

In this course, you will use Outlook to manage your email communications, including composing, reading, and responding to emails; schedule appointments and meetings; manage contact information; schedule tasks and create notes; customize message response options; and organize your mail.

 

You will:

  • Navigate Outlook 2016 to read and respond to email.
  • Use the Address Book, and format and spell check new messages.
  • Attach files and insert illustrations to messages.
  • Customize read and response options.
  • Use flags, categories, and folders to organize messages.
  • Create and work with Contacts.
  • Create appointments and schedule meetings in Calendar.
  • Create and work with Tasks and Notes.

Lesson 1: Getting Started with Outlook 2016

 Topic A: Navigate the Outlook Interface

 Topic B: Work with Messages

 Topic C: Access Outlook 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 and Illustrations

 Topic A: Attach Files and Items

 Topic B: Add Illustrations to Messages

 Topic C: Manage Automatic Message Content

 

Lesson 4: Customizing Message Options

 Topic A: Customize Reading Options

 Topic B: Track Messages

 Topic C: Recall and Resend Messages

 

Lesson 5: Organizing Messages

 Topic A: Mark Messages

 Topic B: Organize Messages Using Folders

 

Lesson 6: Managing Your Contacts

 Topic A: Create and Edit Contacts

 Topic B: View and Print Contacts

 

Lesson 7: Working with the Calendar

 Topic A: View the Calendar

 Topic B: Create Appointments

 Topic C: Schedule Meetings

 Topic D: Print the Calendar

 

Lesson 8: Working with Tasks and Notes

 Topic A: Create Tasks

 Topic B: Create Notes

 

Appendix A: Microsoft Office Outlook 2016 Exam 77-731

 

Appendix B: Microsoft Outlook 2016 Common Keyboard Shortcuts

 

 

Outlook 1 Overview

Email has become one of the most widely used methods of communication, whether for personal or business communications. In most organizations, large or small, email is the preferred form of communicating information amongst employees. As email grows in popularity and use, most organizations have found the need to implement a corporate mail management system such as Microsoft® Office Outlook® to handle the messages and meeting invitations sent among employees.

 

In this course, you will use Outlook to send, receive, and manage email messages, manage your contact information, schedule appointments and meetings, create tasks and notes for yourself, and customize the Outlook interface to suit your working style.

 

This course is the first in a series of two Microsoft® Office Outlook® 2016 courses. It will provide you with the basic skills you need to start using Outlook 2016 to manage your email communications, contact information, calendar events, tasks, and notes.

 

You can also use this course to prepare for the Microsoft Office Specialist (MOS) Certification exams for Microsoft Outlook 2016.

 

Audience

This course is intended for people who have a basic understanding of Microsoft® Windows® and need to know how to use Outlook as an email client to manage their email communications, calendar appointments, contact information, and other communication tasks. In addition to creating and sending email, this course will introduce you to organizing your mail, working with attachments, formatting message text, scheduling meetings, and responding to meeting invitations. 

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 and close applications, navigate basic file structures, and manage files and folders is recommended. 

Objectives

In this course, you will use Outlook to manage your email communications, including composing, reading, and responding to emails; schedule appointments and meetings; manage contact information; schedule tasks and create notes; customize message response options; and organize your mail.

 

You will:

  • Navigate Outlook 2016 to read and respond to email.
  • Use the Address Book, and format and spell check new messages.
  • Attach files and insert illustrations to messages.
  • Customize read and response options.
  • Use flags, categories, and folders to organize messages.
  • Create and work with Contacts.
  • Create appointments and schedule meetings in Calendar.
  • Create and work with Tasks and Notes.

Lesson 1: Getting Started with Outlook 2016

 Topic A: Navigate the Outlook Interface

 Topic B: Work with Messages

 Topic C: Access Outlook 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 and Illustrations

 Topic A: Attach Files and Items

 Topic B: Add Illustrations to Messages

 Topic C: Manage Automatic Message Content

 

Lesson 4: Customizing Message Options

 Topic A: Customize Reading Options

 Topic B: Track Messages

 Topic C: Recall and Resend Messages

 

Lesson 5: Organizing Messages

 Topic A: Mark Messages

 Topic B: Organize Messages Using Folders

 

Lesson 6: Managing Your Contacts

 Topic A: Create and Edit Contacts

 Topic B: View and Print Contacts

 

Lesson 7: Working with the Calendar

 Topic A: View the Calendar

 Topic B: Create Appointments

 Topic C: Schedule Meetings

 Topic D: Print the Calendar

 

Lesson 8: Working with Tasks and Notes

 Topic A: Create Tasks

 Topic B: Create Notes

 

Appendix A: Microsoft Office Outlook 2016 Exam 77-731

 

Appendix B: Microsoft Outlook 2016 Common Keyboard Shortcuts

 

 

Outlook 2 Overview

In this course, you will customize command sets, configure mail accounts, set global options, perform advanced searches, apply filters to intercept mail and control spam, create rules to automate many management tasks, work with calendars and contacts, manage tasks, protect data with archiving and data files, as well as share and delegate access to your workspaces.

This course builds upon the foundational knowledge presented in the Microsoft Outlook 1 course.

In addition, this course will help you prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Outlook. 

 

Audience

This course is intended for people who have a basic understanding of Microsoft® Windows® and want to know how to use Outlook’s advanced features to manage their email communications, calendar events, contact information, search functions, and other communication tasks.

Prerequisites

To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to open and close applications, navigate basic file structures, and manage files and folders. Additionally, it will benefit you to have basic Outlook skills. You can obtain these skills and knowledge by taking the following Training To YOU course Microsoft  Outlook 1.

Objectives

In this course, you will use Outlook’s advanced features to customize and manage your email communications, including using advanced features to organize emails; managing calendar settings and options; managing contact information; scheduling tasks; and managing Outlook backups and data file settings.

You will:

  • Modify messages and set global options.
  • Organize, search, and manage messages.
  • Manage your mailbox.
  • Automate message management.
  • Work with calendar settings.
  • Manage contacts and groups.
  • Manage activities by using tasks.
  • Share workspaces with others.
  • Manage Outlook data files.

 

Lesson 1: Modifying Messages and Setting Global Options

Topic A: Insert Advanced Characters and Objects

Topic B: Modify Message Settings and Options

Topic C: Configure Global Outlook Options

Topic D: Customize the Outlook Interface

 

Lesson 2: Organizing, Searching, and Managing Messages

Topic A: Group and Sort Messages

Topic B: Filter and Manage Messages

Topic C: Search Outlook Items

 

Lesson 3: Managing Your Mailbox

Topic A: Use the Junk E-Mail Filter to Manage Messages

Topic B: Manage Your Mailbox

 

Lesson 4: Automating Message Management

Topic A: Use Automatic Replies

Topic B: Use the Rules Wizard to Organize Messages

Topic C: Create and Use Quick Steps

 

Lesson 5: Working with Calendar Settings

Topic A: Set Advanced Calendar Options

Topic B: Create and Manage Additional Calendars

Topic C: Manage Meeting Responses

 

Lesson 6: Managing Contacts

Topic A: Import and Export Contacts

Topic B: Use Electronic Business Cards

Topic C: Forward Contacts

 

Lesson 7: Managing Activities by Using Tasks

Topic A: Assign and Manage Tasks

 

Lesson 8: Sharing Workspaces with Others

Topic A: Delegate Access to Outlook Folders

Topic B: Share Your Calendar

Topic C: Share Your Contacts

 

Lesson 9: Managing Outlook Data Files

Topic A: Use Archiving to Manage Mailbox Size

Topic B: Back Up Outlook Items

Topic C: Change Data File Settings 

 

 

Outlook 2 Overview

In this course, you will customize command sets, configure mail accounts, set global options, perform advanced searches, apply filters to intercept mail and control spam, create rules to automate many management tasks, work with calendars and contacts, manage tasks, protect data with archiving and data files, as well as share and delegate access to your workspaces.

This course builds upon the foundational knowledge presented in the Microsoft Outlook 1 course.

In addition, this course will help you prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Outlook. 

 

Audience

This course is intended for people who have a basic understanding of Microsoft® Windows® and want to know how to use Outlook’s advanced features to manage their email communications, calendar events, contact information, search functions, and other communication tasks.

Prerequisites

To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to open and close applications, navigate basic file structures, and manage files and folders. Additionally, it will benefit you to have basic Outlook skills. You can obtain these skills and knowledge by taking the following Training To YOU course Microsoft  Outlook 1.

Objectives

In this course, you will use Outlook’s advanced features to customize and manage your email communications, including using advanced features to organize emails; managing calendar settings and options; managing contact information; scheduling tasks; and managing Outlook backups and data file settings.

You will:

  • Modify messages and set global options.
  • Organize, search, and manage messages.
  • Manage your mailbox.
  • Automate message management.
  • Work with calendar settings.
  • Manage contacts and groups.
  • Manage activities by using tasks.
  • Share workspaces with others.
  • Manage Outlook data files.

 

Lesson 1: Modifying Messages and Setting Global Options

Topic A: Insert Advanced Characters and Objects

Topic B: Modify Message Settings and Options

Topic C: Configure Global Outlook Options

Topic D: Customize the Outlook Interface

 

Lesson 2: Organizing, Searching, and Managing Messages

Topic A: Group and Sort Messages

Topic B: Filter and Manage Messages

Topic C: Search Outlook Items

 

Lesson 3: Managing Your Mailbox

Topic A: Use the Junk E-Mail Filter to Manage Messages

Topic B: Manage Your Mailbox

 

Lesson 4: Automating Message Management

Topic A: Use Automatic Replies

Topic B: Use the Rules Wizard to Organize Messages

Topic C: Create and Use Quick Steps

 

Lesson 5: Working with Calendar Settings

Topic A: Set Advanced Calendar Options

Topic B: Create and Manage Additional Calendars

Topic C: Manage Meeting Responses

 

Lesson 6: Managing Contacts

Topic A: Import and Export Contacts

Topic B: Use Electronic Business Cards

Topic C: Forward Contacts

 

Lesson 7: Managing Activities by Using Tasks

Topic A: Assign and Manage Tasks

 

Lesson 8: Sharing Workspaces with Others

Topic A: Delegate Access to Outlook Folders

Topic B: Share Your Calendar

Topic C: Share Your Contacts

 

Lesson 9: Managing Outlook Data Files

Topic A: Use Archiving to Manage Mailbox Size

Topic B: Back Up Outlook Items

Topic C: Change Data File Settings 

 

 

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

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

PowrePoint Level 2 Overview

Meetings, instruction, training, pitches; these are all a part of our daily lives. We are often called upon to deliver presentations with little notice, at multiple venues, and with varying requirements. And, some of these presentations include sensitive information that needs to be guarded. Given all the variables, it may seem an overwhelming task to deliver your content, on time, to all audiences, and to only those who need to see it. Oh, and by the way, you need to make it interesting, informative, and memorable. So, how do you do it? Without the help of a robust set of tools, it would be nearly impossible. But Microsoft® Office PowerPoint® 2016 provides you with a variety of such tools that can help you deliver content in nearly any situation, while saving time and effort. By taking advantage of these tools, you will be creating presentations that not only stand out from the crowd, but also don't consume all of your available time.

 

Audience

This course is intended for students who have a foundational working knowledge of PowerPoint 2016, who wish to take advantage of the application's higher-level usability, security, collaboration, and distribution functionality.

 

Prerequisites

To ensure success, students should have experience using PowerPoint 2016, running within the Windows® 10 operating system, to create, edit, and deliver multimedia presentations.

 

Objectives

Upon completing this course, you will be able to customize the PowerPoint 2016 application, and effectively create, collaborate on, secure, and distribute complex multimedia presentations for a variety of situations.

You will:

  • Modify the PowerPoint environment.
  • Customize design templates.
  • Add SmartArt and math equations to a presentation.
  • Work with media and animations.
  • Collaborate on a presentation.
  • Customize a slide show.
  • Secure and distribute a presentation.

Lesson 1: Modifying the PowerPoint Environment

Topic A: Customize the User Interface

Topic B: Set PowerPoint 2016 Options

 

Lesson 2: Customizing Design Templates

Topic A: Modify Slide Masters and Slide Layouts

Topic B: Add Headers and Footers

Topic C: Modify the Notes Master and the Handout Master

 

Lesson 3: Adding SmartArt and Math Equations to a Presentation

Topic A: Create SmartArt

Topic B: Modify SmartArt

Topic C: Write Math Equations

 

Lesson 4: Working with Media and Animations

Topic A: Add Audio to a Presentation

Topic B: Add Video to a Presentation

Topic C: Customize Animations and Transitions

 

Lesson 5: Collaborating on a Presentation

Topic A: Review a Presentation

Topic B: Store and Share Presentations on the Web

 

Lesson 6: Customizing a Slide Show

Topic A: Annotate a Presentation

Topic B: Set Up a Slide Show

Topic C: Create a Custom Slide Show

Topic D: Add Hyperlinks and Action Buttons

Topic E: Record a Presentation

 

Lesson 7: Securing and Distributing a Presentation

Topic A: Secure a Presentation

Topic B: Broadcast a Slide Show

Topic C: Create a Video or a CD

 

Appendix A: Microsoft Office PowerPoint 2016 Exam 77-729

 

Appendix B: Microsoft PowerPoint 2016 Common Keyboard Shortcuts

PowrePoint Level 2 Overview

Meetings, instruction, training, pitches; these are all a part of our daily lives. We are often called upon to deliver presentations with little notice, at multiple venues, and with varying requirements. And, some of these presentations include sensitive information that needs to be guarded. Given all the variables, it may seem an overwhelming task to deliver your content, on time, to all audiences, and to only those who need to see it. Oh, and by the way, you need to make it interesting, informative, and memorable. So, how do you do it? Without the help of a robust set of tools, it would be nearly impossible. But Microsoft® Office PowerPoint® 2016 provides you with a variety of such tools that can help you deliver content in nearly any situation, while saving time and effort. By taking advantage of these tools, you will be creating presentations that not only stand out from the crowd, but also don't consume all of your available time.

 

Audience

This course is intended for students who have a foundational working knowledge of PowerPoint 2016, who wish to take advantage of the application's higher-level usability, security, collaboration, and distribution functionality.

 

Prerequisites

To ensure success, students should have experience using PowerPoint 2016, running within the Windows® 10 operating system, to create, edit, and deliver multimedia presentations.

 

Objectives

Upon completing this course, you will be able to customize the PowerPoint 2016 application, and effectively create, collaborate on, secure, and distribute complex multimedia presentations for a variety of situations.

You will:

  • Modify the PowerPoint environment.
  • Customize design templates.
  • Add SmartArt and math equations to a presentation.
  • Work with media and animations.
  • Collaborate on a presentation.
  • Customize a slide show.
  • Secure and distribute a presentation.

Lesson 1: Modifying the PowerPoint Environment

Topic A: Customize the User Interface

Topic B: Set PowerPoint 2016 Options

 

Lesson 2: Customizing Design Templates

Topic A: Modify Slide Masters and Slide Layouts

Topic B: Add Headers and Footers

Topic C: Modify the Notes Master and the Handout Master

 

Lesson 3: Adding SmartArt and Math Equations to a Presentation

Topic A: Create SmartArt

Topic B: Modify SmartArt

Topic C: Write Math Equations

 

Lesson 4: Working with Media and Animations

Topic A: Add Audio to a Presentation

Topic B: Add Video to a Presentation

Topic C: Customize Animations and Transitions

 

Lesson 5: Collaborating on a Presentation

Topic A: Review a Presentation

Topic B: Store and Share Presentations on the Web

 

Lesson 6: Customizing a Slide Show

Topic A: Annotate a Presentation

Topic B: Set Up a Slide Show

Topic C: Create a Custom Slide Show

Topic D: Add Hyperlinks and Action Buttons

Topic E: Record a Presentation

 

Lesson 7: Securing and Distributing a Presentation

Topic A: Secure a Presentation

Topic B: Broadcast a Slide Show

Topic C: Create a Video or a CD

 

Appendix A: Microsoft Office PowerPoint 2016 Exam 77-729

 

Appendix B: Microsoft PowerPoint 2016 Common Keyboard Shortcuts

Project 1 Overview

Welcome to Microsoft® Project 2016: Part 1. This course is designed to familiarize you with the basic features and functions of Microsoft Project Professional 2016 so you can use it effectively and efficiently in a real-world environment.

This course covers the critical knowledge and skills a project manager needs to create a project plan with Project 2016 during the planning phase of a project. In other words, if your supervisor assigns you to lead a project, this course will enable you to draft a project plan with Project 2016 and share it with your supervisor (and others) for review and approval.

 

Audience

This course is designed for a person with an understanding of project management concepts and who is responsible for creating and maintaining project plans. The course will give the student a fundamental understanding of Microsoft Project 2016 necessary to create and save project plans.

 

Prerequisites

To ensure your success in this course, you should have basic project management knowledge and skills. The following Logical Operations course can help you in meeting this requirement: Project Management Fundamentals (Second Edition). You should also have basic knowledge and skills for using any current Windows® operating system, preferably Windows 10.

 

Objectives

In this course, you will learn to create and engage in basic management of a project using Microsoft Project Professional 2016.

You will:

  • Identify project management concepts and navigate the Project 2016 environment.
  • Create and define a new project plan.
  • Create and organize tasks.
  • Manage resources in a project plan.
  • Finalize a project plan.

Lesson 1: Getting Started with Microsoft Project

Topic A: Identify Project Management Concepts

Topic B: Navigate the Microsoft Project 2016 Environment

 

Lesson 2: Defining a Project

Topic A: Create a New Project Plan

Topic B: Define a Project

Topic C: Assign a Project Calendar

 

Lesson 3: Creating and Organizing Tasks

Topic A: Add Tasks to a Project Plan

Topic B: Import Tasks From Other Programs

Topic C: Create a Work Breakdown Structure

Topic D: Define Task Relationships

Topic E: Schedule Tasks

 

Lesson 4: Managing Project Plan Resources

Topic A: Add Resources to a Project Plan

Topic B: Create a Resource Calendar

Topic C: Enter Costs for Resources

Topic D: Assign Resources to Tasks

Topic E: Resolve Resource Conflicts

 

Lesson 5: Finalizing a Project Plan

Topic A: Optimize a Project Plan

Topic B: Set a Baseline

Topic C: Share a Project Plan

Project 1 Overview

Welcome to Microsoft® Project 2016: Part 1. This course is designed to familiarize you with the basic features and functions of Microsoft Project Professional 2016 so you can use it effectively and efficiently in a real-world environment.

This course covers the critical knowledge and skills a project manager needs to create a project plan with Project 2016 during the planning phase of a project. In other words, if your supervisor assigns you to lead a project, this course will enable you to draft a project plan with Project 2016 and share it with your supervisor (and others) for review and approval.

 

Audience

This course is designed for a person with an understanding of project management concepts and who is responsible for creating and maintaining project plans. The course will give the student a fundamental understanding of Microsoft Project 2016 necessary to create and save project plans.

 

Prerequisites

To ensure your success in this course, you should have basic project management knowledge and skills. The following Logical Operations course can help you in meeting this requirement: Project Management Fundamentals (Second Edition). You should also have basic knowledge and skills for using any current Windows® operating system, preferably Windows 10.

 

Objectives

In this course, you will learn to create and engage in basic management of a project using Microsoft Project Professional 2016.

You will:

  • Identify project management concepts and navigate the Project 2016 environment.
  • Create and define a new project plan.
  • Create and organize tasks.
  • Manage resources in a project plan.
  • Finalize a project plan.

Lesson 1: Getting Started with Microsoft Project

Topic A: Identify Project Management Concepts

Topic B: Navigate the Microsoft Project 2016 Environment

 

Lesson 2: Defining a Project

Topic A: Create a New Project Plan

Topic B: Define a Project

Topic C: Assign a Project Calendar

 

Lesson 3: Creating and Organizing Tasks

Topic A: Add Tasks to a Project Plan

Topic B: Import Tasks From Other Programs

Topic C: Create a Work Breakdown Structure

Topic D: Define Task Relationships

Topic E: Schedule Tasks

 

Lesson 4: Managing Project Plan Resources

Topic A: Add Resources to a Project Plan

Topic B: Create a Resource Calendar

Topic C: Enter Costs for Resources

Topic D: Assign Resources to Tasks

Topic E: Resolve Resource Conflicts

 

Lesson 5: Finalizing a Project Plan

Topic A: Optimize a Project Plan

Topic B: Set a Baseline

Topic C: Share a Project Plan

Project 2 Overview

Welcome to Microsoft® Project 2016: Part 2. This course is designed to familiarize you with the advanced features and functions of Microsoft Project Professional 2016 so that you can use it effectively and efficiently in a real-world environment. In Microsoft® Project 2016: Part 1, you learned the basic features of Microsoft® Project 2016 during the planning phase of a project. Microsoft® Project 2016: Part 2 covers the advanced knowledge and skills a project manager needs to update a project plan in Project 2016 during the execution, monitoring, and controlling phases of a project. In other words, once your project plan is approved by the project sponsor, this course will enable you to manage the project so that it is completed on time, within budget, and according to scope.

 

Audience

This course is designed for students with an understanding of project management concepts who are responsible for creating and maintaining project plans. Target students will be looking to acquire the advanced knowledge and skills a project manager needs to update a project plan in Project 2016 during the execution, monitoring, and controlling phases of a project.

 

Prerequisites

To ensure your success in this course, you should have basic project management knowledge and skills. Additionally, you should be able to create a new project plan, manage time in a project plan, manage tasks in a project plan, manage resources in a project plan, and share a project plan using Microsoft Office Project 2016.

 

Objectives

Upon successful completion of this course, you will be able to manage an existing Microsoft Project 2016 project plan.

You will:

  • Update a project plan to reflect progress as you execute the project.
  • Monitor project progress in the project plan.
  • Adjust the project plan to control constraints.
  • Create project reports to share a project’s status.
  • Customize project settings and share customizations with other projects.

Lesson 1: Executing a Project

Topic A: Enter Task Progress

Topic B: Update Task Progress with SharePoint

Topic C: Update Work

Topic D: Update Costs

 

Lesson 2: Monitoring Project Progress

Topic A: View Project Progress

Topic B: Add Custom Fields

Topic C: Create Custom Views

Topic D: Create a Network Diagram

Topic E: Analyze a Project Plan

 

Lesson 3: Controlling a Project Plan

Topic A: Edit the Task List

Topic B: Reschedule Tasks

Topic C: Update a Baseline

 

Lesson 4: Reporting on Progress

Topic A: Format and Share a Chart View

Topic B: View Existing Reports

Topic C: Create Custom Reports

Topic D: Create a Visual Report

 

Lesson 5: Customizing the Application

Topic A: Change Project Options

Topic B: Create a Project Plan Template

Topic C: Share Resources

Topic D: Link Project Plans

 

Appendix A: Extending Project with Macros and Apps

Project 2 Overview

Welcome to Microsoft® Project 2016: Part 2. This course is designed to familiarize you with the advanced features and functions of Microsoft Project Professional 2016 so that you can use it effectively and efficiently in a real-world environment. In Microsoft® Project 2016: Part 1, you learned the basic features of Microsoft® Project 2016 during the planning phase of a project. Microsoft® Project 2016: Part 2 covers the advanced knowledge and skills a project manager needs to update a project plan in Project 2016 during the execution, monitoring, and controlling phases of a project. In other words, once your project plan is approved by the project sponsor, this course will enable you to manage the project so that it is completed on time, within budget, and according to scope.

 

Audience

This course is designed for students with an understanding of project management concepts who are responsible for creating and maintaining project plans. Target students will be looking to acquire the advanced knowledge and skills a project manager needs to update a project plan in Project 2016 during the execution, monitoring, and controlling phases of a project.

 

Prerequisites

To ensure your success in this course, you should have basic project management knowledge and skills. Additionally, you should be able to create a new project plan, manage time in a project plan, manage tasks in a project plan, manage resources in a project plan, and share a project plan using Microsoft Office Project 2016.

 

Objectives

Upon successful completion of this course, you will be able to manage an existing Microsoft Project 2016 project plan.

You will:

  • Update a project plan to reflect progress as you execute the project.
  • Monitor project progress in the project plan.
  • Adjust the project plan to control constraints.
  • Create project reports to share a project’s status.
  • Customize project settings and share customizations with other projects.

Lesson 1: Executing a Project

Topic A: Enter Task Progress

Topic B: Update Task Progress with SharePoint

Topic C: Update Work

Topic D: Update Costs

 

Lesson 2: Monitoring Project Progress

Topic A: View Project Progress

Topic B: Add Custom Fields

Topic C: Create Custom Views

Topic D: Create a Network Diagram

Topic E: Analyze a Project Plan

 

Lesson 3: Controlling a Project Plan

Topic A: Edit the Task List

Topic B: Reschedule Tasks

Topic C: Update a Baseline

 

Lesson 4: Reporting on Progress

Topic A: Format and Share a Chart View

Topic B: View Existing Reports

Topic C: Create Custom Reports

Topic D: Create a Visual Report

 

Lesson 5: Customizing the Application

Topic A: Change Project Options

Topic B: Create a Project Plan Template

Topic C: Share Resources

Topic D: Link Project Plans

 

Appendix A: Extending Project with Macros and Apps

Publisher Overview

Microsoft® Office Publisher is a desktop publishing software application capable of producing greeting cards, certificates, newsletters, and other printed publications. Publisher includes a large collection of templates that provide a great way to start a new publication. Publisher offers a large selection of "building blocks" that can be dragged into your documents, helping you to create page elements such as calendars, newsletter sidebars, and borders. Publisher integrates online sharing and mail merge features, which are handy when you need to send publications to a list of customers, and it's possible to export publications as HTML web pages or PDF documents. With a user-friendly interface, Publisher makes it easy to create and edit publications.

NOTE: This course presents information and skills that are appropriate for users of either the Office 2016 or Office 2019 desktop applications. However, the instructional environment for the delivery of this course utilizes Office 2016.

 

Audience

This course is intended for persons in a variety of job roles such as publishing specialists, layout specialists, graphic designers, or any other knowledge workers who need to use Microsoft Office Publisher to create, lay out, edit, and share publications.

 

Prerequisites

To ensure your success in this course, you should have experience with basic Microsoft® Windows® 10 tasks and be comfortable in the Windows 10 environment.

 

Objectives

In this course, you will create, format, edit, and share publications.

You will:

  • Perform basic tasks in the Microsoft Publisher interface.
  • Add content to a publication.
  • Format text and paragraphs in a publication.
  • Manage text in a publication.
  • Work with graphics in a publication.
  • Prepare a publication for printing and sharing.

Lesson 1: Getting Started with Microsoft Publisher 2016

Topic A: Navigate the Interface

Topic B: Customize the Publisher Interface

Topic C: Create a Publication

 

Lesson 2: Adding Content to a Publication

Topic A: Add Text to a Publication

Topic B: Add Pages and Picture Placeholders to a Publication

Topic C: Control the Display of Content in Text Boxes

Topic D: Apply Building Blocks to a Publication

 

Lesson 3: Formatting Text and Paragraphs in a Publication

Topic A: Format Text

Topic B: Format Paragraphs

Topic C: Apply Schemes

 

Lesson 4: Managing Text in a Publication

Topic A: Edit Text in a Publication

Topic B: Work with Tables

Topic C: Insert Symbols and Special Characters

 

Lesson 5: Working with Graphics in a Publication

Topic A: Insert Graphics in a Publication

Topic B: Customize the Appearance of Pictures

 

Lesson 6: Preparing a Publication for Sharing and Printing

Topic A: Check the Design of a Publication

Topic B: Save a Publication in Different Formats

Topic C: Print a Publication

Topic D: Share a Publication

 

Appendix A: Automating Communication Using Mail Merge

 

Appendix B: New Features in Publisher 2016/2019

Publisher Overview

Microsoft® Office Publisher is a desktop publishing software application capable of producing greeting cards, certificates, newsletters, and other printed publications. Publisher includes a large collection of templates that provide a great way to start a new publication. Publisher offers a large selection of "building blocks" that can be dragged into your documents, helping you to create page elements such as calendars, newsletter sidebars, and borders. Publisher integrates online sharing and mail merge features, which are handy when you need to send publications to a list of customers, and it's possible to export publications as HTML web pages or PDF documents. With a user-friendly interface, Publisher makes it easy to create and edit publications.

NOTE: This course presents information and skills that are appropriate for users of either the Office 2016 or Office 2019 desktop applications. However, the instructional environment for the delivery of this course utilizes Office 2016.

 

Audience

This course is intended for persons in a variety of job roles such as publishing specialists, layout specialists, graphic designers, or any other knowledge workers who need to use Microsoft Office Publisher to create, lay out, edit, and share publications.

 

Prerequisites

To ensure your success in this course, you should have experience with basic Microsoft® Windows® 10 tasks and be comfortable in the Windows 10 environment.

 

Objectives

In this course, you will create, format, edit, and share publications.

You will:

  • Perform basic tasks in the Microsoft Publisher interface.
  • Add content to a publication.
  • Format text and paragraphs in a publication.
  • Manage text in a publication.
  • Work with graphics in a publication.
  • Prepare a publication for printing and sharing.

Lesson 1: Getting Started with Microsoft Publisher 2016

Topic A: Navigate the Interface

Topic B: Customize the Publisher Interface

Topic C: Create a Publication

 

Lesson 2: Adding Content to a Publication

Topic A: Add Text to a Publication

Topic B: Add Pages and Picture Placeholders to a Publication

Topic C: Control the Display of Content in Text Boxes

Topic D: Apply Building Blocks to a Publication

 

Lesson 3: Formatting Text and Paragraphs in a Publication

Topic A: Format Text

Topic B: Format Paragraphs

Topic C: Apply Schemes

 

Lesson 4: Managing Text in a Publication

Topic A: Edit Text in a Publication

Topic B: Work with Tables

Topic C: Insert Symbols and Special Characters

 

Lesson 5: Working with Graphics in a Publication

Topic A: Insert Graphics in a Publication

Topic B: Customize the Appearance of Pictures

 

Lesson 6: Preparing a Publication for Sharing and Printing

Topic A: Check the Design of a Publication

Topic B: Save a Publication in Different Formats

Topic C: Print a Publication

Topic D: Share a Publication

 

Appendix A: Automating Communication Using Mail Merge

 

Appendix B: New Features in Publisher 2016/2019

Visio Level 1 Overview

From the earliest eras of human existence, visual images have been used to represent knowledge, data, and information. Beginning with the Paleolithic cave paintings and continuing to today’s most complex computer networks, these images leverage the ability of the human brain to rapidly perceive patterns and trends from visual representations.

In today’s workplace, visual diagrams are an essential part of communication, from road maps to sales flows to process charts. Microsoft® Visio® provides you with an intuitive, customizable tool to easily create a professional-looking visual product by using its extensive gallery of shapes. By following the exercises in this course, you will create visually engaging diagrams, maps, and drawings, using graphical elements to make information easier to comprehend.

 

Audience

This course is designed for persons who are new to Visio and who will be using Visio to create basic workflows and perform end-to-end flowcharting.

 

Prerequisites

To ensure your success, you will need to be familiar with using personal computers, including a mouse and keyboard. You should be comfortable in the Windows 8 environment and proficient in using Windows to access programs, navigate to information stored on the computer, and manage files and folders.

 

Objectives

In this course, you will design, modify, and manage basic diagrams. You will:

  • Identify the basic elements of Visio and their use.
  • Create a workflow diagram.
  • Build organization charts.
  • Design a floor plan.
  • Build a cross-functional flowchart.
  • Design a network diagram.
  • Style a diagram.

Lesson 1: Getting Started with Visio 2016

Topic A: Perform Basic Tasks in the Visio Environment

Topic B: Use Backstage Commands

Topic C: Save a File

 

Lesson 2: Working with Workflow Diagram Tools

Topic A: Use Drawing Components

Topic B: Modify a Drawing

Topic C: Insert Callouts and Groups

 

Lesson 3: Building Organization Charts

Topic A: Create an Organization Chart Manually

Topic B: Create Organization Charts by Using Starter Diagrams and the Organization Chart Wizard

Topic C: Modify an Organization Chart

 

Lesson 4: Designing a Floor Plan

Topic A: Make a Basic Floor Plan

Topic B: Model a Room Layout

 

Lesson 5: Building a Cross-Functional Flowchart

Topic A: Create a Cross-Functional Flowchart

Topic B: Format a Cross-Functional Flowchart

 

Lesson 6: Designing a Network Diagram

Topic A: Create Network Diagrams

Topic B: Use Shape Data

Topic C: Use Layers

 

Lesson 7: Styling a Diagram

Topic A: Modify Shape and Connector Styles

Topic B: Apply Themes and Variants

Topic C: Use Containers

 

Appendix A: New Features in Visio 2016

Word Level 1 Overview

These days, most people take electronic word processing for granted. While we may still write out our grocery lists with pen and paper, we expect to use a computer to create the majority of our documents. It's impossible to avoid word-processing software in many areas of the business world. Managers, lawyers, clerks, reporters, and editors rely on this software to do their jobs. Whether you are an executive secretary or a website designer, you'll need to know the ins and outs of electronic word processing.

Microsoft® Word 2016 is designed to help you move smoothly through the task of creating professional-looking documents. Its rich features and powerful tools can make your work easy, and even fun. In this course, you'll learn how to use Word 2016 to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents.

 

Audience

This course is intended for students who want to learn basic Word 2016 skills, such as creating, editing, and formatting documents; inserting simple tables and creating lists; employing a variety of techniques for improving the appearance and accuracy of document content.

 

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.

 

Objectives

In this course, you will learn fundamental Word 2016 skills.

You will:

  • Navigate and perform common tasks in Word, such as opening, viewing, editing, saving, and printing documents, and configuring the application.
  • Format text and paragraphs.
  • Perform repetitive operations efficiently using tools such as Find and Replace, Format Painter, and Styles.
  • Enhance lists by sorting, renumbering, and customizing list styles.
  • Create and format tables.
  • Insert graphic objects into a document, including symbols, special characters, illustrations, pictures, and clip art.
  • Format the overall appearance of a page through page borders and colors, watermarks, headers and footers, and page layout.
  • Use Word features to help identify and correct problems with spelling, grammar, readability, and accessibility.

Lesson 1: Getting Started with Word

Topic A: Navigate in Microsoft Word

Topic B: Create and Save Word Documents

Topic C: Manage Your Workspace

Topic D: Edit Documents

Topic E: Preview and Print Documents

Topic F: Customize the Word Environment

 

Lesson 2: Formatting Text and Paragraphs

Topic A: Apply Character Formatting

Topic B: Control Paragraph Layout

Topic C: Align Text Using Tabs

Topic D: Display Text in Bulleted or Numbered Lists

Topic E: Apply Borders and Shading

 

Lesson 3: Working More Efficiently

Topic A: Make Repetitive Edits

Topic B: Apply Repetitive Formatting

Topic C: Use Styles to Streamline Repetitive Formatting Tasks

 

Lesson 4: Managing Lists

Topic A: Sort a List

Topic B: Format a List

 

Lesson 5: Adding Tables

Topic A: Insert a Table

Topic B: Modify a Table

Topic C: Format a Table

Topic D: Convert Text to a Table

 

Lesson 6: Inserting Graphic Objects

Topic A: Insert Symbols and Special Characters

Topic B: Add Images to a Document

 

Lesson 7: Controlling Page Appearance

Topic A: Apply a Page Border and Color

Topic B: Add Headers and Footers

Topic C: Control Page Layout

Topic D: Add a Watermark

 

Lesson 8: Preparing to Publish a Document

Topic A: Check Spelling, Grammar, and Readability

Topic B: Use Research Tools

Topic C: Check Accessibility

Topic D: Save a Document to Other Formats

 

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

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

While middle managers are one of the most populous roles within many organizations, research indicates these leaders often describe themselves as lost, isolated, torn between multiple forces, and thus, lonely. In this workshop, participants will take a deep dive into the experience of loneliness and isolation of middle managers. Participants will gain insight into the mindset and perspectives of these leaders and will learn how to become not only management culture brokers and translators for their experiences, but also gain a toolbelt of skills around intervention and support of these critical leaders.

  • Explore reasons for loneliness and isolation in middle management
  • Gain insight into mindset and perspectives of these leaders
  • Gain a toolbelt of skills around intervention and support

 

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

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

SQL Querying Fundamentals Overview

Many organizations use databases to store their most critical information: the information that manages their day-to-day operations. After the data is stored in databases, however, it is useless unless you can retrieve it for further business analysis. One example of a database management system is Microsoft SQL Server 2012. The language you use to retrieve information from SQL Server 2012 databases is the Structured Query Language (SQL). This course, SQL Querying: Fundamentals, will teach you to use SQL as a tool to retrieve the information you need from databases.

 

Audience

This course is intended for individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.

 

Prerequisites

Basic end-user computer skills and some familiarity with database terminology and structure are required.

 

Objectives

In this course, you will compose SQL queries to retrieve desired information from a database.

You will:

  • Connect to the SQL Server database and execute a simple query.
  • Include a search condition in a simple query.
  • Use various functions to perform calculations on data.
  • Organize the data obtained from a query before it is displayed on-screen.
  • Retrieve data from multiple tables.
  • Export the results of a query.

Lesson 1: Executing a Simple Query

Topic A: Connect to the SQL Database

Topic B: Query a Database

Topic C: Save a Query

Topic D: Modify and Execute a Saved Query

Lesson 2: Performing a Conditional Search

Topic A: Search Using One or More Conditions

Topic B: Search for a Range of Values and NULL Values

Topic C: Search Data Based on Patterns

Lesson 3: Working with Functions

Topic A: Perform Date Calculations

Topic B: Calculate Data Using Aggregate Functions

Topic C: Manipulate String Values

Lesson 4: Organizing Data

Topic A: Sort Data

Topic B: Rank Data

Topic C: Group Data

Topic D: Filter Grouped Data

Topic E: Summarize Grouped Data

Topic F: Use PIVOT and UNPIVOT Operators

Lesson 5: Retrieving Data from Multiple Tables

Topic A: Combine the Results of Two Queries

Topic B: Compare the Results of Two Queries

Topic C: Retrieve Data by Joining Tables

Lesson 6: Exporting Query Results

Topic A: Generate a Text File

Topic B: Generate an XML File

Appendix A: The FullerAckerman Database

SQL Querying Fundamentals Overview

Many organizations use databases to store their most critical information: the information that manages their day-to-day operations. After the data is stored in databases, however, it is useless unless you can retrieve it for further business analysis. One example of a database management system is Microsoft SQL Server 2012. The language you use to retrieve information from SQL Server 2012 databases is the Structured Query Language (SQL). This course, SQL Querying: Fundamentals, will teach you to use SQL as a tool to retrieve the information you need from databases.

 

Audience

This course is intended for individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.

 

Prerequisites

Basic end-user computer skills and some familiarity with database terminology and structure are required.

 

Objectives

In this course, you will compose SQL queries to retrieve desired information from a database.

You will:

  • Connect to the SQL Server database and execute a simple query.
  • Include a search condition in a simple query.
  • Use various functions to perform calculations on data.
  • Organize the data obtained from a query before it is displayed on-screen.
  • Retrieve data from multiple tables.
  • Export the results of a query.

Lesson 1: Executing a Simple Query

Topic A: Connect to the SQL Database

Topic B: Query a Database

Topic C: Save a Query

Topic D: Modify and Execute a Saved Query

Lesson 2: Performing a Conditional Search

Topic A: Search Using One or More Conditions

Topic B: Search for a Range of Values and NULL Values

Topic C: Search Data Based on Patterns

Lesson 3: Working with Functions

Topic A: Perform Date Calculations

Topic B: Calculate Data Using Aggregate Functions

Topic C: Manipulate String Values

Lesson 4: Organizing Data

Topic A: Sort Data

Topic B: Rank Data

Topic C: Group Data

Topic D: Filter Grouped Data

Topic E: Summarize Grouped Data

Topic F: Use PIVOT and UNPIVOT Operators

Lesson 5: Retrieving Data from Multiple Tables

Topic A: Combine the Results of Two Queries

Topic B: Compare the Results of Two Queries

Topic C: Retrieve Data by Joining Tables

Lesson 6: Exporting Query Results

Topic A: Generate a Text File

Topic B: Generate an XML File

Appendix A: The FullerAckerman Database

SQL Querying Advanced Overview

In the course SQL Querying: Fundamentals, you learned the basics of SQL querying. Now that you have a foundation in how to query databases, you will learn in this course how to identify and use advanced querying techniques. In addition, you might find that you need to perform tasks such as modifying the structure of a table; inserting, updating, or deleting data; and indexing tables to optimize query performance. In this course, you will learn how to complete these tasks and more.

In today's competitive environment, information is one of the most important factors in determining the success of an organization. If you are able to manage and retrieve information efficiently, you can streamline the organization's processes and give it a competitive edge. As the organization grows, you will need to handle large amounts of data. Under such circumstances, you might need to query multiple tables simultaneously and with increasing frequency. You must step up the speed of generating query output to cope with the increasing demands of data storage, management, and retrieval.

 

Audience

Students should have basic computer skills, SQL skills, and be familiar with concepts related to database structure and terminology.

 

Prerequisites

To ensure your success, we recommend you first take the following Logical Operations courses, or have equivalent skills and knowledge:

  • SQL Querying: Fundamentals

 

Objectives

In this course, you will work with advanced queries to manipulate and index tables. You will also create transactions so that you can choose to save or cancel the data entry process.

You will:

    • Use subqueries to generate query output.
    • Manipulate table data by inserting and updating records in a table and deleting records from a table.
    • Manipulate the table structure.
    • Create views, manipulate data through views, modify the view structure, and drop views.
    • Create indexes on table columns and drop inefficient indexes.
    • Mark the beginning of a transaction, roll back a transaction, and commit a transaction.

Lesson 1: Using Subqueries to Perform Advanced Querying

Topic A: Search Based on Unknown Values

Topic B: Compare a Value with Unknown Values

Topic C: Search Based on the Existence of Records

Topic D: Generate Output Using Correlated Subqueries

Topic E: Filter Grouped Data Within Subqueries

Topic F: Perform Multiple-Level Subqueries

 

Lesson 2: Manipulating Table Data

Topic A: Insert Data

Topic B: Modify and Delete Data

 

Lesson 3: Manipulating the Table Structure

Topic A: Create a Table

Topic B: Create a Table with Constraints

Topic C: Modify a Table's Structure

Topic D: Back Up Tables

Topic E: Delete Tables

 

Lesson 4: Working with Views

Topic A: Create a View

Topic B: Manipulate Data in Views

Topic C: Create Aliases

Topic D: Modify and Delete Views

 

Lesson 5: Indexing Data

Topic A: Create Indexes

Topic B: Drop Indexes

 

Lesson 6: Managing Transactions

Topic A: Create Transactions

Topic B: Commit Transactions

 

Appendix A: The FullerAckerman Database

SQL Querying Advanced Overview

In the course SQL Querying: Fundamentals, you learned the basics of SQL querying. Now that you have a foundation in how to query databases, you will learn in this course how to identify and use advanced querying techniques. In addition, you might find that you need to perform tasks such as modifying the structure of a table; inserting, updating, or deleting data; and indexing tables to optimize query performance. In this course, you will learn how to complete these tasks and more.

In today's competitive environment, information is one of the most important factors in determining the success of an organization. If you are able to manage and retrieve information efficiently, you can streamline the organization's processes and give it a competitive edge. As the organization grows, you will need to handle large amounts of data. Under such circumstances, you might need to query multiple tables simultaneously and with increasing frequency. You must step up the speed of generating query output to cope with the increasing demands of data storage, management, and retrieval.

 

Audience

Students should have basic computer skills, SQL skills, and be familiar with concepts related to database structure and terminology.

 

Prerequisites

To ensure your success, we recommend you first take the following Logical Operations courses, or have equivalent skills and knowledge:

  • SQL Querying: Fundamentals

 

Objectives

In this course, you will work with advanced queries to manipulate and index tables. You will also create transactions so that you can choose to save or cancel the data entry process.

You will:

    • Use subqueries to generate query output.
    • Manipulate table data by inserting and updating records in a table and deleting records from a table.
    • Manipulate the table structure.
    • Create views, manipulate data through views, modify the view structure, and drop views.
    • Create indexes on table columns and drop inefficient indexes.
    • Mark the beginning of a transaction, roll back a transaction, and commit a transaction.

Lesson 1: Using Subqueries to Perform Advanced Querying

Topic A: Search Based on Unknown Values

Topic B: Compare a Value with Unknown Values

Topic C: Search Based on the Existence of Records

Topic D: Generate Output Using Correlated Subqueries

Topic E: Filter Grouped Data Within Subqueries

Topic F: Perform Multiple-Level Subqueries

 

Lesson 2: Manipulating Table Data

Topic A: Insert Data

Topic B: Modify and Delete Data

 

Lesson 3: Manipulating the Table Structure

Topic A: Create a Table

Topic B: Create a Table with Constraints

Topic C: Modify a Table's Structure

Topic D: Back Up Tables

Topic E: Delete Tables

 

Lesson 4: Working with Views

Topic A: Create a View

Topic B: Manipulate Data in Views

Topic C: Create Aliases

Topic D: Modify and Delete Views

 

Lesson 5: Indexing Data

Topic A: Create Indexes

Topic B: Drop Indexes

 

Lesson 6: Managing Transactions

Topic A: Create Transactions

Topic B: Commit Transactions

 

Appendix A: The FullerAckerman Database

Managing Microaggression Training: removing subtle acts of exclusion at work illuminates the blind-spots and understated actions that individuals, often unknowingly, take that can leave others with an experience of feeling excluded or “not heard”. Left unchecked, microaggressions negatively impact an organization’s culture, disrupts individual/team performance and ultimately obstructs leaders’ capacity to achieve promised business results.

Participants will leave this learning session with new practical approaches to identify and disrupt Subtle Acts of Exclusion in real time.

Outcomes:

  • You will discover a new approach to dealing with Microaggressions [Subtle Acts of Exclusion].
  • You will discover immediate actions you can take that will leave people with an authentic experience of being included.

Course Outline

  • Understanding Microaggression
  • The Impact of Microaggression
  • A New Approach: Subtle Acts of Exclusion
  • The Practice of Inclusion
  • Actions to Stop, Start & Continue

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

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

Did you know that science has shown that you can rewire your brain to be more positive just by thinking positive thoughts? Positive thinking helps prevent and control anxiety even during the most worrying of times. This training will uncover the power of a positive mindset and provide practical strategies for beginning your journey to a more positive you.

Outcomes:

  • Discover the power of positive thinking.
  • Learn innovative and creative ways to manage anxiety when worry and stress are apparent.
  • Explore your worry patterns and learn how to start an action plan to build your positive mindset.

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

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.

 

Understand the relationship between difficult behaviors and values. Understanding this relationship can help you explore steps for success when working with the ten most common difficult archetypes in the workplace. When difficult behavior leads to conflict, prepare to respond by establishing a healthy environment and follow our guide to switch from debate to dialogue.

Outcomes

  • Explore the ten most common archetypes of difficult behavior
  • Analyze the relationship between values and difficult behavior
  • Prepare to respond to conflict by establishing a healthy environment
  • Learn to switch from debate to dialogue

Course Outline

  • “Diagnosing” difficult archetypes
    • Exploring ten archetypes of difficult behavior
    • Understanding steps for success 
    • Impact of values on difficult behavior 
  • Prepare to respond to difficult archetypes
  • Shift from Debate to Dialogue
    • Mindset of Inquiry
    • Open-ended questions
    • Paraphrase 
    • Recommend
  • Case Studies

While there are basic business writing rules that apply to every situation, some situations require special adjustments. In this workshop, participants will learn practical tools for writing well in the most common situations. Topics covered include how to overcome writer’s block, how to filter your thoughts into only what you should say, and how to organize ideas for the greatest impact.

Outcomes

  • Overcoming writer’s block
  • Frameworks for daily communication 
  • Write to persuade and influence
  • Reporting clearly and effectively 

Course Outline

  • Three techniques to overcome writer’s block
  • A 5-step process for writing formal emails
  • Write emails for those who scan
  • Explore two frameworks for writing to persuade and influence
  • The 3P’s of progress reporting
  • Write reviews that engage and motivate