Desarrolla habilidades para tu carrera profesional desde solo $11.99 USD. Termina hoy

Basic Excel Step by Step to Learn Easily

If you have never used Excel before or need to brush up on your knowledge, this course is ideal for you. It will guide you step by step from the basics to the essential functions that will allow you to create simple reports, tables and graphs.

Por Willington Rincon Hoyos | Systems Engineer Specialist in IT Management

Sobre este curso

✔️ Excel course that starts from Zero to a more advanced level. This course explains in detail the fundamental concepts to learn how to use Excel correctly, taking into account the appropriate data types, fundamental mathematical concepts, and logical operations.

The most important aspects of handling functions and their parameters. Very practical classes will be given so that students can really internalize the concepts and topics covered in each of them. In the final section, a series of utilities are explained that students can apply in their companies or businesses.

Among the benefits of the course are:

- Invoice Search.
- Simple Invoice.
- Control of activities or schedules with alerts.
- Income and Expense Control.
- Handling dynamic tables with an exercise explained in detail and with the possibility of practicing with a file of more than 1,000,000 records.
- Contingency table of the Saber tests.
- Cross-referencing information between sheets and files.
- A CRM for small businesses through which you can track customers.

The main objective of this course is for students to get real benefit from the classes taught and to apply them in their work and personal lives.

  • 5 stars: 5 (45%)
  • 4 stars: 6 (55%)
  • 3 stars: 0 (0%)
  • 2 stars: 0 (0%)
  • 1 star: 0 (0%)
Z
Zadquiel Carrillo
edad: 18-24
Nivel: Estudiante Universatario
Satisfecho

Un curso bien explicado, aclara todo de manera sencilla, si estás comenzando este es para ti, solo presten atención y practiquen lo suficiente.

A
Andrea Álvarez

Puedes acceder a los cursos desde cualquier dispositivo, lo que hace que el aprendizaje sea aún más conveniente.

M
Miguel Hernández

Los contenidos se mantienen al día, lo que es fundamental en un mundo laboral en constante cambio.

D
David López

Los cursos están impartidos por profesionales con gran experiencia, lo que asegura contenido de alta calidad.

S
Sofía Sánchez

La posibilidad de estudiar a tu propio ritmo es una gran ventaja para quienes tienen agendas ocupadas.

L
Laura Fernández

G-talent ofrece una amplia gama de cursos que cubren diferentes áreas, lo que es perfecto para quienes buscan diversificarse.

J
Juan Pérez

G-Talent es una plataforma de aprendizaje online increíblemente útil y fácil de usar.

A
Ana González

G-Talent es una herramienta invaluable para cualquier persona que quiera aprender online.

M
María Rodríguez

Recomiendo encarecidamente G-Talent a todos los que buscan ampliar sus conocimientos y mejorar sus habilidades.

L
Luis Martínez

G-Talent ha superado mis expectativas y ha sido una experiencia de aprendizaje increíblemente positiva.

C
Carlos García

Estoy muy contento con mi experiencia en G-Talent y lo seguiré usando en el futuro.

Curso Online
59 estudiantes
Acceso de por vida
50 clases
Acceso para siempre
Spanish
Garantía de reembolso de 30 días

Lo que aprenderás

🟧 Excel FROM SCRATCH

🟧 Use Functions and design your own formulas.

🟧 You will go from zero to a more advanced level.

🟧 Most importantly, you will be able to apply what you have learned in this course to your professional and personal life.

Temario

Duración 8h 58m
10 recursos descargables
50 clases

U1: Concepts and my first steps in Excel

- Introduction to Excel
- Importance of Regional Settings
- Data Types: General, Number, Currency and Accounting
- Data Types: Short Date, Long Date and Hours
- Data Types: Percentage, Fractions, Scientific and Text
- Select, drag and move
- Relative References
- Absolute References
- Circular References

U2: Basic Styles

- Row and Column Sizing
- Text Styles and Alignment
- Handling Borders and Merging Cells
- Applying Styles: Word Search
- Applying Styles: List of Workers

