Microsoft Excel Intermediate Training in Singapore

  • 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 Singapore. 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 Singapore, with flexible scheduling to meet your professional needs.

Immerse yourself in our most sought-after learning style for Microsoft Excel Intermediate Training in Singapore. Our hand-picked classroom venues in Singapore 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 Intermediate Training in Singapore. 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 Singapore 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 April 2026 (2 Days)
Singapore €1,490 +VAT
24 April 2026 (2 Days)
Singapore €1,490 +VAT
27 April 2026 (2 Days)
Singapore €1,490 +VAT
11 May 2026 (2 Days)
Singapore €1,490 +VAT
26 May 2026 (2 Days)
Singapore €1,490 +VAT
14 June 2026 (2 Days)
Singapore €1,490 +VAT
28 June 2026 (2 Days)
Singapore €1,490 +VAT
08 July 2026 (2 Days)
Singapore €1,490 +VAT

Singapore is widely recognized as Asia's leading 'Smart Nation,' serving as a global financial and technology powerhouse with unparalleled infrastructure for IT training and research. Strategically located in the heart of Southeast Asia, it acts as a magnet for international tech talent and investment, supported by the research prestige of the National University of Singapore (NUS) and Nanyang Technological University (NTU). The city-state is a world leader in Cybersecurity, Blockchain, and Data Science, fostering an environment where digital transformation is integrated into every level of society. Our training programs in Singapore are built for a workforce that demands the highest technical standards and strategic insight. We offer advanced certifications in AI, Cloud Engineering, and Digital Governance, ensuring that Singapore continues to set the global benchmark for technological sophistication and excellence in the modern digital era.

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