Blog

submitted by /u/Equivalent-Tea-3030 [link] [comments]

submitted by /u/Wanessalucenaw [link] [comments]

A few months ago, we launched a tool that can help you automate YouTube channel discovery and contact information extraction. During this time, we received a lot of help and feedback from you guys, and it was the main factor that allowed us to improve Prospety. We just launched functionality for Instagram profile discovery, and we are again looking for early adopters. This new functionality provides multiple methods to discover and extract data of influencers, followers, and followed profiles. Our features will allow you to: – Discover over 1M of Instagram influencers with advanced search and retrieve their contacts. – Extract standard and contact information from your lists of Instagram profiles. – Extract data of followers and followed profiles. – Pay per profile with email or per scraped profile. No upfront commitments. – Receive your data in no time and an efficient manner. Early adopters will receive 500 free credits, access to the private community group, and premium support. They will be able to request features, provide valuable feedback, and shape the product roadmap. If you are interested or have any questions – do not hesitate and let me know. Feel free to contact me via DM or leave a comment. To apply to the program – visit https://prospety.com/early-adopter-program/ or contact me via DM. submitted by /u/prospety [link] [comments]

You’re sitting across from a hiring manager, or even worse, a group of people interviewing you for a role, and the dreaded question comes up…
“What are your weaknesses?”
You spend what seems like an eternity battling inside your own head, “Do I tell them I’m occasionally late or that I take things too personally?” before settling on a response that makes you groan: “I just care too much and I work too hard.”

While that question isn’t likely to be left off the interview checklist anytime soon, you know it’s likely coming and can spend some time in self-reflection before your next interview, so you can answer it truthfully and respectfully. Its sister question, “What are your strengths” is coming as well, so it’s best to be prepared ahead of time.
What are strengths and weaknesses?
Strengths are a set of skills or character traits you possess that assist you in carrying out your duties in a productive and efficient manner and make you an excellent candidate for a job. Weaknesses are characteristics or shortcomings that when left unchecked, may hamper your ability to do your job well.
It can be difficult to toot your own horn during an interview. Even more challenging, is finding a balance between being honest about some of your shortcomings, without turning the hiring manager off to the idea of hiring you.
Take some time before each interview (and ideally before you apply) to determine what your strengths are and weaknesses are. This is best done in the beginning as self-reflection, however, you may at some point want to enlist the help of people close to you. This can be asking friends, family, or someone you’ve worked with in the past for feedback.
You can create a list of your strengths and weaknesses, and, when it’s time to apply for a job, tailor your responses to its specific qualifications. You can also spend some time researching the company itself, understanding its culture, and determining which of your strengths would be most highly valued.
Thankfully, you don’t have to reinvent the wheel when it comes to your strengths and weaknesses. There are a number of common (and relatable) characteristics that you can share with potential employers.
Strengths and Weaknesses List
Don’t know where to start? Take a look at these strengths and weaknesses examples, and determine which best describes you. Keep in mind that this is a list of “soft skills” which can pertain to any industry and role. Depending on what position you’re applying for, you may also need to share your knowledge of specific software programs and on-the-job experience.
Strengths

Accuracy
Attentive
Clarity
Conciseness
Creativity
Determination
Discipline
Dedication
Empathetic
Enthusiasm
Flexibility
Great listener
Honesty
Hard-working
Innovative
Negotiation Skills
Optimistic
Organization Skills
Patient
Quick learner
Respectful
Trustworthy
Time-management
Team player
Versatility

Weaknesses

Blunt and brazen communicator which can turn some people off
Extremely critical of self
Need time to adjust to change
Perfectionist (which sometimes make it hard to delegate responsibilities)
Procrastinator
Slow to develop rapport with coworkers or subordinates
Shy in new situations
Stressed under pressure
Too sensitive to the needs of others which sometimes allows others to manipulate you

Leadership Strengths and Weaknesses
While there are many similarities, leadership strengths and weaknesses cover a wide range of skills. Consider the different responsibilities you will have as a leader, mainly motivating and managing employees on a daily basis, rather than being responsible for just your own work. Consider some of these common strengths and weaknesses examples for leaders and managers.
Leadership Strengths

Passionate about their work.
Able to understand the needs and emotions of others.
Excellent self-management skills.
Top-notch communication skills (including listening).
Able to motivate and inspire others to do their best work.
Comfortable making decisions quickly.
Willing to be held accountable for their decisions and their actions.

Leadership Weakness

Taking feedback personally.
Too focused on the end goal that employees’ needs go unheard.
Overly concerned with being liked.
Unable to delegate responsibility which leads to burnout.
Disrespectful attitude towards employees.
Poor communication skills.
Afraid of making the wrong decision, which leads to making no decisions at all.

If you see yourself in any of these weakness examples, it may be time to seek mentorship or training, and do some soul searching to determine why you lack in these areas.
How to Share Your Strengths and Weaknesses During a Job Interview
Now that you’ve reviewed many popular characteristics and decided which ones best reflect who you are, it’s time to dig deeper. Ask yourself a very important question… “Why?”
Potential employers don’t want a list of fancy words, they want to get to know you by understanding how these characteristics have served you in your previous work experience. For example, instead of saying, “I have excellent negotiation skills,” say, “I’ve used my excellent negotiation skills to work with new and existing vendors to cut our raw material costs by 52%.”
Paint them a picture of your skills in action and tell them a (true) story they’ll remember well past the last interviewee has left the building. When telling a story, remember to include:

