The SEO career path: What it may look like and how to level up

People outside of the world of marketing rarely know what SEO is or what the initialism even stands for.

Within the industry, it’s a familiar term to all formidable marketers. Far less is SEO – search engine optimization – actually understood, though. 

First, it’s important to understand that, while SEO stands for search engine optimization, it is also often used interchangeably to describe the people who do SEO (a.k.a., SEO professionals). An SEO – or search engine optimizer – does SEO. SEOs do SEO.

To avoid any further confusion, we’ll refer to the people who do SEO as SEO professionals.

SEO professionals are a special breed of marketers from many walks of life.

But there are some characteristics and experiences many of us have in common that I will attempt to organize as some of the most useful and shared professional qualities possessed by SEO professionals.

I’ll also cover what the career path to becoming one may look like.

How do you start an SEO career?

Historically speaking, most SEO professionals didn’t plan on SEO as a career – at least until recently (starting in the late 1990s and early 2000s). That was because they couldn’t, really. 

Early in their educational journey, a marketer or digital marketer very rarely – if ever – declared, “I want to optimize websites and chase the Google algorithm for brands to revolutionize the way humans and businesses connect forever.”

The latter part of that dubious statement was probably similar to something many marketers-in-training did declare. 

But getting there through website and brand optimization to gain organic visibility on a search engine was not likely the vehicle they had in mind at the time for accomplishing it.

It’s also rare to meet multiple SEO professionals who’ve forged the same path to becoming one.

But there are certainly overlapping journeys, professions and experiences.

Some common previous areas of expertise for SEO professionals that commonly intersection include teaching, journalism, various math-focused professions and the obvious traditional marketing focuses.

But as the worldwide web evolved the way it has over the last 30 years, opportunities to help brands and people in new ways arose in the marketing realm. And some became more specialized – and lucrative – than ever.

Organic search, paid media and social media are all suitable channels for successful marketing strategies. And they indirectly or directly were created (or adapted to be used) for the growth, prominence, and usefulness of websites.

Today, as a result, high schoolers and college students are able to set their aims on a digital marketing gig specializing in SEO. This will continue to become more common as secondary-education institutions evolve with the world’s needs, job demand, and technology.


Get the daily newsletter search marketers rely on.

<input type="hidden" name="utmMedium" value="” />
<input type="hidden" name="utmCampaign" value="” />
<input type="hidden" name="utmSource" value="” />
<input type="hidden" name="utmContent" value="” />
<input type="hidden" name="pageLink" value="” />
<input type="hidden" name="ipAddress" value="” />

Processing…Please wait.

function getCookie(cname) {
let name = cname + “=”;
let decodedCookie = decodeURIComponent(document.cookie);
let ca = decodedCookie.split(‘;’);
for(let i = 0; i <ca.length; i++) {
let c = ca[i];
while (c.charAt(0) == ' ') {
c = c.substring(1);
}
if (c.indexOf(name) == 0) {
return c.substring(name.length, c.length);
}
}
return "";
}
document.getElementById('munchkinCookieInline').value = getCookie('_mkto_trk');


Possible SEO career routes

Like most careers, there are multiple directions an SEO professional can take. 

It’s probably most likely to start at an agency, and that’s a wonderful place to kick off almost any career related to marketing (or design, account management, video production or sales). 

There are typically a bunch of talented people with a plethora of knowledge and direction to share, so it’s like obtaining an education while getting paid.

You also get the chance to really find your niche in whatever facet of digital marketing you end up in, whether that be SEO itself, or a more-specific component within SEO.

Your first couple of years in SEO are likely to shape your long-term future, at least to some extent.

You can also reinforce and/or stand out demonstrating strengths with the critical soft skills mentioned above and your ability to effectively communicate with internal and external stakeholders.

Agency life allows those skills to shine while also finding out if agency life is for you.

You have to be able to juggle multiple deliverables and multiple deadlines constantly, oftentimes jumping between various projects throughout the same day and throughout the week.

The other direction you could go into is directly in-house at a company.

But if you’re looking to strengthen your SEO skillset as a novice, that could prove difficult without a good SEO at the company to guide you and teach you many of the basics needed to be successful.

Bigger companies would be more likely to have multiple skilled SEO professionals hired on a team at once. Getting into an opportunity like that is tough for someone with little to no experience.

One other potential direction an SEO career could go is strictly freelance or as an independent consultant.

This was probably the most common way to get into SEO back when Google and the marvel of search were still in their adolescent years. Today, it’s become harder as search has become more complex and the choices for vendors have increased significantly across the world.

These are three different potential career routes an SEO could follow. They usually overlap at some or multiple points based on what the SEO wants to do which steers them in that direction.

All three directions also offer the ability to work in a variety of environments (i.e., working in a traditional office setting, working at home, or a hybrid set-up).

SEO, like most digital marketing careers, offers flexibility when it comes to the location worked and also the time of day of which you do that work.

SEO job levels and salary ranges

