Avantix Learning Blog

Recent Articles

View related training courses

10 Microsoft Excel Magic Tricks with Flash Fill

Flash Fill is a great new 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.

How to Export PowerPoint Speaker Notes to Microsoft Word

During a Microsoft PowerPoint training course, students often ask how to send speaker notes from a PowerPoint presentation to a Word document. The best option is to send the notes to Word with the notes next to the slides. After you’ve exported to Word, a table will be created with 3 columns – slide number, slide images and notes on the right.

How to Access the Free Online Version of Microsoft Excel

Like PowerPoint and Word, you can access a free online version of Microsoft Excel and create simple workbooks online or open workbooks you or a colleague has created in the desktop version of Microsoft Excel in the online version.

Excel’s Awesome Quick Totals Tool

Use Microsoft Excel’s awesome Quick Analysis tool to calculate totals automatically for a selected range of cells with the click of a button. Access this tool by …

How to Run a PowerPoint Slide Show using a Keyboard

When running a PowerPoint slide show, presenters may not have a mouse or other tools to manipulate slides, go to hyperlinks or control movies and sounds. In this case, the keyboard may be the only tool available to run a show. The following keyboard shortcuts work in most versions of Microsoft PowerPoint for Windows.

Extracting Data with Excel’s Amazing Flash Fill

Flash Fill is a tool you can use to automatically fill in values in a column in Microsoft Excel. It is available in Excel 2013 and later versions. Flash Fill is able to extract, format and string together data from another column or columns.

Microsoft Excel Articles

View related training courses

10 Microsoft Excel Magic Tricks with Flash Fill

Flash Fill is a great new 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.

Microsoft PowerPoint Articles

View related training courses

Microsoft Word Articles

View related training courses

10 Navigation Shortcuts for Microsoft Word Tables

If you work a lot with tables in Microsoft Word, it’s helpful to learn to move around quickly using your keyboard. Check out this list of helpful keyboard shortcuts to speed up navigating in tables.

Microsoft Word Timesaver – Copying Styles Between Documents

Styles are one of the most useful features in Microsoft Word to automate formatting. If you’re using styles (and hopefully you are), you’ll likely want to copy styles between Microsoft Word documents. One way to copy styles is to use Word’s Organizer and it’s a bit difficult to find in newer versions.

Microsoft Access Articles

View related training courses

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.

Microsoft Project Articles

View related training courses

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

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. You can add and remove items from a timeline and copy a timeline into an email or Word or PowerPoint file to present the timeline.

To request this page in an alternate format, email our staff at info@avantixlearning.ca

Pin It on Pinterest