UNIT 1……………………………………………………………. 7
Workbook and Worksheet Handling
1.1 Create Worksheets and Workbooks: Create a workbook, Add a worksheet to an existing workbook
1.2 Navigate in Worksheets and Workbooks: Search for data within a workbook, Navigate to a named cell, range, or workbook element, Insert and remove hyperlinks
1.3 Format Worksheets and Workbooks: Insert and delete columns or rows, Adjust row height and column width, Insert headers and footers
UNIT 2……………………………………………….. 20
Apply Custom Data Formats and Layouts
2.1 Apply Custom Data Formats and Validation-Create custom number formats, Populate cells by using advanced Fill Series options, Configure data validation
2.2 Apply Advanced Conditional Formatting and Filtering, Create custom conditional formatting rules, Create conditional formatting rules that use formulas, Manage conditional formatting rules
UNIT 3…………………………………………………….. 60
Create Tables and Apply Filter and Sort
3.1 Create and Manage Tables-Create an Excel table from a cell range, Convert a table to a cell range, Add or remove table rows and columns
3.2 Filter and Sort a Table-Filter records, Sort data by multiple columns, Change sort order, Remove duplicate records
UNIT 4………………………………………………….. 65
Perform Operations with Formulas and Functions
4.1 Summarize Data by using Functions-Insert references, Perform calculations by using the SUM MIN and MAX, COUNT, AVERAGE 4.2 Perform Conditional Operations by using the IF, SUMIF, AVERAGEIF, COUNTIF
4.3 Format and Modify Text by using Functions: RIGHT, LEFT, and MID, UPPER, LOWER, PROPER, CONCATENATE
UNIT 5………………………………………………………….. 71
Create Charts, Objects and Tables
5.1 Create Charts-Create a new chart, Add additional data series, Switch between rows and columns in source data, Analyze data by using Quick Analysis
5.2 Format Charts-Resize charts, Add and modify chart elements, Apply chart layouts and styles, Move charts to a chart sheet
5.3 Insert and Format Objects-Insert text boxes and shapes, Insert images, Modify object properties, Add alternative text to objects for accessibility
5.4 Create Advanced Charts and Tables-Create and Manage PivotTables- Create PivotTables, slicers, Group PivotTable data
5.5 Create and Manage Pivot Charts-Create PivotCharts- Manipulate options in existing PivotCharts, Apply styles to PivotCharts