| Accounting Calendar |
|
"Excellent tutorial on the topic. Simple and well explained.
How do you treat the correct starting Wednesday for 2009 which is 31/12/2008? or do you start with 7/1/2009?"
|
|
"I thought this was very helpful I can't wait to practice this"
|
| Adding Drop Down Lists to your Speadsheet |
|
"Yet another tool I knew nothing about. Not sure when I might use it, but it's certainly good to know."
|
|
"Loved this tutorial. Keep up the great job. "
|
|
"Such a simple solution. It will save a lot of time."
|
|
"Thanks for the wonderful tutorial.I will get rid of most of my data entry error.
Clergyman"
|
|
"Hi Clayton
Another area I was not familiar with but I can see areas where this could limit data entry.
Again the tutorials are simple yet powerful and especially useful where there is practical application involved.
thanks once again
Rob Kearnes"
|
|
"Hi Clayton!
I thought I kew this, but you have taught me some new things.
Thank you very much.
Mwedi Kumenya"
|
|
"Thank you so much, Clayton! This is a simple task that would have taken me so long without your video. Thank goodness I found this site! I plan to visit it often. Cindy from Marietta, Georgia
"
|
|
"Absolutly loved the tutorial on Data Validation. I know this process very well and use it daily. Your explainations were right on!! Good Job! Kay Lenort"
|
|
"Clayton,
Knew this one. Your presentation of it is very straightforward and uncomplicated.
Good job!
Leigh"
|
|
"This tutorial points out many of the features of Excel which are useful but which I do not know exist."
|
|
"Thank you Clayton, this lesson will help me a lot. You made it look easy ,hope I can do the same."
|
| Advance Sorting and macros - Medial Case Study |
|
"Wow... you did it again... Brillant... love learning from you... thanks again... Kelly..."
|
|
"More useful hints and examples of how to work 'wonders' with Excel - Thank-you."
|
|
"Excellent"
|
| Advanced Filtering |
|
"Great tutorial, I'm ready to go and have some fun with this one! Thanks Clayton, Kay"
|
|
"Clayton as per your normal excellent standard - a simple and workable demonstration that when practiced will enhance the filtering process. Practice makes perfect. Rob Kearnes"
|
| Case Study: Automatic Forms with excel |
|
"Absolutely Fabulous Clayton!! This tutorial renews my love of Excel!
Thanks so much, Kay Lenort"
|
|
"Hi Clayton, this was really useful to draw together and expand on the offset from previously. I can see bags os use for it. Thanks from Mark"
|
| Cell Referencing |
|
"Finally... Clayton you explain cell referencing so well... that I will never forget how to do it... and what it means.. thanks..."
|
| Comparing two Lists In Excel |
|
"Hey Clayton, I love this tutorial. This is another great example of how you take tasks that at first may seem complicated and then show how easy they really are once you know the correct tricks. Many Excel users will be happy when they discover how much time this one can save them. Keep the tutorial coming, they are great! -- Francis"
|
|
"Thanks, Clayton. I have been looking for an easy method to compare two lists and you have provided it. This will save me countless time."
|
|
"I feel that, as usual, Clayton has come up with another unusal way to do something in Excel, as he has so many other times. Thank You Clayton. Jack"
|
| Control the Contents of Drop Downlist from a cell |
|
"So helpful - I have often wanted to do this - but
could not find any detail ! Thanks"
|
|
"To the point, very useful, explained well, the instructor in the vedio is easy to understand and follow."
|
| Customizing Toolbars |
|
"Clayton, I am really excited to be able to create macros and assign them to icons on my toolbar. Thanks for sharing!"
|
|
"Another interesting and most useful 10 minutes spent being shown the hidden gems in Excel ! Thank-you once again."
|
|
"I am fairly proficient with Excel but because I taught myself I have "holes" in my knowledge that these tutorials address very well. "
|
|
"Very helpful information. This is a great tutorial. A lot of "Aha!" moments. "
|
| Descriptive Statistics - Which Average To Use? |
|
"Clayton,
this was very useful, as I am teaching myself more statistical use, and I am finally introducing myself to more of the Excel stat features. The oops, in the video was actually a good learning opportunity.
Thanks
Sharon"
|
| Dynamic References to External Spreadsheets |
|
"Fantastic. You put your examples in a very clear manner.
I will certainly try this at the next opportunity
All we want now is to ensure the user/s does not modify the cells etc....
Cheers
Pikey"
|
|
"I can't wait to go and practice this so if and when I do find a need to use this function, I will have it nailed down!"
|
|
"Nifty trick done with excel without VBA!"
|
| Excel 2007 Menus Hidden Secret |
|
"Thankyou, it helps to know someone else feels the same way I do about the ribbon...We had to make the move to 2007 at work. It was a difficult change for me. "
|
|
"Very helpful, thanks . .
Have 200 version at work and 2007 at home, when working from home it takes me awhile to find things . . . "
|
|
"Once again you have done just what you said that you would do and I thank you for that. Jack"
|
| Extending Charts and Equations for Dynamic Data |
|
"Very helpful tutorial .... Thanks"
|
|
"Clayton
Very simple concepts but very powerful. I thought this tutorial was was worth viewing. Thanks, Michael"
|
|
"Hi Clayton, this is a super utility, I can see loads of opportunities to expand on it :-) Have got my head rounf offset now after this tutorial :-) "
|
| Extracting Data from Lists - Part I |
|
"A most useful tutorial - presented in a most 'endearing' way -thankyou once again."
|
|
"This is a great tool, I can't wait ti try this out! Thankyou!"
|
|
"This will be very useful for the grant that I manage."
|
|
"Yes... it has helped me... and your tutorials just get better and better... You are really good... Kelly..."
|
| Extracting Data from Lists - Part II (using AND) |
|
"Hi Clayton... You need to add another line after Excellent - Brilliant!!... Holy Cow... I haven't removed my jaw off the floor yet!!... I need to practise this a couple of times... then I am going to see how I can apply it to the spreadsheet I have for tracking stats for the Library I support... Cheers, Kelly..."
|
|
"As usual . .AWESOME!!!"
|
| Filtering Lists and the Status Bar |
|
"Hi Clayton
Although I was familiar with filtering and I do use it in a practical sense I was not aware of the power of the status bar aspect and that is a great feature, especially when dealing with significant amounts of data.
The five minute video presentations are excellent and feature a simple (KISS) but practical demonstration of a particular feature in Excel. and they are just long enough to instruct in a manner that manuals can't cover like you do.
The fact is I can revisit until i get the principles right by practicing the feature until it becomes an automatic feature of my Excel skills
Keep up the good work
Rob "
|
|
"Dear Clayton,
I must confess that I admire the simple and professional way of communicating your idea to your audience. I found this tutorial very enriching in my quest for advance knowledge of microsoft excel. Thanks a million.
- Kola."
|
|
"Hi Clayton,
The tutorial is very useful to analyse a long list of data. And the best thing about it is you don't have to use any functions or formulas to analyse the database."
|
|
"Clayton, Great tutorial! Would be good to mention how this tool is useful for analysis, but doesn't anul the need for formulas in spread sheets that are shared with others?
Mike"
|
|
"Excellent! The status bar had never been explained clearly to me before. Thanks"
|
|
"Clayton, this is actually a feature I had stumbled across some time ago and I love it. It saves me so much time. Thanks for sharing with everyone!"
|
|
"I've had a lot of trouble remembering how to use the drop down lists. You have made this very simple and using this function with the status bar makes it even more useful.
Thank you."
|
|
"I never knew this function existed. I have wasted hours at work over the last few years applying formulas when all I should have done was right clicked the status bar.
Arghh!"
|
|
"I have read about this but have never seen a demonstration of it. The movie helps me to understand better about the use of the status bar and the autofilter tool, and to confidently apply it.
Dr Tin Htut "
|
|
"I like this feature especially with large data. This could help make what you are working with much more manageable. Thanks for this tutorial."
|
|
"wow thank you
i never knew how easy it was very easy presentation easy to follow"
|
|
"Great Information. Made it look easy
Thank You"
|
|
"Mr. Clayton, Tutorial was really superb. Thank you"
|
|
"This is an awesome tutorial!!!!!
Kathy Scott
Houston, Texas"
|
|
"Very useful, excellent"
|
| Finding Data using INDEX and MATCH |
|
"Read some articles on the web about how valuable INDEX/MATCH is, but couldn't figure it out. Thanks to your tutorial, I feel really comfortable using it, and will use it frequently. Don't have to sort lists like VLOOKUP."
|
|
"I watch the videos a couple times through, take a few notes and then try them out just as you have modeled them and then I try to find the ways the function will be useful in what I do...you make learning very easy and convienent, thankyou!"
|
|
"You have a wonderful way with breaking things down. I look forward to working through this myself to solidify my understanding."
|
|
"Great tutorial. "
|
| Finding Duplicates in a list |
|
"Easier than writing a macro to accomplish this task."
|
|
"This can be very useful in the accounting world as well. I think this is going to be something I use regualarly."
|
|
"Clayton,
This is one of your best!
Leigh"
|
|
"Hello Clayton,
An excellent application of simple common sense; thank you very much...you have done a lot to make me confident of working with excel files..
"
|
|
"Thanks Clayton,
I've seen this at work but NEVER knew how easy it could be to set up and use."
|
|
"Whilst this contained nothing new for me it was an excellent example of how to use conditional formatting in a very practical setting. Well done Clayton!"
|
| getting started with dates and times |
|
"This will be very useful, I will be able to continue with my little scheduling project.
Thanks again. "
|
|
"Some of us are slower than others really catching on....for me this unlocked many mysteries but took 2 or 3 listenings to be certain I had truly grasped the idea. This had nothing to do with Clayton's presentation rather my comprehension"
|
| Goal Seeking |
|
"I have never used this function mainly because actual descriptions of what things do is not in plain English. The tutorial showed me how to use this function in a very easy to understand manner."
|
|
"Great feature! I hope to be able to use it soon."
|
| Hiding Excel Error Messages |
|
"I can't wait to use this at work and give my spreadsheets a more professional appearance! Thanks!"
|
| Introduction to Conditional Formatting |
|
"I am going to put this to work tomorrow to let me know when my inventory falls below minimums. It will flag me to make an order."
|
|
"This was a very useful tutorial and will allow for the easy detection of values beyond your set limits. I am looking forward to learing how to use conditional formatting with formulas. Thank you. "
|
|
"The Conditional formating techniques helps me a lot ,bcoz i need to compare lot of my recorded data againsst a limit.. The Technique shown by you reduces my work time to a great extend
"
|
|
"I'm a newbie. The tutorial is useful for me. Thank you Clayton!
Cheers,
Alexander"
|
|
"I have NEVER used (or understood) "Paste Special". Now I know I can't wait to put it to use, along with Conditional Formatting."
|
|
"Thanks Clayton
Again another good yet simple presentation that can be consolidated into ones range of skills one practised and grasped.
Rob"
|
|
"Excellent. I can use this daily in my job. Thanks so much."
|
| Introduction to Named Ranges |
|
"Hi Clayton
Thanks for the naming ranges tutorial. It has lots of potential and as you say once you have the hang of it then it can open doors to more complex and larger workbooks and make the auditing of formulas easier. Again the KISS principle is really appreciated. Kind regards
Rob Kearnes"
|
|
"Thanks Clayton, this is one tool I will DEFINITELY use in my workplace to help understand formulas when I come back to them long after they were created."
|
|
"While I used named cells before, you showed me how to use a named range with a validation list. This was new and will prove to be a useful skill to add to my excel knowledge. Thanks"
|
|
"I thought I knew all about names, but I have learned new things from your tutorial.
This feedback page is also very good and I like it"
|
|
"Clayton,
This one is EXCELLENT, I can and will use this directly. thank you. I thought I was aware of most of the use. Thank you for this one.
Sharon "
|
|
"Sweet! Clayton I have tried with no success to figure out a way to get around Excel's limited access to drop down data. You have shown me what I haven't been able to do on my own! Thank you so much. I can not wait to put this new information in action. Kay Lenort"
|
|
"Clayton,
I always wondered how to capture a list of values from another worksheet and be able to use those values elsewhere without takig up real estate. Now, I know---by namimg the worksheet range. Thanks
Patrick Breuer"
|
| Introduction to Pivot Tables |
|
"Good straightforward instruction! Thanks"
|
|
"never used them befor and now i use them daily,thanks"
|
|
"I have several uses for this feature. I could have saved countless hours had I been able to use Pivot Tables before. Thank you, Clayton!"
|
|
"I have never used pivot tables, but I'm hoping I can now. Thank you."
|
|
"An excellent guide to a very powerful feature in Excel. Introduced in a very clear and
unassuming way making the process easy to understand and put into practice. Thank-you once again."
|
|
"Thanks. I learned a lot. I did not know that a pivot table was a summary table. This could save a lot of time. "
|
|
"A great way to summarise large amounts of data quickly and easy"
|
| Introduction to the IF statement |
|
"Finally someone who can explain how to write an IF formula, understandable by all.
I have tried to add the "and/or" to an IF formula and was unable to find the solution on my own.
As I am sure you know, the Help files are really not a lot of help!!
Thanks so much, the tutorial was greatly appreciated. Kay"
|
|
"Clear explanation of using And/Or with an If statement"
|
|
"I have always wanted to be able to do equations using "if" statement, and now I can. Thank you."
|
|
"Learned about using AND and OR functions. Very powerful."
|
|
"Being able to see this function used makes it so much easier to pick up and being able to go back and veiw it again helps too! Thankyou!"
|
| Joining cells together with Carriage Returns |
|
"If I had known how to do this 2 years ago it would have saved me hours of work and a lot of MONEY ! But much wiser now - thank-you once again Clayton !"
|
| Making your Spreadsheet Easier to use. |
|
"I knew about the first two pointers but did not know about the text box trick...and it seems such a simple trick to use when sharing files and data input...thanks!"
|
|
"Some very practical techniques that are clearly explained. I liked that you showed several ways to do basically the same thing and explained the advantages of each way."
|
| Master Excel Dates Functions |
|
"I can't wait to try this tutorial for myself, it seems a bit challenging but fun!"
|
|
"Sweet tutorial!! I will have fun with this one. I am going to download it and give it a go.
Thanks Clayton, Kay Lenort"
|
| Mastering the Excel AutoFill Features |
|
"I actually knew this one and use it frequently. I have set up several customized lists which save a lot of time."
|
| Nested IF statements |
|
"Clayton, I just love your tutorials they are straight to the point and easy to understand.
Kay Lenort p.s. Nice update to your website."
|
|
"Hi Clayton
Again another good tutorial, kept simple. I have used nested IF statements recently but the exercise ultimately required more than 8 so your tutorial on VLOOKUP made the job easier all round. Your guidelines of only using up to 4 nested IF statements before changing to VLOOKUP is a good guideline to be aware of. kind regards
Rob Kearnes "
|
| Producing Consolidated Reports With Excel |
|
"Thanks for helping me find the solution to consolidating data. Your presentation made it easy to follow. It was worth buying the credits just for this but I know I will get a lot more help on various functions of Excel as I work my way through your tutorials.
I love Excel and use it in lots of ways in my work."
|
|
"Another time saving feature from Excel. Clayton your explaination made this feature very easy to understand and gave me the know how to beable to do it on my own. Thanks much, Kay"
|
|
"Clayton, Thanks so much for making the tutorials that I have purchased previously available to me for a refresher. I haven't consolidated for quite sometime and need to refresh my mind on the process. Thanks again, Kay Lenort"
|
|
"Wow. Often seen "Consolidate" on the drop down but not really known how to use it....
Now I do.
Thanks Clayton for yet another very clear and consice tutorial.
Pikey"
|
|
"This is definitely a must know...which I did not, and yet used work
books with numerous identical sheets, and did all the summary files by hand. All that will now change.
many thank!"
|
|
"I will use this feature daily! What a time-saving function."
|
|
"Never knew this was possible. I am can't wait to use this. "
|
| Quick and Easy Frequency Distribution charts |
|
"I love it. I learned a lot with this one. I reviewed it twice, good show.
Thanks
Sharon "
|
|
"I can't wait to give this feature a go! I am excited to try the cumulative % option to see where the percentages are. Thanks Clayton, Kay Lenort"
|
|
"Very cool, time-saving feature! I can put this one to good use! Thank you, Clayton."
|
|
"One word AWESOME information . . never used the data analysis before. I sure will now.
So many useful tools in Excel, I have not even scratched the surface.
Thank you Clayton for easy to follow and learn tutorials!
The best I have come across!"
|
| Quick In-Cell Bar Charts |
|
"Great function when a quik chart is needed & what fun it is you can do all sorts of things with this little hidden function. Thank Clayton, Kay Lenort"
|
|
"Very easy way to show first hand scores. has its limitations of course, but is very visually effective.
Thanks!"
|
|
"Like the idea."
|
|
"Sweet! A fun one too!"
|
|
"Wow, so simple so effective too."
|
| Removing Blank Rows from Spreadsheets |
|
"Very useful as usual."
|
| Save time by using Custom Chart Types |
|
"Hi Clayton, I'm glad someone else agrees with what I have been thinking about the standard charts.
very well demonstrated.
Thanks
Peter"
|
|
"This was a really useful tutorial. Many thanks."
|
|
"create graphs often . .and go through all that work. Did not know I could save my my graph formats to reuse! Great trick to know!
Thanks again !"
|
| Simplify Financial Data Using Groups and Outline |
|
"All I can say is that I wish I had known about this earlier! It really is very useful especially when dealing with large tables of financial data. To think I might have missed this entire tutorial because I had no idea what the video title "Grouping and Outlining" was alluding to. Maybe this should be under the section about working with large spreadsheets. Anyways, a really handy technique to know!"
|
|
"I have never used the Group and Outline feature before. I always did it the long way with sort, filter, sum. This is so much easier. Thanks, Clayton."
|
|
"Great tutorial Clayton. I have never used this feature, when I didn't want the data to show in my spreadsheets I would simply use format row/column hide feature. This way you have easy access to the hidden data which is very user freindly. Great job thanks much, Kay Lenort"
|
| Single Column Pivot table |
|
"Thankyou I didn't realise you could use this function with only one column of information!"
|
| Splitting Text Strings Using Equations |
|
"This will be helpful for names where the last name and first name need to be split for a merge document. It will save a lot of time. Thank you for sharing!"
|
|
"Sweet Tutorial!! Very well demonstrated. I'm off to give it a shot. Thanks so much, Kay"
|
| Splitting Text Without Equations |
|
"I do come across situations where I need to split text in data given to me by my colleagues. I don't know that it can be done this way, and I had to go through all the trouble retyping the data. Thank you for this information.
Dr Tin Htut"
|
|
"Brilliant simple tool for splitting text. Very beneficial for me."
|
|
"The tutorial was very informative.I did not know that this feature was available! It will be a real time saver when it comes to splitting up lists of data. I am anxious to give it a try. Thanks, Kay"
|
|
"Another amazing tool which I never knew existed."
|
|
"A very good refresher of a little used feature. Hopefully more people will now be aware of this."
|
|
"I have had to try to correct lists improperly entered more than once. Boy, I wish I had known about this. "
|
|
"Well I reallly enjoyed this presentation. this is first time I have come to know this feature of excel... It was a great learning for me..
keep up the gud work...."
|
|
"WOW!! Never knew there was a feature like this one!! Now I will have no trouble with the lists I may need to work with from time to time...
Thanks a lot!"
|
| Theming Data on Bar Charts |
|
"Lot of uses for this one....."
|
|
"Clayton . .thanks yet again for making it so much easier to work with graphs!!!!
The tutorials are extremely useful information!"
|
| Timesheet case study Part I |
|
"Well explained"
|
| Using Excel Check Boxes on a Quote |
|
"Hi Clayton, this is a smashing utility I'll be making good use of it.
Mark"
|
|
"This is just awesome!
"
|
|
"Another tutorial which has you re-designing the way your exsisting workbooks operate !! Many thanks once more."
|
| Using Macros to Save You Time |
|
"Hi Clayton. Macros have always been an area that seemed quite complicated and previous attempts haven't worked. So thank you for at least encouraging me through the video training to now have a go. A little step successfully completed leads to confidence to try something a little more advanced. One step at a time. Rob Kearnes"
|
|
"I have just discovered "macros" and I know nothing about VBA so I am a little hesitant on using them.
The tutorial on "macros" was quite good.
An excellent job of explaining how they work and also how to create them.
Thanks, Kay"
|
| Using Option (radio) Button on a Spreadsheet Quest |
|
"I had tried to use radio buttons before but I did not know how to separate them into groups before.
This is very helpful."
|
|
"Thankyou! This was helpful"
|
| Viewing and Printing Large Tables |
|
"This is a very big help to me at work. Recently, I've been working with a couple of spreadsheets with about 12 pages of data. I knew how to use the "freeze pane" feature but only in a limited way. This tutorial is awesome just like all of the tutorials I've seen thus far. I'm so glad I found this information from Clayton."
|
|
"Aha, so THAT'S how you manage large tables! This was another very useful tutorial for me, Clayton!
What if you just wanted to select certain columns to print in a table? What's the simplest way to do that? Thanks!"
|
| Vlookup |
|
"Excellent. I've used Vlookup before but I never realized it could do all that."
|
| Working on more than one sheet at once |
|
"I have worked on multiple worksheets before but not with vba.
Wow - what a powerful tool for multiple sheet manipulation.
Had a play with code by copying the whole Macro2 and changed the name to "InsertColumnA". I then replaced the word "Delete" with "Insert" so the code was now
For icount = 1 To ActiveWorkbook.Sheets.Count
ActiveWorkbook.Sheets(icount).Select
Columns("A:A").Select
Selection.Insert Shift:=xlToLeft
Next icount
And what do you know, a new column A in each of the worksheets.... Guess what you change to either insert or delete "Rows"?
Fantastic.. another thumbs up for Clayton"
|
| Working with 2, 3 or 4 Conditional Formats |
|
"I love it! Thanks Clayton for showing me the process for the 4th conditional formatting addition. I couldn't see the forest through all the trees!! LOL Great tutorial. Kay Lenort"
|
|
"Loved the bit of tickery for the fourth condition . . . without this tutorial I wouldn't have discovered that possibility."
|
|
"Really useful lesson, it will be of great use.
many thanks. "
|
|
"I have just spent an afternoon juggling with amounts so as to only use three formats - when ideally I wanted four - and here is the answer !
So simple its brilliant !!"
|
