Computer Training Source

Power BI: Level 2
2023-06-12 09:00 - 16:00, 2023-02-13 09:00 - 16:00 UTC | CA, United States
Microsoft Power BI: Level 2
Course Number: 095212
Course Length: 1 day

Overview:
As technology progresses and becomes more interwoven with our businesses and lives, more data is collected about business and personal activities. This era of “big data” is a direct result of the popularity and growth of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantages.
Creating data-backed visualizations is key for data scientists, or any professional, to explore, analyze, and report insights and trends from data. Microsoft® Power BI® software is designed for this purpose. Power BI was built to connect to a wide range of data sources, and it enables users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Power BI’s data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, enabling users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action.

Course Objectives:
In this course, you will analyze data with Microsoft Power BI. You will:

Visualize data with Power BI.
Enhance data analysis by adding and customizing visual elements.
Model data with calculations.
Create interactive visualizations.
Use advanced analysis techniques.
Enhance reports and dashboards.

Target Student:
This course is designed for professionals in a variety of job roles who are currently using desktop or web-based data management tools such as Microsoft Excel® or SQL Server® reporting services to perform numerical or general data analysis. They are responsible for connecting to cloud-based data sources, as well as shaping and combining data for the purpose of analysis. They are also looking for alternative ways to analyze business data, visualize insights, and share those insights with peers across the enterprise. This includes capturing and reporting on data to peers, executives, and clients.
This course is also designed for professionals who want to pursue the Microsoft certification Exam DA-100: Analyzing Data with Microsoft Power BI.
Prerequisites:

Microsoft® Excel® for Office 365™ (Desktop or Online): Part 1 or Microsoft® Office Excel® 2019: Part 1
Microsoft® Excel® for Office 365™ (Desktop or Online): Part 2 or Microsoft® Office Excel® 2019: Part 2
Power B: Introduction

Course Content
Lesson 1: Visualizing Data with Power BI
Topic A: Create Visualizations in Power BI
Topic B: Chart Data in Power BI

Lesson 2: Enhancing Data Analysis
Topic A: Customize Visuals and Pages
Topic B: Incorporate Tooltips

Lesson 3: Modeling Data with Calculations
Topic A: Create Calculations with Data Analysis Expressions (DAX)
Topic B: Create Calculated Measures and Conditional Columns

Lesson 4: Creating Interactive Visualizations
Topic A: Create and Manage Data Hierarchies
Topic B: Filter and Slice Reports
Topic C: Create Dashboards

Lesson 5: Using Advanced Analysis Techniques
Topic A: Create Calculated Tables, Variables, and Parameters
Topic B: Enhance Visuals with Statistical Analysis
Topic C: Perform Advanced Analysis

Lesson 6: Enhancing Reports and Dashboards
Topic A: Enhance Reports
Topic B: Enhance Dashboards

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

Excel Level 1
2023-06-06 09:00 - 16:00, 2023-03-09 09:00 - 16:00, 2023-02-14 09:00 - 16:00 UTC | CA, United States
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.

SharePoint® Modern Experience: Site User
2023-05-25 09:00 - 16:00, 2023-03-14 09:00 - 16:00 UTC | CA, United States
SharePoint® Modern Experience: Site User
Course Length:
1 day

Course Description
Overview:
In many professional environments today, people work collaboratively in teams. Information technology and applications facilitate this by allowing people to easily share, access, edit, and save information. Microsoft® SharePoint® is a platform specifically designed to facilitate collaboration, allowing 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 learn about and use SharePoint to access, store, share, and collaborate with information and documents.

SharePoint is a complex platform with many features and capabilities. A strong understanding of those features and capabilities will allow you to work more efficiently and effectively with SharePoint, and with the documents and data stored in SharePoint. Furthermore, effective use of the Modern UI and Office 365™ integrations will streamline tasks, and facilitate collaboration with colleagues in other Office 365 and third-party apps.

Note: The skills covered in this course are appropriate both for Site Users who work in environments with SharePoint Online servers and for those using on-premise SharePoint servers in Modern Experience mode. This course covers the comprehensive suite of SharePoint online features and functions, which may go beyond what is available if the production environment is limited to SharePoint 2019 servers. How the environment is customized and configured will also affect how production sites compare to the sample sites shown in class.

