via youtube.com
via lifehacker.com
via mint.com
via jezebel.com
PC World - Have you ever wondered if Microsoft Excel was invented by a sadist?
Trying to edit multiple files at one time becomes a game of "Find the worksheet." You know that the feature you need is on one of the ribbons, but which one? And a large, funky workbook file can slow the program down so much, you need to take a coffee break after altering a single number.
Let's face it: If you do a significant amount of important work in Excel, you're dealing with one nightmare after another. And if you find that using Excel is more difficult than tracking your finances with a pencil and paper, something isn't adding up properly.
I'm here to help, with solutions to five common nightmares found in Excel 2007 and 2010. I'll tell you how to manage multiple workbooks effortlessly, speed up a slow file, track changes from multiple users, find the feature you need among all the ribbons, and enter data more easily.
1. Multiple open workbooks maximize hassles
In Excel you have two clear and obvious ways to work on three or more spreadsheets: You can have too-small windows that don't give you the big picture, or you can clumsily switch between them.
When you launch Excel, it opens a single window on the Windows desktop. When you open or create another workbook (an Excel file that can contain one or more worksheets), that opens an internal window within the Excel window. You can maximize internal windows so that each one fills the entire Excel window, or restore them to view them all at once.
Unless your worksheets are exceptionally small, you should keep the inner windows maximized (the default setting) so that they fill the whole Excel window. You can switch between worksheets by pressing Ctrl-Tab or, to go in the other direction, Ctrl-Shift-Tab.
That approach works well if you have only two files open--but the more files you add, the more you might cycle through them, going in the wrong direction and then wasting time circling back. Another problem with the technique is that it doesn't allow you to examine two workbooks at the same time (which, depending on what you're doing, may come in handy).
For that, click a workbook's Restore button, which you can find below Excel's Restore button in the upper-right corner. Then you can resize and rearrange the windows for better viewing. You can also minimize those you don't want up at the moment.
If you use two monitors, click Excel's own Restore button so that the application is no longer maximized, and then drag the edge of Excel's window so that it fills both monitors. You'll have much more room for arranging windows.
Your final option--and the best in my opinion--is to download and install one of ExtendOffice's Office Tab products. These Office add-ins place each open file in its own tab at the top of the application window. You sacrifice a small amount of screen space, but gain the ability to switch easily between multiple windows. The free edition adds tabs to Word and PowerPoint as well as to Excel, and can handle pretty much everything you need it to do.
2. One superslow file
You double-click a worksheet in Windows Explorer and wait for it to load into Excel. And wait. And wait. Finally, it loads. You change a number, and then you wait some more.
It's hard to say why a particular Excel workbook file becomes so slow that it's unbearable to use. Here are three common culprits and what you can do about them.
Too many calculations: In complex workbooks, changing one number can affect hundreds of reiterative calculations, and Excel takes time to work out each one.
The solution is to turn off automatic calculations, which you can do from the Options dialog box. To get there in Excel 2010, click the File tab, and then select Options in the left pane. In Excel 2007, click the round Office button, and then click the Excel Options button at the bottom of the drop-down menu.
Once you're in the Options dialog box, select Formulas in the left pane. For Workbook Calculations, select Manual.
Just remember that the numbers won't be correct until you either save the file or press F9.
The field of public health is full interesting challenges. At home and abroad, public health issues are becoming increasingly important. We know that our policies have bearing on our health, and our choices can impact our health.
Additionally, we also know that around the world others don’t have the same access to public health facilities and information. There is a lot of information out there about the distributing of health resources, as well as information here at home about the threats we face to our health. If you are interested in information about public health, there are some great infographics that can illustrate different statistics. Here are 15 public health infographics:
Diseases and Health Conditions
Around the world, there are disease threats. Here are some public health inforgraphics that take a look at diseases around the world.
Progress Against Polio: In the U.S., we’re used to thinking of polio as a disease that no longer exists. However, in other countries, mostly in Third World countries, polio is still a very real threat. In some cases, the disease is still endemic. You can look at this infographic, which includes great color contrast, to easily see where there are still pockets of polio. A great infographic that indicates what we might need to do next.
A Look at ‘Preventable’ Deaths & Diseases: This infographic takes a look at different diseases, and how they can be prevented. Looks at some of the deaths that could have been prevented, diseases that can be prevented, and medical errors that can be deadly. And interesting infographic that really puts disease and public health into perspective. It’s clear that, in some cases, there are diseases that do not have to affect us.
Cancer: This infographic shares information about cancer, and the types that there are. It looks at the public health numbers behind cancer, including who is likely to contract cancer, and who is likely to die from the disease. It also includes common types of fatal cancer, and other facts about cancer. If you want to learn more about this disease, and how it impacts public health, this is a great infographic.
Malaria: This tropical disease affects millions of people each year. Even if you visit a tropical area, there is chance that you could contract malaria. It still constitutes a global public health concern. If you want more information about malaria, this great infographic at World Vision can provide you with solid information and facts abou malaria and its effects.
Life Expectancy and Mortality Rate
Indications of public health in an area can be seen in terms of life expectancy and mortality rate — especially infant mortality rate.
USA Life Expectancy: Learn more about the life expectancy in the U.S. by state. An interesting break down of where you can expect to live longest. Hawaii has the highest life expectancy. Its laid back vibe and very agreeable climate are likely reasons for the high life expectancy rate. It’s an interesting infographic that really puts things into perspective. You can live eight years longer if you live in Hawaii instead of the District of Columbia.
Life Expectancy and Health Care Costs: This eye opening infographic created a storm when National Geographic released it. It looks at health care costs and life expectancy. The U.S. spends more than anyone else on health care, doesn’t have universal health coverage, and has a life expectancy that is less than many other developed countries. An interesting public health infographic — if only for the controversy it sparked.
Life expectancy in America: Takes a look at life expectancy in the U.S. among different groups. Takes a look at different risk factors, regions and ethnic groups. It’s an interesting look at years gained by avoid risk factors, and looks at life expectancy by gender as well as ethnic group. Some interesting surprises, and an interesting look at how income can indicate a higher expectation of risk factors.
Child Mortality Rates Infographic: Interested in child mortality around the world? Mortality is considered a public health indicator. This infographic shares interesting information on the rate of child deaths around the world. It’s an interesting infographic, and one that provides reliable information about child death — and what causes it.
Lifestyle Habits
Smoking, alcohol consumption and obesity are all lifestyle habits that can contribute to different aspects of public health. Here are some great infographics on lifestyle habits.
The Global Obesity Problem: Obesity isn’t just a growing problem in the United States; it affects other countries as well. Indeed, the lifestyle habits that lead to obesity can also lead to other health problems. Diseases like heart disease, diabetes and cancer are all linked to obesity in some ways. This infographic looks at the obesity rates around the world. It is true that the U.S. has the highest rate of obesity, but other countries are catching up.
The Fries that Bind Us and The Magic Bean Shop: Princeton offers a look at two different infographics describing the place of McDonald’s and Starbucks in public health implications that are related to the foods they show. Sometimes we forget how much sugar Starbucks coffee has, and the lack of nutritional value in McDonald’s food. An eye-opening infographic that provides an interesting look at the way we eat — and how it is being exported around the world.
Global Tobacco Trade: Follow the path of cigarettes throughout the world. Information on tobacco, where it comes from, and where it goes. It also includes stats about smoking, as well as the dangerous and unhealthy chemicals found in cigarettes. Includes information on this dangerous lifestyle habit, including the impacts of second hand smoke on others. A fascinating ingraphic from the folks at Princeton University.
The Truth About Alcoholism: Alcohol abuse can cause significant impact on personal and public health. The deaths caused by alcohol related accidents each year are a problem, and, of course, there are liver problems, cancer and other diseases that can grow from alcoholism. Just because it’s legal, doesn’t mean it isn’t actually a public health problem.
Health Care
Finally, the quality of health care received has great bearing on public health. These infographics look at health care facts and figures.
-->
Global Health Indicators: Are We Better or Worse Off Now?: A great infographic put together with information from a report issued by the World Health Organization. Executive Healthcare published the infographic, which includes a great deal of information, including information about health care workers, access to health care, and sanitation. Additionally, includes other health indicators, like mortality rates and life expectancy. It’s meant to monitor health progress around the world.
Health Care Capabilities: Where will you get access to health care facilities? This infographic looks at access to health care, and the existence of acceptable health care capabilities, around the world. It’s an interesting look at at where you can find the health care you need. It has great implications in terms of figuring out where more health care services are needed — and helping you decide what sort of evacuation you might need if you get sick in some countries.
Health Reform and the Uninsured: A look at health reform in America, and the uninsured. Many consider a rising number of uninsured a public health issue. And with health care reform possibly being repealed, many are wondering what’s next.
Tagged as: disease, Health, Health care, medicine, public health
Save this on delicious...Save this on delicious...
ShareThis
via arstechnica.com
via lifehacker.com