Data Analysis with Excel 📈📉📊✅ - Top 10 Excel formulas for IT people

🏆 Are you AND(“In IT”, “Use Excel”)? Then this video is for you. Here is my list of top 10 Excel formulas for people in IT. As software miners use Excel differently than other folks, this video highlights important use cases for you. These examples will particularly help project managers, IT analysts, testing people and business analysts. 👉👉👉Don’t forget to download the example workbook from here: https://chandoo.org/wp/top-10-excel-formulas-for-it-people/ Timestamps for the 10 formulas: 0:00 Intro 1:03 Counting values between dates 3:14 Lookup an item 5:12 Gap between two dates 7:34 Working days between two dates 9:46 nth smallest item 11:33 Moving averages 12:58 Extract portions from text 16:14 Combine text values 17:30 Make random data 20:25 Avoiding errors Got a suggestion or question? Please post them in the comments. #ExcelforITPeople #TopExcelFormulas