The SEO career path will likely move from entry-level to experienced roles. And when it comes to salary, like all things in SEO, it depends.

Many variables influence compensation, including your location, work environment, whether you work in-house or agency-side, and experience level, among others. (We’ve done our best to put a general range to put at these levels.)

Entry-level

Salary range: $49K–$72K per year

So many jobs start with a basic, lower-tier position, but it’s also a lot like getting paid to continue hands-on education in your specific field.

Landing that first entry-level position is usually the tougher task. Once you assume the post, you’re going to want to learn as much as you can as fast as you can. Make sure you are absorbing everything you can.

Unfortunately, (or fortunately, for the lucky ones) having a great or terrible leader to guide and train you at this critical stage of your early career could make or break you. Make the most of it.

Junior SEO (SEO analyst, SEO specialist, etc.)

Salary range: $62K–$101K per year

Once you have the basics down and carry out the day-to-day with limited assistance, your entry-level position should move up to something a little bit more senior, like an SEO analyst or specialist (it’s not actually a senior position, though). 

These junior SEO positions usually do a lot of the data pulls and living-in-Excel that builds a solid, effective SEO. These are long-winded tasks that build SEO professionals at the core, and they can’t be replaced or abbreviated.

You’ll likely work closely with an SEO manager and their senior SEO leader to:

  • Carry out tasks that can have a big impact on a client but take quite a bit of data-diving.
  • Explain (then recommend and implement) to get the needle moving significantly.

SEO strategist

Salary range: $69K–$110K per year

After time as a junior SEO, be ready for a bit more reasonability, a bit more account ownership, and even some chances to start training other new hires (regardless of experience levels).

Some of the “training” you do will likely not be highly complicated SEO tasks but rather internal tasks related to the SEO process at the company. This could include:

  • Using tools and datasets.
  • Working closely with internal and client stakeholders.
  • Reviewing and delivering client deliverables.
  • And more.

SEO manager 

Salary range: $80K–$120K per year

SEO managers are typically the first managing-oriented SEO roles within agencies. New SEO managers usually oversee one or two SEO professionals to get a feel for their style, effectiveness, strengths and weaknesses.

These managers also usually manage several client accounts and their own workloads, too.

This period in an SEO career can also allow people to see what their next role may look like by identifying things they do and don’t like.

For instance:

  • Some people love the in-the-trenches SEO work more likely tied to an SEO strategist or analyst.
  • Other people clearly prefer the management-oriented role that has a big impact on the teams around them but doesn’t need to get their hands as dirty or as often as the more-junior-level SEO mentioned above.

Senior manager (head of SEO, director of SEO, etc.)

Salary range: $109K–$192K per year

Following successful posts at the helm as an SEO manager, a senior version of that usually follows.

As a senior manager, which could also be a head of SEO or even a director, you assume significantly more responsibilities, not just as an individual, but as a representative of the agency or company you work at, as well as the clients you work with and represent as the leader of their organic initiatives.

These senior managers tend to:

  • Be some of the biggest players in agency-client relationships.
  • Bring some of the best and brightest ideas.
  • Be able to explain – and sometimes even convince – client stakeholders of the best reasons why some of the hardest, most laborious tasks are very much worth the effort and time.

Vice president

Salary range: $124K–$224K per year

VPs tend to be some of the highest-ranking, SEO-focused positions in the climb to the top. 

Whereas VPs of SEO/organic are still highly integrated with SEO efforts and usually oversee entire teams or more in that area, they still are very much responsible for:

  • SEO strategies.
  • Client communication.
  • New business pitches and research.
  • Operational responsibilities.
  • And much more.

C-suite (CMO, CEO, etc.)

Salary range: $192K–$550K per year

This is likely the ultimate goal of many digital marketers, not just SEO professionals.

Some start their own companies, others join companies as veteran thought leaders and try to take said companies to the next level, and others are just so right for the job, there’s nowhere else they really belong.

Good, effective marketers are always going to be in demand, and the better ones are going to be leading the best companies and their organic-growth initiatives.

By the time an SEO makes it to the C-suite, they are likely:

  • Focused on so much outside of SEO, like all marketing channels – usually both paid and organic – the “big picture” and the “bottom line” that guides the company.
  • Working to achieve the most important goals to ensure growth and profitability for that company and their clients, if they have them.

Of course, these are not definitive paths through the SEO ranks.

Every company and agency has its own way of doing things. Sometimes it looks like this, other times it looks slightly different, and occasionally it looks extremely different.

It’s important to stay on the path that works for you and to take the steps needed to get to where you want to be.

Best ways to advance your SEO career

It’s imperative to understand that SEO education never stops. Staying ahead of the game is one shining factor that separates decent from great SEO professionals. 

As such, educating yourself on the many facets of SEO and digital marketing should be a top priority for someone trying to get their feet wet for the first time in the profession.

Stay on top of changes and developments in the industry through online forums and SEO-related news publications. Keep a constant eye on Google’s Search Blog.

