Isticmaalayaal badan oo Google^{(Google Sheets)} -ka ah ayaa waqti aad u badan ku bixiya hawlo fudud. Tani waxay u badan tahay sababtoo ah ma yaqaanaan qaar ka mid ah hababka ugu waxtarka badan Google Sheets . Foomamka ayaa halkan u jooga si ay noloshaada u fududeeyaan, u dedejiyaan hawsha, ugana saaraan khaladaadka bini'aadamka.

Aynu eegno 10 ka mid ah qaaciidooyinka ugu waxtarka badan ee ku jira Google Sheets kuwaas oo loogu talagalay inay ku badbaadiyaan wakhtiga.

Dejinta Formula

Isticmaalka qaacido ee xaashida Google^{(Google Sheets)} waa sahlan tahay. Sanduuqa qoraalka, kaliya ku qor "=" oo ay ku xigto qaacidada aad rabto inaad isticmaasho. Waa inuu jiraa sanduuq yar oo calaamad su'aal ah oo soo baxaya markaad ku qorayso qaacido. Dooro sanduuqa si aad wax badan uga ogaato isticmaalka caanahaas.

Tusaale ahaan, haddii aan ku qorno "= add(" waxaan baran doonaa wax badan oo ku saabsan sida loo isticmaalo shaqadan. Sheets waxay noo sheegaysaa inay soo celiso wadarta laba lambar oo aan u qaabayn karno annaga oo ku daraya qiimaha 1, comma, ka dibna qiimaha 2 ee qawlka dhexdiisa.

Taas macneheedu waxa weeye in ku qorida " =add (1,3)" ay ku celiso jawaabta 1+3.

Halkii aad ku qori lahayd "1" iyo "3", waxaan sidoo kale tixraaci karnaa unugyada xaashida^(Sheets) . Marka lagu daro magaca unugga (oo lagu tilmaamay tiirka uu raacayo safka), Xaashiyaha^(Sheets) ayaa si toos ah u fulin doona qaacidada unugyadaas la siiyay.

Markaa, haddii aan ku qorno "= add (B3,C3)", qiyamka unugyada B3 iyo C3 ayaa lagu dari doonaa. Waxay ina siinaysaa jawaab isku mid ah. 

Habkani waxa uu u shaqeeyaa badi qaacidooyinka qaybaha soo socda.

10 Foomamka waxtarka leh^{(Helpful Formulas)} ee ku jira xaashida Google^{(Google Sheets)} -ka si ay kuu badbaadiyaan waqti

Kuwa soo socdaa waa 10 ka mid ah qaaciidooyinka ugu waxtarka badan ee Google Sheets si ay kuu badbaadiyaan wakhtiga. Waxaa jira qaabab badan oo qarsoodi ah oo xaashida ah^{(hidden Sheets formulas)} oo ku caawin kara, laakiin kuwani waa kuwa isticmaaluhu maalin walba isticmaali karo oo uu ka faa'iidaysan karo.

1. Geli jadwalka taariikhda maanta ()^{(Ditch the Calendar with TODAY())}

Waxay dareemeysaa inaan is weydiineyno "waa maxay taariikhda maanta?" maalin kasta. Xaashiyaha^(Sheets) , waxay ku noqotaa arrin xitaa ka sii weyn - la socoshada waqtiyada kama dambaysta ah iyo tirinta taariikhaha waxay u baahan tahay cusbooneysiin maalinle ah. Taasi waa, ilaa aad isticmaasho maanta (^(TODAY) ) shaqada.

Ka dib markaad geliso qolka, waxaa kuu hadhay taariikhda maanta. Maalin walba way cusboonaataa oo kaagama baahna inaad wax samayso.

Excel waxa uu leeyahay tiro dhan oo kala duwan oo la dhisay taariikhda iyo qaacidooyinka waqtiga. Tani waxay fududaynaysaa in la helo farqi u dhexeeya laba taariikhood. Shaqada MAANTA^(TODAY) () , waxaad yeelan kartaa isbeddel joogto ah oo labaad.

2. COUNTIF () Waxay ka dhigtaa tirinta shuruudaysan^{(Makes Conditional Counting Easier)}

Xaashiyaha sidoo kale waxay kuu ogolaanayaan inaad sameyso wax yar oo kood ah adoo isticmaalaya waxa loo yaqaan "tirinta shuruudeed". Tani waa marka aad tiriso shay kaliya haddii uu ku dhaco shuruudaha qaarkood.

