 
|
If you've imported data into Excel, you might need to clean it up before you can use it. For example, your imported data might have Region headings in column A, Employee subheadings in column B, and sales data in columns C and D.
If you want to filter or sort this data, [...] Excel helps out in the Barbie Bungee Lab, which is not to be confused with MATLAB. Also, there's some debate over the use of the mouse, but everyone agrees that pivot tables are life changing. Only a couple of links this week, and if you plan to do the land based exercises, please consult your [...] 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 [...] A common pivot table question is "How can I create a pivot table from data that's on separate sheets in my workbook? Sometime people have a workbook set up with a separate sheet for each region, or for each salesperson. Eventually, they want to pull all the data together, and create a summary report in [...] One tweet complained that it took 5 minutes to adjust the zoom in Excel 2007. I feel their pain. This week it took me almost that long to find the version info (Office Button, Excel Options, Resources, About). There are some interesting links, including a map of H1N1 severity, in case you need to know. [...] If you add comments to an Excel worksheet, you might want to include those comments when printing. There are a couple of built in options for printing comments, but neither is ideal. We'll look at those, then a numbering system, that's similar to numbered footnotes. The Built In OptionsIn the Page Setup dialog box, [...] We'll set up an Excel workbook so you can click on a map, and see a list of fictional doctors in the state that you selected. Set up the Map First, I found a clip art map of the continental USA, with a separate shape for each state, and pasted that into a [...] Will Excel be banned too? Some people seem to hope so, judging by this week's tweets. But without Excel, how would we get all that data visualization work done? And what would the Google people use for their real work? And the pivot table at the Facebook office isn't quite the same as the pivot [...] Everyone loves a good mystery! And now you can create a few in your Excel workbooks. I've been updating some Excel files that are used for data entry. Some tabs have a long series of questions, and some questions have two or more subsequent questions. To make it easier for users to work [...] Excel is certainly packed with features, but I use a few free add-ins that make Excel even better. Name Managerby Jan Karel Pieterse of JKP Application Development Services If you use names in Excel, you need this tool. You can quickly find names with errors and delete them, or track names that link [...]  |
|
|
Copyright © 2012 Contextures Blog - All Rights Reserved |
||
