This module is the first of two that teach intermediate level aspects of Microsoft Excel. It covers topics such as Data Validation, Conditional Formatting, Transferring data between sheets, Tabular data, Charts and Graphs, Screenshotting, and IF statements. You should ideally have completed the Foundation 1 and 2 courses before attempting the Intermediate Level. The module consists of 17 pages, including five multiple choice questions and a practical exercise.
➢ Data Validation – allows cells to have only specific values
➢ Conditional Formatting – format of the cell depends on the value in the cell
➢ Data Transfer between worksheets
➢ Format as Table – Table Styles
➢ Charts and Graphs.