Advertising
Advertising

10 Ways To Create and Promote Your Website Effectively

10 Ways To Create and Promote Your Website Effectively

Anyone who wants to run a successful online business must start with a home base: their website. That’s where they share their story. Visitors will drop-by and see what solutions they find to their challenges and problems. Whether they click that “Subscribe” button or buy from you, depends on a number of factors. It won’t happen overnight, but if you promote your website the right way, you’ll achieve the success your business deserves. This post looks at some of the ways of creating and promoting a website. They can be adapted depending on what business you run (consulting, freelancing, writing, etc). Let’s break down the process in two chunks.

How to create a website

1. Register Your Domain Name

This is the foundation of creating your website. Godaddy, Namecheap and 1&1 are just a few of the domain registrars you can choose from. All of them have low prices and offer a variety of package deals to suit every need. When deciding for a domain name, give it some thought; use keywords relevant to your business. Also, since you need to be perceived as a pro, the best thing to do is go for a self-hosted website.

2. Choose a Hosting Service

The next step is to register your hosting account. I recommend you stay away from the free blogging platforms like blogspot.com or wordpress.com, and build a professional website using wordpress.org. Here you also have dozens of options, but I personally recommend Westhost, which I’m using myself. I chose them for two main reasons: they offer a superior service and are extremely affordable. You want a website you can have control over, that you own and have the freedom to use as you wish to offer your visitors the best experience.

Advertising

3. A Minimalist WordPress Theme Makes Your Content Stand Out

When getting to this point, bear in mind that your website doesn’t have to be perfect or super flashy. A clean and minimalist theme with a professional look would do. Some of the best WordPress theme providers are: Theme Forest, Genesis and Elegant themes. This post from wplift can also be instrumental in giving you a few ideas about what would work best for your website.

4. Install Plug-Ins on Your WordPress Website

There’s no need to go overboard here either. Some of the plug-ins you’ll most need are Akismet, to protect your blog (assuming you have one) from spam; BackWPup, to automatically back up your WordPress website; WP Super Cache, to help make your site faster and protect it from crashing in case of traffic spikes; and, last but not least, Google Analytics, to measure your results.

5. Persuade Your Visitors with Your Web Copy

Now that your website is shaping up nicely, your web copy should be engaging and right to the point. Persuasive. When you start creating your web pages, picture your potential clients in mind. What makes them tick? Highlight your key points first. Let your visitors know from the get go what you can do for them. Keep in mind they will only have a quick look at your website to decide whether they should stay or leave. Besides that, if you don’t tell them what to do, if your pages don’t include a call-to-action, they’ll click the back button in an instant.

Advertising

6.  Not Ready to Launch Yet? No Problem. Create a Landing Page First

As an alternative to the previously covered points, you could just create a landing page that lets your visitors know you’d be launching soon, and build a strong offer – give them a free report or an e-book in exchange for their email address. Make sure you don’t come up with another freebie just because almost everyone does. The world wide web is inundated with those kind of things. Make it count.  It has to be useful, informative and smart. Why? Because you need credibility to attract visitors and convert them into buyers. Let’s look now at some of the ways to earn Google’s trust.

How to promote your website

You need eyeballs to your product or services no matter what business are you in. Your main goal is to turn visitors into subscribers or buyers. But before you get there, you need to spread the word about what you do. Even the best product is useless if people don’t know about it.

7.  Start Marketing Your Business Early

This is a key lesson both Buffer co-founders Joel Gascoigne and Leo Widrich learned and discussed in the early days of their startup. Gascoigne wrote in one of his blog posts that treating his product as finished was essential to immediately see the benefits.

Advertising

Widrich pointed out, reflecting to his business partner’s words: “Take what you have, treat it as finished and push it out there.” He added: “People don’t sign up for your product after hearing about you for the first time.” You need to put it out there, so people can hear about it, see how it works and what it can do for them. In our quest to launch the perfect website (or blog) for the perfect business, we tend to keep postponing, waiting for the perfect time when our product or service is polished enough to see the daylight. The thing is you have to start somewhere, otherwise you’ll never advance.

8. Get Links to Earn Credibility

When your website is brand new, you’re not an established authority yet. To get credibility, you need to get links from credible websites. The combination between the quality and quantity of these links is called domain authority (DA) and gives your credibility score. This is measured on a scale from one to 100. Page authority (PA) is also a scale of one to 100 and measures the credibility on a specific page on your website.

