Scratch the image to get a discount on your course. You'll be able to apply the coupon at checkout.

5.0 /5
(19)

66
Bienvenidos al curso de Excel nivel 3
Tercera parte del itinerario de Excel
Introducción al curso
Cómo sacarle el máximo partido al curso
Toma notas de tu curso en tiempo real en Frogames Formación
Una chuleta de las funciones de Excel
Introducción sobre repaso
Descargar Excel para Windows y Mac
Atajos en Excel
Más reglas condicionales
Evaluar Formulas
Más opciones en el uso de tablas
BuscarV
Introducción a más opciones de búsqueda
Buscar con datos parciales
Búsqueda con datos múltiples
Tarea de la sección
Introducción a extracción de datos
Separar datos
Buscar datos concatenados
Tarea de la sección
Introducción a diagrama de Gantt
Diagrama de Gantt
Tarea de la sección
Introducción a las Macros
Vínculo
Macros
Tipos de archivos en Excel: con Macros y sin Macros
Ejemplo
Conclusión de las macros
Evaluación
Introducción a tablas dinámicas
Comenzar con las tablas dinámicas
Campos de la tabla
Campo de valores
Campo de filas
Campo de columnas
Campo de filtros
Gráfico dinámico
Tarea de la sección
Evaluación
Introducción a auditoría de formulas
Ventana de información
Datos precedentes y dependientes
Tarea de la sección
Introducción a Solver
Solver
Ejemplo1
Ejemplo 2
Tarea de la sección
Evaluación
Introducción a Power Pivot
Activar Power Pivot
Importar datos
Relacionar los archivos
Modelado de datos
Filtros
KPI con Power Pivot
Tarea de la sección archivo 1
Tarea archivo 2
Tarea archivo 3
Introducción de Anexos
Capacitación en H.B
ChatGPT - Variables de Negocios
Data Science
Conclusión del curso

instructor

5.0 /5
(19)

  • Avatar
    Jorge
    (5)
    Mastering Spreadsheets

    This was definitely the challenge I was missing, the tools I learned here save me hours of repetitive work every week and now I can say my files look much more professional.

  • Avatar
    Caty
    (5)
    Excel from intermediate to advanced

    Ideal for those who want to master Excel—it includes solid techniques, complete formulas, and data analysis

  • Avatar
    Joiser
    (5)
    Satisfied with the course

    I'm totally thrilled with the intermediate to advanced Excel course. It gave me deep knowledge in advanced functions, data analysis and automation, drastically improving my spreadsheet productivity.

  • Avatar
    Gustavo
    (5)
    Excel from Intermediate to Advanced: Master Functions, Automate Processes, and Design Professional Dashboards

    This course takes you beyond basic formulas and teaches you to use Excel as a data analysis, management, and presentation tool. You'll learn to work with complex functions, automate repetitive tasks, link sheets and workbooks, and create interactive dashboards that impress.

  • Avatar
    Samuel
    (5)
    I thought I knew Excel until I took this course

    The advanced functions they teach are a game-changer for my work. Now I do complex calculations in minutes

  • Avatar
    Javi
    (5)
    My time is better optimized with my new Excel skills

    It's helped me a lot to stand out in the office, because now I solve in minutes what used to take me all afternoon. It's huge satisfaction to finally see that I master the tool and it doesn't master me.

  • Avatar
    danison
    (5)
    From Simple Formulas to Complex Solutions: My Jump to Advanced Excel

    This course is amazing! I'd always stuck to the basics of Excel, but here I discovered a completely new world. I learned how to create pivot tables that simplify my data analysis, how to use macros to automate repetitive tasks, and even how to solve optimization problems that seemed impossible to me before.

  • Avatar
    Nieves
    (5)
    Great course, I can't wait to move on to the next level!

  • Avatar
    María
    (5)
    From intermediate to advanced without the headache

    This course helped me go from knowing how to use Excel to really making the most of it. Functions, pivot tables, automations… everything explained clearly. I feel much more efficient and able to solve complex problems with ease.

  • Avatar
    Gabriela
    (5)
    Getting better!

    Pivot tables are my new best friend, they make everything so easy and now my reports are top notch

  • Avatar
    Giovanni
    (5)
    The next level of productivity

    This course proves there's always more to discover. Pivot tables and complex functions now come naturally to me, and I've gone from being "the spreadsheet guy" to the team expert

  • Avatar
    Santiago
    (5)
    Super useful, the exercises are very realistic.

  • Avatar
    Nicolás
    (5)
    I learned really useful things

  • Avatar
    Rocío
    (5)
    A very complete course; it allowed me to master advanced functions and optimize my daily work

  • Avatar
    Angel
    (5)
    Take your Excel skills to the next level and become an expert in spreadsheets, dynamic reports, and macros

    This course is designed for those who already master Excel's basic and intermediate functions and want to advance toward professional use of the tool. You'll learn to work with large data volumes, create interactive dashboards, apply advanced functions, and automate tasks with macros and VBA.

  • Avatar
    Jackeline
    (5)
    It helped me automate my work

  • Avatar
    Rosa
    (5)
    I leveled up my Excel skills!

  • Avatar
    Yvonne
    (5)
    Excellent course

    I've already taken the beginner to intermediate Excel course and honestly, learning more and more about Excel and progressing through Frogames courses has been really rewarding

  • Avatar
    Marc
    (5)
    3rd Excel level

    following these courses to become an Excel master.