Tusaale ahaan, haddii aad rabto in aad ogaato inta ka mid ah ka qaybgalayaasha sahanka ay leeyihiin laba ama ka badan baabuur, waxaad isticmaali kartaa bayaanka COUNTIF^(COUNTIF) (). 

Xaaladdu waxay noqonaysaa qiimo ka weyn ama la mid ah laba.

Adigoo aan isticmaalin qaaciidadan, waa inaad gacanta ku sawirtaa xogta oo aad hesho lambarka aad raadinayso. 

Waxaa jira hawlo kale oo IF ah oo sidan oo kale ah oo aad isticmaali karto sidoo kale sida SUMIF , AVERAGEIF, iyo in ka badan^{(AVERAGEIF, and more)} .

3. Ku dar unugyo leh SUM()

Mid ka mid ah hawlaha aan jecelnahay waa shaqada SUM (). Waxay isku daraysaa dhammaan tirooyinka gudaha tiro la doortay. Wadarta guud waa tirooyin tirooyin ah oo la isku daray. Tusaale ahaan, wadarta 2, 3, iyo 4 waa 9.

Waxaad isticmaali kartaa SUM () si aad isugu darto tiir dhan. 

Markaad ku darto safaf cusub, shaqada SUM () ayaa si toos ah u cusbooneysiin doonta oo ku dari doonta shayga cusub. Waxaa loo isticmaali karaa tirooyinka togan, taban, ama eber-qiimaha.

Ma rabtaa inaad samayso miisaaniyad degdeg ah? SUM () ayaa noqon doona saaxiibkaaga ugu fiican.

4. Ku wada dheji qoraalka CONCATENATE()^{(Put Text Together with CONCATENATE())}

Haddii aad rabto inaad ku darto xargaha qoraalka, ma isticmaali kartid isku-darka kaliya. Waxaad u baahan doontaa inaad isticmaashid erey barnaamij oo loo yaqaan concatenation. Eraygani waxa uu tilmaamayaa fikradda ah in qoraalka la isku daro. 

Waxaad isku dari kartaa unugyo kala duwan oo kala duwan oo aad abuuri kartaa hal unug oo ay ku jiraan dhammaan qoraalka. Isticmaalka CONCATENATE () waa habka tooska ah ee habkan loo fuliyo.

Qaacidadan la'aanteed, waa inaad nuqul ka sameysaa oo aad si gooni ah qoraalka ugu dhejisaa hal unug. Habkani waxa uu qaadanayaa wakhti badan marka aad eegayso faylal ka kooban safaf badan.

Habkani aad buu u fiican yahay haddii aad rabto inaad dadka magacyadooda hore iyo kuwa dambeba isku xidho ama aad abuurto fariimo gaar ah.

5. TRIM () Waxay ka saartaa meelaha dheeraadka ah ee aan la rabin^{(TRIM() Removes Unwanted Extra Spaces)}

Mar kasta oo baloogyada qoraalka laga soo guuriyo lagana soo dhejiyo ilo kale, qaabaynta waxay noqotaa riyo xun. Marar badan, waxaad yeelan doontaa meelo aan loo baahnayn oo burburiya qaabka guud.

Waxaad gacanta ku tirtiri kartaa meel kasta, ama waxaad isticmaali kartaa amarka TRIM () ee Google Sheets . Amarkani waxa uu yareynayaa tirada boosaska ee fariinta waxa uuna kaa tagayaa hal meel oo kaliya inta u dhaxaysa erayada.

Tani waxay sidoo kale waxtar u yeelan kartaa xaashida loo dejiyay inay aqbalaan jawaabaha qoran ee isticmaalayaasha. Waxay meesha ka saartaa khaladka bini'aadamka ee laba-meelaynta shil ahaan waxayna keentaa dukumeenti u muuqda mid nadiif ah.

6. TEXT () U beddelo qiyamka qaabab kale^{(TEXT() Converts Values to Other Formats)}

Mid ka mid ah madax xanuunka weyn ee Google Sheets waa dib u habeynta qiyamka la geliyo unugga. Xaashiyaha ayaa isku dayi doona inay qiyaasaan qaabka aad rabto, laakiin waxaa laga yaabaa in lagaa tago inaad beddesho qayb dhan oo unugyada ah.

