Access Advanced | Learnit
In this live online Access Advanced training course, learn advanced form design techniques, how to use switchboards to navigate database objects, how to design macros to automate database tasks, and more!
Module 5
Advanced Form Design Techniques
Using Switchboards (Menus) to Navigate Database Objects
Designing Macros to Automate Database Tasks
Introduction into Access Visual Basic for Complex Automation
Module 6
Linking Tables to Ensure Database Security
Customizing Database Options
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:
Access Intermediate | Learnit
In this live online Access Intermediate course, learn how table relationships affect queries, control query results with join types, create complex queries with multiple criteria, calculate data with queries, and more!
Module 3
How Table Relationships Affect Queries
Controlling Query Results with Join Types
Creating Complex Queries with Multiple Criteria
Calculating Data with Queries
Module 4
Automating Queries with Parameters
Using Query Wizards
Exploring Action Queries
Advanced Report Design Techniques
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:
IT professionals, data analysts, database users and coordinators, managers and directors, and anyone who uses Access! Access Introduction level training is recommended.
Access Introduction | Learnit
In this live online Introduction to Access training, learn to use data management features of Access in order to make faster and more effective business decisions.
Module 1
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
Module 2
Using Forms for Data Entry
Create Reports for Data 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:
IT professionals, data analysts, database users and coordinators, managers and directors, and anyone who uses Access!
Allyship Training | Learnit Instructor-Led Workshop
Upskill with Learnit to learn how to be an ally in the workplace. Discover how to act for all and empower inclusion at work with this DEI training.
Brave Space vs. Safe Space
The Four Agreements to having Courageous Conversations
Allyship: what it is and what it isn’t
Moving into Action (application of this training back at work)
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:
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.
Emotional Intelligence at Work | Learnit
Upskill with Learnit and foster a success hybrid environment by with this instructor-led emotional intelligence training.
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:
People managers, team builders, people strategists, L&D professionals, coaches
Build Productive Work Habits Workshop | Learnit
Upskill with Learnit and discover how to achieve behavior change by developing productive habits.
What is a habit?
The Process of habit formation
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:
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.
Building Trust with Your Team Workshop | Learnit
Upskill with Learnit and take this leadership workshop to learn how to build trust with your team and practice effective leadership skills.
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:
This training is a good fit for people managers, team builders, people strategists, L&D professionals, and coaches.
Building a Vision for Your Team Workshop | Learnit
Upskill with Learnit and develop your leadership skills to boost productivity and motivate your team.
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:
People managers, team builders, people strategists, L&D professionals, coaches
Career Growth Workshop | Learnit
Upskill with this soft skills course from Learnit designed to empower you 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:
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.
Coaching Skills for Managers Workshop | Learnit
Upskill with Learnit and focus on coaching skills for managers in this leadership training course.
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:
This workshop is designed for leaders, managers, and high-performing individual contributors that want to tap into their coaching potential.
Cohort - Emerging Leader | Learnit
Interactive leadership cohort to equip emerging leaders with management skills they can use right away to help their teams grow and succeed.
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
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.
Leading Today's Workforce
Learn how to lead with confidence and effectiveness in this interactive, live online leadership cohort.
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
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.
Cohort - Present like a Pro | Learnit
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
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.
Cross-Cultural Communication Workshop | Learnit
Upskill with Learnit and our soft skills courses. Focus on your people skills training by developing multicultural communication skills.
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:
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.
Communication Styles Workshop | Learnit
Upskill with Learnit and focus on your communication skills training by learning about communication styles and improving your communication in the workplace.
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:
This training is a good fit for anyone who works on or leads a team from individual contributors to managers.
Creative Thinking for Problem Solving Workshop | Learnit
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:
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.
Critical Thinking Training| Learnit
Upskill with Learnit and improve your decision making and problem solving skills with 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:
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.
Dealing with Conflict Workshop | Learnit
Upskill with Learnit and focus on your conflict resolution training 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:
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
Key Customer Service Skills | Learnit
Live online, interactive customer service strategies workshop: Training to proactively uncover your client’s deeper needs and work toward favorable solutions for you both.
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:
Solid skill development for client experience representatives, salespeople, and client-facing associates.
Emotional Intelligence: Self-Awareness Workshop | Learnit
Upskill with Learnit and develop key self-awareness skills in this important emotional intelligence 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:
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.
Excel Advanced | Learnit
Learn powerful Excel features like database functions, error-handling, goal-seek, solver, and macros — and a collection of professional-level tips and tricks.
Module 5: Advanced Functions
Learning Outcomes:
Topics:
Module 6: Using the "What If" Analysis Toolpack & Implementing Macros
Learning Outcomes:
Topics:
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.
Excel Intermediate | Learnit
Get hands-on training in Excel's top 3 features: advanced tables, charts, and pivot tables. Crush it when you get back to the office.
Module 3: List/Table Essentials & Charting
Learning Outcomes:
Topics:
Module 4: Pivot Tables, Protecting & Linking Data
Learning Outcomes:
Topics:
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:
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.
Excel Introduction | Learnit
Excel basics class with hands-on training in how to build and format spreadsheets that use functions and formulas between cells.
Module 1: Excel Essentials & Formulas and Functions
Outcomes:
Topics:
Module 2: Formatting, Spreadsheet Design, Page Setup & Printing
Outcomes:
Topics:
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:
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.
Excel Pivot Tables | Learnit
Excel pivot tables are difficult to learn on your own. We'll get you up to speed in this critical feature and related topics like pivot charts and power pivot...
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:
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:
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:
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.
Excel Power User | Learnit
Get hands-on training in advanced Excel features: pivot table enhancements, macros and VBA, charting techniques, array functions and more.
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
Advanced Pivot Table Techniques
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
Advanced Conditional Formatting
Advanced Charting
Macros
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.
Excel VBA | Learnit
Learn to code VBA for Excel. The training covers variables, conditionals, loops and error handling. Start adding interactivity to your worksheets now!
Learning Outcomes:
Day 1 Topics:
Introduction to VBA Usage and Terminology
Programming Basics
Creating Decision Structures
Day 2 Topics:
Creating Looping Structures
Designing Custom Dialog Boxes
Debugging and Error Handling
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.
Excel: Intro to Data Analysis | Learnit
Training in data analysis with Excel: sorting, filtering, and data cleanup. Create totals and averages; design charts, pivot tables, and pivot charts.
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
Summary Based IF Functions
Chart Features
Working with Pivot Tables and 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.
Time Management Strategies | Learnit
In this live online interactive Learnit training, learn how to schedule and prioritize your tasks to effectively managing your time.
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:
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.
Effective Feedback | Learnit
Live online, interactive training to learn how to give and receive effective 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:
This is a foundational Learnit training, one that is designed with managers and leaders in mind.
Google Sheets for Excel Users | Learnit
This live online Google Sheets Training for Excel Users class is 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.
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:
Advanced users of Excel
Growth Mindset Course | Learnit
Learn how to adjust your mindset - yes, it's possible - from a fixed to a growth perspective. Our live online workshop teaches how to nurture a growth mindset.
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:
This foundational Learnit training is good for everyone from individual contributors to senior leaders.
Illustrator Advanced | Learnit
Learn to create complex illustrations, format illustrations and type, and prepare documents for print and web in this live online Advanced Illustrator course.
Lesson 1 - Customizing Illustrator
Lesson 2 - Magic Wand Tool
Lesson 3 - Illustrator Graphic Styles
Lesson 4 - Working with Symbols
Lesson 5 - Working with Filters and Effects
Lesson 6 - Creating Graphs and Charts
Lesson 7 - Blend Tools
Lesson 8 - Gradient Mesh Tool
Lesson 9 - 3D Filter
Lesson 10 - Puppet Warp Tool
Lesson 11 - Data Merge for Creating Templates
Lesson 12 - Automating Tasks with 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:
This Illustrator course is recommended for those with some basic training or understanding of Adobe Illustrator.
Illustrator Fundamentals | Learnit
In this entry-level Illustrator course, learn about the components and capabilities of Illustrator CC. Create illustrations that include graphics and text.
Module 1: Introducing Illustrator CC
Module 2: Creating Documents Containing Basic Shapes
Module 3: Creating Documents Containing Customized Paths
Module 4: Creating Graphics Containing Customized Text
Module 5: Customizing Objects
Module 6: Customizing Basic Shapes
Module 7: Preparing Documents for Deployment
Upon successful completion of this course, you will be able to use Adobe Illustrator CC to create illustrations that include graphics and text.
Outcomes:
This is an entry level Illustrator course recommended for all levels.
Business Writing Principles Course | Learnit
Upskill with Learnit and learn the principles of business writing to develop top-notch professional communication skills.
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:
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.
Indesign Advanced | Learnit
In this live online InDesign course, learn various advanced techniques, including text formatting, text frames, paragraph and character styles, interactivity, setting up and flowing a Table of Contents, and more!
Lesson 1 - InDesign Interface & Setup
Lesson 2 – Creating Documents using Templates
Lesson 3 – Graphic Design Principles and Illustrations
Lesson 4 – Advanced Text Frame Techniques
Lesson 5 – Advanced Text Formatting Techniques
Lesson 6 - Working with Larger Documents
Lesson 7 – Advanced Paragraph and Character Styles
Lesson 8 – Working with Tables
Lesson 9 – Creating a Book Document
Lesson 10 - Interactivity
Lesson 11 - Data Merge Postcard Mailers
Lesson 12 - Create Document with Alternate Layouts
Lesson 13 – Publishing Your Document for Printer
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:
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.
InDesign Fundamentals | Learnit
Learn to navigate and customize the InDesign interface and create and deliver professional-looking printed and interactive documents in this live online InDesign Fundamentals course.
Lesson 1 - InDesign Interface & Setup
Lesson 2 - Creating a New Document
Lesson 3 - Working with Shapes
Lesson 4 - Creating a Basic Poster
Lesson 5 - Working with Larger Documents
Lesson 6 - Working with Images
Lesson 7 - Object Styles
Lesson 8 – Working with Type
Lesson 9 - Intro to Paragraph Styles
Lesson 10 - Intro to Character Styles
Lesson 11 - Master Pages
Lesson 12 – Exporting Files for Print and Digital Deployment
In this course, you will use Adobe InDesign CC to create and deliver professional-looking printed and interactive documents.
Outcomes:
This is an entry level InDesign course recommended for all levels.
Inclusive Leadership | Learnit
Live online, interactive training with practical approaches to empowering diversity and belonging at work.
Getting Connected Exercise
Inclusion as a Mindset
Actions to Stop, Start & Continue
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:
For all levels of an organization including staff-level, middle-management and/or senior leaders.
Time Management Training | Learnit
In this live online interactive Learnit training, learn how to control distractions so you can focus during the day and maximize your use of time.
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:
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.
Resiliency at Work | Learnit
Live online, interactive training to learn to foster a growth mindset and develop strategies to stay resilient in challenging times.
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:
This workshop is for anyone looking to discover and improve their individual perseverance when the going gets tough.
Influencing at Work | Learnit
Learn how to move beyond your position on the org chart to get things done. Gain influence through trust and influential communication techniques.
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:
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.
Change Management Workshop | Learnit
Upskill with Learnit and learn essential skills and best practices for executing change in this change management workshop.
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:
This workshop is designed for leaders, people managers, project managers, and influencers who want to better manage change.
Leadership: Setting the Foundation Workshop | Learnit
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:
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.
Leading Hybrid Teams | Learnit
Prepare to lead teams effectively as hybrid arrangements become the working standard.
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:
Project Management for Everyone | Learnit
Learn best practices for project management, tools, and methodologies. How to set up projects with outcomes and deliverables; track and handle scope creep.
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:
This workshop is designed for leaders, people managers, project managers, and individual contributors that want to improve project performance.
Empathetic Leadership Skills | Learnit
Live online, interactive internal relationships workshop: Training to maintain positive relationships through difficult circumstances.
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:
People managers, HR professionals, department leaders, policy enforcers, and associates leading projects are ideal for this course.
Elements of Transformative Listening Workshop | Learnit
Upskill with Learnit and focus on your active listening skills training to improve communication in the workplace.
Active Listening
Reflective Listening
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:
This is a foundational Learnit training, one that can be repeated and is good for everyone from Individual contributors to senior leaders.
Successful Decision Making | Learnit
In the Making High-Quality Decisions live online workshop, learn important decision-making concepts, techniques, and processes.
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:
This workshop is ideal for those in decision-making positions, especially leaders and managers who have the benefit of time and teams.
Build a Positive Mindset | Learnit
Live online, interactive training to learn innovative and creative ways to manage anxiety and foster a positive mindset.
What is Anxiety?
Retrain the Brain
Positive Thinking
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:
This workshop is appropriate for anyone who wants to build an optimistic attitude and approach life and their workday with a positive mindset.
Upskill with Learnit and learn techniques for managing stress with this instructor-led workplace wellness workshop.
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:
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.
Productive Work Relationships | Learnit
Understanding and using best practices to navigate manager relationships in a hybrid work model.
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:
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.
Microaggression Training | Learnit
Live online, interactive training with new practical approaches to identify and disrupt Subtle Acts of Exclusion in the workplace.
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:
For all levels of an organization including staff-level, middle-management and/or senior leaders.
Microsoft Project Advanced | Learnit
In Learnit's Microsoft Project Advanced training, participants will be guided 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.
Module 3
Lesson 1: Executing a Project
Lesson 2: Monitoring Project Progress
Lesson 3: Controlling a Project Plan
Module 4
Lesson 4: Reporting on Progress
Lesson 5: Customizing the Application
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.
Microsoft Project Introduction | Learnit
In this Microsoft Project Introduction course, learn how to develop project plans, track and manage project resources, create powerful visual reports, and track and monitor project deliverables with ease.
Module 1
Lesson 1: Getting Started with Microsoft Project
Lesson 2: Defining a Project
Lesson 3: Creating and Organizing Tasks
Module 2
Lesson 4: Managing Project Plan Resources
Lesson 5: Finalizing 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.
Microsoft Teams | Learnit
Learn the basic features of this chat software, then dive into extended features: phone calls, videoconferences, meetings, groups, topic channels, and more.
Learning Outcomes:
Lesson 1: Teams Overview
Lesson 2: Teams Chat
Lesson 3: Building a Team
Lesson 4: Outlook Integration
Lesson 5: Options Setting and Other Features
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.
Building Motivation for Your Team Workshop | Learnit
Upskill with Learnit and learn how to motivate your team with key motivational skills for leaders.
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:
This training is a good fit for people managers, team builders, people strategists, L&D professionals, and coaches.
Navigating Loneliness for Middle Managers Workshop | Learnit
Upskill with Learnit and improve your company culture by understanding the middle manager experience and how they can feel lonely at work.
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:
This class is for anyone who has a boss and is a boss, including managers, supervisors, and directors.
Negotiation Skills | Learnit
Learn a variety of negotiating styles including collaborative, holistic, and competitive. Find out how to counter and bargain. Essential tips and tricks.
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:
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.
OneNote | Learnit
Learn to organize notes and projects and be able to share with ease through Outlook and SharePoint in the live online OneNote course.
Module 1: OneNote Basics
Lesson 1: Getting Started with OneNote
Lesson 2: Adding and Formatting Notebook Content
Lesson 3: Embedding and Attaching Files
Module 2: Searching and Sharing Notes
Lesson 4: Organizing and Searching Notebooks
Lesson 5: Finalizing a Notebook
Lesson 6: Managing Notebook Files
Lesson 7: Sending and Sharing OneNote Content
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:
Outlook Intermediate | Learnit
In this Intermediate Outlook live online course, discover the advanced settings within Outlook and dive deep into the tools that help organize messages, manage contacts, assign tasks, and more!
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:
Lesson 1: Modifying Messages and Setting Global Options
Lesson 2: Organizing, Searching, and Managing Messages
Lesson 3: Managing Your Mailbox
Lesson 4: Automating Message Management
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:
Lesson 5: Working with Calendar Settings
Lesson 6: Managing Contacts
Lesson 7: Managing Activities by Using Tasks
Lesson 8: Sharing Workspaces with Others
Lesson 9: Managing Outlook Data Files
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.
Outlook Introduction | Learnit
In this Introduction to Outlook live online course, learn how to more efficiently manage 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:
Lesson 1: Getting Started with Outlook
Lesson 2: Formatting Messages
Lesson 3: Working with Attachments and Illustrations
Lesson 4: Customizing Message Options
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:
Lesson 5: Organizing Messages
Lesson 6: Managing Your Contacts
Lesson 7: Working with the Calendar
Lesson 8: Working with Tasks and 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.
Performance Management: Elevated Skills Workshop | Learnit
Upskill with Learnit and discover how to effectively lead through challenging situations.
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:
This workshop is suitable for an emerging leader, manager, or executive who wants to better understand the best practices in the performance management process.
Performance Management: Fundamental Skills Workshop | Learnit
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:
This workshop is suitable for an emerging leader, manager, or executive who wants to better understand the best practices in the performance management process.
Photoshop Advanced | Learnit
Learn advanced Photoshop techniques including layer management, layer comps, how to create 3D text and text outlines, explore advanced filters, create animated GIFs, and more!
Lesson 1 - Keyboard and Toolbar Shortcuts
Lesson 2 - Advanced Layer management
Lesson 3 - Blending modes
Lesson 4 - Layer Comps
Lesson 5 - Drawing Vectors
Lesson 6 - Advanced Type Techniques
Lesson 7 - Advanced Adjustment Layers
Lesson 8 - Advanced selection (use golden retriever) – Smart Radius/Select and Mask
Lesson 9 - Colorizing BW images
Lesson 10 - Displacement Maps
Lesson 11 - Advanced Filters
Lesson 12 - Intro to Actions
Lesson 13 - Creating an Animated GIF
This course will progress your skills to an intermediate and advance level of Adobe Photoshop CC.
Outcomes:
This course is recommended for those interested in learning intermediate/advanced Photoshop techniques.
Photoshop Fundamentals | Learnit
Learn to use the most common basic features of Adobe Photoshop CC including layers, selection tools, filters, and more!
Lesson 1 - Interface and Preferences
Lesson 2 - Image File Formats
Lesson 3 - Creating a New Document
Lesson 4 - Placing images
Lesson 5 - Image Size and Resolution
Lesson 6 - Layers introduction
Lesson 7 - Selection Tools
Lesson 8 - Layer Effects
Lesson 9 - Introduction to Shapes
Lesson 10 - Type and Typography
Lesson 11 - Colors
Lesson 12 - Creating a Clipping Mask
Lesson 13 - Introduction to Masking
Lesson 14 - Adjustment Layers
Lesson 15 - Image Touch Up
Lesson 16 - Filters Intro
Lesson 17 - Blending Modes Intro
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:
This is an entry level Photoshop course recommended for all levels.
Power Apps | Learnit
In this live online Power Apps course, learn how to create and deploy mobile and desktop apps that allow you and your team to view, create and edit common business data.
What is Microsoft PowerApps
Create New Power App
Connecting to a Data Source
Building Screens
Adding Power App Components
Format Controls
Publishing a Power App
Using a Power 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.
In this live online Power Automate course, learn to automate business processes to ensure consistency and free up time to focus on your business.
Workflow Concepts Overview
Accessing Power Automate
Getting around in Power Automate
Create a Power Automate Flow
Building a Power Automate Flow
Power Automate Integration
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.
Power BI | Learnit
Are your usual pie charts getting yawns in meetings? Learn Power BI to create elegant and impactful data visualizations, from bubble graphs to heat maps.
Day 1: Prepping Data and Creating Visualizations
Learning Outcomes:
Lesson 1: Introducing Power BI
Lesson 2: Shaping and Combining Data
Day 2: Modeling Data and Publishing Options
Learning Outcomes:
Lesson 3: Modeling Data
Lesson 4: Publishing Options
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.
PowerPoint Advanced | Learnit
Ready to go beyond titles, headings and stock photos? Learn how to take your presentations to the next level with audio, video, animations and more!
Module 3:
Learning Outcomes:
Lesson 1: Modifying the PowerPoint Environment
Lesson 2: Customizing Design Templates
Lesson 3: Adding SmartArt and Math Equations
Module 4:
Learning Outcomes:
Lesson 4: Working with Media and Animations
Lesson 5: Collaborating on a Presentation
Lesson 6: Customizing a Slide Show
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.
PowerPoint Introduction | Learnit
Learn how to create clean and impactful presentations using MS PowerPoint. The class covers design tools, formatting, charts, tables, and slide animations.
Module 1:
Learning Outcomes:
Lesson 1: Getting Started with PowerPoint
Lesson 2: Developing a PowerPoint Presentation
Lesson 3: Performing Advanced Text Editing Operations
Lesson 4: Adding Graphical Elements to Your Presentation
Module 2:
Learning Outcomes:
Lesson 5: Modifying Objects in Your Presentation
Lesson 6: Adding Tables to Your Presentation
Lesson 7: Adding Charts to Your Presentation
Lesson 8: Preparing to Deliver 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.
PowerPoint Psychology: Engaging Presentations | Learnit
Learn how to deliver engaging, effective and memorable PowerPoint presentations using audience psychology and design principles in this hands-on class.
Module 1: Planning, Content, and Delivery
Learning Outcomes:
Topics:
Module 2: Designing Clean and Impactful Slides
Learning Outcomes:
Topics:
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.
Presentation Skills | Learnit
Learn advanced presentation skills in this live online training: PowerPoint techniques, the traits of exceptional presenters, tips and tricks.
Day 1:
Outcomes:
Outline:
Day 2:
Outcomes:
Outline:
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.
Python Fundamentals | Learnit
Learn the fundamentals of Python with our 3-day Python Fundamentals live online course.
Learn the fundamentals of Python with our 3-day Python Fundamentals course.
This course is for programmers.
Risk Management Training | Learnit
Upskill with Learnit and learn how to minimize losses and other risks 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:
This workshop is designed for leaders, people managers, project managers, and individual contributors who want to better manage risks and issues.
Run Psychologically Safe Meetings Workshop - Learnit
Upskill with Learnit and learn how to have more inclusive meetings by focusing on psychological safety training to have more psychological safety 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:
This course is designed for people who lead virtual, in-person, or hybrid meetings.
SQL Querying Fundamentals | Learnit
In the SQL Querying Fundamentals live online course, learn how to use SQL to query databases and extract information.
Day 1 - Topics
Introduction to SQL Usage and Terminology
Executing A Simple Query
Performing Queries Using Criteria Conditions
Day 2 - Topics
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:
*Please Note: A Mac environment will not work for this class
Sharepoint Fundamentals | Learnit
Learn SharePoint basics: getting around, using Apps, Lists, and Libraries. Integrated editing in Office 365; calendars, tasks, and more in this hands-on Learnit class.
Outcomes:
Day 1 Topics:
Day 2 Topics:
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.
Workplace Wellness and Self-Care Course | Learnit
In this live online workshop, you'll learn how to implement strategies to make self-care a daily priority.
Sleep Importance
Sleep Protocols
Self-care methods
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:
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.
Smartsheet - Introduction | Learnit
Learn Smartsheet best practices: how to build and share collaborative checklists, project plans, calendars, and dashboards for both waterfall and agile projects.
Lessons
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:
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.
Communication Skills Workshop | Learnit
Upskill with Learnit and focus on your communication skills training by learning how to present ideas effectively and improve communication at work.
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:
This training is a good fit for anyone who wants to ensure their verbal contributions are heard, understood and valued.
Business Storytelling Workshop | Learnit
Upskill with Learnit and focus on business storytelling training with this live, online, instructor-led 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:
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.
Strategic Thinking Workshop | Learnit
Upskill with Learnit and our soft skills courses. Focus on your professional development with strategic thinking training.
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:
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.
Process Improvement for the Rest of Us | Learnit
Upskill with Learnit and increase 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:
This workshop is for anyone looking to discover and improve their individual perseverance when the going gets tough.
Emotional Intelligence: Social Awareness Workshop | Learnit
Upskill with Learnit and 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:
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.
Tableau: Advanced | Learnit
This Tableau advanced live online course is designed to boost the student’s competence when it comes to creating visualizations, and creating dashboards.
Module 1: Connecting to data sources
Module 2: Creating univariate charts
Module 3: Creating bivariate charts
Module 4: Creating multivariate charts
Module 5: Creating maps
Module 6: Calculating user-defined fields
Module 7: Customizing and saving
Module 8: Exporting and saving
Module 9: Exploring advanced features
Module 10: A short dash to dashboarding
Module 11: Summarizing your data for dashboards
Module 12: Interacting with data for dashboards
Module 13: Using dashboards to get results
Module 14: Putting the dash into dashboards
Module 15: Making dashboards relevant
Module 16: Visual best practices
Module 17: Tell the world! share the dashboards
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.
Tableau: Introduction | Learnit
In this introduction to Tableau live online course, gain a firm grasp of the basic techniques required to create visualizations, and combine them in interactive dashboards.
Module 1: Creating your first visualizations and dashboard
Module 2: Working with data in Tableau
Module 3: Moving from Foundational to Advanced Visualizations
Module 4: Using row-level and aggregate calculations
Module 5: Table Calculations
Module 6: Formatting a visualization to look great and work well
Module 7: Telling a data story with dashboards
Module 8: Adding value to analysis - trends, distributions, and forecasting
Module 9: Making data work for you
Module 10: Advanced techniques, tips, and tricks
Module 11: Sharing your data story
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:
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.
Time Management: Strategize Your Day With Outlook workshop | Learnit
Part 01: Effectively use Outlook to strategize our day
Turning on The To-Do Bar
Tools for Efficiency
Tools for Effectiveness
Applying the Pareto Principle
Part 02: Increase our regulation of time using Outlook
REP Plan (Record, Estimate, Prioritize)
Calendar blocking with assigned Categories
Part 03: Other Time Management Tools
User-action tools:
Automated tools:
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.
Conflict Resolution Course | Learnit
Upskill with Learnit and focus on your conflict resolution training 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:
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.
Upskill with Learnit and dive into this key DEI training focused on addressing unconscious bias the workplace.
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:
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.
Visio Advanced | Learnit
In this live online advanced Visio course, learn to create stunning data-driven diagrams and vector graphics, 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.
Module 3
Lesson 1: Designing Advanced Plans and Diagrams
Lesson 2: Enhancing the Look of Drawings
Lesson 3: Working with Custom Shapes, Stencils, and Templates
Module 4
Lesson 4: Connecting Drawings to External Data
Lesson 5: Leveraging Development Tools
Lesson 6: Sharing 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.
Visio Introduction | Learnit
In this Introduction to Visio live online course, learn to simplify and communicate information through data-driven visuals.
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:
Lesson 1: Getting Started with Visio 2016
Lesson 2: Working with Workflow Diagram Tools
Lesson 3: Building Organization Charts
Lesson 4: Designing a Floor Plan
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:
Lesson 5: Building a Cross-Functional Flowchart
Lesson 6: Designing a Network Diagram
Lesson 7: Styling a Diagram
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.
Practice Self-Care | Learnit
Learn how to achieve work-life balance and gain control of your whole health with science-backed research, tools, and resources through Learnit’s live online, interactive emotional well-being workshop.
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:
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.
Word Advanced | Learnit
Learn advanced MS Word features like document markup review, fillable forms, macros, digital signatures and more. Hands-on, instructor-led class.
Module 5:
Outcomes:
Lesson 1: Manipulating Images
Lesson 2: Using Custom Graphic Elements
Lesson 3: Collaborating on Documents
Lesson 4: Adding Document References and Links
Module 6:
Outcomes:
Lesson 5: Securing a Document
Lesson 6: Using Forms to Manage Content
Lesson 7: Automating Repetitive Tasks with Macros
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.
Word Intermediate | Learnit
Learn next-level MS Word features like mail merges, tables of contents, styles, themes, templates and more. Hands-on, instructor-led class.
Module 3:
Outcomes:
Lesson 1: Organizing Content Using Tables and Charts
Lesson 2: Customizing Formats Using Styles and Themes
Lesson 3: Inserting Content Using Reusable Content
Lesson 4: Using Templates to Automate Document Formatting
Module 4:
Outcomes:
Lesson 5: Controlling the Flow of a Document
Lesson 6: Simplifying and Managing Long Documents
Lesson 7: Using Mail Merge To Send Multiple Customized Documents
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.
Word Introduction | Learnit
For first time MS Word users and those seeking formal training for a better foundation. Text formatting, images, tables, document prep and more.
Module 1:
Outcomes:
Lesson 1: Getting Started with Word
Lesson 2: Formatting Text and Paragraphs
Lesson 3: Working More Efficiently
Lesson 4: Managing Lists
Module 2:
Outcomes:
Lesson 5: Adding Tables
Lesson 6: Adding Graphics
Lesson 7: Controlling Page Appearance
Lesson 8: Preparing to Save a Document
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.”
Applied Business Writing Course | Learnit
Upskill with Learnit and become a professional communication pro by developing your business writing skills.
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:
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.