Posts: 440
Threads: 46
Likes Received: 1 in 1 posts
Likes Given: 0
Joined: Mar 2011
TGIF friends! Just a random question. Are any of you MO experts? I love using excel, but I'm hardly advanced at it and realize there are SO many cool things you can do, along with all the rest of the MO stuff. I know most people are not advanced, but for those who are, how did you gain your experience?
Some of my excel knowledge came from a high school course. However, I would love to be an Excel/PowerPoint master. It's SO useful in the business world. Do you guys take online classes, etc.? I searched for interactive classes, on them, and couldn't seem to find anything..esp. that wouldn't cost an arm and a leg. I have tutorials for all of them, but I feel like I learned the most when I was in my high school class and the teacher explained it and actually graded us and had us do the spreadsheets. Am I geek for thinking these two programs are so cool and wanting to become masters of them? LOL
![[-]](https://www.degreeforum.net/mybb/images/collapse.png)
•
Posts: 687
Threads: 61
Likes Received: 1 in 1 posts
Likes Given: 0
Joined: Dec 2010
06-10-2011, 11:08 AM
(This post was last modified: 06-10-2011, 11:25 AM by STG.)
CollegeStudent7 Wrote:TGIF friends! Just a random question. Are any of you MO experts? I love using excel, but I'm hardly advanced at it and realize there are SO many cool things you can do, along with all the rest of the MO stuff. I know most people are not advanced, but for those who are, how did you gain your experience?
Some of my excel knowledge came from a high school course. However, I would love to be an Excel/PowerPoint master. It's SO useful in the business world. Do you guys take online classes, etc.? I searched for interactive classes, on them, and couldn't seem to find anything..esp. that wouldn't cost an arm and a leg. I have tutorials for all of them, but I feel like I learned the most when I was in my high school class and the teacher explained it and actually graded us and had us do the spreadsheets. Am I geek for thinking these two programs are so cool and wanting to become masters of them? LOL I also had a class to teach me about Excel but I never understood it... For PowerPoint and Microsoft Word my high school taught me a lot (especially PowerPoint). For my bio class that I'm taking we need to work in groups to make a slide show and I'm happy I'm an expert with that...
The way our teacher taught us was by telling us to play around with all the buttons and see all the animations and sounds you can put in but I still never got it until she made us make a slide show of our own with 50 slides and we needed to add in music so she taught us all the different stuff and we worked on it for about 7 months...it was kind of annoying at first but once I figured it all out (by asking a million questions) it was fun and I got an A 
- [SIZE="2"]STG[/SIZE]
[COLOR="Plum"][SIZE="1"]Intro to Sociology 51|Biology 54|Intro to Psychology 61
College Algebra A[/SIZE][/COLOR]
[COLOR="DarkOrange"]124 credits: B.A Social Sciences [B]DONE in 14 months; August 2011[/COLOR][/B]
"The pessimist sees difficulty in every opportunity. The optimist sees opportunity in every difficulty"- [COLOR="DarkOrchid"]Winston Churchill[/COLOR]
•
Posts: 2,142
Threads: 135
Likes Received: 210 in 130 posts
Likes Given: 181
Joined: Jun 2010
I used to know a lot more than I do now. Years ago, my first boss at my first real 'professional' job took me under his wing and spent days of his time going through excel with me. I learned a LOT, which for the job I was in, I actually used quite a bit of it.
When I started using Microsoft Outlook, I bought the big yellow Dummies book and read everything I could.
Time has gone by and I have stopped using the more advanced skills. I know how to do what I need and that's it. Excel is not something I use every day but I did keep my Outlook ability.
If you still want to be an executive assistant in the future, you will absolutely need to have amazing excel, word, PPT and Outlook skills. The execs don't necessarily know how to use all these tools well and they will come to you and say "can you do this or that to make my PPT in front of the board of directors look good?" There will be no room for error. If you make your boss look bad in his/her presentation, your exec assistant career will be short-lived.
That being said, if you don't think you can even get the job without the degree, you shouldn't waste your time on it now. Start testing and get in the swing of things. Plan on taking a dedicated Microsoft Office class after you graduate. My local rec center offers them for under 100 bucks. OR, you could decide to find a class to teach you at your local community college and use those credits towards your degree.
Regis University, ITESO, Global MBA with a focus in Emerging Markets 4.0 GPA, Dual-university degree (Spanish/English)
ISSA Certified Nutritionist
COSC BS, Business Admin
My BS Credits:
Spanish 80 | Humanities 67 | A & I Lit 72 | Sub Abuse 452 | Bus Ethics 445 | Tech Writ 62 | Math 53 | HTYH 454 | Am. Govt 65 | Env & Humanity 64 | Marketing 65 | Micro 61| Mgmt 63| Org Behavior 65| MIS 446|Computing 432 | BL II 61 | M&B 50 | Finance 411 | Supervision 437| Intro Bus. 439| Law Enforcement 63| SL: Accounting I B | Accounting II C+| Macro A | ECE: Labor Relations A | Capstone: A| FEMA PDS Cert
•
Posts: 440
Threads: 46
Likes Received: 1 in 1 posts
Likes Given: 0
Joined: Mar 2011
Oh yes, definitely. I know how to use that stuff, it was just something I'm asking on the side..and you're right---execs really are clueless with that stuff! hilarious
•
Posts: 132
Threads: 21
Likes Received: 0 in 0 posts
Likes Given: 0
Joined: Mar 2011
I use excel constantly in my job - Corporate Retail relies heavily on it.
To be honest, the most advanced formula's I was using before working here were SUMs, and I thought that was advanced.
I recommend just buying a book or viewing a Lynda.Com video. I have learned SO many new functions during my training here. More than any class could really provide. I was forced to learn many of the necessary skills for my job role on the spot.
VLOOKUP is one formula that is highly sought after, as is the use of Pivot Tables.
If you learn both of those, you'll know more than many, even those who take classes.
I also recommend to NOT take an Excel VBA class until you know you need it. If you are still fresh using excel, use VLOOKUPs, they are the MOST useful formula's I know of.
Let me know if you have any questions. I currently have 4 different spreadsheets I'm working on at work all 20mb+ filled with TONS of formulas.
---Graduatedt Excelsior - BS - General Business - Conferred August 2012---
Social Sciences CLEP:59 - Humanities CLEP:55 - Natural Sciences CLEP:53 - Analyzing & Interpreting Literature CLEP:59 - Management & Information Systems DSST:435
Human Resource Management ECE:C - Org. Behavior ECE:C - World Population ECE:C - UExcel Political Science:C - 2 NFA ACE Approved Courses
Straighterline:Criminal Justice, Western Civilization 1 and Sociology - Passed, Penn Foster Cost Accounting & Financial Management:Both B
CSU MGMT 311 Operations Management: Finished April 2012 - A, Business Ethics & Society DSST -- 440, BUS495 - EC Business Capstone - A
Finished - AS - Business from Excelsior - 61 credits 2.8 gpa - Commencement July 2011
•
Posts: 303
Threads: 19
Likes Received: 1 in 1 posts
Likes Given: 0
Joined: Apr 2011
I have been in IT forever so I use excel for a ton of different things.
But learning by example worked for me, simply go out to office.microsoft.com, look through the template files and look at how the formulas were used in various spreadsheets that people created.
Also if you go to that site, you will see a menu at the top called support, just find the excel support site and you will find links to everything you can think of like pivot tables, formulas and nested formulas, macros, and conditional formatting. When you see the video link, that is just what it says, videos on how to do excel tasks.
This is all free and not just for excel but all office apps!
Cheers!
•
Posts: 2,077
Threads: 108
Likes Received: 5 in 5 posts
Likes Given: 0
Joined: Nov 2010
You can become certified in microsoft office. I think it's called a mous.
BSBA CIS from TESC, BA Natural Science/Math from TESC
MBA Applied Computer Science from NCU
Enrolled at NCU in the PhD Applied Computer Science
•
Posts: 440
Threads: 46
Likes Received: 1 in 1 posts
Likes Given: 0
Joined: Mar 2011
ryoder Wrote:You can become certified in microsoft office. I think it's called a mous.
Wow that's cool. How do you go about that?
•
Posts: 132
Threads: 21
Likes Received: 0 in 0 posts
Likes Given: 0
Joined: Mar 2011
06-10-2011, 09:04 PM
(This post was last modified: 06-10-2011, 09:37 PM by durandtheman.)
CollegeStudent7 Wrote:Wow that's cool. How do you go about that?
Microsoft Office Specialist Certification - MOSC
Also, another note, exams are worth 1 credit, so becoming MOSC certified will earn 1 credit towards Applied Professional, becoming an Expert will earn 2. Must be ACE Transcribed.
As a matter of fact, I earned 2 credits for my CompTIA A+ certification, now I'm going to get this Excel certification too! Earn myself that 1 credit to even this out!
$75 total! - GetCertify4Less Purchase Test Voucher for $60 + ACE transcript cost of $15 = 1 Credit and An Addition to your Resume
---Graduatedt Excelsior - BS - General Business - Conferred August 2012---
Social Sciences CLEP:59 - Humanities CLEP:55 - Natural Sciences CLEP:53 - Analyzing & Interpreting Literature CLEP:59 - Management & Information Systems DSST:435
Human Resource Management ECE:C - Org. Behavior ECE:C - World Population ECE:C - UExcel Political Science:C - 2 NFA ACE Approved Courses
Straighterline:Criminal Justice, Western Civilization 1 and Sociology - Passed, Penn Foster Cost Accounting & Financial Management:Both B
CSU MGMT 311 Operations Management: Finished April 2012 - A, Business Ethics & Society DSST -- 440, BUS495 - EC Business Capstone - A
Finished - AS - Business from Excelsior - 61 credits 2.8 gpa - Commencement July 2011
•
Posts: 303
Threads: 19
Likes Received: 1 in 1 posts
Likes Given: 0
Joined: Apr 2011
You can also join the IEEE's computer society for $50 for the year and gain access to all their courses to train with. Most of them are element K and have some form of ACE transferal.
Includes PMP, most of the Comptia's, Various security(Cissp,CISM, CEH, ....), Anything you can think of for microsoft, Oracle/Sun, the list goes on and on.
Element K Online Courses Catalog
The associate for computing machinery has a very similar option, again using the element k material.
ACM Learning Center
I have been a member of IEEE and Computer Society for 12 years now and there is always great information to be learned. Not as long with the ACM but its a great org if you need low cost access to training materials for computer and IT.
If your enrolled at any school and carrying a 50% load you can get the student cost of $40 a year for both IEEE and Computer Society. As a professional my costs are almost $200 a year which is still outstanding but join as a student. The other benefit is our group here in DC got a behind the scenes tour and demo of the Johns Hopkins medical robotics labs!
•
|
