THE TOP CORNER

2020-04-19T05:21:00.001+05:30

COUNTIF function

Use COUNTIF, one of the popular function to count the number of cells that meet a criterion;

example, to count the number of times a particular city appears in a customer list.

In its simplest form, COUNTIF says:

=COUNTIF(Where do you want to look?, What do you want to look for?)

For example:

=COUNTIF(A2:A5,"name of sales person")👇

Result will be👇

The best part of this function is you can use it in many different ways.

Lets say you have a table with many numbers in a columns and you just want to count only those numbers which are greater than equal to 32

Formulae bar:

=COUNTIF(B2:B5,">=32")

B2:b5 is ranger here

You can use any criteria...rest is your creativity 😃

5 books that you must read if you are serious about success

2019-02-18T10:30:00.000+05:30

5 books that you must read if you are serious about success

Successful people read a lot, And never stop learning.

If you are not learning and teaching yourself there would be-

"No difference between who you are today and who you would be tomorrow". so keep learning and keep growing.

Here, In this blog-post, I am gonna tell you some of the best success related(self-help) books that you must read. All the books given below are the best of their own category. In short, you would know about 5 best books from 5 different categories that will help you to show the path towards your success.

Before getting to the point, let me clear your views about this question(?)-

why you should read books?

A very very common question!

If you talk about the world's 3rd richest man i.e Warren Buffet. He gives the credit of all of his knowledge and riches to a book called "THE INTEllIGENT INVESTOR" written by Benjamin Graham. Even if you talk about worlds second richest man i.e Bill Gates(Microsoft founder), at this age too, he reads a lot of books and posts its summary on gatesnotes.com

Books are an amazing source of knowledge and you can get the experience of the whole life of an author, sitting in a place and enjoying the books. Because no author wants his books a bit less than perfect.

See also-Top 10 Government MBA colleges in India 2019

Now, let's talk about those golden books that you are going to read after reading my article

1. Rich dad poor dad by Robert T. Kiyosaki

One of the best financial book ever written. This book can raise your financial intelligence to a very high level. the book is written in very simple language so that even people of other backgrounds can easily gain and understand financial topics and its importance.

Rich dad poor dad

In this book, the author had shared his lifelong experience and how he got a secured financial future. He told about his rich dad-actually rich from his thoughts and money and poor dad- though earning

but not able to generate assets.
His definition of assets and liabilities is quite different from what we know.
First chapter-

The Rich don't work for money

2. Think and grow rich by Napoleon Hill

Can you name a single fortune who didn't read this book, I know you can't. The book is very popular among businessmen, entrepreneurs etc.
Every chapter of this book gives you money making secrets, that's why the book is so popular.
The secrets formula that is given in the book to achieve riches
was introduced by Andrew Carnegie to the author who was not aware of this.

Think and grow rich

Before writing this book author analyzed the life of many successful businessmen to find habits and formula which is common among them and followed by them to achieve success.
First few chapters of this book is just a motivational dose to you that you can also achieve success.
The offer on this book is irresistible (just Rs 70), click below to buy-

3. The Power of your subconscious mind by Dr. Joseph Murphy

Best affirmation, given in the book-

I can do all the things through the power of my subconcious mind

This book took its place in both science and religion. The book gives an answer to why you pray & why you must pray.
The author explains that with the help of your subconscious mind you can achieve anything. As the title suggests the book revolves around how to use your mind to achieve your aims and taste the success.

The power of your subconscious mind

>>3 lessons from the book to help you tap into the subconscious part of your mind-
1. Use visualization as a way to exploit the placebo effect.
2. Make use of affirmation to help your mind believe that you can do it.
3. If you can’t decide between several options, give yourself a night to sleep over it.
The offer on this book is irresistible (just Rs 75), click below to buy

See also- Top 5 secrets of India || mysteries of India

4. The 7 habits of highly effective people by Stephen R. Covey

As the title of this book suggests the book tells you about 7 habits that makes you effective and productive as well. This book is one of the best self-help book of all times.

The 7 habits of highly effective people

As per the author, the 7 habits that make you effective are-

Be proactive
Begin with the end in mind
Put first things first
Think win-win
Seek first to understand, then to be understood
Synergize
Sharpen the saw

# Core principle of this book as per covey-

The real change comes not from the outside in,But from the inside out

5. The Alchemist by Paulo Coelho

This book is one of the best motivational book ever written. It's actually a storybook but in reality, it is more than that. Its a guide about following your dream.

The Alchemist

The story is about a shepherd boy who follows his dreams of finding a treasure. To find the treasure he struggles a lot, works on a glass shop for many years, crosses long deserts to make his dream a reality. And in the end, he successfully got his treasure. But there is a good climax at the end that I am not going to tell you because it might ruin your wish to read the whole book. The book is very motivating and written in a very lucid language.

