Linkedin Learning Excel Advanced Formulas and Functions-ZH | Apps-Tutorials | MP4 | 696.55 MiB
995 kb/s 1280×720 | AAC 160 kb/s 2 CH
Zieg Heil
Linkedin.Learning.Excel.Advanced.Formulas.and.Functions-ZH
Title: Excel: Advanced Formulas and Functions
Publisher: Linkedin.Learning
Size: 697M (730382508 B)
Files: 15F
Date: 06/05/2020
Course #: Linkedin.Learning
Type: N/A
Published: April 1, 2019
Modified: N/A
URL: www.linkedin.com/learning/excel-advanced-formulas-and-functions
Author: Dennis Taylor
Duration: N/A
Skill: N/A
Exer/Code: [ ]
Installation:
Unpack that shit, run that shit
Of course we know its sieg heil, thats how fucking rebelious we are!
Description:
Follow along with Excel expert Dennis Taylor as he
demystifies the hundreds of formulas and functions available in
Excel. Dennis starts with a few critical formula shortcuts that
will speed up your work, then covers a variety of functions, such as
VLOOKUP, MATCH, and INDEX, statistical functions, text
functions, and date and time, math, text, and information
functions. Dennis provides practical examples to help viewers
easily transition to using
697M Excel - Advanced Formulas and Functions 4.6M Excel - Advanced Formulas and Functions/1.Introduction 4.6M Excel - Advanced Formulas and Functions/1.Introduction/01.Use the most powerful formulas and functions in Excel.mp4 104M Excel - Advanced Formulas and Functions/10.9. Text Functions 13M Excel - Advanced Formulas and Functions/10.9. Text Functions/51.Locate and extract data with FIND, SEARCH, and MID.mp4 9.0M Excel - Advanced Formulas and Functions/10.9. Text Functions/52.Extract data with the LEFT and RIGHT functions.mp4 10M Excel - Advanced Formulas and Functions/10.9. Text Functions/53.Use the TRIM function to remove unwanted spaces in a cell.mp4 8.2M Excel - Advanced Formulas and Functions/10.9. Text Functions/54.Combine data with symbols (&) and CONCATENATE.mp4 11M Excel - Advanced Formulas and Functions/10.9. Text Functions/55.Use CONCAT and TEXTJOIN to combine data from different cells.mp4 12M Excel - Advanced Formulas and Functions/10.9. Text Functions/56.Adjust alphabetic case with UPPER, LOWER, and PROPER.mp4 13M Excel - Advanced Formulas and Functions/10.9. Text Functions/57.Adjust character content with REPLACE and SUBSTITUTE.mp4 13M Excel - Advanced Formulas and Functions/10.9. Text Functions/58.Use utility text functions - TEXT, REPT, VALUE, and LEN.mp4 18M Excel - Advanced Formulas and Functions/10.9. Text Functions/59.Use the new LET function.mp4 45M Excel - Advanced Formulas and Functions/11.10. Information Functions 11M Excel - Advanced Formulas and Functions/11.10. Information Functions/60.Extract information with the CELL and INFO functions.mp4 9.7M Excel - Advanced Formulas and Functions/11.10. Information Functions/61.Explore various information functions.mp4 15M Excel - Advanced Formulas and Functions/11.10. Information Functions/62.Use several error-checking functions.mp4 9.5M Excel - Advanced Formulas and Functions/11.10. Information Functions/63.Track and highlight formula cells with ISFORMULA.mp4 1.7M Excel - Advanced Formulas and Functions/12.Conclusion 1.7M Excel - Advanced Formulas and Functions/12.Conclusion/64.Next steps.mp4 93M Excel - Advanced Formulas and Functions/2.1. Formula and Function Tips and Shortcuts 15M Excel - Advanced Formulas and Functions/2.1. Formula and Function Tips and Shortcuts/02.Display and highlight formulas.mp4 19M Excel - Advanced Formulas and Functions/2.1. Formula and Function Tips and Shortcuts/03.Use the auditing tools.mp4 8.1M Excel - Advanced Formulas and Functions/2.1. Formula and Function Tips and Shortcuts/04.Use entire row_column references.mp4 16M Excel - Advanced Formulas and Functions/2.1. Formula and Function Tips and Shortcuts/05.Change formulas to values and update values without formulas.mp4 11M Excel - Advanced Formulas and Functions/2.1. Formula and Function Tips and Shortcuts/06.Simplify debugging formulas with the F9 key.mp4 15M Excel - Advanced Formulas and Functions/2.1. Formula and Function Tips and Shortcuts/07.Enhance readability with range names.mp4 12M Excel - Advanced Formulas and Functions/2.1. Formula and Function Tips and Shortcuts/08.Create 3D formulas to tabulate data from multiple sheets.mp4 44M Excel - Advanced Formulas and Functions/3.2. IF and Related Functions 12M Excel - Advanced Formulas and Functions/3.2. IF and Related Functions/09.Explore IF logical tests and use relational operators.mp4 13M Excel - Advanced Formulas and Functions/3.2. IF and Related Functions/10.Create and expand the use of nested IF statements.mp4 14M Excel - Advanced Formulas and Functions/3.2. IF and Related Functions/11.Create compound logical tests with AND, OR, NOT, and IF.mp4 6.0M Excel - Advanced Formulas and Functions/3.2. IF and Related Functions/12.Use IFS for multiple conditions.mp4 121M Excel - Advanced Formulas and Functions/4.3. Lookup and Reference Functions 12M Excel - Advanced Formulas and Functions/4.3. Lookup and Reference Functions/13.Explore the VLOOKUP and HLOOKUP functions.mp4 14M Excel - Advanced Formulas and Functions/4.3. Lookup and Reference Functions/14.Find approximate matches with VLOOKUP and HLOOKUP.mp4 14M Excel - Advanced Formulas and Functions/4.3. Lookup and Reference Functions/15.Use VLOOKUP to find exact matches and search large tables.mp4 8.9M Excel - Advanced Formulas and Functions/4.3. Lookup and Reference Functions/16.Find table-like data within a function using CHOOSE.mp4 12M Excel - Advanced Formulas and Functions/4.3. Lookup and Reference Functions/17.Use the SWITCH function for formula-embedded selection.mp4 7.6M Excel - Advanced Formulas and Functions/4.3. Lookup and Reference Functions/18.Locate data with the MATCH function.mp4 7.0M Excel - Advanced Formulas and Functions/4.3. Lookup and Reference Functions/19.Retrieve information by location with the INDEX function.mp4 11M Excel - Advanced Formulas and Functions/4.3. Lookup and Reference Functions/20.Use the MATCH and INDEX functions together.mp4 6.4M Excel - Advanced Formulas and Functions/4.3. Lookup and Reference Functions/21.Document formulas with the FORMULATEXT function.mp4 16M Excel - Advanced Formulas and Functions/4.3. Lookup and Reference Functions/22.Extract and count unique entries from a list with UNIQUE.mp4 15M Excel - Advanced Formulas and Functions/4.3. Lookup and Reference Functions/23.Use the XLOOKUP function.mp4 44M Excel - Advanced Formulas and Functions/5.4. Power Functions 12M Excel - Advanced Formulas and Functions/5.4. Power Functions/24.Tabulate data using a single criterion with COUNTIF, SUMIF, and AVERAGEIF.mp4 11M Excel - Advanced Formulas and Functions/5.4. Power Functions/25.Tabulate data using multiple criteria with COUNTIFS, SUMIFS, and AVERAGEIFS.mp4 7.1M Excel - Advanced Formulas and Functions/5.4. Power Functions/26.Use MAXIFS and MINIFS.mp4 15M Excel - Advanced Formulas and Functions/5.4. Power Functions/27.Use the SUBTOTAL function to prevent double counting.mp4 48M Excel - Advanced Formulas and Functions/6.5. Statistical Functions 8.1M Excel - Advanced Formulas and Functions/6.5. Statistical Functions/28.Find middle and most common values with MEDIAN and MODE.mp4 11M Excel - Advanced Formulas and Functions/6.5. Statistical Functions/29.Rank data without sorting using RANK and RANK.EQ.mp4 4.8M Excel - Advanced Formulas and Functions/6.5. Statistical Functions/30.Find the largest and smallest values with LARGE and SMALL.mp4 16M Excel - Advanced Formulas and Functions/6.5. Statistical Functions/31.Tabulate blank cells with the COUNTBLANK function.mp4 9.0M Excel - Advanced Formulas and Functions/6.5. Statistical Functions/32.Use COUNT, COUNTA, and the status bar.mp4 85M Excel - Advanced Formulas and Functions/7.6. Math Functions 15M Excel - Advanced Formulas and Functions/7.6. Math Functions/33.Work with the ROUND, ROUNDUP, and ROUNDDOWN functions.mp4 7.3M Excel - Advanced Formulas and Functions/7.6. Math Functions/34.Use MROUND, CEILING, and FLOOR for specialized rounding.mp4 7.8M Excel - Advanced Formulas and Functions/7.6. Math Functions/35.Use INT, TRUNC, ODD, and EVEN for specialized rounding.mp4 12M Excel - Advanced Formulas and Functions/7.6. Math Functions/36.Use MOD to find remainders and apply conditional formatting.mp4 14M Excel - Advanced Formulas and Functions/7.6. Math Functions/37.Explore practical uses for RAND, RANDARRAY, and RANDBETWEEN.mp4 8.0M Excel - Advanced Formulas and Functions/7.6. Math Functions/38.Convert a value between measurement systems with CONVERT.mp4 14M Excel - Advanced Formulas and Functions/7.6. Math Functions/39.Use the AGGREGATE function to bypass errors and hidden data.mp4 8.3M Excel - Advanced Formulas and Functions/7.6. Math Functions/40.Use ROMAN and ARABIC to display different number systems.mp4 80M Excel - Advanced Formulas and Functions/8.7. Date and Time Functions 9.9M Excel - Advanced Formulas and Functions/8.7. Date and Time Functions/41.Understand Excel date and time capabilities in formulas.mp4 12M Excel - Advanced Formulas and Functions/8.7. Date and Time Functions/42.Use various date and time functions.mp4 12M Excel - Advanced Formulas and Functions/8.7. Date and Time Functions/43.Use the TODAY and NOW functions for date and time entry.mp4 9.0M Excel - Advanced Formulas and Functions/8.7. Date and Time Functions/44.Identify weekdays with the WEEKDAY function.mp4 9.5M Excel - Advanced Formulas and Functions/8.7. Date and Time Functions/45.Count working days and completion dates (NETWORKDAYS and WORKDAY).mp4 14M Excel - Advanced Formulas and Functions/8.7. Date and Time Functions/46.Tabulate date differences with the DATEDIF function.mp4 14M Excel - Advanced Formulas and Functions/8.7. Date and Time Functions/47.Calculate dates with EDATE and EOMONTH.mp4 31M Excel - Advanced Formulas and Functions/9.8. Reference Functions 8.7M Excel - Advanced Formulas and Functions/9.8. Reference Functions/48.Get data from remote cells with the OFFSET function.mp4 8.5M Excel - Advanced Formulas and Functions/9.8. Reference Functions/49.Return references with the INDIRECT function.mp4 14M Excel - Advanced Formulas and Functions/9.8. Reference Functions/50.Use INDIRECT with Data Validation for multitiered pick lists.mp4 697M total
File: 01.Use the most powerful formulas and functions in Excel.mp4 Size: 4767404 bytes (4.55 MiB), duration: 00:00:38, avg.bitrate: 1004 kb/s Audio: aac, 48000 Hz, stereo (und) Video: h264, yuv420p, 1280x720, 30.00 fps(r) (eng)
Download Linkedin Learning Excel Advanced Formulas and Functions-ZH ( Size: 696.55 MiB ) :
Keywords: Linkedin, Learning, Excel, Advanced, Formulas, and, Functions
http://nitroflare.com/view/75F9B841A78FBD4/bcdhjLiLeExAdFoanFuZH.zip
http://rapidgator.net/file/44c75932208fe10d3f1cb06993a73bea/bcdhjLiLeExAdFoanFuZH.zip.html