Avantix Learning Blog

Trending

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

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.

How to Delete Blank Rows in Excel (5 Ways)

How to Delete Blank Rows in Excel (5 Ways)

You can delete blank rows in Microsoft Excel worksheets manually or you can use several tricks to remove multiple blank rows quickly. Check out 5 different ways to easily delete blank rows in your data.

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

How to Fill Blank Cells in Excel with a Value from a Cell Above

How to Fill Blank Cells in Excel with a Value from a Cell Above

You can fill blank cells in Excel with a value from a cell above using a few great Excel tricks. The data may have been imported from an external source or formatted this way by a client or colleague for readability but the blank cells are a problem if you want to sort, filter or summarize the data.

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.

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 Convert Cm to Inches in Excel (or Inches to Cm)

How to Convert Cm to Inches in Excel (or Inches to Cm)

You can convert cm to inches (or inches to cm) using formulas with operators or functions in Excel. This is useful since the regional settings on a computer affect the default measurement system used in Excel and other programs.

How to Hide Comments or Notes in Excel Workbooks

How to Hide Comments or Notes in Excel Workbooks

You can hide comments and notes in Excel workbooks. In addition to adding comments in Excel, there is a little known function called the N function that you can use to enter notes directly within a formula. The N function has been around for a long time so you can use it in older versions of Excel.

How to Group Objects in PowerPoint (or Ungroup)

How to Group Objects in PowerPoint (or Ungroup)

You can group and ungroup objects in PowerPoint using the Ribbon, keyboard shortcuts or the context menu. If you group pictures, shapes or other objects, you can format, move, resize and animate those objects as one object. You can also ungroup objects that have been grouped and regroup objects.

How to Show or Hide White Space in Word

How to Show or Hide White Space in Word

You can show or hide white space at the top and bottom of pages in Microsoft Word documents. If you hide white space, you won’t be able to see headers or footers in Print Layout View or the gray space that typically appears at the top and bottom of pages as you scroll through your document.

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.

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

Google, the Google logo and related Google Drive applications and logos are registered trademarks of Google LLC in Canada, US and other countries. 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