From there, once a gig is landed, the most important aspect of building an SEO career comes at you every day: real-life SEO experience with clients, internal stakeholders, vendors, and/or agency partners, among others.

You’ll continue your education after that, too. Pretty much every day you’ll be reading blogs and news in the ever-changing industry.

You’ll attend cutting-edge conferences and virtual seminars. Eventually, you too may be speaking at these events and guiding SEO professionals from around the world. 

SEO professionals love to help each other as much as they love to learn from each other. It is one of the best parts of being an SEO and it’s why you’ll be hard-pressed to find any great SEO who dislikes another great SEO. We’re in this together and there’s plenty to go around!

The everyday trials and tribulations in the field are the best way to find your path as an SEO.

This allows you to learn:

  • The many unique problems that may arise.
  • How to strategically develop solutions.
  • The very real (and sometimes complicated) relationship struggles with clients, stakeholders, vendors, and more.

Most of all, you should know if SEO is right for you early and often. I know I did, and still very much do.

The post The SEO career path: What it may look like and how to level up appeared first on Search Engine Land.

Original source: https://searchengineland.com/seo-career-path-388834

TikTok has launched an in-app ecommerce feature

In addition to its most recent shopping features, TikTok has just launched TikTok Shop, where users can now make purchases directly through the app.

Availability. TikTok officially began testing in the U.S. this week. It was previously only available in the UK and seven countries in Southeast Asia.

Invite only. TikTok is currently inviting select U.S. businesses to participate in the initiative. That means live streamers from places where the feature is not live will need to continue directing shoppers to third-party websites.

What TikTok says. “We’ve seen the positive impact of TikTok Shop, and we’re excited to continue experimenting with this new commerce opportunity to support businesses of all sizes.” 

In other TikTok news. TikTok has released several new features and products this year, including:

Why we care. The new feature is invite-only, but if the Shop feature becomes available to advertisers and brands globally, you should start testing it as an alternative way to promote your products.

The post TikTok has launched an in-app ecommerce feature appeared first on Search Engine Land.

Original source: https://searchengineland.com/tiktok-has-launched-an-in-app-ecommerce-feature-389575

How the Municibid Government Auction Platform Is Helping Business Owners Circumvent Inflation

Home Business Magazine Online

With inflation here and a potential recession just around the bend, many business owners cannot afford to buy the vehicles and equipment they need for their companies. The sky-high prices of gas and other living expenses have made it so difficult to afford long-term car and business loan payments. This has been difficult for many, but there has been one saving grace amidst it all: the Municibid online government auction marketplace.

Municipalities, police departments, and other governmental entities all over the U.S. are auctioning off their surplus items on Municibid — these auctions are helping business owners purchase the vehicles and equipment they need without having to deal with pricey car payments or take out long-term loans. From heavy-duty trucks to used police cars, vans, boats, tractors, lawn mowers, and snow removal equipment, Municibid offers a plethora of vehicles and equipment for über-affordable prices.

Anyone is able to bid in an auction online, 24/7. For example, one winning bidder in Pennsylvania was able to buy the car he needed, which he was unable to do before due to financial troubles. Here is what he had to say:

“Recently, the Law Firm I worked for was unable to maintain sufficient revenue, and I am unable to secure car loans. As a divorced father of three daughters, my credit was killed. Municibid gave me access to vehicles below dealer prices. I have a Crown Vic thanks to Sherriff Rich in Pennsylvania, and nobody cuts in front of me anymore! LOL Thanks Municibid.”

Here is a quick snapshot of just a few of the many used cars currently up for auction on Municibid:

Academic disciplines

And here is a quick snapshot of the construction equipment, agriculture essentials, and other items company founders need to maximize their business success:

agricultural equipment

Founded in 2006, Municibid, a four-time Inc. 5000 member (2018-2021), serves over 4,000 governments and schools across the US who use Municibid to auction off fire trucks, buses, ambulances, heavy machinery, agricultural equipment, and other surplus goods to the public online. www.municibid.com

The post How the Municibid Government Auction Platform Is Helping Business Owners Circumvent Inflation appeared first on Home Business Magazine.

Original source: https://homebusinessmag.com/businesses/success-tips/how-municibid-government-auction-platform-helping-business-owners-circumvent-inflation/

A Guide to Registering a Company in Ireland

Home Business Magazine Online

Ireland is a great country to start a business because of its pro-business environment, with low taxes and regulations. The country has a strong culture of entrepreneurship which means that there is plenty of support and advice available for new businesses. Ireland also has a highly educated workforce, which means that businesses can find the skilled employees they need to grow and succeed. These advantages may prompt you to start a business in Ireland. If you think that Ireland will suit your business style, you can follow the guide below to know how to register a company in Ireland.

Select company name

When you’ve decided to set up a company in Ireland, one of the first things you need to do is choose a name for your business. This may seem like a relatively straightforward task, but it’s important to take the time to select a name that will be both memorable and reflective of your brand. Keep in mind that once you register your company, you will not be able to change the name without going through the process of re-registering. Therefore, it’s worth taking the time to brainstorm a few potential options before making your final decision.

