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.
___________
|
Instead of copying and pasting, you can quickly copy data from a web browser to Excel, by dragging and dropping. ___________ Last month your revenue was $40,000 and this month it’s only $30,000? What happened? You could even create a bar chart to compare the different revenue streams. The bar chart lets you see [...] 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. 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 [...] It’s Friday, and things are slow at the office. To liven things up, you could create bingo cards in Excel, and organize a game during the lunch hour. 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. 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 much from [...] 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 may be other [...] |
||
|
Copyright © 2010 Contextures Blog - All Rights Reserved |
||
Recent Comments