Software Training

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.

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.

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.

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.

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.

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.

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.

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.

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.

Learn how to create, share, sync and collaborate with this online-only productivity suite.

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.

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.

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.

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.

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.

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.

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.

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.

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

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.

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.

Create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents.

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.

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.

Increase your Excel calculation skills using statistical, date, text, financial, and lookup functions and learn how to check for errors in a worksheet.