93 подписчиков
53 видео
Use of Countif Function - How to count cells in a range with a condition / Criteria
Macro to add / create a new sheet in an excel file and rename sheet using Inputbox option in VBA.
How to console / Merge multiple text files into one text file using command prompt / DOS / CMD
How to use SUMIFS function, sums a selected range with multiple criteria's / conditions
Copy all files and folders name in text file using DIR command in command prompt /CMD
Microsoft Excel different files formats with extension and their uses
Create aging / bucketing using custom aging function in excel, ready made solution available
Automate Excel sheet using Vlookup & IFERROR FUN,enter the key field others fields will populate
Run Macro on any excel file by just storing your MACRO in Personal Workbook/Use of personal workbook
Consolidate / Merge Multiple workbooks / sheets in single Workbook / sheet using Excel VBA MACRO
Most Commonly/frequently used top five excel Shortcut Keys
Drop Down List in Excel / data validation and its uses, how to convert range into table in excel
VBA Macro to delete Sheet in a workbook by entering sheet name in box
Change date format using Text Function
Use of Macro to Un-merge / Split data from single excel sheet into Multiple excel sheet using VBA
Convert date in Financial Year using Function created in vba,Enable Function To Work in all workbook
Count with multiple condition using countifs function, how to use countifs Function
Count duplicate values using countIF function / Use of CountIF function to check duplicate values
Combine text and dates using Concatenate (& Operator ) and Text Function
How to SPLIT a big file of any format using WINZIP split Option and send it through email to user.
Count duplicate values using IF Function when you are working on a lakhs of excel rows & columns
Concatenate function used with text function, joins two or more text / numbers into one
Use Find & Select option to Find Comments, Data validation or Formulas using Find & select option
Copy file names and folder names using VBA Excel MACROS / 5 line macro to copy file and folder names
VBA Macro to merge/ console multiple Sheets in a single sheet in a workbook using for each next loop
How to highlight duplicate cells in a range using conditional formatting
Convert number into aging/bucketing by creating FUNCTION in VBA.Enable FUNCTION to work in all files
