+ Reply to Thread
Page 1 of 12 1 2 3 11 ... LastLast
Results 1 to 15 of 174

A Whole Bunch of Tips & Tutorials I've Learned

  1. #1
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,109

    A Whole Bunch of Tips & Tutorials I've Learned

    Hey everyone, my name's benishiryo & i am an Excel addict... it's almost 2 years i've been in this forum & although I've only been helping only since about Apr 2012, i've learned more than i can ever imagined. So i'm sharing all (well, most. ok maybe just stuff i bothered to note down when i'm not being lazy) the stuffs i've learned in this 1 year. it may be an overkill for some to have so many things inside though.

    a big thank you to all OPs i've helped because cracking my brains for you guys made me learn things through it. and definitely mostly due to contributors here i've learned from. i'm soooo much better than i was a year ago & i'm not even close to being awesome yet.

    credited some of the tips to the people who provided the solutions, but this started later when i thought it would be more appropriate when sharing. So i'm sorry if some of the solutions were from you & i missed your name. If this file proves useful or if this thread becomes "stickied", i will then keep updating it.
    =)

    Edit: Will constantly be updating the opening post (so no notification if you have subscribed to this!) instead of a new post whenever I have updates, so keep a lookout for the date in the file name if you guys are interested. Explanations written inside the file are done by me, with the exception of 1 case where I asked Ron Coderre about a portion of his amazing formula & he helped explain. i hope the new layout is easier for users to find what they need. i guess i need to categorize them but it's kinda tough. just keep a lookout for this on a monthly basis. i'll try to do updates
    Attached Files Attached Files
    Last edited by Fotis1991; 05-05-2015 at 01:04 PM. Reason: Updated file.

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,745

    Re: A Whole Bunch of Tips & Tutorials I've Learned

    Nice work Ben!
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,145

    Re: A Whole Bunch of Tips & Tutorials I've Learned

    Nice work. I will sticky this thread.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  4. #4
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,109

    Re: A Whole Bunch of Tips & Tutorials I've Learned

    @Fotis:
    thanks!

    @arlu:
    ahhh just like that eh? i thought it has to be at least useful. thank you too!

    and thanks for those who repped.
    =)

  5. #5
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,145

    Re: A Whole Bunch of Tips & Tutorials I've Learned

    I did find it useful. Maybe as you keep adding in stuff, it will make it more useful and can remain as a sticky.

  6. #6
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,636

    Re: A Whole Bunch of Tips & Tutorials I've Learned

    Not everyone will have this mentality of sharing their collections/methods which they learned/found/arrived over several years of research to stop others from spending much more time for understanding the hidden secrets (which is stated in the file) which eliminates lot of web research to find those mind blowing approaches.

    Surely many will found it helpful and thanks for sharing your extensive knowledge about excel by way of this file and by of answering the questions


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  7. #7
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,109

    Re: A Whole Bunch of Tips & Tutorials I've Learned

    @sixthsense:
    thanks. it was initially just a file for me to learn some great stuff, but it became such a huge collection i thought it'll be wonderful to share. i do try to breakdown & explain some stuff in the file, but ultimately sharing their wonderful knowledge of Excel. =)

    (repeated in edited opening post) Will constantly be updating the opening post (so no notification if you have subscribed to this!) instead of a new post whenever I have updates, so keep a lookout for the date in the file name if you guys are interested.

  8. #8
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,636

    Re: A Whole Bunch of Tips & Tutorials I've Learned

    Your's reminds me the book called
    Excel Gurus Gone Wild Do the IMPOSSIBLE with Microsoft Excel>Name:  Book Image.jpg
Views: 14099
Size:  26.2 KB

  9. #9
    Valued Forum Contributor Sean Thomas's Avatar
    Join Date
    03-25-2012
    Location
    HerneBay, Kent, UK
    MS-Off Ver
    Excel 2003,2007,2013
    Posts
    959

    Re: A Whole Bunch of Tips & Tutorials I've Learned

    Thanks,
    some of those tips are really usefull to us beginners!
    Thankyou for sharing!
    Regards
    Sean

    Please add to my reputation if you think i helped
    (click on the star below the post)
    Mark threads as "Solved" if you have your answer
    (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code:
    [code] Your code here [code]
    Please supply a workbook containing example Data:
    It makes its easier to answer your problem & saves time!

  10. #10
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,109

    Re: A Whole Bunch of Tips & Tutorials I've Learned

    @Sixthsense:
    ahhh MrExcel eh? seems like a tempting book to get.

    @Sean Thomas:
    you're very welcome! just sharing what i've learned from the others. i hope the new Main page is easy to search for stuffs

  11. #11
    Registered User
    Join Date
    11-20-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    24

    Re: A Whole Bunch of Tips & Tutorials I've Learned

    Wow! Thank you for sharing! You are a star!

  12. #12
    Registered User
    Join Date
    09-03-2004
    Location
    Vancouver, BC Canada
    Posts
    98

    Re: A Whole Bunch of Tips & Tutorials I've Learned

    Thanks a lot for sharing! That makes the learning all the more productive...It was really useful

    Cheers,
    SJ

  13. #13
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,109

    Re: A Whole Bunch of Tips & Tutorials I've Learned

    @Konnie & kollur:
    you're very welcome~ i'm glad you guys found it useful. do look out for it every month for me to fill up the explantions & share new solutions

  14. #14
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    48,639

    Re: A Whole Bunch of Tips & Tutorials I've Learned

    Well gee thanks Ben, now we dont need the forum anymore. OP's can just read what they want from your file, and the rest of us dont get any more thanks or anything *sigh*

    heheh just kidding, that is a really well laid out tutorial, Im sure we will all learn from it. Maybe admin can figure a way to make it something that others can add to?

    Great job
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  15. #15
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,109

    Re: A Whole Bunch of Tips & Tutorials I've Learned

    @FDibbins:
    haha. i'll be really glad if i can compile something that solves most problems in the world. anyway, i think this file would interest excel lovers more than most people here who are more interested in getting a customised solution.

    thanks a lot~ i dont think adding to my file is a good idea because all of us would have different opinions on the explanation & suggestions. maybe a separate file. but then how many people would contribute? it might become very messy to have 10 over files for people to download. who would also keep track to make sure there are no 2 very similar solutions?

+ Reply to Thread
Page 1 of 12 1 2 3 11 ... LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1