Choose trading name

Apart from your company name, you will also need to select a trading name. This is the name that will be used on all official documents and correspondence, so it is important to choose something that is both memorable and professional. There are a few things to keep in mind when selecting a trading name. First, it should not be too similar to existing company names, as this could lead to confusion. Second, it should be easy to pronounce and spell, so that potential customers can easily find your business. Finally, it should reflect the products or services that your company offers.

Select directors

One of the most important steps in the company registration process is selecting the directors for your company. The directors are responsible for managing the day-to-day operations of the company and ensuring that it meets all legal and financial obligations. When choosing directors, it is important to consider their experience, skill set, and ability to work together as a team. You should also select individuals who you trust to make sound decisions on behalf of the company. Once you have selected your directors, you will need to register them with the Companies Registration Office. This can be done online, and you will need to provide some basic information about each director, such as their name, address, and date of birth.

Confirm registered office

Another important while registering your company in Ireland is choosing the registered office. This is the address that will be used for all official correspondence and filings, so it’s important to choose a location that is convenient and accessible.

Submit appropriate form

The registration of a company in Ireland is a straightforward process that can be completed online in a matter of minutes. The first step is to submit Form A1, which is available on the Companies Registration Office website. The form must be accompanied by a constitution, which outlines the company’s purpose and membership rules. Once Form A1 and the constitution have been submitted, the company will be registered and assigned a unique identification number. The company will then be required to file an annual return with the Companies Registration Office, detailing any changes to its registered address or shareholders.

If you’re registering a business name, it’s important to submit the correct forms to the Business Names Registry. In addition to Form A1, you’ll need to submit Form RBN1: for an individual, Form RBN1A: for a partnership, and Form RBN1B: for a body corporate. This is to ensure that your business name is properly registered and that all the required information is included. Failure to submit the correct forms can result in delays in processing your application or even rejection of your application. So be sure to check the requirements and submit all the necessary forms.

There are four main types of companies that can be formed in Ireland: private companies limited by shares, public companies limited by shares, private companies limited by guarantee, and unlimited companies.

Private companies limited by shares are the most common type of company in Ireland and are suitable for businesses of all sizes. Public companies limited by shares must have at least seven shareholders and are required to float their shares on a stock exchange. Private companies limited by guarantee are not-for-profit organisations, such as charities, and have no shareholders. Unlimited companies do not have a limit on their liability, meaning that their shareholders could be held personally responsible for the debts of the company. When forming a company in Ireland, it is important to choose the right type of company for your business.

It is usually an easy process to register a company in Ireland. You can do it all online and it only takes a few minutes. The process is simple as long as you have all the details handy and the fees are relatively low. Additionally, you will have full control over your company’s management and operations. If you are not sure how to go about the entire process, you can consult with a professional who knows the rules and regulations thoroughly. This will help you avoid the mistakes that many business owners do at the time of registering their companies in Ireland.

The post A Guide to Registering a Company in Ireland appeared first on Home Business Magazine.

Original source: https://homebusinessmag.com/business-start-up/how-to-guides/guide-registering-company-ireland/

YouTube has expanded its comment translations and smart replies

YouTube has just announced an expansion of its comment translation tools, as well as broader access to Smart Replies, its streamlined, template response option which allows fast replies on videos.

Comment translations. Last year YouTube announced the availability to comment translations within the app via a Google Translate integration.

YouTube said the feature became so popular that it has now added comment translations to Studio Mobile as well.

Smart Replies. The experiment, which provides comment suggestions and templated responses, is also being expanded.

Alphabet Inc.

Smart Replies have been available to some users for a while, but now, YouTube is making them available to all creators in the main app, while it’s also launching a new experiment of Smart Replies on Studio Mobile.

Dig deeper. To learn more about the new translate and smart features, you can watch the video from Creators Insider.

Why we care. The translation feature could make video interaction and engagement easier and more robust for viewers in different countries, and those who speak different languages. If you’re a creator, interacting with your viewers and receiving feedback is a great way to help grow your community.

The post YouTube has expanded its comment translations and smart replies appeared first on Search Engine Land.

Original source: https://searchengineland.com/youtube-has-expanded-its-comment-translations-and-smart-replies-389527

Google Ads Reach Planner now forecasts Video Action campaigns

Advertisers will now have the option to select “Action – Online Conversions” as a goal when setting up your plans in Reach Planner and can also add Video Action Campaigns to existing plans.

What is the Reach Planner. The Google Ads Reach Planner makes it easier for advertisers to plan for Conversions, Views, Reach, and Impressions-based metrics. It provides a forecast for how your media plan might perform, based on your desired audience, budget, and other settings such as geographic location and ad formats.

How it works. Google says that forecasts are modeled on trends in the ad market and the historical performance of similar campaigns run in the past.

Why we care. Advertisers using video will now be able to predict campaign performance using the new tool. This could be helpful for budgeting during the holiday season.

