Trending November 2023 # Instagram Marketing For Business: A Complete Guide # Suggested December 2023 # Top 13 Popular

You are reading the article Instagram Marketing For Business: A Complete Guide updated in November 2023 on the website We hope that the information we have shared is helpful to you. If you find the content interesting and meaningful, please share it with your friends and continue to follow and support us for the latest updates. Suggested December 2023 Instagram Marketing For Business: A Complete Guide

If you’re not utilizing Instagram marketing for your business, you’re missing out. Instagram is a great way for individuals and businesses to express themselves.

Most businesses utilize Instagram as a platform where they can connect with existing or potential customers.

For example, they accomplish this by producing content as a means of storytelling.

An integral part of social media for businesses is that it helps to increase brand awareness, drive engagement and reach bigger audiences. This has a huge upside as it can convert to sales.

In this guide, we’ll dive into Instagram marketing strategies you can use to skyrocket your business.

Table of Contents:

1. Logo, Bio, and Link

Here’s an example of an effective profile from us, Followchain.

Use a logo for your profile photo. If you don’t have a logo, make sure to pick a photo that expresses your brand.

Additionally, story highlights reinforce your brand’s identity. Treat it like a board where you can showcase your brand’s goods, services, unforgettable moments or launch dates.

Here’s another example of an effective profile by YouTube:

YouTube has consistent story highlights, one with a prominent thumbnail challenge that keeps its audience engaged.

For bio-wise, short and simple ones are the best.

Like any one-liner pitch, you want people to understand your business the first time you say it.

Keep your bios in one sentence and write them in plain English. Don’t use any jargon.

If you haven’t already noticed, YouTube’s bio has only three words.

Here’s another example by Pinterest:

Did you notice anything distinctive about these profiles?

The link provided in their bio isn’t directly linked to their sites.

If your brand has lots of content published from various platforms, a single link wouldn’t be enough. This is why many other brands are utilizing tools like LinkTree or chúng tôi to connect all their content in one link.

It’s a great idea to utilize these tools for your business if you have other content that you want to link your audience to.

2. Theme

You need a consistent, eye-catching theme if you want your brand to shine.

Stick to a theme that has similar or complementary colors to your logo.

We like to retain the same colors from our logo – white and blue.

Hence, our theme mostly comprises of graphics with these colors.

Here’s another example of a business that stuck to a consistent theme:

Starbucks nailed it using photos with objects that complement their logo.

Here’s another one:

Prada accomplished this in one of their campaigns, Prada Linea Rossa, which underscores its foundations and origins in the 1990s sportswear. It marks the precision of the lines and improvisation of aesthetics that defined the look of the era.

Lessons learned: Consistency is key. Make use of a consistent theme and stick with it.

Captions provide an opportunity for you to express your business. Everyone loves a good story, be it a pitch or a sale.

But here’s the debate – should you write longer or shorter captions?

Various sources recommend people to write longer captions because they are great for storytelling and driving engagement.

Here’s an example of a longer caption from Instagram:

However, other sources suggest that shorter captions are the way to go.

Here’s a shorter caption, from Apple:

Both of these photos are art forms can be used as an analogy. Art can speak a thousand words or a couple of words; depending on the person who views it. It’s extremely subjective.

Here’s what we believe:

Short and sweet captions are the most effective.

If your caption is too long, most people won’t even bother to read till the end so it’s redundant to write something more than 150 characters.

At the end of the day, captions don’t really matter. What’s more important is the amount of engagement you’re giving or reciprocating to others (extended on tip number 5).

However, that being said, there is still one tip that every business should utilize in their captions.

Include a call to action at the end of every caption

Example: ‘link in bio’.

This one simple tip can lead to a bigger amount of conversions (traffic to your website).

4. Instagram Stories

Instagram stories is a great way to keep your audience updated to the latest happenings of your business.

Moreover, it can drive a lot of one-on-one conversations, polls or feedback because it’s such a great ice-breaking tool.

Example: If you’re launching a product, you can utilize Instagram’s countdown feature in your stories to inform your audience about its launch date.

This feature allows your followers to be notified when the countdown hits 0 if they set a reminder.

So, this has the potential to drive a lot of sales, sign-ups and more.

You can also utilize Instagram Poll Stickers to gather user feedback.

Instagram Polls is an awesome way to prompt users to interact with your story.

You can use this if you want to gather your user’s thoughts on something. It could be a poll for a future update or an improvement to be made.

Another great use of the story feature is the ability to share your post on your story.

Example: If you were to post something, you can add it to your story as well to prompt your followers to engage in your post. This is incredibly useful because some people view stories more than posts.

A simple heart icon is enough to tell your followers to spread some love to your recent post.

You’ll be surprised how effective yet simple this is.

5. Always Engage

This shows that you actually care about your followers, (or customers in this sense).

Example: Wendy’s does this extremely well. Not only on Instagram but also on their other socials.

Be like Wendy’s.

Unfortunately, many businesses and individuals are unable to accomplish this because they get it wrong.

You can’t create a business account for the sole intention of taking and not giving. Treat the account as an individual one and your followers as friends.

That being said, following others back is a must. Don’t bother building a good following/followers ratio. Instead, try to build rapport. It’s unforgivably cringeworthy seeing business accounts with an ‘exceptional’ following/followers ratio, but terrible engagement rates.

Especially if you’re a small business, not many people are aware of your brand.

If you want to have increased engagement, you’ll have to give engagement first. It doesn’t work the other way around.

6. Instagram Direct Messages

Instagram Direct Messages is an unconventional way to market your business, drive sales, or sign-ups. It’s also one of the best ways to get your message across to your customers (or potential customers) if done right.

This is because the open rate of direct messages is incredibly high, well above 70%.

However, mastering the art of direct messages takes multiple trials and errors.

For a start, you should never direct message users at random. Here’s why:

You’re not providing any value.

Nobody will be interested in your product/service.

One does not simply break the ice by selling.

To be able to successfully send a direct-message that guarantees a reply, you’ll need to find and target a group of users that need your product/service right now.

This is incredibly challenging and you’ll have to do lots of research.

