Computer Training Source

Excel PowerPivot
2023-12-13 09:00 - 16:00 UTC
Excel Power Pivot
$219
Course Length: 1 day
Course Description
Overview: 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 is capable of doing much more. Being able to harness the power of advanced PivotTable features and create PivotCharts 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.
Course Objectives: Upon successful completion of this course, you will be able to use Excel O365 advanced PivotTable functionality to analyze your raw data.
You will:

Prepare data for PivotTable reporting and create PivotTables from various data sources.
Analyze data by using PivotTables.
Work with PivotCharts.

Target Student: Students taking this course are experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables.
Prerequisites: To ensure your success in this course, you should have experience working with Excel O365 and PivotTables. You should already understand spreadsheet concepts and be comfortable creating basic PivotTables. You can obtain this level of skill and knowledge by taking the following Logical Operations courses:

Microsoft® Office Excel® O365: Part 1
Microsoft® Office Excel® O365: Part 2

Course Content
Lesson 1: Preparing Data and Creating PivotTables

Topic A: Prepare Data
Topic B: Create a PivotTable from a Local Data Source
Topic C: Create a PivotTable from Multiple Local Data Sources
Topic D: Create a PivotTable from an External Data Source

Lesson 2: Analyzing Data by Using PivotTables

Topic A: Summarize PivotTable Data
Topic B: Organize PivotTable Data
Topic C: Filter PivotTable Data
Topic D: Format a PivotTable
Topic E: Refresh and Change PivotTable Data

Lesson 3: Working with PivotCharts

Topic A: Create a PivotChart
Topic B: Manipulate PivotChart Data
Topic C: Format a PivotChart

Microsoft Project Level 2
2023-12-14 09:00 - 16:00, 2024-07-22 08:30 - 16:00, 2024-10-23 08:30 - 16:00 UTC
Course Length: 1 day

Course Objectives:

Upon successful completion of this course, you will be able to manage an existing Microsoft Project O365 – Desktop Version project plan.

You will:

Update a project plan to reflect progress as you execute the project.
Monitor project progress in the project plan.
Adjust the project plan to control constraints.
Create project reports to share a project’s status.
Customize project settings and share customizations with other projects.

This event ticket will close at 12:00 pm the day before the event.

OneNote - w/Tips and Tricks
2023-12-14 09:00 - 16:00, 2024-05-16 09:00 - 16:00, 2024-06-11 09:00 - 16:00, 2024-11-14 09:00 - 16:00 UTC
Course Length: 1 day

Course Objectives:

In this course, you will develop digital note-taking skills by creating, modifying, and managing OneNote notebooks that work with other Microsoft Office programs.

You will:

Navigate and customize the OneNote interface and environment.
Add and format text, images, audio, links, and drawing objects to a notebook.
Embed Excel spreadsheets and attach other files to a notebook.
Categorize, organize, and search notebook content.
Check spelling in, print, and password-protect notebooks.
Use Outlook and OneDrive to send and share notebook content.
Export notebook content and manage notebook history and backups.

This event ticket will close at 12:00 pm the day before the event.

ChatGPT Basics
2023-12-18 09:00 - 12:00, 2024-07-25 09:00 - 12:00 UTC
ChatGPT Basics
Course Duration: 3 hours (including breaks)
Course Description: This course provides a condensed overview of ChatGPT, a large language model developed by OpenAI. The course covers the basics of natural language processing and how ChatGPT uses machine learning to generate human-like responses to user inputs. Participants will learn about the architecture of ChatGPT, its capabilities, and limitations. They will also gain hands-on experience using ChatGPT to generate text and engage in conversational AI.
Course Objectives: By the end of the course, participants will be able to:

Understand the basics of natural language processing and conversational AI
Explain the architecture of ChatGPT and how it works
Use ChatGPT to generate text and engage in conversational AI

Course Outline:
Section 1: Introduction to Natural Language Processing and ChatGPT (30 minutes)

Definition of natural language processing
Applications of natural language processing
Overview of ChatGPT and its architecture
The capabilities and limitations of ChatGPT

Section 2: Using ChatGPT (90 minutes)

Setting up and accessing ChatGPT
Using ChatGPT to generate text
Engaging in conversational AI using ChatGPT
Analyzing the output of ChatGPT and identifying potential biases

Section 3: Real-World Applications of ChatGPT (30 minutes)

Using ChatGPT for customer service and support
ChatGPT in educational and training contexts
ChatGPT in healthcare and mental health contexts
Ethical considerations and potential risks of ChatGPT

