Business & Finance   

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.

Required: 

• Access to Microsoft Excel
• Microsoft Excel for Office 365 (Desktop or Online) Part 1 (appx. $30.12)

Please see CEU procedure and Student Learning Outcomes.
 

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.

Prerequisite: Excel Level 1 or equivalent experience

Required: 

• Access to Microsoft Excel
• Microsoft Excel for Office 365 (Desktop or Online): Part 2 (appx $30.12)

Please see CEU procedure and Student Learning Outcomes.
 

Learn how to use PivotTables to summarize, group, chart and analyze data effectively in Microsoft Excel.

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. During this class, the instructor demonstrates the concepts while you perform the tasks at the same time.

Required: 

• Microsoft Excel for Office 365/2021: Data Analysis with PivotTables (appx $15.98)
• Access to Microsoft Excel

Pre-Requisites: Basic experience with Microsoft Excel.

Please see CEU procedure and Student Learning Outcomes.
 

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.

Prerequisite: Excel Level 1 or equivalent experience

Required: 

• Access to Microsoft Excel
• Microsoft Excel for Office 365/2021: Data Analysis with Power Pivot (appx. $15.98)

Please see CEU procedure and Student Learning Outcomes.
 

Copilot Chat is a hands on, practical course designed for adults who want to save time, work more efficiently, and feel confident using AI at work and in everyday projects. You'll learn how to use Copilot Chat to analyze files, write and refine content, generate presentations, create images, and automate common tasks - without needing technical or AI experience. Through real world examples and guided practice, you'll discover how to ask better questions, get more useful results, and use Copilot in Word, Excel, and PowerPoint. Whether you're new to AI or already experimenting, this course helps you turn curiosity into confidence and productivity.

This will be a live, online class offered via Zoom. It is a combination of demonstration and hands-on learning.

Student Learning Outcomes:

• Use Copilot Chat to create effective prompts and extract meaningful insights from documents and messages.
• Apply Copilot in Word to generate, revise, and summarize professional documents.
• Use Copilot in Excel to analyze data, identify trends, and create visual summaries using natural language instructions.
• Build presentations in PowerPoint by generating slides, improving structure, and creating speaker notes with Copilot.
• Improve communication in Outlook by drafting messages, summarizing conversations, and preparing meeting follow ups with Copilot.
• Create and use Copilot agents to automate tasks and support common workflows.
• Generate and refine AI images to support documents, presentations, and creative projects.

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.

Required: 

• Access to Microsoft PowerPoint
• Microsoft PowerPoint for Office 365 (Desktop or Online): Part 1 (appx $22.82)

Please see CEU procedure and Student Learning Outcomes.