Avantix Learning Blog

Recent Articles

View related training courses >

How to Insert Video in PowerPoint

How to Insert Video in PowerPoint

You can insert a video into a PowerPoint  presentation from a file on your PC or from a shared server. In 2010 and later versions, video files are embedded or copied into PowerPoint by default so video files can increase file size significantly.

How to Insert, Format and Update Cross-References in Word

How to Insert, Format and Update Cross-References in Word

In Microsoft Word, you can insert a cross-reference to content in another part of your Word document and then update it if the target of the cross-reference changes. A cross-reference can refer to a heading, bookmark, the caption of a table or figure as well as other target items.

Productivity Articles

View related training courses >

Microsoft Teams Keyboard Shortcuts (40+ Shortcuts)

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).

20 Tips for Working from Home (for Newbies)

20 Tips for Working from Home (for Newbies)

As people around the world adjust to working and living in the unprecedented era of Coronavirus (COVID-19), a new group of workers are transitioning to working from home. Unlike remote workers who have chosen to work from home, this new group of remote workers have moved from a traditional office to a new work environment with little to no preparation …

How to Add Slide Numbers in PowerPoint | The Complete Guide

How to Add Slide Numbers in PowerPoint | The Complete Guide

You can add slide numbers in PowerPoint to some or all of your slides using slide layouts. If your slide layouts contain slide number placeholders, you can then apply those layouts to your slides and insert slide numbers in the placeholders.

Excel Flash Fill Tricks to Extract or Clean Data (10 Examples)

Excel Flash Fill Tricks to Extract or Clean Data (10 Examples)

Flash Fill is a great tool that you can use to quickly clean or format data in your Excel workbooks. It can automatically extract, combine and format data without using a formula. It does seem like magic. Here are 10 examples where we’ve used Flash Fill to clean up data.

PowerPoint Slide Show Shortcuts (20+ Keyboard Shortcuts)

PowerPoint Slide Show Shortcuts (20+ Keyboard Shortcuts)

You can use PowerPoint keyboard shortcuts when you are running a slide show to quickly move around in your PowerPoint presentation. Using your keyboard, you can move from slide to slide, jump to a specific slide or even change the screen to black or white.

10 Great Excel Navigation Shortcuts to Move Around in Workbooks

10 Great Excel Navigation Shortcuts to Move Around in Workbooks

In Microsoft Excel, you can save lots of time if you can move around quickly in your worksheets and workbooks. You can use keyboard shortcuts to jump to the beginning or end of your worksheet and move up or down by ranges of data. In this article, we’ve put together a great list of navigation shortcuts to help you be more productive with Excel. 

How to Delete a Pivot Table in Excel

How to Delete a Pivot Table in Excel

A pivot table can be deleted in an Excel workbook in several ways. You can delete a pivot table, convert a pivot table to values or clear data and customizations from a pivot table to reset it. When a pivot table is created from source data in a workbook,

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 Remove Blanks in a Pivot Table in Excel (6 Ways)

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 Insert Video in PowerPoint

How to Insert Video in PowerPoint

You can insert a video into a PowerPoint  presentation from a file on your PC or from a shared server. In 2010 and later versions, video files are embedded or copied into PowerPoint by default so video files can increase file size significantly.

How to Convert PowerPoint to Google Slides (5 Ways)

How to Convert PowerPoint to Google Slides (5 Ways)

You can import or convert a PowerPoint presentation in PPTX format to Google Slides format in several ways. Google Slides will try to convert a PowerPoint presentation to compatible objects, tools and fonts but these programs do have differences so don’t expect a perfect conversion.

Change Line Style, Thickness or Color of Table or Cell Borders in PowerPoint

Change Line Style, Thickness or Color of Table or Cell Borders in PowerPoint

You can change the formatting of a table border or the borders of multiple table cells in PowerPoint by changing the line style, thickness (weight) or color. Different borders can be applied to cells in the same table. For example, you could apply a thick line to header cells and a thin line to the cells in the last row of a table.

How to Rotate Objects in PowerPoint (4 Ways)

How to Rotate Objects in PowerPoint (4 Ways)

You can rotate objects in PowerPoint by dragging the rotation handle, entering an exact rotation amount or by using keyboard shortcuts. To rotate an object means to turn it around its center. Shapes, images and other objects can be rotated in Normal View or Slide Master View.

How to Compress Images in PowerPoint to Reduce File Size

How to Compress Images in PowerPoint to Reduce File Size

There are many strategies you can use to compress images in PowerPoint presentations to reduce file size. It’s common to use built-in compression features in PowerPoint to make large files smaller but you can also reduce image size before you insert pictures on your slides.

How to Blur Text on a PowerPoint Slide

How to Blur Text on a PowerPoint Slide

Blur is an artistic effect that you can apply to a picture in PowerPoint. However, artistic effects cannot be applied to text boxes or text placeholders. If you want to blur text in PowerPoint, you’ll need to cut the text object and then paste it back into PowerPoint as a picture. You will then be able to blur the text.

How to Use Emphasis Animation to Highlight Text in PowerPoint

How to Use Emphasis Animation to Highlight Text in PowerPoint

If you want to focus attention on a key point on a PowerPoint slide, you may want to highlight text. One way to do this is to use emphasis animation effects. You can use this type of animation to change the color of text, apply a fill to the shape containing the text or even have the text grow or shrink.

How to Insert, Format and Update Cross-References in Word

How to Insert, Format and Update Cross-References in Word

In Microsoft Word, you can insert a cross-reference to content in another part of your Word document and then update it if the target of the cross-reference changes. A cross-reference can refer to a heading, bookmark, the caption of a table or figure as well as other target items.

How to Create, Save, Use and Edit Templates in Microsoft Word

How to Create, Save, Use and Edit Templates in Microsoft Word

You can create, save, use and edit templates in Microsoft Word for frequently-used documents such as letters, reports, proposals and manuals. Templates include basic character, paragraph and page formatting and may include text, custom styles, tables, images, macros, sections, headers and footers.

How to Easily Export Microsoft Access Data to Excel

How to Easily Export Microsoft Access Data to Excel

Microsoft Access includes an export wizard that can be used to export tables, queries, forms or reports easily to Excel. It’s common to have many users in an organization using Excel so data in Excel format can work well.

Auto vs Manual Scheduling in Microsoft Project

Auto vs Manual Scheduling in Microsoft Project

In newer versions of Microsoft Project, you have the option of scheduling tasks using manual or auto scheduling. In earlier versions, Microsoft Project used auto scheduling which takes advantage of Project’s scheduling engine to schedule tasks.

How to Create a Timeline in Microsoft Project

How to Create a Timeline in Microsoft Project

Timelines are a great way to view key tasks and milestones in a project. You can add tasks to a timeline and then format it any way you’d like. Copy a timeline into an email or Word or PowerPoint file to present the timeline.

Microsoft Visio Articles

View related training courses >

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