Section 4: Conclusion and Next Steps (30 minutes)

Recap of the course
Discussion of further resources and tools for working with ChatGPT
Practical advice on how to implement ChatGPT in real-world setting

Excel Level 1
2024-05-16 09:00 - 16:00, 2024-09-05 09:30 - 15:30, 2024-10-17 09:00 - 16:00 UTC
Excel Level 1
In this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization.
Course Objectives:

You will:

Get started with Microsoft Office Excel O365 – Desktop Version.
Perform calculations.
Modify a worksheet.
Format a worksheet.
Print workbooks.
Manage workbooks.

Course Content
Lesson 1: Getting Started with Microsoft Office Excel O365
Topic A: Navigate the Excel User Interface
Topic B: Use Excel Commands
Topic C: Create and Save a Basic Workbook
Topic D: Enter Cell Data
Topic E: Use Excel Help
Lesson 2: Performing Calculations
Topic A: Create Worksheet Formulas
Topic B: Insert Functions
Topic C: Reuse Formulas and Functions
Lesson 3: Modifying a Worksheet
Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows
Topic B: Search for and Replace Data
Topic C: Use Proofing and Research Tools
Lesson 4: Formatting a Worksheet
Topic A: Apply Text Formats
Topic B: Apply Number Formats
Topic C: Align Cell Contents
Topic D: Apply Styles and Themes
Topic E: Apply Basic Conditional Formatting
Topic F: Create and Use Templates
Lesson 5: Printing Workbooks
Topic A: Preview and Print a Workbook
Topic B: Set Up the Page Layout
Topic C: Configure Headers and Footers
Lesson 6: Managing Workbooks
Topic A: Manage Worksheets
Topic B: Manage Workbook and Worksheet Views
Topic C: Manage Workbook Properties

Appendix A: Microsoft Office Excel O365 Exam 77-727
Appendix B: Microsoft Office Excel O365 Expert Exam 77–728
Appendix C: Microsoft Excel O365 Common Keyboard Shortcuts
Appendix D: Adding Borders and Colors to Worksheets
Appendix E: Basic Excel Customization

This event ticket will close at 12:00 pm the day before the event.

Copy of Excel Level 1
2024-05-16 09:00 - 16:00 UTC

Excel Level 2
2024-05-20 09:00 - 16:00, 2024-08-26 09:00 - 16:00, 2024-10-30 09:00 - 16:00 UTC
Excel Level 2
Course Length:
1 day
Course Description
Overview:
Whether you need to crunch numbers for sales, inventory, information technology, human resources, or other organizational purposes and departments, the ability to get the right information to the right people at the right time can create a powerful competitive advantage. After all, the world runs on data more than ever before and that’s a trend not likely to change, or even slow down, any time soon. But with so much data available and being created on a nearly constant basis, the ability to make sense of that data becomes more critical and challenging with every passing day. You already know how to get Excel to perform simple calculations and how to modify your workbooks and worksheets to make them easier to read, interpret, and present to others. But, Excel is capable of doing so much more. To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data. In other words, when you have questions about your data, you need to know how to get Excel to provide the answers for you. And that’s exactly what this course aims to help you do.

Course Objectives:
Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.
You will:

Work with functions.
Work with lists.
Analyze data.
Visualize data with charts.
Use PivotTables and PivotCharts.

Target Student:
This course is designed for students who already have foundational knowledge and skills in Excel and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.

Course Content
Lesson 1: Working with Functions
Topic A: Work with Ranges
Topic B: Use Specialized Functions
Topic C: Work with Logical Functions
Topic D: Work with Date & Time Functions
Topic E: Work with Text Functions
Lesson 2: Working with Lists
Topic A: Sort Data
Topic B: Filter Data
Topic C: Query Data with Database Functions
Topic D: Outline and Subtotal Data
Lesson 3: Analyzing Data
Topic A: Create and Modify Tables
Topic B: Apply Intermediate Conditional Formatting
Topic C: Apply Advanced Conditional Formatting
Lesson 4: Visualizing Data with Charts
Topic A: Create Charts
Topic B: Modify and Format Charts
Topic C: Use Advanced Chart Features
Lesson 5: Using PivotTables and PivotCharts
Topic A: Create a PivotTable
Topic B: Analyze PivotTable Data
Topic C: Present Data with PivotCharts
Topic D: Filter Data by Using Timelines and Slicers

This event ticket will close at 12:00 pm the day before the event.