U3: Basic Mathematical Concepts and Logical Operations

- Mathematical Concepts for Excel Part 1
- Mathematical Concepts for Excel Part 2
- Logical Operation AND and Logical Operation OR

U4: Handling Functions and Parameters in Excel

- Detailed Explanation to handle Functions in Excel

U5: Most common functions in Excel part I

- Add and Add.IF
- Count and Count.IF
- Sum Product
- Apply Product Sum to a sales list

U6: Nested Functions

- Detailed Explanation of Handling Nested Functions

U7: Most common functions in Excel part 2
Concatenate

- Concatenate
- Proper, Left, Right, Uppercase, Lowercase and Length
- Round Function
- Extract Function
- Logical Function IF
- VLOOKUP Function. A Very Detailed Explanation
- SearchV in a simple invoice
- Indirect Function: Invoice Search

U8: Data Management and Security in Excel

- Sort Records
- Conditional Formatting: Remove Duplicates
- Handling Graphics in Excel
- Handling Pivot Tables
- Tabulate and Graph Surveys
- Income and Expense Control
- Data Protection and Formulas

U9: Examples of Applications and Utilities in Excel

- How to keep track of your activities
- Contingency Tables
- Student Attendance Control
- Information Cross-checks with SearchV part 1
- Information Cross-checks with SearchV part 2
- Cross-checking and validation of health diagnoses
- CRM for small businesses part 1
- CRM for small businesses part 2
- CRM for small businesses part 3
- CRM for small businesses part 4

U10: What's Next?

- My Databases course
- My SQL course

Course evaluation

- This course contains a final exam.

G-Tools: For Students

- Exclusive access to cutting-edge student tools: improve your employability, participate in exclusive events, take advantage of our intelligent virtual assistant, and more.

⚑ Certificate of completion

- Your personalized digital certificate, a unique badge of your achievements, with international validity, course duration and QR code for instant verification.

Instructor del Curso
Instructor

Willington Rincon Hoyos

He is a Systems Engineer and IT Management Specialist with more than 15 years of experience in software and database development. Throughout his career, he has accumulated vast knowledge in the Colombian health sector, where he has played a fundamental role in the coordination of information systems and in the design of high-impact technological solutions for hospital entities.

His professional career has led him to work as an information systems coordinator in various hospital institutions, as well as a face-to-face teaching instructor for more than 5 years, sharing his knowledge and experience with students and professionals in the sector. In addition, he has worked directly with real clients in Colombia, developing software projects and relational databases that have allowed for improved information management in the health field.

As a technology expert, Willington has demonstrated a unique ability to efficiently and effectively integrate IT solutions into complex environments such as those in the healthcare sector. His practical approach and teaching skills have made him a benchmark in his field, standing out not only for his technical ability, but also for his ability to convey complex concepts in an accessible and clear manner.

Why learn with Willington Rincón Hoyos?

▪️ Extensive experience: More than 15 years in software and database development, especially in the health sector in Colombia.

▪️ Practical approach: Their training is oriented towards the effective implementation of technological solutions, with a strong practical component that prepares students to face real challenges.

▪️ Teaching experience: More than 5 years as an in-person instructor, providing quality training to professionals and students.

▪️ Expertise in applied technology: With a solid knowledge in IT management and the development of solutions in the health field, Willington offers comprehensive training that combines theory and practice.

If you want to acquire knowledge in software development, databases or IT management applied to the health sector, don't miss the opportunity to learn from a professional with extensive experience in the industry. Sign up for their courses and take your skills to the next level!

Discover the added value: G-Tools and much more

In addition to high-quality content, this course gives you access to G-Tools, a suite of tools and resources designed to enhance your learning and your career.

Employability support resources, live events and take advantage of Aixa.IA's artificial intelligence to resolve your questions at any time.

$12.99 $47.00

Acceso sólo a este curso

$67.00 $180.00

