Imagine having bought hundreds of crypto coins in different exchange apps. Sometimes, logging into each of these exchanges to check the performance of these cryptocurrencies you bought might be very stressful. But there are some special crypto portfolio trackers that can help you monitor the performance of all your crypto trades easily. CoinGecko app has a powerful crypto portfolio tracker you can use for free. You will learn how to use CoinGecko app to easily track your crypto portfolio from your smartphone or PC and how to set price alert for any coin.

CoinGecko is one best free crypto research tools you can use to perform fundamental analysis before buying any cryptocurrencies. You can also learn about DeFi, yield farms, markets, Crypto news, Coin price updates, Crypto price to fiat currencies calculator, etc.

How to Use CoinGecko App Crypto Portfolio Tracker to Manage your Trades

First, you need to download the latest CoinGecko app from Google play store on your phone. You can get it at https://gcko.io/coingecko-android. Install the app and launch it on your phone.

Next, click the More tab and then click on Sign Up / Sign In. Login by clicking on Sign In if you already have an account with CoinGecko or you click on Create Account to create new account. 

After creating a new account, you will be required to login to the email account you used for the registration, click a verification link to verify your CoinGecko account. After that, your CoinGecko account is ready for use!

Now click on Portfolio tab to start building your favourite coin list. 

Watchlist vs. Portfolio

But it is under the Portfolio sub-tab that you can add or record the transactions (buy, sell and transfer) you have carried out for any coin under your portfolio. In other words, the balance you see at the top of the Portfolio sub-tab is your real crypto portfolio if you add all the transaction you carried out in all the coins under your portfolio.

In summary, the Watchlist sub-tab of CoinGecko app is just like the front-end of a webpage while the Portfolio sub-tab is the back-end where you have many setup options.

See:

• Free Bitcoin Trading Profit/Loss MS Excel Calculator For Crypto Traders
• Free Ethereum Trading Pair Profit/Loss Excel Calculator App

How to Add a Coin to your Portfolio

There are ways to add coins to your CoinGecko app portfolio:

Method 1: Search the Coin from the Market Tab

Method 2: Search the Coin from the Portfolio Tab

To add a coin to your portfolio using this method: From the Portfolio tab, click the + symbol at the top right corner of the page and then type the coin name in the search box that appears.

Once the coin appears in the search result, click on it. 

Congrats! You have successfully added a coin to your CoinGecko app favourite list. Do this for all the coins you wish to track their performance.

Check:

• Free Excel App For Converting USD Or USDT To BTC - Crypto Calculator
• Free Excel App For Converting USD Or USDT To ETH - Crypto Calculator

How to Add the Transaction Details for your Portfolio in CoinGecko App

There are 3 types of transactions you can setup for each coin in your portfolio:

• Buy: For adding completed buy transactions.
• Sell: For adding completed sell transactions.
• Transfer: For recording transfer (in and out) transactions. For example, if you bought a certain amount of a coin in a particular exchange platform and wish to move a percentage to another exchange.

Click the Fees & Notes link to add the description for the transaction (under the Notes field) and the transfer fee (under the Fees field).

Once you are done, click on Submit. Confirm the submission by clicking on Save.

NOTE: You only add transaction details for the coins you have actually bought or sold in any exchange. If you added the coin(s) to your portfolio just to study its movement pattern then don't add any transaction detail for the coin(s).

How to SetUp CoinGecko App Price Alert Feature

Search for the coin you wish to add price notification for and then tap on it to see its details on CoinGecko. Tap the + sign at the top right hand side of the page as shown in the screenshot below.

Select the Add Price Alert option. This prompts the Add Price Alert page.

Now specify the price at which you want CoinGecko app to alert you. You can specify in percentage or you type the exact alert price. 

Specify the how often you wish to be alerted (once or recurring?). The tap on Save as shown in the screenshot below.

Do you wish to learn more about cryptocurrency trading? Check out this book on Amazon - How to Make Money from Crypto Trading & Investing for Beginners: Complete Guide on How to Buy & Sell Bitcoin & Altcoins for Profit, DeFi Yield Farming with Cryptocurrency Investments & Security Tips. The book also explained how to discover cryptocurrencies with powerful potentials, how to calculate profits for other crypto trading pairs like BTC, ETH, NEO, BNB, KCS, USDT, etc.