Analysis for Office – AO for Excel
2024-05-23 08:30 - 16:00 UTC
Analysis for Office – AO for Excel
Course Number: 092721AO
Course Length: 1 day
Course Description
Overview:
This course is intended for users interested in building and analyzing workbooks using SAP BusinessObjects Analysis edition for Microsoft Excel.
In AO you can use SAP BW data sources from the BI platform data sources. The data is displayed in the workbook in crosstabs. You can insert multiple crosstabs in a workbook with data from different sources and systems. If the workbook will be used by different users, it is also helpful to add info fields with information on the data source and filter status.
Using the design panel, you can analyze the data and change the view on the displayed data. You can add and remove dimensions and measures to be displayed easily with drag and drop. To avoid single refreshes after each step, you can pause the refresh to build a crosstab. After ending the pause, all changes are applied at once.
You can refine your analysis using conditional formatting, filter, prompting, calculations and display hierarchies. You can also add charts to your analysis. If you want to keep a status of your navigation, you can save it as an analysis view.
Upon successful completion of this course, you will be able to:
Identify the components of Analysis for Office

What’s New
Design and edit a basic report
Use an AO crosstab
Create and modify charts
Design and advanced report using hierarchies and filters
Create a report from scratch, using queries
Group AO crosstabs
Link and unlink dimensions for separate crosstabs

This event ticket will close at 12:00 pm the day before the event.

Excel VBA (Macros) - Two Day Course
2024-05-27 09:00 - 2024-05-28 16:00 (America/Denver)
Course length: 2.0 day(s)
Course Description
Course Objective: You will automate your job tasks in Microsoft® Office Excel® O365.
Target Student: This course is intended for advanced Microsoft Excel professionals that need to automate Excel spreadsheet tasks using Visual Basic for Applications (VBA).
Prerequisites: Knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data. Students are recommended to first take the following Logical Operations courses or have equivalent knowledge:

Microsoft® Office Excel® O365: Level 1
Microsoft® Office Excel® O365: Level 2
Microsoft® Office Excel® O365: Level 3

