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!


Charlotte Magnusson

Charlotte Magnusson

Education Manager, Excellerate

charlotte.magnusson@consid.se

+46 72-368 73 36

Other courses on Microsoft 365

Course | 2024-04-11

Search engine optimization (SEO)

Search engine optimization (SEO)
A lightbulb in the foreground in front of a laptop in the background, both painted in beige, white and pink nuances.

Course | 2023-12-15

Accessibility for UX

Accessibility for UX