Microsoft Excel Intermediate Training in Global

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

The goal of this course is to provide you with the knowledge required to use more advanced formulas and work with various tools to analyse data in spreadsheets, such as advanced sorting and filtering, and conditional formatting. You will also organise table data and present data in different visuals, such as charts and maps.

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

This course is aimed at existing Excel users who need to further their knowledge. Delegates are assumed to have experience of entering data and writing basic formulas, including common functions such as SUM and AVERAGE.

What You Will Learn

  • Use formula-related tools and techniques.
  • Work with popular Excel functions.
  • Use advanced data list features and Excel tables.
  • Create visuals representing data, using charts and sparklines.
  • Apply and use conditional formatting.
  • Utilise the capabilities of dynamic arrays to improve your formula writing

Training Outline

Module 1: Formula tools and techniques

  • Quick analysis.
  • Absolute and mixed referencing.
  • Working with range names.
  • Linking to other worksheets.
  • Linking to external workbooks.

Module 2: Popular Excel functions

  • Understanding functions.
  • Criteria-based functions.
  • Logical functions.
  • Lookup and reference functions.
  • Dynamic array functions.

Module 3: Working with data lists

  • Flash fill.
  • Advanced sorting.
  • Summarising with subtotals.
  • Advanced filters.

Module 4: Mastering Excel tables

  • Introducing tables.
  • Creating and managing tables.
  • Calculation and totals in tables.
  • Formatting a table.
  • Further table tools.

Module 5: Creating Visuals

  • Understanding charts
  • Creating a chart
  • Resizing and moving
  • Managing a chart
  • Working with chart elements
  • Formatting charts
  • Working with chart templates
  • Creating maps from Geographic data
  • Creating Infographics with Excel add-ins
  • Analyse data with sparklines

Module 6: Conditional formatting

  • Applying and managing conditional formatting.
  • Creating custom conditional formatting.
  • Sorting and filtering by colour.

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 Intermediate Training in Global. 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 Global, with flexible scheduling to meet your professional needs.

Immerse yourself in our most sought-after learning style for Microsoft Excel Intermediate Training in Global. Our hand-picked classroom venues in Global 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 Bilginc IT Academy’s Onsite Microsoft Excel Intermediate Training in Global. 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!

Available Training Dates

Join our public courses in our Global 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.
07 апреля 2026 (2 Days)
Online Training / Remote Learning €1,490 +VAT
24 апреля 2026 (2 Days)
Online Training / Remote Learning €1,490 +VAT
27 апреля 2026 (2 Days)
Online Training / Remote Learning €1,490 +VAT
11 мая 2026 (2 Days)
Online Training / Remote Learning €1,490 +VAT
26 мая 2026 (2 Days)
Online Training / Remote Learning €1,490 +VAT
14 июня 2026 (2 Days)
Online Training / Remote Learning €1,490 +VAT
28 июня 2026 (2 Days)
Online Training / Remote Learning €1,490 +VAT
08 июля 2026 (2 Days)
Online Training / Remote Learning €1,490 +VAT

Our IT training and professional development services reach a global audience, transcending geographical boundaries through advanced digital learning platforms and strategic international hubs. We specialize in delivering world-class curriculum across continents, ensuring that no matter where you are located, you have access to the latest industry certifications and technical expertise. By partnering with global technology leaders and academic institutions, we provide a unified learning experience that meets the demands of a diverse, international workforce. Our commitment to global excellence ensures that professionals in every time zone can master the digital skills required to lead, innovate, and thrive in the ever-evolving global technology landscape.

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