LESSON ONE: INTRODUCTION TO VISUAL BASIC FOR APPLICATIONS (VBA) WHAT IS VISUAL BASIC FOR APPLICATIONS (VBA)?
OBJECT-ORIENTED PROGRAMMING PROCEDURES:
OBJECTS
CONTAINERS
COLLECTIONS
PROPERTIES:
METHODS:
EVENTS:
HOW VBA REFERS TO OBJECTS
ACCESSING THE MACRO COMMANDS
SECURITY SETTINGS
SAVING WORKBOOKS THAT CONTAIN MACROS
LESSON TWO: UNDERSTANDING MACROS
WRITING CODE VS RECORDING MACROS
ABSOLUTE VS RELATIVE REFERENCING
USING THE MACRO RECORDER
RECORDING IN RELATIVE MODE
MODIFYING MACROS
METHODS FOR EXECUTING MACROS
ACCESSING MACROS THROUGH THE QUICK ACCESS
TOOLBAR
ACCESSING MACROS THROUGH THE RIBBON
ACCESSING MACROS THROUGH SHAPES OR IMAGES
ACCESSING MACROS THROUGH CONTROLS
LESSON THREE: GETTING TO KNOW THE VISUAL BASIC EDITOR (VBE)
THE MICROSOFT VISUAL BASIC EDITOR
THE PROJECT EXPLORER THE PROPERTIES WINDOW
THE CODE WINDOW
ADDING A NEW MODULE NAMING MODULES
REMOVING A MODULE EXPORTING AND IMPORTING MODULES
PROTECTING CODE
THE OBJECT BROWSER
CUSTOMIZING THE VISUAL BASIC ENVIRONMENT
The Editor Tab
Code Settings
Window Setting
The Editor Format Tab
The General Tab
The Docking Tab
DOCKING WINDOWS
LESSON FOUR: TROUBLESHOOTING AND DEBUGGING ERRORS
TROUBLESHOOTING AND DEBUGGING ERRORS
TYPES OF ERRORS Syntax Errors (aka Compile Error)
Run-Time Errors
Logical Errors
DEBUGGING TECHNIQUES
Debugging Tools
Setting a Breakpoint
The Watch Window
Stepping Through Code
Deleting a Watch Expression
The Immediate Window
The Locals Window
LESSON FIVE: WRITING VBA CODE
ESSENTIALS TO WRITING VBA CODE
Sub Procedures vs Functions
Macro Naming Rules
Comments
SUB PROCEDURES
Using Objects
Using Methods
Using Events
Storing Procedures in the Personal Macro
Workbook
Copy and Paste Procedures
Assigning Macro Buttons to the Quick
Access Toolbar (QAT)
CALLING A SUB PROCEDURE
EXPRESSIONS
VARIABLES
Declaring a Variable
Option Explicit
Declaring Multiple Variables
Assigning a Value to a Variable
DATA TYPES
Using Byte Variables
Using String Variables
Using Currency Variables
Using Date Variables
VARIANTS CONSTANTS SCOPE
Procedure Level Scope
Private Level Scope
Public Level Scope
VBA STANDARD OPERATORS
The Assignment Operator ( = )
The Line Continuation Character ( _)
The Parenthesis ( ) The Comma ( , )
The Colon Operator ( : )
The Ampersand ( & )
Carriage Return Line Feed (vbCrLf)
Defining Parameters (:=)
Arithmetic Operators Comparison
Operators
Logical Operators
THE CELLS OBJECT
The Value Property
FORMATTING DATA
The Range Object
The Select Method
The CurrentRegion Property
The RangeSort Method
MANIPULATING WORKSHEET DATA
The ActiveSheet Property
The Name Property
The Selection Property
The Copy Method
The Paste Method
The Offset Property
The End Property
The Font Property
The With End With Construct
The Call Statement
The Columns and Rows Properties
The AutoFit Method ARRAYS
LESSON SIX: WORKING WITH CONTROL STRUCTURES
CONTROL STRUCTURES
Decision Structures
If…Then
If…Then…Else
Select Case
LOOPS
For Next Loop
Stepping For Each
Do Until Loop
Do While Loop
LESSON SEVEN: WORKING WITH FUNCTION PROCEDURES
FUNCTIONS
Creating a Function
MacroOptions Method
Calling a Function
Calling a Function in a Worksheet
WRITE DATA TO TEXT FILES
USER INTERACTION FUNCTIONS
Working with Message Boxes
Working with Input Boxes
Return Values
LESSON EIGHT: ERROR HANDLING
ERROR HANDLING
The Error GoTo Statement
The On Error Resume Next
The Error Object
LESSON NINE: USER FORMS
USER FORMS
Displaying a UserForm
Printing a Form
Hiding a Form
Closing a Form
FORM PROPERTIES
Name Location Size
CONTROLS
Aligning Controls
Tab Order
Borders
Font
Control Colors
Control Visibility
Control Availability
Focus
Creating a User Form
Writing Code to Show the User Form
Event Procedures for UserForm Controls
Attaching Events to the Form Controls
Dependent Combo Boxes
LESSON TEN: MANAGING SHEETS
MANIPULATING WORKSHEETS
Sheet Types
Worksheet Reference Options
The Add Method
The Delete Method
The Copy Method
The Move Method
CREATING A CHART SHEET
The Declared Range Object
The Set Statement
REFERENCE
GLOSSARY
VISUAL BASIC LANGUAGE KEYWORDS
Reserved Keywords
Unreserved Keywords
OBJECT NAMING CONVENTIONS
CODE SNIPPETS
COMMON EXCEL VBA STATEMENTS
EXCEL VBA FUNCTIONS
VBA KEYBOARD SHORTCUTS

Microsoft Teams
2024-06-19 09:00 - 12:00 UTC
Microsoft Teams for the Desktop
Course Length:
.5 day
You will:
We Will Learn How To:

Navigate Microsoft Teams Desktop Interface
Create a Team and Add and Edit Members
Create and Follow a Channel
Create an Email Channel
Email a Channel
Mark, Like and Save Messages
Manage Files in a Channel
Work with Chat Messages and Chat Features
Access and Manage Team Settings, Members and Channels
Create and Manage Meeting Invites
Show the Connection Between, Teams, Outlook and SharePoint

Target Student:
This course is intended for business users and knowledge workers in a variety of roles and fields who have competence in a desktop-based installation of the Microsoft Office Suite and who are now extending Microsoft Office to a collaborative cloud-based Office 365 environment.
Prerequisites:
To ensure your success, you will need to be familiar with the Windows operating system and a web browser. You also need competence in using the locally installed version of Microsoft Outlook for sending email and interacting with calendar events, and should be familiar with at least one of the primary applications in the Microsoft Office suite (Microsoft Word, Microsoft PowerPoint, and Microsoft Excel).
To meet these prerequisites, you can take any one or more of the following Logical Operations courses:

Using Microsoft® Windows® 10
Microsoft® Office Outlook® 2016: Part 1

This event ticket will close at 12:00 pm the day before the event.

