The TalentWire blog
Expert advice on Excel, WordPress, search engine optimization, Google analytics and Adwords. Sign up to our newsletter to get the latest and greatest tips directly to your inbox.
Do you know many of your visitors actually click the links in your sidebar? Or your social sharing buttons? How about related articles below your blog posts? Here’s a guide on how to find out with Google Analytics.
Are you using your analytics data to your benefit? With insights from Google Analytics data you can fix the problem areas and maximize the benefits. Your boss will be so pleased to see ever improving results of your data driven approach to publishing.
Wondering how to get more traffic coming your way from Google? This article will talk about how Google works and how you can create content that earns the clicks and starts growing your organic search traffic.
Not seeing results with your SEO efforts? Read which old school SEO techniques aren’t working anymore and what are the effective methods that actually work today.
What are the key things you need to know about search engine optimization? Read how to get ahead, learn the rules of the game and which pitfalls to avoid.
This is a Microsoft Excel training tutorial on how to calculate percentages correctly in any version of Excel. Lean three cases you can use for all situations and learn how to calculate percentages correctly in Excel.
This is a quick tutorial on how to replace characters from a text string in Microsoft Excel. The substitute function is a very useful tool for replacing characters or words from strings of text. Here is an example how to use substitute to replace unwanted characters or words from a text.
This is a quick tutorial on how to combine first name and last name in Excel. You can use it to create email addresses from a list of names for example. To combine strings of text or values in cells we can use the CONCATENATE function.
This is a tutorial on how to round time in Excel. This can feel a bit tricky if you are not familiar with how Excel handles time formatted data. Now we can’t just go ahead and use the ROUND function which might feel like the obvious choice. We need a different set of tools for this, because for Excel, data formatted as time behaves in a different way.
Wondering how to remove the first word in of a text Excel? Or how to remove the first words dynamically in Excel, if the length of the words varies? No problem! You can achieve both pretty easily if you understand the functions RIGHT, LEN and SEARCH.