Microsoft Excel Advanced
This training covers the features of workbook management, how to prepare workbooks 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.
15 hours
Online
English
OFFICE-010
Microsoft Excel Advanced
Sign Up
Duration
15 hours
Location
Online
Language
English
Code
OFFICE-010
Schedule and prices
Training for 7-8 or more people? Customize trainings for your specific needs
Microsoft Excel Advanced
Sign Up
Duration
15 hours
Location
Online
Language
English
Code
OFFICE-010
Schedule and prices
Training for 7-8 or more people? Customize trainings for your specific needs

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.
After completing the course, a certificate
is issued on the Luxoft Training form

Objectives

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

Target Audience

Anyone

Prerequisites

Knowledge of MS Excel at a user level, or OFFICE-009 MS Excel. Module 1: Intermediate

Roadmap

Manage workbook options and settings
  • Manage workbooks
  • Prepare workbooks for collaboration
  • Use and configure language options

2. Manage and format
  • Fill cells based on existing data
  • Format and validate data
  • Apply advanced conditional formatting and filtering

Create advanced formulas and macros 
  • Perform logical operations in formulas
  • Look up data by using functions
  • Apply advanced date and time functions
  • Perform data analysis
  • Troubleshoot formulas
  • Create and modify simple macros

Manage advanced charts and tables
  • Create and modify advanced charts
  • Create and modify PivotTables
  • Create and modify PivotCharts
Schedule and prices
View:
Register for the next course
Registering in advance ensures you have priority. We’ll notify you when we schedule the next course on this topic
+
Courses you may be interested in
MS Excel: Practical Course
Our training helps you understand the main MS Excel functions and how to use them.
Microsoft Excel: Financial Functions
This training covers the ability to use financial functions in MS Excel. You will get basic knowledge about financial topics related to these functions.
View Catalog
Your benefits
Expertise
Our trainers are industry experts, involved in software development project
Live training
Facilitated online so that you can interact with the trainer and other participants
Practice
A focus on helping you practice your new skills
Still have questions?
Connect with us
Thank you.
Your request has been received.
Thank you!
The form has been submitted successfully.