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. Contact Us!

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 through Bilginç IT Academy's live and interactive virtual classroom environment, accessible from your home, office, or any location. Connect with expert trainers in real time and bring the energy of classroom learning into the digital experience.

Live Instructor-Led Sessions: Join scheduled training sessions with your instructor and fellow delegates in real time.
Interactive Learning Experience: Take part in discussions, practical exercises, group activities, and Q&A sessions throughout the course.
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 long-standing experience in delivering professional training since 1995.
Flexible and Scalable Delivery: Access live virtual classrooms worldwide with flexible planning options for individual and corporate training needs.

Experience Microsoft Excel Advanced in a focused classroom environment designed for high engagement and effective learning. Bilginç IT Academy's carefully selected training venues provide a professional setting where delegates can interact directly with expert trainers and peers.

Experienced Trainers: Learn from specialists with extensive field experience and real-world knowledge.
Professional Training Venues: Attend courses in comfortable, well-equipped classrooms designed to support effective learning.
Focused Classroom Experience: Benefit from limited class sizes that encourage discussion, interaction, and personalized support.
Quality-Driven Learning: Develop practical skills through structured, up-to-date, and professionally designed training content.

Meet your team's training needs with Bilginç IT Academy's onsite Microsoft Excel Advanced solution, delivered at your office or preferred location. Align your team's development with your business goals through a training experience tailored to your organization.

Tailored Course Content: Adapt the training program to your organization's projects, team structure, and specific business requirements.
Time and Cost Efficiency: Reduce travel, accommodation, and operational costs while maximizing the value of your training investment.
Team-Focused Learning: Help your employees develop around the same knowledge base and strengthen collaboration across your organization.
Simplified Planning and Tracking: Manage the training process, participant development, and organizational requirements with greater control.

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