search
-
Start Date
End Date
backgroundbackgroundMicrosoft Excel 2019 advanced
Microsoft Excel 2019 advanced
share
favourite

Microsoft Excel 2019 advanced

Course/workshop
Course/workshop
Advanced
Advanced
Group 3 - 5
Group 3 - 5
Training
Training
Business
star-favourite0
535.00 €
per course

About course

The participants learn many relevant functions of Excel. Through exercises, you become familiar with logic, statistics and database functions and can optimize your work environment in MS Excel 2019.

The registration for the offline course is restricted to up to 6 members per group.

The registration for the online course is unrestricted, the groups will form continuous bases.

Content

Formulas and functions from Microsoft Excel 2019

  • Calculations with relative and absolute references
  • Nest functions in MS Excel 2019
  • Tools for finding errors in formulas
  • Calculate with names
    Special formatting and editing in MS Excel 2019
  • Flashfill, quick trends, quick analyzes
  • Edit multiple tables at the same time
  • Conditional formatting
  • Use and adjust data bars, color scales, symbol sets
  • Validity rules
  • Create templates
  • Edit and print large tables
    Working with lists and databases in Microsoft Excel 2019
  • Consolidate by position and rubric
  • Sort by multiple criteria
  • Insert partial results
  • Filter data (auto filters and special filters)
  • Evaluations with database functions
    Text functions in MS Excel 2019

Pivot tables in Microsoft Excel 2019

Optimization and calculation in MS Excel 2019

Logic functions in Microsoft Excel 2019
Tips and tricks for Microsoft Excel 2019

Map

courseImage

Business

Microsoft Excel 2019 advanced

Like and share!

share
favourite

Leave a review

Rate

Comments and rates

There are no reviews

Become a business professional

Are you interested in business topics? Receive the best marketing, management, and other field-related courses based on your preferences and needs. Just let us know we can help! Leave an email!

Related Courses

See More
share
favourite
No Schedule

star-favourite0
per course
share
favourite
No Schedule

star-favourite0
share
favourite
No Schedule

star-favourite0
per course