Haddii kale, waxaad isku dayi kartaa shaqada TEXT (). Qaaciddadani waxay ka beddeli doontaa qaabaynta qoraalka guud, xargaha erayada, qiyamka, qaddarka doollarka, boqolleyda, taariikhaha, iyo tiro doorasho kale.

Haddii aad nuqul ka samaynayso oo aad dhejinayso qayb xog ah oo aad u baahan tahay si aad u beddesho qiimaha dollarka, tusaale ahaan, waxaad isticmaali kartaa qaacidadan si aad u samayso. Waxa kale oo aad bedeli kartaa tirada jajab tobanle ee la tusay qiimaha ka dib.

7. Turjumaada lagu dhex dhisay GOOGLETRANSLATE()^{(Built-In Translation with GOOGLETRANSLATE())}

Xaashiyaha sidoo kale waxay dedejin karaan tarjumaadaada. Haddii aad leedahay tiir odhaahyo ah oo ku jira luqad aad taqaan, waxaad samayn kartaa tiirar badan oo weedho la turjumay oo luuqado kala duwan ah.

Tusaale ahaan, waxaan ka turjumi karnaa jumladaha caadiga ah ee Ingiriisi^(English) ilaa Isbaanish, Faransiis^(French) , iyo Jabbaan hal dukumeenti ah. Tani waxay ka caawin kartaa kooxda caalamiga ah inay fahmaan dukumeenti isku mid ah.

Qaaciddan waxaa iska leh adeegyada turjumaada Google. Waxa kale oo aad u isticmaali kartaa qaacidadan si aad u ogaato luqadda qoraal gaar ahi yahay adiga oo koobiyaynaya oo ku dhejinaya Xaashiyaha^(Sheets) . 

Waxaad u haysan kartaa luqadda isha sida "auto", oo xaashiyadu^(Sheets) waxay go'aamin doonaan luqadda ay tahay, ka dibna u tarjun luqadda la doortay ee aad fahmi karto.

8. Si dhakhso leh u kala sooc() Xogta^{(Quickly SORT() Data)}

Joogteynta liiska xogta ee la soocay waxay noqon kartaa madax xanuun. Marka xogta cusub la geliyo ama xogta la beddelo, liiskaaga gacanta lagu kala soocay waa la carqaladayn doonaa.

Halkii aad gacanta ku kala saari lahayd xogta mar kasta oo la geliyo, waxaad isticmaali kartaa amarka SORT () ku dhex jira. Tani waxay si toos ah u soo saartaa liiska qiimaha kor u kacaya ama hoos u dhacaya. 

Ka dib marka uu ordo, waxay ku ururisaa liiska la soocay safkeeda ama tiirkeeda. Waxaad markaa isticmaali kartaa xadkan si aad tillaabooyin dheeri ah ugu qaado xaashidaada.

9. Ku beddel safafka ^(TRANSPOSE)iyo^(Rows) tiirarka TRANSPOSE (^(Columns) )

Si lama filaan ah ma^(Did) u beddeshay safka iyo tiirka xaashida markii ugu horreysay ee aad samaynaysay? Ama waxaa laga yaabaa in macmiilku kuu soo diro xogta aad rabto inaad ku darto dukumeentigaaga, laakiin safafka iyo tiirarka waxay u baahan yihiin in la beddelo.

Si kastaba ha ahaatee, waxaad isku dayi kartaa amarka TRANSPOSE ().

Waa kan sida ay u shaqeyso: Safafka iyo tiirarka waa la rogrogay. Xogta u dhiganta ee shaxda sidoo kale waa la beddelaa si loo hubiyo inay taallo meesha saxda ah ka dib marka la rogo.

Sida xogtii hore la beddelo, miiska la beddelay ayaa sidoo kale cusbooneysiiya oo isbeddela.

10. Si degdeg ah u hel celceliska()^{(Quickly Find the AVERAGE())}

Isticmaalka celceliska^(AVERAGE) () amarka ee xaashida^(Sheets) waxay soo tufi doontaa celceliska tirooyin la bixiyay. Haddii aanad xasuusan, celcelis ahaan waa marka la isku geeyo dhammaan tirooyinka oo loo qaybiyo inta tiro ee jira.

Tani waa amar xisaab oo faa'iido leh. La'aanteed celceliska^(AVERAGE) () caanaha, waxa lagu dayn doonaa in aad ku xalliso warqad iyo xisaabiye.

