Microsoft Office Articles | Avantix Learning
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.
How to Export PowerPoint Speaker Notes to Microsoft Word
You can easily send or export speaker notes from a PowerPoint presentation to a Word document and then print the notes in Word. One of the best options in this process is to send the notes to Word with the notes next to the slides.
10 Microsoft Project Tips for Working Efficiently in Tables
Tables are a core component of Microsoft Project. They appear in many views and display specific fields available in Project. The default tables that appear in the Tables drop-down menu on the View tab include …
A Beginner's Guide to Video Formats in Microsoft PowerPoint
Selecting Video Formats for PowerPoint Decks (Windows or Mac) by Avantix Learning Team | Updated June 29, 2016 Applies to: Microsoft® PowerPoint® 2010, 2013 and 2016 (Windows) and 2011, 2014 and 2016 (Mac) If you are going to insert video in PowerPoint, you should...
How to Access the Free Online Version of 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.
10 Great Keyboard Shortcuts for Microsoft Word Styles Users
You can use Microsoft Word keyboard shortcuts to apply heading styles and remove character and paragraph formatting. If you working on large Word documents, styles are one of the biggest timesavers. Want to learn more? Check out our Microsoft Word training courses in Toronto, Ontario, Canada.
Send Microsoft Project Data to Excel with Visual Reports
With Visual Reports, you can export data to either Excel or Visio from Microsoft Project. You can access the Visual Reports button on the Report (2013 or 2016) or Project (2010) tab.
Automatically Sum Rows and Columns in Excel Using the Awesome Quick Analysis Tool
You can sum or calculate other totals automatically in Excel using the Quick Analysis Tool. This awesome tool calculates totals for Sum, Average, Count, % Total and Running Total. All you need to do is decide if you want totals generated below or to the right of the selected range. You can even see a live preview of the totals before inserting them. In addition to calculating totals, you can also use the Quick Analysis tool to apply conditional formatting or to create charts and tables.
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 Watch Cells for Real Time Updates in Microsoft Excel
Keep an Eye on Important Changes using Excel's Watch Window by Avantix Learning Team | Updated October 1, 2021 Applies to: Microsoft® Excel® 2010, 2013, 2016, 2019 and 365 (Windows) The Watch Window is an awesome tool that you can use in Excel to view changes to cells...
3 Simple Ways to Copy or Import Excel Data into Word (Linked or Unlinked)
You can easily copy or import Excel worksheet data into Word documents. When you import from an Excel file, you can choose to import linked or unlinked data. If it's linked, you will be able to update, change and remove the links.
How to Highlight Errors, Blanks and Duplicates in Microsoft Excel (Using Formulas)
You can highlight errors, blanks and duplicates in Microsoft Excel easily using conditional formatting. Conditional formatting is a great tool in Excel and if you combine it with formulas, you can do some amazing things.
10 Timesaving Microsoft Project Shortcuts in Gantt Chart View
Check out these great shortcuts to save time in the Gantt Chart view.
How to Reduce the File Size of Word Documents (10+ Ways to Compress Word Files)
You can reduce the size of a Microsoft Word document in several ways. The most common strategy to reduce Word file size is to compress pictures. However, you can also use other methods to deal with large documents such as saving media and Word files in other formats and limiting the use of specific features.
How to Convert a Microsoft Access Report to PDF (3 Ways)
You can easily convert your Access reports to PDF (Portable Document Format) without using Adobe Acrobat Pro. To convert to PDF, you use the File tab or the External Data tab in the Ribbon or you can customize the Quick Access Toolbar.
How to Quickly Remove All Animations from PowerPoint Presentations
You can quickly remove or delete PowerPoint animations on an individual slide or turn off all animations for an entire presentation. This can be particularly helpful for specific audiences. In this article, we'll use two methods to remove animations. The first method permanently removes animations on a slide and the second simply disables animations during a presentation. Animations can be enabled again later
How to Use the N Function to Insert Notes in a Formula in Excel
In addition to adding comments in Excel, there is a relatively obscure function called the N function that you can use to enter notes directly within a formula. The N function converts a value to a number and has been around for a long while so you can use it in older versions of Excel as well.
Inserting, Editing, Deleting, Showing and Hiding Comments in Excel
You can insert, edit, delete, show and hide comments or notes in Microsoft Excel using Excel's comments feature. Notes can also be entered directly in a formula. Notes or comments are hidden by default unless you click on a cell. You can quickly delete all comments using the Inspector.
How to Insert Screenshots in PowerPoint and Word (Part 2: Windows Snipping Tool)
You can capture screenshots using the Snipping Tool and insert them into Microsoft Word, PowerPoint, Excel and other programs. The Snipping Tool is a free utility program or accessory in Windows and has already been installed with Windows. So where is this tool?
How to Insert Screenshots in PowerPoint and Word (Part 1: Office Tools)
In 2010 and later, you can capture and insert screenshots in PowerPoint, Word, Excel and Outlook using built-in tools on the Ribbon.
Microsoft Outlook Shortcuts to Improve Productivity (75+ Keyboard Shortcuts)
Check out these 75 Microsoft Outlook shortcuts to work faster with emails, calendars, contacts and tasks.
Discover the Hidden Power of Excel's Custom Views
You can display several variations of the same Excel worksheet with different print settings, filters and hidden columns or rows using the powerful Custom Views command. This command is particularly useful if you are running reports for multiple audiences.
21 Microsoft Word Shortcuts for Faster Formatting
Check out these Microsoft Word shortcuts for faster formatting in your documents. You can save a lot of time using formatting shortcuts in Microsoft Word. Keep in mind that character formatting applies to one or more characters. Paragraph formatting applies to entire paragraphs.
How to Write Your Own Keyboard Shortcuts in Microsoft Excel
Microsoft Excel has many built-in shortcuts as well as the ability to navigate and select in the Ribbon using the keyboard. However, did you know that you can also write your own keyboard shortcuts for specific commands?
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