Microsoft Excel 2016 Beginners & Intermediate Excel Training
Excel for the office: Excel Formatting, Excel functions, Excel charts, Excel pivot tables made easy for you
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 leccionesUNIDAD 1 - Welcome! Course Introduction
UNIDAD 1 - Welcome! Course Introduction
- What Does the Course Cover?
- Bonus Gift Number 1
- Bonus Gift Number 2
- Quiz Number 1
UNIDAD 2 - A Quick Introduction to the Basics of Excel · 11 leccionesUNIDAD 2 - A Quick Introduction to the Basics of Excel
UNIDAD 2 - A Quick Introduction to the Basics of Excel
- Overview of Excel
- The Excel Ribbon
- Working with Rows & Columns
- Data Entry in Excel
- Introduction to Formatting
- Creating Formulas in Excel
- Microsoft Excel at Its Best - Functions
- Work Efficiently By Using Cut, Copy & Paste
- Format Cells
- Pasting Values, Formulas and Formats with Paste Special
- Quiz Number 2
UNIDAD 3 - Assignment 1 · 1 leccionesUNIDAD 3 - Assignment 1
UNIDAD 3 - Assignment 1
- Basic Excel - Practice Activity
UNIDAD 4 - Excel Best Practices: Useful Tips & Tools · 20 leccionesUNIDAD 4 - Excel Best Practices: Useful Tips & Tools
UNIDAD 4 - Excel Best Practices: Useful Tips & Tools
- This Is How You Can Start Formatting Your Sheets in a Professional Way
- Fast Scrolling That Would Allow You to Be 3x Faster
- Fixing Cell References Properly
- Using the Alt plus Enter combination
- Learn How to Organize Your Excel Data with Text to Columns
- Wrapping Text in Excel
- Create Easily Printable Documents by Using Set Print Area
- Find and Select Special Types of Cells with Select Special (F5)
- Learn How to Assign Dynamic Names within a Model
- Excel Formulas that Make Sense - Named Ranges
- Completing 33% of the course
- Introduction to Custom Formatting
- Assigning Custom Formats to Specific Cells (Ex. Multiples)
- Execute 50 Commands with a Single Click - Excel Macros
- Create a Drop-Down List by Using Data Validation
- Using Custom Sort in Order to Sort Multiple Columns within a Table
- Create a Great Index Page at the Beginning of Your Financial Models
- Freeze the Title Row of Your Table - Freeze Panes
- Excel's "Tell Me" Search Bar
- Quiz Number 1
UNIDAD 5 - Keyboard Shortcuts in Excel · 1 leccionesUNIDAD 5 - Keyboard Shortcuts in Excel
UNIDAD 5 - Keyboard Shortcuts in Excel
- Keyboard Shortcuts Save LOTS of time in Excel
UNIDAD 6 - Excel Functions · 17 leccionesUNIDAD 6 - Excel Functions
UNIDAD 6 - Excel Functions
- A helpful consideration
- Key Functions in Excel: COUNT, COUNTA, COUNTIF, COUNTIFS
- Key Functions in Excel: SUM, SUMIF, SUMIFS
- Key Excel Functions: AVERAGE & AVERAGEIF
- Completing 50% of the course
- Working with Text in Excel: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE
- Find the Highest and the Lowest Values in a Range: MAX & MIN
- Include ROUND in Your Financial Models
- Transferring Data Efficiently: VLOOKUP & HLOOKUP
- Use INDEX & MATCH as a Substitute of VLOOKUP
- The Perfect VLOOKUP Substitute: XLOOKUP (Office 365 Only)
- IFERROR Allows You to Deal Easily with Error Mesages
- Excel's Dynamic & Interactive Tables: Pivot Tables
- Create Flexible Financial Models with the CHOOSE Function
- Find the Result that You Are Looking For with Goal Seek
- Include Sensitivity Analysis In Your Model Through Data Tables
- Quiz Number 2
UNIDAD 7 - Create Professional Charts in Microsoft Excel 2016 · 7 leccionesUNIDAD 7 - Create Professional Charts in Microsoft Excel 2016
UNIDAD 7 - Create Professional Charts in Microsoft Excel 2016
- Introduction to Charts in Excel 2016
- Inserting Charts in Excel & Learning About the Various Chart Types
- Formatting of Excel Charts (1/2)
- Formatting of Excel Charts (2/2)
- Creating a Bridge Chart in Excel 2016 - As Easy As It Gets
- An Easy Way to Create a Treemap
- Use Sparklines to Show Data Trends
UNIDAD 8 - Build a Complete P&L from Scratch · 17 leccionesUNIDAD 8 - Build a Complete P&L from Scratch
UNIDAD 8 - Build a Complete P&L from Scratch
- Introduction to the Case Study
- This Is the data that we will use for our Exercise
- Let's Reorder our Excel sheet and create a clear structure
- Introducing a Code: The best way to work with large amounts of data
- Finishing Touches of our Database
- Using Vlookup in Order to Transfer Data
- Applying Sumif in Order to Populate the Database with Numbers
- Demonstrating How Index & Match Can Successfully Replace Vlookup
- Substituting VLOOKUP with XLOOKUP (Office 365 Only)
- Mapping the Items Within Our Database - A Key Exercise For Financial Analysts
- Creating the Structure of the P&L Statement
- Time for Some Formatting! The Secret of Creating Awesome Looking Excel Sheets
- Populating the P&L sheet with figures
- How do We Find Mistakes in the easiest way possible?
- Finishing Touches: Calculating Year-on-Year Growth and Percentage Incidence
- Quiz Number 3
- Course Challenge - Apply Your Skills in Practice
UNIDAD 9 - Practical Exercise - SUMIFS · 2 leccionesUNIDAD 9 - Practical Exercise - SUMIFS
UNIDAD 9 - Practical Exercise - SUMIFS
- Practical Exercise - SUMIFS
- Completing 100% of the course
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
Tu itinerario, de la inscripción al certificado
- 1
Inscripción con pago único
Pagas $2,800 MXN una sola vez y entras de inmediato al curso.
- 2
Estudias a tu ritmo
9 unidades con videos, lecturas y actividades, disponibles 24/7 durante 12 meses.
- 3
Cuestionarios por unidad
6 cuestionarios para comprobar lo aprendido.
- 4
Certificado
Emitido por la SEP a través del Gobierno del Estado de México, con folio verificable.
Un certificado oficial de la SEP
- 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.
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
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.