Kaliya dooro tirada tirooyinka aad rabto inaad u hesho celcelis ahaan, ka dib Xaashiyaha^(Sheets) ayaa sameyn doona inta soo hartay.

Isticmaal foomamka^{(Use Formulas)} si aad u horumariso waxtarkaaga xaashida Google^{(Your Google Sheets Efficiency)}

Waa wakhti aad furto xaashida oo aad tijaabiso 10kan qaacido ee waxtarka leh ee aad hadda baratay. Waxa loo qorsheeyay inay ku badbaadiyaan wakhtiga oo ay noloshaada u fududeeyaan. Isku day adiga keligaa oo arag sida ay u fududahay.

Ma haysaa qaacido aan jecelnahay oo aan tabnay? Faallo u dhaaf oo nala soo socodsii.

10 Helpful Formulas in Google Sheets to Save You Time

Many Google Sheets users spend too much time on simple tasks. This is largely because they don’t know some of the most helpful Google Sheеts formulas. Formulas are here to make your life eaѕier, expedіte the procesѕ, and take out human error.

Let’s look at 10 of the most helpful formulas in Google Sheets that are designed to save you time.

Setting Up a Formula

Using a formula on Google Sheets is easy. In a text box, just type “=” followed by the formula you want to use. There should be a little question mark box that pops up as you type a formula. Select that box to learn more about using that formula.

