TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Office Excel 2021: Part 1

Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, this is where the power of Microsoft® Office Excel® 2021 can help. Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software. This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation.

This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Excel Associate (Office 365 and Office 2021): Exam MO-200 and Excel Expert (Office 365 and Office 2021): Exam MO-201 certifications.

This course is the first part of a three-course series that covers the skills needed to gain a foundational understanding of Excel.
– Microsoft Office Excel 2021: Part 1 (this course)
– Microsoft Office Excel 2021: Part 2
– Microsoft Office Excel 2021: Part 3

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Motivation Training: Motivating Your Workforce

It’s no secret that employees who feel they are valued and recognized for the work they do are more motivated, responsible, and productive. This course will help supervisors and managers create a more dynamic, loyal, and energized workplace. It is designed specifically to help busy managers and supervisors understand what employees want, and to give them a starting point for creating champions.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Problem Solving and Decision Making

Many people lack the necessary skills to effectively solve problems and make decisions. Having a process in place can help with this.

TOTAL DAYS: 3 | TOTAL HOURS: 19.5

Programming and Data Wrangling with VBA and Excel

VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft® Excel® and other applications in the Microsoft® 365 application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users.

Completion of this course will earn 1.8 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Project Management Training: Understanding Project Management

Project management isn’t just for construction engineers and military logistics experts anymore. Today, in addition to the regular duties of your job, you are often expected to take on extra assignments and to get that additional job done well, done under budget, and done on time. This course is not intended to take you from a supervisory or administrative position to that of a project manager. However, this course will familiarize you with the most common terms and the most current thinking about projects.
In this course, we will walk you through the nuts and bolts of project management, from setting priorities to controlling expenses and reporting on the results. You may still have to cope with the unexpected, but you’ll be better prepared.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Public Speaking: Presentation Survival School

This course will teach you how to manage your thoughts, body language, nervousness, and speech patterns to present yourself professionally. You’ll also learn how to present at meetings, use the five-S pattern to prepare a good presentation, and punch up your presentation with visual aids.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Systematic Succession Planning

Succession planning saves the cost and time of external personnel searches. It improves employee morale, lessens the effects of re-engineering and downsizing, but most important, it creates a diverse talent pool within your organization. This book was written to guide you through the evaluation process of succession planning. It describes the guidelines for setting up a program, along with bench-marking procedures for ensuring the ongoing success of your plan.

Completion of this course will earn 0.575 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Time Management

Time is money, the saying goes, and lots of it gets lost in disorganization and disruption. We also deal with a constant barrage of technology, people, and tasks that can contribute to that disorganization. Many people find that they flit from one task to another, trying to get everything done, but often falling short. You will learn how to make the most of your time by getting a grip on your workflow and office space, using your planner effectively, and delegating some of your work to other people.

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 2

Time Management 2-Hour Class

This is a 2-hour virtual instructor-led class, and in celebration of our 30th Anniversary, it will be held for $30!

Time is money, the saying goes, and lots of it gets lost in disorganization and disruption. We also deal with a constant barrage of technology, people, and tasks that can contribute to that disorganization. Many people find that they flit from one task to another, trying to get everything done, but often falling short. You will learn how to make the most of your time by getting a grip on your workflow and office space, using your planner effectively, and delegating some of your work to other people.

TOTAL DAYS: 1 | TOTAL HOURS: 3

Working with New Excel 365 Functions

Newer Excel functions are designed to be easier to use and easier for others to learn and edit. Get familiar with some these newer Excel functions like XLOOKUP, IFS, FILTER, SORT, and TEXTJOIN. Learn more about dynamic arrays and spilling into ranges. Find out if some of these new functions can make your work in Excel easier.