Category Archives: Android apps

MS Excel Formula List and How to Use these formula..Learn with Examples !!

With more than 30 million users, Ms Excel is famous and very usable software developed by Microsoft. The Code name of MS Excel is Odyssey. Excel is a software program from Microsoft that from Microsoft Office suite of productivity software. Released in September 1985, Microsoft Excel is software for creating and editing spreadsheets which are saved with .xls or .xlsx file extension.

MS Excel is basically used for calculation, pivot tables and other graphics representations. You can keep number record of any data. You can keep monthly budget, salary, expenses and other calculations in Excel. It is very useful software. Excel contains a spreadsheet that has columns and rows. The intersection of columns and rows make cells. We keep data in cells.  There is no restriction to keep only numeric data; you can add text data too. There is a set of formulas to ease your calculation in Excel. It is different from Ms Word. The formulas are very helpful to reduce your calculation work. You can do addition, subtraction, multiplication, division and many more functions within typing a few keys. You will enjoy most sorted browsing experience with MS Excel formulas. Sharp your math with Excel.

Today here we will share information about MS Excel formulas and MS excel shortcut keys:

 

All excel formulas begin with Equal to sign (=) and followed by specific text tag that will denote the formula.  We are sharing some formula here:

1. SUM

Sum means addition of numbers, we can feel comfortable while putting numbers in Excel. No matter what numbers of excel you fill in excel and now looking for total of those numbers. There is a formula there.  = SUM (number 1, number 2, number 3….). The solo aim of Sum is add numbers together. Sum function sums values supplied as arguments; these can be up to 255 arguments. Sum function ignores text values.

Example

 

You can add cell number here too. Even you can add range of cells too. Here you can see sum of cell range.

Example

 

 

2. Average 

Average function in Excel does exactly as its name shows. Average function is used to find average or arithmetic mean of numbers. This work like Sum formula. You can find average of multiple numbers.
=AVERAGE(number1, [number2], …)

Example

Let’s have an example of the formula in Excel software

 

 

3. MAX and MIN 

The MAX and MIN formulas in Excel are used to find the largest and smallest number in a set of numbers, respectively. The use of this formula is very easy.

= MAX (number1, [number2], …)

=Min (number1, [number2], …)

Example

Let’s learn with an example given below:

 

 

4. COUNT & COUNTA

If you have curiosity to find the cells in a given range contain numeric values, you can save your time by using COUNT function. This will count all instantly as you apply the formula.

=COUNT(value1, [value2], …)
In COUNTA function, we can find all cells that are not blank, even they have contained numbers, letters, errors, text, dates, times, values, logical values (True/False), text strings etc.
=COUNTA (value1, [value2], …)

Example

Let’s apply both formula, watch following example please.

 

5. LEN

You often need a perfect formula to count the number of characters in a cell. Yes, LEN is suitable for you needs. You can easily count number of characters in a cell through using it.
=LEN(text)
=LEN (cell no.)

Example

Examples in Excel sheet given below:

 

6. TRIM

TRIM is extremely useful formula in Excel. You can remove extra spaces in text with it. You can get rid of unwanted spaces in text with TRIM formula. There may be multiple methods to avoid extra spaces but you will find TRIM formula, a cool one.
=TRIM(text)

Example

 

7. IF Formula

When we face ‘IF’ anywhere, we suddenly think about logic. It is very popular formula in Excel. It is used to test a specific condition and return a value or do a calculation if condition is met, and if the condition is not met, another value or calculation.
IF(logical_test, [value_if_true], [value_if_false])

Example

For example, the following IF statement command Excel to check the value in B3 and returns “OK” if it’s less than or equal to 10, “Not OK” if it’s less than 10:

=IF(B3>=10, “OK”, “Not OK”)

 

8. AND & OR

These are two very famous logical functions in Excel. These are used to check multiple criteria. Now, you may be eager to know different between both formulas. Let’s talk main difference between both functions:

AND returns TRUE if all conditions are met, otherwise FALSE

OR returns TRUE if any of conditions is met, otherwise FALSE

These formula are not often used as they are but both are massively used as a part of large formulas.

Example

we are using here IF formula with And. We will apply it for 2 columns. It returns “Best” if both values are greater than 2

=IF(AND(A2>1, B2>1), “Best”, “”)

In text of OR formula, you are satisfied with one value greater than 1 then it returns “Best”, you should use OR formula.

=IF(OR(A2>1, B2>1), “Best”, “”)

9. Today and Now

One amazing thing, you can watch current date and time without manually update daily. This magic begins with Today and Now function in Excel. This is also a popular formula in Excel.
=TODAY()            [current date]

=NOW()            [current date and time in a cell.]

Example

=TODAY()            [current date]

=NOW()            [current date and time in a cell.]

10. CONCATENATE

This formula is used in that condition where you want to take values from two or more cells and combine them into one cell; use the CONCATENATE function:
CONCATENATE(text1, [text2], …)

Example

For example, to combine the values from cells B4 and C8, just enter the following formula in a different cell:
=CONCATENATE(B4, C8)

Advertisements

