Workplace Course Outline - (2023)

Overview Of Excel

(Video) Basic Computer Skills for the Workplace in 2021 - 12 Hours of Free Tech Training

Beginners Course

Inputting & Formatting:

All types of Formatting,especially number and currency formatting will be covered in this Excel courses online. Also shows you how to delete formats correctly and how Excel views Formatting.

Beginners.14 Mins
Introduction To Excel Formulas:

Shows the difference between a Formula and a Function. This module’s of our online Excel training course emphasis is that Formulas ,like Functions simply automate a ‘Human Process’. Viewing it from this point of view makes Formulas and Functions must easier to understand. This module in our online Excel training course finishes by providing a simple but powerful Two step method to create even complex formulas.

Beginners14 mins

Introduction to Excel Functions:

This online Excel training course explains what Functions are and how to use them to their full potential. Covers the SUM,AVERAGE,MIN, MAX and COUNT Functions.

Beginners16 Mins
Linking Worksheets & Workbooks:

An extremely important Excel skill to learn in our Excel courses online, as in real life workplace situations, data is kept in different worksheets and workbooks. This module shows various methods to access data from different worksheets & workbooks.

Beginners17 Mins
Controlling Your Worksheets & Workbooks:

This module in our online Excel training course will teach you how to freeze rows and columns, split your screen, size and hide your rows and columns. Also how to rename, move or copy your worksheets.

Beginners18 Mins
Printing Your Worksheets and Workbooks:

Everything you need to know about printing your worksheets and workbooks.

Beginners8 Mins
Protect your Spreadsheets:

Its vital,especially if others will be using your spreadsheets that they are protected fully to insure integrity of your data. This module in our online Excel training Course shows you

Beginners7 Mins
Introduction to Data Analysis:

So much of your work in Excel will be spent dealing with lists or tables of information,whether it be a list of orders, suppliers,employees etc.
This module of our online Excel training course starts of by stressing the importance of setting up your lists or tables property. Because without this, you cannot use Excel’s powerful data analysis tools like Filters, Advanced Filters and the SubTotal Tool. We will master all of these in this module of our online Excel training course

Beginners12 Mins
Excel Beginner’s Test and Certification:

Essential Excel Concepts

(Video) 1. Everything DiSC Workplace® Introduction
Fundamental Excel Concepts:

Probably one of the most important module in our online Excel training course. I am always amazed that so many Excel courses online only give a few minutes to these concepts. This module explains the concepts of ‘Relative Reference’, ‘Absolute Reference’ and using ‘Cell references”. There is no point going any further in the course until you have mastered these three concepts. They are the very oxygen of Excel.

Intermediate19 Mins
Named Ranges In Excel:

We will show how to create proper lists or databases in Excel. What is an Named range and how to create them?

Intermediate9 Mins
Excel Tables

Like the above modules this is another essential module you need to master, especially if your work in Excel involves analyzing large chunks of data. What is an Excel Table ?. How to create and use them and how they differ from ordinary lists and Named ranges.
The key points is that if you add data to the end of ordinary Excel lists, your Lookup Functions, your Named Ranges or your Pivot Tables will not automatically pick them up. The module will explain the answers and solutions to all these important questions

Intermediate17 Mins

Intermediate Excel Techniques





Conditional Formatting:

Conditional formatting allows you to format a cell or cells if a certain condition or conditions are met.
We will learn about the various conditional formatting methods including data bar, color scales and icon sets based on criteria like traffic lights. In the Advanced level, we will study how to combine conditional formatting with

Data Validation:

A lot of heartache can be avoided by using data validation techniques in your spreadsheet.
For example, if a cell requires a date, you can program that cell only to take a date, with it also flashing a warning notice to your users, ensuring data integrity.

Drop Down Boxes:

Drop-down lists should always be used in Excel if users have to input ‘constant data’ as only that data on the list can be chosen. This ensures data integrity. We will show various ways to create these drop-down lists.

Consolidate Data:

This technique will show how to consolidate data from various worksheets into one worksheet using the consolidation Tool.The great thing is that the data can be of different length.

Error Types explained

This section explains the various Excel errors types you might meet and how to handle them.Particular attention is given to the powerful IFERROR Function with plenty of examples.

Formula Auditing:

Mistakes will occur in the best of spreadsheets. This module goes through the various formula auditing techniques available to help you find these errors.

Form Controls

