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.

How to track clicks in sidebar or in any element with Google Analytics

By Ilkka Mäkinen | 6 September, 2016
How to track clicks in sidebar or inside any element

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.

6 Ways to benefit from Google Analytics: use data to grow your traffic and potential leads

By Ilkka Mäkinen | 27 August, 2016
Benefit from Google Analytics data and grow

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.

The single most effective SEO technique to grow your organic search traffic

By Ilkka Mäkinen | 11 August, 2016
You mean to tell me I didn't meet the needed koala-fications?

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.

Outdated and ineffective SEO techniques that will end up hurting you

By Ilkka Mäkinen | 4 August, 2016
seo laundry

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.

3 things you probably did not know about SEO

By Ilkka Mäkinen | 16 June, 2016
What you probably didn't know about SEO

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.

How to calculate percentages in Excel training tutorial

By Ilkka Mäkinen | 14 June, 2016
Changing formatting into percentage in Excel

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.

How to replace characters or words from any text in Excel

By Ilkka Mäkinen | 8 April, 2016

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.

Combine first name and last name in Excel – create email addresses for example

By Ilkka Mäkinen | 8 April, 2016
concatenate-excel-combine-text-create-emails

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.

Round time in Excel – full hour, half hour or fifteen minutes

By Ilkka Mäkinen | 17 March, 2016

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.

How to remove the first word of a text in Excel

By Ilkka Mäkinen | 11 March, 2016
How to remove first word in Excel

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.

Terms & Conditions

Conditions: Minimum number of participants is 3 persons on each course. If the course you are enrolling in does not reach the minimum number of participants it will be cancelled or postponed. We will inform enrolled participants in case there are not enough participants on a course.

Cancellations and substitutes: a) Cancellations confirmed more than 21 days prior to the date of the course are fully refundable and free of charge. Cancellations are to be made in writing to info@talentwire.eu. 

b) Cancellations made within 21 days of the date of the course may not be cancelled without incurring course charges fully.

c) Substitutes may be made at any time free of charge. TalentWire should be informed of any changes.

Pricing and invoicing: Payment for each course is to be received no later than 14 days prior to the course start date. We will send an invoice after your booking has been confirmed. Inform us of any special arrangements you require for your invoices.

All prices are as stated and are exclusive of VAT which will where appropriate be charged at the current rate.

×