If you think that some other book must be in this list then comment below👇👇 its name along with the reason

If you like my articles don't forget to subscribe to my blog through E-mail.

Thanks for Reading - 5 books that you must read if you are serious about success
love@thetopcorner

Remember sharing is caring
.
.
.
.
.

Top 10 Government MBA colleges in India 2019

2019-02-07T10:30:00.000+05:30

Top 10 Government MBA colleges in India 2019

In this post, I have prepared the list of

Top 10 Government MBA colleges in India

2019. The list is prepared by keeping

In mind various factors Such as quality

of students, research output, Recruitment

, industry interface, reference publications,

and academic productivity.

so this list can help you select the best college for MBA among the TOP 10 list based on your peference.

Table showing colleges with Rank and other Details

College Name	Rank	Fees Total(In lacs)	Intake Exams
Indian Institute of Management Ahmedabad	1	22	CAT
Indian Institute of Management Bangalore	2	21	CAT
Indian Institute of Management Calcutta	3	21	GMAT
Indian Institute of Management Lucknow	4	16	GMAT
Indian Institute of Management Indore	5	16	CAT
Indian Institute of Management Kozhikode	6	16	CAT
Faculty of Management Studies, DU, Delhi	7	0.22	CAT
Jamnalal Bajaj Institute of management studies, Mumbai	8	6	MAHCET & others
Indian Institute of Foreign Trade, New Delhi	9	15.7	GMAT
Shailesh J Mehta School of Management, IIT, Bombay	10	10(appx.)	CAT

Note- if you are unable to view this whole table, please turn on the desktop mode in your browser.
settings(3dot)>Desktop mode tick.

Bonus list:

If you don't want to join colleges and universities (includes both govt. and Private) which provides selection just on the basis of CAT and GMAT, especially for those I have added bonus list of colleges which provides an entrance on the basis of written exam and PI(Personal Interview):

TISS - Tata Institute of Social Sciences
Mudra Institute of Communication
Ambedkar University Delhi
Jamia Millia Islamia
SNAP - Symbiosis University ( 15 Colleges and 23 different specializations)
SMAT (Shiv Nadar University Management Aptitude Test)

See also- 5 books that you must read if you are serious about success

conclusion:

This list -(Top 10 Government MBA colleges in
India 2019)
shows top 10 colleges in India but this list is not conclusive or mean that there are no other colleges. Everybody should select the college based upon his comfort,

level of hard work he can adjust with, financial conditions etc

In India there are lacs of institutions (small & Big), you should select the one which suits your requirement. For more research, you can visit career 360 website

Thank You
love@thetopcorner

remember sharing is caring
If you like my articles you can subscribe to my blog by email

5 Tricks to become a PRO-PUBG player instantly || PUBG tricks and tweaks

2019-02-02T14:22:00.000+05:30

5 Tricks to become a PRO-PUBG player instantly || PUBG tricks and tweaks

Pubg or Player's unknown battleground is gaining very much popularity since its launch. As of now it has over 100 million download on play store leaving other platforms aside.

Gameplay Scene

In this, you can play in three modes solo duo and squad. The scene is that you are dropped with your team-mates on a battlefield and The one who survives the match becomes the winner, so-called

"winner winner chicken dinner".

Now If you are a pubg player and you want to play like a PRO then you are in the right place
because i am going to tell you top 10 tricks that you can apply while playing PUBG.
NOTE-the article is going to be a bit long but it'll certainly make you a pro player.

1. Never wear shoes.

Have you ever wondered,some enemies even come very near to you without making a noise. They enter the without making any footstep sound. They actually use this trick.PUBg is not a fashion show, you are supposed to beat enemies there,so from now never wear the shoes. And this is one of the features of PUBG.

2. Take consumeable to run faster.

This one is also, one of the features of pubg ,if you ever left behind outside the safe zone, try to take consumables like energy drinks, painkillers etc. it will help you to run much faster.

See also- 5 books that you must read if you are serious about success

3. Use the eye button.

On the top right-hand corner of your mobile, you’ll see an icon that looks like an eye. This feature of pubg helps pro player to see around without moving the actual character.if you're hiding behind something and you want to see your enemies , you can use this button to look 360°

4. Don't run with weights!

while running put down your weapon as it reduces weights and helps you to run faster!

5. Make sure you choose the right graphic settings according to your device.

lagging! lagging! lagging! A big problem of pubg.
Most of the time the problem is due to wrong graphics setting according to the device. My preference is always "smooth" graphics.

->>Extra PRO tips<<-

**very imp**

choose right landing locations with least enemies. because it helps you to survive for a longer time

