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

PowerPoint Slide Show Shortcuts (50+ Keyboard Shortcuts)

PowerPoint Slide Show Shortcuts (50+ 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.

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 (50+ Keyboard Shortcuts)

PowerPoint Slide Show Shortcuts (50+ 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.

How to Move a Pivot Table in Excel

How to Move a Pivot Table in Excel

Moving a pivot table is not as simple as moving other objects in an Excel worksheet or workbook. You will typically need to use the Move PivotTable command in the Ribbon to move a pivot table to a different area on a worksheet or to a different sheet in the same workbook.

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 Embed a YouTube Video in PowerPoint

How to Embed a YouTube Video in PowerPoint

You can embed a YouTube video in a PowerPoint presentation and run it during a slide show. Essentially, you are linking to the YouTube video using this method but it will play seamlessly in PowerPoint.

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 Compress Images in Word to Reduce File Size

How to Compress Images in Word to Reduce File Size

You can compress images in several ways in Microsoft Word documents to reduce the size of the file. There are built-in Word compression features you can use to make large files smaller but you can also reduce image size before you insert pictures into your documents.

How to Stop Words from Splitting at the End of a Line in Microsoft Word

How to Stop Words from Splitting at the End of a Line in Microsoft Word

There are many ways to stop words from splitting across lines in Word. You can keep words or characters (numbers or letters) together in Microsoft Word using nonbreaking spaces or hyphens. If Word is inserting hyphens in a word you don’t want to break across lines, you can also turn off automatic hyphenation.

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