Excel Beginner Part 1 | Virtual classroom

Course Overview

Mastering the basics features of Excel to create a simple spreadsheet.

Prerequisites

A good knowledge of Microsoft Windows.

Syllabus

Basic Concepts:

• What is a spreadsheet;
• Starting Microsoft Excel;
• The Excel environment.

Data Entry:

• The different data types;
• Setting the display, the content and the format of a cell;
• Data entry;
• Editing data.

Workbook Management:

• Creating a new workbook;
• Opening a workbook;
• Saving a workbook;
• Saving and sharing files online;
• Freezing titles;
• Viewing multiple workbooks;
• A workbook, a window.

Editing Techniques:

• Selecting cells;
• Moving or copying cells;
• Using the Auto Fill feature.

Basic Calculations:

• Creating a formula;
• Using mathematical operators;
• Identifying the order of calculation;
• Copying the result of a formula;
• Modifying the reference type.