You can use software components like check boxes, combo boxes, spinners etc in your spreadsheets. Here you will learn how to create and manipulate these controls to give greater flexibility to your spreadsheets and forms.

The Camera Tool In Excel:

You can take a picture of your data in Excel by using the camera tool. We will also use this tool later on when creating dynamic and interactive charts.

Hyperlinks in Excel:

You can go to another worksheet by clicking on a hyperlink.These can be very useful if you a large number of worksheets and need to access them quickly. In this module, we will build such an example.

Templates In Excel:

This module will show how to create Excel Templates, which can be used again and again. Various Templates are built to illustrate the required techniques.

The SubTotal Tool:

If you need to subtotal your data by various categories, this is a great tool to use. This module shows you how.


Charts in Excel

Introduction to Excel Charts:

Learn about the various chart types in Excel, when you use each one and how to create and format them.

Intermediate12 mins
Solutions to common Chart Problems:

This module will show how to tackle many of the common problems you might encounter. For example, if one data series value is much lower that the other values, it won’t be seen clearly in your chart.The solution to this and other problems will be shown in this video.

Intermediate17 Mins
Solutions to Chart Problems: Part Two

More charts solutions including automatically highlighting the largest data series, formatting charts with negative values and others.

Intermediate15 Mins
Dynamic Charts In Excel:

Techniques to create dynamic charts , very useful if space is an issue and for using in dashboards.

Intermediate12 Mins
Interactive Charts In Excel:

Create charts which allow your users interactive with your charts.Great for comparative purposes. We build a few examples.

Intermediate11 Mins
New Chart Features in Excel 2013.

In this module,we will learn about the new chart features introduced in Excel 2013.

Intermediate6 Mins
(Video) Active Shooter In The Workplace Training Video Program #oshaguidelines

Intermediate Functions

The IF Function: The First Work-Horse Function.

In most work-place spreadsheets, two Functions can often accounts for over 50-60% of the functions used. They are Excel’s two work-horse Functions, the IF Function and the VLOOKUP Function. The IF function allows you automate decision making processes in Excel.
You will learn how to use the IF Functions and see it’s usage in various workplace situations. Special attention will be given to maximize its use by incorporating the three Essential Excel concepts.

Intermediate15 Mins
The VLOOKUP Function: THE Second Work-Horse Function.

Imagine I asked you to look up 100 phone numbers in a paper-based phone book? What would you do?
Firstly, you would notice that the book was sorted alphabetically , you would then search for the name and when you found it , you would move your eyes over the relevant record until you found the telephone number.
Well that’s what the VLOOKUP Function does. It just automates that human process of searching for a value in a record. But it will do the job in a fraction of a second.
Now imagine if all the thousands of pages of the phone book was mixed up. It could take you a week to find those 100 phone numbers but even that’s no problem to the VLOOKUP Function, it will still get you those 100 phone numbers in a fraction of a second.
This module will show you how to understand and build powerful VLOOKUP Functions in various situations. It will also explain the common problems that occur with VLOOKUP Functions.

Intermediate19 Mins
The SUMIF & COUNTIF Functions: Two Useful Lieutenants

These two functions are very useful. They allow you to add or count items based on a condition. How many sales did Mary make and how much revenue occurred from these sales. The COUNTIF Function is
also used a lot in combination type functions. We will show you how to use these Functions with plenty of examples of using them in real life workplace
situations. In the advanced course, we will meet a new relation of these
Functions, the SUMIFS and COUNTIFS Functions. They arrived in the Excel 2007 version and are Functions you need to master, as they allow you to add or count items for Not just one condition but up to 100 conditions.

Intermediate17 Mins
Working with Text:

This module shows how to manipulate Text in Excel. It looks at the’ &’ concatenate operator and the main Text Functions like LEFT, RIGHT, LEN,MID and FIND, STUBSTITUE Functions. These can be very handy if you need to clean up your text in Excel to make it ready for further analysis. It gives plenty of examples of these in use –like extracting a name or a city from an address text string.

Intermediate26 Mins
Dates and Date Functions:

This module helps you understand dates in Excel, that they are just Numbers.We will then learn about the various date functions like DATE,DATEVALUE, WORKDAY, EOMONTH etc with plenty of reallife examples.

Intermediate11 Mins
Time and Time Functions:

Learn to understand Time in Excel and the various Time Functions.


Excel Intermediate Test and Certification:

(Video) Sexual Harassment Prevention Training Part 1

Advanced Excel Functions

