Information management and technology assurance

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

Q: How long should I keep email before deleting it from Outlook? A: I probably qualify to participate in one of those hoarding shows because I have every email I’ve ever sent or received, dating back more than 20 years (starting with my AOL email accounts). Emails sent or received

Q: Our office has a few dead spots where computers have difficulty accessing the internet through our wireless router. What can we do to solve this problem? A: I had a similar problem with weak Wi-Fi signals in my office when my desktop computer managed only two (out of five)

Q: I am trying to prepare an area chart in Excel 2010 with multiple ranges of data, but no matter which sort order I use, some of the underlying data remains obscured (see below). What is the best way to fix this? A: It appears that your best solution is