Microsoft Office Articles | Avantix Learning

View related training courses >

How to Use Flash Fill in Excel (4 Ways with Shortcuts)

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)

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 (£)

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)

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)

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)

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.

How to Reorder Objects in PowerPoint Using Bring to Front or Send to Back (with 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.

Use Excel Conditional Formatting to Highlight Dates Before Today (3 Ways)

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)

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 Stop Word from Changing Formatting Automatically

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)

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 Hide and Unhide Slides in PowerPoint (with 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.

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