Having said that; if you manage to pull it off, the results will be outstanding.

Instagram Direct Messages can also be utilized as customer service.

If your business is small, Instagram Direct Messages is sufficient enough for customer service so you don’t have to pay for software.

It’s a quick and easy way for your customers to contact you for any questions or inquiries.

Moreover, 500 million people use Instagram daily. This makes it seamless for customers to contact you as most of them are on Instagram on a daily basis.

Instagram Direct Messages is a quick way to pitch your product/service.

Here’s a quick tip: Whenever someone follows you, you can send them a quick message thanking them for the follow, and then introducing your business or provide them with an offer/discount codes.

Example: “Hey, thanks for the follow! Just want to inform you that our entire store is 15% off currently. Just use code “x” at checkout.”

Here’s an additional tip if you have an Instagram Business Account:

You can utilize Instagram’s Quick Replies to respond instantly to the questions you receive most often.

This is super helpful if you receive the same questions multiple times and you want a quick way to respond to them.

However, this works the same as a keyboard shortcut, so it’s pretty redundant if your phone already has this feature.

Hashtags are a great way to increase the reach of your posts.

However, finding the right hashtags is really difficult.

In my other article, 7 Effective Ways To Increase Your Instagram Engagement, I listed down a quick guide for you to find and use the best hashtags for maximum engagement.

There are millions of hashtags on Instagram, but only a few of them drive a large number of likes to your post.

Here’s a recap:

The key to this strategy is to find the best combination of hashtags that gets the highest number of likes.

Then re-using it for your future posts.

Important note: Limit your hashtags to 30 or your account may be shadowbanned.

If you don’t know what a shadowban means, it’s basically the act of hiding your posts on your followers’ feed, the explore page and/or your username on the search results.

This will negatively affect the reach of your posts drastically.

8. Post during peak hours (and don’t spam)

According to ExpertVoice, the best time to post on Instagram (that has the best engagement rate at 4.9%) is Wednesday around 5:00 a.m., 11:00 a.m. or 3:00 p.m.

DayEngagement rateMonday4.4Tuesday4.73Wednesday4.9Thursday4.76Friday4.72Saturday4.66Sunday4.62

That being said, it still depends on the country and demographics of your followers.

Your engagement rates might vary depending on the location and time-zone of your followers, so there isn’t a strict time to post on Instagram.

To find the best time to post, you should do a trial and error and post at different times to see when works best.

Please, don’t over-post.

This is an example of a frequently asked question: Why am I getting fewer likes for multiple posts on Instagram?

The answer is simple, your posts will be regarded as spam.

Nobody likes getting their feed flooded by the same person, it’s disruptive and prevents them from viewing other user’s posts.

It’ll be natural for someone to like one of your posts on their feed and ignore the rest because it’s ‘overkill’. Moreover, your posts are more likely to be muted if your photos appear way too many times on someone’s feed on a single day.

A better approach is to utilize Instagram’s multiple photo feature (if you’re looking to post consecutive photos).

Example: Multiple photos feature

Try to post less often, (once per day is more than sufficient). This gives time for your previous posts to catch up on likes (especially if your followers are in a different time-zone).

9. Growing your followers

Growing your followers is one of the highest priorities for Instagram marketing, second to growing your engagement rates.

If you’ve just started a business account, you may have a couple of these questions:

“How am I supposed to grow my followers from 0?”

“Nobody knows about my account, how do I increase awareness?”

Instagram Growth is hard, especially if you’ve just made a new account.

At the end of the day, ‘You have to spend money to make money’. Similarly, you have to follow others to gain more followers. This is crucial if your account is completely new, and has no reach whatsoever.

You can leverage Followchain’s community to grow your followers.

If you’re struggling to grow your Instagram followers, you can join our follow for follow community, Followchain.

Followchain acts as a single-page thread where you can share your Instagram username.

Firstly, you’ll have to sign up and create an account.

A verification link will be sent to your email, this may take a few minutes.

If you haven’t received it, please check your junk/spam mail!

After you’ve confirmed the verification, log in with your newly created username and password.

Here’s how the community works:

You simply share your Instagram link, follow users that interest you and direct-message them for a follow-back!

By joining Followchain, you can make your Instagram account discoverable by thousands of people, for free! ?

If you’re interested to know more about growing your Instagram followers, you can read this article: 7 Actionable Ways To Grow Your Instagram Followers.

10. Growing your engagement rates

Food for thought: If you post something that gets little to no engagement, what’s the point of posting it anyways?

This is why engagement conquers everything.

If you have lots of followers but low engagement rates, the quality of your account is poor from any user’s point of view.

Your number one focus on Instagram marketing should be growing your engagement rates.

These are several effective ways you can use to improve your engagement rates.

Here are some quick tips you can use right away to skyrocket your engagement rates:

Unfollow ghost followers

There are apps available on the app/play store that tracks this.

However, most of them require you to pay as it is part of their premium features.

Always engage on posts in your feed

You should consistently engage with other user’s posts.

Some people will start to notice and reciprocate. Thus, increasing your likes.

Add your post to your story

With an emphasis on point 4, stories are a great way to drive engagement to your posts.

Whenever you post something, immediately add it to your story.

Some people browse Instagram stories more than liking posts.

Connect with people you know on their Instagram

You should constantly be asking for people you know for their Instagram username, especially the ones who are active.

Friends are family are more likely to engage with your posts as they are closer to you.

You can also follow mutuals as they are more likely to follow you back and engage.

For a full guide on how to grow your engagement rates on Instagram, go to 7 Effective Ways To Increase Your Instagram Engagement. This article mentions why engagement rates matter and changes you can make to improve it.

Bonus: Content Ideas

Content can come in many different forms, the possibilities are endless.

Hence, here are some content ideas for your business, ripe for taking!

1. Graphics

Source: Slack

2. Tweets

Source: GaryVee

Tweets are extremely simple to post!

If you have Twitter, all you have to do is take a screenshot of your tweet, crop it, and share it on Instagram.

3. Videos

Source: YouTube

Videos are a fantastic way to get your message across.

Keep your videos short to captivate your audience.


