Useful tips for everyday
How do I temporarily disable conditional formatting in Excel? To remove conditional formatting from specific cells, select the cells, click the Quick Analysis button, and…
Can you edit a GitHub gist? We can edit, delete, unsubscribe, star, embed, copy, share, and download a raw copy or zipped copy of a…
How do I find and replace in a Google script? Use find and replace in a spreadsheet On your computer, open a spreadsheet in Google…
How do I convert a date to a Monday in Google Sheets? Google Sheets WEEKDAY function – Syntax [type] – This argument allows you to…
How do I sort only certain columns in Google Sheets? To sort a range: Click Data and select Sort range from the drop-down menu. The…
How do I bypass unrecognized devices on Gmail? Open the Google Account Settings > Security > 2-Step Verification and click on the Turn off button.…
How do you create a running subtraction formula in Excel? Subtract numbers using cell references Type a number in cells C1 and D1. For example,…
How do you calculate profit and loss percentage? What is the Profit and Loss Percentage Formula? The formula to calculate the profit percentage is: Profit…
Are string literals enclosed in double quotes? Strings are sequences of characters and are enclosed with quotes. Strings can either be enclosed in single quotes…
What is the Command for Save As on a Mac? Shift-Command-S: Display the Save As dialog, or duplicate the current document. What is the Ctrl…