Course Objectives:
In this course, you will effectively utilize resources on a typical SharePoint team and communication sites in the course of performing normal business tasks.

You will:

Interact with SharePoint sites.
Work with documents, content, and lists.
Share, follow, and collaborate on content.
Interact with Office 365 files via SharePoint.
Manage Office 365 apps with SharePoint.

Target Student:

This course is designed for Microsoft® Windows® and Microsoft Office users who are transitioning to a SharePoint environment, and who need to access information from and collaborate with team members within Microsoft SharePoint (using either a Microsoft SharePoint Online or a Microsoft SharePoint 2019 server).

Course Content
Lesson 1: Interacting with SharePoint Sites
Topic A: Access SharePoint Sites
Topic B: Navigate a SharePoint Site
Topic C: Access SharePoint from Your Mobile Device

Lesson 2: Working with Documents, Content, and Lists
Topic A: Store, Access, and Modify Documents and Files
Topic B: Add and Populate Lists
Topic C: Configure List Views, Filters, and Grouping

Lesson 3: Searching, Sharing, and Following Content
Topic A: Configure Your Delve Profile
Topic B: Share and Follow Content
Topic C: Search for Content

Lesson 4: Interacting with Office 365 Files
Topic A: Synchronize SharePoint Files with OneDrive
Topic B: Save and Share Office 365 Documents
Topic C: Manage File Versions and Document Recovery

Lesson 5: Managing Office 365 Apps with SharePoint
Topic A: Manage Microsoft Outlook with SharePoint
Topic B: Manage Microsoft Teams with SharePoint
Topic C: Manage Tasks with Planner and SharePoint

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

Microsoft Teams
2023-05-18 09:00 - 12:00, 2023-03-07 09:00 - 12:00, 2023-02-08 09:00 - 12:00 UTC | CA, United States
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.

Excel Level 3
2023-05-16 09:00 - 16:00, 2023-04-25 09:00 - 16:00, 2023-03-23 09:00 - 16:00, 2023-02-28 09:00 - 16:00 UTC | CA, United States
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.

Excel Level 2
2023-05-09 09:00 - 16:00, 2023-04-18 09:00 - 16:00, 2023-03-16 09:00 - 16:00, 2023-02-22 09:00 - 16:00 UTC | CA, United States
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.

Microsoft Office, Windows 10 & Microsoft Teams Tips and Tricks
2023-05-04 09:00 - 16:00 UTC | CA, United States
Microsoft Office, Windows 10 & Microsoft Teams Tips and Tricks
Course Content
1 Day
Overview:
This course covers “How To”, Tips and Tricks for Microsoft Windows 10, Excel, Outlook, Word, PowerPoint and Microsoft Teams. Students will learn to navigate the applications and learn great ways to save time. There are too many shortcuts to list below but the outline will give you an idea of what’s covered.

Course Objectives:
In this course, you will be able to use your knowledge of Microsoft applications suite to work more productively.

You will: (to name a few)

Lesson 1: Windows 10

Navigate the Windows 10 Desktop
Customize the Start Menu
Use Task View to Create Multiple Desktops
Use the Windows Logo Button for Easy to Use Shortcuts

Lesson 2: Excel

Record and Edit a Basic Macro
Use Function keys to Repeat what you did last
Easily Create and Modify Charts
Create Functions Using AutoComplete
Create Absolute References
Use AutoFill Effectively
Add to AutoCorrect
Customize Quick Access Toolbar
Use Group Mode
Use the SubTotal Command
Analyze Data with Quick Analysis
Use FlashFill to Pull together or Parse Data

Lesson 3: Outlook

Create an Appointment/Task from an Email
Use @Mentions
Use Voice to Text to Create Emails
Use the Search Options
Use the People Option
Use “Peek” at Calendar
Use Quick Steps
Use Quick Parts

Lesson 4: Word

Share and Collaborate on Documents
Use “Tell me what you want to do”
Use Little Known Selection Techniques
Use Quick Parts
Open and Edit a PDF Directly into Word
Add Videos and Pictures from the Web

Lesson 5: PowerPoint

Manage Large Presentations
Create Sections
Use the Screen Record option (Creates a Video Using any Application)

Lesson 6: Microsoft Teams

