Windows 7 & Office 2010

1235

Comments

  • FrankieGFrankieG Posts: 9,100
    81 wrote:
    FrankieG wrote:
    Don't really want to start a new thread, but I don't want to hijack this one either... Tell me if this is thread worthy or just answer here. :lol:

    Is anyone a Microsoft Office Specialist?
    http://www.microsoft.com/learning/en/us ... x#overview

    Is it worth it? As a resume builder and as a skills builder.
    Anyone a hiring rep that would enlighten me if they look for this?

    I was looking to maybe take some classes to improve my skills and then take the test to put on my resume.. opinoins?

    I'm a self taught Excel Guru....does that count?

    i can't answer if the litte degree would make a difference....however, i believe excel classes are bunk. IMO, if you really want to learn excel or any other office product....open up the program and start playing around. push the buttons and see what they do. write some formula's and see what they do. it's about using and doing vs. spending a day or two in a classroom listening.


    I'm self taught too, and consider myself better than most when I have used it for many engineering reports and projects.

    I don't want to sit through the class. Best case senario is if someone has taken it before and can tell me if I know enough to just go in, pay for it and pass without having to review anything or learn anything new. My main goal is to have proof to future employers that I have proficient skills at excel and word. (i am going to be a college senior is september so i figure now is a prime time to do it.)
    2003: 7/14 NJ ... 2006: 6/1 NJ, 6/3 NJ ... 2007: 8/5 IL ... 2008: 6/24 NY, 6/25 NY, 8/7 EV NJ ... 2009: 10/27 PA, 10/28 PA, 10/30 PA, 10/31 PA
    2010: 5/20 NY, 5/21 NY ... 2011: 6/21 EV NY, 9/3 WI, 9/4 WI ... 2012: 9/2 PA, 9/22 GA ... 2013: 10/18 NY, 10/19 NY, 10/21 PA, 10/22 PA, 10/27 MD
    2015: 9/23 NY, 9/26 NY ... 2016: 4/28 PA, 4/29 PA, 5/1 NY, 5/2 NY, 6/11 TN, 8/7 MA, 11/4 TOTD PA, 11/5 TOTD PA ... 2018: 8/10 WA
    2022: 9/14 NJ ... 2024: 5/28 WA, 9/7 PA, 9/9 PA ---- http://imgur.com/a/nk0s7
  • 8181 Posts: 58,276
    i like the remove duplicate button....first thing i've found in 2010 that is worth a crap

    i've not found a problem where certain files seem to self corrupt which prevents me from saving :fp:

    2010 still blows overall
    81 is now off the air

    Off_Air.jpg
  • rick1zoo2rick1zoo2 Posts: 12,632
    FrankieG wrote:
    81 wrote:
    FrankieG wrote:
    Don't really want to start a new thread, but I don't want to hijack this one either... Tell me if this is thread worthy or just answer here. :lol:

    Is anyone a Microsoft Office Specialist?
    http://www.microsoft.com/learning/en/us ... x#overview

    Is it worth it? As a resume builder and as a skills builder.
    Anyone a hiring rep that would enlighten me if they look for this?

    I was looking to maybe take some classes to improve my skills and then take the test to put on my resume.. opinoins?

    I'm a self taught Excel Guru....does that count?

    i can't answer if the litte degree would make a difference....however, i believe excel classes are bunk. IMO, if you really want to learn excel or any other office product....open up the program and start playing around. push the buttons and see what they do. write some formula's and see what they do. it's about using and doing vs. spending a day or two in a classroom listening.


    I'm self taught too, and consider myself better than most when I have used it for many engineering reports and projects.

    I don't want to sit through the class. Best case senario is if someone has taken it before and can tell me if I know enough to just go in, pay for it and pass without having to review anything or learn anything new. My main goal is to have proof to future employers that I have proficient skills at excel and word. (i am going to be a college senior is september so i figure now is a prime time to do it.)

    I guess I am self taught too in excel and access. what I know I either figured out myself, stole from someone else, or now I even google things. taking classes might teach a few nuggets or most likely how to make pretty reports, but to me, not worth it.
  • 8181 Posts: 58,276
    if FY1 can't fix your problem, mrexcel.com ussally can
    81 is now off the air

    Off_Air.jpg
  • rick1zoo2rick1zoo2 Posts: 12,632
    I remember the guy that showed me pivot tables, he had a very dry sense of humor, I don't think he even knew just how funny he was.

    me: "I understand you could show me how to do pivot tables"

    He says "look, you do this, this, and this"

    me: "that's it?"

    him: "yes, that's it. now go away and die"


    and oddly enough, not long after that he passed away, he was about the age I am now......hmmm........
  • 8181 Posts: 58,276
    rick1zoo2 wrote:
    I remember the guy that showed me pivot tables, he had a very dry sense of humor, I don't think he even knew just how funny he was.

    me: "I understand you could show me how to do pivot tables"

    He says "look, you do this, this, and this"

    me: "that's it?"

    him: "yes, that's it. now go away and die"


    and oddly enough, not long after that he passed away, he was about the age I am now......hmmm........

    you lost me at pivot tables. :lol:
    81 is now off the air

    Off_Air.jpg
  • 8181 Posts: 58,276
    excel tip of the day....

    if you want to average 12 columns of data, don't select 14 columns. :fp:
    81 is now off the air

    Off_Air.jpg
  • 8181 Posts: 58,276
    had to call a former coworker today for spectra question...

    she said.....














    wait for it











    you know it's coming

















    she was working on a pivot table.
    :lol:
    81 is now off the air

    Off_Air.jpg
  • WobbieWobbie Posts: 29,912
    I'm not sure I believe you know anything about excel... :?
    If I had known then what I know now...

    Vegas 93, Vegas 98, Vegas 00 (10 year show), Vegas 03, Vegas 06
    VIC 07
    EV LA1 08
    Seattle1 09, Seattle2 09, Salt Lake 09, LA4 09
    Columbus 10
    EV LA 11
    Vancouver 11
    Missoula 12
    Portland 13, Spokane 13
    St. Paul 14, Denver 14
    Philly I & II, 16
    Denver 22
  • 8181 Posts: 58,276
    imalive wrote:
    I'm not sure I believe you know anything about excel... :?

    i'll arrange an excel demonstration, if you can arrage for me to do this
    kramer056.jpg
    81 is now off the air

    Off_Air.jpg
  • WobbieWobbie Posts: 29,912
    81 wrote:
    imalive wrote:
    I'm not sure I believe you know anything about excel... :?

    i'll arrange an excel demonstration, if you can arrage for me to do this
    kramer056.jpg

    you'd probably have to sign about a $500,000 waiver :?

    LMK
    If I had known then what I know now...

    Vegas 93, Vegas 98, Vegas 00 (10 year show), Vegas 03, Vegas 06
    VIC 07
    EV LA1 08
    Seattle1 09, Seattle2 09, Salt Lake 09, LA4 09
    Columbus 10
    EV LA 11
    Vancouver 11
    Missoula 12
    Portland 13, Spokane 13
    St. Paul 14, Denver 14
    Philly I & II, 16
    Denver 22
  • 8181 Posts: 58,276
    done....

    how does the week after christmas work.
    81 is now off the air

    Off_Air.jpg
  • rick1zoo2rick1zoo2 Posts: 12,632
    conversation with my boss about an excel spreadsheet that her boss sent her:

    her: "he normally uses salmon to color the stuff he does and I asked him why no color. he said he didn't feel well"

    me: "he doesn't feel well because he didn't color it salmon?"

    her:"no, I think he didn't color it because he doesn't feel well"

    me: "well maybe if he colored it, that might make him feel better"

    her: "maybe"

    me: "and if he made a pivot table from it, now he could really feel good"

    her: "I don't think pivot tables do the same thing for him that they do for me"

    :lol::lol:
    we both laughed a lot and it took a lot of effort for me not to say anything else. we are professionals after all...
  • normnorm Posts: 31,146
    rick1zoo2 wrote:
    conversation with my boss about an excel spreadsheet that her boss sent her:

    her: "he normally uses salmon to color the stuff he does and I asked him why no color. he said he didn't feel well"

    me: "he doesn't feel well because he didn't color it salmon?"

    her:"no, I think he didn't color it because he doesn't feel well"

    me: "well maybe if he colored it, that might make him feel better"

    her: "maybe"

    me: "and if he made a pivot table from it, now he could really feel good"

    her: "I don't think pivot tables do the same thing for him that they do for me"

    :lol::lol:
    we both laughed a lot and it took a lot of effort for me not to say anything else. we are professionals after all...

    that sounds dirty
  • serious post (sorry)

    Just wondering if anyone else has this problem...

    Example:
    In Word or Excel
    I tell current document to print 4 copies
    I close the document
    Go to another document and when I print that document, it prints 4 copies even though it only says 1
    I have to close the program completely and reopen to fix the problem.

    I have killed a few trees because of this problem. I dont understand why the next document would print multiple copies (the same number of copies from the previous print) even thought it says 1. Its a new document, it should have the default settings applied (and it appears to). I have uninstalled and reinstalled Office once already due to some problems I was having, but this one persists.
    Mansfield, MA - Jul 02, 2003; Mansfield, MA - Jul 03, 2003; Mansfield, MA - Jul 11, 2003; Boston, MA - Sep 29, 2004; Reading, PA - Oct 01, 2004; Hartford, CT - May 13, 2006; Boston, MA - May 24, 2006; Boston, MA - May 25, 2006; Hartford, CT - Jun 27, 2008; Mansfield, MA - Jun 28, 2008; Mansfield, MA - June 30, 2008; Hartford, CT - May 15, 2010; Boston, MA - May 17, 2010; [EV - Providence, RI - June 15, 2011; EV - Hartford, CT - June 18, 2011]; Worcester, MA - Oct. 15, 2013; Worcester, MA - Oct. 16, 2013; Hartford, CT - Oct. 25, 2013; Boston, MA -  August 5, 2016; Boston, MA - August 7, 2016...



  • 8181 Posts: 58,276
    serious post (sorry)

    Just wondering if anyone else has this problem...

    Example:
    In Word or Excel
    I tell current document to print 4 copies
    I close the document
    Go to another document and when I print that document, it prints 4 copies even though it only says 1
    I have to close the program completely and reopen to fix the problem.

    I have killed a few trees because of this problem. I dont understand why the next document would print multiple copies (the same number of copies from the previous print) even thought it says 1. Its a new document, it should have the default settings applied (and it appears to). I have uninstalled and reinstalled Office once already due to some problems I was having, but this one persists.

    have you tried rebooting?

    i've not seen that problem. might be a setting someplace...but i doubt it.

    honestly, wish i could help...but here is a bump.
    81 is now off the air

    Off_Air.jpg
  • 81 wrote:
    serious post (sorry)

    Just wondering if anyone else has this problem...

    Example:
    In Word or Excel
    I tell current document to print 4 copies
    I close the document
    Go to another document and when I print that document, it prints 4 copies even though it only says 1
    I have to close the program completely and reopen to fix the problem.

    I have killed a few trees because of this problem. I dont understand why the next document would print multiple copies (the same number of copies from the previous print) even thought it says 1. Its a new document, it should have the default settings applied (and it appears to). I have uninstalled and reinstalled Office once already due to some problems I was having, but this one persists.

    have you tried rebooting?

    i've not seen that problem. might be a setting someplace...but i doubt it.

    honestly, wish i could help...but here is a bump.

    Thanks man.
    Computers here auto reboot weekly after backups and updates... Not to mention the recent power outages... so there have been a few reboots and no fix to the problem. I seem to have the most unusual and unsolvable computer problems here at work. :fp: Reboot is usually always my first go-to option when weird shit happens.
    Mansfield, MA - Jul 02, 2003; Mansfield, MA - Jul 03, 2003; Mansfield, MA - Jul 11, 2003; Boston, MA - Sep 29, 2004; Reading, PA - Oct 01, 2004; Hartford, CT - May 13, 2006; Boston, MA - May 24, 2006; Boston, MA - May 25, 2006; Hartford, CT - Jun 27, 2008; Mansfield, MA - Jun 28, 2008; Mansfield, MA - June 30, 2008; Hartford, CT - May 15, 2010; Boston, MA - May 17, 2010; [EV - Providence, RI - June 15, 2011; EV - Hartford, CT - June 18, 2011]; Worcester, MA - Oct. 15, 2013; Worcester, MA - Oct. 16, 2013; Hartford, CT - Oct. 25, 2013; Boston, MA -  August 5, 2016; Boston, MA - August 7, 2016...



  • 8181 Posts: 58,276
    http://mrexcel.com is my go to source for weird odd questions.
    81 is now off the air

    Off_Air.jpg
  • 8181 Posts: 58,276
    actually, i have a solution...

    when you need 4 copies, hit print 4 times. :lol:
    81 is now off the air

    Off_Air.jpg
  • 81 wrote:
    actually, i have a solution...

    when you need 4 copies, hit print 4 times. :lol:

    yeah... thats pretty much the solution I came to myself :lol:
    just trying to break the old habit of doing it the "right" way. :roll:
    Mansfield, MA - Jul 02, 2003; Mansfield, MA - Jul 03, 2003; Mansfield, MA - Jul 11, 2003; Boston, MA - Sep 29, 2004; Reading, PA - Oct 01, 2004; Hartford, CT - May 13, 2006; Boston, MA - May 24, 2006; Boston, MA - May 25, 2006; Hartford, CT - Jun 27, 2008; Mansfield, MA - Jun 28, 2008; Mansfield, MA - June 30, 2008; Hartford, CT - May 15, 2010; Boston, MA - May 17, 2010; [EV - Providence, RI - June 15, 2011; EV - Hartford, CT - June 18, 2011]; Worcester, MA - Oct. 15, 2013; Worcester, MA - Oct. 16, 2013; Hartford, CT - Oct. 25, 2013; Boston, MA -  August 5, 2016; Boston, MA - August 7, 2016...



  • 8181 Posts: 58,276
    why is it, when i hit F2 and change a cell refrence from say b2 to a2, excel reformats the cell that i am working on. :fp: :nono:
    81 is now off the air

    Off_Air.jpg
  • 8181 Posts: 58,276
    :lol: access powers activate
    81 is now off the air

    Off_Air.jpg
  • 8181 Posts: 58,276
    your powers are weak :x
    81 is now off the air

    Off_Air.jpg
  • 8181 Posts: 58,276
    :x :x :x :x :x

    why is this not working.
    81 is now off the air

    Off_Air.jpg
  • 8181 Posts: 58,276
    :lol:

    stupid xls vs. xlsx

    :fp:
    81 is now off the air

    Off_Air.jpg
  • :yawn:
  • 8181 Posts: 58,276
    :yawn:


    having a high skill level with office can be quite rewarding.
    81 is now off the air

    Off_Air.jpg
  • 8181 Posts: 58,276
    excel powers activate
    81 is now off the air

    Off_Air.jpg
  • I sincerely hope I never have to use excel
  • 8181 Posts: 58,276
    I sincerely hope I never have to use excel

    [will shurg] it's not so bad....when you have mad skills like mine....

    motivation tho....that skill is lacking.
    81 is now off the air

    Off_Air.jpg
Sign In or Register to comment.