Excel 2019: From beginner to intermediate

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 .