Almost everyone with a computer and internet connection is familiar with Microsoft Office. Chances are, you have been using applications like Word and PowerPoint since primary school—but did you know that Microsoft Office has evolved to include a variety of new tools and functions to make our work lives easier?
Most employers expect their staff to have a high level of proficiency across various Microsoft Office applications. Having the knowledge to navigate these tools can not only give your resume a quick boost but also make you more attractive to potential employers. While not every skill needs to be listed in your resume, these in-demand skills are sure to capture a hiring manager’s attention:
Microsoft Excel top skills
Even if you’re a spreadsheet superstar, you can still brush up on the following Excel skills:
- Formulas: Excel formulas serve important functions for virtually any task, project or organisation. Formulas help you calculate the value of certain cells and are used in a variety of ways depending on what your goals are. Understanding the basics of Excel formulas will help you get a grasp on more complex functions and garner much respect from your fellow colleagues.
- Formatting: Formatting cells simply means changing the format of a number (such as (0.8, $0.80, 80%, etc) or changing the alignment, border and font of a value. This is one of the commonly used functions in Excel.
- Reporting: Creating reports in Excel is a common practice in many organisations since data is best featured on a spreadsheet. Many employers expect their staff to have a basic understanding of how to create a report in Excel.
- Pivot tables: A pivot table allows you to reorganise information in a spreadsheet to extract the data you need. This feature is especially useful with large amounts of data and it is used widely across many industries to create reports quickly.
Microsoft Word top skills
- Formatting: Changing font style and size, adding bullet points and headings are all examples of formatting in Word. A definite must-have skill for anyone who works with computers.
- Creating or using templates: Depending on your role, you may be working with custom report templates that are specific to your organisation. Understanding how to work within these templates or creating new ones is a useful skill to master.
- Inserting objects: Inserting images, tables, charts and other objects is a common function for Word and definitely a helpful thing to know.
- Saving as a PDF: You may need to share a word document with colleagues or people who are external to the business, such as customers. With Office 365, it is quick and simple to do, but it is now increasingly common to also share final documents in a PDF format. It’s therefore important to learn how to do this, so you can share professional looking, non-editable files.
Microsoft PowerPoint top skills
- Basic design principles: Great design is essential for powerful presentations. PowerPoint comes with pre-made templates, though many organisations use their own custom designs to create branded assets. Learning the fundamentals of design can help you create beautiful, functional PowerPoint slides that deliver your message effectively.
- Creating tables, charts and diagrams: Being able to successfully pull data and display it visually in PowerPoint is an essential skill in creating presentations. If you’re applying for a role where you’ll be responsible for presenting data, this is definitely a skill to brush up on and add to your resume.
- Using animation, sound and other features: Using these PowerPoint features appropriately can improve the quality of your presentations and help you stand out.
Microsoft Outlook top skills
Email might seem straight forward enough, but did you know there are many features of Outlook that you can utilise to improve email and task management in the workplace? While you may not need to add these to your resume, they are still highly beneficial to learn. Here are a few skills to consider:
- Organising emails: Using folders and creating filing systems can help you locate and access your emails more efficiently. If you receive many emails a day, an organised inbox is essential and can save you a lot of time.
- Filtering: Filtering is the process of sending all mail from a specific address to a certain folder and can make email management much easier.
- Sharing schedules: Email is a collaborative endeavour, so it is imperative to know how to share your schedules with your team.
- Managing calendars: Outlook is your home for appointments, meetings and to-dos. Understanding how to use your calendar to manage tasks is an essential skill in today’s workplace.
Fill knowledge gaps with Office 365 resources from our Learning Library
If you need to brush up on any of these skills, we have a range of Microsoft Office 365 courses and resources available on our Office 365 Learning Library. Our Office 365 library includes learning assets in Excel, Word, PowerPoint, Outlook and more, to help you stay on top of the latest skills needed to succeed in today’s modern workplace. The Office 365 Library is suitable for both beginners and advanced users of Microsoft Office.