Source: success.rule

Heard or saw an inspiring quote recently?

Share it on Instagram!

5. Memes

Source: GaryVee

Memes add humor to your business.

It’s also a great form of content that caters to the younger demographic.

Are you struggling with growing your Instagram followers? Stop paying for agencies that require your Instagram password or growth services that utilize bots or fake followers. Followchain is the only solution you need. Sign up and create an account for free today.

Author: Lim How Wei. Lim How Wei is the founder of Followchain, a community that simplifies growth and networking for Instagram users. Feel free to follow him on Instagram.

You're reading Instagram Marketing For Business: A Complete Guide

Technical Seo For Sports Websites: A Complete Guide

You are familiar with the fast-paced, ever-changing nature of the sports website management industry. Your site provides the latest sports news and information, including live score updates. But if people can’t easily find it, all your great content is for naught. This is where A Comprehensive Guide to Technical SEO for Sports Websites comes in!

This guide will teach you everything you need to know about technical SEO for sports websites so you can stay ahead of the competition. We can help you speed up the time it takes for pages to load and make your site mobile-friendly, among other things. Prepare to enter the exciting world of technical search engine optimization for sports-related websites!

Boosting Your Conversion Rate: What You Need to Know

Every website co must consider the following to increase their conversion rate −

A website that is user-friendly and intuitive

Use a simple and easy navigation system for your users

Easy-to-read fonts and detailed website

An appealing product range

Properly designed call-to-action buttons

Is SEO Necessary for a Sports Website, and why?

Do you know why the sports industry is booming? The sports market is one of the most competitive in today’s era. Every year, more and more sports websites develop their own goods and services. All sports goods sales have increased because more people want to be healthy and fit.

The booming sports and recreation industry includes sports, fitness, sportswear, and shoes. So, if you work in the sports retail business and have an online store, you need an SEO strategy.

The First Step: The Value of Technical SEO

Technical SEO is like the unsung hero of the internet, quietly working to improve your site’s performance and visibility in search results. Why it’s so essential for sports websites −

Google or any other search engine use “spider or crawlers” robots to crawl and index your website. Make it easier for people to find your sports website by making it easy for search engines to crawl and index it. If crawlers can index your website better your site will be among to SERP results.

An excellent user experience is achieved when a website is quick to load, simple to use, and looks good on any device.

Now that we’ve established its significance let’s get into some of the fundamentals of technical SEO for sports websites.

Optimizing Your Site’s Speed

Sports fans, who want up-to-the-moment information, are among the minor patients of Internet users. Here are some tips for making your sports website faster −

Compressing Source Code for Web Pages

Obviously, you don’t stuff your website with unnecessary things. Therefore, remove all the extra stuff in your website like −


CSS, and

JavaScript files.

Your website will load faster if the file is small.

Image Enhancement

High-resolution images, while beautiful, can significantly slow down a website. TinyPNG and ImageOptim can help you compress and optimize your images to load quickly without losing quality.

Mobile Optimization and Responsive Design

Optimizing your sports website for mobile use is essential, as more and more people are now accessing their favorite sites from their phones and tablets. How? Read on!

Use a Mobile-Friendly Layout

With a flexible design, your website will look great and work well on any computer, phone, or tablet. Because of this, both user happiness and search engine results will go up.

Increase Page Load Time on Mobile Devices Schema Markup: Making It Easier For Search Engines To Read And Index Your Work

Schema markup is structured data that improves a site’s readability for search engines. Schema markup for your sports website will allow you to −

Having content easily understood and presented by search engines will increase your site’s visibility in voice search results.

The following schema types should be considered when implementing schema markup for a sports website.

SportsEvent − A class for describing sporting events, including the name, date, location, and participants of the event.

SportsTeam’s mission is to serve as a resource for identifying sports teams and their players.

Athlete − Used to highlight details about specific athletes, such as biographical information and career highlights.

You can use resources like Google’s Structured Data Markup Helper or chúng tôi to generate the necessary code for your website.


Every facet of technical SEO is important for your site’s success, from improving load times and mobile friendliness to adding schema markup. Get going immediately to give your sports website the edge it needs to succeed.

A Complete Guide To Tensorflow Dataset

Introduction to TensorFlow Dataset

Basically, TensorFlow acts as a collection of different kinds of dataset and it is ready to use in another word, we can say that it is one kind of framework that is used for Machine Learning. The main purpose of the TensorFlow dataset is that with the help of the TensorFlow dataset, we can build the pipeline in a machine learning application.

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

What is TensorFlow Dataset?

Profound learning is a subfield of AI or we can say that machine learning is a bunch of algorithms that is propelled by the design and capacity of the cerebrum. Basically, TensorFlow is used for the AI framework or we can say that machine learning framework and it directly gives the straightforward solution to implement the AI concept.

You can utilize the TensorFlow library due to mathematical calculations, which in itself doesn’t appear, apparently, to be all through the very novel, yet these assessments are finished with information stream charts. These hubs address numerical tasks, while the edges address the information, which as a rule are multidimensional information exhibits or tensors, which are imparted between these edges.

TensorFlow Dataset Example Model

Let’s see the example of the Tensorflow dataset as follows:

Datasets is another approach to make input pipelines to TensorFlow models. This API is considerably more performant than utilizing feed_dict or the line-based pipelines, and it’s cleaner and simpler to utilize.

Normally we have the following high-level classes in Dataset as follows:

Dataset: It is a base class that contains all the methods that are required to create the transformed dataset as well it also helps initialize the dataset in the memory.

TextLineDataset: Basically we need to read the line from the text file, so for that purpose we use TextLineDataset.

TFRecordDataset: It is used to read the records from the TFRecord files as per requirement.

FixedLengthRecordDataset: When we need to read the fixed size of the record from the binary file at that time we can use FixedLengthRecordDataset.

Iterator: By using Iterator we can access the dataset element at a time when required.

We need to create the CSV file and store the data that we require as follows: Sepailength, SepalWidth, SetosLength, SetosWidth, and FlowerType.


In the above-mentioned input value, we need to put it into the CSV file which means we read data from the CSV file. The first four are the input value for a single row and FlowerType is the label or we can say the output values. We can consider a dataset of input set is float and int for the output values.

