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
14 March 2020 Excel VBA Code for VLOOKUP Click here to download the workbook which contains the below code Copy below code and edit below VBA code as per[….] 000000
5 March 2020 Excel Date and Time Functions Online Exam To Learn more on Excel Date and Time functions click here. 000000
1 March 2020 EXCEL Lookup & reference functions practice test To Learn more on Excel Logical and Reference functions click here. 000000
20 September 2019 Excel VBA Code to Change Fonts in Specific Range Click here to download the workbook which contains the below code Copy below code and paste it in the VBA Code[….] 111001
