Office 365 training
Here you will find some resources to help you use Microsoft Office 365 applications.
To access your College Office 365 account, go to Office.com and log in with your College email address and password.
Microsoft Word
Getting to know Word for the web URL
- Creating a new page
- Using menus
- Getting more help
- Sharing a document
- Using Save as to save a copy of your document.
- An illustrated step-by-step guide to making your documents accessible to people with different physical and cognitive abilities.
Layout
- Changing margins
- Portrait & landscape orientation
- Line spacing
- Changing margins
Formatting text
An illustrated step-by-step guide.
An illustrated step-by-step guide.
An illustrated step-by-step guide.
An illustrated step-by-step guide.
Tables & pictures
- Adding small & large tables
- Adding pictures from your computer or the web
Collaboration & authoring
- Sharing a document
- Editing it with colleagues
- Adding comments
- Notifying colleagues
Further learning
- Microsoft Word for the web lets you make basic edits and formatting changes to your document in a web browser. For more advanced features, use Word for the web’s Open in Word command.
- Explanation of the differences between the desktop and browser-based versions of Word.
- How Word can refine your writing
- Using voice dictation
- Accessibility:
- Word can read documents to you out loud
- Improving readability with reformatting
- How to setup & use dictation.
- How to fix mistakes.
Dictation commands Page
A list of commands you can use with dictation for Word for the web to help format your documents.
YouTube video. Click on the Moodle page link to see timestamps for each tip.
Excel
- Starting a new document, or opening a document
- Using menus
- Sharing a spreadsheet
Formulas
- Basic functions
- Repeating formulas
- Use SUM when you want to find a total.
- IF allows you to make comparisons between a value and what you expect.
- For those who wish to find out more about using formulas in Excel.
Tables
Using Flash Fill
Sort your table by one or more columns, by ascending or descending order, or do a custom sort.
- Add visual cues, like different colours, that help you spot highs and lows or other trends.
Charts
- Create a chart
- Add a trend line
If you need to change data in a chart, you can do it from its source.
Sharing & authoring
Protect a workbook with a password.
Power Point
- Creating new slides
- Using Themes
- Changing layout
Adding content
- Adding content from your computer or the web.
- Editing pictures
- Using Design Ideas
- Adding & using Shapes and Icons
- Adding hyperlinks
- Adding videos from the web
- Step-by-step text instructions.
- Adding existing audio
- Recording audio
- Trimming & fading your audio
- Choosing when your audio plays
- Step-by-step illustrated instructions.
Animations
Add, change, or remove transitions between slides.
- Effects can make text or an object appear, disappear, or move.
- They can change an object's size or colour.
- Allows you to animate smooth movement from one slide to the next (but not with charts!)
Sharing & authoring
How to add, delete and edit comments on a Power Point presentation.
An illustrated step-by-step guide.
Further learning
- Ways in which Power Point for the web differs from the desktop app.
Lots of examples of how people have used Power Point animation features to create wonderful effects and engaging content.
OneDrive
An illustrated step-by-step document.