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.

Articles on Excel

Changing formatting into percentage in Excel

How to calculate percentages in Excel training tutorial

By Ilkka Mäkinen | 14 June, 2016

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.

concatenate-excel-combine-text-create-emails

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

By Ilkka Mäkinen | 8 April, 2016

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 first word in Excel

How to remove the first word of a text in Excel

By Ilkka Mäkinen | 11 March, 2016

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.

How to get the first word of text in Excel

Learn how to get the first word of a text in Excel – Excel quick tip

By Ilkka Mäkinen | 10 March, 2016

If you need to get the first word of any text in Excel, this is a handy quick tip for you. In this post I will show you how to get the first word or any number of characters of a text in Excel.

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.

×