The post Google Ads Reach Planner now forecasts Video Action campaigns appeared first on Search Engine Land.

Original source: https://searchengineland.com/google-ads-reach-planner-now-forecasts-video-action-campaigns-389532

Zuko Nonxuba Discusses Advantages of International Commercial Arbitration

Home Business Magazine Online

Commercial arbitration is a process through which businesses can resolve disputes without going to court. Experts like Zuko Nonxuba in Johannesburg, South Africa, say arbitration is often faster and cheaper than a traditional trial. It allows the parties to choose their arbitrator (or arbitrators) instead of having a judge impose a decision.

There are many advantages of commercial arbitration, especially when it comes to international disputes. This article will explore the top seven benefits of arbitrating an international commercial dispute.

Avoidance of Local Bias

Arbitrators familiar with the law of more than one jurisdiction are often better equipped to deal with international disputes than local judges. Moreover, parties to a global conflict may have confidence in the fairness of an arbitral tribunal that includes members from different countries.

Zuko Nonxuba says this is not to say that international arbitration is immune from local bias. However, the risk of regional bias minimizes by selecting arbitrators from different countries or stipulating in the arbitration agreement that the arbitral tribunal must apply the law of a specific jurisdiction.

Enforcement of Arbitral Awards

Under the New York Convention on the Recognition and Enforcement of Foreign Arbitral Awards (“New York Convention”), arbitral awards rendered in one contracting state can be enforced in another contracting state. As of September 2017, 159 countries were parties to the New York Convention. Thus, there is a strong possibility that an arbitral award rendered in one country will be enforceable in another country.

There is no guarantee of the enforceability of arbitral awards, however. In some countries, prizes may be set aside if the courts find that the arbitral tribunal exceeded its authority or violated public policy.

Flexibility

The flexibility of arbitration allows the parties to tailor the rules and procedures of the arbitral proceeding to fit their needs. For example, the parties can agree on the language(s) to be used in the arbitral proceedings, the number of arbitrators, and whether or not to take evidence orally or in writing.

Zuko Nonxuba says some arbitral institutions, such as the International Chamber of Commerce (ICC), have their own rules that the parties can choose to adopt. However, even when the parties assume the powers of an arbitral institution, they can still agree to modify those rules to fit their needs.

Confidentiality

Arbitral proceedings are generally confidential. The information disclosed during the proceedings is not public unless both parties agree otherwise. In contrast, court proceedings are open to the public.

Regarding international disputes, confidentiality is often essential for parties that do not want sensitive information about their businesses made public.

Speed

Zuko Nonxuba says arbitral proceedings are generally quicker than court proceedings, because they are not subject to many procedural rules that govern court proceedings ― such as service of process, Motions Days, etc.

Speed is often crucial in international commercial disputes because the longer a dispute drags on, the more money the parties will have to spend on legal fees.

Cost-Effectiveness

Arbitration is generally less expensive than litigation, because it does not require attorneys to prepare for and attend numerous hearings and because discovery (the process through which each party requests evidence from the other party) is usually more limited in arbitration than litigation.

This is not to say that arbitration is always less expensive than litigation. Arbitration can be just as expensive as litigation if the parties choose to use an arbitral institution with high filing fees or if the parties choose to have their arbitral proceedings take place in a country with high hourly rates for attorneys.

Predictability

Parties to an arbitration often have greater certainty about how their dispute will be resolved, because they can select their arbitrator (or arbitrators), who will render a binding decision on the dispute’s merits. Moreover, if the parties choose, they can agree in advance on applicable laws and rules of procedure.

Sometimes, however, the predictability of arbitration can be its downfall. For example, if the arbitrator(s) selected by the parties is not impartial, or if the arbitrator(s) make a legal error, the parties may find themselves in the same position they would be in if they had litigated their dispute.

How to Begin Arbitration

The first step in beginning an arbitration is to select an arbitral institution. The ICC, American Arbitration Association (AAA), and London Court of International Arbitration (LCIA) are some of the most popular arbitral institutions. After selecting an institution, the parties must agree on the rules of the arbitral proceedings.

After agreeing on the rules, the next step is to select the arbitrator (or arbitrator). Most arbitral institutions have a list of arbitrators from which the parties can choose. After selecting an arbitrator, the arbitral proceedings begin.

Arbitration is a cheaper, quicker, and more predictable way to resolve commercial disputes than litigation. However, it is not without its drawbacks. Before beginning arbitration, parties should be aware of both the benefits and the risks associated with this dispute resolution.

Conclusion

As you can see, there are many advantages to resolving commercial disputes through arbitration — especially when those disputes involve companies from different countries. If you find yourself involved in such a dispute, you should consider whether arbitration might suit you.

The post Zuko Nonxuba Discusses Advantages of International Commercial Arbitration appeared first on Home Business Magazine.

Original source: https://homebusinessmag.com/management/legalese/zuko-nonxuba-discusses-advantages-international-commercial-arbitration/

