| 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:
|
| Excel Data Mastery: Importing, Cleaning Shaping Data |
4.00 |
$279.00 |
|
Description: You will cover how data from different sources are imported in Excel. Use Power Query and M Language to transform the raw data into meaningful data that is ready for analysis. Once the query is finalized you will then learn how to save the query for future use as new source data needs to be brought into excel for analysis.
# of Days:
Setting:
|
| Excel Essentials for Everyday Productivity |
4.00 |
$279.00 |
|
Description: This beginner friendly course gives new Excel users a strong foundation in navigating the interface, entering data, and building simple formulas. Even if students have used Excel before, this session uncovers timesaving shortcuts, smart data entry tools, and practical techniques that make everyday tasks faster and easier. Participants learn how to create workbooks, use AutoFill and Flash Fill, and build basic formulas with confidence.
# of Days:
Setting:
|
| Excel Formatting Worksheet Design Made Easy |
4.00 |
$279.00 |
|
Description: In this course, you will cover the formatting worksheets, creating custom number formats, preparing documents for printing or conversion into PDFs, using proofing tools, and creating custom shorthand using AutoCorrect.
# of Days:
Setting:
|
| Excel Power Functions: Lookup, Logic Data Summarization |
4.00 |
$279.00 |
|
Description: In this course, you will learn about how to use names in logical and lookup functions. You will also learn to use complex functions, such as SUMIF / SUMIFS and other functions to perform calculations on large data sets.
# of Days:
Setting:
|
| Excel Power Skills: Spot Trends, Build Visuals, Protect Your Work, and Create Templates |
4.00 |
$279.00 |
|
Description: You will sort and filter data, use conditional formatting, 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 Power Skills: Text Functions Date/Time Intelligence |
4.00 |
$279.00 |
|
Description: This course focuses on how to use function formulas to manage text and its formatting, as well as performing complex date and time calculations.
# of Days:
Setting:
|
| Excel Productivity: Large File Management Linked Formula Techniques |
4.00 |
$279.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.
# of Days:
Setting:
|
| Microsoft Office 365 Online with Teams for the Desktop |
7.00 |
$399.00 |
|
Description: This course is designed to help you master Microsoft Teams, the key communications tool in the suite of Microsoft 365 productivity apps. Microsoft Teams enables individuals and organizations to chat, share ideas, collaborate on files, and essentially, work together. You can use Teams to have a quick chat with a colleague, participate in a virtual meeting, make an online call, and share files and resources. You can also create and configure Teams to suit your business productivity needs. The Microsoft Teams app is available in three versions: a desktop app, a web app, and a mobile app. Once you are familiar with the Teams desktop app, you can easily transfer that knowledge and work in the web and mobile apps to take advantage of connecting through Teams wherever your work takes you.
# of Days:
Setting:
|