Excel skills are highly sought after in the market, so it’s no surprise that this course is one of Lexicon's bestsellers. After these two days, you’ll be considered the organization’s Excel expert!

The training focuses on practical, advanced functions and commands designed to help you solve complex tasks, analyze, and compile data in a visually appealing way. The course includes a lot of hands-on practice with a focus on real-world tasks. You’ll also get a solid overview of the latest updates to the program.

Learning Objectives

After the course, you’ll be able to save even more time in Excel by gaining deeper knowledge in calculations, pivot tables, problem-solving, and automation.

Target Audience

This course is for those who have a basic understanding of Excel and need to learn more advanced functions to work smarter and utilize more of the program’s features and capabilities.

Prerequisites

You should have completed our basic Excel course or have equivalent knowledge through prior experience.

Next Steps

Consider one of our advanced courses, such as Excel Power Pivot and Power BI, or another from our course offerings.

 

Course Content 

• Formulas, review, and repetition
• Enhance your calculations with formatting
• Customize your own number formats
• Conditional formatting
• Links and consolidation
• Manage data in Excel
• Import data with Power Query
• Advanced sorting and filtering
• Manage pivot tables
• Introduction to Power Pivot (Power BI)
• Logical functions
• Lookup functions
• Statistical functions
• Dynamic functions (Excel 365)
• Practical tips and tricks

 

Certificate

Upon completing the course, you will receive a certificate.

Customization

Does your company need tailored Excel training? We customize the course schedule, location, and content entirely to your needs. Contact us for more information.

Testimonials from Previous Participants

Average rating: 4.8 out of 5
- "The instructor had answers to all possible questions and more. Incredibly knowledgeable and solution-oriented – but most importantly, passionate."
- "Educational and fun. Spoke in a way that was easy to understand – not 'Excel speak'."
- "100% professional, and I’ll immediately benefit from most of what I’ve learned!"
- "A warm and friendly atmosphere, combined with the instructor's humor and personal touch, creates a sense of security and a great foundation for learning. Excellent course structure."
- "The instructor made me love Excel, and I'm leaving with new confidence."