We also need to label the data so we can easily recognize the category.

Let’s see how we can represent the dataset as follows:


types_name = ['Sepailength','SepalWidth',' SetosLength',' SetosWidth']

After the training dataset, we need to read the data so we need to create the function as follows:


def in_value(): ………………… return({'Sepailengt':[values], '……….'}) Class Diagram for Estimators

Let’s see the class diagram for the Estimators as follows:

Estimators are an undeniable level API that diminishes a significant part of the standard code you recently expected to compose when preparing a TensorFlow model. Assessors are likewise truly adaptable, permitting you to abrogate the default conduct on the off chance that you have explicit prerequisites for your model.

We can use two ways to build the class diagram as follows:

Pre-made Estimator: This is a predefined estimator’s class and it is used for a specific type of model.

Base Class: It provides complete control over the model.

Representing our Dataset

Let’s see how we can represent the dataset as follows:

There are different ways to represent the data as follows:

We can represent datasets by using numerical data, categorical data, and ordinal data, we can use anyway as per our requirement.


import pandas as pd_obj data_info = pd_obj.read_csv("emp.csv") row1 = data_info.sample(n = 1) row1 row2 = data_info.sample(n = 1) row2


In the above example we try to fetch the dataset, here first we import the pandas to implement the AI program after that we read data from the CSV file as shown, here we have an chúng tôi file and we try to read the data from that file.

The final output or we can say that result we illustrated by using the following screenshot as follows.


Similarly, we can display the second row same as above.

Importing Data TensorFlow Dataset

Let’s see how we can import the Data TensorFlow dataset as follows:


