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

Видео Top 10 Excel formulas for IT people канала Chandoo