| Course Name |
Hours |
List Price |
Content |
| Excel 365 Formulas |
12.00 |
$598.00 |
|
Description: This course has been updated to include several advanced formulas as well as formulas used by the beginner as well as IT users. You will cover how to trace formulas, check errors, evaluate formulas, and how to use the Watch Window. You will review the use of range names and how to use them in logical functions and lookup functions. You will be introduced to new formulas such as the LAMBDA and RANK functions. You will also learn complex functions, such as SUMIF, AVERAGEIF, and COUNTIF functions. You will also learn a wide variety of Text Functions that can be used in a wide variety of processes when creating complex spreadsheets. In addition, you will learn about date and time functions, including finding the day of the week and the week number.
# of Days:
Setting:
|
| 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:
|
| Excel 2019 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.
|