How to perform VLOOKUP: tips and tricksExcel’s VLOOKUP function has been always seen as bringing Excel beginners into panic. At the same time power users can’t live without it. In this digest we offer you the best web articles about this feature... Continue reading
Update Data with Merge Tables WizardThere are some tasks in Excel that take so long to do and which are so tedious that you wonder why there isn't an automated way to do them. One task that falls into this category is that of updating a table with data stored in another table. You either need to spend a lot of time and exercise a lot of patience and care to perform the task manually or hand it over to the experts in the form of the Merge Tables Wizard from AbleBits. Continue reading
School has begun again as hot summer days gave way to classrooms full of students. With tighter budgets we are facing classrooms with more students and less time for getting to know them. With all the data scattered in different reports, let me show you how quickly you can create a single Excel data binder using Merge Tables Wizard… Continue reading
Merging Cells in Excel with AblebitsWorking with Excel tables you are likely to come across a situation when you need to combine several cells with data. For example, to have name parts together, to create a common title for several columns or print out labels with names and addresses. So, if combining cell values is your unavoidable activity, you should give the new version of Merge Cells Wizard a try... Continue reading
Video: Merge cells in Excel without losing dataYou may need to have the first and last names joined row by row. You may also want to get parts of the addresses to print labels, or product descriptions in one cell. There can be different reasons for merging cells, but here is one way to do it quickly and smoothly in your Excel tables. Continue reading
At the end of the 2008 school year, I wanted to see how much students in my class had improved on their state test scores. I had two spreadsheets from the district's data warehouse - one with my students' scores from 6th grade and one from that year's test Continue reading
Video: Merge two Excel tables in 5 easy stepsThis video shows how the Merge Tables Wizard add-in guides you through the merge process that takes seconds. A must-watch for all copypasterellas and anyone who joins two tables in Excel from time to time... Continue reading
The Merge Tables Wizard for Excel has been trialled by our team and we give it a big WMG thumbs up; it has now become a daily tool which is indispensible to our data collating and merging needs... Continue reading
Merging data in Excel: creating spreadsheets from data housed in multiple locationsThe purpose of this article is to provide a step by step guide on how to merge data in Excel that has been extracted into a spreadsheet. By following the steps below, your new "super spreadsheet" can be created and readily available whenever you need it... Continue reading
Click Like and get 15% discount on all our products right now!
Copyright © 2003 - 2012 Add-in Express Ltd. All rights reserved.
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
