Excel Smart Tips: 54 Ways to Supercharge your Sheets
A collection of 54 micro-lessons to help you: Master functions, format your spreadsheets, and analyze data with ease
Lo que serás capaz de hacer
Udemy's "Smart Tips" is the ultimate micro-learning series. Short, standalone lectures let you learn new skills at your own pace, anytime, anywhere. Find what you need, when you need it. Elevate your learning with Smart Tips! Have you ever needed to remove duplicate records in a list that’s hundreds of rows long, and gone cross-eyed trying to find all of them on your own? Or maybe you’ve needed to get just the first name from a list of full names and wasted hours manually copying them. I’m here to tell you there’s a better way for these and so many more of your real world struggles in Excel. Welcome to Smart Tips: Excel! In this course I’ll provide short lectures to help you do something new - fast, so that you can immediately apply it to your work or life. The videos in this course are standalone. That means you don’t have to watch in any particular order. If you’re searching for a specific skill or topic that’s relevant for you, take a look through the available tips to find the knowledge you need when you need it. My name is Alex Mozes, and I’m Director of Business Operations at Udemy. Before joining Udemy, I was a Microsoft Certified Master Instructor, and spent my time teaching people around Silicon Valley the secrets of Excel. In this course, I share some of my best tips to help you become more productive and efficient with your spreadsheets. I’ll teach you things like how to calculate dates, the master rule for all Excel functions, and how to teach the autofill tool common patterns you use in your business. We’ll cover tips in calculations, formatting, Excel tools, setting up spreadsheets, managing lists, data analysis and more. All of these tips are designed to help you increase your productivity and become an Excel whiz. And, if there’s a time consuming activity in Excel you struggle with, let me know in the Q&A section.
- Become more productive with Microsoft Excel
- Master calculations in excel with a master rule for all functions
- Simplify formatting to quickly create professionally formatted spreadsheets
- Discover useful tools like autofill, sparklines, and goal seek
- Use charts, pivot tables, and other tools to manage lists and analyze data
Temario
UNIDAD 1 - Introduction · 1 leccionesUNIDAD 1 - Introduction
UNIDAD 1 - Introduction
- Introduction to Smart Tips: Excel
UNIDAD 2 - Calculations · 13 leccionesUNIDAD 2 - Calculations
UNIDAD 2 - Calculations
- Calculate Dates: How many DAYS old are you?
- The master rule for all functions
- Text functions: Left, Mid, and Right
- More Text Functions
- Concatenate: Put multiple values into the same cell
- Break up your text strings with Text to Columns
- What are the Dollar signs in formulas? Absolute vs. Relative References
- Advanced functions made easy: Nesting functions
- Track the variables and consequences of your formulas with arrows
- Find the error in your complex formula by watching each step
- Expose the guts of a spreadsheet and show formulas in cells
- Name your ranges and simplify your formulas
- Linking data from one place to another
UNIDAD 3 - Formatting · 8 leccionesUNIDAD 3 - Formatting
UNIDAD 3 - Formatting
- Customize your date format
- Insert Rows and Columns Properly
- Autofit columns, wrap and shrink text to see your data better
- Understand trends at a glance with Conditional Formatting
- Save a custom style for common formats
- The risks and rewards of the Merge Cells tool
- Fun with borders
- Quickly copy formatting to one or multiple cells
UNIDAD 4 - Useful Tools · 14 leccionesUNIDAD 4 - Useful Tools
UNIDAD 4 - Useful Tools
- Secrets of the Autofill tool
- MORE Secrets of the Autofill tool: Creating custom lists
- Rotate your data with Transpose
- Goal Seek: Let Excel find the optimal value
- Format Shortcuts to make short work of your spreadsheet
- Scenario manager: Save your "what if" values
- Data validation: Add dropdown menus and error messages to a cell
- Solver: The Ultimate Add-on for complex questions
- How Big is Excel? Journey to the edge!
- Add, multiply or divide a set of data without a formula
- Sparklines: Quick reference trendlines for your data
- Add a slider to control numbers on your spreadsheet
- Save your filters and view settings with custom views
- Consolidate multiple tables into one
UNIDAD 5 - Managing Lists · 4 leccionesUNIDAD 5 - Managing Lists
UNIDAD 5 - Managing Lists
- Why and how to format a list as a table
- Quickly add automatic subtotals
- Remove duplicates with ease
- What is an Advanced Filter?
UNIDAD 6 - Setting Up a Spreadsheet · 4 leccionesUNIDAD 6 - Setting Up a Spreadsheet
UNIDAD 6 - Setting Up a Spreadsheet
- Lock your headers when reading large data sets with Freeze Panes
- Protect your data from meddling
- Scroll in multiple directions at once
- Secrets to printing data from a spreadsheet
UNIDAD 7 - Data Analysis · 10 leccionesUNIDAD 7 - Data Analysis
UNIDAD 7 - Data Analysis
- 6 Minutes to Master Pivot Tables
- Change how a pivot table calculates data
- A fun way to filter: The Drill To feature in Pivot Tables
- 7 minutes to creating Excel charts
- Showing data at different scales on the same chart
- Fun with Pie Charts
- Pivot Charts - The ultimate in dynamic data analysis
- Use the Slicer tools for convenient Pivot Tables
- Create a dashboard: add multiple Pivot Tables to the same sheet
- Make a custom, fancy chart in one click
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
7 unidades con videos, lecturas y actividades, disponibles 24/7 durante 12 meses.
- 3
Cuestionarios por unidad
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
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 Alex Mozes.
- 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.
- 7 unidades · 54 lecciones · 35 h
- 12 meses de acceso
- 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 Alex Mozes; 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.
