Search courses 👉
Professional Course

MS Excel. Module 1: Intermediate

Length
11 hours
Price
300 EUR + tax
Next course start
Start Anytime! See details
Delivery
Self-paced Online
Length
11 hours
Price
300 EUR + tax
Next course start
Start Anytime! See details
Delivery
Self-paced Online
This provider usually responds within 48 hours 👍

Course 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.

Upcoming start dates

1 start date available

Start Anytime!

  • Self-paced Online
  • Online
  • English

Who should attend?

Prerequisites

None

Training content

  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)

Certification / Credits

Objectives

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

Quick stats about Luxoft Training Center?

More than 200 training courses

Conducted over 1,500 training sessions

Customized training solutions for business

Contact this provider

Contact course provider

Fill out your details to find out more about MS Excel. Module 1: Intermediate.

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Luxoft Training Center
Warsaw Spire, plac Europejski 1
00-844 Warsaw

Luxoft Training Center

Luxoft Training Center — an essential part of the global technology leader, Luxoft, a DXC Technology Company. We play a pivotal role in propelling B2B businesses forward by delivering customized training solutions. Emphasizing the significance of learning and employee development,...

Read more and show all training delivered by this supplier

Ads