• No hay productos en el carrito.

Inicio / Cursos / Microsoft Excel 2016 Beginners & Intermediate Excel Training
Impartido por 365 CareersPago único de $2,800 MXN · acceso por 12 meses

Microsoft Excel 2016 Beginners & Intermediate Excel Training

Excel for the office: Excel Formatting, Excel functions, Excel charts, Excel pivot tables made easy for you

Certificado oficial emitido por la SEPA través del Gobierno del Estado de México
12 meses de acceso En línea · 45 h 9 unidades
Qué aprenderás

Lo que serás capaz de hacer

Do you want to learn how to work with Excel? Even if you don’t have any prior experience? You want to become very good at Excel? If so, then this is the right course for you! *A verifiable certificate of completion is presented to all students who complete this course.* Microsoft Excel is the greatest productivity software the world has seen so far. However, it’s essential that you learn how to work with it effectively. But how can you do that if you have very limited time and no prior training? And how can you be certain that you are not missing an important piece of the puzzle? Microsoft Excel Beginners & Intermediate Excel Training is here for you . One of the best Excel courses online, this training includes everything you’ll need. We will start from the very basics and then gradually build a solid foundation that will help you grow as a professional. What makes this course different from the rest of the Excel courses out there? High quality of production – HD video and animated slides (this isn’t a collection of boring lectures!) Knowledgeable instructor (3 million Udemy students, working experience in Big 4 Consulting and Coca-Cola) Downloadable materials: The course comes with a complete set of downloadable materials (handouts, Excel files, etc.) Extensive case studies that will help you reinforce everything that you’ve learned Excellent support: If you don’t understand a concept or you simply want to drop us a line, you’ll receive an answer Dynamic: We don’t want to waste your time! The instructor maintains a very good pace throughout the whole course Why is Microsoft Excel so important? Every company on the planet uses this software, right? So if you want to learn a new skill that is highly valued by all employers, you should start here. Here are 5 more reasons why you should take this course and learn Excel: Jobs. A solid understanding of Excel opens the door for a number of career paths Promotions. Top Excel users are promoted very easily inside large corporations Secure Future. Excel skills remain with you and provide extra security. You won’t ever have to fear unemployment This course is suitable for people with no previous experience in Excel. We will start from the very basics and will gradually move on to some of the more advanced features, such as lookup functions, functions with conditions, goal seek, pivot tables, custom formatting, Excel charts, and other tools that are often used for the purposes of financial modeling. Additionally, the course includes practical case studies that will reinforce everything you learn. One of the exercises we will see in the course consists of building a complete Profit & Loss statement from scratch. This training is highly recommended for university students, entry-level finance, business and marketing professionals who would like to grow faster than their peers. Please don’t forget that the course comes with Udemy’s 30-day unconditional money-back-in-full guarantee. And why hesitate to offer such a guarantee when we are confident the training will be immensely valuable to you? Buy the course today and let's start this journey together!

  • Work comfortably with Microsoft Excel 2016 and many of its advanced features
  • Learn what is new in Excel 2016
  • Be much quicker at carrying out regular tasks
  • Become your team's go-to-guy when it comes to Excel
  • Use sophisticated functions that will improve the quality of your work

Temario

UNIDAD 1 - Welcome! Course Introduction · 4 lecciones

UNIDAD 1 - Welcome! Course Introduction

  • What Does the Course Cover?Video · 6 min
  • Bonus Gift Number 1Lectura · 0 min
  • Bonus Gift Number 2Lectura · 0 min
  • Quiz Number 1Cuestionario · 0 min
UNIDAD 2 - A Quick Introduction to the Basics of Excel · 11 lecciones

UNIDAD 2 - A Quick Introduction to the Basics of Excel

  • Overview of ExcelVideo · 4 min
  • The Excel RibbonVideo · 3 min
  • Working with Rows & ColumnsVideo · 2 min
  • Data Entry in ExcelVideo · 3 min
  • Introduction to FormattingVideo · 6 min
  • Creating Formulas in ExcelVideo · 3 min
  • Microsoft Excel at Its Best - FunctionsVideo · 4 min
  • Work Efficiently By Using Cut, Copy & PasteVideo · 2 min
  • Format CellsVideo · 5 min
  • Pasting Values, Formulas and Formats with Paste SpecialVideo · 1 min
  • Quiz Number 2Cuestionario · 0 min
UNIDAD 3 - Assignment 1 · 1 lecciones

UNIDAD 3 - Assignment 1

  • Basic Excel - Practice ActivityCuestionario · 20 min