PLANS TO MATCH YOUR GOALS AND NEEDS

Buy the individual course, get all the learning path or access to the entire platform

Choose the payment method that works best for your needs and budget with a one-time course payment, monthly or yearly access to the learning Path, or even to the entire platform.

One-Time Payment

Buy the course once and access it for life

49.99

  • A single payment
  • Instant lifetime access to the course
  • Access the course community
El Más
Popular

Bronze Frog

Access all Frogames courses, communities and extras

39 /month

  • Single payment of 39€ per month
  • Instant access to all courses
  • Access the platform and communities 24/7, wherever and whenever you want
  • Cancel anytime without losing your progress

Office and Productivity Path

Access all Courses in the Office & Productivity Path

19.99 /month

  • Single payment of 19.99€ per month
  • Instant access to the +10 courses in the Path
  • Access the Path 24 / 7, wherever and whenever you want
  • Cancel anytime without losing your progress

One-time payment

Buy the course once and access it for life

49.99

  • A single payment
  • Instant lifetime access to the course
  • Access the course community
El Más
Valorado

Gold Frog

Access all Frogames courses, communities and extras

349 /year

  • Single payment of €349 per year
  • 3 months of discount
  • Instant access to all courses
  • Access the platform and communities 24/7, wherever and whenever you want
  • Cancel anytime without losing your progress
  • Resource Library
  • Monthly Q&A livestreams
  • Premium support

Office and Productivity Path

Access all Courses in the Office & Productivity Path

199 /year

  • Single annual payment of €199
  • 4 months of discount
  • Instant access to the +10 courses in the Path
  • Access the Path 24 / 7, wherever and whenever you want
  • Cancel anytime without losing your progress
  • Premium support

* All prices include taxes.

For your security, all orders will be processed on a secure server.

Office and Productivity Path

The ultimate pack with all our Office & Productivity courses to optimize document management and boost work efficiency. Includes upcoming courses and updates and improvements to current ones.

Essential Guide to Starting a 6-Figure Online Business

Learn everything you need to know to launch your six-figure online business and start living off passive income generated through the internet

17 classes

Excel de cero a principiante

Start your Excel journey with our beginner course to learn how to download Excel, import your data, implement your first formulas, and create your first charts using the Microsoft Office suite.

51 classes

The ultimate ChatGPT guide: master productivity with real examples

Pushing Boundaries with ChatGPT: Unlock your full potential and learn how to ask effective questions to boost your productivity and achieve your professional and personal goals at work, programming, and beyond

82 classes

Organiza tu Conocimiento con Obsidian: De la Toma de Notas a la Creación de tu Segundo Cerebro

Learn to use Obsidian, a modern and powerful tool for note-taking and knowledge management

40 classes

🤖 Master AI to Boost Your Productivity 🚀

Discover how to use artificial intelligence to transform the way you work, automate tedious tasks and boost your productivity

20 classes

Excel de principiante a intermedio

Take your Excel skills to the next level with our intermediate course. Learn to use conditionals and Excel functions, perform mathematical operations, and create your first templates using the Microsoft Office suite.

53 classes

🎓 Google Classroom: Master Digital Teaching and Optimize Learning in the Virtual Classroom

Learn everything you need to master Google Classroom: manage classes, create assignments, grade and review your students' work, and much more

23 classes

Excel from intermediate to advanced

Unlock the power of Excel with our intermediate to advanced level course. Learn to work with complex formulas and functions, create pivot tables, macros, solve optimization problems and linear programming.

66 classes

Practical Excel Cases

Harness the power of Excel with our expert-level course. Apply everything you've learned with real-world cases in logistics, purchasing, sales, and management skills.

46 classes