This tutorial is compiled using Excel 2007 but should work on all versions of Microsoft Excel.
Often when using Excel you want to keep values in separate columns but also present them together. For example, when compiling a list of names you would want:
- First Name
- Full Name
You may also then want to add in numerical data as well. Let’s say this is for a customer list you may want customer ID and date contacted. Now your columns look like this:
- First Name
- Full Name
- Customer ID
- Date Contacted
- All Details
Immediately you realise that all the data in the ‘Full Name’ and ‘All Details’ columns is already entered. Instead of typing everything out twice – which often results in mistakes – you can use an Excel function to join multiple cells together. Here is how to join cells containing text and numbers: Read the rest of “Joining Cells in Microsoft Excel 2007 Tutorial”
As well as being a great way to store, tabulate and analyse your data, Microsoft Excel has many other features which can be used to really help you in your day to day life. One of these features is the ability to set up your own Gantt charts.
Gantt charts are ideal for managing your time and resources. From large scale projects to weekly tasks that need to be monitored, using Gantt charts is a great way of getting organised, which is why we take you through a step by step walk through of how to make your own.
First off, we need some data to convert into a chart. The example below goes through a university work schedule plan, but you can make yours to match whatever topic you most need planning.
Make sure that your dates are properly formatted by:
This is the complete list of every Excel Function for text. For each function I have provided a description, the formula and in some cases an example. Where text is necessary I have included the word ‘text’ as an example and where a target cell is specified I have used ‘A1′. Where appropriate I have provided links to other uses for the functions.
This is very much a quick reference guide, if you need help using these formulas you should come on our Excel Training course aimed at beginners. If you’re already up to scratch with all of these functions and are looking for something more advanced then our Advanced Excel Training Course is right for you.
Microsoft Excel 2007 Text Functions
Description: Changes double-byte characters (full-width) into single-byte characters (half-width) for Double-byte characters sets (DBCS).
Description: Changes numbers into Thai currency by changing the number to Thai text and adding the suffix “Baht”