Module 5

Advanced Form Design Techniques 

• Designing Complex Forms 
• Creating “Keystroke-less” field controls 
• Adding Buttons and Drop-Down Lists for Navigation 

Using Switchboards (Menus) to Navigate Database Objects 

• Create a Main Switchboard 
• Design a Reports Switchboard 

Designing Macros to Automate Database Tasks 

• Create Macros to Open and Close Database Objects 
• Using Message Boxes to Inform Users 
• Automate Parameter Queries with Macros 
• View Related Records in Another Form with Macros 
• Hiding/Un-Hiding Field Controls with Macros 
• Use Macros to Validate Data Entry 

Introduction into Access Visual Basic for Complex Automation 

• Use Visual Basic to Secure Forms with Passwords 
• Create User Input Boxes 
• Use Logic Programming to Interpret Conditions 

Module 6

Linking Tables to Ensure Database Security 

• Place Tables in a Separate Database 
• Manage Tables with the Linked Table Manager 

Customizing Database Options 

• Set Startup Options 
• Applying the Compact and Repair Tool 

In our Access training courses, students will learn how to take control of their data with software training at Learnit. Our courses will teach you basic to advanced features of Access.

Whether you are new to Access or an advanced user, our Access training courses will cover what you need to know as efficiently as possible. Learnit offers world-class training for several versions, including 2016, 2013, 2010, 2007 and earlier.

Learning Outcomes: 

• Advanced Form Design Techniques 
• Using Switchboards to Navigate Database Objects 
• Designing Macros to Automate Database Tasks 
• Introduction into Access Visual Basic for Complex Automation 
• Linking Tables to Ensure Database Security 
• Customizing Database Options 

Module 3

How Table Relationships Affect Queries

• Creating Relationships Between Tables
• Add Relationship Security

Controlling Query Results with Join Types

• How Relationships Affect Query Results
• Using Join-Types to Affect Query Results

Creating Complex Queries with Multiple Criteria

• Applying Wildcards
• Using And / Or Conditions

Calculating Data with Queries

• Create Custom Fields with Calculations 
• Summarize Data with Grouping 

Module 4

Automating Queries with Parameters

• Creating Automated Requests for Criteria
• Using Wildcards in Parameter Queries
• Using Range Operators in Parameter Queries 

Using Query Wizards

• Getting Non-Matching Records with the Un-Matched Query Wizard
• Finding Duplicate Records with the Duplicate Query Wizard

Exploring Action Queries

• Create Tables with a Make-Table Query
• Add Records to a Table with an Append Query
• Change Data with an Update Query
• Delete Data with a Delete Query

Advanced Report Design Techniques

• Understanding Report Control Types
• Grouping Report Data
• Summarizing Report Data

In our Access training courses, students will learn how to take control of their data with software training at Learnit. Our courses will teach you basic to advanced features of Access.

Whether you are new to Access or an advanced user, our Access training courses will cover what you need to know as efficiently as possible. Learnit offers world-class training for several versions, including 2016, 2013, 2010, 2007 and earlier.

Outcomes: 

• How Table Relationships Affect Queries 
• Controlling Query Results with Join Types 
• Creating Complex Queries with Multiple Criteria 
• Calculating Data with Queries 
• Automating Queries with Parameters 
• Using Query Wizards 
• Exploring Action Queries 
• Advanced Report Design Techniques 

IT professionals, data analysts, database users and coordinators, managers and directors, and anyone who uses Access! Access Introduction level training is recommended.

Module 1

Introduction into How Databases Operate

• Exploring a Relational Database
• Examining Database Objects 
• How Data Is Related Between Tables 

Learning the Access Interface

• Examining Access Menu Tabs 
• Using the Access Navigation Pane 
• Using the Data View and Design View of an Object 

Creating A New Database

• Planning Steps to Create a New Database

Designing and Creating New Tables

• Create Tables in Design View
• Import Data from Excel

Entering Data into Tables

• Data Entry Techniques and Shortcuts 

Sorting and Filtering Data

• Re-arranging Records by Sorting 
• Hiding Records Using Filtering 

Introduction into Relating Table Data

• Using the Relationships Window 

Create Commonly Used Queries

• Using the Simple Query Wizard 
• Creating Queries in Design View 

Customizing Queries with Criteria

• Adding Criteria for Text, Number, And Date Fields
• Introduction into Using Wildcards in Criteria 

Module 2

Using Forms for Data Entry

• Creating Forms
• Exploring Different Form Layouts
• Perform Data Entry in Forms

Create Reports for Data Output

• Basing Reports on Queries 
• Previewing and Printing Reports 
• Understanding the Report Design Interface 
• Formatting Reports for Professional-Looking Output 

In our Access training courses, students will learn how to take control of their data with software training at Learnit. Our courses will teach you basic to advanced features of Access.

Whether you are new to Access or an advanced user, our Access training courses will cover what you need to know as efficiently as possible. Learnit offers world-class training for several versions, including 2016, 2013, 2010, 2007 and earlier.

Outcomes: 

• Introduction into How Databases Operate 
• Learning the Access Interface 
• Creating A New Database 
• Designing and Creating New Tables 
• Entering Data into Tables 
• Sorting and Filtering Data 
• Introduction into Relating Table Data 
• Create Commonly Used Queries 
• Customizing Queries with Criteria 
• Using Forms for Data Entry 
• Create Reports for Data Output 

IT professionals, data analysts, database users and coordinators, managers and directors, and anyone who uses Access!

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 1^st 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

Learn how to be an ally in the workplace with this important DEI training course.

Ally & Allyship: from awareness to action for all. This course moves participants beyond awareness to meaningful action. You'll learn how to actively use your power, position, or privilege to support and advocate for others. We'll cover key terms like Allyship, Privilege, and Opportunity Gap, and we'll distinguish the four types of allies that get things done. You'll gain practical skills for acting as an ally in various workplace situations, increase awareness of the unconscious barriers to authentic allyship, and create a more inclusive workplace by actively promoting allyship.

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.

What We’ll Explore:

• Develop practical skills for acting as an ally in various workplace situations. 
• Increase awareness of the unconscious barriers to authentic allyship.
• Create a more inclusive workplace by actively promoting allyship.

All levels of an organization, including staff-level, middle-management, and senior leaders who want to actively promote allyship and create a more inclusive workplace levels of an organization including staff-level, middle-management and/or senior leaders.

• Five components of emotional intelligence
• The impact of social cues
• Social presence in hybrid situations
• Communication considerations
• Case study: EI in a Hybrid Workplace

Foster a successful remote environment by understanding the importance of emotional intelligence in the workplace.

Technology has forever altered the way we relate to each other – and how we maintain relationships. Research continues to investigate how our emotional intelligence has changed as we’ve embraced more digital spaces. In this course, we will explore the research and discuss tools to keep you and your colleagues emotionally aware.

What We’ll Explore:

• Understand how technology affects emotional awareness
• Build and manage relationships in hybrid situations
• Be aware of common pitfalls in tech communication spaces

People managers, team builders, people strategists, L&D professionals, coaches

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

Upskill with Learnit and discover how to achieve behavior change by developing productive habits.

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.

What We’ll Explore:

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

This workshop is for everyone, from experienced managers, leaders to individual contributors. These individuals should be open to exploring their work habits and are ready to take on new routines to bring their management or team skills to the next level.

• Domains of Trust
• Empathy 
• Resisting micromanaging and creating a culture of inclusiveness
• Competence 
• Get things done for your team
• Authenticity: honest
• Lead with openness and sincerity

Develop effective leadership skills and learn how to build trust with your team.

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 will learn what to watch out for when applying these key traits.

What We’ll Explore:

• A focus on continual improvement
• Domains of trust
• Learnit’s THREAD model of trust

This training is a good fit for people managers, team builders, people strategists, L&D professionals, and coaches.

• Defining Visions
• Design thinking process for creating a vision
• Metaphorical thinking
• Intuitive thinking
• Motivators for vision writing

Learn key leadership skills to boost productivity and empower your team for success.

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

What We’ll Explore:

• Understand what a vision is and who it’s for
• Use creative thinking techniques to draft a vision
• Consider how to apply the vision for specific direct reports

People managers, team builders, people strategists, L&D professionals, coaches

• Learn a 3-step model to help you experience a fulfilling and meaningful career trajectory 
• Plot your career path using a ladder, lateral or lattice model 
• Learn which competencies are most important for director-level roles 
• Learn how coaching can help you become a more effective leader 
• Understand how your personal brand can help you advance your career and achieve your goals.

Take control of your professional trajectory and learn skills and frameworks to be empowered in your career growth.

Progressing from manager to director is a significant leap that requires a new set of skills. In this workshop, we begin by examining where your career is today and where you want it to be. Next, we look at ways to get you there, including introducing competencies essential for all leaders, coaching to unlock your full potential, and personal branding.

What We’ll Explore:

• Accurately assess where your career is today
• Understand what’s most important to you in your professional career
• Activate the competencies most essential for leadership roles
• Develop your personal brand to help you achieve your goals

Anyone who wants to advance their career will benefit from this workshop, especially managers and senior managers who want to become directors. Individual contributors, team leaders, and middle managers may also gain insight from the principles and practices discussed in this workshop.

• 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

Focus on your leadership training by developing coaching skills for managers.

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.

What We’ll Explore:

• 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

This workshop is designed for leaders, managers, and high-performing individual contributors that want to tap into their coaching potential.

Session 1

Run Psychologically Safe Meetings

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.

Session 2

Coaching for Managers

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.

Session 3

Give and Receive Feedback

Give and Receive Feedback is one of our foundational course geared towards managers that covers the basics of a subject many people find difficult. Participants explore a systems approach rooted in growth 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.

Session 4

Dealing with Conflict

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

Session 5

Increase Focus and Avoid Distractions

So, you’ve learned to plan your day by optimizing your schedule. You’ve blocked your calendar to accurately reflect the time you actually need to complete tasks. You’ve matched the different types of work you do with your energy peaks and valleys. Yet it is still a challenge to manage your time because the realities of the modern workplace will conspire to distract you. This course will help you maintain focus and stay on track. You will learn practical tools that can help you to better align your daily activities to accomplish your goals.

The extraordinary challenges presently faced by the business community call for strong and effective management skills. A skilled manager can lead the whole team forward. And like any skill, management skills can be learned.

The Emerging Leader cohort is a 5-week program (2-hour weekly learning sessions) of interactive workshops to equip emerging leaders with management skills they can use right away to help their teams grow and succeed.

What's included

• Five 2-hour virtual-led sessions
• 1 year unlimited access to our On-Demand library
• 3 peer-to-peer exercises
• Pre-class & post-class bonus material
• Certificate of completion
• Access to a private online community

This cohort is ideal for soon-to-be, new, or recently promoted managers who want to improve their management skills so that they can be more effective in their roles and lead their teams more confidently.

Session 1

Navigating Loneliness for Middle Managers

While middle managers are one of the most populous roles within many organizations, research indicates these leaders often describe themselves as lost, torn between multiple forces, isolated, 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 in organizational and interpersonal challenges middle managers face and create an individualized toolkit of practical solutions and actionable mindsets to navigate their own experience of loneliness.

Session 2

Performance Management: Fundamental Skills

This science-backed workshop explores the nuts-and-bolts of performance management with a focus on defining, planning and supervising goals that hit the sweet spot of challenging and doable (eustress). Participants will also learn frameworks for conducting effective performance reviews. Together with our other courses on managing teams such as Coaching for Managers and Giving and Receiving Feedback, this class rounds out a holistic approach to managing teams for performance and development.

Session 3

Inclusive Leadership Training

Inclusive Leadership Training: a practical approach to belonging at work provides practical strategies for leading and managing diverse teams in a way that fosters a culture of belonging. Our approach is grounded in the latest research on inclusive leadership and is designed to help you develop an inclusive mindset and put it into practice in your workplace.

Session 4

Build Trust with Your Team

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 will learn what to watch out for when applying these key traits.

Session 5

Making High-Quality Decisions

This course is for those who make important decisions. It is ideal for situations when you have time, resources, and the ability to aggregate multiple and, hopefully, differing points of view to arrive at the best possible decision. Easy to say, hard to do. Because all of us have a natural and automatic tendency to jump to conclusions, this class is meant to help you temper the rush to judgment with specific, actionable models that balance the benefits of clear-eyed deliberation with our equally beneficial faculty of human insight and intuition.

Now more than ever, people need managers they can trust and rely upon to inspire and lead them to be their best selves. On top of supporting their teams, managers are expected to plan, adapt, communicate and make things happen. For that, a leader must learn to lead with confidence.

Leading Today’s Workforce cohort is a 5-week program (2-hour weekly learning sessions) of interactive workshops where you will learn how to lead with confidence and effectiveness in today's complex world.

What's included

• Five 2-hour virtual-led sessions
• 1 year unlimited access to our On-Demand library
• 3 peer-to-peer exercises
• Pre-class & post-class bonus material
• Certificate of completion
• Access to a private online community

This cohort is recommended for leaders with some experience of managing teams. It’s ideal for anyone looking to take their managerial effectiveness to the next level or to acquire the skills necessary to effectively lead teams.

Session 1

Compelling Content

In this workshop, participants will hone their ability to determine what information should be presented, and how to structure the beginning, middle, and end of their presentation for clarity and engagement 

Coaching Session 1

During the coaching session, participants will practice creating well organized and logically structured presentations with feedback from the instructors and their peers. 

Session 2

Dynamic Delivery

In this workshop, participants will learn how delivery affects their audience, how to use non-verbal communication in an effective manner, and how to work with the visuals while presenting for an engaging experience. 

Coaching Session 2

During the second coaching session, participants will combine the delivery skills they’ve learned with their well-structured presentation to sharpen their presentation skills. 

Session 3

Confidence and Q&A

In the final workshop, participants will be introduced to mindsets that build confidence and strategies for facilitating effective Q&A sessions.

Engaging a crowd and championing an idea are highly sought after and valued skills. An adept presenter can structure their presentation and deliver it with the confidence necessary to effect change. You’ll learn to develop and hone these techniques to complement your skill set.

What's included

• Three 2-hour virtual led sessions
• Two small group coaching sessions
• 1 year unlimited access to our On-demand library
• 3 peer-to-peer exercises
• Access to a private online community
• Micro learning opportunities between sessions
• Pre-class & post-class bonus material
• Certificate of completion and digital badge
• Dedicated learning engagement specialist

This course is ideal for individuals who would like to improve their public speaking skills, and those who are presenting to managers and executives and would like to improve their ability to engage their audience.

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

Communicate across Cultures will improve your ability to cooperate and collaborate within a multicultural organization. One of the keys to doing this well is understanding how different cultures build trust and express themselves. Multiply this by unique the differences between individuals and organizations and you begin to see how complex working across cultures can become. This workshop will help you anticipate and adjust to some of the most significant cultural differences you might experience, so you can build strong, effective, and lasting, work relationships.

What We’ll Explore:

• 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

Anyone who is looking for ways to better communicate, collaborate, and work together within a multicultural organization, will benefit from this workshop, including individual contributors, middle managers, team leaders, senior managers, and senior leaders.

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 

Develop your people skills and improve your communication at work.

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.

What We’ll Explore:

• 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

This training is a good fit for anyone who works on or leads a team from individual contributors to managers.

• What is creative problem solving?
• How do you know if you need a creative solution?
• 5P’s: Questions to reframe the problem
• Apply Divergent Thinking
• Choose a solution by creating an idea matrix
• Implement and communicate a creative solution successfully

Upskill with Learnit and develop your problem solving and creative thinking skills.

Creative solutions sound appealing, but how do you know if they’re right for you? This workshop teaches you how to decide if you need a creative solution to your problem and offers several strategies for how to use creative thinking in the problem-solving process, ensuring that you get an innovative, unique and successful solution!

What We’ll Explore:

• Learn to think creatively in each step of the problem-solving process.
• Learn the simple four-step problem solving process.
• Learn to reframe problems.
• Learn to expand possibilities and narrow options with divergent and convergent thinking tools.

This course is designed for anyone who needs to develop innovative, out-of-the-box solutions for challenging problems, from individual contributors to senior leaders.

• Two systems of thinking 
• Applications of critical thinking 
• Self-Assessment 
• Evaluate Claims 
• Make Decisions 
• Solve Problems

Upskill with Learnit with important critical thinking training.

Critical thinking is an essential skill but one that is severely challenged by today’s heavy workloads and time constraints, leading us to frequently engage in rushed, impulsive, even irrational behavior. In this workshop, participants will learn how to minimize the cognitive biases and logical fallacies we susceptible to when evaluating claims, making decisions or solving problems.

What We’ll Explore:

• Assess your own personal biases 
• Evaluate the claims of others 
• Improved decision making 
• Arrive at rational solutions to problems

This workshop is ideal for individual contributors, middle managers, and senior leaders who are interested in examining their own biases and logical fallacies in order to arrive at more rational conclusions.

• What is conflict?
• Perceived threats
• Using conflict analysis to choose your behavior
• The 4 steps to responding to conflict
• How to reformulate your position
• Compromise or collaborate
• Own your actions

Focus on your conflict resolution skills to learn how you should be dealing with conflict in the workplace.

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

What We’ll Explore:

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

This training is best suited to anyone who deals with conflict, not just disagreement, on a regular basis. It’s ideal for managers but will be a good fit for anyone, from individual contributors to leaders

