Wednesday, May 13, 2009

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

May 13, 2009
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.

Do 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.

Live 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
TROLOV 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.

Get the latest community updates, product reviews, and need-to-know lists in the following TechRepublic newsletters.

Automatically sign up today!

TechRepublic Today

10 handy Firefox about:config hacks
10 ThingsIf 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.RSS

Get more from TechRepublic

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.

No comments:

Post a Comment

Thanks for understanding that we need to prevent the nasties.

Terms of Use

Personal & Educational Use Only This blog consists mainly of FREE newsletters from computer web gurus that I receive. I thought you might like to see them all in one place than try to discover them on your own. A moderate amount of editing may be done to eliminate unrelated repetitious ads or unnecessary text which bloat the post. However I have given the authors full credit and will not remove their site links because you deserve to see where it comes from and they deserve to get credit for what they have written. Your use of this site is simply for educational purposes. For more computer-related help go to: CPEDLEY.COM for free software, advice and tips on low cost products which are very helpful. If you want to contact the editor, please go CPEDLEY.COM and check the Contact page for email address.