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

A man sitting at a desk holding a hand on his glasses in fornt of the computer.

Course | 2024-05-29

Power BI

Power BI
A man sitting at a desk holding a hand on his glasses in fornt of the computer.

Course | 2024-05-27

M365 Copilot - a lecture

M365 Copilot - a lecture