Microsoft Project Level 1
2024-06-24 09:00 - 16:00 UTC
Microsoft Project Level 1
$250
Course Length: 1 day

Course Objectives:

In this course, you will learn to create and engage in basic management of a project using Microsoft Project Professional O365 – Desktop Version.

You will:

Identify project management concepts and navigate the Project O365 – Desktop Version environment.
Create and define a new project plan.
Create and organize tasks.
Manage resources in a project plan.
Finalize a project plan.

This event ticket will close at 12:00 pm the day before the event.

Excel Level 3
2024-07-30 09:00 - 16:00, 2024-11-04 09:00 - 16:00 UTC
Course Length: 1 day
Course Objectives:
Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.
You will:

Work with multiple worksheets and workbooks.
Use Lookup functions and formula auditing
Share and protect workbooks.
Automate workbook functionality.
Create sparklines and map data.
Forecast data.

Target Student:
This course is intended for students who are experienced Excel O365 users and have a desire or need to advance their skills in working with some of the more advanced Excel features. Students will likely need to troubleshoot large, complex workbooks, automate repetitive tasks, engage in collaborative partnerships involving workbook data, construct complex Excel functions, and use those functions to perform rigorous analysis of extensive, complex datasets.

Prerequisites:
To ensure success, students should have practical, real-world experience creating and analyzing datasets using Excel O365. Specific tasks students should be able to perform include: creating formulas and using Excel functions; creating, sorting, and filtering datasets and tables; presenting data by using basic charts; creating and working with PivotTables, slicers, and PivotCharts; and customizing the Excel environment. To meet these prerequisites, students can take the following Logical Operations courses, or should possess the equivalent skill level:

Microsoft® Office Excel® O365: Part 1
Microsoft® Office Excel® O365: Part 2

Course Content

Lesson 1: Working with Multiple Worksheets and Workbooks
Topic A: Use Links and External References
Topic B: Use 3-D References
Topic C: Consolidate Data

Lesson 2: Using Lookup Functions and Formula Auditing
Topic A: Use Lookup Functions
Topic B: Trace Cells
Topic C: Watch and Evaluate Formulas

Lesson 3: Sharing and Protecting Workbooks
Topic A: Collaborate on a Workbook
Topic B: Protect Worksheets and Workbooks

Lesson 4: Automating Workbook Functionality
Topic A: Apply Data Validation
Topic B: Search for Invalid Data and Formulas with Errors
Topic C: Work with Macros

Lesson 5: Creating Sparklines and Mapping Data
Topic A: Create Sparklines
Topic B: Map Data

Lesson 6: Forecasting Data
Topic A: Determine Potential Outcomes Using Data Tables
Topic B: Determine Potential Outcomes Using Scenarios
Topic C: Use the Goal Seek Feature
Topic D: Forecasting Data Trends

Appendix A: Microsoft Office Excel O365 Exam 77-727
Appendix B: Microsoft Office Excel O365 Expert Exam 77–728
Appendix C: Microsoft Excel O365 Common Keyboard Shortcuts
Appendix D: Cube Functions
Appendix E: Importing and Export Data
Appendix F: Internationalizing Workbooks
Appendix G: Working with Power Pivot
Appendix H: Advanced Customization Options
Appendix I: Working with Forms and Controls

This event ticket will close at 12:00 pm the day before the event.

Microsoft Power Automate - Introduction
2024-08-08 09:00 - 16:00, 2024-11-11 09:00 - 16:00 UTC
MICROSOFT POWER AUTOMATE
Course Duration: 1 Day

Overview
This course delivers an instructor-led product showcase for Microsoft Power Automate from start to finish in an engaging and practical way. Power Automate is a diverse product, turning business processes into automated, consistent, and visual workflows. Power Automate is designed to interweave the various products in Office 365 as well as connect to other on-premises and web-based solutions. This course will give you the confidence to select the right actions and workflow logic for your business workflows.
Audience
The intended audience for this course would be those who have been using Office 365 for some time and are now looking at optimizing their existing business processes and designing new ones.
Prerequisites
Delegates should have some exposure to Microsoft Windows operating system and Microsoft Office 365.
Course Objectives

An Introduction to Microsoft Power Automate
Getting Started with Workflows
Flow Logic
Integration
The Mobile App
Administration and Maintenance