9. Link Popularity Matters

The more sites link to your page, the higher the chance that page will rank higher in the search results. Just like in any popularity contest. Your page must be relevant for a specific topic. Also, the words within the links (anchor text) must include a relevant keyword instead of a URL or a “click here.”

Advertising

10. Don’t Underestimate the Power of Guest Blogging

Guest blogging is the modern day PR. Whether you sell a product or a service, everything goes down to content, how intelligently you create and promote it, and to what purpose. You write for real people, not robots. You ultimately need to guest post to drive quality traffic to your website, garner credibility and build relationships with the blog owners that will host you. If you already have your website up and running, with a blog attached to it, but still feel like you’re talking to an empty room, here’s what you should do: post two to four times per month on your blog.

Other than that, spend time on building relationships with your peers’ audience. Pitch guest post ideas to major blogs in your industry. As they accept and publish your guest posts, you position yourself as an authority. Here are a few tips from Orbit Media’s Strategic Director Andy Crestodina about how to find host blogs. You should guest post on websites that have a higher DA than yours. When you decide what blogs to pitch, you can use Moz’s Open Site Explorer to do a quick domain and link analysis on up to five sites. Or you can install the free Mozbar (for Google and Firefox), to get fast and easy access to advanced metrics, access top tools and instant website information, all in one place.

But more important, you have to create great content, as this is how you’ll earn brownie points with Google. To sum it up: build a solid offer, cultivate relationships, and gain enough subscribers to further spread the word about how awesome your product and services are. From here on in, you can confidently launch and grow your business. Your turn: What tactics do you use to create and promote your website?

More by this author

Anca Dumitru

Freelance Writer & Content Strategist

10 Ways To Create and Promote Your Website Effectively 4 Simple Steps To Make Your Internet Life Secure 13 Things To Do During Weekends To Improve Your Life 10 Most Zen-Friendly Websites to Keep You Calm and Productive at Work 18 Must-Have Travel Apps For Traveling Abroad

Trending in Technology

125 Most Useful Excel Shortcuts That Very Few People Know 210 Best Calendar Apps to Get Your Life Back on Track 320 Google Search Tips to Use Google More Efficiently 420 Excel Tricks That Can Make Anyone An Excel Expert 518 Best Time Management Apps and Tools (2018 Updated)

Read Next

Advertising
Advertising

Last Updated on August 15, 2018

25 Most Useful Excel Shortcuts That Very Few People Know

25 Most Useful Excel Shortcuts That Very Few People Know

Imagine if you could use 5 simple shortcuts while working in Excel, and increase your productivity without wasting time for searching information in huge tables, writing long formulas, and sorting the data.

Or even better:

What if you would get 25 useful shortcuts… and each of them could simplify your work, so you could do much more every day?

You’d definitely feel excited to read about them.

Today is your lucky day because we are going to share with you in this article 25 great Excel shortcuts you can use in your work every day! This is your lucky chance, so go ahead and become a real professional in Excel without wasting your time.

How important are Excel shortcuts for you?

The most effective thing to check out if people really need something is to release a survey and look at the results. So, according to the anonymous survey, 99% of people said Excel shortcuts are critical or important for them.

In general, there are more than 200 shortcuts in Excel. But when we have analyzed the data about how many shortcuts people know, we got the next results:

  • 26% of people know 10 or fewer shortcuts;
  • 61% of people know 10-50 shortcuts;
  • 10% of people know 50-100 shortcuts.

As you can see, not so many people know a lot of shortcuts. Probably, some of them never think about increasing their productivity in such a simple way.

Of course, it depends on how deep you use Excel. Some people use this powerful application just for making simple tables or graphs, others use it for everyday work to count something.

Most of the accountants and businessmen use much more Excel functions for more complex tasks such as creating VBA macros, managing PivotTables, recalculating huge workbooks, outlining data, etc.

But even those people who work with Excel every day very close may know a few shortcuts. Needless to say, they can do their job without shortcuts, but it usually takes for them much more time. T

his sounds not funny, especially if you must finish a huge amount of work urgently. There is a great opportunity for you to increase your productivity in Excel and do your job faster with our useful shortcuts.

5 Main reasons to learn excel shortcuts

