The goal of this course is to provide you with the knowledge required to use more advanced formulas and work with various tools to analyze 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 emphasizes hands-on experience, with a series of instructor guided and independent tasks that mirror real workplace challenges. Attendees will have the option to apply learning to realistic scenarios from one of seven sectors: Retail, Education, Local Government, Legal, Policing, Healthcare, or Finance.

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.

Target audience

This course is designed for existing Excel users who want to build confidence with more advanced spreadsheet tools and techniques. It is suitable for delegates who already understand how to enter data and create basic formulas, and now need to work more efficiently with functions, tables, data lists, charts, conditional formatting, and analytical features in Excel.

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

What You Will Learn

Delegates will learn how to:

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.

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
Checkboxes*
Advanced sorting
The FILTER function*

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**
Analyze data with sparklines

Module 6: Conditional formatting

Applying and managing conditional formatting
Creating custom conditional formatting
Sorting and filtering by color

Exams and assessments

There is no formal exam or certification associated with this course. Learner progress is assessed through instructor-guided activities, practical exercises, and independent tasks completed during the course. These activities allow delegates to apply the techniques covered and check their understanding in realistic Excel scenarios.

Hands-on learning

This course includes hands-on practice throughout, with a mix of trainer-led demonstrations, guided exercises, and independent tasks. Delegates will work with realistic Excel scenarios and can apply their learning to one of seven sector-based contexts: Retail, Education, Local Government, Legal, Policing, Healthcare, or Finance.

Why Choose Us

Experience Microsoft Excel Intermediate in Greece 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 Greece or anywhere else in the world, or arrange a dedicated online training program for your organization.

Experience Microsoft Excel Intermediate through face-to-face Classroom Based training in Greece. Training can be delivered as a Public course open to individual delegates or as a dedicated Private / In-house class 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 in Greece 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: Arrange the training in Greece or at another preferred location worldwide. Bilginç IT Academy trainers can travel to your selected location to deliver the dedicated training program.

D. A. - Specialist - R&D / Arçelik

It was a useful training.

T. K. - GKK sorumlusu / Arçelik

Overall, the training was good and appropriate. Our instructor was very attentive. I also think the examples and exercises provided were sufficient.

m. a. - ArGe Merkezi Koordinatörü / Arçelik

The training was understandable. The trainer engaged the participants' interest in the training.

D. C. K. - HR / Arçelik

The instructor delivered the training in a very detailed and repetitive manner. Thank you.

M. B. - İdari İşler - Arçelik

Rated the training 5 stars.

F. S. T. - Arge Donanım Tasarım Mühendisi - Arçelik

Rated the training 5 stars.

B. K. - Bitmiş Ürün Depo - Arçelik

Rated the training 5 stars.

E. T. - Planlama - Arçelik

Rated the training 5 stars.

A. E. - Mali İşler Sorumlusu - Arçelik

Rated the training 5 stars.

R. V. - Manisa çamaşır mak. Arge Tasarım ve Uygulama Yönetici - Arçelik

Rated the training 5 stars.

S. A. - Mühendis - Arçelik

Rated the training 5 stars.

S. Ö. - ÜMY teknikeri - Arçelik

Rated the training 5 stars.

E. G. - Eğitim Gelişim Yardımcı Uzman - Arçelik

Rated the training 5 stars.

B. H. - İnsan Kaynakları Uzman Yardımcısı - Arçelik

Rated the training 5 stars.

E. C. C. - Counsel - ACTECON

Rated the training 5 stars.

T. Ş. - Danışman - ICBC Turkey

Rated the training 5 stars.

G. C. - Destek Merkezi Yönetici Yardımcısı - ICBC Turkey

Rated the training 5 stars.

B. B. - Veri Merkezi Yöneticisi - ICBC Turkey

Rated the training 5 stars.

Why have you chosen us?

I have attended a training from Bilginc IT Academy before and I was satisfied.

I have attended a training from a different provider and it was not helpful.

Other

How many employees do you have in your IT department?

0 – 50

50 – 250

250 – 1000

1000+

Microsoft Excel Intermediate Training in Greece

Prerequisites

Target audience

What You Will Learn

Training Outline

Exams and assessments

Hands-on learning

Why Choose Us

Microsoft Excel Intermediate Training Course in Greece Schedule

Blog posts related to Microsoft Excel Intermediate Training Course in Greece

Microsoft Excel Intermediate Training in Greece

Prerequisites

Target audience

What You Will Learn

Training Outline

Exams and assessments

Hands-on learning

Why Choose Us

Online Instructor-Led Training

Classroom Based Training

Onsite Training

Training Reviews

Microsoft Excel Intermediate Training Course in Greece Schedule

Blog posts related to Microsoft Excel Intermediate Training Course in Greece

Power BI or Excel? Let the Data Duel Begin!