Avantix Learning Blog

Recent Articles

View related training courses >

How to Change Commas to Decimal Points and Vice Versa in Excel (5 Ways)

How to Change Commas to Decimal Points and Vice Versa in Excel (5 Ways)

Depending on your country or region, Excel may display decimal points or dots instead of commas for larger numbers. The decimal point (.) or comma (,) is used as the group separator in different regions in the world. You can change commas to decimal points or dots or vice versa in your Excel workbook temporarily or permanently.

How to Group by Month and Year in a Pivot Table in Excel

How to Group by Month and Year in a Pivot Table in Excel

You can group by month, year or other date period in a pivot table in Excel. One option is to group by date periods in a pivot table using the Grouping feature. Alternatively, you can also create calculations in source data to extract the month name and the year from a date field and use the fields in your pivot table.

How to Highlight Text in PowerPoint [5 Ways]

How to Highlight Text in PowerPoint [5 Ways]

You can highlight text in PowerPoint in many different ways. If you’re an Office 365 subscriber, Text Highlight Color is available on the Home tab in the Ribbon. For everyone else, you’ll need to use other strategies if you want to highlight text …

10 More Excel Pivot Table Shortcuts

10 More Excel Pivot Table Shortcuts

Since pivot tables are one of the most powerful tools in Microsoft Excel for summarizing data, we’ve compiled a list of 10 more keyboard shortcuts for pivot table users.

10 Great Excel Pivot Table Shortcuts

10 Great Excel Pivot Table Shortcuts

Check out these 10 great Excel pivot table keyboard shortcuts. You can use standard shortcuts using the Control key or use Alt to access the Ribbon and create pivot tables in different ways.

How to Turn Off Automatic Text Resizing in PowerPoint

How to Turn Off Automatic Text Resizing in PowerPoint

PowerPoint’s Autofit feature is set to automatically resize text in text boxes or placeholders. To stop this, you can turn off Autofit settings for all PowerPoint presentations on your computer or for a specific text box or placeholder.

How to Reduce PowerPoint File Size (10 Ways to Compress Your PowerPoint Decks)

How to Reduce PowerPoint File Size (10 Ways to Compress Your PowerPoint Decks)

You can reduce the size of your PowerPoint files in several ways. The most common strategy to reduce PowerPoint presentation size is to compress pictures as well as video and audio files. However, you can also use other methods to make large files smaller including saving media and PowerPoint files in other formats and converting or removing embedded objects.

How to Export PowerPoint Speaker Notes to Microsoft Word

How to Export PowerPoint Speaker Notes to Microsoft Word

During a Microsoft PowerPoint training course, students often ask how to send speaker notes from a PowerPoint presentation to a Word document. The best option is to send the notes to Word with the notes next to the slides. After you’ve exported to Word, a table will be created with 3 columns – slide number, slide images and notes on the right.

How to Convert a Microsoft Access Report to PDF [3 Ways]

How to Convert a Microsoft Access Report to PDF [3 Ways]

If you have Microsoft Access 2010 or a later version, you can easily convert your Access reports to PDF without using Adobe Acrobat Pro. Use the File tab or the External Data tab on the Ribbon or you can customize the Quick Access Toolbar.

How to Freeze Row and Column Headings in Microsoft Excel

How to Freeze Row and Column Headings in Microsoft Excel

As many Excel worksheets can become quite large, it can be useful to freeze row and column headings so that they are locked in place when you scroll through your worksheet. In Excel, you can freeze both row headings and column headings or just one.

How to Enter Data in an Excel Filtered List into Visible Cells [2 Ways]

How to Enter Data in an Excel Filtered List into Visible Cells [2 Ways]

It’s a common issue for Microsoft Excel users to attempt to use AutoFill to fill data in a filtered list and it doesn’t work as expected. The fill data is entered into all cells, including the hidden or invisible cells. The solution is to enter data into visible cells only …

10 Excel Tips for Working with the Subtotal Feature

10 Excel Tips for Working with the Subtotal Feature

You can insert subtotals in Microsoft Excel data sets or lists using the Subtotal feature. Check out these 10 great tips which include showing and hiding subtotals, formatting subtotals, copying only subtotals and grand totals and more …

5 Awesome Excel Chart Shortcuts

5 Awesome Excel Chart Shortcuts

If you create a lot of charts in Excel, you’re probably looking for shortcuts to speed up creation and formatting. Here are 5 useful shortcuts you can use with your Excel charts.

10 More Excel Pivot Table Shortcuts

10 More Excel Pivot Table Shortcuts

Since pivot tables are one of the most powerful tools in Microsoft Excel for summarizing data, we’ve compiled a list of 10 more keyboard shortcuts for pivot table users.

8 Excel Tips for Entering Formulas

8 Excel Tips for Entering Formulas

Check out these 8 Excel tips and tricks for entering formulas. You’ll save a lot of time and even help reduce errors in your formulas.

How to Align Objects on PowerPoint Slides

How to Align Objects on PowerPoint Slides

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 Space Objects an Equal Distance Apart in PowerPoint

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 the Background of Your PowerPoint Slides

How to Change the Background of Your PowerPoint Slides

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, gradient, texture or picture.

How to Crop a Picture in PowerPoint (4 Ways)

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 Blur a Picture in PowerPoint

How to Blur a Picture 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 Update Fields in Microsoft Word

How to Update Fields in Microsoft Word

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 Convert a Microsoft Access Report to PDF [3 Ways]

How to Convert a Microsoft Access Report to PDF [3 Ways]

If you have Microsoft Access 2010 or a later version, you can easily convert your Access reports to PDF without using Adobe Acrobat Pro. Use the File tab or the External Data tab on the Ribbon or you can customize the Quick Access Toolbar.

10 Timesaving Shortcuts in Microsoft Access

10 Timesaving Shortcuts in Microsoft Access

Save time in Microsoft Access using these great keyboard shortcuts. We’re assuming you’re already using standard shortcuts like Ctrll + P to print, Ctrl + S to save and Ctrl + C to copy.

Microsoft Visio Articles

View related training courses >

No Results Found

The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.

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