Many people don’t understand why they should use shortcuts if they can work without them. Of course, if you use Excel twice per year to make a simple table or a graph, it is probably not so important for you to know many shortcuts.

But if you work in Excel every day, sorting huge tables and managing with tons of data, then shortcuts will help you to reach the next five goals:

Advertising

  1. Work efficiently and faster in Excel
  2. Manage big amounts of data easily and fast
  3. Stay calm and concentrated even while doing a tedious job
  4. Make your work accurately and properly without errors
  5. Get a better understanding of Microsoft Excel

Who can use Excel shortcuts?

There are a lot of people who can simplify their life with Excel shortcuts, and here are the groups that will definitely love using them:

  • People who work in banks, finance organizations, etc.
  • Businessmen who make tons of various reports and presentations in Excel for meetings and briefings.
  • Students who usually are lazy and impatient to make their homework because they don’t want to waste a lot of time working in Excel.
  • Private entrepreneurs who keep various data in Excel tables.

Whether you are a student who hates Excel because it seems a time-wasting and boring application, or you are an accountant who must recalculate huge worksheets every day without making errors, we recommend reading and learning these Excel shortcuts to make your work simpler and save some time.

With these simple but useful tricks, it is so easy to finish your job and get more time for yourself.

25 Excel shortcuts to increase your productivity

Here are 25 great Excel shortcuts you should learn and use for work or studying to make your job faster and simpler. Try to use them all and you will realize you were totally blind before while working in Excel:

1. Format whatever object fast with Ctrl+1

If you select any object in Excel – a cell, a chart, a chart axis, a drawing object – then press Ctrl+1, and you will get the Properties dialog for the certain object. This shortcut offers a very quick and easy way to format whatever object you’re working with.

2. Use range names with Ctrol+G or F5 key

If you use range names (which we strongly recommend to do) and you want to choose the range with a specific name references, press either Ctrl+G or the F5 key, which launches the GoTo dialog.

If the name is simple, you can click on it in a list in that dialog. But if it’s at all unusual, Excel won’t list it; so you will need to type in the name. Then press OK.

