Microsoft Excel 2019 CELL Function & INFO Formula, Advanced Excel 2019 Tutorial

Excel CELL Function & INFO Formula, Advanced Excel Formula Tips & Tricks 2019. INFO and CELL functions are both categorized as information function. INFO formula gives information about the current platform while cell gives info about current cell.
This advanced functions tutorial is applicable to excel 2019, excel 2016 and ms excel 2013 as well.

Checkout Some Other Cool Excel Tutorials:

❌❌❌❌❌❌❌❌❌

✔️20 TEXT Functions and String Formulas (Replace in Excel) https://youtu.be/2Cxkua3i8dY

✔️17 Advanced Excel Essentials Math Functions & Formulas https://youtu.be/gvCbSZMd6XE

✔️10 Statistical Functions & Formulas https://youtu.be/TQCtSsK2_Lk

✔️VLOOKUP & HLOOKUP:(Complete Tutorial With Examples) https://youtu.be/GeZ3PKhC_2c

✔️20 Excel 2020 Cool Features & Skills, [Applicable to Excel 2016] https://youtu.be/S_fEnW5OeUM


❌❌❌❌❌❌❌❌❌

✔️Excel TRIM Function, How to Remove Empty Spaces, Advanced Excel Tips and Tricks 2020 https://youtu.be/VsJNR1nq_sg

✔️How to Create Dynamic Drop Down list in Excel https://youtu.be/p8Bu93M7JKo

✔️CONCATENATE Function, Combine Data In Excel https://youtu.be/TYzn7xZ6oAE

✔️CONCAT Function & TEXTJOIN Function To MERGE Data
From Different Cells https://youtu.be/sq9Xn0F_yfU

✔️UPPER, LOWER & PROPER Functions: Learn Excel String Functions ? https://youtu.be/w0xu4PW9lRo

✔️INDIRECT Function, Cell References From Multiple Worksheets, https://youtu.be/Pk9Ng172AIU

✔️MATCH Data With Match Function & Array Formulas, Use CTRL + SHIFT + ENTER with Complex LOOKUPS https://youtu.be/eb6hVBly6Nk

✔️Regression Analysis TREND Function And GROWTH Function For Data Analysis in Excel 2020 ( 365 ) https://youtu.be/oHqYlRyL5SU

✔️TRANSPOSE Function, CTRL + SHIFT + ENTER To Flip Rows and Columns Data, https://youtu.be/XEEteYjIlDk

✔️Excel Frequency Distribution & Table With Frequency Function, https://youtu.be/KS6nCkJmLHI

✔️Count Unique Entries Using CTRL + SHIFT + ENTER, https://youtu.be/zDUh33TAVDQ

✔️Array Formula Examples, Use CTRL + SHIFT + ENTER, https://youtu.be/bqMupa1Nh2A

✔️EOMONTH & EDATE Functions, Calculate Maturity Dates and Due Dates, https://youtu.be/9bKUe0KhAwI

✔️MS Excel WORKDAY Function,Exclude Holidays & Weekends, WORKDAY Formula, https://youtu.be/WvQIXp-1wsk

✔️How To Insert Date and Time in Excel 2020 (Mathematical Method) https://youtu.be/KoVtvgBrOF0

✔️Aggregate Function & Formula To Bypass Errors & Hidden Data, https://youtu.be/Ssh9NAXVpKY

✔️MOD Function and Formula, How To Use The MOD With Examples, https://youtu.be/5xaREg9MR2E

✔️CountIFs, SumIFs, AverageIfs, MaxIFs, MiniFs, SubTotal https://youtu.be/kKyaVgWGloI

❌❌❌❌❌❌❌❌❌

-~-~~-~~~-~~-~-
Please watch: "How to Calculate Age from Date of Birth in Excel in Years Months and Days (Simple Formula)"
https://www.youtube.com/watch?v=Jy-EO724its
-~-~~-~~~-~~-~-