MS Excel. Module 1: Intermediate

MS Excel. Module 1: Intermediate

This training covers the ability to create and manage workbooks and worksheets, modify / format cell content, summarize / organize data, present data in tables and charts, perform data operations by using functions and formulas, and insert / format objects on worksheets in MS Excel.

Durată
11 ore
Tipul de curs
Pe net
Limba
Engleză
Articol
OFFICE-009
Durată
11 ore
Location
Pe net
Limba
Engleză
Cod
OFFICE-009
Program si preturi
-
€ 300 *
Training pentru 7-8 sau mai multe persoane? Personalizați antrenamentele pentru nevoile dumneavoastră specifice
MS Excel. Module 1: Intermediate
Durată
11 ore
Location
Online
Limba
English
Cod
OFFICE-009
Program si preturi
-
€ 300 *
Training pentru 7-8 sau mai multe persoane? Personalizați antrenamentele pentru nevoile dumneavoastră specifice

Description


This training covers the ability to deal with basic features of MS Excel, including the knowledge of how to create and manage workbooks and worksheets, modify / format cell content, summarize / organize data, present data in tables and charts, perform data operations by using functions and formulas, and insert / format objects on worksheets.

Participants are expected to demonstrate correct application of the principal features of MS Excel and complete tasks independently. After completion, they can prove their skills by passing the certification exam MO-200.

certificate
After completing the course, a certificate
is issued on the Luxoft Training form

Objectives

Participants are expected to demonstrate correct application of the principal features of MS Excel and complete tasks independently.

Roadmap

  1. Manage worksheets and workbooks (3 hours: 1.5h theory, 1.5h practice)
    1. 1.1 Import data into workbooks
    2. 1.2 Navigate within workbooks
    3. 1.3 Format worksheets and workbooks
    4. 1.4 Customize options and views
    5. 1.5 Configure content for collaboration
  2. Manage data cells and ranges (2 hours: 1h theory, 1h practice)
    1. 2.1 Manipulate data in worksheets
    2. 2.2 Format cells and ranges
    3. 2.3 Define and reference named ranges
    4. 2.4 Summarize data visually
  3. Manage tables and table data (2 hours: 1h theory, 1h practice)
    1. 3.1. Create and format tables
    2. 3.2. Modify tables
    3. 3.3. Filter and sort table data
  4. Perform operations by using formulas and functions (2 hours: 1h theory, 1h practice)
    1. 4.1 Insert references in formulas
    2. 4.2 Calculate and transform data by using functions
    3. 4.3 Format and modify text by using functions
  5. Manage charts (2 hours: 1h theory, 1h practice)
    1. 5.1 Create charts
    2. 5.2 Modify charts
    3. 5.3 Format charts

TOTAL: 11 hours (50% theory, 50% practice)

Program si preturi
10:30-12:30
Cod: OFFICE-009
Location: Online
Durată: 11 ore
Limba: English
Timp: 10:30-12:30
Trainer Viacheslav Plastun
€ 300 *
Mai ai întrebări?
Conectați-văcu noi