7 Google Products that are immensely useful for All

Today we are again talking about massive search engine giant of the world ‘Google’. Google is pioneer among search engines on the web. Google ranks among top 10 most valuable brands in 2018. We can say that Google is the master of the web. With over 63,000 searches per second, Google is a massive information platform.  You will surprise to know that there are over 2 trillion searches in a year on Google. Google not only offer its search services. Google is a worldwide company and offers several products and services to people online and offline.

Google offers a plethora of products and services. All website owners compete with each other to get high rank in Google searches. Google is extremely useful for every internet users. That was talk about Google search engine but Google has developed or acquired or purchased various useful products for us. I hope you are using most of these products already.  The most important thing these products are free to use for everyone. We will talk about 7 useful products offered by Google.

Google Translate

Google Translate is a free translation tool which offers translation support over 60+ languages.  Google Translate translates short words and sentences translation immediately.

Google Ads

Google ads are also useful services for people. It assists you when you search a new product or service, a relevant ad published there can help you. Ads are main source of income for Google.

Blogger

Blogger is a platform where a user can self-publish his blog. In blogger a user enjoys all readymade features with a few clicks free of cost. He can create his own blog here. Blogger is available in more than 20 languages. Google had acquired it from Pyra Labs.

Android

 

It is very powerful platform that has changed the mobile using experience.  It is a strong platform based on Linux software.  It gives a unique experience on mobile phones. Android was started in 2007 by Google. Millions of people are using Android today. Millions app are working on Android platform. This is very effective and operable platform.

YouTube

One of the biggest video sharing websites, YouTube is powerful media over the web. You can almost find video on every topic you need.  It is considered second largest search engine on the web. Google purchased YouTube in $1.65 billion in November 2006.  People upload videos equal to 300 hours per minute. Over 3 billion videos are watched by people every day. Videos are very useful and entertaining.  People can watch and upload videos free of cost. Wonderful thing about YouTube, even with millions of videos, site works very quickly within seconds.

Google Chrome

Google chrome is one of the most used browsers on the web. It is very simple to use. It is choice of the people. It was started in 2008. It is very quick to open and use. 1/3 of web users are using this browser.

Google Docs

Google Docs is very beneficial tool. People can save their documents and access when the need. It is a free service up to 15 GB storage. Google support various file formats like ppt, xls,doc,docx, xlsx, pptx.

We have sum up a few products/services of Google. Google has several other products like Google Map, Google Pay, Google search, Google Webmaster, Google Keyword Planner, Google console, Gmail, Google Calendar, Google Suit and many more. That’s why Google is king on the web. The focus of Google Company remains to simplify work for people. You can feel ease in use of Google products.

20 Funny and Entertaining Tiktok Videos

Developed by China based company ByteDance, Tiktok is one of the most popular app used by people. More than 500 million downloads on Android platform and over 104 million downloads on ios, Tiktok is a leading entertaining app. Tiktok is called Douyin in china. It is available on both Android and ios platform to create and share video clips (30-60 seconds).

Tiktok app allows users to create music videos of 3 to 15 seconds and short looping videos of 3 to 60 seconds. It is vertical level of craze in India for Tiktok. Tiktok has spread its wings in Asia, USA and in other countries. In 2018, Tiktok became the most downloaded app in USA. Amazingly available in 75 languages, the app covers more than 170 markets.

Started in 2016, Douyin was branded with name Tiktok in global market. Douyin was developed in mere 200 days. The growth of app was astonishingly increased in a year by 100 million users and 1 billion views per day. Tiktok achieved rank one milestone in free downloaded apps in various countries. Tiktok was downloaded more than 800 million times in the world.

ByteDance bought shanghai based startup musical.ly in one billion dollars. Music.ly was very popular social media platform for people. Tiktok merged with musical.ly in August 2018 and made larger community. Tiktok covers 150 markets on global level.

Douyin is a different app from Tiktok and available on developer’s site. It is very popular in china due to its effective marketing campaign. Famous Chinese celebrities are using it. Stunningly over 70 million active users are using this app daily.

Tiktok is a mobile app that allows users to create short videos. It is a platform to share fun, knowledge, talent, art etc. To make a video, users can choose audio music. The music works in background of the video. There are filters to speed up, slow down the videos.

In this post, we are sharing some funny and magical Tiktok videos. We are sure that these will fully entertain you. So without delay, start jumping with happiness and laughter.

You can go with following links of Tiktok to enjoy videos.

  1. Amazing Dance Video
  2. Best dance with fun
  3. Funky dance
  4. Awesome comedy
  5. Very funny clip
  6. Hilarious magic
  7. Stunning magic
  8. Puzzle magic
  9. Good effort
  10. Best ever tricks
  11. Attractive art
  12. Aesthetic art
  13. Beautiful creativity
  14. Awesome drawing
  15. Fabulous rangoli
  16. Something different
  17. Delicious cream
  18. Hefty muscles
  19. Gym style
  20. Fitness savvy

Make your Gmail Work Super easy with these Keyboard Shortcuts

