14 May 2021 How to use Excel Filter Function Quick view of Excel Filter Function Explanation: We have filtered Sales man name, Sales Amount, Department (entire data) based on[….] 000000
22 March 2021 How to Create Excel Student Tracker Macro Click Here to download the Student Tracker File Created with 2 Sheets in 1 Workbook Sheet1 Renamed as “Entry Form”[….] 000000
25 November 2020 How to use the SEQUENCE function in Excel What are the uses of SEQUENCE function in Excel What are the uses of Excel SEQUENCE Function Definition of SEQUENCE[….] 000000
12 July 2020 Excel get user details of who open and close specific Excel file Macro Requirement The macro requirement is if some one opens specific excel file then we need to get the name[….] 000000
12 July 2020 Excel VBA code to data consolidation from multiple sheets Excel VBA code to consolidate data from the multiple sheets in one single Excel file How the Excel macro works[….] 000000
26 April 2020 Excel VBA code to Create Folders and Sub Folders Click here to download the workbook used in the below example. Copy below code and edit as per your requirement.[….] 000000
10 April 2020 Excel How to use OFFSET function Click here to download the Excel workbook which contains the below examples. Description OFFSET Function: Returns a reference to a[….] 000000
5 April 2020 Excel VBA code to remove duplicates Click here to download the workbook which contains the code Excel VBA code to Remove Duplicates Result Screen Print Copy[….] 000000