INDEX & MATCH Functions: Dynamic control over Data.

The INDEX and MATCH Functions along with SUMIFS and SUMPRODUCT are the most important advanced type functions.
The INDEX and MATCH Functions when combined do everything that the VLOOKUP Function can do but more.
Unfortunately the VLOOKUP Function can only search from Left to Right from the first column in your defined table but the INDEX and MATCH Functions when combined can search from Right to Left or Left to Right from any column in your table. To be able to extract data from your table dynamically ,no matter where it is, you need to master these two Functions.

Advanced16 Mins

We have already met the SUMIF & COUNTIF Functions but these only allow you test for one condition .
These new Functions, which came in the Excel 2007 version allow you to test for up to 100 conditions. Very powerful dynamic reports can be created from using these new functions. We will show you how to use them and also show their use when your data is in a Excel Table Format.

Advanced15 Mins
SUMPRODUCT Function: Your First Glimpse of Arrays:

The SUMPRODUCT Function, does as it says , its sums the various products.
This Function is different from all the other functions you have used before because its takes a range of cells(array) as an argument.

This module will show you how to use this function with many examples but it will also introduce a very important advanced technique on how to deal with arrays in Excel. Once you get your mind around this techniques you will have no problem dealing with any array formula in Excel.

Advanced14 Mins

If you want to ask Excel to move from a certain cell to another cell by itself and then grab some cells from this cell point, then call on the OFFSET Function. We will show practical examples of this Function in use and show how to build your own powerful OFFSET Functions.
The great practical use of the INDIRECT Function is that it can accept a text sting as a cell reference. This is great for creating dynamic ranges. We show many practical uses of this function in this module.

Advanced12 Mins
Nested IF Functions with AND & OR Functions:

We will in this module build powerful nested IF Functions with AND & OR Functions, to create complex automatic decision making processes in your spreadsheets.

Advanced15 Mins


Study the module on the SUMPRODUCT Function before you start this module.

In this module we will learn what is an Array and an Array Formula with examples of them in use in practical commercial situations. We will show how to create and use an Array Formula and look again at the important concept of Conditional Evaluation in an Array Formula.

Advanced17 Mins
Custom Formatting

In this module, we will learn how to create customized formats.

Advanced15 Mins

Excel Expert Test and Certification:

Pivot Tables

Overview of Pivot Tables:

Examples of what Pivot tables can do. Using a large data set, we will create various reports showing what you can achieve with Pivot tables. You will learn about the various ribbons and each Pivot table command button.

Advanced10 Mins
Pivot Table Formatting:

Master the techniques to format your pivot tables.

Advanced7 Mins
How to summarize Pivot table Values:

By default, Pivot Tables sums values.In this module we will learn how to summarize these values by averaging, counting , maximizing and minimizing them.

Advanced6 Mins
Pivot Tables : Show vales as:

This section show how to manipulate the values in your Pivot Tables. By default, a pivot table sums values up. We show how to show these values in different ways. See your values as percentages, in relation to other subtotals, differences from other time periods etc

Advanced14 Mins
Pivot Table Pictures:

In this module, we will learn how to take pictures of your pivot tables, maybe you want to insert them into a PowerPoint Presentation or a Word Document.

Advanced2 Mins
Grouping Pivot Table data:

This module explains how we can group data in to bespoken group. We will especially look at the very important technique of grouping dates as most data has a date field.

Advanced10 Mins
Understanding the Pivot table cache:

We will see in this module that Pivot tables are automatically created from the same internal memory. This can cause problems especially if you are grouping data, as changing the grouping of a set of values will change all the others groupings in your other pivot tables. We will show you how to create independent Pivot tables.

Advanced7 Mins
Calculated Fields in Pivot Tables:

We can create new calculated fields in our Pivot Tables based on existing data. This module explains all you need to know.

Advanced15 Mins
Calculated Items in Pivot Tables:

Learn about Calculated Items in Pivot tables. What they are, how to create them, how to use them and pitfalls to look out

Advanced9 Mins
The GETPIVOTDATA Function in Pivot Table:

Pivot data is quiet volatile and it is quite difficult to grab data from pivot tables for further analysis. We will show in this module a possible solution to this problem whereby we can populated per-formated reports from our live Pivot

Advanced18 Mins
New Pivot table Features in Excel 2013:

In this module, we will examine how Pivot tables have changed in the latest version of Excel ..version 2013, in particular the new Excel data model which allows you combine data from different tables into one pivot table.

