Advanced Excel Course

Next Date: February 2026 | 1 Month | 35 Hours | Remote

Advanced Excel Course: master essential tools for data analysis and task automation. This course is designed for professionals who want to enhance their skills in data management and interpretation, using advanced Excel features to optimize processes and boost productivity.

This training is eligible for the Portuguese Digital Training Voucher.

What you will learn: In this course you’ll learn to use Excel as an advanced data analysis and visualisation tool.
You’ll master complex formulas, logical functions, like IF and VLOOKUP, and techniques for filtering, sorting, and error handling.
You’ll learn to connect Excel to external data sources, apply conditional formatting, and create interactive charts.
You’ll also explore pivot tables, pivot charts, slicers, and dashboards, building clear, insightful visual reports.
By the end, you’ll be able to turn raw data into smart, data-driven decisions.

Deep Focus on the Most Needed Expertise in Tech

Practical training with real-world exercises.

Open Doors to the Industry

Skills valued in management, finance, marketing and HR.

Deliver a Professional Project

Certification to make your CV stand out and increase career opportunities.

Who Is the Program For?

The Advanced Excel Course is ideal for those with basic knowledge who want to become specialists in data analysis and management.

Teachers

This unique program was built by a professional team made up of the leading experts in Development, with vast knowledge and experience in training, too.

Beatriz Duarte

Program Trainer

With 2 years as a professional consultant in data analysis and Business Intelligence and 7 years of prior experience in the banking sector, she has a strong foundation in data-driven decision-making.

At CapGemini, she developed tools and automated systems for business data management and analysis, enhancing operational efficiency.

Currently, she works at Cofidis, focusing on Data Governance, where she applies her expertise to ensure data accuracy, compliance, and effective data use across the organization.

Her background in both consulting and banking enables her to bridge technical and business needs, providing strategic insights and solutions.

Nuno Gil

Program Trainer

A graduate of Economics and in Computer Engineering, he held a Master of Information Management and BI, an Executive MBA, as well as owning several other certifications.
More than 30 years of work experience in the Bank, Insurance and Financial Services industries, with specialization in business analysis in the commercial scope, strategic management of people and information systems.
During his career, he served several roles, starting as Financial Market Operator and currently acting as Product Owner and Data Business Partner, in the Data and Intelligence at the Crédito Agrícola Bank.

Júlia Benikes

Career Advisor

Throughout the course, Júlia works closely with each student to guide their professional development. She helps participants refine their CVs and LinkedIn profiles, identifying how to highlight their key skills, and supports them in building effective strategies to enter the job market through practical, results-oriented sessions.

After the course, she plays a pivotal role in bridging students to employability, assisting them in preparing for interviews, developing professional networking and applying their new skills to real career opportunities.

With a personalised, people-centred approach, Júlia believes that every professional journey is unique and that success begins when talent meets the right opportunity.

Course Curriculum

Advanced Excel Skills

Take your Excel skills to the next level! In this module, you’ll learn how to turn spreadsheets into powerful data analysis tools. Master formulas, advanced functions, filters, VLOOKUP, and conditional formatting. Explore pivot tables, pivot charts, slicers, and build interactive dashboards. You’ll also connect Excel to external data sources and apply error handling techniques. A complete, hands-on approach to mastering Excel like a true data analyst.

Formulas
Basic and advanced filtering data
Sorting data
Common use build-in functions
Connectivity to outer data source
If functions
VLOOKUP
Error handling
What is analysis functionality
Conditional formatting
Charts and chart components
Pivot tables
Pivot charts
Slicers
Dashboarding

Final Project

Final presentation of trainees of a chosen dataset and technology

Related Programs and Courses

Data Analyst

Analyze huge sets of data using cutting edge tools to produce insights that would enable your company to grow and take action! A program for beginners and career changers with a passion for numbers.

RESKILLING

Data Manager

Become an expert in data management and analysis with our Data Manager Course, designed for those who want to master the most in-demand tools: Excel, SQL and Power BI.

UPSKILLING

Power BI

This course is designed for professionals who want to master one of the most in-demand tools in Business Intelligence and Data Visualization.

What do our students have to say?

Nathalia Gaiarim

ESG & Sustainability Consultant

“Fiz o curso de análise de dados na TechOf e, do primeiro contato até a apresentação do trabalho final, só tive boas experiências. No início, estava com dúvidas se fazia o curso e logo em seguida recebi uma chamada da professora Beatriz super disposta a tirar todas as minhas dúvidas. A metodologia é ágil, eficiente e completa. A professora é muito atenciosa, sempre disponível e consegue dar atenção para os alunos com diferentes ritmos de aprendizagem. O espaço é amplo e equipado com materiais de qualidade. Eu recomendo 100% a TechOf!”

José Madureira Pinto

Financial Business Consultant

“Encontro-me a concluir o curso de Analista de Dados na TechOf e só posso deixar elogios. A equipa é incrível, sempre disponíveis e atentos ao progresso de cada aluno e com feedback de experiências do “mundo real”. Mas talvez o maior elogio que posso fazer seja este: após 6 meses intensivos, com uma abordagem muito prática, vi colegas de curso — vindos das mais diversas áreas e sem experiência prévia em ferramentas como SQL, Python ou Power BI — a desenvolverem projetos com uma qualidade surpreendente, ao nível (ou até superior) de muitos profissionais com anos de experiência na área. Recomendo vivamente a quem procura uma formação sólida, prática e transformadora.”

João Teixeira

NOC Service Desk Analyst