Gmail is probably the most popular free emailing service. It was developed by Google. Million people are using this mail service. Shortcut is the way to save time and energy. You need not to follow complete process. You just press 2-3 buttons and desired action places. The interesting fact behind it is to remain free from use of mouse.  You can do many Gmail functions through keyboard only. Gmail Keyboard Shortcuts are very useful to save time and energy. In this post, we will share Gmail keyboard shortcuts that help to do various functions.

Before start it, you need to keyboard shortcuts on from setting. Read our post “Easy Steps to Enable Gmail Keyboard Shortcuts ” to know the procedure to enable keyboard shortcut function.

Here are Gmail Keyboard Shortcuts:

  • To compose new email = c
  • To search email = /
  • To open task= g+k
  • Mark selected email as important:  =
  • To reply an email: r
  • To reply all: a
  • To forward an email: f
  • To send selected message into Archive: e
  • Shortcut to reach at newer email: k
  • Reach to previous email: j
  • Reach at next message in email thread: n
  • Reach at previous message in email thread: p
  • To mute the conversation: m
  • Jump to inbox view: u

Shortcuts with Ctrl Key

  • insert link: ctrl+k
  • bold: ctrl+b
  • Italic: ctrl+i
  • underline: ctrl+u
  • send email: ctrl+enter
  • Undo: ctrl+z
  • Redo: ctrl+y
  • Spelling suggestions: ctrl+m
  • Indent less: ctrl + [ :
  • Indent more: ctrl + ] :

Shortcuts with shift key

  • Gmail keyboard shortcut help= Shift +?
  • To select series of message= Shift
  • Add a conversation to tasks: Shift + t
  • To mark current message unread: shift+u
  • To move opened email into Trash: shift+3

Shortcuts with Ctrl+shift Keys

  • Previous font shortcut: ctrl+shift+5
  • Next font:  ctrl+shift+6
  • Shortcut to insert number list: ctrl+shift+7
  • To add Cc recipients: ctrl+shift+c
  • Shortcut to insert bullet points: ctrl+shift+8
  • Quote: ctrl+shift+6
  • To add Bcc recipients: ctrl+shift+b
  • To discard draft: ctrl+shift+d
  • Decrease text size: ctrl + Shift + – :
  • Increase text size: ctrl+ shift + + :

Alignment 

  • Left alignment : ctrl+shift+l
  • Right alignment: ctrl+shift+r
  • center alignment : ctrl+shift+e
  • right to left : ctrl+shift+ , :
  • left to right: ctrl+shift+ . :

Alt+Shift

  • strike through: alt+ctrl+5

Kindly reply in comments, if any shortcut is not found in this list; we will definitely add them in our list here. To know about Twitter keyboard shortcuts, click on this link: Twitter keyboard shortcuts. To know WordPress shortcuts click here: WordPress shortcut keys on keyboard.To know about Facebook keyboard shortcuts, click on this link: Facebook keyboard shortcuts.

Easy Steps to Enable Gmail Keyboard Shortcuts

Gmail is undoubtedly the most popular free email service developed by Google. This is available in 105 languages. Billions of people are enjoying it. Google gives 15 GB free storage to Gmail service user. It is advanced service, it automatically scan emails for various purposes like filter spam and malware.  Google always try to develop simple tools for users, Gmail is also in very simple for to work. You can access your email id without complexity. If you want to know how to creat Gmail id, read our post.

We have tried to make you extra information about keyboard shortcuts of Gmail. You can save your time and energy by these keyword shortcuts. You can access your Gmail account with use of mouse.  These keyboard shortcuts are very helpful to reduce your efforts. You can finish your activities within a few seconds. You can instantly react upon email like reply, send another mail etc.

 

To use these keyboard shortcuts, you need to enable settings to use shortcuts (Enable Gmail Keyboard Shortcut). Follow below steps:

SYMBOLIC IMAGE OF GEAR ICON

  1. Login your Gmail id with User name and Password
  2. You will find a gear icon  on top right corner of your Gmail id.
  3. Click on mail gear iconlocated at top right corner of Gmail and select settings.
  4. Click “General Tab”
  5. Click “Keyboard shortcuts” under General tab
  6. There are two options there: Keyboard shortcuts off and Keyboard shortcuts on
  7. Click “Keyboard shortcuts on”
  8. Click save changes.

 

This was the easy process to enable Gmail Keyboard Shortcuts.  After enable it, you can use keyboard shortcuts in Gmail. The magic will start now. You have never experienced such coziness while working with Gmail what you will face ahead. Get rid of clicks of mouse. Go with soft keys of keyboard only. Click here to read next post to know all Gmail keyboard shortcuts.

Kindly reply in comments, if any shortcut is not found in this list; we will definitely add them in our list here. To know about Twitter keyboard shortcuts, click on this link: Twitter keyboard shortcuts. In the same way, you can use Gmail keyboard shortcuts to reduce your emailing work tension, visit here:  Gmail keyboard shortcuts. To know WordPress shortcuts click here: WordPress shortcut keys on keyboard.To know about Facebook keyboard shortcuts, click on this link: Facebook keyboard shortcuts.