Module 1:
An Introduction to Microsoft Power Automate
Let’s get started with an introduction to Microsoft Power Automate. Historically, automating business processes typically landed in the lap of a developer in the business, who has a good understanding of coding and the systems that they were connecting. However, more systems deployed to businesses are encouraging a bigger focus on end user design and management. With this culture change, end users are looking to further improve their business solutions. Power Automate brings workflow design to all audiences. It offers the building blocks for lightweight or business-critical processes.
In this module, we cover an overview of the product and its application to Office 365 and third-party services.
Topics Covered

What is Microsoft Power Automate?
The benefits of automation
How to get to Power Automate

Module 2:
Getting started with Power Automate
We begin our discovery of Microsoft Power Automate by building our first business process. We will discuss how to use templates to get started with Power Automate or how to use a blank template to start with no defined actions. Once in the product, we will give you a tour of the editor, workflow management page and the home screen to help you navigate around the product.
Next, we will start to add, edit, and remove actions from our workflow template in order to customize the Power Automate for a specific business need. Once ready we will publish and trigger the workflow to test that it works as expected. We will finish this module by discussing how to turn a flow on or off as well as deleting a flow.
Topics Covered

Using Power Automate templates
Navigating in Power Automate
Editing a flow • Publish and trigger a flow
Turn off or delete a flow

Module 3:
Power Automate logic
Decision making during a business process is often a bottleneck. Waiting for decisions or information to steer the workflow towards its goal is dependent on how long the involved party spends on the task. This could be mitigated if the desired information is found declared elsewhere for example, as a document property or a form entry to name a few examples. Logic in a workflow allows existing information to push the workflow down multiple paths. This often speeds up workflow duration and minimizes human input.
In this module, we will look at the core logic found in Power Automate and a practical application of each option.
Topics Covered

Adding conditions
Designing switches
Using apply to each
Configuring “do until” logic
Adding a scope

Module 4:
Integration
Businesses will often use a selection of productivity tools and services beyond Office 365. Marketing teams may use Facebook and Twitter whereas a sales team may use Salesforce to manage their customers. Power Automate provides connectors for popular services allowing your processes to extend beyond Office 365 to other web services. Connections can even be made to on-premises servers, allowing your business systems house at the office to take part in your processes.
Topics Covered

Standard and premium connectors
Connecting to web services
Using Power Automate with on-premises data

Module 5:
The Mobile App
Power Automate has a corresponding mobile app that can be used to leverage many features of Power Automate. Firstly, it offers users the capability to build new flows, directly from their phone or tablet. Secondly, it can be used to manage existing flows including editing, viewing history, saving a copy, disabling, and deleting flows. You can access any approvals that have been sent to you by Power Automate and approve or reject decisions. The app also supports the push notifications that can be sent to your phone or tablet from a flow. Additionally, you can even create buttons that appear in the app which allow you to trigger flows. This valuable app will be detailed in this module.
Topics Covered

Downloading the mobile app
Signing in and account management
Building and managing flows
Creating buttons
Feeds and approvals

Module 6:
Administration and Maintenance
In our last module for Microsoft Power Automate, we will be looking at how a business can manage their flows once they have a good uptake of the product. We will begin by discussing managing individual flows. This could be using history to discover the source of any issues and implement error handling as well as using the analytics to discover usage trends. We will discover how to share a flow which is ideal for sharing the maintenance of a flow with another colleague and how to import and export flows. Finally, we will discuss how Office 365 administrators can shape the Power Automate experience with high-level settings that help ensure data segregation and security.
Topics Covered

Maintaining a flow
View history and analytics
Sharing a flow
Export and import flows
Office 365 administration for Power Automate
Environments
Data policies
Data integration

Microsoft Copilot - Introduction
2024-08-29 09:00 - 12:00 UTC
Workshop: Using Copilot in Microsoft Applications
Duration: 3 Hours

Overview:
Copilot is a digital assistant embedded into Office tools that enable people to consume content impressively faster than we are used to. It helps to discover information by holistically searching for content in different repositories.
Microsoft has branded AI under different names, to mention: Bing Chat, M365 Chat, and Copilot. This will likely standardize in the future. Copilot answers could be different for everyone; content visibility and context of the prompt make the output unique. Copilot can help you quickly catch up with unattended meetings, especially when we are double/triple booked.
During a Teams meetings Copilot uses transcriptions. Transcriptions are sensitive to listening errors or misunderstanding, leading at times to inaccuracies.

Objectives

What is Copilot
How to access Copilot
Copilot in Teams
Copilot in Outlook
Copilot in Power BI
Copilot in Designer
Q&A

Session 1: Introduction to Copilot

Welcome and Introduction

Icebreaker activity.
Overview of workshop objectives and agenda.

