| Course Name |
Hours |
List Price |
Content |
| Excel 2019 Formulas |
6.00 |
$279.00 |
|
Description: In this course, you will cover how to trace formulas, check errors, evaluate formulas, and how to use the Watch Window. You will learn about range names and how to use them in logical functions and lookup functions. You will also learn complex functions, such as SUMIF, AVERAGEIF, and COUNTIF functions. 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 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.
# of Days:
Setting:
|
| Excel 2019 Level 2 |
7.00 |
$289.00 |
|
Description: In this course, you will cover how to work with large worksheets in Microsoft Excel 2019, and use multiple worksheets and workbooks efficiently. You will sort and filter data, use conditional formatting, and create and format tables and charts. You will learn how to protect worksheets and files, as well as referring to data in other workbooks thru 3D formulas. Finally, you will create names, customize a template, and work with comments and graphics.
# of Days:
Setting:
|
| Excel 2019 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 how to assign a Macro to a Form Control. In addition, you will learn about formula auditing, and will learn about common errors, how to correct them, and how to use the Watch Window to see changes in formulas. You will work with creating and modifying hyperlinks, get data from the internet, as well as learn how to save workbooks, worksheets, charts and ranges as web pages. You will create custom styles and learn how to use advanced conditional formatting. Finally you will learn how to create and use a shared workbook, including how to protect, consolidate and resolve editing conflicts in a shared workbook.
# of Days:
Setting:
|
| Excel 365 Formulas |
6.00 |
$279.00 |
|
Description: In this course, you will cover how to trace formulas, check errors, evaluate formulas, and how to use the Watch Window. You will learn about range names and how to use them in logical functions and lookup functions. You will also learn complex functions, such as SUMIF, AVERAGEIF, and COUNTIF functions. 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:
|