Microsoft Excel Advanced Training in Zurich

  • Learn via: Online Instructor-Led / Classroom Based / Onsite
  • Duration: 2 Days
  • Price: From €1,657+VAT
  • Upcoming Date:
  • UK Based Global Training Provider

In this course, you will extend your knowledge into some of the more specialised and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets such as PivotTables, and importing and cleaning data.

The course emphasises hands-on experience, with a series of self-guided exercises integrated into the training.

We can organize this training at your preferred date and location. Contact Us!

Prerequisites

  • Create, edit, and format spreadsheets
  • Navigate within worksheets and books
  • Use Insert Function to create built-in functions
  • Work with absolute references
  • Create named ranges
  • Create Tables within Excel
  • Sort and filter data

What You Will Learn

  • Use macros to automate repetitive tasks
  • Setup workbooks to collaborate with other users
  • Create and build PivotTables to analyse data
  • Write array and advanced lookup functions
  • Use ‘what-if’ analysis tools
  • Use data validation
  • Import external data into Excel workbooks

Training Outline

Module 1: Creating macros

  • Introducing macros
  • Creating macros
  • Relative and absolute macros
  • Running and editing a macro
  • Assigning shortcuts
  • Macro security

Module 2: Collaborating with others

  • Protecting data, workbook structure and files
  • Checking for collaboration issues
  • Marking workbooks as final

Module 3: PivotTables

  • What is a PivotTable?
  • Creating and modifying PivotTables
  • Calculations in PivotTables
  • Grouping fields
  • Slicers and Timelines
  • Creating PivotCharts
  • PivotTables and related sources

Module 4: Array formulas

  • What is an array?
  • Array formulas
  • Array functions
  • Single and multiple cell arrays

Module 5: Further lookup and reference functions

  • VLOOKUP and HLOOKUP
  • GETPIVOTDATA
  • MATCH and INDEX
  • XLOOKUP (Excel 365 only)

Module 6: Analysing data

  • Input data tables
  • Worksheet scenarios
  • Goal Seek
  • Consolidating data
  • Linking to external workbooks

Module 7: Data validation

  • Setting up data validation
  • Message prompts and alerts
  • Conditional data validation
  • Data validation errors

Module 8: Importing data

  • Importing delimited files
  • Importing data with a web query
  • Refreshing data

Why Choose Us

Experience live, interactive learning from the comfort of your home or office with Bilginç IT Academy's Online Instructor-Led Microsoft Excel Advanced Training in Zurich. Engage directly with expert trainers in a virtual environment that mirrors the energy and schedule of a physical classroom.

  • Live Sessions: Join scheduled classes with a live instructor and other delegates in real-time.
  • Interactive Experience: Engage in group activities, hands-on labs, and direct Q&A sessions with your trainer and peers.
  • Global Expert Trainers: Learn from a handpicked global pool of expert trainers with deep industry experience.
  • Proven Expertise: Benefit from over 30 years of quality training experience, equipping you with lasting skills for success.
  • Scalable Delivery: Accessible worldwide, including Zurich, with flexible scheduling to meet your professional needs.

Immerse yourself in our most sought-after learning style for Microsoft Excel Advanced Training in Zurich. Our hand-picked classroom venues in Zurich offer an invaluable human touch, providing a focused and interactive environment for professional growth.

  • Highly Experienced Trainers: Boost your skills with trainers boasting 10-20+ years of real-world experience.
  • State-of-the-Art Venues: Learn in high-standard facilities designed to ensure a comfortable and distraction-free experience.
  • Small Class Sizes: Our limited class sizes foster meaningful discussions and a personalized learning journey.
  • Best Value: Achieve your certification with high-quality training and competitive pricing.

Streamline your organization's training requirements with Bilginç IT Academy’s Onsite Microsoft Excel Advanced Training in Zurich. Experience expert-led learning at your own business premises, tailored to your corporate goals.

  • Tailored Learning Experience: Customize the training content to fit your unique business projects or specific technical needs.
  • Maximize Training Budget: Eliminate travel and accommodation costs, focusing your entire budget on the training itself.
  • Team Building Opportunity: Enhance team bonding and collaboration through shared learning experiences in your workspace.
  • Progress Monitoring: Track and evaluate your employees' progression and performance with relative ease and direct oversight.



Contact us for more detail about our trainings and for all other enquiries!

Microsoft Excel Advanced Training Course in Zurich Schedule

Join our public courses in our Zurich facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

We can organize this training at your preferred date and location.
20 Mai 2026 (2 Days)
Zurich, Zurih, Geneva, Cenevre, Basel
€1,657 +VAT
26 Mai 2026 (2 Days)
Zurich, Zurih, Geneva, Cenevre, Basel
€1,657 +VAT
05 Juni 2026 (2 Days)
Zurich, Zurih, Geneva, Cenevre, Basel
€1,657 +VAT
21 Juni 2026 (2 Days)
Zurich, Zurih, Geneva, Cenevre, Basel
€1,657 +VAT
13 Juli 2026 (2 Days)
Zurich, Zurih, Geneva, Cenevre, Basel
€1,657 +VAT
19 Juli 2026 (2 Days)
Zurich, Zurih, Geneva, Cenevre, Basel
€1,657 +VAT
26 August 2026 (2 Days)
Zurich, Zurih, Geneva, Cenevre, Basel
€1,657 +VAT
02 September 2026 (2 Days)
Zurich, Zurih, Geneva, Cenevre, Basel
€1,657 +VAT

Switzerland is globally recognized as the gold standard for fintech, precision engineering, and data privacy. Zurich and Geneva are not only financial capitals but also critical hubs for blockchain innovation and high-security IT infrastructure. Home to ETH Zurich, one of the world's leading technical universities, the Swiss ecosystem attracts the brightest minds in cryptography and systems engineering. Our IT training services in Switzerland are designed for those who operate in high-stakes environments where accuracy and security are paramount. We offer specialized courses that cover the full spectrum of modern technology, from secure cloud management to advanced data analytics, ensuring that professionals in the Swiss confederation maintain their competitive edge in a digital-first world.

By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.