What is Copilot?

History and development.
How it works:

Capabilities and Limitations

Copilot can do (e.g., content generation, Q&A, conversational AI).

Session 2: Copilot and Teams

Generate meeting notes and summarize key points
Detail follow-up tasks and action items for the team
Use Copilot can recap key meetings points
Rewrite and adjust your messages
Discuss best practices using the prompts
Discuss and analyze sample prompts

Session 3: Copilot and Outlook

Prepare a quick summary of a long email
Associate related emails or conversations into the summary
Draft new emails or replies
General full-length email drafts using thread context when replying

Currently supported in the Outlook web version only

Get Coaching while writing an email (new or reply)
Provide on-demand assistance suggesting tone, sentiment, and clarity

Session 4: Copilot and Power BI

Data Import: Copilot can assist in importing data from various sources into Power BI.
Data Transformation: Copilot can help guide through data cleaning, transformation, and preparation using Power Query.
Visualization Creation: Copilot can help create and customize visualizations like charts, graphs, and maps.
Report Building: Assist in building comprehensive reports and dashboards.
DAX Formulas: Provide suggestions and assistance with writing DAX formulas for advanced calculations.

Session 5: Copilot and Microsoft Designer

Generate professional and visually appealing graphic designs automatically.
Customize templates with ease, using AI-driven suggestions for layout, colors, and fonts.
Collaborate seamlessly with team members by sharing designs and receiving feedback in real-time.

Power BI: Level 1
2024-09-11 09:00 - 16:00 UTC
Microsoft Power BI: Level 1
$250
Course Length:
1 day

Course Type: Description
This is the first course in the series. This course is meant for those desiring to gain skills using Microsoft Power BI to connect, transform and visualize data. You will learn to connect multiple sources of data and combine them (often called modeling) into a data model that lets you build visuals and collections of visuals that you can share as reports.

Upon successful completion of this course, you will be able to:

Connect to Excel File as a Data Source
Shape and Combine Data in Power BI Desktop
Combine Data
Analyze web page data using Power BI Desktop
Connect to a Web Data Source
Shape data in Power Query Editor
Create a visualization
Combine sales data from Excel and an OData feed
Import the product data from Excel
Create a custom calculated column
Manage the Relationship Between the Datasets
Complete the Sales Analysis Report
Create your Own Measures in Power BI Desktop
Create a calculated column that uses an IF function
Create and Manage Hierarchies
Publish and Share Reports and Dashboards
Publish and Set Permissions for App Workspaces

This event ticket will close at 12:00 pm the day before the event.

Word Level 1
2024-11-07 09:00 - 15:30 (America/Denver)
Microsoft Word Level 1
Course Number:
091048
Course Length:
1 day

Course Description
Overview:
These days, most people take electronic word processing for granted. While we may still write out our grocery lists with pen and paper, we expect to use a computer to create the majority of our documents. It’s impossible to avoid word-processing software in many areas of the business world. Managers, lawyers, clerks, reporters, and editors rely on this software to do their jobs. Whether you are an executive secretary or a website designer, you’ll need to know the ins and outs of electronic word processing.
Microsoft® Word O365 is designed to help you move smoothly through the task of creating professional-looking documents. Its rich features and powerful tools can make your work easy, and even fun. In this course, you’ll learn how to use Word O365 to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents.
This course covers Microsoft Office Specialist exam objectives to help students prepare for the Word O365 Exam and the Word O365 Expert Exam.

Course Objectives:
In this course, you will learn fundamental Word O365 skills.
You will:

Navigate and perform common tasks in Word, such as opening, viewing, editing, saving, and printing documents, and configuring the application.
Format text and paragraphs.
Perform repetitive operations efficiently using tools such as Find and Replace, Format Painter, and Styles.
Enhance lists by sorting, renumbering, and customizing list styles.
Create and format tables.
Insert graphic objects into a document, including symbols, special characters, illustrations, pictures, and clip art.
Format the overall appearance of a page through page borders and colors, watermarks, headers and footers, and page layout.
Use Word features to help identify and correct problems with spelling, grammar, readability, and accessibility.

Target Student:
This course is intended for students who want to learn basic Word O365 skills, such as creating, editing, and formatting documents; inserting simple tables and creating lists; and employing a variety of techniques for improving the appearance and accuracy of document content.
Prerequisites:
To ensure your success in this course, you should have end-user skills with any current version of Windows®, including being able to start programs, switch between programs, locate saved files, close programs, and access websites using a web browser. For example, you can obtain this level of skills and knowledge by taking either of the following Logical Operations courses, or any similar courses in general Microsoft Windows skills:

