Microsoft Office Articles | Avantix Learning
How to Align Objects in PowerPoint (4 Ways)
You can align objects on your PowerPoint slides in several ways. Objects you align may be shapes, images, placeholders or text boxes. The most common way to align objects is to use the Align command which appears on multiple tabs in the Ribbon.
How to Break, Update or Change Links to Excel Charts or Worksheets in Microsoft Word
If you want to break, update or change links to Excel charts or worksheets in Microsoft Word, you'll need to use the Edit Links to Files command. Unfortunately, this command is difficult to find. To make it easier to access, you can add Edit Links to Files to the Quick Access Toolbar.
Microsoft Teams Keyboard Shortcuts (40+ Shortcuts)
If you're a Microsoft Teams user, you can save alot of time using your keyboard to access Teams commands. Check out this essential list of keyboard shortcuts for Microsoft Teams for Windows users (Desktop).
How to Format Microsoft Word Tables Using Table Styles (Ultimate Guide)
You can apply table styles to your Word tables to format them quickly and consistently. Use Word's built-in table styles or create your own. You can modify table styles by changing borders, shading and other formats and change all the tables in your docment.
How to Remove the Background from a Picture in PowerPoint (2 Ways)
You can remove the background from a picture in PowerPoint and keep a specific part or parts of the image. The background you remove can be a solid color or it can include different colors and other images. There are two common strategies for removing the background from a picture in PowerPoint – use the Remove Background tool or set the background color of the picture to a transparent color.
How to Convert Seconds to Minutes and Seconds in Excel
You can convert seconds to minutes and seconds in Excel by combining calculations and custom number formatting …
How to Space Objects an Equal Distance Apart in PowerPoint
You can space objects an equal distance apart in a couple of ways in PowerPoint. These objects may be shapes, images, placeholders or text boxes. If the objects are not consistent in size, it's problematic to try to space them evenly apart.
How to Change Slide Background in PowerPoint
In PowerPoint, you can change the background of individual slides, selected slides based on a layout, or all slides based on a slide master. Slide backgrounds can be changed to a color, pattern, gradient, texture or picture. In this article, we'll review applying color, gradient and picture backgrounds.
How to Extract All Pictures from a Microsoft Word Document (or Just One or Two)
In Microsoft Word, images can be extracted one by one or you can extract all images by converting a Word document to a zip file or saving it as a web page. Extracting all images is helpful if you'd like to find pictures that are inflated in size.
How to Hyperlink in PowerPoint (Insert, Remove or Edit Links)
You can easily add links or hyperlinks in PowerPoint presentations to add interactivity and make it easy for users to click a button or link to jump to another slide in your deck, to another presentation, to an Excel file or to a web site.
How to Remove Blanks in a Pivot Table in Excel (6 Ways)
To remove blanks in pivot tables, you can set pivot table options to display data in empty cells, filter to remove blanks, apply conditional formatting, find and replace blanks or change pivot table design settings …
How to Crop a Picture in PowerPoint (4 Ways)
In PowerPoint, you can crop a picture in several different ways. You can apply basic cropping, crop to a shape such as an oval or triangle, crop to aspect ratio or crop to a precise size. After you have applied cropping, you can change the cropped area, adjust the position of the picture and / or resize the picture.
How to Update Fields in Microsoft Word (One or All Fields)
You can update Microsoft Word fields manually or automatically. For fields you update manually, you can update just one field or update all the fields in your document at once.
How to Create a Table of Contents in Word
You can create a table of contents quickly in Word using built-in heading styles. Although you can insert a table of contents (TOC) using different strategies in Word documents, it's easiest to use Heading 1, Heading 2 and so on to format headings and then generate your table of contents. You can then change the formatting and update the TOC when your document changes.
How to Insert Nonbreaking Spaces and Nonbreaking Dashes in PowerPoint
You can insert nonbreaking spaces and nonbreaking dashes or hyphens in PowerPoint to keep characters together on one line …
How to Insert Fields in Microsoft Word (Built-in or Custom)
You can insert built-in or custom fields in Word documents to display variable content that will change when you update the fields. If you want to insert custom fields, you will need to create custom document properties …
How to Quickly Remove All Page Breaks in Word
You can quickly remove all page breaks in a Microsoft Word file using Find and Replace. The following method will delete all manual page breaks created using the Breaks command or by pressing Ctrl + Enter …
How to Blur an Image in PowerPoint
You can achieve some interesting effects in your PowerPoint presentations by applying a blur effect to a picture. Blur is an artistic effect and you can increase the blur using the Format Picture task pane or dialog box …
How to Add Page Numbers in Word
You can add page numbers in Word documents at the top or bottom of pages in headers or footers. Numbers in headers and footers should be inserted as fields so that they will automatically update as the document is edited. In this article, we'll review numbering in simple and more complex Word documents.
How to Crop an Image into a Circle in PowerPoint Using Merge Shapes
Starting in Microsoft PowerPoint 2013, you can use the Merge Shapes tool to crop an image into a circle. You can use Intersect in Merge Shapes to cut out a circle (or other shape) from a picture. If you have a version of PowerPoint prior to 2013, you'll need to use a different method (such as crop to shape) to cut a circle out of a picture.
7 Timesaving Microsoft Excel Shortcuts for Selecting in Tables
There are many different shortcuts for selecting elements in Microsoft Excel tables. You can use shortcuts to select an entire table, an entire row, an entire column or ranges in tables.
4 Strikethrough Shortcuts in Microsoft Word to Cross Out Text
You can apply strikethrough to text in Word to create a line through text. Although you can cross out text using Strikethrough on the Home tab in the Ribbon or the Font dialog box, you can also write your own Strikethrough keyboard shortcut in Microsoft Word.
How to Get Slide Design Ideas Using PowerPoint Designer
If you are a Microsoft 365 subscriber, you can use PowerPoint Designer to get design ideas for slides. Designer takes advantage of Microsoft's Intelligent Services for suggesting layouts for images. It can also help with the design for slides containing other types of content.
How to Increase or Decrease Decimal Places in Microsoft Excel Using Keyboard Shortcuts
You can use keyboard shortcuts to increase or decrease decimal places. Press Alt to access the Ribbon …
To request this page in an alternate format, email our staff at info@avantixlearning.ca
Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.
Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | info@avantixlearning.ca