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 MacroMicrosoft Outlook 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 Microsoft Outlook 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 PowerPointCreate a Custom List to Use with Excel’s AutoFill Tool
Day of the Week? Month of the Year? A Custom Series? Use Excel’s AutoFill Tool to Populate Cells Quickly AutoFill Magic You can use Excel’s AutoFill Tool for any number of known series. For days of the week, for instance, simply start with a day, then click and drag the dark square (the fill handle) at the bottom right of the bordered cells. In our example, we’ll put “Sunday” in[…]
READ MORE about Create a Custom List to Use with Excel’s AutoFill ToolMicrosoft Excel Tip: Inserting Comments
A picture says a thousand words, but numbers sometimes need more explanation. Have you ever looked at a spreadsheet of data and had some questions about the numbers you see? On the other hand, have you ever wanted to clarify something about the data you’re providing to someone else? Give your data context by adding notes to individual cells. This tip shows you how simple it is to insert comments[…]
READ MORE about Microsoft Excel Tip: Inserting CommentsWindows 11: Managing Your Open Programs with Shortcut Keys
The Beauty of Using Windows Shortcut Keys If you aren’t already taking advantage of the many Windows shortcut keys available to you, here’s your chance to get started! Shortcut keys offer a quicker method of navigating or executing commands on your computer in lieu of using your mouse. This tip will show you how to open programs from your taskbar, switch among programs, and view all the programs you already[…]
READ MORE about Windows 11: Managing Your Open Programs with Shortcut KeysMicrosoft Word Tip: Pinning Files and Folders for Easy Access
Access Favorite Word Files and Folders without Hunting through Directories Do you have documents you use on a regular basis? Instead of navigating to the location of those documents each time, use Microsoft Word’s “pin” function to easily access favorite Word files and folders from within the application. You’ll save time by keeping your most used documents close at hand. To pin a recently opened file: Open Word and choose the[…]
READ MORE about Microsoft Word Tip: Pinning Files and Folders for Easy AccessMicrosoft Outlook Tip: Email Templates
Streamline Repetitive Messages by Creating Custom Email Templates in Outlook Are there any emails you send on a regular basis? These might include responding to the same types of questions, delivering purchase requests, or sending out notifications for a weekly meeting. There are several ways to manage commonly sent email messages such as copying and pasting text from a Word document or referencing a previous email you sent. You might even[…]
READ MORE about Microsoft Outlook Tip: Email Templates