 | Advance Sorting and macros - Medial Case Study |  |
|
Added to Library on 27 Apr 2008
Length: 10 mins
View Tutorial Movie
Download File Used |
This tutorial shows a real life application of intermediate Excel techniques for sorting and making macros to make your life easier and quicker. This spreadsheet was submitted by a member of the tutorial Library and they have kindly given permission for my comments to be turned into a tutorial for everyone.
In this tutorial you will see how to lateral thinking can enable you to use the standard Excel sort command to sort a list in any order at all, not just straight ascending or descending. In the tutorial we order the list by a 2 letter code at the end of each list item.
You will also see how easy it is to add a button to your spreadsheet and how much easier it can make the sheet to use.
The tutorial is slightly longer than usual and if nearly 10 minutes long, so please be patient as it starts to download.
|
|
|
|
Feedback for this tutorial:
"Excellent example of using text function and building a macro. You always make it looks so easy!"
"Thank u very much.
Good Technique using macro to do Sorting.
Amazing keep it up."
"Excellent"
"More useful hints and examples of how to work 'wonders' with Excel - Thank-you."
"That' simply amazing! With a little effort, a person can do just about anything with Ecel.
Thank You
Desmond Lodge"
"Clayton - what a little beauty!
Many thanks - Wes Talbot"
"Thanks for the start on macro's I will enjoy that"
"Hi,
I found this tutorial very useful and pertinent to an application that I am currently working on to make life easier for my secretary...
She now thinks I am wonderful!
Keep up the excellent work."
"Very useful, combines a number of techniques for a practical goal and can be generalized for many uses. "
"Incredible! You covered a number of different functions in detail in under 10 minutes. Time well spent. Thank you."
"It is really helpfull tutorials thanks a lot."
"It has eased my work and it saves alot time, sorting the equipment number together with its bill of materials"
"This Tutorial is much helpful. Its helping me a lot in my advanced ECDL Am4. Thanks a Lot!"
"Wow... you did it again... Brillant... love learning from you... thanks again... Kelly..."
"Like all the others I have seen on this site, this is quite sophisticated stuff. I am going to sign up as a subscriber"
"Great tutorial. Apart from the tip being really useful, I also like the way you show the "real life" process where something does not come out entirely as you expect it and then go on and correct it. Much easier to grasp than slick examples where only the perfect steps are shown."
"Like all the others I have seen on this site, this is quite sophisticated stuff. I am going to sign up as a subscriber"
"this was simple but amazing tutorial ."
"This is a very practical and useful tutorial, I will use it to sort the list of my contacts. Thank you. n "
"this is great. i wish i had knowledge of this site before. this is really mind blowing."
"This is a very practical way to teach the end users about the flexibility of the sort, the way to build a macro and control de execution via a button. Thanks for the application."
|
|
|
| |
 | |  |
|
|
|