Using Microsoft® Windows® 10
Microsoft® Windows® 10: Transition from Windows® 7

Course Content
Lesson 1: Getting Started with Word
Topic A: Navigate in Microsoft Word
Topic B: Create and Save Word Documents
Topic C: Manage Your Workspace
Topic D: Edit Documents
Topic E: Preview and Print Documents
Topic F: Customize the Word Environment

Lesson 2: Formatting Text and Paragraphs
Topic A: Apply Character Formatting
Topic B: Control Paragraph Layout
Topic C: Align Text Using Tabs
Topic D: Display Text in Bulleted or Numbered Lists
Topic E: Apply Borders and Shading

Lesson 3: Working More Efficiently
Topic A: Make Repetitive Edits
Topic B: Apply Repetitive Formatting
Topic C: Use Styles to Streamline Repetitive Formatting Tasks

Lesson 4: Managing Lists
Topic A: Sort a List
Topic B: Format a List

Lesson 5: Adding Tables
Topic A: Insert a Table
Topic B: Modify a Table
Topic C: Format a Table
Topic D: Convert Text to a Table

Lesson 6: Inserting Graphic Objects
Topic A: Insert Symbols and Special Characters
Topic B: Add Images to a Document

Lesson 7: Controlling Page Appearance
Topic A: Apply a Page Border and Color
Topic B: Add Headers and Footers
Topic C: Control Page Layout
Topic D: Add a Watermark

Lesson 8: Preparing to Publish a Document
Topic A: Check Spelling, Grammar, and Readability
Topic B: Use Research Tools
Topic C: Check Accessibility
Topic D: Save a Document to Other Formats

Appendix A: Microsoft Office Word O365 Exam 77-725
Appendix B: Microsoft Office Word O365 Expert Exam 77-726
Appendix C: Microsoft Word O365 Common Keyboard Shortcuts

Microsoft Copilot - Introduction
2024-11-18 09:00 - 15:30 UTC
Workshop: Using Copilot in Microsoft Applications
Duration: 6 Hours

Overview:
Copilot is a digital assistant embedded into Office tools that enable people to consume content impressively faster than we are used to. It helps to discover information by holistically searching for content in different repositories.
Microsoft has branded AI under different names, to mention: Bing Chat, M365 Chat, and Copilot. This will likely standardize in the future. Copilot answers could be different for everyone; content visibility and context of the prompt make the output unique. Copilot can help you quickly catch up with unattended meetings, especially when we are double/triple booked.
During a Teams meetings Copilot uses transcriptions. Transcriptions are sensitive to listening errors or misunderstanding, leading at times to inaccuracies.

Objectives

What is Copilot
How to access Copilot
Copilot in Teams
Copilot in Outlook
Copilot in Power BI
Copilot in Designer
Q&A

Session 1: Introduction to Copilot

Welcome and Introduction

Icebreaker activity.
Overview of workshop objectives and agenda.

What is Copilot?

History and development.
How it works:

Capabilities and Limitations

Copilot can do (e.g., content generation, Q&A, conversational AI).

Session 2: Copilot and Teams

Generate meeting notes and summarize key points
Detail follow-up tasks and action items for the team
Use Copilot can recap key meetings points
Rewrite and adjust your messages
Discuss best practices using the prompts
Discuss and analyze sample prompts

Session 3: Copilot and Outlook

Prepare a quick summary of a long email
Associate related emails or conversations into the summary
Draft new emails or replies
General full-length email drafts using thread context when replying

Currently supported in the Outlook web version only

Get Coaching while writing an email (new or reply)
Provide on-demand assistance suggesting tone, sentiment, and clarity

Session 4: Copilot and Power BI

Data Import: Copilot can assist in importing data from various sources into Power BI.
Data Transformation: Copilot can help guide through data cleaning, transformation, and preparation using Power Query.
Visualization Creation: Copilot can help create and customize visualizations like charts, graphs, and maps.
Report Building: Assist in building comprehensive reports and dashboards.
DAX Formulas: Provide suggestions and assistance with writing DAX formulas for advanced calculations.

Session 5: Copilot and Microsoft Designer

Generate professional and visually appealing graphic designs automatically.
Customize templates with ease, using AI-driven suggestions for layout, colors, and fonts.
Collaborate seamlessly with team members by sharing designs and receiving feedback in real-time.

Microsoft Project
2024-11-30 09:00 - 12:00 UTC
MS Project – Level 1