Create and Use a Team
Explain the Connection Between Teams, Outlook and SharePoint.
Generate an Email Address for a Team. Use That Email Address to Email the Team

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

Excel Power Pivot
2023-04-27 08:30 - 16:00 UTC | CA, United States
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

PowerPoint Level 2
2023-04-26 09:00 - 16:00, 2023-03-01 09:00 - 16:00 UTC | CA, United States
PowerPoint Level 2
Course Length: 1 day

Course Objectives:

Upon completing this course, you will be able to customize the PowerPoint O365 – Desktop Version application, and effectively create, collaborate on, secure, and distribute complex multimedia presentations for a variety of situations.

You will:

Modify the PowerPoint environment.
Customize design templates.
Add SmartArt and math equations to a presentation.
Work with media and animations.
Collaborate on a presentation.
Customize a slide show.
Secure and distribute a presentation.

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

Microsoft Forms
2023-04-19 09:00 - 12:00 UTC | CA, United States
Gathering Information with Microsoft® Forms
Course Length: .5 Day
Course Number: 025015-04

Course Description

Overview:
This course builds on the foundational knowledge of the Microsoft® Office 365® online apps and takes a deeper look at the other apps beyond Microsoft Word, Excel®, and PowerPoint®. The Forms app is a tool for collecting information that can be used to help determine your next course of action.
Target Student:
This course is designed for knowledge workers in a variety of professional situations and fields who have been introduced to the Office 365 online productivity apps and want to explore and use them to collaborate, communicate, and share resources with members of their organizations.

Course Content

Lesson 1: Gathering Information with Forms
Topic A: Create a Form
– Microsoft Forms
– New Form Creation
– The Untitled Form
– The Add Question Toolbar
– Question Interface
– The Preview Feature
– How to Create Forms
– Creating Forms
Topic B: Share Forms and Collect Responses
– The Share Settings
– How to Share Forms
– Sharing Forms
– Responding to Forms
– The Responses Tab
– Reviewing the Collected Responses
– Responses in Excel
– Reviewing the Responses in Excel

Microsoft Power Automate - Introduction
2023-03-28 09:00 - 16:00 UTC | CA, United States
Microsoft Power Automate – Introduction
$250
Course Length: 1 day

Duration: 1 day
Overview
Quickly build no-code automations (integrations) between Office 365, SharePoint, Teams, and hundreds of other popular Microsoft and non-Microsoft applications. This Power Automate training course teaches attendees how to turn business processes into automated, consistent, and visual Power Automate automations.
Note: This course can be delivered as 1 full day or 2 half-days.
Prerequisites
No prior experience is presumed.

Objectives

Describe the components of Power Automate and leverage their benefits
Create and edit Power Automate automations
Integrate standard and premium connectors, web services, and on-premise data
Use the Power Automate mobile app
Administer and maintain Power Automate

Outline

An Introduction to Power Automate

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

Getting Started with Power Automate

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

Power Automate Logic

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

Integration

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

The Mobile App

Downloading the mobile app
Signing in and account management
Building and managing Power Automates automations
Creating buttons
Feeds and approvals

Administration and Maintenance

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

OneNote - w/Tips and Tricks
2023-03-21 09:00 - 16:00 UTC | CA, United States
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.

Microsoft Project Level 1
2023-02-20 09:00 - 16:00 UTC | CA, United States
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.

Power BI: Level 1
2023-02-16 09:00 - 16:00 UTC | CA, United States
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.

Excel VBA (Macros) - Two Day Course (February 13th and 14th)
2023-02-13 09:00 - 2023-02-14 16:00 (America/Denver)
Course length: 2.0 day(s) October 25th and 26th
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

PowerPoint Level 1
2023-02-09 09:00 - 16:00 UTC | CA, United States
Course Length: 1 day

Course Objectives:

Upon completing this course, you will be able to create and deliver engaging multimedia presentations that convey the key points of your message through the use of text, graphics, and animations.

You will:

Identify the basic features and functions of PowerPoint O365 – Desktop Version.
Develop a PowerPoint presentation.
Perform advanced text editing operations.
Add graphical elements to your presentation.
Modify objects in your presentation.
Add tables to your presentation.
Add charts to your presentation.
Prepare to deliver your presentation.

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