Avantix Learning Blog

Recent Articles

View related training courses >

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.

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 …

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 …

11 Strategies for Effective Remote Teams

11 Strategies for Effective Remote Teams

Remote workers and teams are growing at an exponential rate with the advent of new technology and, recently, because of social distancing. Check out these strategies to keep these teams focused, productive and motivated.

How to Be a Productive Remote Worker (10 Tips for Working Successfully from Home)

How to Be a Productive Remote Worker (10 Tips for Working Successfully from Home)

With the increase in cases of COVID-19 or Coronavirus as well as the drastic increase in digital technologies and new types of jobs, the number of people working remotely is rising significantly. Because of this change in the way many people are working, we’ve compiled a list of 10 tips on how to be a productive remote worker for both veterans and newbies.

10 Popular New Year’s Resolutions (and Tips on How to Keep Them)

10 Popular New Year’s Resolutions (and Tips on How to Keep Them)

The new year prompts many people to set New Year’s resolutions to help make positive changes in their personal and professional lives. However, keeping those resolutions is not so simple. The following are 10 popular resolutions that show up year after year on many lists …

How to Insert a Line in Microsoft Word (The Better Way)

How to Insert a Line in Microsoft Word (The Better Way)

You can insert lines in Microsoft Word by drawing lines or by using borders (normally paragraph borders). However, if you draw lines using Insert Shapes, you’ll have to worry about the line being inline or floating. In this article, we’ll insert and remove lines using borders which are attached to paragraphs so they move as you edit the document.

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 …

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 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 …

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