Course

Excel: Advanced course

Registration
This advanced Microsoft Excel course is designed to equip you with a deeper understanding of its advanced tools and features, such as database functionality, consolidation, and pivot tables.

About the course

In just one day, you’ll gain comprehensive knowledge of Excel’s database functionality, consolidation, pivot tables and much more. Our goal is to equip you with the skills needed to navigate Excel efficiently. You will receive lots of valuable tips on how to work more efficiently and smoothly within the application.

  • Review of basic functionality
  • Formulas and functions like VLOOKUP and IF
  • Database functions such as data validation, consolidation, and subtotal
  • Pivot tables and pivot charts
  • Collaboration with other Microsoft Office applications
  • Tips and tricks

Prerequisites

Knowledge equivalent to our Excel, Basic course.

Target audience

The course is ideal for skilled Excel practioners who want to advance their knowledge of database functionality, consolidation, and pivot tables within the application.

Duration

1 day course, from 9 am to 4 pm

Course type

The course is customizable for closed groups and can be held on-site or online.

Colleagues during workshop.

Contact 

Leave your details, and we'll get in touch!

Privacy Policy

Further questions? Contact me directly! 


Woman with a ponytail, wearing a blue blouse and black cardigan, looking calmly at the camera.

Charlotte Magnusson

Head of Education

charlotte.magnusson@consid.se

+46 72-368 73 36

Other courses on Microsoft 365 

A lightbulb in the foreground in front of a laptop in the background, both painted in beige, white and pink nuances.

Course | 2024-10-16

Sitevision web analytics with Piwik Pro

Sitevision web analytics with Piwik Pro

Course | 2024-09-26

Employee Experience (EX) - a lecture

Employee Experience (EX) - a lecture