Neil Parsont Discusses Excel Data Functions You Need to Know About

Home Business Magazine Online

If you work with data, you know how important it is to manipulate it quickly and easily. That’s where Excel comes in. Experts like Neil Parsont in Boca Raton, FL, understand that Excel is a powerful tool that can help you make sense of your data and find the answers you’re looking for. And, once you know how to use its various functions, you’ll be able to work with data like a pro.

In this article, we’ll introduce you to five essential data functions in Excel that you need to know about. These functions will help you clean up your data, find specific information, and make calculations.

What Is Excel?

Neil Parsont says most people think of Microsoft Excel as a program for creating spreadsheets. While it is undoubtedly true that Excel is an excellent tool for managing numerical data, the program is much more versatile than that. Excel can be used to track household expenses and create complex financial models. Excel is so powerful that businesses often use it for data analysis and decision-making.

One of the things that makes Excel so valuable is its ability to handle large amounts of data. Excel can easily import data from other programs and databases, and it has a variety of built-in functions for cleaning and manipulating data. This makes it an ideal tool for working with data sets that are too large or complex to be managed by hand. Excel’s visual features make it easy to create charts and graphs communicating information clearly and effectively.

Excel is a valuable tool for anyone who needs to work with data. Whether you are a student studying for an exam or a business professional analyzing market trends, Excel can help you make sense of your data and make better decisions.

1. The IF Function

The IF function is one of Excel’s most popular and widely used functions. It allows you to test a condition and return one value if it is met and another if it’s not. For example, let’s say you have a column of student names and their grades. You can use the IF function to return “Pass” if the quality is A, B, or C and “Fail” if the rate is D or F.

2. The VLOOKUP Function

Neil Parsont says the VLOOKUP function allows you to search for a specific value in the first column of a range of cells and return a corresponding value from another column. This function is beneficial when you have large data tables that you need to search through quickly. For example, let’s say you have a list of employees and their ID numbers, and you want to find an employee’s name based on their ID number. You can use the VLOOKUP function to do just that.

3. The COUNTIF Function

The COUNTIF function allows you to count the number of cells that meet specific criteria. This function helps determine how many items are in a given category or range. For example, let’s say you have a list of students’ names and ages and want to know how many students are under 18 years old. You can use the COUNTIF function to find out.

4. The SUMIF Function

The SUMIF function allows you to sum the values in a range of cells that meet specific criteria. This function helps determine the total value of all items in a given category or field. For example, let’s say you have a list of expenses with categories like “travel,” “food,” and “entertainment.” You can use the SUMIF function to sum up all the costs in each class so you can see how much money you’ve spent overall in each category.

5. The INDEX/MATCH Function

The INDEX/MATCH function is two functions that work together — the INDEX function and the MATCH function — to allow you to search for a specific value in a range of cells and return a corresponding value from another column. This function is similar to the VLOOKUP function but more flexible because it doesn’t require your data to be sorted in ascending order (like VLOOKUP does). For example, let’s say you want to find an employee’s name based on their ID number, but your data isn’t sorted in ascending order by ID number. You can find the employee’s name in the INDEX/MATCH function.

Why Are These Data Functions Important?

Neil Parsont says these data functions are essential because they allow you to quickly and easily manipulate your data. With these functions, you can find the answers you’re looking for, make calculations, and clean up your data. So if you work with data, add these essential functions to your toolkit.

Conclusion

These are just five of the many data functions available in Excel — but they’re some of the essential ones for anyone who works with data regularly. If you take the time to learn how to use these functions properly, we’re confident that your data-related tasks will become much easier (and more fun)! You can learn more about Excel and take full in-depth courses to hone your skills, such as the course Neil Parsont created!

The post Neil Parsont Discusses Excel Data Functions You Need to Know About appeared first on Home Business Magazine.

Original source: https://homebusinessmag.com/home-office/computers-and-software/neil-parsont-discusses-excel-data-functions-need-know/

Jasmine teams up with Community Money Advice

Reading Time: 4 mins

Finance Expert Joins Forces With Community Money Advice to Offer You Help This Winter

Finance Expert and founder of MoneyMagpie.com, Jasmine Birtles, who is also patron of debt charity Community Money Advice (CMA), has teamed up with the charity to offer ten tips to streamline your finances and build financial resilience.

With a staggering 91 per cent of people reporting they are feeling the pressure of the cost-of-living crisis and millions of people turning to a second job to help with bills. Jasmine and Martin Bethell of the CMA are looking for as many ways as possible to help people.

“Many of the money troubles people are facing right now are not their fault,” says Jasmine, ”But there are some things we can all do to make a tough situation a little more bearable. There are also definitely ways we can make extra cash on the side to help pay bills and make sure we have at least a few little luxuries that make life better.”

Martin Bethell agrees: “More and more people are really struggling right now to make ends meet and and we think that is really helpful for people to have access to hints and tips that others have found useful. These really can make a difference”

Jasmine and CMA’s top tips

Streamline your utility bills