• Exploring value proposition 
• Keys to empathetic conversations
• Understanding win/win
• Feel-Felt-Found: Handling objections and resistance 
• Structured persuasion
• The power of “I recommend” 
• How to say no without gaining a reputation 

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.

What We’ll Explore:

• 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

Solid skill development for client experience representatives, salespeople, and client-facing associates.

• Two important areas of the brain related to emotional intelligence 
• Interoception, Emotional Granularity, and Mindfulness to enhance your emotional intelligence 
• Find meaning in your emotions to manage your response 
• Explore alternatives by focusing on your beliefs 
• Harness your emotions to achieve your goals and aspirations

Develop your emotional intelligence skills by focusing on self-awareness training.

In this workshop, participants will gain a deeper understanding of what emotional intelligence is, why it matters, and how to develop it. The course is built on two emotional intelligence pillars: self-awareness and self-management, and draws from the latest research and trends in emotional intelligence, including interoception and emotional granularity. Participants will leave with enhanced insight and perspective about their own emotional experience and how to navigate that experience in the workplace and in their personal life.

What We'll Explore:

• Explore what emotional intelligence is and why it matters 
• Overview of a model to help you enhance your emotional intelligence 
• Learn ways to recognize, understand, and manage your emotions 
• Discover the meaning you attach to your emotions 
• Manage and control how we respond when we’re triggered

Anyone who is curious about ways to better understand their own emotional experience, as well as ways to positively affect others through a deeper understanding and practice of emotional intelligence, will benefit from this workshop, including individual contributors, middle managers, team leaders, senior managers, and senior leaders.

Module 5: Advanced Functions

Learning Outcomes:

1. Use Database Functions: XLOOKUP(), SUMIF(), and AVERAGEIF()
2. Fix errors using auditing, or handle inevitable errors with backup values
3. Apply data cleanup and isolation/consolidation techniques.

Topics:

• Creating and Applying Names In A Worksheet
• VLOOKUP Function
• XLOOKUP Function
• ROUND function
• Using the Formula Auditing Tools
• Using the IF Function and Nesting Functions
• Using the IFERROR Function
• Summary Based Functions: SUMIF(S), COUNTIF(S), AVERAGEIF(S)
• Text Functions: LEFT, RIGHT & MID
• CONCAT function and Text-To-Columns Feature

Module 6: Using the "What If" Analysis Toolpack & Implementing Macros

Learning Outcomes:

1. Find optimal values for a single cell or a set of inter-related cells. 
2. Create and run basic macros to automate repetitive tasks.
3. Add macros to the Excel ribbon

Topics:

• Using the Data Consolidation Tool 
• Using the Goal Seek Tool
• Using the Solver Tool
• Using the Scenario Manager
• Recording and Running Macros
• Understanding the Macro/VBA Developer Interface
• Editing Macros with the Visual Basic Editor
• Adding Buttons to Run Macros From the Ribbon

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.

Database Features. You may be thinking “I use spreadsheets, not databases!” — but there are a few indispensable Excel features that mirror the most useful of features from the world of databases: lookups and aggregate functions. A “lookup” in Excel is when your formula looks up values in a secondary worksheet (just like a database!) and puts them in the primary worksheet: for example, looking up in worksheet B the inventory amount adjacent to a cell containing a particular SKU, and putting it in worksheet A, adjacent to the cell containing that same SKU. Likewise, the SUMIF(), COUNTIF(), and similar Excel functions are counterparts of “aggregate data” calculations in databases – useful, for example, if you wanted to sum up the order values shipped to a particular zip code.

Errors. You’ve probably encountered your fair share of errors that Excel has vociferously pointed out with: “#N/A” and “#NUM!” It turns out there’s an easy way to deal with these errors, either by intercepting them and providing a backup value, or by auditing and fixing them once and for all. We’ll show you the two surefire methods of handling these errors.

Finding the Right Value(s). Sometimes you need to measure variations in a single cell value, like product price, to optimize the value of another cell, like profits. Other times, you need to optimize multipleinterconnectedcells, like price, volume, and inventory – to find the optimal value for profits. These two what-if scenarios are handled by the “Goal Seek” and “Solver” functions in Excel. Get ready to impress your boss.

Macros. These are recorded steps that can be memorized for later playback. For example, if you find yourself splitting text into columns along a delimiter and then conditionally formatting certain rows, you might want to record those steps and then instantly reapply them to a new table. These steps are saved in Excel's internal programming language, VBA (Visual Basic for Applications). Once you've recorded your steps, you can dive into the behind-the-scenes VBA code that activates those steps and customize them even further.

Pro Techniques. On your way to becoming an Excel pro, you’ll need a toolkit of useful standard tips, tricks, and techniques. Among these, you’ll probably find that functions such as LEFT(), MID(), and Excel’s Text-To-Columns and Consolidating Data features are the ones you’ll use the most often. We’ll show you why those are so popular and how to use them.

This class is for users familiar with primary Excel features but who need more powerful features like lookups, error-handling, macros and scenario analysis.

Module 3: List/Table Essentials & Charting 

Learning Outcomes:

1. Create tables to help make analyzing large data sets easier with table tools
2. Using Filters and Sorting tools on a data sets show the data you are looking for
3. Create and save visuals and charts for data sets

Topics:

• 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

Module 4: Pivot Tables, Protecting & Linking Data

Learning Outcomes:

1. Find discoveries within data sources using PivotTables
2. Create Pivot Charts out of PivotTables for visual representations of reports.
3. Protect and lock worksheets and workbooks to restrict users.

Topics:

• Creating Pivot Tables From Lists Or Tables
• Office 365 Pivot Table Enhancements
• Filtering Pivot Tables
• Multi-Select Slicers
• Working With Pivot Charts
• Data Validation Rules
• Applying Built In Conditional Formatting
• Creating Custom Conditional Formats
• Comments
• Linking Data
• Cell, Sheet, And File Protection

Mastery of Excel is developed in stages: first you learn basic formatting, functions and formulas, and build a few spreadsheets yourself. Easy enough. But moving to the next level of proficiency is hard! To create truly professional-looking spreadsheets, you'll need to know how to organize data into elegant, interactive tables that dynamically generate colorful charts and graphs. To bring you up to an intermediate-level usage of Excel, we'll train you in how to use these core features:

• Advanced Tables. Beyond organizing data in rows and columns, we'll show you how to create filters that display only certain rows: for example, all the rows where the "City" column is set to "New York." You'll also learn how to sort entire tables based on values in one or more columns: for example, sorting customers by annual revenue. You'll learn how to instantly colorize, stripe, filter and subtotal a simple table of data using Excel's ever-popular "Format As Table" feature.
• Charts. Excel has 10 major chart types, everything from basic line charts to scatter plots. We'll show you how to add impressive data visualizations to your spreadsheets: line charts, bar graphs, pie charts, and more.
• Pivot Tables. One of Excel's most powerful — and least understood — features, pivot tables auto-magically convert static rows and columns of data into a responsive table that will re-organize itself to instantly display subtotals, averages, or other aggregate functions — depending on which fields you choose. Instead of creating 3 different tables to see sales by customer rep, customers by city, and revenue by state, you'll learn how to create a single pivot table to display all 3 sets of information in one place, based on your selection of different field groupings. You'll also learn how to generate pivot charts from the data.
• Tips & Tricks. The training also covers a few techniques we've selected as the most useful in your journey toward Excel mastery. These include "conditional formatting": coloring cells based on their values (e.g., heat maps); removing duplicates (common in data cleanup); data validation: preventing anything except certain data types (e.g., dates) being entered in a cell; and cell protection: preventing accidental typing into a cell with a formula.

After Intermediate Excel, you'll be ready for advanced Excel training.

This class is for those who already use functions, formulas and cell references — but want to enhance their spreadsheets with responsive tables, advanced charts and pivot tables.

Module 1: Excel Essentials & Formulas and Functions

Outcomes:

• Be able to Navigate Excel and create spreadsheets
• Be able to use excel's basic functions (sum, max, min, avg)
• Select cells and sheets using keyboard shortcuts

Topics:

• Introduction to the Excel Interface
• Search & Help
• Smart Lookup
• Zooming
• Navigating and Selecting Cells
• Keyboard Shortcuts
• Deleting/Replacing Cell Data
• Performing Simple Calculations
• Saving the Workbook File
• Overview of The Formulas Ribbon
• Building Basic Formulas
• Using Simple Functions
• Formulas/Functions with the Autofill Command
• Relative and Absolute Cell References

Module 2: Formatting, Spreadsheet Design, Page Setup & Printing

Outcomes:

• Be able to edit a spreadsheet by adding columns and rows
• Creating reusable fonts, and formats in workbooks by saving them as templates
• Adjust settings for workbook so its suitable for printing? using print options in Excel

Topics:

• Inserting Rows & Columns
• Moving, Copying and Pasting Data
• Using Autofill to Complete A Series of Values
• Formatting Worksheet Data/Using Cell Styles
• Introduction to Worksheet Themes
• Creating Custom Templates
• Managing Worksheets: Inserting, Deleting, Renaming, Move/Copy
• Grouping Worksheets
• Freezing or Splitting Panes
• Grouping and Hiding Rows/Columns
• Creating Custom Views
• Spell Checking Your Worksheets
• Setting Print Options
• Using the Page Layout View
• Printing Your Worksheet

Feel like you're the only person who doesn't know Excel and worried about getting up to speed? You're not alone, and we can help! Our Excel Introduction class leads you, step-by-step, through the basics of this popular spreadsheet program. There's plenty of time for practice and hands-on exercises to cement your new knowledge.

As we go through the training, you'll recognize — and finally understand — the very same features you've seen in Excel spreadsheets at work. By the end of this class you'll be making those kinds of spreadsheets yourself, documents such as:

• Lists. These could be lists of employees, products, customers, or anything else... Lists take advantage of Excel's formatting in rows and columns. You'll learn how to format and freeze table headers; change fonts, sizes and colors; and set printing specs.
• Tabulations. Excel is great at number-crunching and offers a slew of arithmetic functions you can apply to your data, like averages, sums, and counts.
• Computations. Typically financials, these could be budgets, income statements, invoices, tax computations or similar. These spreadsheets contain values that are tied together by formulas so that changing one instantly changes the others: for example, the same way changing revenue immediately flows through to a change in profits. The key to creating these tied-together spreadsheets is learning how to correctly reference the spots where data is kept ("cells") using formulas in other cells.

After Excel Introduction, you'll be ready for some of our other Excel classes. 

This Excel Introduction class is for anyone who would like to learn how to build and format spreadsheets with functions and formulas between cells.

Module 1: Creating and Managing Pivot Tables

Learning Outcomes:

1. Organize and clean data in spreadsheets for pivot table analysis

2. Manage and update pivot table source data to display new values

3. Edit pivot table report formats and settings

Topics:

• Organizing Data
• Inserting Pivot Tables
• Data Categories
• List Design Guidelines
• Data Normalizing Strategies
• Common Data Mining Techniques
• Standardizing Data
• Adding Related Data with VLOOKUP Function
• Managing Pivot Tables
• Naming Pivot Tables
• Refreshing and Changing Pivot Table Data
• Layering Fields of Data
• Filtering and Slicing Pivot Table Data
• Functions and Number Formats
• Show Details of Specific Pivot Table Results
• Creating Pivot Charts
• Pivoting Data Fields
• Basic Chart Formatting
• Filtering and Slicing Pivot Chart Data

Module 2: Advanced Pivot Table Strategies Custom Pivot Table Design

Learning Outcomes:

1. Use Power Pivot to connect data sources

2. Format default layouts for pivot table reports

3. Create a data model and pull data in from various tables for pivot table analysis

Topics:

• Analysis Tables vs. Data Lists
• Choosing Report Layouts
• Using and Creating Table Styles
• Subtotals and Grand Totals
• Pivot Table Options
• Calculated Fields and Items
• Power Pivot
• Data Modeling Basics
• Adding Data to Model
• Creating Relationships
• Designing Measures
• Adding Custom Columns
• Using Basic DAX Expressions
• Power Pivot Tables
• Creating Power Pivot Tables
• Preview of Power Query & Power BI

Pivot tables are arguably Excel's most powerful feature, and most likely to impress your boss. At first glance, pivot tables seem quite mysterious: with a quick drag-and-drop, your data somehow reorganizes itself into interesting groupings and useful totals. There are more than a few organizations whose critical business decisions rely on carefully designed pivot tables. Unfortunately, because they accomplish so much behind the scenes" it's hard to figure out how pivot tables actually work — and scary to try to modify existing ones. That's where our trainers come in: they love nothing more than demystifying tricky features like pivot tables. After this class, you'll be the one creating pivot tables to capture insights about your company's data. Here's what you'll learn:

• Cleanup. The data in your spreadsheet needs to meet certain criteria before it can be turned into a pivot table. We'll show you how to clean the data, designate the cells you want to become a pivot table, place it exactly where you want, and format it nicely in color.
• Manipulation. The advantage of a pivot table is being able to entirely rearrange your view of the data with nothing more than a few mouse clicks. For example, which is more useful: orders by city, revenue by customer, or orders by salesperson? Being able to easily switch these parameters — within the same worksheet — is what makes pivot tables so useful.
• Aggregate Functions. Seeing different views of the data is only useful if you can summarize (aggregate) information about that data: what were the totals, averages, medians and counts for each different view of the data? We'll show you how to apply these functions and filter the results to find the true insights.
• Pivot Charts. As with normal tables of data, it's helpful to create charts that illustrate the pivoted views of the data. We'll show you how to present the data from pivot tables in colorful visualizations (unless you prefer black and white).
• Big Data and "Power" Features. Excel has a limit of only one million rows, and if you've ever tried using them all, your computer probably slowed to a crawl. Enter the family of "Power" features: Power Query, Power Pivot, Power View, Power Map, and Power BI. These features allow you to import hundreds of millions of rows of data — even from multiple databases simultaneously — and use them in a spreadsheet. We'll show you how to get this so-called "big data" using Power Query and then apply calculations using Power Pivot. Ultimately, you'll be able to turn them into pivot tables, pivot charts and other data visualizations.

This class is for users familiar with standard Excel features but who need more efficient and powerful ways of manipulating their data. Others may have inherited pivot tables, and want to understand and modify them.

Module 1: Advanced Lookups and Pivot Tables

Learning Outcomes:

1. Look up values between worksheets based on matching criteria and resolve common errors.

2. Apply logical functions to have Excel make decisions about what values to return.

3. Enhance your pivot tables with a suite of advanced features.

Topics:

Advanced Lookup and Related Useful Functions

• XLOOKUP and VLOOKUP Functions
• Troubleshooting with IFERROR for Secondary Lookup Table
• Two-way Lookup with INDEX and MATCH
• Using IF Logic to Choose Return Values
• Core Date and String Functions: MONTH, TEXT, MID

Advanced Pivot Table Techniques

• Report Page Filters
• Building Outside Formulas
• Calculated Items and Fields
• Grouping: by Date and Manually
• Alternate Data Views with "Show Values As" Menu
• Timelines and Slicers

Module 2: Arrays, Advanced Charts and Macros

Learning Outcomes:

1. Create array functions for complex searches and calculations.

2. Set up, edit, and manage Excel charts

3. Create and modify a macro library for repetitive tasks in Excel

Topics:

Arrays

• Creating Array Formulas for Single Value Output
• Array Formulas for Multiple Value Output
• Useful Array Functions

Advanced Conditional Formatting

• Highlighting an Entire Row
• Highlighting Based on Logical Tests
• Implementing Banded Rows

Advanced Charting

• Recommended Charts
• Choosing Appropriate Charts for Different Data Types
• Combo Charts
• Wrangling Existing Charts to Display What You Want

Macros

• Recording Macros
• Saving Macros to your Personal Macro Workbook
• Accessing and Editing Your Macros
• Using the "Step Into" Feature with the VBA Editor to Debug
• Saving a Workbook Containing VBA Script

Even if you're already a "power user" with a few pivot tables under your belt and a good grasp of charts and other standard Excel topics, there are a few next-level features and techniques that truly distinguish the Excel pros. With a little guidance from one of our amazing trainers, these features won't be hard for you to pick up and will significantly enhance your spreadsheets:

Lookups. In a database like MS Access you can look up data by joining tables along shared fields, like a customer ID in both the Customers and Orders table. This feature also exists in Excel: you can look up values in one worksheet and put them in another worksheet based on a related field: for example, look up the sales figure adjacent to a cell containing "January" in worksheet B, and put it into worksheet A adjacent to the cell containing "January." We'll show you how to do this and troubleshoot common problems.

Pivot Table Enhancements. Need to customize a pivot table to add extra info? Excel provides a number of features to add calculated values, and data groupings into otherwise vanilla pivot tables. To help users change the way your pivot table displays, you can add timelines and "slicers" to select only certain types of data or specific date ranges.

Charts and Advanced Formatting. The choice of chart type can make a huge difference in how easy it is to glean insights from your data. We'll show you how to choose the right charts based on your data. Have two types of data in the same chart (e.g., temperature and rainfall) with different units? You'll learn how to add secondary axes using "combo charts" and get them to display exactly as you want. Along the way you'll master some advanced conditional formatting rules.