UNIDAD 4 - Excel Best Practices: Useful Tips & Tools · 20 lecciones

UNIDAD 4 - Excel Best Practices: Useful Tips & Tools

  • This Is How You Can Start Formatting Your Sheets in a Professional WayVideo · 2 min
  • Fast Scrolling That Would Allow You to Be 3x FasterVideo · 2 min
  • Fixing Cell References ProperlyVideo · 2 min
  • Using the Alt plus Enter combinationVideo · 1 min
  • Learn How to Organize Your Excel Data with Text to ColumnsVideo · 2 min
  • Wrapping Text in ExcelVideo · 1 min
  • Create Easily Printable Documents by Using Set Print AreaVideo · 1 min
  • Find and Select Special Types of Cells with Select Special (F5)Video · 2 min
  • Learn How to Assign Dynamic Names within a ModelVideo · 1 min
  • Excel Formulas that Make Sense - Named RangesVideo · 2 min
  • Completing 33% of the courseLectura · 0 min
  • Introduction to Custom FormattingVideo · 6 min
  • Assigning Custom Formats to Specific Cells (Ex. Multiples)Video · 2 min
  • Execute 50 Commands with a Single Click - Excel MacrosVideo · 3 min
  • Create a Drop-Down List by Using Data ValidationVideo · 2 min
  • Using Custom Sort in Order to Sort Multiple Columns within a TableVideo · 1 min
  • Create a Great Index Page at the Beginning of Your Financial ModelsVideo · 2 min
  • Freeze the Title Row of Your Table - Freeze PanesVideo · 1 min
  • Excel's "Tell Me" Search BarVideo · 1 min
  • Quiz Number 1Cuestionario · 0 min
UNIDAD 5 - Keyboard Shortcuts in Excel · 1 lecciones

UNIDAD 5 - Keyboard Shortcuts in Excel

  • Keyboard Shortcuts Save LOTS of time in ExcelVideo · 5 min
UNIDAD 6 - Excel Functions · 17 lecciones

UNIDAD 6 - Excel Functions

  • A helpful considerationLectura · 0 min
  • Key Functions in Excel: COUNT, COUNTA, COUNTIF, COUNTIFSVideo · 4 min
  • Key Functions in Excel: SUM, SUMIF, SUMIFSVideo · 4 min
  • Key Excel Functions: AVERAGE & AVERAGEIFVideo · 2 min
  • Completing 50% of the courseLectura · 0 min
  • Working with Text in Excel: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATEVideo · 4 min
  • Find the Highest and the Lowest Values in a Range: MAX & MINVideo · 1 min
  • Include ROUND in Your Financial ModelsVideo · 1 min
  • Transferring Data Efficiently: VLOOKUP & HLOOKUPVideo · 8 min
  • Use INDEX & MATCH as a Substitute of VLOOKUPVideo · 7 min
  • The Perfect VLOOKUP Substitute: XLOOKUP (Office 365 Only)Video · 7 min
  • IFERROR Allows You to Deal Easily with Error MesagesVideo · 2 min
  • Excel's Dynamic & Interactive Tables: Pivot TablesVideo · 2 min
  • Create Flexible Financial Models with the CHOOSE FunctionVideo · 2 min
  • Find the Result that You Are Looking For with Goal SeekVideo · 2 min
  • Include Sensitivity Analysis In Your Model Through Data TablesVideo · 4 min
  • Quiz Number 2Cuestionario · 0 min
UNIDAD 7 - Create Professional Charts in Microsoft Excel 2016 · 7 lecciones

UNIDAD 7 - Create Professional Charts in Microsoft Excel 2016

  • Introduction to Charts in Excel 2016Video · 1 min
  • Inserting Charts in Excel & Learning About the Various Chart TypesVideo · 2 min
  • Formatting of Excel Charts (1/2)Video · 2 min
  • Formatting of Excel Charts (2/2)Video · 3 min
  • Creating a Bridge Chart in Excel 2016 - As Easy As It GetsVideo · 2 min
  • An Easy Way to Create a TreemapVideo · 2 min
  • Use Sparklines to Show Data TrendsVideo · 4 min
UNIDAD 8 - Build a Complete P&L from Scratch · 17 lecciones

