Search courses 👉
Professional Course

Microsoft Excel Advanced

Length
15 hours
Price
350 EUR + tax
Next course start
Start Anytime! See details
Delivery
Self-paced Online
Length
15 hours
Price
350 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 advanced features of MS Excel, including the knowledge of how to manage workbooks, prepare them for collaboration, filling cells with data, conditional formatting and data validation, applying advanced formulas and data analysis, creating macros, creating / modifying advanced charts, and pivot tables in MS Excel.

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

Upcoming start dates

1 start date available

Start Anytime!

  • Self-paced Online
  • Online
  • English

Who should attend?

Prerequisites

Knowledge of MS Excel at a user level, or OFFICE-009

MS Excel. Module 1: Intermediate

Training content

1. Manage workbook options and settings (3 hours: 1.5h theory, 1.5h practice)

1.1 Manage workbooks

1.2 Prepare workbooks for collaboration

1.3 Use and configure language options

2. Manage and format (3 hours: 1.5h theory, 1.5h practice)

2.1 Fill cells based on existing data

2.2 Format and validate data

2.3 Apply advanced conditional formatting and filtering

3. Create advanced formulas and macros (6 hours: 3h theory, 3h practice)

3.1. Perform logical operations in formulas

3.2. Look up data by using functions

3.3. Apply advanced date and time functions

3.4. Perform data analysis

3.5. Troubleshoot formulas

3.6. Create and modify simple macros

4. Manage advanced charts and tables (3 hours: 1.5h theory, 1.5h practice)

4.1 Create and modify advanced charts

4.2 Create and modify PivotTables

4.3 Create and modify PivotCharts

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

Certification / Credits

Objectives

Participants are expected to demonstrate correct application of the advanced 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 Microsoft Excel Advanced.

  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