#excel #education #pc #accounting #computers #TallyERP9 #online #Excel Excel , Microsoft Excel, Excel Tutorials, Education , Data analytics, Data Science , Engineering , MIS Reports , MIS Jobs , MIS Executives, Computer Jobs , computer in hindi , Tally ERP, Accounting #indian #urdu #UttarPradesh #lucknow | Excel Tips & Tricks

Importing Data From Web Step 1 − Copy the web address. Step 2 − Open a new blank workbook in Excel. Step 3 − Click the DATA tab on the Ribbon. Step 4 − Click from web option paste the web address. Step 5 − Select the right table and load it. . . . . #excel #exceltips #exceltricks #spreadsheets #dailyupdates #tipsandtricks #shortcuts #excelworld #reelsinstagram #microsoftexcel #tutorial #workhack | Excel_your_day

Descriptive & Diagnostic Analytics via Formulas in Microsoft #Excel 365 1. What is the Net Sales amount for last occurrence of Ahmed? =XLOOKUP("Ahmed",Data[Sales Persons],Data[Net Sales],,,-1) 2. From all the sales Rahim made, which one is highest? =MAX(FILTER(Data[Net Sales], (MAX(Data[Net Sales]))*("Rahim"=Data[Sales Persons]))) 3. What is the Total Net Sales made by Rahim? =SUM(FILTER(Data[Net Sales],Data[Sales Persons]="Rahim")) 4. From all the sales Rahim made, on which occurrence did he ma

❌No copies las fórmulas de esta manera! Mejor hazlo así ✅😎 #excelpro #microsoftoffice #empleos #excelprofesional | Aprende Excel desde Cero