Avantix Learning Blog

Recent Articles

View related training courses >

How to Create, Use and Edit Templates in Microsoft Word

How to Create, Use and Edit Templates in Microsoft Word

You can create, 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.

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

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

3 Strikethrough Shortcuts in Microsoft Word to Cross Out Text

3 Strikethrough Shortcuts in Microsoft Word to Cross Out Text

You can apply strikethrough to text in Word to create a line through text. Although you can cross out text using Strikethrough on the Home tab in the Ribbon or the Font dialog box, you can also write your own Strikethrough keyboard shortcut in Microsoft Word.

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

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 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 Create, Use and Edit Templates in Microsoft Word

How to Create, Use and Edit Templates in Microsoft Word

You can create, 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 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 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