Soluții
How to Use the ARRAYFORMULA Function in Google Sheets
How many times have you created a formula and copied it to the adjacent cells in your sheet? In Google Sheets, you can skip this step by using the ARRAYFORMULA function. With ARRAYFORMULA in Google Sheets, you can return several values instead of just one. This lets you combine the function with others like SUM, SUMIF, IF, and more to obtain results for an entire cell range.
[mai mult...]How to Use the scp Command on Linux
The scp command makes copying files between Linux computers easy and secure. It uses SSH security, but best of all, it is simple. If you can use cp, you can use scp.
How to Start or Join a Google Meet From Docs, Sheets, or Slides
Have you ever wanted to start a quick video meeting while reviewing a document? You can start or join a Google Meet directly from Google Docs, Sheets, or Slides. Then, present your document or simply join and keep working.
[mai mult...]How to Sort by Color in Microsoft Excel
Using Microsoft Excel’s sorting feature, you can sort your cells that are either manually colored or conditionally colored by their color. This works for multiple colors and we’ll show you how to implement it in your spreadsheets. With the feature, you can place the cells containing a specific color at the top or the bottom of the list. For example, you can place all your green-colored cells at the top while keeping all the red ones at the bottom.
[mai mult...]How to Get Currency Exchange Rates in Microsoft Excel
If you use Microsoft Excel for financial data where exchange rates are part of what you need, check out the Currencies data type. This gives you various exchange details that you can include in your spreadsheet.
You can obtain the last trade time, high and low, change percent, and more by entering a pair of ISO currency codes. Then, simply select the details you want to include and refresh the data as needed. As of May 2022, the feature is only available to Microsoft 365 subscribers.
[mai mult...]