Excel, Beginner Part 2 | Virtual classroom
Course Overview
Mastering the basics features of Excel to create a simple spreadsheet from the design phase to the printing process.
Prerequisites
A good knowledge of Microsoft Windows.
Syllabus
Functions:
- Creating a formula using functions;
- Using the SUM function;
- Adding a range of data using the instant data analysis tools;
- Using Statistical functions;
- 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 conditional formatting;
- Copying and pasting formatting.
Page Layout and Printing:
- Using the Print Preview feature;
- Modifying the page layout options;
- Using the Page Layout view;
- Editing page breaks;
- Defining the print area;
- Printing a spreadsheet.
Duration : 3 h
Note :
Regular Rate :
125.00 $
Preferential Rate : 106.25 $Note :
Webinar Web Platform
Access available 15 minutes before the Webinar.
The access instructions and the password will be provided by email 48 hours before the presentation.