What “life” looked like before the inciting incident.
The problem you faced.
Different attempts you made to fix the problem.
What eventually worked.
How life looks after the incident.

This doesn’t have to be an epic novel, just a quick description of what was going on and how you had the strengths to persevere.
Of course for some, you may be reaching for a new role with new responsibilities. If you know you possess the strengths they are looking for, but haven’t had the opportunity to use them in your current job, be honest. You could say, “I haven’t been able to use this skill in my previous employment, however, I look forward to using it more if you decide to hire me.”
You also have the option of sharing a story from your personal life in which you used this skill. Just make sure to keep it professional, appropriate, and relevant to your desired position.
When it comes to communicating your weaknesses, potential employers want to know that you recognize your shortcomings and are actively working to become a better version of yourself. You’ll want to be honest and forthcoming while creating context around your weaknesses and showing:

How you are working to improve in this area.
How this weakness will not impact your performance in the proposed job.

Like we discussed earlier, you’ll also want to avoid stating a humble brag rather than a weakness. “I’m just so fast at my job that it makes others feel intimidated around me and so it’s difficult for me to connect.” This is false modesty and you won’t be doing yourself any favors.
So there you are, face-to-face with an interviewer and being asked, “What are your strengths and weaknesses?” Rather than panic, know that you’ve taken the time necessary to provide a solid answer (with supporting evidence) to this question.

One of the most valuable functions in Google Sheets is the “IF” functions.
Imagine you want to be able to quickly scan your spreadsheet and answer some key questions. This function will help you do that.

Let’s jump into how it works and see some real-life examples.
What does the if function do in Google Sheets?
In Google Sheets, the if function allows you to check a condition and return a specific value if it’s TRUE.
For instance, say you have three columns in a spreadsheet: channel, target, and profit. You want to know which channels hit a profit higher than the target.
You can use the IF function to do so – the formula logic would look like this: If the target is higher than the profit, it will return “YES.” If not, it will return a “NO.” You can then track that data in another column titled “Goal Met.”
How to Use If Function in Google Sheets
When using the if function in Google Sheets, you must use the following syntax:
IF(logical_expression, value_if_true,value_if_false)
Let’s break down what each one means:

Logical expression refers to the condition you’re checking in the function.
Value if true is the value the function will return if the logical expression is true.
Value if false is the value the function will return if the logical expression is false.

To do this, you’ll need to use the following logical expression symbols:

> to denote greater than
>= to denote equal or greater than
< to denote greater than
<= to denote equal or less than
<> to denote not equal
= to denote equal

Let’s see a real-life example.

Here, we have a spreadsheet with data on how each marketing channel performed. Each channel had a target revenue next to the actual profit. The last column, “goal reached” will be used to quickly answer which channels met the goal.

Select the cell in which the formula will be applied.
Write out the formula following this syntax:
Drag the mouse to apply the formula to relevant cells.

Scared you’ll forget it? Don’t worry. Google Sheets has an autofill feature that will show you the formula as you type it out.

In this case, the formula will be: =if (C2 > B2, “YES” , “NO”). To break that down further, the formula states if the profit from the email channel is higher than the targeted profit, then write “YES.” If it’s lower, then write “NO.”

Keep in mind that the value if true can be whatever you choose. However, in this example, the simple option was choosing the words “YES” or “NO.”
Because the formula includes words, you must use apostrophes so that Google Sheets reads the formula correctly.
If/Then vs. If/And vs. If/Or Functions
In the simplest terms, with “If-Then” you’re checking that one condition is met. In the example above, it was that one value would be higher than the other. Based on that data, the return value would be “YES” or “NO.”
With “If And,” you’re checking multiple conditions for a “TRUE” value. They all have to be “TRUE” for the return value to be “TRUE.”
“If Or” is the exact opposite to “If and.” It also checks multiple conditions but if any one is true, it will return a “TRUE” value.
Here’s a real-world example:

If then – I am going to the store. If you go to the store, the statement is true.
If and – I am going to the store and filling up my tank. You must go to the store and fill up your tank for the statement to be true. Otherwise, it will be false.
If or – I am going to the store and filling up my tank. You could complete either task and the statement will be true. The only time it will be false if you complete neither one.

How to Use If Function with Multiple Conditions
Say you’re running a survey and you want to easily categorize your respondents into two age buckets. You could write a formula that states if respondents are 25 or younger, they’ll be in group “A”. If they’re 26 or older, they’ll be in group B.
This creates multiple conditions under which the value can be written. The formula checks the first condition, if it doesn’t apply, it moves on to the next to find the appropriate value.
Let’s see this in action.

Using the example above, your formula would be as follows:
= IF(A2 < = 25, “A”, IF(A2 >= 25, “B”))

Nested If Function in Google Sheets
In Google Sheets, “nesting” simply refers to placing the “if” function within its own formula to test multiple conditions and return different results based on those tests.
The formula syntax is as follows:
=IF(first_statement,value_if_true,IF(second_statement,value_if_true,value_if_false))
It’s as easy as that.
So, here’s another function you can use to speed up your process when using Google Sheets.