| Course Name |
Hours |
List Price |
Content |
| Excel 365 Level 1 |
7.00 |
$279.00 |
|
Description: The Computer Workshop writes their own curriculum for Excel making it easy to customize a class specific to your needs. Many think they are past the basics, but our course has many valuable shortcuts and quick data entry methods built in to give you a good foundation. So even if you have used Excel for a number of years, it is worth taking the Level 1 class. Our course will make ordinary tasks much easier for you to accomplish, and in much less time.
# of Days:
Setting:
|
| Excel 365 Level 2 |
7.00 |
$289.00 |
|
Description: In this course, you will cover how to work with large worksheets and workbooks in Microsoft Excel. Create Named cells and ranges which are used in formulas and navigation. Write formulas that refer to other worksheets and workbooks. Create 3D formulas that refer to data in other worksheets and workbooks. You will sort and filter data, use conditional formatting, and create and format tables and charts, and how to use the Quick Analysis tools. Apply protection to the worksheet, workbook, and file itself. You will work with graphics, run the Accessibility Checker and make the file Accessible (508 Compliant), create and work with comments, and finally create a custom template.
# of Days:
Setting:
|
| Excel 365 Level 3 |
7.00 |
$299.00 |
|
Description: In this course, you will cover how to create and work with Macros and VBA Programming, as well as how to add Form Controls and assign a Macro to a Form Control. In addition, you will work with creating and modifying hyperlinks, get data from the internet using the new Power Query tool. You will learn how to use Outlining, Subtotaling, and Consolidation tools. You will also learn not to use the analytical tools of Goal Seek, Data Tables, Scenarios, Solver, and Forecasting.
# of Days:
Setting:
|
| Microsoft Office 365 Online with Teams for the Desktop |
7.00 |
$399.00 |
|
Description: This course is an introduction to Microsoft Office 365 with Teams in a cloud-based environment. It can be used as an orientation to the full suite of Office 365 cloud-based tools, or the Teams lessons can be presented separately in a seminar-length presentation with the remaining material available for later student reference.
Using the Office 365 suite of productivity apps, users can easily communicate and collaborate together through Microsoft Outlook mail and Teams messaging and meeting functionality. Additionally, the Microsoft SharePoint team site provides a central storage location for accessing and modifying shared documents. This course introduces working with shared documents in the familiar Office 365 online appsWord, PowerPoint, and Excelas an alternative to installing the Microsoft Office desktop applications. This course also introduces several productivity apps including Yammer, Planner, and Delve that can be used in combination by teams for communication and collaboration.
In this course, you will build upon your knowledge of the Microsoft Office desktop application suite to work productively in the cloud-based Microsoft Office 365 environment.
You will:
Sign in, navigate, and identify components of the Office 365 environment.
Create, edit, and share documents with team members using the Office Online apps, SharePoint, OneDrive for Business, and Delve.
Collaborate and work with colleagues using the Yammer and Planner apps.
Use email and manage contacts with Outlook on the web.
Collaborate using Teams.
Configure Teams.
# of Days:
Setting:
|