For example, if we type in “=add(“ we’ll learn more about how to use this function. Sheets tells us that it returns the sum of two numbers and that we can format it by adding value 1, a comma, then value 2 within the parenthesis.

That means that typing “=add(1,3)” should return the answer to 1+3.

Instead of typing “1” and “3”, we can also refer to cells on Sheets. By adding the cell name (denoted by the column followed by the row), Sheets will automatically perform the formula for those given cells.

So, if we type in “=add(B3,C3)”, the values from cells B3 and C3 will be added. It gives us the same answer. 

This approach works for most of the formulas in the following sections.

10 Helpful Formulas in Google Sheets to Save You Time

The following are 10 of the most helpful formulas in Google Sheets to save you time. There are plenty of hidden Sheets formulas that can help you, but these are ones that the everyday user can use and benefit from.

1. Ditch the Calendar with TODAY()

It feels like we catch ourselves asking “what’s today’s date?” every single day. In Sheets, it becomes an even bigger issue — tracking deadlines and counting down dates requires a daily update. That is, unless you use the TODAY() function.

After putting it in a cell, you’re left with today’s date. It updates every day and doesn’t require you to do anything.

Excel has a whole range of built-in date and time formulas. This makes it easy to find a difference between two dates. With the TODAY() function, you can have a constantly changing second variable.

2. COUNTIF() Makes Conditional Counting Easier

Sheets also lets you do a little bit of coding using what’s known as “conditional counting”. This is when you only count an item if it falls within certain criteria.

For example, if you want to know how many of your survey participants own two or more cars, you can use a COUNTIF() statement. 

The condition would be a value that’s greater than or equal to two.

Without using this formula, you would have to scan through the data by hand and find the number you’re looking for. 

There are other IF functions like this you can use as well such as SUMIF, AVERAGEIF, and more.

3. Add Cells with SUM()

One of our favorite functions is the SUM() function. It adds together all the quantities within a selected range. A sum is just a bunch of numbers added together. For example, the sum of 2, 3, and 4 is 9.

You can use SUM() to add a whole column together. 

As you keep adding new rows, the SUM() function will automatically update and add the new item. It can be used for positive, negative, or zero-value numbers.

Want to make a quick budget? SUM() will be your best friend.

4. Put Text Together with CONCATENATE()

If you want to add strings of text together, you can’t just use addition. You’ll need to use a programming term called concatenation. This term refers to the idea of adding text together. 

You can concatenate multiple separate cells together and create a single cell that includes all of the text. Using CONCATENATE() is the automatic way of performing this process.

Without this formula, you would have to copy and paste text separately into a single cell. This process takes a lot of time when you’re looking at files that contain multiple rows.

This formula is great if you want to combine people’s first and last names or create personalized messages.

5. TRIM() Removes Unwanted Extra Spaces

Whenever blocks of text are copied and pasted from other sources, formatting becomes a nightmare. Many times, you’ll have unwanted spaces that ruin the overall format.

You can either manually delete every space, or you can use the TRIM() command in Google Sheets. This command reduces the number of spaces in a message and leaves you with only one space between words.

This could also be helpful for Sheets that are set up to accept written responses from users. It removes the human error of double-spacing by accident and results in a document that looks really clean.

6. TEXT() Converts Values to Other Formats

One of the big headaches in Google Sheets is reformatting values that are put into a cell. Sheets will try to guess which format you want, but you could be left changing a whole section of cells.

Alternatively, you can try the TEXT() function. This formula will change the formatting from general text, strings of words, values, dollar amounts, percentages, dates, and a number of other options.

If you’re copying and pasting a chunk of data that you need to turn into dollar values, for example, you can use this formula to do it. You can also change the number of decimals shown after the value.

7. Built-In Translation with GOOGLETRANSLATE()

Sheets can also expedite your translations. If you have a column of phrases in a language you know, you can create multiple columns of a translated phrase into different languages.

For example, we can translate common phrases from English to Spanish, French, and Japanese in a single document. This can help an international team understand the same document.

This formula is courtesy of Google’s translation services. You can also use this formula to find out what language a certain text is by copying and pasting it into Sheets. 

You can keep the source language as “auto”, and Sheets will determine what language it is, then translate it into the selected language you can understand.

8. Quickly SORT() Data

Maintaining a sorted list of data can be a headache. As new data is inputted or data is changed, your hand-sorted list will get disrupted.

Rather than manually sorting the data every time it’s inserted, you can use the built-in SORT() command. This automatically generates a list of ascending or descending values. 

After running, it compiles the sorted list in its own row or column. You can then use this range to take additional steps in your Sheet.

9. Swap Rows and Columns with TRANSPOSE()

Did you accidentally swap the row and column of your sheet when you were first making it? Or maybe a client sent you over data that you’d like to add to your document, but the rows and columns need to be switched.

Whatever the case, you can try the TRANSPOSE() command.

Here’s how it works: The rows and columns are flipped around. The corresponding data in the table is also changed to ensure it’s in the correct place after the flip.

As the old data is changed, the transposed table also updates and changes.

10. Quickly Find the AVERAGE()

Using the AVERAGE() command in Sheets will spit out the mean of a given set of numbers. If you don’t remember, the average is when you add up all the numbers and divide by how many numbers there are.

This is a useful math command. Without the AVERAGE() formula, you’ll be left solving it with paper and a calculator.

Just select the range of numbers you want to find an average for, then Sheets will do the rest.

Use Formulas to Improve Your Google Sheets Efficiency

Time to open Sheets and try out these 10 helpful formulas you just learned. They’re designed to save you time and make your life easier. Try them out on your own and see how easy they are.

Have a favorite formula that we missed? Leave a comment and let us know.

Related posts

• Sida Loo Isticmaalo Liisaska Hoos U Dhaca Google Sheets

• 14 Habab Google-ku-ool ah oo Wax-ku-ool ah oo Isticmaalka Maalinlaha ah

• 9 Qodob oo Qarsoon oo ku jira Khariidadaha Google waa inaad hubisaa

• Sida loo Shaandheeyo Google Sheets

• Waa maxay Google App-ka & Sida Loo Isticmaalo

• Sida loo galo Inbox Zero gudaha Gmail

• Sida loo Isticmaalo Hawlaha Google-ka-Bilowga Hagaha

• Eeg App-ka fariimaha Google-ka ee Android. Ma wax wanaagsan baa?

• Google Hawshayda: Waa maxay sababta aad u daryeesho

• 8 Talooyin Raadinta Google: Had iyo jeer raadso waxaad raadineyso

• Aan Heleynin Ogeysiisyada Gmail? 10 siyaabood oo loo hagaajiyo

• Waa maxay Qalabka Wariyaha Software-ka ee Chrome iyo sida loo joojiyo

• Sida loo Hagaajiyo Khaladaadka Shahaadada Amniga SSL ee Chrome

• Sida Loo Sameeyo Foom Google: Hage Dhamaystiran

• Sida loola socdo isbeddelada Google Docs

• Sida loo soo diro iimaylka Gmail-ka

• Sida Loo Isticmaalo Joogsiyo Badan Khariidadaha Google-ka

• Sida loogu soo diro iimaylo khaas ah Gmail

• Sida loo arko Taariikhda Raadinta Khariidadaha Google

• Sida loo Beddelo Koontada Google-ka ee Default