Formatting topics - renaming a worksheet, changing tab colours, modifying page setups or worksheet orders, or inserting and deleting columns/rows.Navigating around worksheets and workbooks - this could look at searching for data in a workbook, navigating to specific cells, range, or a workbook element, or inserting and removing hyperlinks.Creation of worksheets and workbooks - including importing data from a delimited text file, adding worksheets to existing workbooks, and copying or moving a worksheet.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?

Free excel 2019