A random blogger, in trying to help bolster the confidence of some people, wrote up an article talking about skills that were translatable to Real Life job skills. Most of the article was really quite good, so I am no trying to tear it down. But one of the items in the list was along the lines of, “Can use MS Office. Because come on, you live on the computer and probably type really fast.”
I commented (as gently as I could because I didn’t want to tear the person down, and a lot of the ideas were genuinely good) that if the person claimed to be good at Office and was applying for a job where I worked, they might very well get turned over to me for verification of their skills. And if you’ve read my rants before, you know I DON’T think that just because you can make a WYSIWYG interface look okay in print that you really know Word. Unfortunately, “Skilled at MS Office” would pretty much get this list of questions. They wouldn’t have to say “yes” to everything to get my confidence, but they’d have to say yes on at least half of each of the big three applications for me to give ’em a pass.
Word
- Do you understand document structure and the advantages of formatting in styles?
- Can you edit styles to create style-driven pagination?
- Can you create custom styles?
- Can you use the outline feature?
- Can you create and format a table?
- Can you make use of tables in formatting?
- Do you know when to use tables or styles in formatting?
- Can you insert an image and then format it so that it will be anchored to a specific paragraph?
- Can you use the Table of Contents object?
- Do you know how to format a document using sections so that you can have different headers and footers within a single document?
- Do you know how to use footnotes and endnotes?
- Can you manage sources and use them for citations, footnotes, endnotes and bibliographies?
- Can you use the indexing features to index a document?
- Can you use a table of authorities?
- Do you understand standard pagination and how to use it?
- Can you use SmartArt effectively?
- Do you understand when and where WordArt is professional?
- Do you understand the limitations of the image editing features of MS Office and when to use or not use them?
- Can you use Quick Parts?
- Can you insert a Drop Cap effectively?
- Can you format pull quotes?
- Can you create a text box effectively so that the text of the document flows around it attractively?
- Can you insert shapes and format drawing objects?
- Do you understand Themes?
- Can you create your own themes?
- Can you create custom color layouts?
- Can you insert a chart in Word without using cut-n-paste from Excel?
- Do you know how to use comments effectively?
- Do you know how to use the Track Changes feature?
- Do you know Mail Merge?
- Can you manage Mail Merge sources to filter by specific criteria? (Needed this one today, as a matter of fact, to help improve a user’s workflow).
- Can you use mail merge to create envelopes and labels?
- Can you use mail merge to send email?
- Can you use Find and Replace?
- Do you know how to use find and replace to edit formatting?
Excel
- Can you use basic functions to add, subtract, multiply, divide, take averages, find the minimum and the maximum value in a range of cells?
- Can you use conditional formatting?
- Do you know how to filter a range?
- Do you know the difference between a list and a table?
- Can you use structured referencing in a table?
- Can you make a basic chart?
- Do you know how to insert a trend line?
- Can you format a single chart element (Data point, data series, or even title?)
- Can you create a PivotTable?
- Can you use Sparklines?
- Do you know what a named range is, and can you use it in a formula?
- Can you use nested functions?
- Do you know how to trace errors?
- Can you use a Watch Window?
- Can you rename worksheets?
- Can you import data from other sources into a workbook?
- Can you create 3-D formulas in a single workbook?
- Can you use 3-D formulas from external data sources?
- Can you use text to columns?
- Can you calculate time duration in minutes and hours using Excel formulas?
- Can you use text functions to analyze data?
- Can you set a cell so you can only put certain data in it?
- Can you do a what if analysis?
- Can you use the PMT function?
- Can you use Outlines?
- Can you use Subtotals?
- Can you use SUMIF and SUMIFS?
- Do you know what a syntax prompt is and do you find it useful?
- Can you protect specific cells in a worksheet while leaving other cells available to edit?
- Do you know how to share and merge workbooks?
- Can you create a macro?
- How’s your VB script? (FWIW, I can change happy to glad in the arguments. I’m not really a programmer)
- Can you create custom views?
- Can you use a formula in Conditional Formatting?
- Do you know how to handle page breaks to create well-formatted, printable worksheets?
PowerPoint
- Do you know how to use the standard layouts on slides?
- Can you format a presentation using Master Slides?
- Do you know how to use Themes?
- Do you know how to change the order in which images are layered?
- Can you group a set of images?
- Can you use SmartArt?
- Do you know how to add headers and footers to slides?
- Do you know how to use Themes?
- Do you know how to edit Themes and color schemes?
- Do you know how to create transitions on slides? Do you know WHEN you should or should not do so?
- Do you know how to add sound to a presentation?
- Do you know how to create an auto-advance for slides?
- Do you know how to add animations to a slide?
- Can you create custom animation paths?
- Can you reorder animations?
- Can you use the Presenter View?
- Can you add notes to a presentation for the presenter view’s use?
- Can you add narration and timing to slides?
- Can you use the Notes Master to create printable notes for a presentation?
- Can you create a photo album slide show?
- Can you use the alignment guides for image and text layout?
- Can you create a PowerPoint Presentation from a Word outline?
- Do you know when and where you should NOT use animation?
- Do you know the difference between designing a presentation for a speaker and designing it for online purposes?
- Can you create custom action buttons for an interactive, online presentation?
I think this is a your-workplace thing, primarily. 90% of jobs I’ve applied for have used a phrase such as “proficiency in using MS Office”, and what they really mean is “Can you produce a professional-looking letter, report or notice in under half an hour?”. The ones which have required more depth of skill have almost always specified that – such as a person spec which said “ability to use styles to apply consistent formatting to a composite document consisting of sections authored by multiple colleagues”.
I do think that most of these organisations would benefit from demanding a higher standard of Office proficiency from their employees; I especially think it when I’m filling out another damn .docx form that does not use any actual form elements, or that has form elements but hasn’t got as far as enabling them. But in my experience, most of them would accept basic skills as sufficient to fulfill a generic “proficiency with MS Office” requirement.
If asked, I would have said that I am good on Excel, ok on Word, and so-so on PowerPoint.
Having read your list, it seems I am lousy on Excel, ok on Word, and excellent on PowerPoint.
That feels odd, lol.
But I would not claim to know MS Office on my resume, either way.
I know I can do what *I* need to do, I am quite sure my skills are not at a professional level,lol.
After re-jigging my partner’s (professionally created) resume that used tabs instead of tables… muttergrumble. I am reasonably proficient at Word, good at swearing at Excel and crap at PowerPoint. Before today, I had no idea what a Sparkline was. I have embraced them. They are awesome (one slide instead of five on my damn PowerPoint for the win!).
I can answer about 50% of those questions with a “yes”. And I’m confident that I could teach myself how to do the other 50% with a few sample files to examine. 🙂