This course is designed for existing Microsoft Excel users who want to extend their knowledge and make effective use of Excel's more specialised and advanced capabilities.

Throughout the course, participants learn how to automate frequently repeated activities, apply advanced analysis techniques to more complex data sets, use PivotTables to explore and summarise information, and import and prepare data from external sources.

The course has a strong practical focus. A range of self-guided exercises is incorporated throughout the training, giving participants opportunities to apply and reinforce the techniques covered.

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

Prerequisites

This course is intended for existing Excel users who are ready to develop their skills to a more advanced level.

Before attending, participants should be comfortable with the following:

Creating, editing, and formatting spreadsheets,
Navigating worksheets and workbooks,
Using Insert Function to create built-in Excel functions,
Working with Absolute References,
Creating Named Ranges,
Creating and working with Excel Tables,
Sorting and filtering data.

What You Will Learn

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

Import data into Excel from external sources,
Use Power Query to import and prepare data,
Apply Data Validation and protection features,
Create and configure PivotTables to analyse data,
Enhance analysis with PivotCharts, Slicers, and Timelines,
Create and work with Dynamic Array Formulas,
Use Formula Auditing tools to investigate formulas and identify errors,
Automate repetitive Excel activities by creating and using Macros.

Training Outline

Module 1 – Importing and Exporting Data

Importing data from a Delimited Text File
Importing and preparing data with Power Query (Excel 2016+ and Microsoft 365)
Exporting data to a Delimited Text File

Module 2 – Collaboration and Data Controls

Using Data Validation to control data entry
Protecting cells
Protecting Workbook structure
Restricting access to a document

Module 3 – Analysing Data with PivotTables

Understanding PivotTables and their purpose
Creating PivotTables
Modifying and configuring existing PivotTables
Performing calculations within PivotTables
Grouping fields
Working with Slicers
Filtering date-based information with Timelines
Creating PivotCharts
Using the GETPIVOTDATA function
Using Analyze Data / Ideas (Microsoft 365)

Module 4 – Dynamic Array Formulas

Introduction to arrays
Working with legacy Array Formulas and functions
Understanding Dynamic Array Formulas
Working with Dynamic Array Functions

Module 5 – Formula Auditing Tools

Tracing Precedents and Dependents
Tracing and investigating formula errors
Displaying formulas within a worksheet
Using the Watch Window
Evaluating formulas step by step

Module 6 – Creating Macros and Automating Tasks

Introduction to Macros
Creating Macros
Understanding Relative and Absolute Macros
Running a Macro
Editing existing Macros
Assigning keyboard shortcuts
Understanding and managing Macro Security

Why Choose Us

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

Experience Microsoft Excel Advanced through face-to-face Classroom Based training in France. 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 Advanced in France 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 France or at another preferred location worldwide. Bilginç IT Academy trainers can travel to your selected location to deliver the dedicated training program.

M. Ç. - MALİ İŞLER EKİP LİDERİ / Turkcell

We would like to thank the instructor very much; their interest, attention, knowledge, and cheerful demeanor, even though it was the weekend, made us very happy.

S. S. - MALİ İŞLER UZMANI / Turkcell

1- A necessary training to fill in our gaps. 2- A training that has significant effects on our professional lives. 3- A training that can help us learn many factors we didn't know about in Excel to a better degree.

A. H. - MA satış deneyimi / Turkcell

The training was very smooth, thank you.

E. G. - Satış / Turkcell

The instructor's demeanor, energy, and skill level were top-notch. I would especially like to thank them.

E. G. - Sales Experience / Turkcell

The instructor explained the training very well and in great detail. Thank you.

A. K. - Yönetici Direktör / SWAROVSKI

Our instructor is, first and foremost, knowledgeable in their subject matter and able to convey their information accurately. Although our training was a one-day, compressed session, they very effectively identified the key topics and points to focus on. They skillfully balanced theory and practice with practical applications. It's crucial that they love what they do. They have high energy. As a team, we would like to receive training from them again.

B. Y. - İdari İşler Personeli / BEDAŞ | Boğaziçi Elektrik Dağıtım A.Ş

Our instructor was truly excellent in their training; I'd like to congratulate them. I didn't encounter any problems during the training process. Thank you for your support.

