iSixSigma

Advanced Excel tips/notes

Six Sigma – iSixSigma Forums Old Forums General Advanced Excel tips/notes

This topic contains 59 replies, has 52 voices, and was last updated by  sathisz 11 years, 4 months ago.

Viewing 60 posts - 1 through 60 (of 60 total)
  • Author
    Posts
  • #39758

    robbo
    Member

    Hi all
    A few years back I had some in-house training on Advanced Excel where I was taught about macro’s, IF statements, manipulate data etc but during the training there were no notes given and as I was really concentrating on the screen I didnt make any notes either (AAAAAAAARRRRGGGHH). You can see where this is going can’t you……..Now I have moved on to a different company where no-one else has advanced knowledge and no budget for training, this little black belt foolishly mentioned about doing an advanced Excel course once and before you know it I need to train some of my team. So has anyone out there got any fab websites they can recommend to me please? (I have seen the exceladdict.com which is great but would prefer to have notes to run a session for 2-3 hours) I await you comments – I will ignore any that tell me I should have taken notes !! :-) Cheers

    0
    #121697

    theCanadian
    Member

    Hello Robbo,
    Think I can help you out. Came across the same situation (where people needed training – but no budget to get it done)
     
    I put together a training paper, details simple formula’s through more complex like trends, vlookup’s, reference operators, pivot tables etc. You can have if you want. (its about 5mb word document if you want)

    0
    #121701

    Swaggerty
    Participant

    oh my god could i be the first to ask for a copy of this?!   I’m doing the same thing here. 
    yrag28@sigecom.net is my email if you could be kind enough to send it. thank you for sharing.
    George

    0
    #121702

    Mark Hanke
    Participant

    I am also interested and will gladly reciprocate with Excel solutions that I have developed/borrowed/copied/etc… Please forward spreadsheets/etc to mhanke@ford.com and I will respond with similar material

    0
    #121703

    Garrett
    Participant

    ditto here… I want a copy of it also. How do we Black Belts always end up having to do training on Non-SS stuff??? LOL!
    Thanks,
    Garrett

    0
    #121704

    Deep
    Participant

    Can i have the copy tooo. I am not doing any training. I just wanted to learn it. Email ID is microsoft_sucks0[AT][YAHOO][DOT][COM]

    0
    #121708

    Habib
    Participant

    Please send me a copy at habib962002@yahoo.com

    0
    #121710

    Thomas Maier
    Member

    I would also appreciate to get a copy – regards Thomas.maier@novartis.com

    0
    #121739

    robbo
    Member

    A true star – Many thanks indeed
    Would you be so kind to send it to me at jrjrjr@talk21.com Thanks in advance
    Robbo

    0
    #121754

    Nwajei
    Participant

    Hello, This is really I am looking at. Could you send me a copy to frank_zhao7e7@yahoo.com.cn. Thanks a million!!!
    Best RegardsFrank

    0
    #121756

    aki
    Participant

    Hi,
    could you please send me the helpful notes to akila_shiv@yahoo.comThx
    Akila

    0
    #121761

    Ryan
    Member

    I would really appreciate it if I can also have a copy of your great http://mailto:Brooklynnitro@msn.com  thanks in advance.
    Ryan

    0
    #121767

    Nagaraj Kini
    Participant

    Hi,
    If you can send me the soft copy of the document (E-mail ID : Nagaraja.kini@sdgc.com), it would be very helpful for my work.
    Regards,
    Nagaraj Kini
     
     
     
     

    0
    #121770

    Adel
    Participant

    i would really appreciated, if you can send this to me at 
    exxol90@yahoo.com
     
    thanks for your help
     
    ADEL 

    0
    #121773

    Jaycee
    Participant

    Sorry to add to the already long list of requests but if at all possible I would greatly appreciate a copy as I’m trying to get to grips with Excel and am struggling a bit.
    Many Thanks
    jcurtis@syfer.co.uk

    0
    #121777

    Dion Koh
    Participant

    Dear all,
    I was browsing throught the internet & came upon these messages. I would like a copy too. You can email it to kohlkdion@ocbc.com.my
    Thanks a million

    0
    #121788

    Mandalia
    Member

    Hi,
    Looking at such a loooong list ( i’m also in the que) wud it not be nice if it is kept in a common folder in Yahoo or any other place.
     
    TIA

    0
    #121789

    Anand
    Participant

    I am new member to this forum. I would like to get a copy of the notes as well. I am very excited to find this forum. Thank you very much in advance. Could you please send me a copy at dealguy_2005@yahoo.com

    0
    #121791

    Christie
    Participant

    Please send me a copy, many thanks. judy_freeman@uhc.com

    0
    #121797

    Sinnicks
    Participant

    Hi.  Could you send e a copy as well?  I greatly appreciate it!   
    Mark_Almeter@UHC.com
     
     

    0
    #121799

    Ashman
    Member

    Would deeply appreciate a copy, too.  implementlean@hotmail.com
    Thanks!
     

    0
    #121801

    Xavier
    Member

    I dare to ask for a copy of it; dare ’cause I’m a student form Barcelona, no black belt, though interested in this world. Thank you very much. xanatale@yahoo.com.au

    0
    #121803

    Xavier
    Member

    I dare to ask for a copy of it; dare ’cause I’m a student form Barcelona, no black belt, though interested in this world. Thank you very much. xanataleyahoo.com.au

    0
    #121804

    George Hunter
    Participant

    I would be forever grateful for this information.  Thank you for sharing.

    0
    #121808

    Tony Greco
    Member

    I would also greatly appreciate a copy!  anthonypgreco@yahoo.com
    Many thanks!

    0
    #121809

    vandehei
    Participant

    I’d very much appreciate a copy too.  Many thanks in advance.  (anniecatz@hotmail.com)

    0
    #121813

    AT
    Participant

    Could you send me a copy as well. Thank very much in advance.My e-mail is jkadalbal@bellsouth.net

    0
    #121832

    robbo
    Member

    We really need thecanadian to come up with the document now. If I get the copy I will save it to a site you can get access to, to save the canadian the trouble of sending it to about 50 email addresses.

    0
    #121833

    Kevin D
    Participant

    Would greatly appreciate a copy of this
    Thank You
     
    Kevin Dolan
     

    0
    #121836

    Tim
    Member

    I would also like a copy if you could forward this please.timothy.neuhausel@motorola
    thanks so much. tim

    0
    #121838

    Vargas
    Member

    I would very much appreciate a copy….please.
    Thanks in advance.
    Srini

    0
    #121848

    Chauhan
    Member

    Dear theCanadian.
    Hi,
    Would appreciate a copy too,
    At prajvi@hotmail.com
    Thanks a lot

    0
    #121850

    Scott
    Member

    Hi, if you have received the info, I would appreciate if you could share it with me.
    Please mail it to karthik.ramalingam@gmail.com
    Thank you
     

    0
    #121852

    Xavier
    Member

    Why not sharing this info as a team, a web: each one sends a mail with the tips to the next one in the order of the discussion, so I’ll sent it to the next one to post a reply, and I’ll receive it from the previous one.

    0
    #121853

    Alice
    Participant

    Hello theCanadian,
    I’m glad to read your reply to Robbo. I’m facing the same problem too since last year, and now still working hard on it, especially for Pivot Table. I’ve try to search from web, unfortunately, no useful input.
    Would be much appreciated if you can post me the training paper, as you mentioned. My e-mail add. is weiwei_my_2000@yahoo.com
    It’s better if you can save in somewhere with a link since that’s a huge file (5mb) and a lot of people interested.
    Thank you in advance.
    Best Regards,
    Alice

    0
    #121856

    Clowers
    Participant

    Hi Rick
    The very best site, author etc on Excel is John Walkenback who has an excellent site with loads of tips etc and free macros at http://www.j-walk.com
     I learnt how to write macros from his books and they are very enjoyable and realistic.
    Hope this helps

    0
    #121870

    Shailaja
    Member

    Hey, I am a fresher at job…. buddying Six Sigma enthusiast… Green-Belt certified…. and need to work a lot n hard with Excel. Appreciate any help with such Advanced Excel tips, to my email- sshailaja@gmail.com, please! Thanks a Ton!

    0
    #121871

    Shailaja
    Member

    Hey Mark, would you mind sharing such begged/borrrowed/stolen collections on Advanced Excel tips, please…. :)          
    to s.shailaja@ge.com or sshailaja@gmail.com Thanks!

    0
    #122082

    Luis C
    Participant

    Hola The canadian/Mark,
    Do you mind share the excel material?
    Email to lcgallardo@yahoo.com
    Thanks

    0
    #139569

    Doug G
    Participant

    Hi – If you please forward me the much talked about Excel training, it would be greatly appreciated. Email: dgroves21@yahoo.comThanks, Doug

    0
    #139574

    Almudena
    Participant

    Hello the Canadian,
    I would appreciate if youd could e-mail me your training paper to: andaluzal@hayoo.es
    Thank you
    Almudena

    0
    #139591

    Chugh
    Participant

    Hey Alice
    I think i

    0
    #139592

    Chugh
    Participant

    Hey Alice,
    I think it is a better Idea to go to MS Help by pressing F1 instead of going & searching on net…
    you will find everything there
    What you can do is
    1 Press F1
    Office assistant will ask you, “what to search”
    2. Enter the funtion that you are looking for with ( )
    for example if you are looking for an Iserror function, enter Iserror()
    or for Dcount, enter Dcout()
    There you will find options like, Microsoft excel fomula
    click there and you can get good enough information & examples for everything, also you will come to know the related functions that can be used either
    I understand, its a very tidy way to learn… but learning hard way will definitely fetch you the best results…
    Take care !!Manish
    Manish.Rawat1@gmail.com

    0
    #139597

    Rajesh Mohandas
    Participant

    Visit the link below for any tip advanced or novice…
    http://www.excelforum.com/
    This is a very good link I frequently refer for any advanced operation.
    Rajesh.

    0
    #155748

    arjo
    Participant

    can i have a copy please, a big thanks!!!

    0
    #155785

    ezweld
    Participant

     I really have tried not to post on this thread. Every time I read it I get so upset. I don’t like the people that openly attack others on what they post. But come on, you have told people you know something you clearly don’t. Not only that but you clamed to be at the level to teach. It’s one thing to lie about something, but to get up in front of others and pretended to be an expert. This is just the worst thing I have ever heard. But what makes that more tragic, half the people replying to this post said they are in the same situation.
     
    About a year ago I posted that I was building my own SPC run charts that would update themselves at night. The charts were going to be in Excel that used VBA (macros) to take data from an Access database and change the color of the point on the charts if conditions were or were not met. I was bombarded with comments that said my company should buy me software and I should not waste my time. Over the past 8 years I have been trying to learn Excel. I have spent a fortune on books and have taking apart every spreadsheet that had anything I could learn from it. I have 12 Excel books in my home office that doesn’t even skim the surface of how many I have read or that I own. I would say with little doubt I know more about Excel than most people. But, I would never claim I could teach Advanced Excel. I don’t know what is on theCanadian cheat sheet but it’s not what you need to teach an advanced class. Maybe people think V-look ups are advanced or some Macros even. That’s a joke.
     
    My point is you are pretending to know something you don’t and that is going to hurt whomever you teach. That’s not fair to them. When I was first learning to write VBA code or complex formulas I would have loved to have had a class on it. I can’t tell you how mad it makes me that you think so much of yourself that you would pose as an expert. But the thing that really burns me up is no one has given anyone on this thread a hard time for hypocrisy. I felt like I was reamed over working hard to give the company something it needed but wasn’t willing to pay for. But you guys not even putting any effort into learning how to use Excel and claming to be at the advanced level just makes me want to vomit.

    0
    #155786

    Jose
    Participant

    I’d very much appreciate a copy too.  Many thanks in advance.  hbarrero05hotmail.com

    0
    #155787

    Sharma
    Member

    Hi Canadian, please mail me a coply of the document to rshashidhara@gmail.com

    0
    #155790

    accrington
    Participant

    Why would you want to spend half your life fiddling around with Excel?
    MINITAB is cheap as chips, much quicker, correct formulae, prettier graphs, real person on its help desk,etc.

    0
    #155793

    suryakiran
    Member

    hi could you please kindly send me the helpful notes to suryakirankommina@yahoo.co.in.  thanks in advance

    0
    #155796

    Suman Swamy
    Member

    Hi,
    I guess i am also on this list…. can you please send me a copy to sumanswamy@yahoo.com. Thanks in advance

    0
    #155806

    ezweld
    Participant

    I love Minitab. I had to beg for the company to buy it for me. One of the ways I convinced them was to do a cost analysis in Excel. Access and Excel are 2 of the most powerful programs you have on your computer. That’s mainly because of VBA capability. You can control many programs from Excel or Access by adding a reference to the project window in the VB window. For example let’s say you have data that comes to you in a report that’s in a text file that is not delimited and the column widths do not match up. (This may not be true for you but many companies are still running legacy systems with this scenario) You can use Excel to extract the data you need and format it to be used with Minitab or some other program automatically.
     
    This is an example of a excel sheet I use to pull info out of a legacy system report and put it in to a report in Excel to print and save it.
     
    This is a string from the report I need to get the information from.
    91329801   Q1024.003|99 35.50    7500.00 LB      6925.00
     
    To get the first part of the string you would use.
    =LEFT(TRIM(LAW),FIND(” “,LAW,1))
     
    To get the 2nd part of the string you would use.
    =RIGHT(LEFT(TRIM(LAW),FIND(“|03”,LAW,1)+0),FIND(“|03″,LAW,1)+1-FIND(” “,LAW,1))
     
    The 3rd part I don’t care about
     
    To get the 4th part of the string you would use.
    =RIGHT(LEFT(LAW,FIND(“LB”,LAW,1)-1),12)
     
    The 5th part I don’t care about
     
    LAW and GLAW are named ranges in my workbook.
     
    LAW=OFFSET(GLAW,0,3)
     
    GLAW=(“Currently selected cell”)
     
    I use this code to save the workbook from a value I get from the report.
     
    Workbooks.Open Filename:= _
            “C:Documents and SettingsUserDesktopRfolderMyReport.xlt”
       
    Range(“date”) = cate
                Range(“product”) = cproduct
                Range(“prodnum”) = wznum
                Range(“cpn”) = gone
                Range(“onumber”) = WSO
        ActiveWorkbook.SaveAs Filename:=SaveAsName
       ActiveWindow.Close
     
     
    Here is another good example of why I have put so much of my time into learning Excel.
    This formula calculates the lower range of my chart.
     
    =IF(IF(N2=0,AVERAGE(LboundValue)-STDEV(LboundValue)*3,IF(N2<AVERAGE(LboundValue)-STDEV(LboundValue)*3,N2-N2*0.01,AVERAGE(LboundValue)-STDEV(LboundValue)*3))<0,0,IF(N2=0,AVERAGE(LboundValue)-STDEV(LboundValue)*3,IF(N2<AVERAGE(LboundValue)-STDEV(LboundValue)*3,N2-N2*0.01,AVERAGE(LboundValue)-STDEV(LboundValue)*3)))
     
     
    LboundValue is a named range
    LboundValue =OFFSET(Sheet1!$F$2,COUNTA(Sheet1!$A:$A)-NumSamples-1,0,NumSamples,1)
     
    NumSamples is a named range
    NumSamples =Sheet1!$S$1
     
    Sheet1!$S$1 is a cell
    Sheet1!$S$1=IF(COUNTA(Sheet1!B:B)>50,50,COUNTA(Sheet1!B:B)-1)
     
     
    I know some people that would argue about Minitab charts looking better than Excel charts. I will say that I can do more with Excel charts than I can with Minitab charts.  Also my requrement called for 4 to 8  charts to be placed side by side on one page to be in HTML and post and update automatically.
    Also I think the time I spent learning about Excel has added value and has not been a waste. The reason I have spent so much time is there is so much to learn.

    0
    #155828

    Kaushik
    Participant

    Could you please send me a copy.
    Thnaks in advance…
    Arun

    0
    #157951

    Kazi Imran
    Participant

    Please send me a copy…………… on my email
     
    thanks in advance…………………………………..

    0
    #157956

    Fake Gary Alert
    Participant

    Why?

    0
    #158880

    Kat
    Participant

    ei… can you send me copy of your excel notes… it will be of great help specially for us whose doing paper reports… thanks in advance… do send it at kitkat_1105@hotmail.com :)

    0
    #158891

    qualitycolorado
    Participant

    Kat and others, Good morning!
    FYI,  Microsoft  has free tutorials on various topics about Office 2003 products, including PowerPoint, Excel, Outlook, Access and Word — the main listing is at this link:
    http://office.microsoft.com/en-us/help/HA102262291033.aspx
    There are 38 free tutorials for Excel, on various topics like “Pivot Tables”, at this link:
    http://office.microsoft.com/en-us/training/CR061831141033.aspx
    Hope this is helpful to you!
    Best regards,
    QualityColorado

    0
    #158892

    qualitycolorado
    Participant

     …. For instance, here is a nifty set of tutorials about Pivot Tables in MS Excel:
    Pivot Tables, Part 1:
    http://office.microsoft.com/training/training.aspx?AssetID=RC010136191033

    Pivot Tables, Part 2:
    http://office.microsoft.com/training/training.aspx?AssetID=RC010286901033
    Pivot Tables, Part 3:
    http://office.microsoft.com/training/training.aspx?AssetID=RC010381561033
     

    0
    #169500

    D Parks
    Participant

    Is it still possible to get a copy?  I see that you did this in 2005, that’s why I’m asking.

    0
    #172741

    sathisz
    Member

    Hi I need a copy of Excel Training Documents. Appreciate you Help.

    0
Viewing 60 posts - 1 through 60 (of 60 total)

The forum ‘General’ is closed to new topics and replies.