Information management and technology assurance

Q: Is there a quick way to create or paste a calendar into a Word document that can be edited, without having to create one from scratch? A: Word includes a tool called Quick Tables, which provides several options for inserting calendars into a Word document, as follows. From the

Q: Help! I was working in Excel 2010 on an important file for several hours when the unthinkable happened. I meant to close a single workbook, but I accidentally closed all of my workbooks without saving. Hoping that there was an undo feature to recover the file, I selected File,

Q: Excel provides several functions (=LOWER, =UPPER, =PROPER) for changing character case; does Word have similar capabilities? A: To change the character case in Word, highlight the word, sentence, paragraph, or document, then press Shift+F3 to toggle between lower, upper, and proper case.

1. Use services such as Twitter Search (twitter.com/#!/search-home) to see if someone’s talking about you, your company, or your products. You can also sign up to receive instant notification in the event a tweet does mention you, your company, or your products. 2. Use applications such as TweetDeck (tweetdeck.com) or

Q: In Excel 2010, the font tool allows me to select from a font size ranging from 8 points to 72 points, but I’m sure that I’ve seen others use a smaller font. Can you tell me how this is done? A: Even though Excel’s font size tool offers font

Q: My colleague runs the same version of Microsoft Office 2003 as I do, but my version is missing some of the functionality that hers has. Why would this happen, and what can I do about it? A: When installing Microsoft Office 2003, the installation routine provides the option to

Who you know matters. Accordingly, many social media websites provide proven solutions for expanding and cultivating one’s circle of contacts, both personally and professionally. With this in mind, presented below are tips for using Facebook, the world’s largest social media website with more than 800 million valid users, half of

Several readers have submitted questions about Excel 2010 and 2007 PivotTables, as follows: Q1: Why does Excel insert the GETPIVOTDATA function into a formula when you use the mouse pointer to refer to a cell in a PivotTable, and is there a way to prevent this action? A1: As discussed

Q: My friend’s phone has a cool feature that allows her to type text messages by sliding her finger across the virtual keyboard rather than typing each key individually. She says this method of typing is much faster once you get used to it. I cannot seem to find this

Q: I keep seeing green triangles in my Excel spreadsheet (pictured below); can you please tell me how to get rid of them? Thank you. A: The small green triangles displayed in the top-left corner of a cell are indicators of a possible error. By default, Excel 2010, 2007, and

Q: I found unwanted cookies on my Windows computer that I am unable to delete, and my security program does not detect or delete them either. How can I get rid of these persistent cookies? (Note: To view the cookies on your computer, from the Internet Explorer browser menu, select

Q: I am trying to write an IF function in Excel that compares two cells to determine if they are exactly the same, including capitals and lowercase letters, but Excel seems to ignore case when using the IF function. What’s the best way to accomplish this goal? A: Excel’s functions