9 Basic Google Sheets Features You Should Know – Functionality is a key component of spreadsheet applications like Google Sheets. But if you rarely use them, or are just starting out, they can feel overwhelming.
Image: stitchdata.com
Basic Google Sheets Features You Should Know
For the most basic actions you’ll take, here are some simple Google Spreadsheet functions.
There’s nothing more basic when working with numbers than adding them up. Using SUMthese functions, you can add multiple numbers, add numbers in cells, or use combinations.
The function syntax is SUM(value1, value2,...)with value1required and value2Optional.
To add up the numbers 10, 20, and 30, use the following formula:
=SUM(10,20,30)
To add the numbers in cells A1 to A5, you would use this formula:
=SUM(A1:A5)
#2. Average score: AVERAGE
Maybe you need to look at the average of a number or numbers in a range of cells. This feature AVERAGEhave you covered
Similar to calculating the average in Excel, the syntax for the Google Sheets function is Required and AVERAGE(value1, value2,...)Optional.value1value2
To find the average of the numbers 10, 20, and 30, you would use the following formula:
= RATE-RATE (10,20,30)
To find the average of the numbers in cells A1 through A5, use this formula:
= RATE-RATE (A1: A5)
Tip: You can also view basic calculations without formulas in Google Sheets.
#3. Count cells with numbers: COUNT
If you’ve ever counted cells, you’ll appreciate COUNTthe feature. With it, you can count how many cells in the range contain numbers.
The function syntax is COUNT(value1, value2,...)with value1required and value2Optional.
To count cells A1 through A5, you would use the following formula:
=COUNT(A1:A5)
To count cells A1 through A5 and D1 through D5, use the following formula:
=COUNT(A1:A5,D1:D5)
You can also calculate data that match the criteria using COUNTIFGoogle Sheets.
#4. Enter the current date and time: NOW and TODAY
If you want to see the current date and time every time you open a Google Sheet, you can use the NOWor function TODAY. NOWshows the date and time while TODAYshowing only the current date.
The syntax for each is NOW()and TODAY()no arguments are required. Simply enter one or the other of the following in your sheet to display the date and time or date only.
NOW()
TODAY()
If you want the date to appear in a certain format, you can set the default date format in Google Sheets.
#5. Delete non-printable characters: CLEAN
When you import data from other locations into your sheet, the data may include non-printing or ASCII characters such as backs and returns. This function CLEANremoves visible and invisible characters.
syntax CLEAN(text)with the required text.
To remove non-printable characters from the text in cell A1, you would use this formula:
= NET (A1)
Note: Because the function removes characters you can’t see as well as characters you can see, you might not see a difference in the resulting cells.
#6. Remove whitespace: TRIM
Another useful function for tidying up your sheets is TRIMthe function. Just like in Microsoft Excel, this function removes blank spaces from cells.
syntax is TRIM(text)where text can represent a cell reference or actual text.
To remove the blank space in cell A1, you would use the following formula:
=TRIM(A1)
To remove whitespace from “remove extra spaces”, use this formula:
=TRIM("hapus spasi")
#7. Combine Text or Value: CONCATENATE and CONCAT
To concatenate strings, text, or values, you can use the CONCATENATEfunction CONCAT. The main difference between the two is that it CONCATENATEoffers more flexibility. For example, you can combine words and insert a space between them.
The syntax for each is CONCATENATE(string1, string2,...)and CONCAT(value1, value2)where all arguments except string2are required.
To combine the values in cells A1 and B1, you can use the following formula:
=CONCATENATE(A1,B1)
To combine the words “How”, “To”, and “Geek” with a space, you would use this formula:
To combine the values 3 and 5, you can use the following formula:
=CONCAT(3,5)
For more details on these two functions, see our tutorial for combining data in Google Sheets.
#8. Insert the image into the cell: IMAGE
While Google Sheets provides the feature to insert an image into a cell, IMAGEit gives you additional options to resize it or set a custom height and width in pixels.
Function syntax IMAGE(url, mode, height, width)with the required URL and other optional arguments.
To embed an image with the URL as-is, you would use the following formula:
In 4this formula is the mode that allows the custom size of the image to be 50 by 200 pixels.
Note: You cannot use URLs or SVG graphics for images in Google Drive.
For more help on resizing images with the IMAGE function, visit the Document Editor’s help page for the IMAGE function.
#9. Validate email address or link: ISEMAIL and ISURL
Whether you’re importing or entering data into Google Sheets, you may want to check if the data should be. With ISEMAILand ISURL, you can verify that the record is a valid email address or URL.
The syntax for each is ISEMAIL(value)and ISURL(value)where you can use text or cell references. The validation result is displayed as TRUE or FALSE.
To verify the email address in cell A1, you would use the following formula:
= ISEMAIL (A1)
To check the URL in cell A1, use this formula:
= ISURL (A1)
To use text in a formula for an email address or URL, simply enclose it in quotes like this:
=ISURL("www.technadvice.com")
Conclusion:
So, friends, This is the explanation of 9 basic Google Sheets features you should know, To go further, see how to use the AND and OR functions, take advantage of the QUERY function, or start using the IF function in Google Sheets.
Wifi Is Often Disconnected on Laptops Here Is The Solution – Many users report that their Wifi wireless connection keeps dropping. According to info from Microsoft forums, this problem is caused by corrupted network drivers, improper Power Management configuration, and sometimes a damaged network adapter.
Wifi Is Often Disconnected On Laptop Here Is The Solution
6 Solution Wifi Often disconnected On Laptops or PC
To help you fix this problem, we are listing an effective method for you to try on your laptop to see if that will solve the problem.
You will find 6 proven ways to fix Wi-Fi problems including Wi-Fi networks that often disconnect on laptops.
Solution # 1: Reset or Reset Your Router
Most routers are turned on for days or even weeks, sometimes just a simple reboot of the router can fix this problem.
To do this follow the steps below.
Turn off your Internet Router.
Unplug your router.
Wait 5 minutes before turning on your router.
Turn on your router.
Try connecting to your network now.
Solution # 2: Forget Your Wireless Connection
Press the Windows + I keys simultaneously on the keyboard.
Select Network & Internet.
Forget Your Wireless Connection
Click on WIFI in the side menu.
Click on Manage Know Networks.
Manage Know Networks
Find the network you are trying to connect to and click on Forget.
Try reconnecting to the network and see if the problem gets fixed.
Solution # 3: Use the Network Troubleshooter / Network Troubleshooter
Press on the Windows key on the keyboard then click on Settings.
Use the Network Troubleshooter / Network Troubleshooter
In Settings, look for “Troubleshoot Network”.
Troubleshoot Network
Open the Network Troubleshooter.
On the side, the menu clicks on Status.
Find the Network Troubleshooter and run it.
Network Troubleshooter
Wait for the Network Troubleshooter to finish scanning your laptop.
Network Troubleshooter to finish scanning your laptop
Try reconnecting to your Wifi and see if the problem gets fixed
If you are still having problems after running the Network Troubleshooter then move on to the next method below.
Solution # 4: Reinstall Network Adapter
If your wireless network adapter driver is not installed properly, it can cause your wireless network adapter to experience an error.
To reinstall your wireless network adapter driver properly follow the steps below.
Press on the Windows key + S and search for “Device Manager”.
Reinstall Network Adapter
Open Device Manager.
Find Network Adapters and select your adapter.
Right-click on your Wireless Network Adapter and select Uninstall.
Wireless Network Adapter and select Uninstall
Restart your computer and Windows will automatically install the latest driver for your Network Adapter.
Solution # 5: Reset TCP / IP Configuration
Press Windows key + X and select Command Prompt (as Admin).
At the Command Prompt, type the following command line and press Enter.
ipconfig / release
Reset TCP IP Configuration
After doing ipconfig / release, enter the following:
ipconfig / renew
ipconfig renew
Close the Command Prompt.
Reboot Windows 10 and try to reconnect to your Wi-Fi network.
Solution # 6: Change the Wireless Adapter Power Settings
Now the last thing to check is your power management settings. Your laptop might turn off your wireless adapter to save power when you use the laptop with a battery.
To disable this setting follow the steps below.
Press on the Windows key + R on the keyboard.
Type ncpa.cpl and press OK.
Change the Wireless Adapter Power Settings
In-Network Connections, locate your wireless network adapter and right-click on it, and select Properties.
right-click on it, and select Properties
Under Properties click on Configure.
Wifi Configure
In the popup window click on the Power Management tab.
Make sure to uncheck “Allow the computer to turn off this device to save power”.
Allow the computer to turn off this device to save power
Click OK and try to connect to your WIFI network.
Another thing to check is your wireless router. The router may be damaged or damaged and cause an unstable connection to your laptop.
Try connecting a laptop or other device to your router and see if the problem will occur. If other devices connect without problems on your router, this means your wireless network adapter is damaged.
Visit your nearest laptop brand service center and have them check your laptop’s wireless network adapter.
You can also add to your business by using Google’s public DNS, which is one of the recommended ways to overcome Wi-Fi always disconnecting on a laptop. As for the steps, you can go directly to how to use Google DNS on Windows 10. After that, you can ping Google to test your internet connection and see whether the problem is from the ISP, browser, or VPN.
Apart from that at Technowizah we usually handle Wi-Fi problems, where several solutions have been archived around the Wi-Fi problems that we group on #tag Wifi which you can click to find solutions and methods of fixing Wifi always disconnecting even detecting Wifi thieves is at # the tag.
So, friends, that’s was Wi-Fi is Often Disconnected on a Laptop Here Is The Solution, Wifi problems are always related to data signal sending connections from ISPs, Adapter drivers, laptop batteries, and also software devices that can affect Wifi working, such as antivirus and even viruses. Therefore, you should also look at antivirus and firewall program settings that might affect Wi-Fi performance and viruses.
[100% Work] How to Root Asus Zenfone GO without PC – For current Asus Zenfone GO cellphone users, you don’t need to be difficult to root the device. It can even be done without a PC by using the latest Kingroot apk which can be done with just one click.
[100% Work] How to Root Asus Zenfone GO without PC
There are many reasons that Android users have for rooting their devices, one of which is because they can run cool root applications where with the help of the application we can make the appearance of the cellphone more beautiful.
One of the root APK applications that is often used for root is KingRoot APK. This application is trusted by many users to easily open root access. Besides, this apk is only installed then with one click it has succeeded in rooting.
This time we will give you how to root Asus Zenfone Go with Kingroot to make it easier for users to further optimize the Asus Zenfone GO device. Please see below the tutorial.
How to Root Asus Zenfone GO without a PC
First, prepare the application, you can download KingRoot APK via the official website directly.
Run the kingroot application, then press Try to Root or Start Root
Then wait for the root process to complete
When it’s finished, now you can check it with the Root Checker application Done.
It’s very easy, right, how to root Asus Zenfone Go without a PC?
If you have finished rooting, now do some helpful tips from us below 7 Android Tricks Once the ROOT You Must Do
But beforehand, make sure you know the impact of the root and the negative things.
Advantages of Root
We get many advantages from rooting, one of which is being able to tweak the RAM, change the appearance of the status bar and UI, and modify applications and data on an Android smartphone.
The most interesting thing is that we can install CWM where this application is handy when we want to try a Custom ROM (ROM modified by people) so that we can try other cellphone displays such as custom ROM iOS, MIUI, Nexus, and many more.
Disadvantages of Root
Before rooting, make sure you already know the risks, namely loss of cellphone warranty, system security is reduced because viruses easily enter if there is root access and several other problems regarding the system.
Rooting the Asus Zenfone GO is the best way for those who want to experience another custom ROM with a different cellphone display. Likewise, root apps are cooler than ever.
There are still more advantages to root than disadvantages, so hopefully, this tutorial can make it easier for users to root and have a good try.
10 Ways To Download TikTok Videos Without Watermark – TikTok has become one of the most popular applications today with various short-duration video applications. Almost every teenager today has the TikTok application on their respective Android smartphones.
10 Ways To Download TikTok Videos Without Watermark
How To Download TikTok Videos Without Watermark
The size of the application is quite light and there are lots of exciting short video appearances that make this application the most popular. This popular application has been proven to have been downloaded by many people in the number of more than 100 million users around the world.
This time, the admin will give you instructions on how to download TikTok videos without TikTok writing. Because at this time there are still many people who do not know how to do it. Lots of people like TikTok videos, but they don’t know how to download them. So they can only save it in the video view they like.
There are several things that people usually do, such as Download TikTok Videos to Music, HD Videos, iPhone Videos, Logoless Videos, Privacy Videos, Watermarkless Videos, and various other things. And of course, there is a hidden way to be able to download various videos from TikTok.
Therefore, for those of you who don’t know the methods yet, then you can read this article to the end. Here, the admin will share a collection of places to download TikTok videos for those of you who don’t know how, please read carefully the following reviews.
About Download TikTok Videos
There are several ways to download TikTok videos, namely the way you can do it without using the help of the application and also the way through the application. The places to download TikTok videos that the admin shares below are popular and frequently used places to download TikTok videos.
Here, the admin has shared with you a collection of places to download TikTok videos that are very popular, both those using the application and those not using the application. For how to download Tiktok videos without an application, you can use various sites such as the following:
TikTok Video Download Site Without Watermark
SSSTikTok.io
id.saveform.net
ttdownloader.com
TikTokdownload.online
Qload.info
Snaptik.App
You just need to enter the site and then use the video link that has been copied from the TikTok application directly, enter the link in the empty column that has been prepared by some of the sites above.
Now, for how to download TikTok videos with the application, you can also do it with various official applications that are already available on the Play Store or AppStore, for example, the following applications:
TikTok Video Download Application Without Watermark
Tikmate Downloader
Downloader for TikTok
Snaptik
That’s the place to download the most popular TikTok videos, now you can access the downloads quite easily and of course for free. By downloading through the place that the admin shared above, the video you download does not have a watermark (WM).
However, if you don’t know how to download TikTok videos through these places. So in the following, the admin will tell you the ways for all of you, especially loyal visitors to this website.
How to Copy TikTok Video URL Without Watermark
For where to download it, the admin has told you above. However, for those of you who don’t know how to download through the places above, please refer to the following methods.
For how to download TikTok videos through the application or site that the admin shared above, it’s actually the same as you have to copy or copy the URL of the video you want to download now.
If you are confused, then the following admin will share how to download TikTok videos without a watermark (Watermark) through the application or site that the admin recommends.
#1. Copy Url
To be able to download TikTok videos without wm (watermark) through the place that the admin recommended earlier, the first way you have to copy the URL. If you don’t know how to copy the URL in the video you want to download, then the admin has shared the method for all of you below:
The main step you have to do is to enter the TikTok application.
If you are already logged in, then you can select the video you want to download now.
Next, please select the Share menu.
If you have selected the Share menu, then the next step is to select the Copy Link menu view.
If so, then you can copy or copy the URL in the video.
Finished!
This method is a very important method because if you haven’t copied or copied the URL in the video you want to download it without a watermark. So you can’t do this one thing if you haven’t copied or copied the URL.
If you have copied or copied, then the next step is that you only need to choose places to download TikTok videos without the watermark or watermark.
How to Download TikTok Videos Without Watermark
There are lots of TikTok videos for you to download, examples of places like what the admin has told you above. But for those of you who don’t know how to download TikTok videos without a watermark through the places that the admin has shared above, then please see the following methods.
#1. SSSTikTok.io
If you want to download TikTok videos without using an application or without a watermark, then you have to use the site. The first site that you can use to download TikTok videos without a watermark is https://ssstiktok.io/. Now to download TikTok videos using the site, you can see how you can do this:
The main step you have to do is to copy or copy the URL in the video that you want to download through the method that the admin has shared above.
If you have copied the URL in the video, then the next step is you can open the browser on your respective smartphone.
Please type https://ssstiktok.io in the Bowser.
If you have entered the site, then please directly paste the video URL that you copied earlier into the available column on the site.
If so, please paste the URL of the video that you want to download, then you can select the Download menu.
Please wait for some time until the download process is complete.
When finished, a video will automatically be saved in the gallery of each of your smartphones.
Finished!
That’s an easy way to download TikTok using the ssstiktok.io site, but if you don’t want to use this one site. Then you can use others in the same way, for more details, the following admin has explained for you the ways.
#2. Id.Saveform.net
How to download TikTok videos without using the next application is that you can use the id.saveform.net site. Now, this one site is very popular because indeed on this site you can not only download TikTok videos, but you can also download videos from Facebook, Youtube, Instagram, and so on using this one site.
Also Read: How to Check XL Quota
To download TikTok videos using the id.saveform.net site, you can see the steps below. Please read carefully so that there are no unwanted errors.
The first step you have to do is copy the URL of the video you want to download, the admin explained how to copy the URL above.
If you have copied or copied the video URL, then you can immediately open a browser such as Mozilla, Chrome, or other browsers that are on your respective smartphone.
If you have opened the browser on your smartphone, then the next step, please type id.saveform.net.
If you have entered the id.saveform.net site, then the next step is to paste the video URL link that you copied.
Please paste the URL link into the column provided on the id.saveform.net site.
Next, if you have pasted it, you can select the Download menu.
Please just wait for some time until the download process is completely finished.
When it’s completely finished, congratulations, you’ve downloaded TikTok videos without using a watermark.
Finished!
By downloading TikTok videos using the id.saveform.net site, the videos you will get will not have a watermark. If you want to use other sites to download TikTok videos, then you can check out other sites to download TikTok videos below.
#3. TTDownloader.com
Unlike the id.saveform.net site above which not only can download TikTok videos. The ttdownloader.com site is specifically for TikTok application users who want to download TikTok videos without a watermark.
For how to download TikTok videos without a watermark using the ttdownloader.com site, you can see how to download TikTok videos below.
The main step you have to do is to copy the URL of the TikTok video that you want to download.
If you have copied the URL of the video that you want to download, then the next step please visit the ttdownloader.com site by using the search “Browser” on your respective smartphone.
If you have browsed the ttdownloader.com site, then on this site there is a column where you have to paste the URL of the video that you copied.
Please paste the TikTok video URL that you copied into the column on the site.
If you have pasted the URL into the column, then the next step, please click the Get Video menu next to the column.
If you click, the site will automatically download the video you want at this time.
Next, if the download process is completely finished, the video will automatically be saved in your smartphone gallery and this TikTok video will not have a watermark.
Finished!
If you download TikTok videos using this site, then the videos you get will not have a watermark or watermark.
#4. TikTokDownload.online
The next TikTok video download site is TikTokDownload.online. Well, this site is dedicated to downloading TikTok videos. Well, how to download TikTok videos using the TikTokDownload.online site. You can see how this is done:
The main step you have to do to download TikTok videos using the TikTokDownload.online site is that you have to copy or copy the URL of the video that you want to download.
If you have copied or copied the URL, then the next step is to visit the TikTokDownload.online site.
Furthermore, if you have entered into this one site, then you can see on this site there are columns.
Please “Paste” the URL that you copied into this column.
If you have pasted it, then the next step you can directly click the Download menu.
Please wait for the “Download” process until it is completely finished.
If the download is completely complete, a video will automatically be saved in the gallery of your respective smartphone.
Finished!
Also Read: How to Earn Money on Snack Video
Actually, there are many other sites that can download TikTok videos without a watermark. In essence, how to download it is the same, namely you need to copy or copy the URL of the video that you will download first.
However, for those of you who don’t want to be complicated, then you can download TikTok videos directly using the TikTok application directly. But the drawback is that the video you download has a watermark.
Now for how to download TikTok videos from the TikTok application directly. Then you can immediately see the method below properly and correctly so that there are no mistakes that we don’t want.
Download TikTok Videos Using Application
If you don’t want to bother opening a browser, then here we will share a tutorial on how to download TikTok videos using the application. Below are complete steps for saving TikTok videos on android phones and iPhones using the app.
First of all, please open the Google Play Store or App Store applications.
Next, please look for one of the TikTok video download applications such as Tikmate Downloader, Downloader For TikTok, and Snaptik.
Then, please “Install” until it’s completely finished.
Finished!
Download TikTok Videos Directly from TikTok App
There are still a lot of people who don’t know how that from the TikTok application you can immediately have the videos you like. However, there are still many people who don’t know this method and if you download directly from TikTok videos, this video will have a watermark. If you are curious, then the following admin will share a tutorial on how to download TikTok from the application directly.
First of all, please enter the TikTok application.
Next, please select the video that you want to “Download” right now.
If you have selected the video that you want to download, then you can select the “Share” menu view.
If you have done the above method, then you can directly select the Save Video menu.
If you click the Save Video menu, the video will automatically be saved directly in your respective smartphone gallery.
Finished!
However, if you download videos directly from the TikTok application, the videos you download will have a watermark.
That’s a very easy and simple way to download TikTok videos via the app or not. If you don’t want to bother, then please download the video from the TikTok application. However, the drawback is that if you directly download videos from the TikTok application, the videos you download will have a watermark.
Maybe that’s all we can share with all of you regarding how to Download the Latest TikTok Videos Without a Watermark. Hopefully, the above review can be useful for all of you, especially TikTok application users.
Easy Ways To Integrate IDM With Mozilla Firefox – I will discuss with you in this article how to integrate IDM with Mozilla Firefox. If you have experienced things related to the integration ofIDMwith Mozilla IDM and Mozilla Firefox for example:
How To Integrate IDM With Mozilla Firefox
How To Integrate IDM With Mozilla Firefox
– You can’t download IDM via Mozilla Firefox.
– IDM cannot be integrated with Firefox
– When downloading something the panel does not appear
– IDM extensions are disabled because they are not compatible (match)
If ever, it’s good if you follow the article to fix this problem. For the article, you can add below, see it well, and correctly.
# 1. As we know the Mozilla Firefox browser will be updated every 6 weeks, so when IDM integration into Firefox will be updated once every 6 weeks. So from that, it is better if you already have the latest version of IDM.
# 2. Try checking whether integration into Firefox can be used in IDM settings. In a way :
Press Options icon
Then select General.
How to integrate IDM with Mozilla Firefox
If there is a checkmark, it means it can be used in Firefox. If there is a checklist, but the integration is still not possible, then the following are possible.
Problems with IDM Extensions (IDM extension) on Firefox
When you just finished installing IDM or you just updated your IDM, IDM will ask you to restart your Mozilla Firefox so that your Firefox can detect the latest add-on from the IDM.
After that, there will be a dialog box like the picture below that will appear to confirm the installation of the IDM add-on in Firefox.
How to integrate IDM with Mozilla Firefox
Note: When the dialog box appears, please check the box provided by the dialog box.
If your computer cannot integrate IDM in Firefox, maybe because of how you integrate IDM into Firefox you don’t do the things I mentioned above when you installed or updated your IDM. To resolve this problem, you can update the IDM extensions in Firefox. In a way :
Go to the Firefox main page
Click add-ons / Click Tools
Then, click on add-ons
Then there will be an add-ons dialog box that will appear. Click the tab or extension icon. And look for IDM integration (Internet Download Manager integration module for Mozilla).
If integration is not yet allowed, then click on the word “Enable” and then restart Firefox.
IDM extensions
Maybe because of an update from Firefox 40, there will be an add-on for Firefox with a new ID again. For the old add-on, IDM CC, the new one will be named IDM integration.
The new add-on supports a lot of versions of Firefox starting from version 27. There is also an old version that only supports versions 1.5 and 26.
Note: The add-on turns out to be equipped with IDM, so you will be able to find the two extensions simultaneously in Firefox settings.
Often many problems occur because the IDM tracks the system registry regarding the old version of Firefox (eg Aurora, Harit, Change, and Waterfox) which is already integrated and is being used on the computer that you are using.
Or it could be because you have two different versions of Firefox, 32 bits, and 64 bits. To solve the problem, delete one of the firefoxes that is no longer used.
Restart your IDM by opening tasks on the IDM menu, then EXIT. And after that, you open a new Firefox. Then your old IDM extension will not appear in the Firefox settings.
However, if both extensions still appear, the old and the new, you only need to have one.
If the IDM CC extension is installed manually, then you can delete it by clicking the remove button on the right.
If the browser is launched in admin mode then integration will not be possible, because this happens if you install Firefox using an intermediary program such as Total Commander.
So, Friends, This is the explanation of how to easily integrate IDM into Mozilla, I hope hopeful for you, also share this article with your friends on social media.
![[100% Work] How to Root Asus Zenfone GO without PC 2024](https://technadvice.com/wp-content/uploads/2021/03/100-Work-How-to-Root-Asus-Zenfone-GO-without-PC.jpg "[100% Work] How to Root Asus Zenfone GO without PC 2024 4")