Advanced10 Mins

Pivot Table Certification:

(Video) Ethics in the Workplace - A Good Work Ethic


How do you write a course outline example? ›

When creating your course outline there are some essential pieces that you need to include:
  1. Course Description from the Academic Calendar. ...
  2. Course Goals. ...
  3. Student Learning Objectives/Outcomes. ...
  4. Assessment Overview. ...
  5. Assessment Plan. ...
  6. Schedule of Activities. ...
  7. Plagiarism Announcement. ...
  8. Reading List.

How do you evaluate course effectiveness? ›

Evaluate how the training has influenced the learner's performance and delivery at work by using a combination of these methods:
  1. Self-assessment questionnaires.
  2. Informal feedback from peers and managers.
  3. Focus groups.
  4. On-the-job observation.
  5. Actual job performance key performance indicators (KPIs)
Aug 13, 2022

How do you give feedback on a training session? ›

How to Give Feedback on Training Session
  1. Explain why feedback is essential.
  2. Apply a framework for providing formal or informal feedback.
  3. Use descriptive language in delivering feedback.
  4. Describe six characteristics of effective feedback.
  5. Provide feedback in real situations.

What should a course outline include? ›

A course design outline usually includes:
  • The learning goals & objectives.
  • Sections or learning activities.
  • Supporting material.
  • Assessments (assignments, quizzes, reflections, and exams)
  • Learning milestones.
Jun 21, 2022

What does course outline mean? ›

Course outline means a detailed description of a course that specifies learning outcomes to be achieved and how the learning outcomes will be evaluated. Sample 1. Course outline .

How do you evaluate a course content? ›

  1. Asses Using a Rubric or Other Tool to Consider Basic Course Elements. ...
  2. Analyze Course from a Student Perspective. ...
  3. Assess Course Artifacts, Materials, & Feedback. ...
  4. Consider Level and Type of Student-to-Student and Student-to-Instructor Interactions. ...
  5. Results: Are Students Learning?
May 26, 2015

What is a good course evaluation score? ›

The average mean teaching evaluation score is 4.3, and the median is 4.5, both well above the “official” average rating of 3.0 on the 1 to 5 scale. There are quite a few perfect and near perfect scores, while there are very few scores below 3.

How would you describe your training experience? ›

You describe your training experience on a resume by including information about your training successes and outline all skills developed related to training and development.

How do you write a feedback report after training? ›

I would like to submit my disappointment on how the training was conducted. The training session would have been more productive had you focused on the practical side of the theories you had shared. The training felt more like a theory class as the practical approach was missing from it.

How do you give positive feedback examples? ›

Examples of reinforcing employee feedback
  1. “Something I really appreciate about you is....” ...
  2. “I think you did a great job when you… ...
  3. “I would love to see you do more of X as it relates to Y” ...
  4. “I really think you have a superpower around X” ...
  5. “One of the things I admire about you is…”

What makes a good training course? ›

Technical expertise. The technical expertise of the company is the single most important thing to consider. In order to run a training course within the industry, the training provider should be competent, professional, and experienced within the specific field.

What are training goals examples? ›

The main training objectives examples include:

To gain new knowledge or information that helps employees to do a job well. To learn physical skills, like using physical machinery quickly and efficiently. To influence employee attitudes and perceptions toward learning or organizational change.

Why are training courses important? ›

The process of learning something new encourages soft-skill development such as time-management, communication and self-confidence, which all employers love. Training courses are also great because they provide a way to enhance your current job or career path, thus enabling opportunities for progression.

How do you develop a course structure? ›

To design an effective course, you need to:
  1. Consider timing and logistics.
  2. Recognize who your students are.
  3. Identify the situational constraints.
  4. Articulate your learning objectives.
  5. Identify potential assessments.
  6. Identify appropriate instructional strategies.
  7. Plan your course content and schedule.

What is a course structure? ›

Deciding on a course structure

The course structure refers to the choice of topics and the organization and sequencing of course content. Remember that the choice of topics and their organization should always support the learning objectives for the course.

What is your course plan? ›

A course plan includes not only the goals and the content topics, but also how the topics will be taught and what the students will do during the course. In order to achieve end-of-semester goals, students must have practice during the semester.

What is the difference between course outline and curriculum? ›

A course is a set of lectures that can consist of any type of content (e.g. video, documents, presentations, etc). A curriculum is a group of courses usually on a related topic.

How important do you need to formulate objectives in the development of a course outline? ›