Macros and VBA. Macros are recorded steps that can be memorized for later playback. For example, if you find yourself formatting all your tables the same way (frozen header rows, banded rows and thin gray border), you might want to record those formatting steps and then be able to reapply them to any new table. These steps are actually saved in Excel's internal programming language, VBA (Visual Basic for Applications). Once you've recorded your steps, you can dive into the behind-the-scenes VBA code that activates those steps and customize them even further.

This class is for users who are already proficient in formulas, functions, cell references, charts, and basic pivot tables.

Learning Outcomes:

1. Understanding How Excel, VBA, and the Coding Editor Fit Together
2. Getting Around the Visual Basic Coding Editor
3. Accessing and Manipulating Excel Objects
4. Using Variables, Control Structures, Loops and Subroutines
5. Getting User Input and Creating Custom Dialog Boxes
6. Debugging and Error Handling

Day 1 Topics:

Introduction to VBA Usage and Terminology

• Defining VBA and What It Can Do
• Comparing Macros vs. Programming
• Exploring the Visual Basic Editor Tool
• Activating and Using the Developer Tab

Programming Basics

• Understanding VBA Syntax and Help Resources
• Creating VBA Sub Procedures
• Getting Information with Input Boxes
• Delivering Information with Message Boxes
• Using Variables for Flexibility
• Understanding Scope of Variables and Procedures
• Defining and Using Functions and Sub Procedures

Creating Decision Structures

• Understanding How a Decision Structure Interprets Conditions
• Using IF…Then Statements
• Creating IF… Then… ElseIF Statements
• Applying Select Case Statements

Day 2 Topics:

Creating Looping Structures

• Using Loops to Repeat Processes
• Implementing a Fixed Iteration Loop
• Creating Infinite Loops
• Using Loops with Workbook Objects

Designing Custom Dialog Boxes

• Creating User Forms to Collect Data
• Using the Form Object Designer Tool
• Connecting Forms to Events in the Workbook
• Processing Collected Data with VBA

Debugging and Error Handling

• Examining Programming Errors
• Using VBA Debugging Tools
• Applying Error Handling within VBA Code

Sooner or later, every Excel user runs into a problem that can’t be solved with a built-in function or feature. What if, for example, you had a worksheet with 20 cities and you wanted to put their current temperatures in each adjacent cell. There’s no feature for that in Excel! That’s where Visual Basic for Applications (“VBA”) comes in. VBA is a programming language built right into Excel and other MS Office applications. You can write VBA code to grab parts of Excel (cells, rows, menus, etc.) — and even data from the web — and programmatically change their values. You can also change their properties: sizes, colors, fonts, etc. Automating repetitive tasks is another popular use of VBA.

The Coding Environment. Microsoft provides a separate free app to help you write code, the “Visual Basic Code Editor.” You can launch it right from Excel. It has features for organizing your code, giving you hints about what the functions should look like, and debugging your program while watching it run, step-by-step.

Programming Basics. Don’t worry if you haven’t written code before. Microsoft has gone out of its way to make VBA as simple as possible. We’ll cover the basics (no pun intended) of coding: grabbing onto Excel cells and changing their properties, getting input from the user, tracking changeable values in “variables,” executing different chunks of code depending on if-this-then-that decisions, and repeating a chunk of code multiple times.

Interacting with your User. The power of VBA becomes clear when you can ask the person looking at your spreadsheet to click on a button, have a nice-looking form pop up, and let them type in some data or choose options from a dropdown box — and then have your custom VBA code process that data and make intelligent updates to the underlying spreadsheet. We’ll show you how to build those forms, visually, with a drag-and-drop editor.

Error Handling. Coding errors are about as inevitable as death and taxes. Fortunately both the code editor and the VBA language itself provide a number of ways to ease the burden of debugging, whether it’s stepping through your code and executing it line-by-line or by anticipating errors in advance and providing alternate chunks of code to execute. Having good debugging skills and mastery of the tools is critical.

This class is for Excel users who need to add interactive features and automations to their workbooks and spreadsheets.

Learning Outcomes:

1. Be able to clean up data into well-defined lists and convert them to tables

2. Use Excel’s aggregate functions to conditionally apply summary calculations to the data

3. Display data in summarized formats using pivot tables and with visuals using pivot charts

Topics:

Analyzing Data in Lists and Tables

• Cleaning data into a well-defined list 
• Sorting and filtering records 
• Formatting as a table 
• Totaling rows 
• Removing duplicates 
• Applying conditional formatting 

Summary Based IF Functions 

• IF 
• SUMIF
• AVERAGEIF
• COUNTIF

Chart Features

• Creating charts 
• Inserting sparklines 

Working with Pivot Tables and Pivot Charts

• Creating a pivot table 
• Sorting and filtering 
• Summarizing values by fields
• Formatting numeric data
• Adding slicers
• Creating pivot charts 

Beyond simple averages and totals, Microsoft Excel offers many features to help you draw insights from your data. Sometimes those observations come from a particular formatting or visualization of the data; other times a specific summary function will generate a surprisingly significant result. Here are some of the techniques you'll learn:

Table Formatting. Cleaning up your data involves tasks like removing duplicates, eliminating empty rows, and making sure data types are correct. Once you have a well-formatted table, you can take advantage of Excel's many features to sort, filter, and colorize it — revealing hidden patterns.

Conditional Functions. You may have data that you want to exclude from your calculations: for example, too-low or too-high outliers, or relating to discontinued products, or months with sales promotions. To exclude this data from your summaries, you can use functions like SUMIF, AVERAGEIF, and COUNTIF — applying them to exclude data that doesn't meet certain criteria.

Charting. Whether it's a pie chart, line graph, or scatter plot, "a picture is worth a thousand words." It's critical to choose the right type of chart to visualize your data so the viewer can quickly make sense of it. We'll show you how to decide which chart works best with your data.

Pivot Tables. Many spreadsheets follow a pattern with a few heading fieldsand many rows based on one field, like order number (sales tables) or product SKU (inventory tables). In the case of sales data, a table will typically have column headers like location, quantity, order number, price, and such. Each row might represent one order. Turning a typical table like this into a pivot table allows you to quickly change the way you 1) view the data: orders by date vs. orders by location; and 2) group the data for aggregate functions: total orders by location, average quantity by order, etc. It's one of Excel's most powerful tools, and can be used in conjunction with pivot charts to easily visualize your data along different dimensions.

This beginner data analysis course is designed for Excel users who need to analyze, summarize and visualize their data. Basic knowledge of Excel is recommended: familiarity with formulas, cell referencing, and simple functions like SUM and AVERAGE.

• Where does time go?
• Efficiency vs effectiveness
• Pareto principle
• Energy peaks and valleys
• How do I regulate it? 
• REP Plan 
• The Planning Fallacy
• How do I get there?
• Calendar blocking

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 plan and execute all that you must accomplish on any given day. 

What We’ll Explore:

• Becoming aware: Thinking realistically about time
• Regulating your time: Methods to prioritize and organize
• Business application: Tools to manage your time 

Individual contributors and mid-level and senior leaders who are seeking to increase their abilities to thrive in chaotic, unpredictable environments will benefit from this workshop.

• Intro to the FOR-Growth Model for giving impactful feedback 
• Practice the FOR part of the model on positive and constructive feedback situations
• Learn to refine FOR with the 4 Growth steps 
• Practice the complete model on real-life situations 
• Learn to turn the feedback you receive into FOR-Growth feedback 
• Create a positive, reinforcing loop of giving and receiving feedback 

Give and Receive Feedback is one of our foundational course geared towards managers that covers the basics of a subject many people find difficult. Participants explore a systems approach rooted in growth 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.

What We’ll Explore:

• Define and prioritize growth when giving feedback 
• Learn and practice our FOR-Growth feedback model through the lens of situational understanding 
• Learn to reverse engineer the feedback you receive to turn it into FOR-Growth feedback

This is a foundational Learnit training, one that is designed with managers and leaders in mind.

• Conditional Formatting: setting rules for changing font and background colors based on cell values
• Data Validation, Named Ranges and Dropdowns: Limiting users to only input dates, numbers, or text from a dropdown
• Data Protection: Prohibiting users from editing certain ranges by setting parts of your spreadsheet to be "protected" from changes
• Sharing Options: Restricting editing, viewing, and/or commenting to certain users
• Filter Views: Allowing multiple users to sort and filter the same spreadsheet without affecting each other
• Recovering from Mistakes: Accessing the spreadsheet's version history, seeing who made changes and restoring old versions
• Creating Charts Instantly Using Google's AI Feature
• Checkboxes: A simple way to create interactive sheets
• Google Forms and Quizzes: Feeding user-inputted data into a spreadsheet (example)
• Incorporating Real-Time Data: Accessing HTML tables and CSV files online to extract data from other web sites
• Selecting data with SQL: running database commands gainst columns of spreadsheet data
• Zapier Integration: Filling sheets with data from other web services (e.g., adding Twitter mentions to a Google Sheet)
• Getting Financial Data: access real-time stock quotes, volume, and even cryptocurrency prices (example)
• Macros and AppScript: Equivalent to VBA, AppScript allows developers to access the internal components of a Google sheet
• Maps with Pins: with the GeoCode add-in, you can create Google maps with colored pins at address locations listed in your spreadsheet
• Mobile Apps from Google Sheets Using AppSheet: If your spreadsheet has tabs, column headings, image URL refrences, and related data in each row, you can quickly turn it into an intuitive cell phone app using the AppSheet add-in (app / / data)
• Visualizing and Transforming Data: Sparkline() for mini-charts, Image() for QR Codes, Translate() for foreign languages

Google Sheets is the spreadsheet application of Google's cloud-based office suite. This accelerated class is meant for experienced users of Excel, who know how to create formulas and apply functions, and who want to learn how to do the same and more in Google Sheets.

Learning Outcomes: 

• Can create conditional formatting 
• Ability to use limit what information users can add or edit 
• Can share a spreadsheet and collaborate in real-time 
• Be able to make interactive sheets and forms to obtain information 
• Can get real-time financial data from stock market 
• Ability to create Macros to automate repetitive actions 
• Can create visuals like charts, sparklines, and QR Codes

Advanced users of Excel

• Growth vs. Fixed Mindset 
• How a fixed mindset holds you back 
• How to achieve a growth mindset 
• Three attitude changes 
• Four action/behavior changes 
• Myths and Misconceptions of Growth Mindset 
• Growth mindset is more than just a positive attitude 
• Applying Growth Mindset through a lens of self-efficacy 
• Determine if using a growth mindset is advantageous 

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 both how and when to implement a growth mindset. 

What We’ll Explore:

•  How does a growth mindset benefit me?
• Practical applications of a growth mindset.
• What gets in the way of utilizing a growth mindset?
• Identify when it is advantageous to use a growth mindset.

This foundational Learnit training is good for everyone from individual contributors to senior leaders.

Lesson 1 - Customizing Illustrator

• Customizing Toolbar
• Custom Keyboard shortcuts
• Customizing the Illustrator Workspace
• Illustrator Preferences

Lesson 2 - Magic Wand Tool

• What is the Magic Wand Tool
• Fill Color
• Stroke Color
• Blending Modes
• Transparency

Lesson 3 - Illustrator Graphic Styles

• Working with Graphic Styles for Efficiency and Creativity
• Creating Graphic Styles
• Editing Graphic Styles
• Applying Graphic Styles
• Using the Appearance Panel and Graphic Styles
• Graphic Styles on Shapes and Objects
• Applying Graphic Styles to Text

Lesson 4 - Working with Symbols

• Creating a Symbol
• Linking and Unlinking Symbols
• Symbol Sprayer
• Symbol Screener
• Symbol Scaler
• Symbol Scruncher

Lesson 5 - Working with Filters and Effects

• Photoshop Effects
• Distort and Tranform
• Liquefy Effects
• Warp Effects
• Stylize
• Blur
• Artistic Effects

Lesson 6 - Creating Graphs and Charts

• Bar Charts
• Column Charts
• Pie Charts
• Customizing Charts

Lesson 7 - Blend Tools

• Blending Colors
• Blending Steps
• Blending Distance
• Combining objects Spines for complex blending

Lesson 8 - Gradient Mesh Tool

• Create complex color patterns
• Using the Pen tool to customize colors

Lesson 9 - 3D Filter

• Extrude and Emboss
• 3D Text
• 3D Object

Lesson 10 - Puppet Warp Tool

• Working with Pins
• Working with Mesh options

Lesson 11 - Data Merge for Creating Templates

• Importing CSV Databases to Illustrator files
• Creating Badges, Banners, Postcards and Document Templates
• Using the Variables files
• Binding Variables in your Illustrator file

Lesson 12 - Automating Tasks with Actions

• What is an Action
• Preset Actions
• Recording Custom Actions

Upon successful completion of this course, students will be able to use Adobe Illustrator CC to create complex illustrations, format illustrations and type, and prepare documents for print and web. 

Outcomes: 

• Apply and create Illustrator Graphic Styles to Objects and Text 
• Working with advanced Filters such as warping, extrusion and 3D 
• Create complex illustrations using the Shape Builder Tool 
• Creating Graphs and Charts 
• Creating complex shapes, shading and coloring using the Gradient Mesh and Puppet Warp tool 
• Import data using the Data Merge tool to create templates 

This Illustrator course is recommended for those with some basic training or understanding of Adobe Illustrator.

Module 1: Introducing Illustrator CC

• Apply Design Principles, Elements, and Graphics Composition 
• Evaluate Graphics Scalability 
• Navigate the User Interface 
• Customize the User Interface

Module 2: Creating Documents Containing Basic Shapes

• Create Documents 
• Save Documents 
• Draw Basic Shapes

Module 3: Creating Documents Containing Customized Paths

• Draw Paths 
• Modify Paths

Module 4: Creating Graphics Containing Customized Text

• Insert Text 
• Apply Flow Text Along a Path 
• Insert Bounded and Threaded Text 
• Apply Text Styles 
• Insert Typographical Characters

Module 5: Customizing Objects

• Import, Place, and Link Graphics 
• Alter the Appearance of Objects

Module 6: Customizing Basic Shapes

• Apply Strokes and Brushes 
• Fill Shapes 
• Apply Graphics Styles 
• Distort Text with Text Envelopes

Module 7: Preparing Documents for Deployment

• Update Text 
• Wrap Text 
• Hyphenate Text 
• Optimize Content for Print 
• Optimize Content for the Web 
• Optimize Content for PDF Documents

Upon successful completion of this course, you will be able to use Adobe Illustrator CC to create illustrations that include graphics and text.

Outcomes:

• Identify the components and capabilities of Illustrator CC.
• Create basic shapes.
• Create custom paths.
• Create graphics that contain custom text.
• Customize objects.
• Customize basic shapes.
• Prepare documents for deployment.

This is an entry level Illustrator course recommended for all levels.

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

Develop top-notch professional communication skills by learning the principles of business writing.

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

What We’ll Explore:

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

This is a foundational Learnit course that is a good fit for anyone who wants to fine-tune their writing skills and increase their confidence in written business communication including individual contributors, middle managers, team leaders, senior managers, and senior leaders.

Lesson 1 - InDesign Interface & Setup

• Customize Preferences
• Customize Keyboard Shortcuts
• Setup Custom Workspaces

Lesson 2 – Creating Documents using Templates

• Overview of InDesign Templates
• Web, Print or Mobile
• Customizing Template documents

Lesson 3 – Graphic Design Principles and Illustrations

• Drawing basic and custom shapes
• Using the Pen Tool
• Using the Direct Selection tool
• Using the Pathfinder Panel to create complex shapes
• Overview of graphic design principles
• Creating a complex poster/flyer using illustration tools
• Optimizing the Properties Panel
• Object Styles using Shapes

Lesson 4 – Advanced Text Frame Techniques

• Placing text from large documents
• Advanced text placement techniques
• Linking text documents
• Creating columns and gutters

Lesson 5 – Advanced Text Formatting Techniques

• Creating Tabs
• Paragraph Rules
• Hyphenation Settings
• Shading and Borders
• Creating Paragraph and Character Styles
• Advanced bullets and numbering

Lesson 6 - Working with Larger Documents

• Masters overview in large documents
• Load Masters
• Masters and guides
• Overriding masters
• Exporting Masters
• Creating Placeholder Templates
• Inserting Page and Section Markers
• Using graphics in Master Pages

Lesson 7 – Advanced Paragraph and Character Styles

• Understanding GREP Styles
• Shading
• Borders
• Nested Paragraph Styles
• Nested Character Styles

Lesson 8 – Working with Tables

• Importing Excel/CSV/Text data into Tables
• Creating Tables
• Formatting Tables
• Table Layout
• Creating Table Styles
• Nest Paragraph Styles into Table Styles

Lesson 9 – Creating a Book Document

• Adding Documents to a Book File
• Specifying Page Numbering Across the Book
• Customizing Page Numbering
• Creating a Running Footer
• Defining a Text Variable
• Inserting a Text Variable
• Adding a Footnote
• Adding a Cross-Reference
• Synchronizing a Book
• Generating a Table of Contents for the Book
• Setting Up the Table of Contents
• Flowing the Table of Contents
• Indexing a Book
• Viewing Index Pages

Lesson 10 - Interactivity

• Buttons
• Links
• Rollovers
• Forms
• Save as PDF Interactive

Lesson 11 - Data Merge Postcard Mailers

• Setting Up the Source Data File & Template
• Importing Data Records
• Mapping Merged Fields
• Previewing & Creating a Data Merged Document

Lesson 12 - Create Document with Alternate Layouts

