Software Training

Courses

Access 365 Level 1: Access 365 Level 1

Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a single relational database application. In this course, you use Access 365 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

Access 365 Level 2: Access 365 Level 2

In this course, you expand your knowledge of relational database design, promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access results in a robust, functional database for your users.

Access 365 Level 3: Access 365 Level 3

In this course, you learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more. Knowledge of these features separates database professionals from the casual database users or occasional designers.

Excel 365 Level 1: Excel 365 Level 1

Organize, calculate, analyze, revise, update, and present your data in ways that help the decision makers in your organization. This course provides you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data analysis.

Excel 365 Level 2: Excel 365 Level 2

This course builds upon the foundational knowledge presented in the Excel 365 Level 1 course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that can compete at a high level.

Excel 365 Level 3: Excel 365 Level 3

This course is intended for students who want Excel to do the hard work for them so that they can focus on getting the answers they need from the vast amounts of data their organization generates. Students learn how to effectively collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions.

Excel 365 Pivot Tables: Excel 365 Pivot Tables

Advances in technology have made it possible to store ever increasing amounts of data. Along with this, the need to analyze that data and gain actionable insight is greater than ever. You already have experience working with Excel and creating basic PivotTables to summarize data. But, Excel can do much more. Being able to harness the power of advanced PivotTable features and create Pivot Charts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyze, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved.

Excel 365 PowerPivot: Excel 365 PowerPivot

We are now living in the age of big data. Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amounts of data quickly. Fortunately, Excel provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data.

Excel Automating Tasks: Excel Automating Tasks

Advanced Excel users encounter repetitive tasks such as: reports that need to be produced, data that needs to be updated or tables that need to be formatted repeatedly. Using “Macros” many of these routine tasks can be automated. Using advanced knowledge of Excel learned in this class you record the steps or operations that they want to perform, and then press a button to run them repeatedly. Macros reduce the possibility of human error that increases with many, repetitive keystrokes and tasks. Macros reduce the amount of time that must be spent performing basic computing tasks, freeing up your time for more complex problem-solving and idea-generating activities. They also make complex computations easier to perform.

Microsoft Teams: Microsoft Teams

Microsoft Teams provides a collaborative, cloud-based workspace where Office 365 users can actively connect and collaborate in real time to get things done. Have a conversation right where the work is happening, whether coauthoring a document, having a meeting, or working together in other apps and services. Teams is the place to have informal chats, iterate quickly on a project, work with team files, and collaborate on shared deliverables.

OneNote (Desktop App): OneNote (Desktop App)

Develop digital note-taking skills by creating, modifying, and managing OneNote notebooks that work with other Microsoft Office programs. Store a wide variety of content in an organized structure, access the content from anywhere and share it with others.

Outlook 365 Level 1: Outlook 365 Level 1

Use Outlook to send, receive, and manage email messages, manage your contact information, schedule appointments and meetings, create tasks and notes for yourself, and customize the Outlook interface to suit your working style.

Outlook 365 Level 2: Outlook 365 Level 2

Learn to use advanced features to manage email, perform advanced searches, apply filters to intercept mail and control spam, create rules to automate many management tasks, work with calendars and contacts, manage tasks, protect data with archiving and data files, as well as share and delegate access to your Outlook items.

Power BI Intermediate: Power BI Intermediate

This course shows you how to use the advanced features of Power BI to create interactive dashboards and reports. You will learn how to use DAX formulas and functions, create calculated columns and measures, and work with advanced data visualization techniques. With the no-code artificial intelligence (AI) experiences in Microsoft Power BI, you can easily leverage highly interactive and intelligent visuals to detect patterns in your data, ask questions of your data and discover new insights that can empower every individual and every team in their decision making.

Power BI Introduction: Power BI Introduction

The Microsoft Power BI collection of software, apps, and services helps analyze your data and uncover insights and trends. This course shows you how to link and model data in Power BI and create visual reports that reveal data insights. The class focuses on the Power BI desktop client and includes an introduction to the Power BI web app.

PowerPoint 365 Level 1: PowerPoint 365 Level 1

How do you grab and maintain an audience's focus when you're asked to present important information? By being clear, organized, and engaging. Today's audiences are tech savvy, accustomed to high-impact multimedia content, and stretched for time. By learning how to use the vast array of features and functionality contained within PowerPoint 365, you will gain the ability to organize your content, enhance it with high-impact visuals, and deliver it with a punch. In this course, you will use PowerPoint 365 to begin creating engaging, dynamic multimedia presentations.

PowerPoint 365 Level 2: PowerPoint 365 Level 2

Create more dynamic and visually appealing presentations using the more advanced features of PowerPoint. The course covers transitions and animation, themes, slide masters, advanced formatting, SmartArt, adding audio and video, collaborating with others, protecting your presentations and more.

SharePoint Flows: SharePoint Flows

Learn how to create and build Flows to integrate with SharePoint Online to automate time-consuming business tasks and processes, save time, and increase accuracy and consistency.

SharePoint Modern Experience Site Basics: SharePoint Modern Experience Site Basics

SharePoint facilitates communication and collaboration, enabling people to use familiar applications and web-based tools to create, access, store, and track documents and data in a central location. In this course, you will use SharePoint to access, store, share, and collaborate with information and documents. Prerequisite Windows proficiency and familiarity with Microsoft 365.

SharePoint Site Owner With Microsoft Forms and Flow: SharePoint Site Owner With Microsoft Forms and Flow

SharePoint, in conjunction with the Microsoft 365 suite of productivity and office automation tools, provides tools to create and manage a corporate intranet, facilitate content sharing and collaboration, and enable users to create, access, store, and track documents and data in a central location. By default, SharePoint provides end users with a generous set of permissions, enabling users to create and customize their own sites as site owners, and create and collaborate on team site content. Users who have grown comfortable with these fundamental content-authoring capabilities may want to move on to more advanced features, such as connecting multiple SharePoint sites through a hub, importing list data from external sources, implementing user input validation features, applying conditional formatting, and using Power Apps® to provide custom user interfaces for data collected in SharePoint. This course focuses on issues related to planning and implementing an intranet with multiple communication sites and team sites interconnected through a hub site to provide unified navigation search, and formatting. Prerequisite To ensure your success in this course, you should have basic SharePoint site user skills such as the ability to view and enter data in SharePoint lists and libraries, and to navigate a typical SharePoint site. You can obtain these skills by taking the SharePoint Modern Experience Site Basics course.

Visio: Visio

Visio provides you with an intuitive, customizable tool to easily create a professional-looking diagram by using its extensive gallery of shapes. Create visually engaging diagrams, maps, and drawings, using graphical elements to make information easier to comprehend.

Visio Advanced: Visio Advanced

Learn the advanced features of Visio 2016, including creating advanced plans and diagrams, working with shape styles, creating macros, building advanced shapes, and inserting drawings into other Microsoft Office programs.

Windows 11 Introduction: Windows 11 Introduction

Gain an understanding of the Windows desktop and file and folder management. In this course, you will explore Windows 11 and learn how to work with locally installed apps and cloud-based apps, browse the Internet, and manage basic Windows 11 settings.

Word 365 Level 2: Word 365 Level 2

Organize content using tables and charts, ensure consistent formatting in a document using templates and styles, simplify and manage long documents, and effectively use the mail merge feature in word.

Word 365 Level 3: Word 365 Level 3

Edit images with advanced image tools, collaborate with others, create cross-references, create forms, secure your documents, and create macros to save time and improve accuracy.