Microsoft Office Articles | Avantix Learning

View related training courses >

How to Convert Cm to Inches in Excel (or Inches to Cm)

How to Convert Cm to Inches in Excel (or Inches to Cm)

You can convert cm to inches (or inches to cm) using formulas with operators or functions in Excel. This is useful since the regional settings on a computer affect the default measurement system used in Excel and other programs.

How to Insert Today's Date in Word (with Shortcut)

How to Insert Today's Date in Word (with Shortcut)

You can insert today's date into a Word document as a static date or as a dynamic date field that updates when a document is opened or printed. Word picks up the current date from the system date and the default formatting from your computer's regional settings.

How to Hide Comments or Notes in Excel Workbooks

How to Hide Comments or Notes in Excel Workbooks

You can hide comments and notes in Excel workbooks. In addition to adding comments in Excel, there is a little known function called the N function that you can use to enter notes directly within a formula. The N function has been around for a long time so you can use it in older versions of Excel.

How to Hide Comments in Word (or Display Them)

How to Hide Comments in Word (or Display Them)

You can show and hide comments using the Review tab in the Ribbon in Microsoft Word. If you add comments in a Word document, they will appear in a markup area on the right side of pages by default. If you want to show or hide comments, you'll need to control the display of markup.

How to Create a Hanging Indent in Word (4 Ways)

How to Create a Hanging Indent in Word (4 Ways)

You can create a hanging indent in Microsoft Word using the Ruler, the Paragraph dialog box or a keyboard shortcut. A hanging indent is created when the first line of a paragraph is at a location to the left of the subsequent lines in the paragraph. The term is often used to refer to a first line indent. Either way, the first line of a paragraph is indented or outdented. A hanging indent is typically used for bullets and numbering or to cite a reference. The bullets and numbering tools automatically apply a hanging indent.

How to Superscript or Subscript in Word (with Shortcuts)

How to Superscript or Subscript in Word (with Shortcuts)

You can apply superscript or subscript in Microsoft Word using keyboard shortcuts, commands in the Ribbon or the Font dialog box. If you apply superscript, the selected letter, number or symbol will be raised slightly above the line of text and sized to a smaller size. If you apply subscript, the selection will be lowered slightly below the line of text and sized to a smaller size. It's common to use superscript or subscript for symbols such as trademark or copyright symbols, mathematical equations, chemical formulas, and footnote characters or numbers. Certain features in Word, such as footnotes, automatically create superscripted characters.

How to Embed a YouTube Video in PowerPoint

How to Embed a YouTube Video in PowerPoint

You can embed or insert a YouTube video in PowerPoint and play it during a slide show. Essentially, you are linking to the YouTube video but it will play seamlessly in PowerPoint. In order to play a YouTube video in a presentation, you will need to copy the URL or embed code first from YouTube and then paste it into PowerPoint. Because you are connecting to YouTube using this method, you will also need a reliable internet connection to play the video.

How to Move a Pivot Table in Excel

How to Move a Pivot Table in Excel

Moving a pivot table is not as simple as moving other objects in an Excel worksheet or workbook. You will typically need to use the Move PivotTable command in the Ribbon to move a pivot table to a different area on a worksheet or to a different sheet in the same workbook.

How to Compress Images in Word to Reduce File Size

How to Compress Images in Word to Reduce File Size

You can compress images in several ways in Microsoft Word documents to reduce the size of the file. There are built-in Word compression features you can use to make large files smaller but you can also reduce image size before you insert pictures into your documents.

How to Insert a Video in PowerPoint (from a File on Your PC or Shared Drive)

How to Insert a Video in PowerPoint (from a File on Your PC or Shared Drive)

You can insert a video into a PowerPoint  presentation from a file on your PC or from a shared drive. Video can help to engage your audience and focus attention. In newer versions of PowerPoint, video files are embedded or copied into PowerPoint by default so video files can increase file size significantly.

How to Stop Words from Splitting at the End of a Line in Microsoft Word

How to Stop Words from Splitting at the End of a Line in Microsoft Word

There are many ways to stop words from splitting across lines in Word. You can keep words or characters (numbers or letters) together in Microsoft Word using nonbreaking spaces or hyphens. If Word is inserting hyphens in a word you don't want to break across lines, you can also turn off automatic hyphenation.

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

Pin It on Pinterest