Computer Training: Microsoft Excel II

In this class, after a quick review of Excel I, you will use Microsoft Office Excel 2016 to learn how to:

• Create formulas using basic Excel functions and basic operations
• Apply format as tables
• Use “Subtotal” from the “Data Tab,” from the function formula, or after applying the format to the data as a table
• Apply conditional formatting
• Create and manage names, and use them in formulas
• Add/delete/edit data validating restrictions, and add messages and error alerts
• Create and customize charts

You will also learn how to use the following Excel functions:

• ROUND, ROUNDUP, ROUNDDOWN, FLOOR, CEILING, and TRUNC
• PRODUCT, IF, AND, OR, SUMIF, COUNTIF, and how to use nested functions in Excel

For more information, and to register, please contact:

Maha Nabhan  | 902-406-0863  | computerskills@isans.ca