Microsoft Access Subforms: The Key to Displaying Access Data from More than One Table Want to take a deep dive into Microsoft Access? Consider enrolling in one of our in-person, full-day Access 2013 training classes presented in Austin, Texas. All classes are instructor-led, encourage interaction and questions, and provide hands-on exercises and learning aids. A frequent question asked in our Access classes concerns how to display the data in a form when[…]
READ MORE about Access 2013 Tip: Creating a SubformWindows 10 Tip: Customize Your Start Menu
Each of us has different needs when it comes to our computers. A great place to start customizing your computer experience is the Start menu. Windows 10 offers many personalization options to make the Start menu fit your workstyle and lifestyle. Personalizing Your Windows 10 Menu There are several ways to customize your Windows 10 Start menu, you have several options: Resizing Resize your Start menu by clicking, holding, and dragging[…]
READ MORE about Windows 10 Tip: Customize Your Start MenuPowerPoint 2013 Tip: Use the Selection Pane to Improve Accessibility
Improve Your PowerPoint Accessibility It’s imperative that you incorporate accessibility best practices into your presentations so everyone, including people with disabilities, has an equal opportunity to benefit from your work. For instance, many with visual impairments commonly use a screen reader. A screen reader will dictate the content you’ve created based on a slide’s reading order. In PowerPoint, the reading order does not necessarily go from top–to–bottom, left–to–right as you[…]
READ MORE about PowerPoint 2013 Tip: Use the Selection Pane to Improve AccessibilityWord 2013 Tip: Cropping Images
Cropping Images Using Microsoft Word Pictures and illustrations can be an effective way of adding interest or getting your message across. Inserting images can be pictures from a clip art gallery, or files that you have collected over the years. Microsoft Word has lots of great picture editing features, one of which is the crop feature. As the name signifies, this feature lets you cut out a portion of your pictures.[…]
READ MORE about Word 2013 Tip: Cropping ImagesExcel 2013 Tip: How to Prepare Excel Data for PivotTables
The PivotTables feature within Microsoft Excel 2013 can be a powerful ally in analyzing large amounts of data. However, to reduce the chance of errors, be sure to prepare Excel data for PivotTables analysis by following these 8 data clean up tasks first. Fail-Proof Tips to Get Excel 2013 Data in Shape for PivotTables Analysis You already know Excel is popular program for analyzing data, and PivotTables is one of the many[…]
READ MORE about Excel 2013 Tip: How to Prepare Excel Data for PivotTablesExcel 2013 Tip: Creating a Macro
Create an Excel Macro to Speed Up Your Repetitive Tasks! Macros—you’ve probably heard the word before, and you may have even heard people talk about how great they are. But what’s the hype all about? When it comes to working with spreadsheets in Excel 2013, some processes can be repetitive (and dare I say, boring). One example is formatting a report. While editing text styles and adjusting cells may feel like[…]
READ MORE about Excel 2013 Tip: Creating a MacroOutlook 2013 Tip: Set Calendar Dates Using Natural Language, Abbreviations
Nifty Outlook Calendar Shortcuts for Setting Appointments Does this sound familiar? You: Let’s touch base six weeks after Christmas and go from there. Client: Sounds great. What date is that? You: Uhhh…let me look at my calendar. You then scroll to the reference point (Christmas) and count six weeks out to find the date. All the while, your client is waiting for a response so they can move on to[…]
READ MORE about Outlook 2013 Tip: Set Calendar Dates Using Natural Language, AbbreviationsWord 2013 Tip: Organize Documents with a Table of Contents
How to Create a Table of Contents in Microsoft Word Long documents can be overwhelming for both the writer and the reader. This week, our Microassist Software Tips tutorial shows you how to create a table of contents for your long Word documents, helping both you and your readers navigate your work. If you often work with long documents, don’t miss Split Window View: Work with Two Sections of the Same Word Document at Once. Using[…]
READ MORE about Word 2013 Tip: Organize Documents with a Table of ContentsProject 2013 Tip: Calendar View for Individual Resources
Creating Individual Resources Calendars within Microsoft Project Whether big or small, Project 2013 is a great tool for managing a project’s timeline and resources. Resources are usually people involved in your project plan, though they can also be materials or equipment. For our purposes, we’ll focus on individuals as resources. While it’s imperative that project managers have a bird’s-eye view of a project to fully understand how the pieces work[…]
READ MORE about Project 2013 Tip: Calendar View for Individual ResourcesHighlight Text in Microsoft PowerPoint
Use These Workarounds to Highlight Text in PowerPoint If you need to emphasize some important words within your presentation, highlighting words may certainly help. A true highlight for PowerPoint is only available in Microsoft Office 365 (consider our Microsoft Office 365: Web Apps and Collaboration for Office 2013 course to learn more). If you’re not an Office 365 subscriber, there are two other ways to highlight text using PowerPoint. While you[…]
READ MORE about Highlight Text in Microsoft PowerPoint