Del curso: Excel 2016: Advanced Formulas and Functions
Únete hoy para acceder a más de 23.100 cursos impartidos por expertos del sector.
Next steps
“
- After viewing this course, you might be saying, "What's up next, what else "do I need to learn about Excel?" If you go to Lynda.com, you'll find many courses on this software, including charts, formatting, pivot tables, tips and tricks, Excel 2016 Essentials, quite a few others. Most Excel courses are identified by the Excel version, 2016, 2013, 2010, and many of them explore additional features related to topics covered in this course. Be sure to check back often, as new courses are continually being released. I hope this course has been beneficial to you. Thank you for watching.
Practica mientras aprendes con los archivos de ejercicios.
Descarga los archivos que el instructor utiliza para enseñar el curso. Sigue las instrucciones y aprende viendo, escuchando y practicando.
Descarga los ejercicios de este curso.
Empieza hoy mismo con un periodo de prueba gratis.
Descarga cursos y fórmate estés donde estés
Ve cursos en tu dispositivo móvil sin conexión a Internet. Descarga cursos con la aplicación de LinkedIn Learning para iOS o Android.
Ve este curso en cualquier momento y lugar.
Empieza hoy mismo con un periodo de prueba gratis.
Contenido
-
-
Displaying and highlighting formulas4 min 43 s
-
Using Auditing tools6 min 15 s
-
Using entire row and column references4 min 4 s
-
Copying column formulas instantly2 min 45 s
-
Converting formulas to values with a drag4 min 59 s
-
Updating values without formulas3 min 26 s
-
Debugging formulas with the F9 key4 min 2 s
-
(Bloqueado)
Enhancing readability with range names5 min 23 s
-
(Bloqueado)
Tabulating data from multiple sheets8 min 20 s
-
-
-
(Bloqueado)
Hierarchy of operations in formulas6 min 28 s
-
(Bloqueado)
Formulas tab for locating functions5 min 34 s
-
(Bloqueado)
Insert Function for learning about unfamiliar functions5 min 20 s
-
(Bloqueado)
Extending the capabilities of AutoSum6 min 10 s
-
(Bloqueado)
Absolute and relative references5 min 4 s
-
(Bloqueado)
Using mixed references in formulas6 min
-
(Bloqueado)
Using autocalculate in the status bar5 min 45 s
-
(Bloqueado)
-
-
(Bloqueado)
Looking up information with VLOOKUP and HLOOKUP4 min 30 s
-
(Bloqueado)
Finding approximate matches with VLOOKUP and HLOOKUP7 min 16 s
-
(Bloqueado)
Finding exact matches with VLOOKUP5 min 30 s
-
(Bloqueado)
Nesting lookup functions4 min 12 s
-
(Bloqueado)
Using VLOOKUP with large tables4 min 21 s
-
(Bloqueado)
Finding table-like information within a function using the CHOOSE function2 min 44 s
-
(Bloqueado)
Using the SWITCH function for formula-embedded selection5 min 40 s
-
(Bloqueado)
Locating data with the MATCH function3 min 43 s
-
(Bloqueado)
Retrieving information by location2 min 53 s
-
(Bloqueado)
Using MATCH and INDEX functions together4 min 14 s
-
(Bloqueado)
-
-
(Bloqueado)
Finding the middle value with MEDIAN and most common value with MODE2 min 21 s
-
(Bloqueado)
Ranking data without sorting with RANK and RANK.EQ4 min 8 s
-
(Bloqueado)
Finding the largest and smallest values with the LARGE and SMALL functions1 min 47 s
-
(Bloqueado)
Tabulating blank cells with the COUNTBLANK function5 min 29 s
-
(Bloqueado)
Using COUNT, COUNTA, and the status bar3 min 32 s
-
(Bloqueado)
-
-
(Bloqueado)
Working with the ROUND, ROUNDUP, and ROUNDDOWN functions6 min 13 s
-
(Bloqueado)
Working with MROUND, CEILING, and FLOOR for specialized rounding3 min 20 s
-
(Bloqueado)
Using the INT and TRUNC functions to extract integer data3 min 58 s
-
(Bloqueado)
Finding the remainder with MOD and using MOD with conditional formatting5 min 26 s
-
(Bloqueado)
Exploring practical uses for the RAND and RANDBETWEEN functions4 min 57 s
-
(Bloqueado)
Converting a value between measurement systems with CONVERT2 min 55 s
-
(Bloqueado)
Using the powerful AGGREGATE function to bypass errors and hidden data6 min 32 s
-
(Bloqueado)
Using the ROMAN and ARABIC functions to display different number systems3 min 25 s
-
(Bloqueado)
-
-
(Bloqueado)
Understanding Excel date and time capabilities in formulas9 min 52 s
-
(Bloqueado)
Using the DATE, YEAR, MONTH, DAY, TIME, HOUR, MINUTE, and SECOND functions4 min 4 s
-
(Bloqueado)
Using the TODAY and NOW functions for dynamic date and time entry6 min 49 s
-
(Bloqueado)
Identifying the day of the week with the WEEKDAY function4 min 40 s
-
(Bloqueado)
Counting working days with the NETWORKDAYS function5 min 26 s
-
(Bloqueado)
Determining a completion date with the WORKDAY function4 min 10 s
-
(Bloqueado)
Tabulating date differences with the DATEDIF function6 min 15 s
-
(Bloqueado)
Calculating end-of-month and future and past dates with EDATE and EOMONTH4 min 58 s
-
(Bloqueado)
-
-
(Bloqueado)
Extending formula capabilities with array formulas5 min 7 s
-
(Bloqueado)
Counting unique entries in a range with an array formula5 min 51 s
-
(Bloqueado)
Determining frequency distributions with the FREQUENCY function3 min 53 s
-
(Bloqueado)
Flipping row and column orientation with TRANSPOSE5 min 10 s
-
(Bloqueado)
Building analysis via regression techniques with TREND and GROWTH2 min 59 s
-
(Bloqueado)
Using array formulas and the MATCH function for complex lookups5 min 30 s
-
(Bloqueado)
-
-
(Bloqueado)
Locating and extracting data with the FIND, SEARCH, and MID functions6 min 20 s
-
(Bloqueado)
Extracting specific data with the LEFT and RIGHT functions3 min 22 s
-
(Bloqueado)
Using the TRIM function to remove unwanted spaces in a cell5 min 43 s
-
(Bloqueado)
Using ampersands and CONCATENATE to combine data from different cells5 min 51 s
-
(Bloqueado)
Using the CONCAT and TEXTJOIN to combine data from different cells6 min 8 s
-
(Bloqueado)
Adjusting alphabetic case with the UPPER, LOWER, and PROPER functions3 min 48 s
-
(Bloqueado)
Adjusting character content with the REPLACE and SUBSTITUTE functions5 min 41 s
-
(Bloqueado)
Using the utility text functions: TEXT, REPT, and LEN5 min 7 s
-
(Bloqueado)
-
-
(Bloqueado)
Extracting information with the CELL and INFO functions4 min 10 s
-
(Bloqueado)
Using ISBLANK, ISODD, ISEVEN, ISTEXT, ISNONTEXT, and ISNUMBER5 min 9 s
-
(Bloqueado)
Using the ISERR, ISERROR, IFERROR, and ISNA error-checking functions7 min 53 s
-
(Bloqueado)
Tracking and highlighting formula cells with the ISFORMULA function3 min 2 s
-
(Bloqueado)