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 There are multiple ways to highlight text using PowerPoint. If you need to emphasize some important words within your presentation, highlighting words may certainly help. While you can’t highlight text in PowerPoint the way you can in Word, you can make text in PowerPoint appear to be highlighted using a textbox to simulate a highlighted effect by applying a background color. 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 ToolExcel 2013 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 Excel 2013 Tip: Inserting CommentsWindows 10: 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 10: Managing Your Open Programs with Shortcut KeysWord 2013 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 Word 2013 Tip: Pinning Files and Folders for Easy Access