This official Microsoft exam could include questions based on the following topics: Look at the usage of macros, including their creation, editing and the options of macro security.

Familiarise yourself with the options of protecting and sharing the workbook content.

Learn to prepare a table or entire worksheet before printing.

Also, examine the insertion of various graphical elements into worksheets i.e.

Focus on the creation of charts and automation of the work in the program using macros.

Examine how to split longer text entries in tables into individual data placed into several columns.

Study searching for specific values in extensive tables.Familiarise yourself with the advanced options of sorting and filtering data.Learn to fill cells with a series of data.Understand the principles of referencing to the values in other cells.Broaden your basic knowledge by the application of logical and text functions.Follow interactive lessons focused mainly on performing calculations.Learn to create calculations using basic arithmetic formulas.Learn to work with worksheets and entire files.Study the manipulation of each cell and cell range.

Learn how to set up cell formatting, including conditional formatting.

Find out how to enter values correctly into the cells.

Familiarise yourself with MS Excel 2019, its documents, and controls.

This package is made up of three courses: What is the MS Excel online course modules?

Microsoft excel 2019 training