I consider myself to be a fairly well educated person. I work for a large brokerage firm and I can easily navigate the software programs I use for work and if there was a change, I think I’d easily adapt. I’m an idiot when it comes to using other software, such as Office.
I have no idea how to do a powerpoint.
My Excel skills are probably less than the average 5th grader. I can open a sheet and put numbers in, but that’s about it.
I can use Word to write letters and maybe a resume.
If Outlook is still considered part of office, I can use it to manage emails, I can create folders and assign certain emails to be directed to folders. I have to look up how to create an out of office message as well as change my signature, but I can do these tasks.
I’m OK at Excel, good at Word, can open a database in Access, and can make a decent PowerPoint. Outlook is our everyday email and scheduling program at work, so I am pretty good with that.
Other things, like Publisher and Project? No clue.
Mostly the same here, except that I can design using Access (I took classes.) and am not as good with Excel. There were no classes offered for those other programs.
I can use OneNote, though. We had to use it a lot in Photoshop class. It was how we sent in screenshots of our layers panel.
I have fairly advanced skills in Word and Excel, which are part of every Office bundle, and Outlook, which is part of some. I am pretty good at Project; although it is marketed as an Office application it is never sold as part of an Office bundle. I have written many VBA macros that provide advanced and custom functionality and integrate all of them to varying degrees.
I have a passing familiarity with Access, which is included in some Office bundles. Also Visio, which is again marketed as Office but I don’t think it’s ever bundled.
I think OneNote is a good product but for me it is still a solution looking for a problem.
There is enough to each of these apps (at least the major ones) that you probably really need to take a class to get really good at using them.
Several years ago, I took a class at the local adult school in Office Apps. It used a sizable workbook-style text book, with large chapters on each app (Word, Excel, Powerpoint, Access). The class was self-paced mostly – just work through the exercises in the book at one’s own speed.
Before the class, I was “slightly” knowledgeable with Word, Excel, and Access and knew exactly zilch about Powerpoint. I learned all sorts of stuff – from major functions down to a variety of little tricks – that I hadn’t dreamed about these apps. I came out of the class much more proficient in Word, Excel, and Access, and with some minimal knowledge of Powerpoint.
So, yeah, there’s enough to these apps that you should really take a class to make best use of them. Or, if you have the self-discipline and motivation, get a good teach-yourself book (and I do mean a good one, not some “Dummies” shit) and work through all the exercises.
I actually teach an introductory Microsoft Office class at a community college, so I think I’m pretty good at Outlook, Excel, Word, PowerPoint, but a novice at Access (which we barely cover since it’s a little confusing; I’m pretty good at MySQL though).
I don’t really know Publisher but I think I could learn it in a hour or so. I don’t have any personal need or interest in OneNote or Lync though.
We’re assigned one of those step-by-step Office textbooks, but I don’t assign anything out of it. I figure that I should know it well enough to teach it, so I show them how I used the main Office apps while working in business and in some community groups I belong to. I get really good feedback from my students for this course (except for never using the textbook).
Oh, yeah, forgot about Publisher. I know Publisher pretty well. Well enough to know that it sucks. It sucks as a page layout program. It sucks for creating htlm documents. It just sucks.
I’ve hardly ever used any of them. I did experiment with a very early version of Word (pre-windows) and found totally out of sync with my way of thinking. I use a text editor and TeX exclusively. It is great for publishing and also for presentations. I have never used a spreadsheet or database.
I resent when people (especially my administration) sends me stuff in .doc (which my wife can convert for me) or .docx (which she can’t). Would they agree to pay for a copy of Word for me? They would not. So I delete them unread and send them a note to that effect, which they ignore.
I used to be great at Excel and Word. Then Office 2007 came along and now I can’t find any damned thing. The fact that I am not using them for work (I’m retired) makes it worse as I don’t need features often enough to remember where the hell they decided to hide them.
I am proficient at Powerpoint and Visio, and pretty much expert level in the other apps. I know VBA (Visual Basic for Applications) which allows you to do pretty much anything that you can imagine and program. You can actually develop working and useful frontend to Access or Excel using this tool.
Hah! I took that same test about 10 years ago (or a very similar one.) I had never used Access or Powerpoint, and barely Excel, yet I had the same results. If you had two brain cells and have used a Microsoft product before, it was pretty easy to figure out.
How I would really rate my skills? I’m pretty decent in Word and Excel, but not an expert by any stretch. There is just so much you can do with these programs, and I feel I haven’t even scratched the surface. I can figure out whatever I need to get done easily, though, thanks to the internet. With Powerpoint and Access, that’s all a matter of learning or relearning as I go at this point. Don’t think it would take me long to get up to speed, but I haven’t used either of these programs since that temp stint 10 years ago (and I didn’t use Powerpoint at all, though I suspect that’s not hard to pick up.)
Publisher was going to be Microsoft’s entry into desktop publishing. About 15 years ago they provided it free to commercial printers (along with a spiffy “Publisher Files Welcome Here!” window cling sticker.) In the next version, they changed it to make it more “Office-like,” which is the last thing commercial printers wanted. It languishes on, neither fish nor fowl.