Articulating learning objectives helps instructors select and organize course content. As an instructor, when you write and review the learning objectives in a course, you can identify the kinds of materials and topics that will be suitable to the learning outcomes most efficiently.

What is a course structure? ›

Deciding on a course structure

The course structure refers to the choice of topics and the organization and sequencing of course content. Remember that the choice of topics and their organization should always support the learning objectives for the course.

What is a course template? ›

Course templates allow you to configure, store and reuse components of a course, such as quizzes, assignments, surveys, images, and so on, and then use the components in individual course offerings.

How do you construct a course? ›

To design an effective course, you need to:
  1. Consider timing and logistics.
  2. Recognize who your students are.
  3. Identify the situational constraints.
  4. Articulate your learning objectives.
  5. Identify potential assessments.
  6. Identify appropriate instructional strategies.
  7. Plan your course content and schedule.

What is another name for course outline? ›

What is another word for course outline?
syllabusprogram of study
courseeducational programme
scheduleprogramme of study
44 more rows

What is the example of course? ›

Course is defined as a specific path that something follows or the way in which something develops. An example of course is the route taken by an airplane. An example of course is the way your life progresses.

What comes first in planning a course? ›

Before the beginning of the semester, have a basic, solid outline for the course. Know the learning goals, major assignments, course policies, and the big picture goals of the course. Don't get bogged down in details.

What is your course plan? ›

A course plan includes not only the goals and the content topics, but also how the topics will be taught and what the students will do during the course. In order to achieve end-of-semester goals, students must have practice during the semester.

What is a course objective? ›

Objective – A course objective describes what a faculty member will cover in a course. They are generally less broad that goals and more broad than student learning outcomes. Examples of objectives include: • Students will gain an understanding of the historical origins of art history.

What is a course description? ›

The primary purpose of the course description is to clarify course content. They are used by students, prospective employers, and transfer articulators at other institutions.

What is the difference between course outline and syllabus? ›

A course outline gives the basic components of the course required to be taught by all instructors; whereas a syllabus describes how an individual instructor will teach that course in terms of specific assignments, dates, grading standards, and other rules of conduct required by that instructor.

How do you structure an online course? ›

Share this article
  1. Pick the perfect course topic.
  2. Ensure your course idea has high market demand.
  3. Create Magnetic and Compelling Learning Outcomes.
  4. Select and Gather your Course Content.
  5. Structure Your Modules and Course Plan.
  6. Determine the most engaging and effective delivery methods for each lesson.
Sep 1, 2021

What do you mean by a successful course? ›

Success Course Definition. Success courses are designed to help undergraduate students make successful transitions from a previous level of education, or experience (e.g., the military), into the University, from undeclared status into a major, and/or from undergraduate studies to graduate studies or careers.

Why is course design important? ›

The focus of course design is to put together the optimal learning experiences for students in an environment that is supportive and appreciative of learning and intellectual development. The backdrop behind effective course design is that the courses themselves constitute the foundation of teaching and learning.

What is more important in defining course goals? ›

The best way to use goals as a roadmap for a course design is to make them more clear and concise by determining specific learning objectives. Learning Objectives are measurable subgoals of a lesson and inform particular learning outcomes. Writing learning objectives keeps you focused and helps you in planning.


1. ServiceNow Workplace Reservation Management (WRM) Overview
2. Workplace Harassment Training from
3. Millennials in the Workplace Training Video
(Official Comedy)
4. Workplace Violence Prevention Training
(Nina Williams)
5. Workplace Violence Training for Healthcare Workers
6. Respect in the Workplace Training Video with Sarah Harper, Andy Park, Roland, Tim and Irene
Top Articles
Latest Posts
Article information

Author: Sen. Ignacio Ratke

Last Updated: 16/09/2023

Views: 5926

Rating: 4.6 / 5 (76 voted)

Reviews: 83% of readers found this page helpful

Author information

Name: Sen. Ignacio Ratke

Birthday: 1999-05-27

Address: Apt. 171 8116 Bailey Via, Roberthaven, GA 58289

Phone: +2585395768220

Job: Lead Liaison

Hobby: Lockpicking, LARPing, Lego building, Lapidary, Macrame, Book restoration, Bodybuilding

Introduction: My name is Sen. Ignacio Ratke, I am a adventurous, zealous, outstanding, agreeable, precious, excited, gifted person who loves writing and wants to share my knowledge and understanding with you.