Conclusion

You have learnt how to use CoinGecko app to track your crypto trading portfolio. There are other popular crypto portfolio tracking apps like Blockfolio, Delta, CoinTracking, Coin Market Manager, Kubera, CryptoCompare, Altrady CoinStats, etc. Each of these apps has its pros and cons. Weigh them and choose the one that suits you most. I love CoinGecko app portfolio tracker because it is very simple and easy to use. Blockfolio is another crypto portfolio management app I love.

Comment your questions and suggestions below. Click a share button to share this tutorial article with your social media friends. Enjoy!

This is a simple excel cryptocurrency converter app or calculator you can use to convert funds from USD or USDT to BTC. The calculator also shows you the current equivalence of 1 BTC in USD (the BTC price is gotten from CoinGecko). This means that your device must be connected to the internet so that you will see the current Bitcoin value when you open the app.

How to Use the USD or USDT to BTC Calculator App (Spreadsheet Template)

To do another calculation, press the Reset button.

You can view and download the usd or usdt to btc calculator app for free here.

Check: How to Manage your Crypto Portfolio with Coingecko App

NOTE: 

Once you download the spreadsheet template, upload it back to your own google drive. This is to ensure that any record you add to the spreadsheet will be saved automatically and you can access the spreadsheet template easily.

Check out the screenshot below to understand how the app works.

NOTE: To learn more about cryptocurrency trading, check out this book on Amazon - How to Make Money from Crypto Trading & Investing for Beginners: Complete Guide on How to Buy & Sell Bitcoin & Altcoins for Profit, DeFi Yield Farming with Cryptocurrency Investments & Security Tips. The book also explained how to calculate profits for other crypto trading pairs like ETH, NEO, BNB, KCS, USDT, etc.

Remember:

1 Satoshi = 0.00000001 BTC = 10^(-8) BTC

See:

• Free Bitcoin Trading Profit/Loss MS Excel Calculator for Crypto Traders
• Free Excel App for Converting USD or USDT to ETH - Crypto Calculator
• Free Ethereum Trading Pair Profit/Loss Excel Calculator App

This is a simple excel cryptocurrency converter app or calculator you can use to convert funds from USD or USDT to ETH. The calculator also shows you the current equivalence of 1 ETH in USD (the BTC price is gotten from CoinGecko). This means that your device must be connected to the internet so that you will see the current Ethereum value when you open the app.

How to Use the USD or USDT to ETH Calculator App (Spreadsheet Template)

To do another calculation, press the Reset button.

You can view and download the usd or usdt to eth calculator app for free here.

Check: How to Manage your Crypto Portfolio with Coingecko App

NOTE: 

Once you download the spreadsheet template, upload it back to your own google drive. This is to ensure that any record you add to the spreadsheet will be saved automatically and you can access the spreadsheet template easily.

Check out the screenshot below to understand how the app works.

NOTE: To learn more about cryptocurrency trading, check out this book on Amazon - How to Make Money from Crypto Trading & Investing for Beginners: Complete Guide on How to Buy & Sell Bitcoin & Altcoins for Profit, DeFi Yield Farming with Cryptocurrency Investments & Security Tips. The book also explained how to calculate profits for other crypto trading pairs like BTC, NEO, BNB, KCS, USDT, etc.

See:

• Free Bitcoin Trading Profit/Loss MS Excel Calculator for Crypto Traders
• Free Ethereum Trading Pair Profit/Loss Excel Calculator App
• Free Excel App for Converting USD or USDT to BTC - Crypto Calculator

How to Password Protect MS Word File Offline

Enter the document open password. Re-enter the password to confirm it and then click OK.

Microsoft Word will now indicate that the file has been protected. To view the content of the word file, you need to enter the password. Now click on Save to save the changes you made to the file.

Learn how to password protect PDF filesboth online and offline for free.

How to Restrict Editing in Word Document

You can control the types of editing others can make in your file by setting up the restrict editing in Microsoft word.

To setup restricting access:

Click File menu > Info option.

Select Restrict Access from the Protect Document menu as shown below.

You have 3 steps to follow: Formatting restrictions, Editing restrictions (with optional Exception) and Start Enforcement.