• Create a trifold document
• Create a document with alternate layout options
• Working with Allowing Pages to Shuffle option

Lesson 13 – Publishing Your Document for Printer

• Create Press Quality document
• Secure your documents
• Adjust compression values of images for exporting
• Adjust PDF viewing properties
• Preflight and package

Upon successful completion of this course, students will be able to use Adobe InDesign CC to create and deliver professional-looking printed and interactive documents.

Outcomes: 

• Advance illustration techniques including the Pen Tool, Pathfinder and Direct Selection 
• Working with large documents such as Books and Magazines 
• Create Footnotes, Table of Content, Bookmarking and Cross-Referencing 
• Creating interactive PDF’s that include Buttons, Forms and Links 
• Create Tables and Table Styles 
• Use the Data Merge feature to import outside data into your document 

This InDesign course is recommended for those with a basic understanding of InDesign with some industry experience. No other Adobe or graphic design experience required. Must have InDesign installed on your computer.

Lesson 1 - InDesign Interface & Setup

• What is InDesign used for?
• Example of what you can create
• InDesign Interface & Workspace overview
• Panel Overview and Customization
• Basic Keyboard Shortcuts

Lesson 2 - Creating a New Document

• Units of Measure
• Understanding Margins, Bleeds, Slugs and Page settings
• Saving Presets
• Overview of InDesign Templates

Lesson 3 - Working with Shapes

• Drawing basic shapes
• Understanding Fill and Stroke 
• Stroke color, width and style settings
• Color overview (CMYK, RGB, HSB, Hexadecimal)
• Creating Swatches
• Corner options
• Resizing, rotating and moving shapes
• Using the Properties Panel for Shapes

Lesson 4 - Creating a Basic Poster 

• Document Setup
• Ruler and Guides
• Drawing and coloring Shapes
• Creating basic Text Frames
• Placing Graphics
• Using the Selection Tool
• Shapes Transparency settings
• Intro to Layers
• Saving InDesign files

Lesson 5 - Working with Larger Documents

• Overview of Pages panel
• Customizing Pages panel
• Inserting new pages
• Moving pages
• Intro to Master Pages
• Understanding Layers

Lesson 6 - Working with Images

• Placing images
• Image placement options
• Image Frames
• Fitting options for images
• Using the Properties Panel for Images
• Autofit options for image resizing
• Stroke color, width and style settings
• Text wrapping
• Cloning images
• Cropping
• Object Effects including Drop Shadow, Glow, Feathering
• Object Transparency
• Intro to Object Styles

Lesson 7 - Object Styles

• Why create Object Styles?
• Overview of Object Styles panel
• Overview of object settings 
• Drop Shadow, Corner Options, Stroke, Columns, Text Wrapping
• Creating an Object Style
• Applying an Object Style
• Overriding and updating Object Styles

Lesson 8 – Working with Type 

• Using the Control Panel
• Using the Properties Panel
• Basic Formatting 
• Overview of basic typographic settings (Kerning, Tracking, Leading)
• Paragraph properties settings
• Placing text from Word Document 
• Bullets and Numbering
• Paragraph Margins
• Paragraph Rules
• Paragraph and Cell Style introduction

Lesson 9 - Intro to Paragraph Styles

• Why do we use Paragraph Styles?
• Examples of Paragraph Styles
• Intro to Paragraph Style Panel
• Creating a Paragraph Style
• Applying a Paragraph Style
• Nesting a Paragraph Style inside a Text Object Style

Lesson 10 - Intro to Character Styles

• Why do we use Character Styles?
• Examples of Character Styles
• Intro to Character Style Panel
• Creating a Character Style
• Applying a Character Style
• Using Find and Replace and Character Styles
• Nesting a Character Style inside a Paragraph Style

Lesson 11 - Master Pages

• The value of Master Pages
• Creating a Master Page
• Adding a running footer/heading
• Adding Page Numbers
• Adding Section Markers
• Creating Master placeholder pages

Lesson 12 – Exporting Files for Print and Digital Deployment

• Managing Links
• Preflighting Documents for Printing
• Creating a Custom Preflight Profile
• Converting RGB & Spot Colors to Process Colors
• Packaging the InDesign File
• Embedding & Sharing a Custom Preflight Profile
• Sharing Files & Packages with Earlier InDesign Versions
• Previewing Color Separations
• Previewing Transparency
• Exporting PDF Files for Printing & Proofs

In this course, you will use Adobe InDesign CC to create and deliver professional-looking printed and interactive documents.

Outcomes:

• Navigate and customize the InDesign interface.
• Create a new document, poster project and long document.
• Expertly work with images, frames, text wrapping and object effects.
• Learn how to format using Paragraph and Character Styles.
• Learn how to use Master Pages.
• Export, Publish and Package documents for deployment and delivery.

This is an entry level InDesign course recommended for all levels.

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

Inclusive Leadership Training: a practical approach to belonging at work provides practical strategies for leading and managing diverse teams in a way that fosters a culture of belonging. Our approach is grounded in the latest research on inclusive leadership and is designed to help you develop an inclusive mindset and put it into practice in your workplace.

What We’ll Explore:

• Understand the definition, importance and impact of Inclusive Leadership.
• Learn how to develop an inclusive mindset that recognizes and values diversity and fosters a culture of belonging.
• Learn practical actions and strategies for applying inclusive leadership.

For all levels of an organization including staff-level, middle-management and/or senior leaders.

• Find your flow
• Multitasking is a myth 
• Active your flow State 
• Control your distractions 
• Pomodoro technique
• How to say “no” professionally
• Navigate shifting priorities
• Reactive vs Proactive
• Urgent vs important

So, you’ve learned to plan your day by optimizing your schedule. You’ve blocked your calendar to accurately reflect the time you actually need to complete tasks. You’ve matched the different types of work you do with your energy peaks and valleys. Yet it is still a challenge to manage your time because the realities of the modern workplace will conspire to distract you. This course will help you maintain focus and stay on track. You will learn practical tools that can help you to better align your daily activities to accomplish your goals.

What We’ll Explore:

• Finding our flow
• Shut down distractions
• Navigate shifting priorities

Individual contributors and mid-level senior leaders who are seeking to increase their abilities to shut down distractions and maximize their time management by reaching a state of flow.

• AAA of Resilience 
• Reframing your perspective with cognitive reappraisal
• Challenge the appraisal
• How to grip your grit
• Grit and goal setting

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

What We’ll Explore:

• Change and growth
• Becoming more resilient 
• Developing more grit

This workshop is for anyone looking to discover and improve their individual perseverance when the going gets tough.

• Explore the difference between influence and authority 
• Learn why influence is important in the workplace
• Discover Learnit’s Advantage/Relationship Matrix
• Learn how to build and manage relationships
• Make your ask advantageous
• Use emotion/logic and push/pull to communicate your objective
• 4 methods to influence 
• Kairos, timing is everything

Perhaps no topic has garnered more interest in recent years than how to build influence in an organization. This is especially true for those who work in flatter, matrixed organizations where getting work done often depends on the support of others. Influencing Without Authority will show you a clear, actionable model for growing your influence, deepening your relationships, and getting more done.

What We’ll Explore:

• Examine and practice Learnit’s Advantage/Relationship Matrix
• Communicate your objective using a balance of logic and emotion
• Learn how and when to time your request

This workshop is for anyone who needs to enroll the efforts and support of others, even when they are not required to help you. Project managers or those who run projects as well as those who work on cross-functional teams or need help influencing ‘laterally’ in their organizations will benefit from this course.

• Define change management
• Explore the change management process 
• Learn the key roles and how to work effectively with each
• Create a change management plan using the CSC Framework
• Examine strategies for avoiding costly mistakes and the dangers of change fatigue

Execute change like a pro with essential skills learned in this change management course.

Employees are constantly experiencing change at work. Whether you are planning for a forthcoming change initiative or currently executing one, this course will introduce essential information and best practices that will improve adoption. The goal with change management is to help employees successfully and smoothly transition from a current state to an ideal future state.

What We’ll Explore:

• Components and roles of change
• Creating a change plan
• Avoiding costly mistakes

This workshop is designed for leaders, people managers, project managers, and influencers who want to better manage change.

• Ways to build trust in your first 100 days
• How to empower your team
• Turning empathy into action
• Practice using tools to help you succeed as a new manager
• Make the team your own—establishing yourself as the leader

Upskill with Learnit and focus on your new leader training by developing effective leadership skills.

In this workshop, participants will learn how to maximize their first 100 days as a new manager by establishing trust. Whether they’re new to a team, new to the organization, or transitioning from being a peer to managing the team, establishing trust from the beginning is cornerstone to their success. This course will prepare them for the handoff as they learn ways to build trusting relationships, empower team members, avoid micromanagement, turn empathy into action, and ultimately establish a new team culture.

What We’ll Explore:

• Facilitate a smooth transition by building trust in your first 100 days
• Get the best out of your team by empowering them
• Understand what motivates team members to lead and support them effectively
• Demonstrate your competence by taking action on what’s most meaningful to your team
• Gain loyalty by being honest and approachable

This workshop is for anyone who is new to management, whether new to a team, to an organization, or transitioning from being a peer to managing a team. Those who are on a path to become a manager, are part of a leader’s succession plan, or have aspirations to become a manager, will also benefit from this workshop.

• Be aware of proximity bias
• Leverage synchronous and asynchronous communication while also setting communication boundaries
• Overcome collaboration challenges by setting decision-making rights
• Explore independent ideation and brainstorming rules and roles
• Advocate for the wellness of your employees
• Plan events and make the most of your meetings to support employee engagement

The future of work is flexible. As work arrangements continue to evolve, it is essential for leaders to adapt their leadership styles to meet the changes needs of their teams. This course is designed to help leaders effectively lead teams that work in a remote, hybrid, or flexible working environment. Leaders will learn how to overcome challenges related to communication, collaboration, and engagement while also supporting flexibility, productivity, and connectivity.

What We’ll Explore:

• Focus on flexibility, productivity, and connectivity to overcome challenges in these three focus areas:
• Communication
• Collaboration
• Engagement

• Any level of people leader who is managing hybrid/remote/flexible teams 
• Trainers, coaches and consultants who need to understand how to move a team into flexible working arrangements

• Project and Project Management Defined 
• Project roles defined 
• An introduction to Project Management Methodologies
• Project Management Triangle 
• The Five Project Phases 
• Project Objectives, Deliverables, and Requirements 
• Task Management and Creating a Task List

Learn to better manage projects with essential skills taught in this project management training.

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.

What We’ll Explore:

• Methodologies and project phases
• The project management triangle
• Task management and task lists

This workshop is designed for leaders, people managers, project managers, and individual contributors that want to improve project performance.

• Empathy in the workforce 
• Four components for developing empathy
• 6 skills to active listening
• Perspective-taking and understanding others’ point of view
• Three steps for coaching

Boost your people skills and deepen your workplace relationships with this key empathetic leadership workshop.

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.

What We’ll Explore:

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

People managers, HR professionals, department leaders, policy enforcers, and associates leading projects are ideal for this course.

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

Develop your active listening skills and improve communication at work.

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. 

What We’ll Explore:

• Learnit’s EAR listening model 
• Next-level listening 
• Giving others the experience of feeling heard

This is a foundational Learnit training, one that can be repeated and is good for everyone from Individual contributors to senior leaders.

• Introduction to decision-making challenges
• Balance the scales
• DECIDE decision-making model
• Optimal Stopping
• Delayed Intuition Matrix
• Take a BEAT decision-making model
• Leave with action items and a plan for better, quick, in-the-moment decision-making habits

This course is for those who make important decisions. It is ideal for situations when you have time, resources, and the ability to aggregate multiple and, hopefully, differing points of view to arrive at the best possible decision. Easy to say, hard to do. Because all of us have a natural and automatic tendency to jump to conclusions, this class is meant to help you temper the rush to judgment with specific, actionable models that balance the benefits of clear-eyed deliberation with our equally beneficial faculty of human insight and intuition. 

What We’ll Explore:

• Understand the risks of biased, instinctual decision-making
• Introduce how to rebalance the scales for both clear-eyed deliberation and human intuition
• Learn the four decision-making models 
• Begin the habit-changing process for making better, quick, in-the-moment decisions 

This workshop is ideal for those in decision-making positions, especially leaders and managers who have the benefit of time and teams.

What is Anxiety? 

• The brains response to anxiety 
• Unpack how anxiety occurs 
• Anxiety in the workplace 

Retrain the Brain 

• Identify and stop thinking traps 

Positive Thinking 

• Find a place of calm – So we can think clearly. 
• Change or Reframe our thoughts – To find more positive thoughts. 
• Create a new experience – To replace the old one. 

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.

What We’ll Explore:

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

This workshop is appropriate for anyone who wants to build an optimistic attitude and approach life and their workday with a positive mindset.

• The stress experience 
• Eustress vs distress
• E.A.S.E.: Examine it, Alleviate it, Shift it, Embrace it
• Promoting eustress

Boost your workplace wellness by learning key techniques for managing stress at work.

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

What We'll Explore:

• The cause and experience of stress
• Eustress vs distress
• Learnit’s E.A.S.E. model

Anyone who is experiencing stress in their workplace and is curious about ways to help manage day to day stress. This workshop is for individual contributors, middle managers, team leaders, senior managers, and senior leaders.

• Three keys to managing up
• Social styles model
• Establishing feedback norms
• The ABCs of meeting to manage Up
• Know the ROPES: Planning an agenda during advanced preparation
• Navigating difficult situations

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.

What We’ll Explore:

• 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

This is a great fit for anyone who reports to another person! People at all career levels benefit from understanding or reviewing how to navigate manager relationships.

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

Microaggressions Training Managing Microaggressions: how to stop acts of exclusion 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.

Workplace Application: Participants will leave this learning session with new practical approaches to identify and disrupt Subtle Acts of Exclusion (i.e., microaggressions) in real time.

What We’ll Explore:

• Understand and recognize the impact of microaggressions.
• Learn a more contemporary approach to dealing with microaggressions (i.e., subtle acts of exclusion).
• Gain practical experience and practice actionable steps to stop the damaging impact of Subtle Acts of Exclusion in real-time.

For all levels of an organization including staff-level, middle-management and/or senior leaders.

Module 3

Lesson 1: Executing a Project

• Enter Task Progress
• Update Task Progress with SharePoint
• Update Work
• Update Costs

Lesson 2: Monitoring Project Progress

• View Project Progress
• Add Custom Fields
• Create Custom Views
• Create a Network Diagram
• Analyze a Project Plan

Lesson 3: Controlling a Project Plan 

• Edit the Task List
• Reschedule Tasks
• Update a Baseline

Module 4

Lesson 4: Reporting on Progress

• Format and Share a Chart View
• View Existing Reports
• Create Custom Reports
• Create a Visual Report

Lesson 5: Customizing the Application

• Change Project Options
• Create a Project Plan Template
• Share Resources
• Link Project Plans

This hands-on course guides participants through: executing a project; updating task progress, cost and work deliverables with SharePoint; monitoring project process using custom fields and network diagrams; and producing professional, results-driven reports by building custom reports and visuals. Participants will also learn how to customize the application for their specific needs using Options settings, creating and sharing templates, and linking projects.

Project managers and coordinators. Basic proficiency with Windows UI. Some familiarity with MS Office a plus - but not required.

Module 1

Lesson 1: Getting Started with Microsoft Project

• Identify Project Management Concepts
• Navigate the Microsoft Project 2016 Environment

Lesson 2: Defining a Project

• Create a New Project Plan
• Define a Project
• Assign a Project Calendar

Lesson 3: Creating and Organizing Tasks

• Add Tasks to a Project Plan
• Import Tasks From Other Programs
• Create a Work Breakdown Structure
• Define Task Relationships
• Schedule Tasks

Module 2

Lesson 4: Managing Project Plan Resources

• Add Resources to a Project Plan
• Create a Resource Calendar
• Enter Costs for Resources
• Assign Resources to Tasks
• Resolve Resource Conflicts

Lesson 5: Finalizing a Project Plan

• Optimize a Project Plan
• Set a Baseline
• Share a Project Plan

This hands-on course introduces participants to developing project plans, tracking and managing project resources, creating powerful visual reports, and tracking and monitoring project deliverables with ease. Participants will learn terminology, how to create and define a project, add tasks to the project plan, and create a work breakdown structure.

Project managers and coordinators. Basic proficiency with Windows UI. Some familiarity with MS Office a plus - but not required.

Learning Outcomes:

• Initiate and respond to chats with coworkers.
• Use call, videoconference, and screen-sharing features.
• Set up collaborative teams and topic channels.
• Use the integrated features between Teams and Outlook.

Lesson 1: Teams Overview

• Understanding the Purpose of Teams
• Navigating Teams
• Setting up your Profile

Lesson 2: Teams Chat

• Chatting with a Colleague
• Group Chats
• Making a Video/Phone Call During a Chat
• Sharing Your Screen
• Viewing your Organization Chart
• Sharing Files Via Chat 

Lesson 3: Building a Team

• Creating a Team
• Creating Channels
• Creating a Post
• Searching for Posts, Files & Messages

Lesson 4: Outlook Integration 

• Modifying Calendar Views
• Scheduling a Meeting from Teams
• Scheduling a Meeting from Outlook

Lesson 5: Options Setting and Other Features

• Device Settings
• Teams Themes
• Notification Settings

