Excel Help Page
Purpose of this page to Learn & Teach Excel & VBA With easy Way.
17/02/2024
Running Total In SQL From This video you can learn running total in SQL.SELECT * FROM SALEDATA2SELECT *, SUM(SALE_AMOUNT) OVER(ORDER BY SALE_DATE) AS running_total FROM SALEDATA2...
01/09/2023
https://www.youtube.com/watch?v=quCRJ3LsPAs
MIS Interview Series Q31 Use of IF & OR Function MIS Interview Series Q31 Use of IF & OR Function=IF(OR(LEFT(A1,1)="a",LEFT(A1,1)="e",LEFT(A1,1)="i",LEFT(A1,1)="o",LEFT(A1,1)="u"),"Start With Vowel","Start ...
02/04/2023
How To Use SUM, SUMIF, SUMIFS & Subtotal In Excel How To Use SUM, SUMIF, SUMIFS & Subtotal In ExcelSupporting File.https://docs.google.com/spreadsheets/d/1MB4eoWztCo8_UgPTGruH7GBhXK0Ft6TC/edit?usp=sharing&o...
26/03/2023
MIS Excel VBA Macro Tricks 3 UDF MIS Excel VBA Macro Tricks 3 UDFFunction TOTAL(a As Integer, B As Integer)TOTAL = a + BEnd Function----------------------------------------------------------...
22/03/2023
MIS Excel VBA Macro Tricks 2 MIS Excel VBA Macro Tricks 2Sub VBA_tips2()For Each cell In Selectioncell.Value = cell.Value & vbNewLine & Range(cell.Address).Offset(1, 0).ValueNext cellEnd...
11/03/2023
MIS VBA Macro Tricks - 1 - video Dailymotion Watch MIS VBA Macro Tricks - 1 - RAKESH KUMAR on Dailymotion
11/03/2023
MIS-Interview Series-Q28 (Making Folder with VBA Macro coding) VBA macro coding for making some folder in a folder.Sub Making_folder()For Each cell In SelectionMkDir "D:\Mar2023\" & cell.ValueNext cellEnd SubSupporting f...
26/02/2023
MIS Interview Series Q27 New Sheet with VBA Macro code Excel VBA MacroInterview question.Supporting file.https://drive.google.com/file/d/1xpAvI8reg--sh2cTZjFJ4JbFosIRCHHP/view?usp=sharing
25/09/2022
MIS Interview Question Paper Set 3 MIS Interview Question Paper Set 3https://docs.google.com/spreadsheets/d/1zYdqyS9Wf8u2r5yst4sx0htrlr3Kg8Qq/edit?usp=sharing&ouid=108365514073073043927&rtpo...
10/09/2022
MIS Interview Question Paper Set 3 MIS Interview Question Paper Set 3
21/08/2022
Excel Pivot Table Series Part 2 Excel Pivot Table Series Part 2
14/08/2022
Excel Pivot Table Series Part -1 Excel Pivot Table Series Part -1From this video you can learn how to use pivot table in excel.
08/05/2022
MIS-Interview Series-Q25 (Use of Sumifs, Choose, Eomonth & Date Function) MIS-Interview Series-Q25 (Use of Sumifs, Choose, Eomonth & Date Function)Quarterly Reportsupporting file linkhttps://docs.google.com/spreadsheets/d/1PzN7_7yb...