• For Formatting restrictions: Check the "Limit formatting to a selection of styles" check box. You can click the Settings link to edit the allowed styles.
• For Editing restriction: Check the "Allow only this type of editing in the document" check box. Then click the drop down menu to select the editing types to allow. No changes (Read only) is the default.
  You can also use the optional Exceptions section to specify parts of the document and users who are allowed to edit them freely. If you wish to allow everyone, then check the Everyone check box and then specify all regions they can edit by clicking the drop down arrow to the right of the check box. If you want only specific users to be able to edit these selected parts freely, click the More users link.
• For Start enforcement: When you are ready to apply the changes to the document click on the Yes, Start Enforcing Protection button.

This prompts the Start Enforcing Protection dialog box as shown below.

You have two protection methods: Password and Authentication. You can use any protection method that suits you. Then click OK.

• For the Password method: you need to enter a new restrict access password and confirm it. It must be different from the document open password you set earlier. Note that the document will not be encrypted. So malicious users can edit the file and remove the password with an online password unlock tool.
• For the User authentication method: Users must pass the authentication before they can have access to the restrict access settings. Note that authenticated users can also remove the document protection. But the document will be encrypted and Restricted Access will be enabled.

Also note that you must sign in to your Microsoft office account in order to activate the User authentication method. But you can use the Password method without signing to your Microsoft account.

Save the word document to effect these changes you made.

See:

• How To Convert A Docx File To Pdf And Other Format For Free Offline Using Ms Word
• How To Convert A Pdf File To Docx File Offline Using Ms Word & Adobe Pdf Reader

How to Decrypt a Protected Word Document Offline

To remove the password of a protected word document offline, you must provide the document. After which you will be allowed to decrypt the word file.

First, open the word document you wish to unlock with MS Word app.

You will be requested to type in the document open password before you can view the content of the document. Type the password and click OK as shown below.

Now to remove the document open password, click the File menu. Select the Info option.

Click the drop down arrow near Protect Document menu and select Encrypt with Password.

The Encrypt Document dialog box pops up with the document open password in the Password field. Delete those password and click OK.

MS Word has permanently removed the password. Save the word document to effect these changes.

How to Remove Editing Restriction in a Word Document

You might remove a document open password and also discover that you cannot edit the content of the word document. This is because the word document is set to restrict editing in some part or all parts of the document. In order to edit such a document, you need provide the Restrict Editing password or remove the password completely.

To deactivate Restrict Editing in a Word file:

Open the word document with MS word. If the file is locked with a document open password, follow the above guide for unlocking a password protected word document to unlock it.

If all editing access were restricted for the document, it will open in read only mode.

To enable editing, click on the View menu and then select Edit Document as shown below.

The document will now open fully, showing all the menus and MS Word features.

Now when you try to edit the document, MS Word will notify you that the document is restricted from unintentional editing.

To remove the restriction, click the Stop Protection button as shown below.

Microsoft Word will remove the editing restrictions. Now save the word document to effect these changes.

Learn how to remove password from any PDF file online and offline for free.

How to Use any Word Document Password Unlock Tool

1. Upload the word file you wish to unlock to the server of the website.
2. Most tools will ask you to provide the document open password. Type it.
3. If editing access was also restricted in the document, you will be asked to provide the remove restriction password.
4. The tool will start the decryption process. Once it is successful, you can download the decrypted version of the word document.

NOTE: For offline word document unlock tools, you don’t need to upload the word document first. It does the decryption offline.

Free Online and Offline Word Document Password Recovery Tools

Here are some free online and offline tools you can use to unlock any word document and also remove editing restriction.

• Aspose Free Online Documents Unlocker: Unlock word documents, allows you to save to any desired format (PDF, JPG, HTML, etc.) and removes password in multiple files.
• Passper for Word: Recovers the document open password and also removes the editing restriction password.
• GuaWord: MS Word command-line password removal utility.
• PassFab for Word: Password recovery tool for protected MS Word documents.

How to Use Online Tools for Locking any Document

Here is a general guide for using any online tool for password protecting any document.

1. Upload the document you wish to password protect to the server of the website.
2. You will be asked to provide and confirm the document open password.
3. If you wish to restrict editing access, you will also provide another password for this.
4. Then the tool will encrypt the document and ask you to download it. 
5. Download it and try to open it. You will be required to provide the document open password to access the content of the file. If editing was also restricted, you be asked to provide the remove editing restriction password.

Check:

