Create and manage worksheets and workbooks

• Create and navigate in Excel worksheets and workbooks,

• Format worksheets and workbooks,

• Customize options and views, and

• Configure Excel worksheets and workbooks for distribution.

Manage data cells and ranges

• Insert data into and format cells and ranges, and

• Summarise and organize data in Excel .

Create tables

• Create and manage tables,

• Manage table styles and options, and

• Filter and sort a table.

Perform operations with Excel formulas and functions

• Summarize data,

• Perform conditional operations, and

• Format and modify text.

• Excel Formulas such as COUNTIF, SUMIF, MIN etc. are translated into 15 different languages.

Create charts and objects

• Create charts,

• Format graphic elements, and

• Insert and format objects in Excel .