import tensorflow as tf_obj A = tf_obj.constant([4,5,6,7]) B = tf_obj.constant([7,4,2,3]) res = tf_obj.multiply(A, B) se = tf_obj.Session() print( se.close()


By using the above we try to implement the TensorFlow dataset, here first we import the TensorFlow as shown, and after that, we write the two different arrays A and B as shown. After that, we make the multiplication of both arrays and store results into res variables. In this example, we also add a session and after the complication of the operation, we close the session.

The final output or we can say that result we illustrated by using the following screenshot as follows.


Freebies TensorFlow Dataset

Basically, the Tensorflow dataset is an open-source dataset that is the collection of datasets we can directly use during the machine learning framework such as Jax, and all datasets we can set by using the TensorFlow as per requirement.

It also helps us to improve our performance.


From the above article, we have taken in the essential idea of the TensorFlow dataset and we also saw the representation of the TensorFlow dataset. From this article, we saw how and when we use the TensorFlow dataset.

Recommended Articles

We hope that this EDUCBA information on “TensorFlow Dataset” was beneficial to you. You can view EDUCBA’s recommended articles for more information.

Hyperlinks In Excel (A Complete Guide + Examples)

Excel allows having hyperlinks in cells which you can use to directly go to that URL.

There are many things you can do with hyperlinks in Excel (such as a link to an external website, link to another sheet/workbook, link to a folder, link to an email, etc.).

In this article, I will cover all you need to know to work with hyperlinks in Excel (including some useful tips and examples).

There are many different ways to create hyperlinks in Excel:

Manually type the URL (or copy paste)

Using the HYPERLINK function

Using the Insert Hyperlink dialog box

Let’s learn about each of these methods.

Manually Type the URL

When you manually enter a URL in a cell in Excel, or copy and paste it in the cell, Excel automatically converts it into a hyperlink.

Below are the steps that will change a simple URL into a hyperlink:

Select a cell in which you want to get the hyperlink

Similarly, when you copy a URL from the web (or some other document/file) and paste it in a cell in Excel, it will automatically be hyperlinked.

Insert Using the Dialog Box

If you want the text in the cell to be something else other than the URL and want it to link to a specific URL, you can use the insert hyperlink option in Excel.

Below are the steps to enter the hyperlink in a cell using the Insert Hyperlink dialog box:

Select the cell in which you want the hyperlink

Enter the text that you want to be hyperlinked. In this case, I am using the text ‘Sumit’s Blog’

In the Insert Hyperlink dialog box, enter the URL in the Address field.

Press the OK button.

This will insert the hyperlink the cell while the text remains the same.

There are many more things you can do with the ‘Insert Hyperlink’ dialog box (such as create a hyperlink to another worksheet in the same workbook, create a link to a document/folder, create a link to an email address, etc.). These are all covered later in this tutorial.

Insert Using the HYPERLINK Function

Another way to insert a link in Excel can be by using the HYPERLINK Function.

Below is the syntax:

HYPERLINK(link_location, [friendly_name])

link_location: This can be the URL of a web-page, a path to a folder or a file in the hard disk, place in a document (such as a specific cell or named range in an Excel worksheet or workbook).

[friendly_name]: This is an optional argument. This is the text that you want in the cell that has the hyperlink. In case you omit this argument, it will use the link_location text string as the friendly name.

Below is an example where I have the name of companies in one column and their website URL in another column.

Below is the HYPERLINK function to get the result where the text is the company name and it links to the company website.

In the examples so far, we have seen how to create hyperlinks to websites.

But you can also create hyperlinks to worksheets in the same workbook, other workbooks, and files and folders on your hard disk.

Let’s see how it can be done.

Below are the steps to create a hyperlink to Sheet2 in the same workbook:

Select the cell in which you want the link

Enter the text that you want to be hyperlinked. In this example, I have used the text ‘Link to Sheet2’.

In the Insert Hyperlink dialog box, select ‘Place in This Document’ option in the left pane.

Enter the cell which you want to hyperlink (I am going with the default A1).

Select the sheet that you want to hyperlink (Sheet2 in this case)

Note: You can also use the same method to create a hyperlink to any cell in the same workbook. For example, if you want to link to a far off cell (say K100), you can do that by using this cell reference in step 6 and selecting the existing sheet in step 7.

You can also use the same method to link to a defined name (named cell or named range). If you have any named ranges (named cells) in the workbook, these would be listed in under the ‘Defined Names’ category in the ‘Insert Hyperlink’ dialog box.

Apart from the dialog box, there is also a function in Excel that allows you to create hyperlinks.

So instead of using the dialog box, you can instead use the HYPERLINK formula to create a link to a cell in another worksheet.

The below formula will do this:

=HYPERLINK("#"&"Sheet2!A1","Link to Sheet2")

Below is how this formula works:

“#” would tell the formula to refer to the same workbook.

“Sheet2!A1” tells the formula the cell that should be linked to in the same workbook

“Link to Sheet2” is the text that appears in the cell.

You can also use the same method to create hyperlinks to other Excel (and non-Excel) files that are in the same folder or are in other folders.

For example, if you want to open a file with the chúng tôi which is in the same folder as your current file, you can use the below steps:

Select the cell in which you want the hyperlink

In the Insert Hyperlink dialog box, select ‘Existing File or Webpage’ option in the left pane.

Select ‘Current folder’ in the Look in options

Select the file for which you want to create the hyperlink. Note that you can link to any file type (Excel as well as non-Excel files)

[Optional] Change the Text to Display name if you want to.

You can also do this using the HYPERLINK function.

The below formula will create a hyperlink that links to a file in the same folder as the current file:

=HYPERLINK("Test.xlsx","Test File")

In case the file is not in the same folder, you can copy the address of the file and use it as the link_location.

This one also follows the same methodology.

Below are the steps to create a hyperlink to a folder:

Copy the folder address for which you want to create the hyperlink

Select the cell in which you want the hyperlink

In the Insert Hyperlink dialog box, paste folder address

You can also use the HYPERLINK function to create a hyperlink that points to a folder.

=HYPERLINK("C:UserssumitDesktopTest","Test Folder")

To use this formula, you will have to change the address of the folder to the one you want to link to.

You can also have hyperlinks which open your default email client (such as Outlook) and have the recipients email and the subject line already filled in the send field.

Below are the steps to create an email hyperlink:

Select the cell in which you want the hyperlink

Enter the E-mail address and the Subject line

[Optional] Enter the text you want to be displayed in the cell.

You can also do this using the HYPERLINK function.

The below formula will open the default email client and have one email address already pre-filled.

Note that you need to use mailto: before the email address in the formula. This tells the HYPERLINK function to open the default email client and use the email address that follows.

In case you want to have the subject line as well, you can use the below formula:

In the above formula, I have kept the cc and bcc fields as empty, but you can also these emails if needed.

Here is a detailed guide on how to send emails using the HYPERLINK function.

If you only have a few hyperlinks, you can remove these manually, but if you have a lot, you can use a VBA Macro to do this.

Manually Remove Hyperlinks

Below are the steps to remove hyperlinks manually:

Select the data from which you want to remove hyperlinks.

The above steps would instantly remove hyperlinks from the selected cells.

In case you want to remove hyperlinks from the entire worksheet, select all the cells and then follow the above steps.

Remove Hyperlinks Using VBA

Below is the VBA code that will remove the hyperlinks from the selected cells:

Sub RemoveAllHyperlinks() Selection.Hyperlinks.Delete End Sub

If you want to remove all the hyperlinks in the worksheet, you can use the below code:

Sub RemoveAllHyperlinks() ActiveSheet.Hyperlinks.Delete End Sub

Note that this code will not remove the hyperlinks created using the HYPERLINK function.

You need to add this VBA code in the regular module in the VB Editor.

For some people, it’s a great feature that Excel automatically converts a URL text to a hyperlink when entered in a cell.

And for some people, it’s an irritation.

If you’re in the latter category, let me show you a way to prevent Excel from automatically creating URLs into hyperlinks.

The reason this happens as there is a setting in Excel that automatically converts ‘Internet and network paths’ into hyperlinks.

Here are the steps to disable this setting in Excel:

In the AutoCorrect dialog box, select the ‘AutoFormat As You Type’ tab.

Uncheck the option – ‘Internet and network paths with hyperlinks’

Close the Excel Options dialog box.

If you’ve completed the following steps, Excel would not automatically turn URLs, email address, and network paths into hyperlinks.

Note that this change is applied to the entire Excel application, and would be applied to all the workbooks that you work with.

There is no function in Excel that can extract the hyperlink address from a cell.

However, this can be done using the power of VBA.

For example, suppose you have a dataset (as shown below) and you want to extract the hyperlink URL in the adjacent cell.

Let me show you two techniques to extract the hyperlinks from the text in Excel.

Extract Hyperlink in the Adjacent Column

If you want to extract all the hyperlink URLs in one go in an adjacent column, you can so that using the below code:

Sub ExtractHyperLinks() Dim HypLnk As Hyperlink For Each HypLnk In Selection.Hyperlinks HypLnk.Range.Offset(0, 1).Value = HypLnk.Address Next HypLnk End Sub

The above code goes through all the cells in the selection (using the FOR NEXT loop) and extracts the URLs in the adjacent cell.

In case you want to get the hyperlinks in the entire worksheet, you can use the below code:

Sub ExtractHyperLinks() On Error Resume Next Dim HypLnk As Hyperlink For Each HypLnk In ActiveSheet.Hyperlinks HypLnk.Range.Offset(0, 1).Value = HypLnk.Address Next HypLnk End Sub

Note that the above codes wouldn’t work for hyperlinks created using the HYPERLINK function.

Extract Hyperlink Using a Formula (created with VBA)

The above code works well when you want to get the hyperlinks from a dataset in one go.

But if you have a list of hyperlinks that keeps expanding, you can create a User Defined Function/formula in VBA.

This will allow you to quickly use the cell as the input argument and it will return the hyperlink address in that cell.

Below is the code that will create a UDF for getting the hyperlinks:

Function GetHLink(rng As Range) As String GetHLink = "" Else GetHLink = rng.Hyperlinks(1).Address End If End Function

Note that this wouldn’t work with Hyperlinks created using the HYPERLINK function.

Also, in case you select a range of cells (instead of a single cell), this formula will return the hyperlink in the first cell only.

If you’re working with a huge dataset that has a lot of hyperlinks in it, it could be a challenge when you want to find the ones that have a specific text in it.

For example, suppose I have a dataset as shown below and I want to find all the cells with hyperlinks that have the text 2023 in it and change it to 2023.

And no.. doing this manually is not an option.

You can do that using a wonderful feature in Excel – Find and Replace.

With this, you can quickly find and select all the cells that have a hyperlink and then change the text 2023 with 2023.

Below are the steps to select all the cells with a hyperlink and the text 2023:

Select any cell which has a hyperlink in it. You will notice that the Format gets visible in the box on the left of the Format button. This indicates that the format of the cell you selected has been picked up.

Enter 2023 in the ‘Find What’ field and 2023 in the ‘Replace with’ field.

In the above data, it will change the text of four cells that have the text 2023 in it and also has a hyperlink.

Note: This technique works as Excel is able to identify the formatting of the cell that you select and use that as a criterion to find cells. So if you’re finding hyperlinks, make sure you select a cell that has the same kind of formatting. If you select a cell that has a background color or any text formatting, it may not find all the correct cells.

While Hyperlinks are useful, there are a few things about it that irritate me.

For example, if you want to select a cell that has a hyperlink in it, Excel would automatically open your default web browser and try to open this URL.

So let me quickly show you how to get rid of these minor irritants.

Select the Cell (without opening the URL)

This is a simple trick.

After a second, you’ll notice that the hand cursor icon changes into the plus icon, and now when you leave it, Excel will not open the URL.

Instead, it would select the cell.

Now, you can make any changes in the cell you want.

Neat trick… right?

This is another thing that might drive you nuts.

Here is a quick fix.

This happens when these cells have the wrap text enabled.

There are useful things you can do when working with hyperlinks in Excel.

In this section, I am going to cover some examples that you may find useful and can use in your day-to-day work.

Example 1 – Create an Index of All Sheets in the Workbook

If you have a workbook with a lot of sheets, you can use a VBA code to quickly create a list of the worksheets and hyperlink these to the sheets.

This could be useful when you have 12-month data in 12 different worksheets and want to create one index sheet that links to all these monthly data worksheets.

Below is the code that will do this:

Sub CreateSummary() 'This code can be used to create summary worksheet with hyperlinks Dim x As Worksheet Dim Counter As Integer Counter = 0 For Each x In Worksheets Counter = Counter + 1 If Counter = 1 Then GoTo Donothing With ActiveCell .Value = x.Name With Worksheets(Counter) .Range("A1").Value = "Back to " & ActiveSheet.Name chúng tôi Sheets(x.Name).Range("A1"), "", _ "'" & chúng tôi & "'" & "!" & ActiveCell.Address, _ ScreenTip:="Return to " & ActiveSheet.Name End With End With ActiveCell.Offset(1, 0).Select Donothing: Next x End Sub

You can place this code in the regular module in the workbook (in VB Editor)

This code also adds a link to the summary sheet in cell A1 of all the worksheets. In case you don’t want that, you can remove that part from the code.

You can read more about this example here.

Note: This code works when you have the sheet (in which you want the summary of all the worksheets with links) at the beginning. In case it’s not at the beginning, this may not give the right results).