Intra-office chat systems like Slack and Microsoft Teams are a smart alternative to today’s overflowing email inboxes and abandoned voicemails. MS Teams is actually much more than just a chat system; it offers phone calls, videoconferences, document attachments, website chat box integration, topic channels, and more.

Chat. After giving an overview of how to get around Teams, we’ll show you its primary feature: chat. Instead of sending an email, contacting a colleague by chat is much more effective when you need their immediate attention. Chat is a less formal way of communicating with coworkers, so you can safely intersperse emoji and customized Grumpy Cat memes. If you need to share a file with a coworker, it’s easier and faster than sending an email attachment.

Calls and Videoconferences. When you need more context to explain yourself, you can easily switch from chat to voice call or videoconference. We’ll show you how to manage a contact list within Teams, initiate calls, launch videoconferences, and share your screen. Like its competitor Zoom, MS Teams has a number of settings related to videoconferencing.

Building a Team. A larger organization will want to ensure that there are global “channels” for company-wide messaging and team-specific channels for individual office branches or departments. We’ll show you how to create teams and topic-specific channels for chat discussions between employees.

Outlook Features. Instead of being a replacement for email, the best way to use MS Teams is as a complement to Outlook: integrating it with calendars, meetings, and more. We’ll show you how to use these two cornerstone applications in harmony.

This class is for employees who want to use MS Teams to better collaborate with coworkers — beyond email and shared drives.

• How to build team motivation
• Provide clarity to your employees
• Assess your management style
• Reduce dissatisfaction and maximize satisfaction
• Make team motivation personal

Develop your motivational skills and learn how to motivate your team.

Teams with motivated employees are highly adaptable, exude positivity, and demonstrate higher levels of performance and productivity. This workshop takes team leaders through the process of reflecting on how their attitudes and beliefs shape employee motivation. It then guides leaders through a four-part plan with clear strategic and practical actions they can take to create a work environment optimized for sustainable motivation. Motivation isn't something you can do to or for others. But you can create optimal conditions for motivation which is what this class is all about.

What We’ll Explore:

• The value: Why we need motivated employees
• Build the foundation: 4 essential components of a motivational environment
• Take it further: The impact of optimism and appreciation

This training is a good fit for people managers, team builders, people strategists, L&D professionals, and coaches.

• Who are middle managers
• Common challenges faced by middle managers
• Organizational challenges
• Interpersonal challenges
• Actionable mindsets and practical solutions
• Creating relationships and networks
• Curating meaning and purpose
• Engaging in self-care

Tune in to your company culture and the role middle management plays.

While middle managers are one of the most populous roles within many organizations, research indicates these leaders often describe themselves as lost, torn between multiple forces, isolated, 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 in organizational and interpersonal challenges middle managers face and create an individualized toolkit of practical solutions and actionable mindsets to navigate their own experience of loneliness.

What We’ll Explore:

• Explore organizational challenges faced by middle managers
• Explore interpersonal challenges faced by middle managers
• Learn practical solutions to navigate loneliness
• Apply actionable mindsets to curate meaning and purpose

This class is for anyone who has a boss and is a boss, including managers, supervisors, and directors.

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

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

What We’ll Explore:

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

The Negotiating for Shared Success workshop attracts professionals from all occupations. Anyone who is interested in deepening his or her skills to achieve their maximum potential in everyday negotiations should take this course.

Module 1: OneNote Basics

Lesson 1: Getting Started with OneNote

• Navigate the OneNote 2016 Environment
• Use Templates
• Customize the OneNote User Interface

Lesson 2: Adding and Formatting Notebook Content

• Apply Formatting to Notebook Content
• Insert Images and Audio into a Notebook
• Add Quick Notes and Links
• Use Drawing Tools

Lesson 3: Embedding and Attaching Files

• Embed Excel Spreadsheets
• Attach Other File Types

Module 2: Searching and Sharing Notes

Lesson 4: Organizing and Searching Notebooks

• Use Tags
• Organize and Search Notebooks

Lesson 5: Finalizing a Notebook

• Proof and Print a Notebook
• Configure Password Protection and Notebook Properties

Lesson 6: Managing Notebook Files

• Export Content from OneNote Notebooks
• Back Up and Restore Notebook Content

Lesson 7: Sending and Sharing OneNote Content

• Send OneNote Content in Other Formats
• Share OneNote Content by Using OneDrive

Learnit offers OneNote training courses. Whether you're new to OneNote or an advanced user, our training will cover all you need to know to become an OneNote power user. Microsoft OneNote lets you create and store notes in a convenient location, enabling you to find and use them simply. The organizational power of OneNote is essential to maintaining productivity. 

Outcomes:

• Understand Microsoft OneNote interface and Notebook structure
• How to create a Notebook
• How to create Notes
• How to organize content and search for information in a OneNote notebook
• How to integrate OneNote with other office applications
• How to use OneNote to share notes with people  

Module 3: Automating Outlook

This module will cover more advanced settings within Outlook. We will also talk about the search functionality and automating repetitive tasks.

Learning Outcomes:

• Be able to group, sort, filter, and search for messages
• Can modify settings within Outlook
• Ability to create automated replies
• Can create rules to simplify repetitive tasks

Lesson 1: Modifying Messages and Setting Global Options

• Insert Advanced Characters and Objects
• Modify Message Settings and Options
• Configure Global Outlook Options
• Customize the Outlook Interface

Lesson 2: Organizing, Searching, and Managing Messages

• Group and Sort Messages
• Filter and Manage Messages
• Search Outlook Items

Lesson 3: Managing Your Mailbox

• Use the Junk E-Mail Filter to Manage Messages
• Manage Your Mailbox

Lesson 4: Automating Message Management

• Use Automatic Replies
• Use the Rules Wizard to Organize Messages
• Create and Use Quick Steps

Module 4: Advanced Outlook Settings

This module dives deep into the tools that help organize your messages, manage your contacts, assign tasks, and schedule meetings/appointments on your calendar. It will also show you how to share and delegate your mailbox to co-workers.

Learning Outcomes:

• Can work with multiple calendars
• Can import and export contacts
• Ability to share and delegate access to other users
• Be able to create and assign tasks
• Can back up outlook items

Lesson 5: Working with Calendar Settings

• Set Advanced Calendar Options
• Create and Manage Additional Calendars
• Manage Meeting Responses

Lesson 6: Managing Contacts

• Import and Export Contacts
• Use Electronic Business Cards
• Forward Contacts

Lesson 7: Managing Activities by Using Tasks

• Assign and Manage Tasks

Lesson 8: Sharing Workspaces with Others

• Delegate Access to Outlook Folders
• Share Your Calendar
• Share Your Contacts

Lesson 9: Managing Outlook Data Files

• Use Archiving to Manage Mailbox Size
• Back Up Outlook Items
• Change Data File Settings

Learnit offers an extensive Microsoft Outlook training course that covers various versions including 2016, 2013, 2010 and earlier. All our training courses are delivered by our world-class trainers ready to help you or your employees get the most out of Microsoft Outlook.

Anyone who uses Microsoft Outlook and who would like to learn how to more efficiently manage their mailboxes, modify settings, create automated replies and message management, and manage data files.

Module 1: Basics of Outlook

This module will help you to navigate outlook and talk about how we can format our messages with attachments and also track them.

Learning Outcomes:

• Be more efficient when manage mailbox
• Can modify settings within Outlook
• Can attach files in an email
• Be able to track, recall, and resend messages

Lesson 1: Getting Started with Outlook

• Navigate the Outlook Interface
• Work with Messages
• Access Outlook Help

Lesson 2: Formatting Messages

• Add Message Recipients
• Check Spelling and Grammar
• Format Message Content

Lesson 3: Working with Attachments and Illustrations

• Attach Files and Items
• Add Illustrations to Messages
• Manage Automatic Message Content

Lesson 4: Customizing Message Options

• Customize Reading Options
• Track Messages
• Recall and Resend Messages

Module 2: Managing Outlook

This module introduces the tools that help organize your messages, manage your contacts, and schedule meetings/appointments on your calendar.

Learning Outcomes:

• Can create folders, categories, and mark messages
• Can add and edit contacts
• Ability to schedule appointments, events, or meetings
• Be able to save notes and create tasks associated with an email

Lesson 5: Organizing Messages

• Mark Messages
• Organize Messages Using Folders

Lesson 6: Managing Your Contacts

• Create and Edit Contacts
• View and Print Contacts

Lesson 7: Working with the Calendar

• View the Calendar
• Create Appointments
• Schedule Meetings
• Print the Calendar

Lesson 8: Working with Tasks and Notes

• Create Tasks
• Create Notes

Learnit offers an extensive Microsoft Outlook training course that covers various versions including 2016, 2013, 2010 and earlier. All our training courses are delivered by our world-class trainers ready to help you or your employees get the most out of Microsoft Outlook.

Anyone who uses Microsoft Outlook and who would like to learn how to more efficiently manage their mailboxes, modify settings, create automated replies and message management, and manage data files.

• Understanding performance
• How to have course correction conversations
• How to create an effective PIP
• Mediation in three steps
• Leading your team through change with honesty, credibility, clarity, and hope

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

What We’ll Explore:

•  What to do when a direct report is underperforming
• Mediating conflict on your team
• Leading your team through change

This workshop is suitable for an emerging leader, manager, or executive who wants to better understand the best practices in the performance management process.

• 5 goals of effective performance management
• Exploring the performance management cycle
• Three steps for setting direction
• Writing goals that are clear, fair and relevant
• Managing execution and resisting micromanaging
• Writing effective performance reviews
• Three components of performance review conversations

Upskill with Learnit and discover how to achieve effective leadership through performance management training.

This science-backed workshop explores the nuts-and-bolts of performance management with a focus on defining, planning and supervising goals that hit the sweet spot of challenging and doable (eustress). Participants will also learn frameworks for conducting effective performance reviews. Together with our other courses on managing teams such as Coaching for Managers and Giving and Receiving Feedback, this class rounds out a holistic approach to managing teams for performance and development.

What We’ll Explore:

• Identify the performance management cycle, and the part employees, managers, and organizations play in that cycle.
• Discover how to set direction and write effective goals
• Develop skills in managing goal execution 
• Learn how to write performance reviews and facilitate performance review conversations

This workshop is suitable for an emerging leader, manager, or executive who wants to better understand the best practices in the performance management process.

Lesson 1 - Keyboard and Toolbar Shortcuts

• Customizing toolbars
• Customizing keyboard shortcuts
• Overview of fundamental keyboard shortcuts

Lesson 2 - Advanced Layer management

• Filtering layers by element
• Searching layers
• Color coding layers
• Grouping layers
• Merging layers
• Blending Modes

Lesson 3 - Blending modes

• What is a Blending Mode?
• Usage for Blending Modes
• Usage inside of Layers panel and Effects

Lesson 4 - Layer Comps

• What is a Layer Comp? Why use them?
• Creating Layer Comps
• Editing Layer Comps
• Updating Layer Comps
• Exporting to PSD/PDF/JPEG

Lesson 5 - Drawing Vectors

• Overview of Vector images
• Using Shapes
• Using Pen Tool
• Using the Direct Selection Tool
• Creating a Clipping Mask using vector
• Applying Color
• Using the Properties Panel

Lesson 6 - Advanced Type Techniques

• Make text into Shapes
• Change font style with pen tool
• Use for clipping mask
• Create Outlines
• 3D text

Lesson 7 - Advanced Adjustment Layers

• Curves
• Levels
• Black and White
• Selective Color
• Gradient Maps

Lesson 8 - Advanced selection (use golden retriever) – Smart Radius/Select and Mask

• Select and Mask
• Smart Radius
• Color Range
• Selecting Hair
• Using Pen Tool for selection
• Use Path Panel for selection
• Save Selection

Lesson 9 - Colorizing BW images

Lesson 10 - Displacement Maps

Lesson 11 - Advanced Filters

• Create Trees, Frames, Clouds and Fire
• Polarized, Wave and extrusion to create “Japanese Sun”
• Vanishing Point Filter
• Camera RAW
• Blur (create depth of field)
• Filter gallery
• Vanishing point with 3D text
• Liquify

Lesson 12 - Intro to Actions

• Using Actions to automate tasks
• Use Photoshop’s preset Actions
• Create your own Actions

Lesson 13 - Creating an Animated GIF

• Frame by frame animation
• Use the Timeline

This course will progress your skills to an intermediate and advance level of Adobe Photoshop CC.

Outcomes:

• Learn advanced selection techniques like the Path and the Pen Tool
• Learn advanced layer management and Layer Comps
• Have a greater understanding and usage of Blending Modes
• Learn how to create 3D text and create text outlines
• Learn advanced Filters such as Displacement Maps, Blurs and Distortion
• Apply actions and batch processing to automate tasks
• Create animated GIFs
• Set project requirements by identifying the purpose, audience, copyright rules and project management tasks

This course is recommended for those interested in learning intermediate/advanced Photoshop techniques.

Lesson 1 - Interface and Preferences

• The Photoshop Interface
• Customizing Panels and Toolbars
• Photoshop Preferences
• Photoshop CC Workspaces
• Intro to Keyboard Shortcuts

Lesson 2 - Image File Formats

• Photoshop format (PSD)
• JPEG, PNG, PDF
• About File Compression

Lesson 3 - Creating a New Document

• Setting dimensions
• Setting size and dimension
• Understanding media units
• Color profile overview
• Saving presets

Lesson 4 - Placing images

• Embedded vs Linked
• Smart Object intro
• Selection tool

Lesson 5 - Image Size and Resolution

• Saving in different formats and compression settings
• Image size and resolution

Lesson 6 - Layers introduction

• Reordering layers
• Renaming layers
• Grouping layers
• Locking layers
• Hiding layers

Lesson 7 - Selection Tools

• Marquee Tools
• Magic Wand Tool
• Quick Selection Tool
• Lasso Tools
• Inverse Selection
• Deselect

Lesson 8 - Layer Effects

• Drop Shadow
• Stroke
• Outer Glow
• Saving Effects Styles
• Applying multiple effects
• Cloning Effects

Lesson 9 - Introduction to Shapes

• Using the Shapes tool
• Creating Custom Shapes
• Intro to Colors
• Using the Properties Panel
• Intro to the Direct Selection tool
• Create a basic poster (examples provided)

Lesson 10 - Type and Typography

• Working with Type
• Character and Paragraph Panel
• Styles Panel
• Saving favorite fonts
• Effects and Layer Styles on Type
• Leading, Tracking, Kerning

Lesson 11 - Colors

• RGB vs CMYK
• Selecting colors using Eyedropper
• Saving colors as Swatches
• Using Gradient Tool

Lesson 12 - Creating a Clipping Mask

• What is a Clipping Mask?
• Using type
• Using images
• Using shapes
• Applying Layer Effects to Clipping Masks

Lesson 13 - Introduction to Masking

• What is Masking/Usage of Masking?
• Understanding Brush tool and Masking
• Shortcuts for Masking
• Gradient Mask

Lesson 14 - Adjustment Layers

• Color/Gradient
• Curves
• Levels
• Hue/Saturation
• Black and White
• Using Adjustment Layer Mask

Lesson 15 - Image Touch Up

• Red Eye Removal
• Spot Healing Brush
• Patch Tool
• Content Aware Removal
• Clone Stamp
• Dodge/Burn tools
• Restore an old photo
• Removing blemishes/unwanted objects
• Whiten Teeth

Lesson 16 - Filters Intro

• Intro to Smart Objects/Filter
• Filters Gallery
• Blur filter
• Vantage filter

Lesson 17 - Blending Modes Intro

• Understanding different Blending Modes
• Layer overlays and blending modes types
• Darken, Lighten, Overlay

This course will prepare you to use the most common basic features of Adobe Photoshop CC. You will learn how to use layers effectively, utilize selection tools, apply layer effects, learn adjustment layers, masking and clipping masks, how to touch up and restore photos, typography techniques, intro to filters, color theory and application.

Learning Outcomes:

• Learn how to use layers  
• Effectively utilize selection tools 
• Apply Layer Effects 
• Learn Adjustment Layers, Masking and Clipping Masks 
• How to touch up and restore photos 
• Typography techniques 
• Intro to Filters 
• Color theory and application 

This is an entry level Photoshop course recommended for all levels. 

What is Microsoft PowerApps
Create New Power App

• New Blank App
• From a SharePoint List

Connecting to a Data Source

• SharePoint Lists
• Excel Stored in SharePoint or OneDrive

Building Screens

• View Item Screens
• New Item Screens
• Edit Item Screens

Adding Power App Components

• Galleries
• Screen Controls
• Images

Format Controls

Publishing a Power App
Using a Power App

• From Office 365
• From a Web Browser
• Mobile App

Sharing a Power App
Bonus: Adding Power BI to a Power App

Mobile Apps have become a primary tool for doing business. This course will teach you how to create and deploy mobile and desktop apps that allow you and your team to view, create and edit common business data. You will learn to connect to common data sources such as SharePoint lists, and Excel files stored in OneDrive to build your apps. By the end of this one day of learning, you will have built your own working app that connects to business data.

Workflow Concepts Overview
Accessing Power Automate

• From Office 365
• From SharePoint
• From OneDrive

Getting around in Power Automate
Create a Power Automate Flow

• Starting from a Template
• Starting from Blank

Building a Power Automate Flow

• Triggers
• Conditions
• Actions