Suscríbete y ahorra con PLUS

Anual

Plan de Acceso Total

Para 1 estudiante

$77.00 $120.00
  • Acceso a todas las carreras con más de 700 cursos de contenido profesional y actualizado.
  • Certificado por cada curso completado con validez en internacional
  • Clases en vivo y casos guiados todos los meses sobre IA aplicada al trabajo.
  • Recursos exclusivos, Comunidad PLUS, Bolsa de Trabajo (Jobs).
  • Sin renovación anual
  • 30% descuento exclusivo en todas las certificaciones de doble aval y eventos presenciales.

Paga en 2 cuotas sin intereses

Recomendado
Anual

G-Talent PLUS

Para 1 estudiante

$67.00 $180.00
  • Acceso a todas las carreras con más de 700 cursos de contenido profesional y actualizado.
  • Certificado por cada curso completado con validez en internacional
  • Clases en vivo y casos guiados todos los meses sobre IA aplicada al trabajo.
  • Recursos exclusivos, Comunidad PLUS, Bolsa de Trabajo (Jobs).
  • Renovación anual (cancela cuando quieras)
  • 30% descuento exclusivo en todas las certificaciones de doble aval y eventos presenciales.

Cancela cuando quieras

Mensual

G-Talent LITE

Para 1 estudiante

$15.99 $25.00
  • Acceso a todas las carreras con más de 700 cursos de contenido profesional y actualizado.
  • Certificado por cada curso completado con validez en internacional
  • Clases en vivo y casos guiados todos los meses sobre IA aplicada al trabajo.
  • Recursos exclusivos, Comunidad PLUS, Bolsa de Trabajo (Jobs).
  • Renovación mensual (cancela cuando quieras)
  • 30% descuento exclusivo en todas las certificaciones de doble aval y eventos presenciales.

Cancela cuando quieras

Planes para organizaciones

Soluciones personalizadas para tu empresa

Ofrecemos planes especiales para organizaciones con necesidades específicas de capacitación.

  • Reclutamiento y selección
  • Seguimiento planes de formación
  • Evaluación desempeño
  • Formación para equipos
  • Clima organizacional
  • Expedientes digitales
No hemos podido validar su registro.
Hemos recibido tu información. Nos pondremos en contacto contigo.

Prueba G-Talent HR

Agenda una demo con nosotros.

Ingresa un número válido.
Esta oferta finaliza en:
00
Hrs
00
Min
00
Seg
Compra este curso individual
$12.99 USD
$47.00 USD
Ahorro: $34.01 USD
Pago único. Acceso de por vida.
Garantía de reembolso de 30 díasGarantía de reembolso de 30 días
Mejor opción
Suscríbete a PLUS y ahorra
$67.00 USD
$180.00 USD
Ahorro: $113.00 USD
Accede a más de 700 cursos, clases en vivo, recursos y beneficios para la comunidad PLUS.
Cancela cuando quieras

¿Qué esperar de los cursos de G-Talent?

  • Estudia a tu ritmo

    Consigue cursos en video, impartidos por instructores de primera, para estudiar a tu propio ritmo

  • Aprende de los mejores

    Lleva cursos de alta calidad desarrollados expertos seleccionados con cuidado

  • Calidad garantizada

    ¿No estás seguro?, todos nuestros cursos ofrecen garantía de éxito de 30 días

  • Acompañamiento permanente

    Aprende a tu ritmo, con actualización, acceso y acompañamiento de por vida.

  • Certificado personalizado

    Consigue un certificado de clase mundial, con validez internacional y código único cifrado QR

  • Descubre G-Talent Studio

    Accede a herramientas premium, beneficios exclusivos y apoyo en tu empleabilidad. Disponible para estudiantes con Acceso Total.

Las principales empresas eligen a G-Talent HR para desarrollar las habilidades profesionales de sus colaboradores.

G-Talent HR

G-Talent.Net

G-Talent.Net

G-Talent.Net

G-Talent.Net