Example 2 – Create Dynamic Hyperlinks

But you can also use a little bit for Excel formula trickery to create dynamic hyperlinks.

By dynamic hyperlinks, I mean links that are dependent on a user selection and change accordingly.

For example, in the below example, I want the hyperlink in cell E2 to point to the company website based on the drop-down list selected by the user (in cell D2).

This can be done using the below formula in cell E2:

When you change the selection using the drop-down list, the VLOOKUP result will change and would accordingly link to the selected company’s website.

This could be a useful technique when you’re creating a dashboard in Excel. You can make the hyperlinks dynamic depending on the user selection (which could be a drop-down list or a checkbox or a radio button).

Here is a more detailed article of using Dynamic Hyperlinks in Excel.

Example 3 – Quickly Generate Simple Emails Using Hyperlink Function

As I mentioned in this article earlier, you can use the HYPERLINK function to quickly create simple emails (with pre-filled recipient’s emails and the subject line).

Single Recipient Email Id

Multiple Recipients Email Id

For sending the email to multiple recipients, use a comma to separate email ids. This would open the default email client with all the email ids in the ‘To’ field.

Add Recipients in CC and BCC List

Add Subject Line

You can add a subject line by using the &Subject code. In this case, this would add ‘Excel is Awesome’ in the ‘Subject’ field.

Add Single Line Message in Body

This would add a single line ‘I love Excel’ to the email message body.

Add Multiple Lines Message in Body

To add multiple lines in the body you need to separate each line with %0A. If you wish to introduce two line breaks, add %0A twice, and so on.

Here is a detailed article on how to send emails from Excel.

Hope you found this article useful.

You May Also Like the Following Excel Tutorials:

A Complete Guide To Vegan Muscle Building

This post has been updated. It was originally published on 1/7/2023.

When articles proclaim that “veganism is growing in popularity,” it’s not just because Instagram and Youtube makes it feel that way. It’s because veganism is, in fact, growing in popularity.

Some fast facts:

On Dec. 30, 2023 more than 14,000 people formally promised (by signing up through this website) to not eat animal products in January. Participation in Veganuary has more than doubled every year since the campaign began in 2014.

Last year, restaurant consulting group Baum + Whitman identified plant-based food as a major trend for 2023. “That’s still true” for 2023, the copywriter(s) note [PDF], adding that this year lab-grown meats “look like profound long-range game changers.” (The brief writer also describes cows as “prolific poopers,” so BRB going to hire them to write for Popular Science.)

In 2023, Nestle—whose brands range from Hot Pockets to Coffeemate to Haagen-Dazs to Digiorno—also identified plant-based foods a trend the company, in the words of its Executive Vice President of Strategic Business Units, “believe[s] is here to stay and amplify.”

6 percent of U.S. consumers now claim to be vegan, up from 1 percent in 2014. That’s a 500 percent increase, or a difference of 1.6 million people.

Ariana Grande is vegan.