Make sure you are getting the best deals across the board. Jasmine says, “Often, mobile phones can really rack up our outgoings, so look into getting second accounts on one contract or just out the contract entirely if you already have a phone and get a SIM-only deal. There are loads of really cheap offers there.”

Also, try avoid monthly bank bills. CMA’s Martin Bethell adds that, “There are plenty of none-packaged accounts that have similar deals. Don’t fall for the sales pitch and spend money you don’t need to spend.” 

Stop using your credit cards

Credit card repayments can spiral and when the cost-of-living increases, these can seem unmanageable. First thing to do is speak to your credit card provider and try and negotiate a repayment plan. If, however you are using your card towards your cost of living, then urgently speak to somebody from a debt charity – places such as CMA, StepChange and Turn2Us will be able to help.

“More and more people are using cash as a good way to budget now,” says Jasmine. “With cash you know where you are and once it’s out of your wallet that’s it – you can’t overspend.”

Check Your Eligibility for Income Support and Benefits

A huge amount of people don’t realise that they are eligible for some sort of benefit. Whether it’s a carer’s allowance, a PIP payment or even Universal Credit (UC), you could be entitled to more than you’re getting. Always check to see if you are eligible for help as often UC can help cover some all important bills and living costs which could save you money in ways you hadn’t considered.

Some people don’t realise that these payments can be there for people in employment or for the self-employed too.  They are not just for when you are out of work. Try Turn2Us.org.uk or Entitledto.co.uk to use their calculators and see what you might be entitled to.

Have you got the right tax code?

Check online or call HMRC to be sure you’re not paying too much tax. It has been suggested this year that millions of people are in the wrong tax bracket, if this is so then you could free up hundreds of pounds that you didn’t know you were owed.

Try the tax code checker here https://taxscouts.com/calculator/tax-code-checker/.

Save on Travel

A lot of us have to travel, but many are getting a lot more savvy about it switching to walking and cycling more, car shares and setting up fuel syndicates. Join a car-sharing company like Blablacar or get into renting your car out when you’re not using it on a platform like Hiyacar.com.

Increase Income

There are literally hundreds of ways to make a bit of cash on the side to supplement your income and many are really fun. Whether it’s de-cluttering and selling the stuff online, baking to sell, ironing for others, dog walking or even using cashback sites, people are finding new ways to make some money. We have lots more on MoneyMagpie.com.

Cut Back

The last thing we all feel like doing when the world is scary is cut back on those feelgood things. However, it is sadly a necessity here and there.

Jasmine reminds us, “Millions of us have subscription services we don’t even use. Therefore, just go through your bills and really fine tune your outgoings. But at the same time look for ways to get things for free: what can you share with neighbours and friends? Join some mystery shopping agencies to get free food and entertainment. Search the internet for free days out, free events and free entertainment because it is out there.”

Time When You Shop for Groceries and Make the Most of offers and discounts

Find out when your local supermarkets get their yellow stickers out and this can make a huge difference to your bill. Also, check out the food waste apps such as Olio, UK Harvest and Too Good to Go – as these can save an absolute fortune and really help combat food waste in the process.

Power Efficiency

If you have a smart meter you can check which of your appliances are using the most energy and make sure you use them less. Even if you don’t have a smart meter,  there are now apps that can help you monitor your energy use like Nous.co and Hugo. Using the microwave and air fryer more and the oven less, for example, will make a significant difference to your bills.

Share, share and share

Jasmine says, “The more we can share with our neighbours, friends and families the more we will all have at a lower cost. Share your food, share your tools, share your time (helping to look after each other’s children) and even share your space if you can. That way we all have more but we spend less.”

 

Both Jasmine and Martin want to impress that however hard the economy crisis is hitting you that help is out there.

The post Jasmine teams up with Community Money Advice appeared first on MoneyMagpie.

Original source: https://www.moneymagpie.com/make-money/jasmine-teams-up-with-community-money-advice

What stakeholders should expect from SEO

SEO is a long-term play and requires patience.

I’ve told this to clients and stakeholders hundreds of times during my career.

After a couple of decades in the industry, I still believe that SEO demands time to see results.

SEO is a long-term commitment that should be considered an investment versus an expense.

It is not advertising and does not have the same type of quick return on investment measurement.

However, I have also seen clients and contacts who were told to wait and look at SEO as long-term, then end up getting burnt anyway.

There’s a difference between being patient and just waiting.

Beyond time, other factors go into a solid SEO client/agency partnership – or even in-house resources and teams – to ensure that expectations are defined and managed, so the effort is ultimately successful.

How to define and manage SEO expectations?

SEO expectations include:

  • The amount of time that SEO takes.
  • Hard costs associated with SEO resource investments (internal or external/agency).
  • Soft costs associated with SEO resource investments.
  • Non-SEO resources needed (copy, UX, dev, IT, approvals, etc.).
  • Level of involvement by client/stakeholders.
  • Competitive landscape.
  • Audience volume.
  • Overall ROI opportunity.

