EXCEL ADVANCED

Our training center offers an innovative and fully practical Advanced Excel seminar, designed for professionals who want to unlock the full potential of Excel beyond the basics. We will not cover repetitive or already familiar topics like basic formulas or simple functions. Instead, the program focuses on essential and truly advanced techniques used in everyday professional settings.

 

What You Will Learn:

  • Advanced Lookup Functions: VLOOKUP, HLOOKUP, INDEX & MATCH – including comparisons, nested combinations, and troubleshooting.
  • Pivot Tables & Pivot Charts: Analyze and visualize large datasets with flexibility.
  • Financial Transaction Management: Functions like NPV, IRR, PMT, XNPV, and XIRR for investment and loan analysis.
  • Macros & Intro to VBA: Automate everyday tasks – record, edit, and create your own macro scripts.
  • CONCATENATE & TEXT Functions: Create dynamic texts, clean and convert data.
  • IF Statements & Nested Logic: Complex logical conditions using AND, OR, NOT, and IFS.
  • Data Validation & Conditional Formatting: Control and highlight data based on rules.
  • What-If Analysis & Scenario Manager: Build hypothetical scenarios and make better decisions.

Participant Benefits:

 

  • Acquire practical skills that can be applied immediately in the workplace.
  • Increase efficiency and process complex data faster.
  • Strengthen your professional profile with in-demand market skills.
  • Automate repetitive processes, saving time and resources.

Participants will receive a Certificate of Attendance to enhance their CV.

 

Seminar Structure:


The seminar is entirely hands-on, with numerous exercises, application examples, and case studies based on real-world business scenarios. Each module combines theory and application, allowing participants to immediately practice what they learn.

This seminar is ideal for business professionals, accountants, economists, data analysts, and individuals from all sectors who work with Excel regularly and wish to level up their skills.

 

Units

Date

15/05/25-19/06/25
Thursday

Time

09:00-14:15

Training Center

Online/ Ζοοm

Program Duration

30 ώρες

Program Cost

€150 after HRDA cost

Scroll to Top