If you are one of the millions of folks who now call themselves vegan (or plant-based or whatever) and you have divulged this fact to anybody, you have probably been asked about your protein sources and intake. People may have wondered about your muscle mass, or your strength. And it’s not a totally unreasonable concern. Generous protein intake is essential for maintaining and building muscle. Eggs, meat, and dairy make up roughly 62 percent of the protein consumed by US adults—and that number may actually be greater when you consider that 8 percent of the protein consumed “could not be classified” (hot dogs?). The remaining 30 percent is plant protein, the largest dietary source of which is bread, which doesn’t exactly have a reputation for being protein-rich.

When I transitioned out of animal products a year ago—there are many science–backed reasons to reduce your animal product intake—the move seemed to run counter to my goals for athleticism and overall beefcakiness (pun intended). I’ve drained hours researching what humans need to build muscle optimally. When I tried to find research on how people who don’t eat egg whites, whey protein powder, or 93-percent-lean ground beef can optimize their gains, the Google Scholar well ran dry.

But even without recent or replicated peer-reviews papers, we have proof enough that getting buff with plant-based protein is, in fact, possible. There are enough vegan bodybuilders and Olympic athletes to show us it can be done. But how? I asked four experts and compiled their knowledge below.

Our panel: (1) Dr. Anastasia Zinchenko, a vegan bodybuilder, powerlifter, and coach with a PhD in biochemistry and books full of high-protein bake recipes. (2) Jordan David, a vegan bodybuilder, health coach, and founder of Conscious Muscle, which sells coaching, apparel, and supplements. (3) Dr. Rachele Pojednic, an assistant professor of nutrition at Simmons University. (4) Kendrick Farris, a vegan weightlifter who represented the U.S.A. in the 2008, 2012, and 2023 Olympic Games.

How much protein the aspiring buff vegan should eat

As previously mentioned, the survival of our species does not require as much protein as many Westerners are led to believe. Adequacy, according to the US recommended dietary allowance, is just 0.8 grams of protein per kilogram of body weight. So, for example, a person who weighs 170 pounds (or 77 kilograms) should eat about 62 grams of protein (that’s 77 x 0.8). Most people (especially meat eaters) get that without even really trying. A peanut butter sandwich on wheat bread, for example, has about 18 grams of protein.

[Related: You don’t have to eat vegan to reduce your environmental impact.]

Zinchenko, who shares tips on her website Science Strength, recommends vegans eat 2.4 grams of protein per kilogram of body weight (or about 1.1 grams per pound). That’s a lot higher than what governmental organizations recommend, but her clients want to bulk up, not simply be healthy. And muscle gain requires the amino acids in protein. (More on that below.)

People who go to David for coaching are prescribed 1 gram of protein per pound of body weight, which shakes out to just a bit less protein than Zinchenko prescribes. Pojednic, a nutritionist, recommends training athletes get anywhere from 1.6 to 2.2 grams of protein per kilogram of body weight.

For context, a 170-pound individual would consume 185 grams of protein on Zinchenko’s plan, 170 grams of protein on David’s plan, and 123-169 grams of protein on Pojednic’s plan. That difference in protein consumption equates to roughly two protein shakes, or a block and a half of tofu.

The difference between vegan proteins and proteins that come from animal products

If you aren’t vegan, Zinchenko says, you can get away with eating 2.1 grams of protein per kilogram of body weight, because the amino acid profiles in animal products are slightly better for making muscle. Pojednic notes that amino acid composition is “one of the key distinctions” between a vegan and an omnivorous diet.

Both Zinchenko and Pojednic call out amino acids leucine and lysine, in particular. Animal proteins generally have more of these amino acids than plant proteins (here’s a graph), which is significant because these building blocks seem to be particularly good drivers of muscle protein synthesis. You can boost your levels by incorporating a supplement, which Zinchenko recommends, though Pojednic notes that there are plenty of vegan sources of leucine: soy isolates (like soy protein powder), seaweed and spirulina, sesame seeds, sunflower seeds, and tofu.

[Related: What to know before investing in a pair of running shoes]

“It’s not just about getting enough protein,” Zinchenko says, “The distribution of amino acid types is also important. It’s like building a house. It must have windows, bricks, and doors. You can have all the bricks in the world, but without a door, it’s not going to be a house.”

That doesn’t mean you need to make sure each serving of protein includes a mix of all the necessary amino acids, Pojednic says. If you’re eating a variety of foods throughout the day, there’s no need to pair up rice and beans for every meal. Your body can still put all the pieces together.

Fiber and protein bioavailability

Even if your lunchtime salad has all the nutrients you want, your body may not be absorbing them. Some foods are harder for the human digestive system to turn into nutrients. Compared to meats, eggs, and dairy, vegetal proteins are not as bioavailable, meaning your body might not actually get to use all the protein contained in the raw spinach you scarfed.

Whole (also known as unprocessed) foods, which are recommended by the USDA, contain fiber and other substances that can limit absorption in the small intestine. “If you eat a raw vegan diet, you may need to aim for 2.7 grams per kilogram of body weight, which is just an insane amount of broccoli and beans,” Zinchenko says.

Whole foods generally take longer to digest, which is why serious muscle-builders may want to chug a protein shake on a relatively empty stomach—and why both David and Zinchenko recommend some sort of protein supplementation. Pojednic suggests it too, particularly if your stomach can’t handle a full meal after lifting.

Do vegans need to supplement?

Vegans need to take a B12 supplement. Most of the B12 humans get in their diet comes from animal products, as a result of microorganisms being processed in the guts of cattle and sheep. Without foods from those critters, it’s a lot harder to get adequate B12, which means vegans rely on fortified plant milks and cereals or supplementation. (Unless they are really into eating seaweeds like spirulina or dried nori, which contain B12.)

Otherwise, no, you don’t need to use a protein shake or branched chain amino acid powder—but they can make it a whole lot easier to get your protein in. Otherwise, 150 grams of protein a day (without just oodles of carbs) can be overwhelming.

The ideal ratio of vegan protein sources

Zinchenko encourages vegan lifters to “err on the side of caution” and eat about 50 percent of your protein from legumes (beans, peas, soy, etc.), 25 percent from grains, and 25 percent from nuts and seeds to make sure you’re getting adequate amounts of the necessary amino acids.