That’s a lot of stuff! There’s likely more to add to the list or nuanced ways to break out some of the items into more bullet points.

SEO is big. There are plenty of moving parts. It takes time, money, and a baseline level of understanding to:

  • Learn what you are getting.
  • Know that ROI is possible.
  • Have decision points down the road that are objective and not based on emotion or incomplete data.

How long does SEO take?

SEO takes time. It is a long-term discipline that requires consistent short-term tactics and implementation.

Whether you have an agency, consultant, or in-house person/team managing SEO, you need to mentally prepare for it to take some time to see significant results.

But that doesn’t mean you should detach from the effort, waiting for it all to be fully optimized and performing to your liking.

If you haven’t seen a strategy, tactical plan and goals, you should ask for one. 

There’s no reason to be “floating” or waiting for updates or results or to be led to believe that you should trust someone to handle SEO and that, at some point down the road, it will magically be “done.”

Promises about how long it will take to see specific results should not be expected or made. However, experienced SEO professionals should be able to give you some reasonable expectations based on their strategy, plan, and process – tied to your goals – or at what points you should see certain milestones.

You should expect to know:

  • What milestones are ahead.
  • What metrics and KPIs you’ll be seeing.
  • The level of communication and input you need in the process.

Get the daily newsletter search marketers rely on.

<input type="hidden" name="utmMedium" value="” />
<input type="hidden" name="utmCampaign" value="” />
<input type="hidden" name="utmSource" value="” />
<input type="hidden" name="utmContent" value="” />
<input type="hidden" name="pageLink" value="” />
<input type="hidden" name="ipAddress" value="” />

Processing…Please wait.

function getCookie(cname) {
let name = cname + “=”;
let decodedCookie = decodeURIComponent(document.cookie);
let ca = decodedCookie.split(‘;’);
for(let i = 0; i <ca.length; i++) {
let c = ca[i];
while (c.charAt(0) == ' ') {
c = c.substring(1);
}
if (c.indexOf(name) == 0) {
return c.substring(name.length, c.length);
}
}
return "";
}
document.getElementById('munchkinCookieInline').value = getCookie('_mkto_trk');


How well should I expect SEO to perform?

This question probably could – and should – come before asking how long it will take. However, it sometimes isn’t asked at all until months into an SEO investment.

This is a key question on the front end of any SEO engagement or investment. Much like how long SEO takes, SEOs are often non-committal and can’t guarantee performance.

However, they should be able to do some modeling and projections based on your historical, current, and opportunistic website and business data combined with audience and competitor research.

Suppose there’s a big opportunity to gain new exposure with rankings for new topics and terms, matched with the right content and ability to serve that audience, getting them to convert in a customer journey. In that case, that can be used to do some projecting.

If you know the full investment in any SEO resource (people and tech) plus the other areas that will be needed (copy, IT, etc.), then you can get a pretty good picture of the total monetary investment.

Your SEO should be able to help you with some data to: 

  • Connect the dots with your business information.
  • Calculate possible conversions. 
  • Work through the math to ensure the potential ROI is positive, making for a good business investment overall.

What does SEO success look like?

SEO success can come in many different forms. Return on investment is the one that comes to mind first.

Beyond that:

  • How is SEO performance influencing your customer journey?
  • Is it generating more or new awareness?
  • Is it moving people through to the next step? 

It may not always lead directly to a conversion. Thought leadership and other aspects of exposure and engagement from SEO traffic could be part of your goals and essential in the success equation.

Having a solid partnership with your SEO team is vital as well.

You should be able to trust them to lead the strategy, be transparent, and have open lines of communication on the goals and ROI metrics, making sure no one is caught off guard.

What are warning signs?

Bad SEO warning signs include:

  • Poor communication.
  • Lack of transparency.
  • No conversation around strategy and goals.

These key items are central to so much of what goes right and wrong with SEO efforts. Time, money invested, goal performance metrics, and what it takes to achieve them are critical.

If any of those components aren’t clear, are glossed over, or are missing from your internal or external SEO resources and team, then it should be a cause for concern.

Keep these in mind before you start or call a timeout with your current partner to resolve any concerns before spending additional time and dollars.

Always set and manage SEO expectations

Unfortunately, I know many people who are skeptical about SEO or have given up on it. That tends to stem from the belief that SEO doesn’t work or that SEO providers can’t be trusted, so the effort isn’t worth it.

I totally get it. I’m not saying I’m perfect or that my team is and that every client we’ve partnered with has had an ideal path to their goal results.

However, you can see a profitable path for your SEO efforts. How? By:

  • Managing expectations.
  • Watching for warning signs.
  • Understanding what makes SEO successful.

Yes, there are a lot of moving parts and pieces. 

Yes, SEO takes time and money.

But it doesn’t have to be something you sit back and wait and see while you write checks.

The post What stakeholders should expect from SEO appeared first on Search Engine Land.

Original source: https://searchengineland.com/what-stakeholders-expect-seo-389400