• How to Calculate Mean (Average), Median and Mode in MS Excel
• Free Bitcoin Trading Profit/Loss MS Excel Calculator For Crypto Traders

Conclusion

You have learnt how to password protect any word document both online and offline. Also, you learnt how to remove password from any locked word document both online and offline. I also revealed free tools for locking and unlocking word documents online. Feel free to use any method that suits you most.

Drop your questions in the comment section below. Click Here to subscribe to our blog to get notified via email when we drop new tutorial articles and videos. Share this article with your social media friends by clicking a share button below. Enjoy!

How to Calculate Average in Excel

Excel AVERAGE Function

The syntax is:

=AVERAGE(number1, [number2], …) or AVERAGE(cell references or cell range)

Note that in the first syntax, the first argument (number1) is required, while the subsequent ones are optional. You can include up to 255 arguments.

Examples of cell references are A2, B2, C3, etc. Examples of cell range is A2:A5, B2:B5, C2:C5, etc.

From the workers' details in the above screenshot, to calculate the average salary of all the worker, type the following formula:

=AVERAGE(D2:D11) then press Enter key. It will return $1,385 in the cell.

How to Calculate Median in Excel

Median is simply the middle value in a group of numbers when they are arranged in ascending or descending order. 

For example, the median of the following set of numbers: {1, 2, 2, 3, 4, 4, 5} is 3.

Finding the median of an odd number of values in a group is easier. But for even number of values, the medain is the average of the two middle values.

For example, to calculate the medain of these set of values: {1, 2, 2, 3, 4, 4, 5, 5}; you take the average of the 4th and 5th values in the data set. 

That is,  (3+4)/2 = 3.5

The syntax for median function is Excel is:

=MEDIAN(number1, [number2], …) then press the Enter key.

Where:

Number1, number2, … are numeric values you wish to find their median and can be up to 225 arguments. These can be numbers, dates, named ranges, arrays, or references to cells containing numbers. Number1 is required, while the subsequent numbers are optional.

The following are worth noting for Excel median calculation:

• Cells with zero value are included in calculation.
• Empty cells and cells containing text and boolean values are not included in calculation.
• If you type the boolean values directly as arguments in the MEDIAN function, they are counted. The boolean TRUE value is evaluated as 1, while the boolean FALSE value is evaluated as 0. For example, the formula =MEDIAN(TRUE,FALSE,5,6,7) returns 5, which is the median of the numbers {1, 0, 5, 6, 7}.

From the above screenshot of the workers' detail, to calculate the median of the workers' salaries, type the following formula:

=MEDIAN(D2:D11) then press the Enter key.

The formula will return $1,350.

To confirm the answer, you can sort the data in the cells which you wish to find their median either in ascending or descending order. Since number of our data set was even (10), Excel returned the average of the 5th and 6th data (i.e. $1,300 and $1,400) which is equal to $1,350.

You can learn more about calculating median in excel here.

See:

• Learn MS Excel from Scratch for Free
• How to Calculate your CGPA in MS Excel

How to Calculate Mode in Excel

Mode is the value in a data set that has the highest frequency or occurrence. You don't need to perform any calculation to find the mode of a data set. All you need to do is to count the number of times each value occurs in the data set.

For example, the mode of the set of values {1, 2, 2, 3, 3, 4, 4, 4} is 4.

The syntax for mode function is Excel is:

=MODE(range) or =MODE(number1, [number2], ...)
 then press Enter key.

Where:

• Range or number1, [number2], ... is the range of cells or data set you wish to find their mode.

For the workers' details in the above screenshot, to find the mode of the workers' salary, type the following formula:

=MODE(D2:D11) then press the Enter key.

The formula will return #N/A error because all the values in the cell range occurred only once. So there is no mode.

NOTE:

If Excel discovers that there are two or more modes in your data set, the Excel MODE function will return the lowest mode.

Check: 15 Simple Ways To Increase Your Website Traffic For Free

Conclusion

You have learnt how to calculate mean (average), median and mode in any version of Microsoft Excel. You also learnt how to calculate these measures of central tendencies manually in this article. Feel free to apply these tips in any data set of your choice.

Help your social media friends to discover this amazing Excel tutorial by clicking a share button below.

Drop your comments below. Also click Here to subscribe to our blog via email so that we will update you when new WordPress themes are released by these sites.