Microsoft Office Articles | Avantix Learning
10 Useful Microsoft Access Shortcuts When You're Working with Controls on Forms and Reports
Check out these great shortcuts for manipulating controls in Design View in both forms and reports in Microsoft Access.
How to Stop or Control Microsoft Access Error Checking Markers
In Microsoft Access, small green error markers may appear in Design View in forms and reports for a number of reasons. You can turn error checking off completely or set the rules you prefer.
How to Break, Update or Change Links to Excel Charts or Worksheets in PowerPoint
If you want to break, update or change links to Excel charts or worksheets in PowerPoint, you'll need to use the Edit Links to Files command. Unfortunately, this command is difficult to find. To make it easier to access, you can add Edit Links to Files to PowerPoint's Quick Access Toolbar.
10 Excel Data Entry Tricks and Shortcuts Every User Should Know
Check out this great list of Excel data entry tricks and shortcuts to save time in your worksheets.
How to Insert Reusable Text Snippets in Word with Quick Parts (Great Timesaver)
Microsoft Word's Quick Parts can be used to automatically add repetitive words, paragraphs, statements, images or logos into Word documents …
Excel Shortcuts for Filtering Data (10+ Keyboard Shortcuts)
You can turn on Filter or AutoFilter in Excel for data sets / lists and tables and easily filter and sort data using a mouse or keyboard shortcuts. When you first turn on Filter, arrows appear in the header row for each field with a drop-down menu. You can then use keyboard shortcuts to select different filter options from the Filter menus.
10 Microsoft Project Shortcuts to Zoom and Move Quickly in the Gantt Chart Timescale
Zoom in, out and move using these great shortcuts in the Microsoft Project Gantt Chart timescale. The timescale in the Gantt Chart view appears on the right side and displays units of time.
How to Add a Timeline in Microsoft Excel to Filter Pivot Tables by Date
In newer versions of Excel, you can filter pivot tables by date periods using a timeline tool. You can combine timelines with slicers to filter in different ways and you can also zoom in on specific date periods.
How to Create a Navigation Form in Microsoft Access
In newer versions of Microsoft Access, you can create a new type of form called a navigation form which includes one or more navigation controls.
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.
How to Use the Eyedropper in PowerPoint to Match Colors
In newer versions of PowerPoint, you can match colors by picking up and applying specific colors from a picture on a slide or even on a web site using the Eyedropper.
25 Microsoft Access Shortcuts to Save Time in Tables in Datasheet View
Check out these 25 keyboard shortcuts when you're working in Access tables in Datasheet View.
10 Microsoft Access Navigation Pane Keyboard Shortcuts
There are many keyboard shortcuts that can be used in the Microsoft Access Navigation Pane. The four basic objects that appear in the Navigation Pane are tables, queries, forms and reports.
10 Great PowerPoint Drawing Tricks and Shortcuts
Check out these great PowerPoint drawing tricks and shortcuts that can really save you time.
10 Microsoft Access Tips for Creating Select Queries
There are a number of ways of working efficiently in select queries to get the results you want and save some time. You can also use many of these tips in other types of queries.
How to Use Sections in PowerPoint to Organize Slides
You can manage a PowerPoint presentation by organizing it into sections. Although you can work with sections in Normal View or Slide Sorter View, it's easier to work with sections in Slide Sorter View. You can insert, name, move, collapse, expand and remove sections in PowerPoint. If you are working with a team on a large presentation, you can assign team members to different sections. You can also use Summary Zoom in PowerPoint 2019 or 365 to create links to different sections.
10 Microsoft Word Shortcuts for Moving Around in 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.
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.
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