Microsoft Office Articles | Avantix Learning
How to Use Flash Fill in Excel (4 Ways with Shortcuts)
You can use Flash Fill in Excel to extract, combine, clean or format data quickly without using formulas. In order to use Flash Fill, Excel must be able to understand a pattern in a column to the left of the column where you want to fill the data so the source data should be entered in a consistent way. You can use Flash Fill by clicking a button, using shortcuts or by using the Fill handle. You run Flash Fill by entering an example of the data you want to fill using a "by example" logic.
How to Hide or Unhide Excel Worksheets (and Unhide All Sheets)
You can hide or unhide Excel worksheets using the Ribbon, the right-click menu or keyboard shortcuts. If you hide worksheets, you can still reference them in other worksheets or workbooks. If you have Excel 365, you can now quickly unhide multiple worksheets or all worksheets. If you have trouble hiding or unhiding a worksheet, protection may have been enabled or a user has used VBA (Visual Basic for Applications) to hide the sheet.
4 Ways to Insert or Type the Pound Symbol in Word (£)
You can insert the pound sign or symbol (£) in a Word document using built-in Word commands or keyboard shortcuts (including Alt code, AutoCorrect or built-in shortcuts). This article applies to the British currency symbol, not the pound sign (#) or hash tag.
How to Convert Text to Numbers in Excel (5 Ways)
There are several ways to convert text to numbers in Microsoft Excel. When data is downloaded from other programs, numbers may sometimes be stored as text and you can't perform calculations correctly on the values. Also, some users may enter a number as text by typing an apostrophe (') before the number. Numbers stored as text usually appear with a green error checking marker in the cell. You can't sum or perform many other types of calculations with text.
How to Insert or Type Greek Letters or Symbols in Excel (6 Ways)
You can insert or type Greek letters or symbols (such as Alpha, Beta, Delta, Gamma, Omega, Pi, Sigma or Theta) in Excel worksheets in several ways. These include inserting symbols using the Insert Symbol command, the Symbol font, Alt code shortcuts and AutoCorrect shortcuts. You can insert Greek letters in cells, text boxes and equations in Excel.
How to Insert Multiple Rows in Excel (4 Fast Ways with Shortcuts)
You can quickly insert multiple rows in Excel using a drop-down menu, keyboard shortcuts or the Home tab in the Ribbon. The key to inserting multiple rows at once, rather than one by one, is to select the number of rows you want to insert first and then insert rows. Excel will insert the same number of rows you selected.
4 Ways to Insert or Type the Euro Symbol in Word (€)
You can insert the euro symbol or sign (€) in a Word document using built-in Word commands or keyboard shortcuts (including Alt code, AutoCorrect or built-in shortcuts).
How to Reorder Objects in PowerPoint Using Bring to Front or Send to Back (with Shortcuts)
You can reorder objects on a PowerPoint slide using keyboard shortcuts, the context menu, the Ribbon or the Selection Pane. When objects are placed on a slide, they are stacked on top of each other. It's common to reorder objects to change the stacking order. When you select an object and Send to Back, it's moved to the bottom of the stack. If you choose to Send Backward, it's moved back by object. When you select an object and Bring to Front, it's moved to the top of the stack. If you choose to Bring Forward, it's moved forward by object.
How to Use Kerning in Microsoft Word to Adjust Letter Spacing
Kerning can be used in Microsoft Word to increase or decrease the spacing between characters. You have the option of turning on automatic kerning or you can manually control kerning by expanding or condensing spacing.
How to Insert or Type the Division Symbol in Word (5 Ways to Insert ÷ with Shortcuts)
You can insert the division symbol in a Word document using Insert Symbol, a keyboard shortcut, an AutoCorrect entry or an Alt shortcut. The division sign or symbol is different from the division operator used in calculations in a Word table or in Excel (/).
Use Excel Conditional Formatting to Highlight Dates Before Today (3 Ways)
You can use conditional formatting in Excel to highlight cells containing dates before today or within a date range before the current date. In a worksheet, you can use conditional formatting to highlight selected cells by filling them with a color based on rules or conditions. This type of formatting is helpful if you want to highlight past due dates such as invoices that are 30, 60 or 90 days overdue.
How to Crop a Picture into a Circle in PowerPoint (Crop Image to Shape)
If you want to crop an image into a circle in PowerPoint, you'll need to combine cropping options. Crop options appear on the Picture Format or Picture Tools Format tab in the Ribbon. You can use these tools to crop a picture into an oval and then crop again to change the aspect ratio so the oval changes to a circle. In PowerPoint, you can achieve some great effects by cropping images to different shapes.
How to Insert the Mu or Micro Symbol in Word (µ)
How to Insert or Type the Delta Symbol in Word (Δ)
How to Copy Formatting in Word (3 Easy Ways with Shortcuts)
You can insert the square root or radical symbol (√) in a Word document using built-in Word commands or keyboard shortcuts.
How to Cut a Shape Out of an Image in PowerPoint (Mask a Picture)
Starting in Microsoft PowerPoint 2013, you can use the Merge Shapes tool to crop an image to a circle. You can use either Intersect or Subtract to cut out a circle (or other shape) from a picture.
How to Replace Spaces in Excel with Underscores (_), Dashes (-) or Other Values
You can quickly replace blank cells in Excel with zeros, dashes or other number or text values (0, -, N/A, Null or other text). It's useful to fill blank cells with a number, symbol or value if you want to use the data set as the source for a pivot table or use other data analysis tools.
5 PowerPoint Keyboard Shortcuts to Start a Slide Show
The outline has been an integral part of Microsoft PowerPoint for many years. It is dynamically linked to slide placeholders and is organized in a hierarchical way.
How to Stop Word from Changing Formatting Automatically
You can stop Word from changing formatting automatically in your documents by turning off AutoFormat As You Type settings in the AutoCorrect dialog box. If text or formatting is changing, there are several options you can turn off.
How to Find and Replace in Word (and Use Wildcards)
You can find and replace in Word using the Find and Replace dialog box as well as the Navigation Pane. If you use the dialog box, you can find and replace text and numbers and use wildcards for more advanced find and replace tasks. Wildcards are useful when you are not able to find an exact match. You can display the Find and Replace dialog box using a keyboard shortcut or the Home tab in the Ribbon.
How to Insert or Type the Sigma Symbol in Word (6 Ways to Insert Σ or σ)
You can insert or type the Sigma symbol in Word documents in several ways. The Greek Sigma symbol can be entered in upper case (Σ) or lower case (σ) using built-in commands or keyboard shortcuts.
How to Hide and Unhide Slides in PowerPoint (with Shortcuts)
You can hide slides in PowerPoint presentations so that they do not appear during a slide show unless you want to display them. Typically, you hide slides in Normal View or Slide Sorter View and then run your slide show. During a slide show, you can unhide slides or you can return to Normal View or Slide Sorter View and unhide them.
10 Keyboard Shortcuts in PowerPoint's Outline View
The outline has been an integral part of Microsoft PowerPoint for many years. It is dynamically linked to slide placeholders and is organized in a hierarchical way.
5 Ways to Insert or Type the Degree Symbol in PowerPoint (°)
You can insert or type the degree symbol in PowerPoint presentations using built-in commands or keyboard shortcuts. The degree sign can be entered in placeholders, text boxes or in equation blocks on PowerPoint slides.
How to Change the Font on All Slides in PowerPoint (3 Ways)
You can insert or type the degree symbol in PowerPoint presentations using built-in commands or keyboard shortcuts. The degree sign can be entered in placeholders, text boxes or in equation blocks on PowerPoint slides.
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