Instead of copying and pasting, you can quickly copy data from a web browser to Excel, by dragging and dropping.
To see the steps in action, you can watch this 30 second video.
___________
[...]
 
|
Last month your revenue was $40,000 and this month it's only $30,000? What happened? In Excel, you could print a nice report that shows each revenue stream for last month and this month, so you can compare the amounts. You could even create a bar chart to compare the different revenue streams. The [...] Last week, John Walkenbach posted a list of basic skills for men, then basic skills for women, and finally, basic skills for dogs. That got me thinking – what's on the list of basic skills for Excel users? If you use Excel at work, or list it on your résumé, what tasks should you be [...] Do you have two or more web pages that you use frequently? I like Google as a home page, and use it many times during the day. I also refer to my own website several times, to make sure everything is working okay, or look up one of the Excel tips that are stored there. [...]In the Google Reader, you can see a list of your RSS feeds, and group them into folders. Usually I assign a feed to a folder as soon as I subscribe to it. If I forget, then I can assign it later. One way is to click the Manage Subscriptions link, at the bottom [...] In Excel 2003, you can add a couple of buttons to the toolbar to make it easy to filter a table. For example, in the table below, the East region is selected. With one click of a button, and no programming, you can add an AutoFilter and filter the table to show only the East [...] I'm setting up my new laptop, and plan to copy my bookmarks from the old laptop. Before I copy them, I'll clear out the dead links, to tidy things up a bit. There's no point in copying useless data to the new machine. If you'd like to do this on your machine, you can [...] How can you create a chart from annual or monthly data, and make the results easy to understand? For example, this table shows meat production in the UK, per season, over 2 years, in thousands of tonnes. I need a chart that shows the fluctuations in production for each meat type. Did production change [...] In Excel, if you divide 2 by 8, the result is 0.25. if you format the cell as a fraction, the cell might show 1/4 as the result. What if you want to show the result as a ratio? How can you get the cell to show 1:4 instead of 1/4? There [...] Well, it’s Christmas Eve, and you’re probably too busy to read a long blog post today. So, here’s a quick tip that I discovered this week. I use Firefox as my browser, and when I need a new tab, I right-click in the tab area, then click on New Tab. Now, I realize that [...]  |
|
|
Copyright © 2012 Contextures Blog - All Rights Reserved |
||