Power Automate Integration

• Forms
• Planner
• Power Apps
• SharePoint
• Teams

Activate and Test a Flow
Monitor Flow Statistics and Metrics

Office 365 offers many systems and tools to better organize and execute business processes. In this course, you will learn to automate business processes to ensure consistency and free up time to focus on your business. This course focuses on the integration between Power Automate and many other Office 365 apps such as SharePoint, Outlook, Teams, and Forms. Upon completion of this one-day course, you will have learned to work with workflow Triggers, Logical Conditions, and Actions to perform Power Automate business processes.

The live online Power Automate course is for those who wish to set up automated workflows to organize and execute business processes more efficiently.

Day 1: Prepping Data and Creating Visualizations

Learning Outcomes:

1. Import well-formed data into Power BI Desktop
2. Build reports with stunning visuals
3. Publish a report to the Power BI service on Office 365
4. Create and edit query steps in Power Query
5. Learn basic data transformation tools
6. Combine data from different data sources and tables

Lesson 1: Introducing Power BI 

• Navigating the Interface
• Power BI Web Services
• Building a Report Using Excel Data
• Publishing and Sharing Power BI Reports

Lesson 2: Shaping and Combining Data

• Importing from Multiple Data Sources
• Using Power Query
• Shaping, Transforming and Combining Data
• Producing Reports Using your Data Transformations

Day 2: Modeling Data and Publishing Options

Learning Outcomes: 

1. Understand the need for table relationships
2. Discover and build DAX functions that enhance your dataset
3. Learn to build calculated columns, tables and measures
4. Create Interactive Power BI Dashboards
5. Discover the Power BI mobile app
6. Understand how to embed Power BI reports into other media

Lesson 3: Modeling Data 

• Establishing Table Relationships
• Writing DAX (Data Analysis Expressions)
• Building Custom Calculated Columns
• Building Custom Data Measures
• Incorporating your Custom Columns and Measures in Reports 

Lesson 4: Publishing Options

• Overview of Power BI Web Service Capabilities
• Building a Web Service Dashboard
• Sharing your Dashboards
• Installing and Using the Power BI Mobile App
• Embedding Reports in Web Pages
• Publishing Reports to MS SharePoint and MS Teams 

Are your usual pie charts getting yawns in meetings? Power BI, like its competitor Tableau, is Microsoft’s software for building sophisticated “data visualizations”: elegant and often interactive graphical representations of your data – beyond what you can find in Excel or even Crystal Reports. In this class we’ll show you how to navigate the software so you can build and publish the kind of data-based reports that will get the office talking.

Prepping Data. After we’ve shown you the basic navigation and main areas of Power BI, we’ll cover how to import your data and clean it up. You can get data from multiple sources: Excel, SQL Server, XML and online services like Azure and Google Analytics. You can even combine tables from different sources by designating “join” relationships between them. Along the way we’ll show you how to set cleanup rules for any messiness in your imported data.

Different Visualizations. Once your data is ready, you’ll learn how to create stunning visualizations from it: bubble charts, heat maps, geographic shape maps, and more. You’ll learn how to publish them as standalone documents to bring to your next meeting.

Extending Data. In addition to simple data cleanup, Power BI offers tools to shape and combine data, including Power Query and Data Analysis Expressions (DAX), a toolkit of functions and formulas to return calculated values. This lets you incorporate key business summary data into your visualizations.

Publishing Options. Once your visualization is perfected, you can share it with others online by posting it to Office 365 or the Power BI mobile app. You’ll also learn how to embed reports into web pages, or post them to SharePoint or MS Teams. Finally, we’ll show you how to build interactive dashboard reports to combine your different data visualizations.

This class is for data analysts and managers who want to find business insights by creating impactful and elegant data visualizations.

Please note: This class requires participants to preinstall Power BI (Free Desktop Version). Prior to enrolling, please confirm you will have access to the Desktop Version, as well as authorization from your IT department. Further, this class will not be available for Mac users.

Module 3:

Learning Outcomes:

1. Customize the Ribbon for easier access to your favorite commands
2. Create and update templates and slide master layout options
3. Incorporate SmartArt, headers, footers and math equations

Lesson 1: Modifying the PowerPoint Environment 

• Customizing the Ribbon 
• Setting PowerPoint Options

Lesson 2: Customizing Design Templates

• Modifying Slide Masters and Slide Layouts 
• Creating Custom Layouts using placeholders 
• Adding Headers and Footers 
• Modifying the Notes Master and the Handout Master

Lesson 3: Adding SmartArt and Math Equations 

• Creating and Modifying SmartArt 
• Animating SmartArt 
• Adding Math Equations

Module 4:

Learning Outcomes: 

1. Be able to insert audio and video files for launch within a presentation 
2. Collaborate with your team on PowerPoint design and revisions using OneDrive
3. Make use of PowerPoint’s presentation prep and delivery features

Lesson 4: Working with Media and Animations 

• Adding Audio to a Presentation
• Adding Video
• Using Microsoft Stream or Files from your Computer
• Taking Advantage of the Screen Recording Tool
• Setting Video/Audio Playback Options
• Customizing Animations and Transitions 

Lesson 5: Collaborating on a Presentation

• Reviewing a Presentation
• Marking as Final
• Inspecting Presentations for Hidden Properties
• Storing and Sharing Presentations via OneDrive and MS Teams 

Lesson 6: Customizing a Slide Show 

• Annotating a Presentation
• Adding Subtitles
• Setting Up a Slide Show
• Creating Custom Slide Shows
• Adding Action Buttons and Hyperlinks for Slide Navigation
• Adding a Zoom Feature to Images
• Recording and Replaying a Presentation with your Narration

Audiences are all too familiar with PowerPoint slide decks having the usual titles, headings, bullets and stock photos – so it can be a real eye-opener to experience a presentation with custom transitions, animations, and embedded videos! This class will take your slide decks to that “next level.”

Customizations. PowerPoint not only lets you customize the Ribbon buttons, but everything on the page itself, including the design elements: the background, headers, footers, and related templates like the Notes and Handouts “Master” slides.

Audio, Video, Animations. Imagine punctuating a point in your presentation with an audio clip from the poet Robert Frost, or a video of your CEO demonstrating a new product. Audio and video can add life to your slides, but they require production and editing. Animations are a less resource-intensive alternative to add zest to your presentations – and they’re not as hard as you might think.

Review and Delivery. With Microsoft OneDrive, you can save your presentation to the cloud and collaborate with your coworkers on revisions. For your own prep, you can annotate your presentations, rehearse timings, and record and replay your presentation narration.

Tips and Tricks. We’ll cover a few of the biggest bang-for-buck features available in PowerPoint, such as Action Buttons for navigating a slideshow delivery; zooming in to see larger images; customizing slideshows for beginner vs. advanced audiences, and more.

This class is for users who can create and format PowerPoint presentations with text, graphics and charts, but want to add audio, video, animations and other advanced features.

Module 1:

Learning Outcomes:

1. Navigate the PowerPoint interface and manipulate core components 
2. Design presentations with templates, themes and layouts
3. Add and format text and images

Lesson 1: Getting Started with PowerPoint 

• Navigating the PowerPoint Interface 
• Viewing a Presentation’s Different Components
• Creating and Saving PowerPoint Presentations
• Using PowerPoint Help 

Lesson 2: Developing a PowerPoint Presentation 

• Selecting a Presentation Type 
• Editing Text with Shortcuts 
• Building a Presentation 
• Using PowerPoint Designer* (Office 365 Users) 

Lesson 3: Performing Advanced Text Editing Operations 

• Formatting Characters 
• Formatting Paragraphs 
• Formatting Text Boxes 

Lesson 4: Adding Graphical Elements to Your Presentation 

• Inserting and Formatting Images 
• Using the Background Removal Tool 
• Inserting and Formatting Shapes 
• Using the PowerPoint Eyedropper 

Module 2:

Learning Outcomes: 

1. Align, layer and group PowerPoint objects. 
2. Create or import table data into a PowerPoint presentation 
3. Create charts using PowerPoint or Excel
4. Create dynamic presentations with animations and transitions 

Lesson 5: Modifying Objects in Your Presentation 

• Formatting Objects 
• Grouping Objects 
• Arranging and Aligning Objects 
• Animating Objects 

Lesson 6: Adding Tables to Your Presentation 

• Creating a Table
• Formatting Tables
• Inserting a Table from Other MS Office Applications 

Lesson 7: Adding Charts to Your Presentation 

• Creating a Chart 
• Formatting a Chart 
• Inserting a Chart from MS Excel 

Lesson 8: Preparing to Deliver Your Presentation 

• Reviewing Your Presentation 
• Using MORPH and Other Transitions
• Printing Your Presentation
• Delivering Your Presentation 

PowerPoint is Microsoft’s flagship application for creating multi-page presentations, pitch decks, tutorials, and even one-pagers like infographics, flyers and posters. In contrast with MS Word, PowerPoint gives you more control over where images and text appear on each page. Learn to use PowerPoint the right way and you’ll be amazed at how quickly you can put together clean and impactful presentations!

Starting Out. PowerPoint shares the same user interface as other MS Office 365 apps and we’ll show you how to navigate it. You’ll learn about the different ways of looking at your slide deck: normal (slide view), outline, sorter, handouts, notes and a few more. We’ll show you how slides are integrated into an automated outline using title and subtitle text boxes.

Design Features. PowerPoint offers several built-in features to make your presentations look like they’ve been professionally produced. You’ll try out choosing different templates, themes, and layouts to find the style most appropriate for your audience. We’ll also demonstrate PowerPoint Designer, an AI tool that examines the text on each slide and suggests attractive design schemes and relevant accompanying illustrations.

Formatting Text. You won’t get all the options you see in MS Word, but PowerPoint still lets you create bulleted and numbered lists, indented paragraphs, and the usual font, tab and color options. Squeezing text into available spaces on a PowerPoint slide is indeed an art form!

Adding Graphics. You can spice up your slides by inserting pictures, shapes, and clip art. PowerPoint gives you access to millions of clip art illustrations and stock photos. We’ll show you how to resize, crop, and position them exactly where you want them, and order them in front of, or behind, other graphics. You can even import charts and tables from Excel.

Delivery. Most PowerPoint files are presentations meant to be delivered in real-time in front of an audience. Fortunately PowerPoint offers a number of features to perfect your delivery, from slide transitions to handouts to timing practice. We’ll show you how to keep those butterflies in your stomach by using these features to ensure your presentation is well-received.

This class is for anyone who needs to create or edit high-quality presentations with complex combinations of text, graphics, tables and charts.

Module 1: Planning, Content, and Delivery

Learning Outcomes:

1. Discover presentation strategies to keep audience members engaged and increase retention.
2. Learn common mistakes people make while building presentations and how to avoid them.
3. Learn to create slides with just the right amount of information and what to do with the remainders.

 Topics:

• Using Storytelling Techniques in PowerPoint
• Techniques for Reporting Information Effectively
• Avoiding Boring PowerPoints
• Other Hard-To-Avoid Common Mistakes
• When to Read Slides Out Loud in a Monotone
• Handling Data-Heavy Presentations and Individual Slides
• Researching your Audience and Adapting your Presentation
• Using the Presenter View
• When to Use Humor and Animation
• Strategies To Reduce Information Overload
• Techniques to Increase Retention
• Making Content Decisions: Dropping, Moving, or Expanding

Module 2: Designing Clean and Impactful Slides

Learning Outcomes: 

1. Learn the three most important graphic design rules to ensure a clean and professional look.
2. Learn how to use font effects and techniques to catch the audience’s attention.
3. Learn how to optimally format and place images and bullets in slides.

Topics: 

• Using PowerPoint as a Written Document
• Font Choices: Size, Readability and Other Matters
• Creating “Clean” Designs
• 3 Graphic Design Rules You Must Know
• What To Do with Too Much Information
• Creating Slides our Brains Naturally Understand
• Design Tips and Tricks for Non-Designers
• Imagery Placement, Backgrounds, Borders and More
• Bullets Have Their Own Set of Rules

Worried your audience will find your presentation difficult to follow, or worse, boring? It’s one thing to carefully put all your insights and data into a presentation, but it’s another thing entirely to keep an audience engaged as you deliver it. You’ll also need to optimize your slides so they’re easy for you to narrate and easy for your audience to understand and remember. This class gives you the tools and techniques to make sure your presentations will be enjoyed, understood, and remembered (even if you’re not a high-energy speaker).

Engaging Presentations. We’ll show you what to know about your audience, how to adapt your presentation to them, how to use storytelling techniques, and how to get your audience to grasp and remember critical points.

Optimal Slide Content. We’ve all seen slides crammed with too many bullets and images. We’ll teach you the rules for when to make the difficult decision to drop content. You’ll also learn multiple ways to make content available outside your presentation. We’ll also teach you how to selectively emphasize the most important content, and when to use animations and humor.

Design Considerations. PowerPoint isn’t Photoshop, so it’s surprising how design choices can make the difference between a dull and an engaging presentation. Learning just a few simple design rules will make a big difference in how well your audience receives your presentation. Whether image backgrounds, white space, or fonts, following a few design rules and norms will ensure you create nothing but “clean” slides!

This class is for presenters who are familiar with PowerPoint features but need to get better at delivering presentations and conveying information effectively.

Day 1:

Outcomes:

• Learn the two key principles for creating relevant, concise content
• Structure the beginning, middle, and end of your presentation for engagement and impact
• Incorporate contrast into your delivery
• Elevate your presentation with better slide management

Outline:

• 2 Key Principles
• Learnit’s 3x3 Presentation Guidelines
• 3 Elements of Delivery
• Working with Visuals

Day 2:

Outcomes:

• Practice on your real-life presentations
• Learn to apply these skills in a way that best suits you
• Improve confidence with mindset shift
• Become situationally ready for every type of question

Outline:

• Practice elements of presentations
• The Presenter’s Mindset
• Challenge Limiting Beliefs
• Types of questions
• Advanced Q&A maneuvers

Great ideas don’t announce themselves. They need a champion, someone to present them in a clear, compelling, and memorable way. That’s what this series of workshops is designed to do. Whether it’s a keynote address, pitch or status update, this series of workshops and coaching sessions will help you bring your presentation to life. Topics covered include:

Compelling Content

This workshop covers a complete process–from the beginning, middle, and end of your presentation–for identifying what to keep, what to leave out, and how to shape your remaining content for the greatest impact. 

Dynamic Delivery

This workshop teaches you how to use your body, voice and eyes to enhance engagement and understanding.

Confidence and Q&A

This workshop will help you stand in front of any audience with greater poise and confidence as well as give you the tools to handle even the toughest of questions.

Small Group Coaching

Because the skills learned during this series must be practiced, we’ve designed this series to include at least one small group coaching session with feedback from your instructor and each other.

Anyone who regularly delivers presentations, either virtually or in-person, or anyone who wants to improve their presentation skills.

• Getting Started with Python
• Fundamentals of Python Programs and Program Development
• Python Functions
• Python Sequences: Lists, Tuples, and Ranges
• Control Flow Statements
• Repetition Control Statements
• List Processing
• String Processing
• Sets and Dictionaries
• File Input/Output
• Object-Oriented Programming in Python

Learn the fundamentals of Python with our 3-day Python Fundamentals course.

This course is for programmers.

• The importance of risk management for organizations 
• Risk identification and analysis
• Approaches for identifying risks 
• Techniques for analyzing the probability and impact of a risk 
• Risk prioritization
• Developing a risk management plan
• Introduction to the RAID log 
• Approaches for managing risk 
• Creating mitigation and contingency plans 
• Embedding risk management into the organizational culture 

Learn skills you need to help maintain success and continuity at your organization with this key risk management training.

Risk management is essential for organizations of all sizes as it helps to identify, analyze, and mitigate risks that could negatively impact operations, projects, finances, reputation, and people. By effectively managing risks, leaders and teams can minimize losses, avoid legal and regulatory penalties, and ensure the continuity of business operations. Risk management also enables organizations to make informed decisions and allocate resources more efficiently, which can lead to improved performance and competitive advantage.

Outcomes:

• Understand key components of the risk management process and why it is important
• Know the difference between a risk and issue, along with how to prioritize efforts
• Be able to identify, analyze, and determine the best approach for managing risk
• Ability to track risks in an organized and efficient way
• Knowledge on how to encourage risk management within your organization

This workshop is designed for leaders, people managers, project managers, and individual contributors who want to better manage risks and issues.

• 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

Focus on psychological safety training to have more inclusive meetings at work.

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. 

What We’ll Explore:

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

This course is designed for people who lead virtual, in-person, or hybrid meetings.

Day 1 - Topics 

Introduction to SQL Usage and Terminology 

• What is SQL and What can SQL Do? 
  
• SQL Keyword Command Language and Hierarchy 
  
• Introduction and Usage of the Select Clause Statement 

Executing A Simple Query 

• Connect to a SQL Database 
  
• Query a Database. 
  
• Save a Query. 
  
• Modify and Execute a Saved Query 

Performing Queries Using Criteria Conditions 

• Query Using One or More Conditions 
  
• Query for a Range of Values and NULL Values 
  
• Query Data Using Wildcard Characters 
  
• Applying And/Or Operators 
  
• Format Column Headings with Aliases 
  
• Format Query Results Data 

Day 2 - Topics 

Summarizing Data with Mathematical Functions 

• Perform Date Calculations 
  
