Microsoft Excel Advanced

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, and creating/modifying advanced charts, and pivot tables in MS Excel.

Duration
15 hours
Course type
Online
Language
English
Article
OFFICE-010
Duration
15 hours
Location
Online
Language
English
Code
OFFICE-010
Training for 7-8 or more people? Customize trainings for your specific needs
Microsoft Excel Advanced
Duration
15 hours
Location
Online
Language
English
Code
OFFICE-010
€ 350 *
Training for 7-8 or more people? Customize trainings for your specific needs

Description

Advance your Excel skills with our "MS Excel: Advanced" course.

This training is designed for individuals who have a strong understanding of intermediate Excel features and are ready to explore its advanced capabilities. Participants will learn how to manage workbooks, utilize advanced formulas, perform data analysis, create macros, and develop sophisticated charts and Pivot Tables. This course prepares participants for the MO-201 certification exam, validating their advanced proficiency in MS Excel.

This advanced-level course covers the in-depth features of MS Excel, structured into four comprehensive modules:

  • Manage Workbook Options and Settings
  • Manage and Format Data
  • Create Advanced Formulas and Macros
  • Manage Advanced Charts and Tables

By the end of this course, participants will be able to:

  • Efficiently manage workbook options and settings for advanced use.
  • Format and validate data, applying advanced conditional formatting and filtering techniques.
  • Develop and troubleshoot advanced formulas and conduct data analysis to extract insights.
  • Create sophisticated charts and PivotTables for comprehensive data analysis and visualization.

Participants will gain the expertise to leverage advanced MS Excel features, enhancing their efficiency and analytical capabilities. Successful completion of the course prepares participants to take the MO-201 certification exam, confirming their advanced skills in MS Excel.

certificate
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


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

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

4. Manage advanced charts and tables

  • Create and modify advanced charts
  • Create and modify PivotTables
  • Create and modify PivotCharts

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

Still have questions?
Connect with us