Meal timing

“The most recent recommendations clarify not just how many grams of protein you should eat, but also how those grams are pulsed throughout the day,” Pojednic says. “Scientists are thinking now that there’s only a certain amount of protein your muscles can uptake and utilize in one sitting. If you flood your system with amino acids, at some point they’re a little bit wasted.”

Aim to get 0.25 and 0.4 grams of protein per kilogram of body weight per meal. Or, to put it way simpler, space out your protein over 3 or 4 meals a day, not just all at once in a mega smoothie.

The other science-backed tip is to make sure you’re eating 20-30 grams of protein within 30 minutes (up to an hour is probably fine) of training. “The literature shows that ingesting both protein and carbs in that window promotes muscle growth and recovery, which helps you stay up on your training regimen.” Yes, that can be a protein shake—but it can also be a peanut butter sandwich.

But the most crucial aspects of gaining muscle have nothing to do with being vegan.

It’s not all about getting enough amino acids. You’ve got to eat enough calories to gain mass, and you’ve got to train hard. Farris, who went plant-based in November 2014 (between Olympics appearances), is a world-class athlete who happens to be vegan—and he doesn’t track his protein at all. Still, he was able to “make some gains and, more importantly, stay healthy.” He says a vegan diet has let him recover faster. “If you can do that, you can do more work. You can beat your body up more. Simply, just train.”

[Related: What’s the best total-body exercise?]

(It’s worth noting that part of the reason Farris had no qualms about changing his diet while in a high point of his career was because he spent his prime lifting years (19-22) gaining strength without reliable access to any type of food at all. “If I could lift and do it all when I didn’t have access to regular meals, how was I going to get weaker eating enough food but switching out the ingredients?”)

In case that doesn’t drive the point home, know that every single person I spoke to for this article mentioned the importance of simply eating enough food.

“A big problem for vegans is that they can easily under eat,” Zinchenko says. “Especially active people who eat a lot of whole foods. Without calories, your body can’t make muscle.”

“The main thing is high-volume weight training and getting adequate nutrients,” David says. “That’s it. There are no shortcuts. The harder you hit it, the more you feed it, the more it will grow.” (I believe we were talking about butts at this point in the conversation.)

“Obviously diet is going to give you that tiny push at the end, but the training and the dedication is really what’s going matter in the long term for high-level athletes,” Polojic says.

Oh, and for what it’s worth, we sorely need more research on vegans. “Even the studies that examine vegan protein powders are not done on vegans,” Zinchenko says. “If there is somebody who would like to donate money to study vegan muscle growth, I would be happy to run the study.”

9 Reasons To Use Instagram For Business

Others, however, remain on the sidelines, and one of the chief reasons is that they (incorrectly) believe they have nothing to post.

This couldn’t be further from the truth.

Whether you’re a trendy B2C company or a traditional B2B company, there’s a place for you on the ‘gram.

Don’t fall into the trap of thinking your business doesn’t have anything visually interesting to post.

With a little creativity and strategic planning, you’ll find there’s plenty you can post on Instagram.

Here are nine reasons you should use Instagram as a business, no matter what your industry is.

1. Customers Expect It

Customers will search for you on Instagram.

They might search for you specifically by name, or by hashtags relating to your business or location.

Either way, not finding you is a bad experience.

Even if you don’t plan to be incredibly active on Instagram, the best practice is to create an account that, at the very least, has your business name, contact information, and a few posts to showcase your brand.

In any case, you don’t want that search to come up empty – or, even worse, lead them to a competitor.

2. It’s a Trust Signal

Having an Instagram account – especially a verified Instagram account – is one more signal that your business is reputable, real, and transparent.

If you’re doing online business exclusively, having yet another social account where your customers can get to know your business is highly valuable.

3. Your Customers & Users Can Tag You

Let’s say you offer a client exceptional service, or a customer is over-the-moon about a product they just bought from you.

It’s highly possible they’ll take to Instagram to share the story, and their glowing review is gold.

That’s the kind of thing you definitely want to be tagged in so that it can show up on your Instagram account.

But here’s the thing – if you don’t have an Instagram account to begin with, the customer will never be able to tag you and it’s a huge missed opportunity.

4. You Can Tag and Sell Your Products

If you sell products, the ability to share Instagram photos and  videos that link directly to those products is a major win.

5. Point Back to Your Site

It isn’t just products you can showcase from your Instagram account – it’s also your white papers, infographics, blog posts, and any other content you post on your website.

Instagram is one more social channel where you can drive traffic back to your site.

6. Online Reputation Management

When it comes to online reputation management and search engine optimization for your brand name, having an Instagram account is a must-do.

Your online reputation is critical to your business, and for that reason, you have to be vigilant about what comes up when customers search for your business or brand’s name.

In addition to your website, your social channels usually show up on the first page of the search engine results, as well.

For that reason, it’s a best practice to create business accounts on all social networks (including Instagram) with your brand name, even if you don’t plan on using them frequently.

The idea here is to control the search engine results page as much as you can by creating profiles and content that points back to your brand.

That way, in the event you do get bad publicity online, your website and social accounts have a fighting chance to rank above any negative content.

7. Your Competitors Are on Instagram

If you don’t have an Instagram account and your competitors do, you’re giving them a competitive edge, plain and simple.

If you’re stumped on what kind of content to post to Instagram, look at what your competitors are doing.

It’ll give you plenty of inspiration for what you can do, too!

8. Networking

Instagram is also a useful networking tool.

That way, if you ever want to reach out to them in the real world or run into them at an event, you’ll have already laid a foundation on Instagram.

9. You Can Attract Talent

Whenever people are considering working with or for a new company, they want to know what it’s really like.

Giving them a transparent glimpse of behind-the-scenes moments on Instagram (and social media in general) is a great way to show off your company culture.

Featured Image Credit: Paulo Bobita

Update the detailed information about Instagram Marketing For Business: A Complete Guide on the website. We hope the article's content will meet your needs, and we will regularly update the information to provide you with the fastest and most accurate information. Have a great day!