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.