M. A. T. - İşletme ve Bakım Mühendisi / BEDAŞ | Boğaziçi Elektrik Dağıtım A.Ş

It was prepared in a format we could use in our training work. The trainer was a highly competent educator.

P. T. - Dijital Tarım Dönüşüm ve Tarımsal İnovasyon Lideri / Tekfen Holding

The instructor delivered a truly successful and effective training. We thank him/her very much. We hope to meet again in other training sessions.

G. K. - İnsan Kaynakları Uzmanı / D&R

Thank you for your interest and approach to your work. I hope to see you again.

I. B. - Ofis ve Seyahat Koordinatörü / DIALOG SEMICONDUCTOR AS

I was very pleased with the instructor. Thank you.

M. G. - EKSİK TÜKETİM VERİ ANALİZ PERSONELİ / BEDAŞ | Boğaziçi Elektrik Dağıtım A.Ş

Your instructor is very expert in their field.

S. A. - KAÇAK TAHAKKUK VERİ ANALİZ PERSONELİ / BEDAŞ | Boğaziçi Elektrik Dağıtım A.Ş

It was great!

M. P. G. - Yasal takip uzmani / BEDAŞ | Boğaziçi Elektrik Dağıtım A.Ş

Everything was great. 😊

B. D. - DAVA VE İCRA TAKİP UZMANI / BEDAŞ | Boğaziçi Elektrik Dağıtım A.Ş

It was a great and productive training session. It was the first training I've attended without getting bored :)

S. G. - Channel Sales Manager / Turkcell

It was a very interactive, enjoyable, and high-energy training session. Thank you for everything...

T. İ. - Satış Yöneticisi / Turkcell

I think this was the most productive and well-explained Excel training I've ever attended. It was very helpful. Furthermore, our instructor stood out with their knowledge and teaching style.

Ş. K. A. - SATIŞ YÖNETİCİSİ / Turkcell

I am completely satisfied; the information I gained will add value to my professional life. Thank you.

C. Ü. - Yazılım Geliştirme / Netaş

It was definitely a very helpful training. Thank you.

C. D. - İnsan kaynakları / BEDAŞ | Boğaziçi Elektrik Dağıtım A.Ş

This has been very helpful in using Excel more efficiently in the office, thank you.

T. K. - TIM Akademi Eğitmeni / Turkcell

Our instructor was very well-equipped and knowledgeable, so he explained all the topics clearly and concisely and had us practice. The topics covered were directly applicable to our work and reports, making our jobs easier. It was a training that allowed me to review topics I already knew and add to my knowledge in areas I didn't know.

N. İ. - SATIŞ YÖNETİCİ / Turkcell

It was a very valuable training. Many thanks to both Bilginç IT Academy and the instructor. I would also like to take Access training from him, as I believe it will be very beneficial for our work.

L. A. - Satış Yöneticisi / Turkcell

The instructor delivered the training in a very successful and informative manner. It was a valuable training course that I've taken recently and will be seriously beneficial to my work.

H. E. B. - Satış töneticisi / Turkcell

Thanks

Ü. A. - Satış Yöneticisi / Turkcell

Many thanks to the instructor for their extensive knowledge and teaching style.

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 Advanced Training in France

Prerequisites

What You Will Learn

Training Outline

Module 1 – Importing and Exporting Data

Module 2 – Collaboration and Data Controls

Module 3 – Analysing Data with PivotTables

Module 4 – Dynamic Array Formulas

Module 5 – Formula Auditing Tools

Module 6 – Creating Macros and Automating Tasks

Why Choose Us

Microsoft Excel Advanced Training Course in France Schedule

Microsoft Excel Advanced Training in France

Prerequisites

What You Will Learn

Training Outline

Module 1 – Importing and Exporting Data

Module 2 – Collaboration and Data Controls

Module 3 – Analysing Data with PivotTables

Module 4 – Dynamic Array Formulas

Module 5 – Formula Auditing Tools

Module 6 – Creating Macros and Automating Tasks

Why Choose Us

Online Instructor-Led Training

Classroom Based Training

Onsite Training

Training Reviews

Microsoft Excel Advanced Training Course in France Schedule