#use wifi instead of mobile network
#Disable auto pick, so that you can choose according to your need.
#choose the green ping server
#lay down when circle is very small
#turn off voice chat ,if they make unnecessary noises.
#use 2 vehicles instead of 1 when in squad.
#use bombs to kill enemies when circle is very small.

For more info you can visit PUBG official website here

Dear reader, thanks for reading "5 Tricks to become a PRO-PUBG player instantly PUBG tricks and tweaks". If you want to get instant notifications of my articles you can easily subscribe me by email in follow by email section.
love@the top corner

Israeli-scientist say: very close to permanent cure for cancer

2019-01-30T23:36:00.001+05:30

Israeli-scientist say: very close to a permanent cure for cancer that would be cheaper than what's available in the market

An Israeli pharma comapany is claiming to the first company to be very close to find a permanent

cure for the deadly cancer disease.

The name of the company is Accelerated Evolution Biotechnologies (AEBi) and the claim is made by the board chairman : Dan Aridor ,of that pharma co. He also said that the treatment for this disease is going to be "revolutionary".

“Our cancer cure will be effective from day one, will last a duration of a few weeks, and will have no or minimal side-effects at a much lower cost than most other treatments on the market,” Aridor told The Jerusalem Post.

According to world wide data an estimated of 18.1 million people are diagnosed with this dangerous disease every year.Further, Every sixth death in the world is due to cancer.

Aridor, chairman of the board of AEBi and its CEO Dr. Ilan Morad, had said their treatment which they call MuTaTo

is essentially on the scale of antibiotic for cancer.

and

What's the treatment?

Morad told the jerusulam post that their team had already ran an experiment on mice and concluded that the experiment showed inhibited human cancer cell growth ,without any effect on healthy cells.And he also said that the treatment would be a week long without any follow up.

The treatment called MuTaTo target only cancerous cells and destroy them, without affecting good cells.

Conclusion:

It is obvious the kind of treatment that AEBi is proposing would going to evolutionary. and if everything gone well we would have treatment for 2 largest reason for deaths across the globe.

Thanks for reading

keep reading

keep sharing

Top 5 secrets of india || mysteries of india || भारत के रहस्य

2019-01-29T20:37:00.004+05:30

Top 5 secrets of india || mysteries of india || भारत के रहस्य

Hey!

As you know that india specially the indian subcontinent is full of various

mysteries and secrets whether these relates to ancient times or the modern

one. India and its government keep various secrets that are unknown to many.

so in this post i am going to tell u some of the mysteries and secrets that are

popular on internet.

--------------------------------------------------------------------------------------------

if you dont want to read you can watch this amazing video on youtube-

The 5 secrets of india are :

The nine unknown men-

The Nine Unknown Men are a two millennia-old secret society founded by the Indian king Asoka 270BC. The legend of The Nine Unknown Men goes back to the time of the Emperor Asoka, who was the grandson of Chandragupta.

Each of the Nine is supposedly responsible for guarding and developing a single book. These books each deal with a different branch of potentially hazardous knowledge that can destroy orover develop humanity. books are based on varied subjects such as cosmology,anti-gravity, etc

Kongka la pass-

Kongka Pass also known as Kongka La is an elevated mountain route in the Chang-Chemno Range on the Line of Actual Control (LAC) between India and China. It is located at an altitude of 5,171 m (16,965 ft). Kongka La is a disputed area on the Indo-Chinese border of Aksai Chin.

The Kongka La region of Aksai-Chin is quite strange and mysterious. Indian troops including ITBP (Indo-Tibet Border Police Force) and Army has reported sightings of UFOs (Unidentified Flying Objects) in this area which were visible to the naked eye, but not reported by the radar.

E-Bomb by DRDO-

The Defence Research and Development Organisation (DRDO) is developing an E-bomb which will emit electromagnetic shock waves that destroy electronic circuits and communication networks of enemy forces.

Netaji Shubhash Chandra Bose's death-

Netaji Subhash Chandra Bose's death. Netaji's death in an alleged plane crash over Taiwan en route Tokyo is a mystery wrapped in the enigma. The crash took place on August 18, 1945, but his body was never recovered. The Taiwan government has denied any such plane crash in Taipei and his death mystery still stands unsolved. Whether our government has any details of it or not is another mystery that we are yet to unravel

Kali 5000-

India's electron-accelerated pulse-power gigahertz microwave beam weapon : KALI (Kilo-Ampere Linear Injector ).The machine essentially generated pulses of highly energetic electrons. Other components in the machine down the line converted the electrons into flash X-rays (for ultra high-speed photography) or microwaves. The electron beam itself can be used for welding.

------------------------------------------------------------------------------------------------------------------------------

connect with us:

Like the Facebook Page!

Follow On Twitter!

Follow on instagram

------------------------------------------------------------------------------------------------------------------------------

Disclaimer- Some contents are used for educational purpose under fair use. Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favour of fair use.