| 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 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.
|