How to use Concatenate in Excel
This week I had a request to show how to join text together from different columns in Excel. For this example, the Concatenate function in Excel works perfectly as it
This week I had a request to show how to join text together from different columns in Excel. For this example, the Concatenate function in Excel works perfectly as it
For anyone who is completely new to Excel or is wanting to venture into the world of formulas and functions, this post is here to give you some basic tips
Any of the Microsoft Office programs includes the ability to create a PDF file for you. I’m always surprised at how many people are still unaware that this function is
Microsoft Office includes the powerful Autocorrect feature which helps to reduce typing errors whilst you work. AutoCorrect is set up by default to correct common spelling and punctuation errors. Common
When working in Microsoft Excel there are several references or names which will appear on a regular basis, as well as different methods for navigating within the program. Which navigation
Let’s take a look now at the terminology and names of the various areas within the Microsoft Excel 2016 window. Even if you have been an avid user of Excel
Conditional formatting is one of my favourite parts of Excel. I am a very visual person and would much rather look at colour charts or visual representations of data to
Microsoft Excel provides various number formatting options which allows you to easily format numbers as currency, dates, percentages, time and even fractions. Occasionally you may run into a situation where