Download Training Content

Microsoft Excel Intermediate Training helps users with basic Excel experience develop stronger skills in formulas, data management, analysis, and visualization.

Through this course, you will be able to:

  • Perform calculations more efficiently using advanced formulas and Excel functions.

  • Organize and manage data lists with sorting, filtering, and Excel tables.

  • Present information clearly through charts, maps, and sparklines.

  • Highlight important information and simplify data analysis using conditional formatting.


This course is designed for Excel users who want to expand their knowledge of formulas and learn how to organize, manage, and analyze spreadsheet data more effectively. Participants will develop practical skills in advanced sorting and filtering, conditional formatting, Excel tables, and data visualization tools.

The training combines instructor-led exercises with independent activities to reinforce learning through practical experience. Participants will work with scenarios inspired by real workplace challenges and can choose examples relevant to one of seven sectors: Retail, Education, Local Government, Legal, Policing, Healthcare, or Finance.


For corporate groups, we can organize this training as an on-site private group.
HAVELSAN
ASELSAN
PepsiCo Türkiye
JTI TÜTÜN ÜRÜNLERİ SANAYİ A.Ş.
ING Bank
DHL
MASTERCARD
Huawei
TotalEnergies
Mercedes-Benz Türk A.Ş.
Goodyear
FORD OTOMOTIV SANAYI A.S.
3M COMPANY
Schneider Electric
Central Bank of Azerbaijan
BP Petrolleri
Procter & Gamble (P&G)
Qatar Foundation
Bank Of China
GlaxoSmithKline (GSK)
MORGAN STANLEY & CO Inc
Novo Nordisk
DEUTSCHE BANK
Azerbaycan Cumhuriyeti Emek ve Ahalinin Sosyal Güvenliği Bakanlığı
ACCENTURE

Prerequisites

This course is intended for users who are already familiar with the essential features of Microsoft Excel and want to develop their skills further.

Participants should have experience with data entry, basic formulas, and commonly used Excel functions such as SUM and AVERAGE.

Who Should Attend

Microsoft Excel Intermediate Training is suitable for existing Excel users who want to improve their efficiency and confidence when working with more advanced spreadsheet features.

It is particularly beneficial for professionals looking to strengthen their skills in formulas, functions, tables, data lists, charts, conditional formatting, and Excel analysis tools.

What You Will Learn

By the end of this course, you will be able to:

  • Use absolute and mixed cell references, named ranges, and links between worksheets and workbooks.

  • Perform more advanced calculations with criteria-based, logical, lookup, and dynamic array functions.

  • Manage data lists more effectively using advanced sorting, filtering, and Flash Fill.

  • Create and maintain Excel tables, including calculations and total rows.

  • Present and analyze information using charts, geographic maps, and sparklines.

  • Apply conditional formatting to highlight important data and perform color-based sorting and filtering.

  • Use the Excel tools and techniques covered in the course to handle realistic workplace tasks more efficiently.

Availability of certain features may depend on the version of Excel being used.

Infographic creation depends on the availability of the relevant Excel add-ins.

Training Outline

Module 1: Formula Tools and Techniques

  • Using the Quick Analysis tool

  • Working with absolute and mixed cell references

  • Creating and using named ranges

  • Establishing links between worksheets

  • Linking data to external Excel workbooks

Module 2: Commonly Used Excel Functions

  • Understanding how Excel functions work

  • Applying criteria-based functions

  • Using logical functions for conditional calculations

  • Retrieving and matching data with lookup and reference functions

  • Working with dynamic array functions

Module 3: Working with Data Lists

  • Using Flash Fill to complete data patterns

  • Working with checkboxes*

  • Performing advanced sorting operations

  • Filtering data with the FILTER function*

Module 4: Mastering Excel Tables

  • Exploring the key features of Excel tables

  • Creating, organizing, and managing tables

  • Performing calculations and using total rows in tables

  • Applying and customizing table formatting

  • Using additional Excel table tools

Module 5: Data Visualization

  • Understanding the fundamentals of Excel charts

  • Creating charts for different types of data

  • Resizing and repositioning charts

  • Editing and managing existing charts

  • Adding and modifying chart elements

  • Customizing chart appearance and formatting

  • Working with chart templates

  • Creating maps from geographic data

  • Designing infographics using Excel add-ins

  • Analyzing trends with sparklines

Module 6: Conditional Formatting

  • Applying and managing conditional formatting rules

  • Creating custom conditional formatting rules

  • Sorting and filtering by cell color

Why Choose Us

Leading UK-based global training provider since 1995.

Experience Microsoft Excel Intermediate through Bilginç IT Academy's live and interactive virtual classroom environment. Join a Public course as an individual delegate or arrange a dedicated Private / In-house online training program exclusively for your organization.

  • Delivery Method: Online Instructor-Led
  • Participation Model: Public / Private (In-house)
  • Live and Interactive Training: Connect with your instructor in real time and actively participate through discussions, Q&A sessions, practical exercises, and group activities.
  • Flexible Participation: Join the training from your home, office, or any location with a suitable internet connection.
  • Expert Trainer Network: Learn from experienced trainers with strong industry backgrounds and practical field expertise.
  • Over 30 Years of Training Expertise: Benefit from Bilginç IT Academy's professional training experience since 1995.
  • Worldwide Access: Join our live virtual classrooms from anywhere in the world or arrange a dedicated online training program for your organization.

Experience Microsoft Excel Intermediate in a professional face-to-face classroom environment. Classroom Based training can be delivered as a Public course open to individual delegates or as a dedicated Private / In-house class exclusively for your organization.

  • Delivery Method: Classroom Based
  • Participation Model: Public / Private (In-house)
  • Face-to-Face Learning: Interact directly with your instructor and fellow delegates in an engaging classroom environment.
  • Experienced Trainers: Learn from specialists with extensive industry experience and practical real-world knowledge.
  • Professional Training Environment: Attend training in comfortable, well-equipped classrooms designed to support effective learning.
  • Practical Learning: Depending on the course, reinforce your knowledge through hands-on exercises, scenarios, case studies, and instructor-led activities.

Arrange Microsoft Excel Intermediate as a dedicated Onsite training program for your organization. Bilginç IT Academy trainers can deliver the training at your office or another location of your choice, with the program planned around your team's requirements and business objectives.

  • Delivery Method: Onsite
  • Participation Model: Private (In-house)
  • Training at Your Preferred Location: Organize the training at your company's office or another location selected by your organization.
  • Tailored Course Content: Adapt the training program to your projects, team structure, existing skill levels, and specific business requirements.
  • Team-Focused Learning: Develop your team around a shared knowledge base while strengthening internal collaboration and knowledge transfer.
  • Flexible Scheduling: Plan the training dates, location, and program according to your organization's operational requirements.
  • Worldwide Onsite Delivery: Bilginç IT Academy trainers can travel internationally to deliver dedicated training programs at your preferred location.

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