99.1% Of all customers recommend us, we're so confident about our results we publish all reviews and statsView Live Stats View Reviews
How to Create Better Excel Spreadsheets: Part Two
Thu 31st August 2006
Problem: I need to combine the contents of two or more cells!
There are numerous reasons why you might need to combine the contents of two or more cells. For example, you may have a column of customer first names and a column of last names that you need to combine into one cell. You won't need to waste your time retyping the entire list; Microsoft foresaw this problem and created the "concatenate" function to solve it.
The word 'concatenate' literally means 'to link together' or 'to unite in a series or chain.' You can join the data from as many cells as possible with the concatenate function. In this example, we'll assume that we're joining the first names in column A, with last names in column B. In the cell where you want the combined information to appear, simply type =concatenate(A1," ",B1).
Make sure to enter a space between the A1 and the B1 cell labels surrounded by quotation marks so that Excel knows to leave a space between the first name and the last name. There is much more functionality and lots of other uses for the concatenate function that are explained in greater detail in an Excel course.
Problem: I need an easier way to create a numbered or dated list!
Many, many spreadsheets have a need for an organized list that includes months of the year (January, February), days of the week (Monday, Tuesday), progressing dates (1/22/07, 1/23/07), or just a numbered list. So many spreadsheets have the need for such lists, that the functionality to automatically populate these lists is built right into the Excel cells.
The process is simple, and even a bit fun. Simply type the first list name into one of the Excel cell, for example, "Monday." Next hover your mouse over the bottom right corner of the cell until the pointer becomes a "+" sign and drag your mouse across the cells where you want your list to appear.
Excel intuitively knows that you're attempting to create a list of days of the week and fills in the empty cells in seconds flat. Sometimes with numbered lists Excel needs you to fill in the first two cells in order to understand you intended pattern, but never much more than that. In Excel courses, you'll learn lots more about this feature, like how to build customized lists with your own repeating information like employee names.
Most people who try Excel courses say that they're shocked by the sheer amount of interesting functions they didn't know existed in Excel. After attending several Excel courses you can build all sorts of customized, interactive spreadsheets that can handle just about any functionality you can imagine. If you're a business owner, sending your employees through Excel courses can easily boost productivity. Regardless of how you use it, understanding more about Excel's clever and powerful features can open doors to new and more intuitive way of interpreting your data.
Original article appears here:
London's widest choice in
dates, venues, and prices
On-site / Closed company:
Learning And Development Manager
Maurius was so helpful and really enthusiastic. Was able to give good examples of how you might use the features too.
It would be nice if the tutors are able to join us for lunch!
Commercial Intelligence Manager
Power BI Modelling, Visualisation and Publishing
This will improve productivity with PowerBI and the ability to answer ad hoc user related questions during the course was very useful.
Seven Investment Management
PA To CEO And Head Of Corporate Development
A thoroughly informative course with great interaction between the course leader and the delegates.