Avantix Learning Blog

Recent Articles

View related training courses >

Productivity Articles

View related training courses >

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 from Home)

How to Be a Productive Remote Worker (10 Tips for Working 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 …

No Results Found

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

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 Strikethrough or Cross Out Text in PowerPoint (4 Ways)

How to Strikethrough or Cross Out Text in PowerPoint (4 Ways)

You can apply strikethrough to cross out or create a line through text using PowerPoint commands or keyboard shortcuts. Strikethrough can be effective to show that something has been removed or deleted. You can even add a Strikethrough button to the Quick Access Toolbar.

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 Format Microsoft Word Tables Using Table Styles

How to Format Microsoft Word Tables Using Table Styles

You can apply table styles to your Word tables to format them quickly and consistently. Use Word’s built-in table styles or create your own. You can modify table styles by changing borders, shading and other formats and change all the tables in your docment.

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