• Summarize Data Using Aggregate Functions 
  
• Manipulate Text Results with String Functions 
  

Organizing Query Data Results 

• Sort Data with “Order By” Clause 
  
• Group Data with “Group By” Clause 
  
• Rank Data Using “Rank” Function 
  
• Filter Grouped Data 
  
• Summarize Grouped Data 
  
• Use PIVOT and UNPIVOT Operators 
  

Retrieving Data from Multiple Tables 

• Understanding SQL Joins 
  
• Retrieve Data by Joining Tables 
  
• Combine the Results of Two Queries 
  
• Compare the Results of Two Queries 
  
• Introduction into Sub-Queries 
  

Exporting Query Results 

• Export to Excel Workbook 
  
• Generate a Text File 

• Introduction to SQL Usage and Terminology 
• Executing Simple Queries 
• Performing Queries Using Criteria Conditions 
• Summarizing Data with Mathematical Functions 
• Organizing Query Data Results  
• Retrieving Data from Multiple Tables 
• Exporting Query Results 

This course has been designed for individuals who wish to learn how to use SQL to query databases and extract information. The only requirements for attending this course are:

• Basic computer literacy skills 
• Familiarity with database structure and terminology 

*Please Note: A Mac environment will not work for this class

Outcomes:

• Understand the different parts of MS SharePoint.
• Efficiently navigate your organization’s SharePoint Team Site.
• Create SharePoint Libraries; upload and organize documents.
• Integrate SharePoint with Office 365.
• Collaborate with coworkers to edit documents and track workflows.
• Use SharePoint sort, filter, tagging, and search tools.
• Customize user views to improve their user interface.
• Create and edit SharePoint Lists to organize and share your organization’s data.
• Create, design and interlink Site Pages to build out a site.

Day 1 Topics:

• Understanding the SharePoint Structure and Components
• The SharePoint Apps Ecosystem
• How Site Permissions Affect User Access
• Navigating Your Company's SharePoint Team Site
• Using the Quick Launch and Top Link Bars
• Accessing Site Apps Through the Site Contents Area
• “Following” Sites
• Understanding SharePoint Libraries
• Creating SharePoint Libraries for Document Files
• Adding Files to A Library
• Creating Library Folders
• Different Types of Libraries
• Integrating SharePoint with MS Office Programs
• Opening and Editing Library Documents
• Working with the Office 365 On-Line Apps
• Editing in Office 365 On-Line vs. Desktop Apps
• Collaborating with Others in the SharePoint Environment
• Working in Simultaneous Multi-User Environment
• Understanding and Managing Versioning
• Using the Check-Out/Check-In Process to Ensure Single User Editing
• How the Content-Approval Process Works
• What Happens to Deleted Documents
• Using Alerts to Keep Up-To-Date on Users’ Activities in a Library

Day 2 Topics:

• Using Sort, Filter, And Search Tools; Locating Documents
• Understanding Search Levels
• Grouping Library Documents
• Customizing User Views
• Controlling the Visibility of Column Information
• Creating New Columns in a Library or List
• Creating Team and Personal Views
• Tracking Data with SharePoint Lists
• Creating New Lists
• Creating Records in a List
• Using Links Lists
• Calendars
• Task Lists
• Exporting Excel Data into a SharePoint List
• How Site Pages Are Used in SharePoint
• Creating and Formatting Site Pages
• Creating Links and Adding Content
• Creating and Configuring New SharePoint Sites as a Site Owner
• Adding News Pages and Quick Links
• Assigning Access Rights to Team Members
• Configuring Site Settings, Navigation and Search Capabilities

SharePoint is similar to WordPress in that it is a customizable website with add-ons, but unlike WordPress, SharePoint is specifically for intranets: websites visible to employees only. For the add-ons, Microsoft has collected the best features of its software applications. Which applications? Here are some: spreadsheets, calendars, contact lists, file shares, instant messaging, wikis, task lists, discussion boards, workflows, etc. – pretty much everything and the kitchen sink. Working in a SharePoint environment can be confusing at first since you’re presented with so many individual features – but with our trainer’s guidance and some hands-on practice, you’ll learn how the parts fit together and quickly become productive.

Sites and Apps. A “Site” is SharePoint’s term for a section of your intranet, for example, the Accounting department of your organization. In that Site you might find a contact list of employees in that department, a shared calendar of tax deadlines, a document library of tax forms, and a set of workflows for accounts receivable and payable. To set up these features, the site owner would have earlier installed a corresponding “App” to add sections to the Site to handle those features. We’ll show you how to navigate the basic Site structures and use the most common Apps.

Office 365 Collaboration. Since you can upload MS Office files to SharePoint, it only makes sense that you should be able to edit them inside a web environment, and indeed you can. You can also choose whether to have exclusive editing abilities (check-in/check-out features), or if you want to have multiple employees be able to simultaneously edit Excel, Word, and similar files, just like Google Docs. We’ll also show you how to set up content approval workflows using versioned documents where employees handle them at different stages.

Lists and Libraries. Whether your data is from a worksheet in Excel, an address book from Outlook, or a timeline of dates and duration from MS Project, these all have the same structure: they are lists of rows with column headings. SharePoint makes it easy to work with “Lists” like these – and in this class you’ll learn how to put them to good use. “Libraries,” on the other hand, are like folders full of documents, but with extra features that make it easier to organize and search them. We’ll show you when to use Lists and when Libraries are better.

This class is for end users that are new to SharePoint and want to learn how they can create, update, and find resources on their organization’s internal SharePoint sites.

Sleep Importance 

• The ugly side of sleep deprivation 

Sleep Protocols 

• Light and dark sleep cycles 
• How to apply most current science sleep advice 

Self-care methods

• The importance of looking after you 
• How to take action and implement self-care strategies immediately 

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. 

What We’ll Explore:

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

This workshop is suitable to any person who wants to gain a better understanding of their sleep patterns and best practices for making self-care a daily priority.

Lessons 

• Create project workspaces 
  
• Create and manage tasks 
  
• Launch different views for your projects 
  
• Set sharing permissions for real-time collaboration 
  
• Linking cells, attaching task & project-related files, and setting reminders 
  
• Adding Contacts 
  
• Formatting your Sheets 
  
• Create dashboards and reports 
  
• Create workflows 
  
• Automate alerts and approvals 
  
• Create forms for data gathering 

Smartsheet Intro is for businesspeople of all types who could benefit from tighter, clearly defined process and projects. In this Smartsheet training, you will learn best practices, methodology, and mechanics around how to build and share collaborative checklists, project plans, calendars, and dashboards. Smartsheet is ideal for waterfall and agile projects, product launches, planning, events, and more.

Outcomes: 

• Be able to build and share collaborative Project Plans 
  
• Can create and publish reports 
  
• Ability to create Dashboards to Visualize your Data 
  
• Can add and manage tasks on a sheet 
  
• Can format sheet content to color code tasks 
  
• Ability to set automated alerts and tasks within a Project 
  
• Be able to create forms to obtain data

Our Smartsheet training is perfect for leaders, managers, and team members involved in projects.

Note: Smartsheet is an online subscription-based tool. Attendees may use a free trial membership for this course. This course addresses topics available in the team-level plan.

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

Focus on your communication skills training and improve your communication in the workplace.

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

What We’ll Explore:

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

This training is a good fit for anyone who wants to ensure their verbal contributions are heard, understood and valued.

• 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

Focus on your business storytelling training with this interactive workshop.

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. 

What We’ll Explore:

• 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

This workshop is for anyone who needs to bring ideas to life and motivate people to action. It is ideal for leaders or those whose job entails high degrees of information sharing, vision setting and persuasion.

• What is strategic thinking? 
• Four applications of strategic thinking 
• Mental models to support your strategic thinking 
• The strategic thinking toolkit 

Strategic thinking is all about seeing the bigger picture. In this workshop, participants will discover how to adopt the mindset of a strategic thinker by gaining a wider perspective to take on challenges and obstacles. While not a workshop designed to help you develop a specific business strategy, the tools and frameworks explored in this course will allow you to build skills to analyze and challenge the status quo, foster a more competitive mindset, and thrive through challenges. 

What We’ll Explore:

• Define and explore what strategic thinking is 
• Attributes of strategic thinking 
• Toolkit for Strategic Thinking 

This workshop is ideal for those who want to improve their strategic thinking and apply it to commonly encountered issues, especially managers and individual contributors.

• Reasons for evaluating and improving processes 
• An introduction to the DMAIC process improvement model 
• 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 
• Getting the team aligned on process improvements

Increase your productivity at work by developing your process improvement skills.

These days we all know what it feels like to be asked to do more with less. More productive, more efficient, more effective and all with fewer resources. In this data-driven process improvement workshop, we will help you find ways to get better business results by understanding root causes of process challenges and directly addressing them with proven problem-solving techniques.

What we’ll explore: 

• The DMAIC model and problem-solving
• Developing a project charter
• Use Root Cause Analysis tools

This workshop is for anyone looking to discover and improve their individual perseverance when the going gets tough.

• A model to build emotional intelligence for others 
• Emotion scientist vs. emotion judge 
• How to build empathy 
• Ways to engage and work effectively with others 
• A communication model to help build connection with others

Focus on your emotional intelligence training by developing your social awareness skills.

In this workshop, participants will learn how to use emotional intelligence to understand, connect, and work with others more effectively. The course is built on two emotional intelligence pillars: Empathy and Relationship Management and draws from the latest research and trends in emotional intelligence, including “emotion scientist,” observation, and active listening. Participants will leave with enhanced levels of understanding about the emotional experiences of others and how to connect and manage relationships in the workplace and in their personal lives.

What We’ll Explore:

• Understand the two key components of social awareness 
• Learn to perceive the emotions of others 
• Understand how to interpret and find meaning behind those emotions 
• Learn ways to build trust and earn respect to work more effectively with others 
• Identify our unconscious biases and learn ways to minimize or reduce them

Anyone who is curious about ways to positively affect their interactions with others through a deeper understanding and practice of emotional intelligence will benefit from this workshop, including individual contributors, middle managers, team leaders, senior managers, and senior leaders.

Module 1: Connecting to data sources

• Connecting to text, Excel, Access, and SQL files
• Pasting from a clipboard
• Connecting to other databases
• Connecting to Windows Azure Marketplace
• Understanding dimensions and measures
• Changing data types
• Applying filters
• Merging multiple data sources

Module 2: Creating univariate charts

• Creating tables
• Creating bar graphs
• Creating pie charts
• Sorting the graphs
• Creating histograms
• Creating line charts
• Using the Show Me toolbar
• Creating stacked bar graphs
• Creating box plots
• Showing aggregate measures
• Showing the top 10 items

Module 3: Creating bivariate charts

• Creating tables
• Creating scatter plots
• Swapping rows and columns
• Adding trend lines
• Selecting color palettes
• Using dates

Module 4: Creating multivariate charts

• Creating facets
• Creating area charts
• Creating bullet graphs
• Creating dual axes charts
• Creating Gantt charts
• Creating heat maps

Module 5: Creating maps

• Setting geographic roles
• Placing marks on a map
• Overlaying demographic data
• Creating choropleth maps
• Using polygon shapes
• Customizing maps

Module 6: Calculating user-defined fields

• Using predefined functions
• Calculating percentages
• Applying the If-Then logic
• Applying logical functions
• Showing totals
• Showing the percentage of totals
• Discretizing data
• Manipulating text
• Aggregating data

Module 7: Customizing and saving

• Adding title and caption
• Modifying font sizes and colors
• Applying various marks
• Adding colors, labels
• Changing marks sizes
• Adding reference lines
• Printing to PDF
• Saving packaged workbooks
• Creating a workbook data extract

Module 8: Exporting and saving

• Saving a workbook on a Tableau server
• Saving a workbook on the Web
• Exporting images
• Exporting data

Module 9: Exploring advanced features

• Viewing data
• Changing the mark size
• Using the presentation mode
• Adding annotations
• Excluding data on the fly
• Customizing mark shapes
• Adding drop-down selectors
• Adding search box selectors
• Adding slider selectors
• Creating dashboards
• Creating animated visualizations
• Creating parameters

Module 10: A short dash to dashboarding

• Preparing for your first dashboard
• Showing the power of data visualization
• Connecting to data sources
• Introducing the Tableau interface
• Interacting with your first data visualization
• Sharing your visualization with the world

Module 11: Summarizing your data for dashboards

• Arithmetic – the queen of mathematics!
• Dashboards and dates
• Grouping your data with calculations
• Correlation with calculations
• Using cross-tabs flexibly
• Simplifying your business rules with custom calculations

Module 12: Interacting with data for dashboards

• Fun with filters – grouping your data with clarity
• Hierarchies for revealing the dashboard message
• Classifying your data for dashboards
• Actions and interactions
• Drilling into the details
• Working with input controls

Module 13: Using dashboards to get results

• Enriching data with mashups
• Page trails
• Guided analytics with Tableau
• Sharing your results in a meeting
• Notes and annotations
• Using external data to enrich your dashboard

Module 14: Putting the dash into dashboards

• Choosing your visualization
• Using parameters in dashboards
• Using custom geocoding in Tableau
• Profiting from Big Data to rev your visualization
• Filtering your data for focus
• Creating choices in dashboards using conditional logic

Module 15: Making dashboards relevant

• Adding an infographic to your Tableau dashboard
• String manipulation in dashboards
• Correcting data exports from Tableau to Excel
• Blending data
• Optimizing tips for efficient, fast visualization

Module 16: Visual best practices

• Coloring your numbers
• Dueling with dual axes
• Where is the three-dimensional data?
• Eating humble pie – Pie charts or not?
• Sizing to make a data story

Module 17: Tell the world! share the dashboards

• Packaging workbooks with data
• Publishing dashboards to Tableau Server
• Publishing dashboards to Tableau Public
• Mobilizing your dashboards
• Mixing Tableau with Power BI

As a continuation of the Tableau Introduction Training Course, this Advanced course is designed to boost the student’s competence when it comes to creating visualizations, and creating dashboards.

The course goes into considerable detail on these two subjects, and explores, among other areas, how to create a range of different charts, maps, user-defined fields, as well as a host of advanced features and abilities.

Any student taking this course should have already completed the Introductory Tableau course, or who have obtained experience with the fundamental concepts of Tableau through any other means.

Please note: This class requires participants to preinstall Tableau Public Version Prior to enrolling, please confirm you will have access to the Tableau Public Version, as well as authorization from your IT department. Further, this class will not be available for Mac users.

Module 1: Creating your first visualizations and dashboard

• Connecting to data in Access
• Foundations for building visualizations
• Bringing everything together in a dashboard

Module 2: Working with data in Tableau

• The Tableau paradigm
• Connecting to data
• Working with extracts instead of live connections
• Metadata and sharing data source connections
• Joins and blends
• Filtering data

Module 3: Moving from Foundational to Advanced Visualizations

• Comparing values across different dimensions
• Visualizing dates and times
• Relating parts of the data to the whole
• Visualizing distributions
• Visualizing multiple axes to compare different measures

Module 4: Using row-level and aggregate calculations

• Creating and editing calculations
• Three levels of calculation
• Parameters
• Practical examples of calculations and parameters
• Ad hoc calculations
• Performance considerations

Module 5: Table Calculations

• An overview of table calculations
• Quick table calculations
• Scope and direction
• Addressing and partitioning
• Advanced table calculations
• Practical examples

Module 6: Formatting a visualization to look great and work well

• Formatting considerations
• How formatting works in Tableau
• Adding value to visualizations

Module 7: Telling a data story with dashboards

• Dashboard objectives
• Example – is least profitable always unprofitable?
• How actions work
• Example – a regional scorecard
• Story points

Module 8: Adding value to analysis - trends, distributions, and forecasting

• Trends
• Distributions
• Forecasting

Module 9: Making data work for you

• Structuring data for Tableau
• Dealing with data structure issues
• An overview of advanced fixes for data problems

Module 10: Advanced techniques, tips, and tricks

• Sheet swapping and dynamic dashboards
• Leveraging sets to answer complex questions
• Mapping techniques
• Using background images

Module 11: Sharing your data story

• Presenting, printing, and exporting
• Sharing a workbook with users of Tableau Desktop or Tableau Reader
• Sharing data with users of Tableau Server, Tableau Online, and Tableau Public

The Tableau Basic Training Course is designed as an introduction to Tableau for beginners. On completing the course, students will have a firm grasp of the basic techniques required to create visualizations, and combine them in interactive dashboards. Specifically, students will meet the following learning outcomes, among others:

• Creating foundational to advanced visualizations
• Working with data in Tableau
• Moving from Foundational to Advanced Visualizations
• Using row-level and aggregate calculations
• Formatting a visualization for appearance
• Adding value to analysis
• Advanced techniques, tips, and tricks for Tableau

As an introductory course, students are expected to have some experience using Microsoft Excel, but do not require any other prerequisite skills.

Please note: This class requires participants to preinstall Tableau Public Version Prior to enrolling, please confirm you will have access to the Tableau Public Version, as well as authorization from your IT department. Further, this class will not be available for Mac users.

Part 01: Effectively use Outlook to strategize our day  

Turning on The To-Do Bar  

• Creating and viewing Tasks  

Tools for Efficiency   

• Flagging messages for follow-up  
• Assigning and managing Categories for email   
• Assigning and managing Categories for Calendar items   

Tools for Effectiveness  

