[TechRepublic] Transpose Excel data from rows to columns, or vice versa

Trouble viewing this mail? Read it online | Manage my newsletters | Unsubscribe TechRepublic Microsoft Office Suite TechRepublic Member | June 24, 2009

Transpose Excel data from rows to columns, or vice versa When you need to flip-flop data in an Excel worksheet, don't waste time doing it manually. Excel offers a handy Transpose option that will quickly take care of the task. Read more Sponsored How much do your peers earn? Find out on activeTechPros if you're an IT professional. * * * * * * * * Introducing activeBizPros: a salary resource for business professionals We're in the midst of building our beta community site. Come join us and help drive the salary charts. Popular power tips   E-mail multiple recipients without sharing e-mail addresses Create a simple invoice template in Word Move data to another workbook without copy and paste Seven keyboard shortcuts to help make your PowerPoint slide shows glitch-free Quickly access the Office folders you use most often Free up screen space for reading Outlook mail Need more screen space for reading Outlook mail? Hide the Navigation pane using this handy shortcut. Read more How do I... Fill Word form fields with Access data? When you need to bring your Access data into a Word form, a little VBA can expedite the task. Susan Harkins walks through an example to demonstrate the process. Read more Office challenge: How can you discern an icon's keyboard shortcut? Here's the solution to last week's challenge on positioning the cursor at the beginning of a Word document. This week, we're testing your general Office expertise: How do you display an icon's keyboard shortcut? Read more A formula-less technique for parsing Excel data Excel's Text to Columns feature parses data quickly and almost effortlessly. Read more Use Word's AutoRecover option to avoid lost work If users can't remember to save their work on a regular basis, get Word to do it for them. Read more Office poll: What kind of Office training have you had? Users pick up their Microsoft Office skills in a variety of ways -- from formal training to on-the-fly assistance from their favorite hallway guru. Take our poll and then see how other members have managed to learn the ins and outs of Office apps. Read more Additional TechRepublic resources   Night-shift boredom on the help desk Jeff Dray has worked some graveyard shifts on the help desk, when duties are lighter and boredom has a chance to set in. How do you cope when you need to stay alert but everyone you know is at home fast asleep? Read more Video: Five email safety tips everyone should follow Instant messaging, texting, and tweeting are all the rage, yet e-mail still dominates the communication landscape--at home, but especially in business. Unfortunately, many people, even IT pros, still ignore the basics of email security. Bill Detwiler goes over five basic email safety tips that everyone should follow. Read more Best of Microsoft Office Suite   34 timesaving mouse tricks for Word users Avoid e-mail mistakes with a single setting Prevent Excel from turning fractions into dates Build a quick training presentation using PowerPoint's Photo Album feature Run your slide show on two monitors - one for you and one for your audience Sponsored Live Webinar: Speed ROI with Intel vPro Technology and Symantec Altiris Realize significant ROI savings-and recoup your investment in as little as 10 months-by activating your PCs with these proven technology solutions. Video: TR Out Loud - June 19, 2009   In the week before the TechRepublic Community Event, TROLOV tries to contain the excitement and carry on as usual, recapping the most popular discussions and highlighting the most active members on the boards. TechRepublic newsletters   Get the latest community updates, product reviews, and need-to-know lists in the following TechRepublic newsletters. Automatically sign up today: Community Central Product Spotlight 10 Things WHITE PAPERS FROM OUR SPONSORS How much do your peers earn? Free 30-day Trial of Desktop Authority (ScriptLogic) Free Test Drive: ActiveRoles Server (ScriptLogic) Unrivaled Red Hat support now available from Novell (Novell) Safeguard intellectual property and ensure compliance (Symantec) TECHREPUBLIC TODAY 10 ways to avoid viruses and spyware To have a fighting chance against today's rampant security threats, end users have to be informed and proactive. Here are some practical guidelines they can follow to minimize the risk of infection and attack. Read more Subscribe to the 10 Things RSS feed. Get more from TechRepublic Video: Five email safety tips everyone should follow Palm Pre vs. iPhone 3G S: The choice I made and why Familiarity can breed contempt among co-workers Video: Five ways to control IT MOOSE spending Featured training courses   Microsoft Exchange Server 2007 Managing and Maintaining a Microsoft Windows Server 2003 Environment Planning, Deploying and Managing Microsoft Systems Center Configuration Manager 2007 Managing and Maintaining Server 2008 Configuring Microsoft Office Communications Server 2007 Browse all training courses Presented by Global Knowledge Ma.gnolia points to potential storms in the cloud TechRepublic member dcolbert vents about his frustration and concern over the recent Ma.gnolia failure. Do you think the Ma.gnolia collapse provides an important lesson in the "cloud revolution"? Apple 16GB iPod Touch (Refurb) Buy Today, Only: $259.00 Blackberry Curve 8900 Red Buy now, only: $199 TechRepublic's best of site   32 online tools The end is near for Windows XP, what are you going to do? 10 cool tools in Windows 7 Find and delete hidden Windows Vista and XP device drivers Hunt down hard disk resource hogs

Send us your feedback here. Sign up for more free newsletters from TechRepublic! To manage your account settings or to remove yourself from all TechRepublic communications, please visit our Subscription Center. The e-mail address for your subscription is cpedley@churchpower.com Unsubscribe from this e-mail | FAQ | Advertise | Privacy Policy   Copyright 2009 CBS Interactive, Inc. All rights reserved. TechRepublic is a registered service mark of CBS Interactive, Inc. CBS Interactive, Inc. 235 Second Street San Francisco, CA 94105 U.S.A.