Excel 2013/2016/2019/2021/365 Regular Beginner EX-027

Course Overview

Mastering the basic features of Excel to create a simple spreadsheet from the design phase to the printing process.

Prerequisites

Have a good knowledge of Windows.

Syllabus

Basic Concepts:

• What is a spreadsheet;
• Starting Microsoft Excel;
• The Excel environment;
• Customizing the Ribbon;
• Customizing the Quick Access toolbar;
• Importing/Exporting customizations;
• The “Backstage”;
• Understanding the Excel characteristics;
• Using the mouse;
• Using the keyboard;
• Using the Excel help features.

Data Entry:

• The different data types;
• Setting the display, the content and the format of a cell;
• Data entry;
• Editing data;
• Undoing, redoing or repeating an action;
• Using the Zoom features.

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;
• Sending a workbook via e-mail;
• Closing a workbook;
• Closing Excel.

Editing Techniques:

• Selecting cells;
• Moving or copying cells;
• Working with data series;
• Using the Auto Fill feature;
• Searching and replacing text.

Basic Calculations:

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

Functions:

• Creating a formula using functions;
• Using the SUM function;
• Adding a range of data using the instant data analysis tools;
• Using Statistical functions;
• Using Date functions;
• Using the IF Logical function;
• Changing the format of cells.

Spreadsheet Management:

• Changing the width of a column;
• Changing the height of a row;
• Inserting or deleting cells;
• Inserting or deleting rows or columns;
• Hiding rows or columns.

Formatting Data:

• Modifying the alignment;
• Formatting characters;
• Adding borders;
• Applying shades to cells;
• Using styles;
• Using conditional formatting;
• Copying and pasting formatting.

Page Layout and Printing:

• Using the Print Preview feature;
• Modifying the page layout options;
• Editing page breaks;
• Setting the print area;
• Printing a spreadsheet.