Search Users
Requirement: Check whether the User is invalid or not in Organization using MS Excel (User list) When we have plenty of users in a list, it’s hard to find who….
Category: MS Excel
Import data from an Image in Excel
Requirement: How to Import data from an Image in Excel Want to add an Image in Excel without making Copy Paste of the Screenshot, so now go to the Office….
Converting Numbers to Roman Numerals
How to Convert Numbers to Roman Numerals using the function in Excel. Converting numbers to Roman numerals instead of typing manually use the function
Translate Text with functions in Excel
Requirement: Translating Text with the functions using the language code For Translating Text from one language to other using google translate in excel Do the same Process for remaining cells…..
Formatting Email ID’s to copy into Outlook from Excel
Requirement: Format cells to combine and copy into outlook using Excel Instead of selecting one by one email id to copy and paste in outlook, use COUNTIF formula as Textjoin….
Summing all of Criteria Sales in Excel
Requirement: Sum all of Criteria sales in excel sheet Sum- Sums cells that meet a criteria, Range- range to apply criteria to, Criteria- criteria to apply. It Sums the Sales….
Pull Language, Currency code, and Flag from value Country in Excel
Requirement: Pull the Data type values in excel Language, code, flag values from Country value Create Table, Select Data tab then click on Data types , select Country Column and….
Conditional Checkbox in Google sheet
Requirement: Formatting each completed task using conditional checkbox in Google sheet Create a google sheet, Click on Format tab, Select Conditional formatting, Then add the cell by selecting them, now….
How to Filter data in Table in Array
Requirement: Filter data in Table using Array in Excel To Filter data from one table to another, which had a collection of strings to get filtered, as the Name enter….
In Excel how to Sort data in Array
Requirement: Sort Data in Array Sorting collection of string in array using the sort function in excel list. By using the above formula Sales column Order were changed to Descending….