[TechRepublic] Add data to an Excel worksheet from a Word table

May 13, 2009

TechRepublic Microsoft Office Suite Trouble viewing this mail? Read it online | Manage my newsletters Welcome: TechRepublic Member Update my profile | Unsubscribe from this mail Blogs | Photos | Downloads | Forums Add data to an Excel worksheet from a Word table If you have a workbook containing data that originates in Word, you can keep the data current with the help of Excel's Import External Data wizard. Here's a look at how to put this handy feature to work. SponsoredDo a salary check IT Professionals - check your salary on activeTechPros. Be a member and get instant access to salary charts and country reports. * * * * * * * * * * Business Professionals - join activeBizPros and play a part in driving the salary charts. Your input will help us build a valuable resource for you to compare salaries. Members' choice 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. Hottest new tips Clear an Access combo box for entering the next record You can have Access clear the selection from a combo box in a data entry form so that the user starts fresh with each new record. See how to make this user-friendly tweak. Return quickly to document text after inserting a footnote After entering a footnote or endnote, Word seems to leave you stranded. Fortunately, a quick keyboard shortcut will take you back to the spot where you were working in your document. Copy an Excel chart into a presentation (without dragging the workbook with it) When you copy an Excel chart into a presentation, PowerPoint pastes the entire workbook along with it -- which has a couple of disadvantages. Here's a trick that lets you paste just the chart onto a slide. Office Challenge: How can you get Excel to return an average that doesn't consider 0 values? Here's the answer to last week's challenge on exporting the text from a PowerPoint presentation, along with a new question to test your Excel skills. SponsoredLive Webcast: The 4-Hour Workweek: Using Technology to Increase Productivity Join this live BNET Webcast featuring Tim Ferriss, best-selling author of The 4-Hour Workweek, to learn why businesses need to change the way they think about work. (Citrix Online) Video: TR Out Loud - May 8, 2009 Sonja Thompson keeps the TechRepublic community up on the weekly happenings by highlighting the top discussions and members on the site. She also counts down the weeks until the community event. 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 partners Do a salary check Cool Tool: Lumension Vulnerability Scanner (Lumension Security) Free Software Trial Finds VMware Problems and Optimizes the Data Center (VKernel) Live Webcast: The 4-Hour Workweek: Using Technology to Increase Productivity (Citrix Online) How Rich Internet Applications Impact the Network and Application Delivery (Crescendo Networks) TechRepublic Today 10 handy Firefox about:config hacks If you really want to fine tune your Firefox functionality, you have to roll up your sleeves and tinker with the about:config page. Jack Wallen shares some simple hacks to make Firefox work the way you want. Subscribe to the 10 Things RSS feed. Get more from TechRepublic IT Dojo: Install IIS 7.0 on Windows Server 2008 with a Package Manager script Sanity check: The four stages of a typical Twitter user Tech pro feeling squeezed out by manager Video: Five signs to look for when identifying future leaders 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 Best practices for putting your business or brand on Twitter Twitter is known as a social networking tool that allows people to connect with the individuals whose activities and opinions they care about. Businesses are also getting in the act, and here are some best practices to help them. 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, TechRepublic.com and the TechRepublic logo are registered trademarks of CBS Interactive Inc. Used by permission. CBS Interactive Inc. 235 Second Street San Francisco, CA 94105 U.S.A.