• Filtering by flagged messages  
• Arranging by Categorized messages  
• Using search folders to find flagged and Categorized messages  

Applying the Pareto Principle  

• Assigning your top tasks as high importance   
• Marking flagged items with high importance  

Part 02: Increase our regulation of time using Outlook  

REP Plan (Record, Estimate, Prioritize)  

• Managing Tasks with the To Do App  
• Creating a Task from a Message  
• Delegating a Task to someone else  

Calendar blocking with assigned Categories  

Part 03: Other Time Management Tools  

User-action tools:  

• Applying and managing Quick Steps  

Automated tools:  

• Applying Conditional Formatting  
• Applying and managing Rules  

You agree that time is important. You are looking for technical tools that extend beyond paper and pencil. Instead of adding yet another program, we will dive in to see what MS Outlook has to offer. How can MS Outlook help to strategize our day? Learn the tools that help to show tasks, filter those tasks, decide, and act accordingly. Take it a step further and automate those actions. The choice is yours; you can create a visual to see a snapshot of important items or you can turn them into a task. It is time to learn practical tools that can help you to better plan and execute all that you must conduct on any given day.

What We’ll Explore:

This workshop is for experienced Outlook users. If Outlook is the designated task-based tool in your environment and you want to learn to use it more efficiently, this course is for you.

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

Develop your conflict resolution skills by learning how to turn debate to dialogue during conflict in the workplace.

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.

What We’ll Explore:

• 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

This training is best suited for anyone who regularly works with challenging people. It’s ideal for managers but will be a good fit for anyone, from individual contributors to leaders.

• Getting Connected Exercise
• Unconscious Bias: What It Is, How It works and How to Disrupt It (in real-time)
• Neuroscience behind Unconscious Bias
• Thinking Slow vs. Fast
• The Practice of Cultural Humility
• Moving into Action (application of this training back at work)
• Practicing the 5 Steps for Disrupting Unconscious Bias
• Calling-In vs. Calling-Out
• Creating your own Action Plan
• Post-training (optional)
• Recommended Reading & Video Clips
• Homework Assignment

Unconscious Bias Training Beyond Bias: creating connections and collaboration at work is a learning session offering participants practical strategies to identify and overcome unconscious biases that affect relationships and collaboration in the workplace. This training focuses on creating connections and collaboration that are free from the influence of unconscious bias. Through interactive exercises and discussions, participants will gain a deeper understanding of the impact of unconscious bias, learn how to identify and address it in real-time, and expand their capability to create more inclusive and collaborative work environments.

What We’ll Explore:

• Understand the impact of unconscious bias and its negative effects on relationships.
• Learn practical strategies to overcome unconscious bias in real-time.
• Learn how to promote collaboration and build stronger connections with colleagues.

This training is suitable for individuals at all levels of an organization, including staff-level, middle-management, and senior leaders, and anyone aiming to build bias-free relationships and promote collaboration.

We recommend this program as a prerequisite to any future Diversity, Equity & Inclusion work.

Module 3

Lesson 1: Designing Advanced Plans and Diagrams

• Create a Microsoft Account and Log in to Visio
• Build Advanced Plans
• Build Advanced Diagrams

Lesson 2: Enhancing the Look of Drawings

• Use 3-D Shapes
• Work with Shape Styles
• Define Shape Styles
• Apply Backgrounds, Borders, and Titles

Lesson 3: Working with Custom Shapes, Stencils, and Templates

• Create Simple Custom Shapes
• Create Custom Stencils
• Create Custom Templates

Module 4

Lesson 4: Connecting Drawings to External Data

• Make an Organization Chart from an Excel Spreadsheet
• Generate a Pivot Diagram from an Excel Spreadsheet
• Create a Gantt Chart from a Project File
• Create a Timeline from a Project File
• Connect a Map to an Access Database

Lesson 5: Leveraging Development Tools

• Create Macros
• Modify ShapeSheets
• Build Advanced Shapes

Lesson 6: Sharing Drawings

• Save and Share Drawings with OneDrive
• Review Drawings
• Insert Drawings into Other Office Files
• Export Drawings
• Print Drawings

This provides hands-on instruction, tips and tricks to participants enabling them to create stunning data-driven diagrams and vector graphics. Participants will learn how to: design advanced plans and diagrams, enhance drawings with 3-D shapes, build GANNT charts and Timelines from external data sources, including Excel, Project and Access, and automate processes by building macros.

Knowledge of Visio Introduction concepts and familiarity with MS Office.

Module 1: Building a Flowchart 

This module will help you to navigate Visio and show you how to create beautiful visuals to represent your ideas, data, and so much more.  

Outcomes: 

• Navigate Visio Interface with ease 
  
• Create and build a flowchart 
  
• Can create an organization chart 
  
• Be able to design a floor plan 

Lesson 1: Getting Started with Visio 2016 

• Perform Basic Tasks in the Visio Environment 
  
• Use Backstage Commands 
  
• Save a File 
  

Lesson 2: Working with Workflow Diagram Tools 

• Use Drawing Components 
  
• Modify a Drawing 
  
• Insert Callouts and Groups 
  

Lesson 3: Building Organization Charts 

• Create an Organization Chart Manually 
  
• Create Organization Charts by Using Starter Diagrams and the Organization Chart Wizard 
  
• Modify an Organization Chart 
  

Lesson 4: Designing a Floor Plan 

• Make a Basic Floor Plan 
  
• Model a Room Layout 

Module 2: Cross-Functional Flowcharts & Diagrams 

This module introduces cross-functional flow charts and diagrams  that help organize your projects and ideas in a visual way.  

Outcomes: 

• Can create cross-functional flow charts 
  
• Can use layers in a diagram 
  
• Ability to modify shapes and connectors 
  
• Be able to use containers to organize tasks  

Lesson 5: Building a Cross-Functional Flowchart 

• Create a Cross-Functional Flowchart 
  
• Format a Cross-Functional Flowchart 
  

Lesson 6: Designing a Network Diagram 

• Create Network Diagrams 
  
• Use Shape Data 
  
• Use Layers 
  

Lesson 7: Styling a Diagram 

• Modify Shape and Connector Styles 
  
• Apply Themes and Variants 
  
• Use Containers 

This hands-on course introduces participants to simplifying and communicating information through data-driven visuals. Participants will learn how to: build organizational charts, design a floor plan, and create network diagrams.

• Definition and personal exploration of whole health
• Why does it matter?
• The science of whole health
• Four pillar exploration: emotional wellbeing, physical activity, nutrition, sleep patterns

Our physical, mental, and emotional well-being matter more now than ever before. Gain control of your whole health through the learning of science-backed research and resources. Discover how to achieve work-life balance with an emphasis on nutritious eating, exercise, sleep, and emotional well-being. Take care of your whole health and you will realize the benefits of stress reduction, reduced illness, increased work productivity, and even a positive mindset. 

What We’ll Explore:

• Investigate what whole health means and its importance in your work-life balance. 
• Learn the science basics behind exercise, nutrition, sleep, and emotional well-being.
• Apply the workshop principles to approach lifestyle changes that focus on your whole health.

This workshop is for anyone looking to take charge of their health by making healthful changes in their diet, activity levels, sleep patterns and emotional well-being.

Module 5:

Outcomes:

• Add graphic and multimedia into a document.
• Collaborate with co-workers on revising a document.
• Create academic references and links.

Lesson 1: Manipulating Images

• Integrating Pictures and Text
• Adjusting Image Appearance
• Applying Artistic Effects
• Inserting Other Media Elements 

Lesson 2: Using Custom Graphic Elements

• Creating Text Boxes and Pull Quotes
• Adding WordArt and Other Text Effects
• Drawing Shapes
• Creating Complex Illustrations with SmartArt 

Lesson 3: Collaborating on Documents

• Turning Track Changes On and Off
• Marking Up a Document
• Reviewing Markups
• Accepting and Rejecting Changes
• Merging Changes from Other Documents 

Lesson 4: Adding Document References and Links 

• Adding Captions
• Adding Cross-References
• Adding Bookmarks
• Adding Hyperlinks
• Inserting Footnotes and Endnotes
• Adding Citations and a Bibliography 

Module 6:

Outcomes: 

• Secure a document with user-level access and password protection.
• Create fillable forms and distribute digitally signed documents.
• Create macros to automate repetitive tasks.

Lesson 5: Securing a Document

• Suppressing Information
• Setting Formatting and Editing Restrictions
• Restricting Document Access
• Adding a Digital Signature to a Document 

Lesson 6: Using Forms to Manage Content

• Creating Forms
• Modifying Forms

Lesson 7: Automating Repetitive Tasks with Macros 

• Automating Tasks by Using Macros
• Creating a Macro

Once you’ve learned and worked with the standard features of MS Word, you’ll be ready for some of its more advanced functions. For this class, we’ve curated the most popular and useful advanced-level MS Word techniques and tools. Whether you need to enhance your document with multimedia; collaborate with other authors and editors; or even add fillable forms – this class will expand your word processing toolset.

Graphics. A common misconception is that Word only offers cropping, resizing, and alignment of images. Did you know that you can also add shadows, reflections, 3-D bevels, and apply artistic effects like blurs and texture transforms? We’ll show you how to add some flair to your images and even create new graphics with “SmartArt” and the “Draw Shapes” tool.

Collaboration. One of Word’s most powerful – and frequently used – features is tracking changes in a document and highlighting them for acceptance or rejection by other team members. We’ll show you how to set up, and participate in, this review process.

References. MS Word offers a number of academic reference features like footnotes, endnotes, citations, cross-references and bibliographies. You’ll learn how to use these and also incorporate hyperlinks in your documents.

Security and Forms. MS Word is a great tool for surveys, forms, or other types of documents used to collect data. We’ll show you how to create and distribute fillable forms you can email to others. You’ll also learn how to restrict edit permissions and digitally sign your document to prove its authenticity.

Macros. If you find yourself performing the same sequence of steps again and again in your documents, you might consider using a “macro” to automate the process. We’ll teach you how to memorize a set of actions in MS Word and replay them again with a single keystroke.

This class is for capable MS Word users who want to increase their proficiency by learning a curated set of advanced techniques including multi-user features, macros, forms, and academic references.

Module 3:

Outcomes:

• Create and modify tables and charts.
• Customize and apply styles and themes.
• Create “building blocks” and “quick parts” to encapsulate content.
• Use built-in templates and create new ones.

Lesson 1: Organizing Content Using Tables and Charts

• Sorting Table Data
• Controlling Cell Layout
• Performing Calculations in a Table
• Creating Charts
• Adding an Excel Table to a Word Document 

Lesson 2: Customizing Formats Using Styles and Themes

• Creating, Applying and Modifying Text Styles
• Creating Custom List or Table Styles
• Applying Document Themes 

Lesson 3: Inserting Content Using Reusable Content

• Inserting Building Blocks
• Creating and Modifying Building Blocks
• Inserting Fields Using Quick Parts 

Lesson 4: Using Templates to Automate Document Formatting 

• Creating a Document Using a Template
• Creating and Modifying a Template
• Managing Templates with the Template Organizer 

Module 4:

Outcomes: 

• Control document flow with section breaks and content controls.
• Add a Cover Page, Table of Contents and Index.
• Conduct mail and email merge processes.

Lesson 5: Controlling the Flow of a Document

• Controlling Paragraph Flow
• Taking Advantage of Section Breaks
• Defining and Managing Columns
• Linking Non-Contiguous Text Boxes with Text Overflow 

Lesson 6: Simplifying and Managing Long Documents

• Creating Cover Pages
• Adding an Index
• Inserting and Updating a Table of Contents
• Inserting an Ancillary Table
• Managing Outlines
• Creating a Master Document

Lesson 7: Using Mail Merge To Send Multiple Customized Documents 

• The Mail Merge Feature
• Merging Printed Envelopes and Labels 
• Merging Customized Emails with Outlook

Sooner or later every user of MS Word encounters a document produced by a power user. When that happens, you may find yourself bewildered by an array of features that are impossible to edit unless you know how they work: tables of contents; multiple headers and footers; linked text boxes; and more. This class will demystify, and enable you to start working with, those kinds of sophisticated documents.

Tables and Charts. MS Word has a number of features borrowed from its software sibling, Excel. You can embed charts and mini-spreadsheets in your documents and keep the data within Word, or link to an external Excel data file. We’ll show you how to format tables in Word so they look clean and impactful; add formulas to them; and generate colorful charts from the data.

Reusable Items. Whether you find yourself frequently reapplying formatting in different places in the same document or generally struggling to maintain a consistent look and feel, MS Word offers a couple killer tools to make your life easier. With custom styles and document themes you can ensure your document looks great throughout. If you’re starting a new document, templates are another feature to save you from reinventing the wheel. Need a resume? A business plan? A report? One click and done! We’ll also show you how to create and manage reusable chunks of content and placeholders that you can sprinkle through your document and have Word update automatically – no more tedious search and replace sessions!

Document Flow. If you’ve used MS Publisher or Adobe InDesign, you’re familiar with the many options for controlling text overflow – but did you know MS Word has those features, too? Beyond simply letting text flow onto the next page, we’ll show you how to link text boxes to merge their content; how to divvy pages up into columns; and when to take use section breaks.

Crowd Pleasers. In your journey toward becoming a master of MS Word, it won’t be long before you encounter the need to add certain advanced features to your documents. We have you covered! We’ll show you how to implement these popular features: cover pages, tables of contents, indexes, and mail (and email) merges.

This class is for MS Word users that can already create, edit, and format documents but who need next-level features like tables of contents, cover pages, charts, embedded spreadsheets, and mail merges.

Module 1:

Outcomes:

• Navigate the “Ribbon” interface in MS Word.
• Create, edit, print and save documents.
• Use keyboard shortcuts and reformatting features.
• Create bulleted and numbered lists.
• Format document text.

Lesson 1: Getting Started with Word 

• Using Menus, Context Menus and the Ribbon Interface
• Creating and Saving Word Documents
• Managing your Workspace
• Previewing and Printing Documents
• Customizing the Word Environment 

Lesson 2: Formatting Text and Paragraphs

• Applying Character Formatting
• Controlling Paragraph Layout
• Aligning Text Using Tabs
• Displaying Text in Bulleted or Numbered Lists
• Applying Borders and Shading 

Lesson 3: Working More Efficiently 

• Making Repetitive Text Edits
• Applying Repetitive Formatting
• Using Styles to Streamline Repetitive Formatting Tasks 

Lesson 4: Managing Lists 

• Sorting Lists
• Formatting Lists 

Module 2:

Outcomes: 

•  Create or import tables within a document.
• Insert images and special characters.
• Apply document layout formatting options.
• Perform final document prep techniques.

Lesson 5: Adding Tables

• Inserting a Table
• Formatting a Table
• Converting Text to a Table 

Lesson 6: Adding Graphics 

• Inserting Symbols and Special Characters
• Adding Images to a Document
• Designating Text Wrap Options for Images

Lesson 7: Controlling Page Appearance 

• Applying a Page Border and Color
• Adding Headers and Footers
• Controlling Page Layout
• Adding a Watermark 

Lesson 8: Preparing to Save a Document 

• Checking Spelling, Grammar, and Readability
• Using Research Tools
• Checking Accessibility
• Saving a Document to Other Formats 

Need to get started with, or freshen up on, MS Word? As Microsoft’s flagship word processor has evolved over the years, it has changed so much that you can no longer just launch it and start typing up documents. Without understanding the right way to use MS Word, you are guaranteed to unnecessarily spend many hours reformatting and tweaking documents to get them to look right. Here’s what you need:

The Basics. The first step in learning MS Word is getting around the interface. If you’ve been using an older version, you’ll probably be surprised by the new “Ribbon’ interface – but don’t worry, we’ll show you how to navigate it. Within short order you’ll be able to create, preview, print, and save documents.

Formatting Text. Beyond changing fonts and colors, you’ll learn: how Word documents are structured into paragraphs with different formats; a tab stop system for aligning text; and borders and shading. We’ll cover two of the most useful text layouts: bullets and numbered lists. You will also learn the top keyboard shortcuts and how to instantly reapply formatting from one chunk of text to another.

Images. Adding an image to a Word document is straightforward. But getting it to align properly with the text can be tricky: there are no less than 7 alignment options, not to mention features for cropping, resizing and styling. We’ll show you the most important configurations to ensure your images beautifully complement the text. 

Tables. Like images, tables are objects with widths, heights, backgrounds, and borders. They also have numerous options for alignment, text wrapping, internal paragraph styles, and even controlling how they conform to page breaks. We’ll show you the most common table layout options.

Document Prep. When you’ve finished writing your document, it’s time to get it ready for printing and distribution. To that end, we cover how to spell-check, set page margins, add headers/footers, and more.

This class is for new MS Word users, as well as those who have some familiarity, but feel that they aren’t using it efficiently or “the right way.”

• 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

Develop your business writing skills to become a professional communication pro.

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 learning to create: emails that are scannable, relevant, and more likely to be read; documents that are more persuasive and by targeting the reader’s WIIFM; and a simple structure for reports that get right to the point while covering the most important information.

What We’ll Explore:

• Frameworks for better emails 
• Writing to persuade and influence
• Reporting clearly and effectively

This is a foundational Learnit course that is a good fit for anyone who wants to fine-tune their writing skills and increase their confidence in written business communication including individual contributors, middle managers, team leaders, senior managers, and senior leaders.