3. Use a range name in a formula with =sum( and F3

Suppose you want to use a range name in a formula. For example, you want to sum the Sales range. Enter…

=sum(

…and then press F3.

When you do so, Excel launches the Paste Name dialog. Just choose “Sales” from the list, press the OK button in the dialog, then enter the SUM function’s closing “)” to complete the formula.

4. Launch Function Arguments dialog easily with Ctrl+A

Suppose you want to check the help topic for a worksheet function. For example, you want to read about the MATCH function. In a cell, type…

=match(

…and then press Ctrl+A, or click the Insert Function (“fx“) button to the left of the formula bar.

Advertising

When you do so, Excel displays the Function Arguments dialog, which might offer all the help you need.

But if you still want to see the complete help topic, click the blue “Help on this function” hyperlink in the lower-left corner of the dialog. This technique works with all documented Excel functions.

5. Copy stuff down the column without scrolling with Ctrl+D

If you added a formula in a new column on the right of a huge dataset, and you want to copy that formula down without scrolling, do these steps:

  • go to the right to the column that has data (the column to the left of the new column with the formula);
  • press Ctrl+Down – to get to bottom;
  • move one cell to the right (with arrow key naturally);
  • press Ctrl+Shift+Up to select the new column, at the top of which is the formula you just created;
  • press Ctrl+D to fill down the formula.

6. Quick access to any function with Alt+

By customizing the quick access toolbar, you can create simple shortcuts to commands that you would otherwise have to find in the Ribbon tabs, or macros you have created yourself.

The keyboard shortcut is simply selecting Alt+ (the number of the command you wish to select).

For example, if you have customized your quick access toolbar to have Calc Sheet, Save, Open. To calculate sheet you would hit Alt+1, for save Alt+2, and for open Alt+3.

A lot of people are unaware of this useful function, and it’s a great time saver.

7. Format cells with Ctrl+1

When you need to format cells, use Ctrl+1. Most people know this as the shortcut for the Format Cells dialog, but you can also use it to format almost anything in Excel, without a care about the state of the ribbon. Try this amazing and simple shortcut!

8. Choose visible cells with Alt+

When you need to choose visible cells only – use Alt+. This is the trick to copy only what you see. It is a priceless shortcut when you’re manually hiding rows and columns in the table.

9. Use filtering

Filtering – it is a powerful way to slice, dice, and sort through a huge table of information.

It’s amazingly effective when you’re participating in a meeting to discuss something like a sales forecast, and everyone is looking in real-time at your spreadsheet projected on a screen (or on their monitors).

To some people, you will be seen as the God of Spreadsheets, and this is not a joke!

10. Insert or delete column/row easily with the Ctrl key

Some people waste a lot of time even for simple operations, for example, when they need to insert/delete columns and rows in Excel.

Use this shortcut to insert: with an entire row or column selected, use Ctrl+Shift ++.

Advertising

To delete: with an entire row or column selected, use Ctrl + –.

11. See formula results with F9

If you want to check formula results within multiple formulas, highlight the formula and select F9 to see formula result.

Don’t forget to undo before exiting the formula.

12. Use ALT+Enter for more text within a cell

If you want to add a second line of text within a cell, use ALT+Enter.

13. Use EDATE to move a date on by a full calendar month:

Here’s how to use EDATE:

=EDATE(15/01/16,+1) = 15/02/2016 (15th Feb 2016)

=EDATE (15/01/2016,-2) = 15/11/2015 (15th Nov 2016)

14. Use EOMONTH to move a date onto the end of the month:

Here’s how to use EMONTH:

=EOMONTH(15/01/2016,0) = 31/01/2016 (31st Jan 2106)

=EOMONTH (15/01/2016,-2) = 30/11/2015 (30th Nov 2015)

15. Remove spaces with TRIM

TRIM is a useful function known by few people. It removes any spaces at the beginning of a value. This is useful if you are pulling in values from somewhere else.

16. Repeat commands with F4 or Ctrl+Y

In many cases, you may need to repeat your last action. Use F4 or Ctrl+Y; you can repeat many commands like applying the same borders, format, or insert a worksheet again.

17. Quick access to cells with the Ctrl key and Shift key

When you need to go to the first or last cell of a worksheet, no matter where you are, use Ctrl+Home, Ctrl+End combinations.

And here is a pleasant bonus for you: add the Shift key to select everything on the way!

Advertising

18. Use Ctrl+ to create a timestamp

If you need a date stamp and/or a timestamp in your document, there is no need to type a date and time! Use shortcuts Ctrl+ ; (date) Ctrl+Shift+ : (time). It works like a magic and helps to save your time and nerves.

19. Use autosum shortcut for sum function anywhere

Autosum shortcut – use Alt =. It is a “magic” shortcut of Excel to automatically insert a sum function.

You can use this shortcut to sum rows, columns, or even an entire table in one step without wasting your time.

20. Use data validation

This is an amazing but underutilized tool in Excel, which can be used for a variety of things:

  • Create dependent drop-down lists;
  • Create drop-down lists;
  • Protect/restrict data input of specific cells (without the need for VBA macros).

21. Use conditional formatting

It can be used for various purposes such as color format or cell format of cells, rows or columns based on dependent cell values or formats.

22. Use formula auditing

This is a great tool to analyze and trace precedent or dependent cells, check errors and evaluate formulas.

The “Watch Window” is a feature to keep a snapshot of an area of the spreadsheet, and then move to another area of the workbook – particularly valuable if you’re managing large spreadsheets or don’t have a second screen.

23. Use Scenario Manager to generate summary outputs of a spreadsheet

Scenario Manager (under “What-if Analysis”) enables users to generate high-level, summary outputs of a spreadsheet – without the need to replicate the entire workbook.

It will present multiple scenarios of a spreadsheet in a succinct, high-level summary worksheet.

24. Use INDIRECT to set up large tables

INDIRECT makes it easy to set up tables which reference larger tables without a lot of referencing work or cutting and pasting; especially for dynamic spreadsheets.

25. Use OFFSET for complicated calculations or formulas

OFFSET can be useful for things like calculating YTD numbers or creating formulas that take data in rows and using in columns.

The bottom line

As you can see, when you have a boring or tedious job to do, the best way to do it fast is not looking for a way how to avoid it, but searching for the shortest variant to do it!

That is why we suggest keeping in mind these Excel shortcuts that will help you to save a lot of time and nerves.

If it seems hard for you to remember all them, you can print out the list of shortcuts and keep it on your worktable. Use it to search for some help when you need it, and over time, you’ll remember all shortcuts easily.

Featured photo credit: Unsplash via unsplash.com

Read Next