“O verdadeiro desafio foi conseguir transpor as minhas ideias e conceitos para a prática. A TechOf ajudou-me imenso, proporcionando-me a liberdade de errar e corrigir ao longo do caminho. Recebi orientações valiosas, como: ‘Aqui, poderias aprofundar mais este ponto ou melhorar nesta área’. Isso foi crucial, pois muitas vezes falta-nos essa abertura para receber feedback sincero, algo que nem sempre encontramos. A abordagem transparente e construtiva da equipa fez toda a diferença”

Caroline Brockveld

Civil Engineer

My goal in this course was to learn how to use tools, manipulate data, and derive insights from it. What I gained, however, was much more than that. I had the privilege of learning from an amazing mentor, Beatriz Duarte, who encouraged us to question and analyze data from different perspectives. I also had the opportunity to connect with colleagues from diverse backgrounds, whose insights I will carry with me. I am deeply grateful for the knowledge shared by the TechOf team. I’m already applying what I’ve learned in my daily work and am eager to keep improving my results through data-driven decisions.

Sofia Carvalho

Insurance Specialist at Tesla

“Escolhi a TechOf porque foi a única escola que encontrei que oferecia as ferramentas de SQL, Python, e Power BI, focadas especificamente em análise de dados. A praticidade do curso, com uma forte aposta em exercícios e projetos, foi crucial para a sua aprendizagem. Adoro analisar dados e queria muito aprender estas técnicas”. “Agora, em vez de extrair grandes bases de dados em Excel, que muitas vezes iam abaixo, uso SQL para extrair exatamente a informação que preciso, o que aumentou a eficiência, o próximo passo é usar Power BI para facilitar a comunicação com os stakeholders”

Hugo Boavista

Data Analyst | Civil Engineer

“Na área em que eu estava, Engenharia Civil, estava num beco sem saída. Comecei a procurar cursos no mundo das tecnologias e achei que o curso de Data Analyst era o ideal para mim, dado que sou mais analítico. Foi um gosto trabalhar aqui durante seis meses e sair com perspetivas novas para a minha vida. Saio com um sentimento de dever cumprido”

Tiago Jesus

Call Center Manager

“Foi muito desafiante, sem dúvida, porque não tinha qualquer base de programação. No entanto, os conteúdos que nos deram foram straight to the point. Começámos com SQL, Microsoft Excel avançado, Power BI e terminámos com o Python. Foi muito desafiante. No entanto, os conteúdos que nos deram foram eficazes, praticámos bastante e também ajudou a nossa professora, Beatriz Duarte, ser excecional e prática. Consigo criar, analisar e acompanhar toda a informação da minha equipa, simplesmente porque adiciono informação e a programação automaticamente dá-me tudo o que preciso, porque a configurei assim. Facilita-me imenso a vida. O Power BI foi life changing. Se encontraram a TechOf, e se estão com dúvidas, acho que devem dedicar tempo e visitar a escola, onde todos são muito prestáveis. Não tenham dúvidas em inscrever-se na TechOf, porque acho que é o início de muitas carreiras de sucesso”

Patrícia Tavanez

Lab Technician

“Sempre gostei da parte de análise e tratamento de dados, porque é uma área que, ao contrário da Química em laboratório, não traz surpresas desagradáveis no final de um dia de trabalho. No início, a programação assustava-me, mas acabei por gostar muito. Achei que foi uma oportunidade fantástica para explorar o meu lado mais criativo e pensar fora da caixa, Aproveitem toda a disponibilidade que a TechOf oferece e não tenham medo de explorar coisas diferentes”

Diana Levytska

Export Sales Manager

“Recomendo vivamente. Superou todas as expectativas! Um curso que prepara para o mercado de trabalho, com conteúdos atualizadíssimos e uma abordagem prática que faz toda a diferença. O suporte da professora e a qualidade do material foram fundamentais para o sucesso deste curso.”

WhatsApp Image 2025-01-29 at 18.21.54_3c02d8c4

Marília Cremaschi

Business Operations Specialist

A escola é excelente. Curso, equipa, estrutura… tudo fantástico! Fiz o curso de Data Analyst e terminei o curso muito satisfeita com todo o desenvolvimento que me foi promovido.”

FAQs

Will I receive a certificate?

Yes! All graduates who have successfully completed the program will receive a certificate.

You will also receive the SIGO Certificate, as our training is DGERT Certified.

Use you new course certificate to demonstrate skills to potential employers, along with their LinkedIn networks.

Our content is certified also by IoA – Institute of Analytics, the world’s leading professional body for Analytics and Data Science, promoting the continuous development of skills and networking opportunities in the field.

Can I apply to Cheque-Formação + Digital?

Yes! All of our courses are aligned with Cheque-Formação + Digital, feel free to ask us anything related with this 750 Euros fund from the state.

Are the classes online or presential?

This course is only online. All classes are recorded and securely stored for a period of 3 months, so you never have to worry about missing a session, but remember that you need to attend 80% of the classes to have a certificate.

This approach allows your learning to continue uninterrupted, with live, interactive sessions led by expert trainers.

Additionally, learning materials and self-study topics, are available on-demand. Access these resources anytime, from anywhere, to reinforce your knowledge and stay on track with your studies.

What is the application process like?

Register your interest below to be contacted by one of our Career Consultants. Book an in-person or online consultation session to validate the desired course content, available classes and schedules, and gain access to our assessment test.

What if I don’t have the required skills prior to this program?

Our program is designed to bridge the gap for those without a programming background, providing the foundational skills you need to succeed.

This ensures you’re prepared not just to excel in the program, but also to thrive in your future career.