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…..
Category: MS Office 365
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….
Editable Grid using Gallery and Modern controls in Power apps
Requirement: Power apps editable grid using Gallery and Modern controls Create a SharePoint list “Employee List Grid”, Create columns as shown in below Now Create a Blank canvas app. enable….
Adding Emojis to the Text label In Power apps, SharePoint, and Power automate.
When User want emoji for the text or button to look it more impressive. There are 2 ways for this. Step1: click on Windows logo key (🪟) + greater than….
Employee progress in Excel sheet using IF Function
Requirement: Employee Progress Increasing or not using IF function in Excel sheet Create a Excel sheet, Provide three columns, Employee name, Employee Work Progress and Yes/ No. Calculating Work Progress….