UNIDAD 8 - Build a Complete P&L from Scratch

  • Introduction to the Case StudyVideo · 1 min
  • This Is the data that we will use for our ExerciseVideo · 3 min
  • Let's Reorder our Excel sheet and create a clear structureVideo · 2 min
  • Introducing a Code: The best way to work with large amounts of dataVideo · 2 min
  • Finishing Touches of our DatabaseVideo · 2 min
  • Using Vlookup in Order to Transfer DataVideo · 5 min
  • Applying Sumif in Order to Populate the Database with NumbersVideo · 4 min
  • Demonstrating How Index & Match Can Successfully Replace VlookupVideo · 4 min
  • Substituting VLOOKUP with XLOOKUP (Office 365 Only)Video · 3 min
  • Mapping the Items Within Our Database - A Key Exercise For Financial AnalystsVideo · 2 min
  • Creating the Structure of the P&L StatementVideo · 2 min
  • Time for Some Formatting! The Secret of Creating Awesome Looking Excel SheetsVideo · 3 min
  • Populating the P&L sheet with figuresVideo · 3 min
  • How do We Find Mistakes in the easiest way possible?Video · 2 min
  • Finishing Touches: Calculating Year-on-Year Growth and Percentage IncidenceVideo · 3 min
  • Quiz Number 3Cuestionario · 0 min
  • Course Challenge - Apply Your Skills in PracticeVideo · 1 min
UNIDAD 9 - Practical Exercise - SUMIFS · 2 lecciones

UNIDAD 9 - Practical Exercise - SUMIFS

  • Practical Exercise - SUMIFSVideo · 8 min
  • Completing 100% of the courseLectura · 0 min
Certificado oficial

Tu certificado lo emite la SEP, no solo una plataforma

Al demostrar la competencia recibes un certificado emitido por la Secretaría de Educación Pública a través del Gobierno del Estado de México: un documento oficial que puedes presentar con confianza ante cualquier empleador o institución.

Tu certificado con INEC

  • Lo emite la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México
  • Documento oficial con folio verificable en línea
  • Lo otorga la Universidad Tecnológica Fidel Velázquez

Otras plataformas en línea

  • Constancia privada emitida por la misma plataforma
  • Solo acredita horas cursadas o asistencia
  • Sin respaldo de una autoridad educativa
Cómo funciona

Tu itinerario, de la inscripción al certificado

  1. 1

    Inscripción con pago único

    Pagas $2,800 MXN una sola vez y entras de inmediato al curso.

  2. 2

    Estudias a tu ritmo

    9 unidades con videos, lecturas y actividades, disponibles 24/7 durante 12 meses.

  3. 3

    Cuestionarios por unidad

    6 cuestionarios para comprobar lo aprendido.

  4. 4

    Certificado

    Emitido por la SEP a través del Gobierno del Estado de México, con folio verificable.

Lo que obtienes

Un certificado oficial de la SEP

Muestra del certificado: Microsoft Excel 2016 Beginners & Intermediate Excel Training

Muestra · verificable por folio y QR

  • Emitido por la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México. No es una constancia privada: es un documento oficial, y ese respaldo marca la diferencia frente a otras plataformas en línea.
  • Contenido impartido por 365 Careers.
  • Folio y QR verificables para compartirlo con quien te contrate.
Medios que necesitas
Equipo de cómputo Conexión estable a internet
Pago único

Empieza hoy, a tu ritmo

Un solo pago y acceso inmediato al curso completo durante 12 meses.

  • 9 unidades · 80 lecciones · 45 h
  • 12 meses de acceso
  • 6 cuestionarios de evaluación
  • Certificado emitido por la SEP (Gob. del Estado de México) con folio verificable
Pago único
$2,800MXN
Acceso por 12 meses
Inscribirme Hablar con un asesor
Preguntas frecuentes

Sobre tu inscripción

¿Cómo es el pago?

Un solo pago de $2,800 MXN. No hay mensualidades ni cargos recurrentes.

¿Cuánto tiempo tengo acceso?

12 meses desde tu inscripción, 24/7, para avanzar a tu ritmo.

¿Quién imparte el contenido?

El curso es impartido por 365 Careers; INEC gestiona tu inscripción, evaluación y certificado.

¿Qué pasa cuando vence mi acceso?

Puedes renovar tu cuenta tú mismo desde la plataforma, sin trámites ni esperas.

Certificado emitido por la SEP a través del Gobierno del Estado de México · Microsoft Excel 2016 Beginners & Intermediate Excel Training

Inscribirme
  INEC es una Marca de SalesPartners Ciudad de México S de RL de CV. Template Design © Learnify LMS. All rights reserved. Terminos y Condiciones Aviso de Privacidad Politica de Devolución
Hide picture