You are here: Home / Archives for Windows

10 Excel Keyboard Shortcuts that Every User Should Know

December 8, 2010 by Leave a Comment
Touche CTRL
Image via Wikipedia

Microsoft Excel can be difficult for new users to get around in. They may find themselves clicking the wrong areas, or have trouble locating commands within the tool bars. There are several keyboard shortcuts that are beneficial to anyone who uses this program. These are especially useful if you have problems with your mouse or simply prefer to use the keys on the keyboard.

Navigation Within Excel

CTRL + Home – This shortcut will move you to the beginning of your worksheet. The active cell will typically become A1, or the first cell located in the top left corner of the page.

CTRL + End – This combination of keys will all your active cell to become the one located in the bottom right corner of your worksheet.

CTRL + N – These two keys open a new worksheet when pressed at the same time.

Data Selection

CTRL + Click – This keyboard shortcut will provide you with the ability to select a number of cells at one time. You would normally click your mouse and drag the cursor across the page to select more than one cell. However, by pressing the CTRL key, you can select cells that are not touching each other.

CTRL + A – These two keys, when pressed together, will allow you to select the entire worksheet.

CTRL + C – This shortcut makes a copy of the cells you have just selected. They will be appended to the clipboard, and can be pasted somewhere else on the worksheet, or into a new worksheet.

CTRL + V – Pressing these two keys together will allow you to quickly paste the cells you have previously copied.

Font Formatting in Excel

The following keyboard shortcuts will apply to the text within an active cell. Additionally, they will also alter the text within each cell if many cells are currently selected.

CTRL + B – Bolds the text

CTRL + I – Italicizes the data

CTRL + U – Underlines the text

Filed Under: Excel, Microsoft, Tips Tagged With: , , , , , , ,

2 Computer Essentials

November 11, 2010 by Leave a Comment
Installing Microsoft Windows Vista
Image by cocoate.com via Flickr

When you are buying a computer you are overwhelmed with the amount of choices there are available to you. There is certainly no limit to what you can have done to it. As a matter of fact you have websites that are completely devoted to giving your computer every accessory and piece of power it possibly can. It’s so easy to get overwhelmed by these choices that you end up making a rather poor choice about your computer and either overpay or don’t get what you really needed on the computer in the first place. So here is a list of exactly what your computer needs.

Microsoft

This should go without saying seeing as how almost every computer in the world runs on Windows but if you get a computer without the essential windows tools you’ll making your own PC worse for wares. The truth is that Windows isn’t the best feature of Microsoft. Their office edition has some of the better applications out there and for that you are missing the boat if you pass them up. Go and get yourself Windows today and the great office programs that go along with it.

DVD Player/Sound Card

Don’t fool yourself into thinking that your computer was here for the explicit purpose of hanging your email. The truth is your computer is quickly become your one stop entertainment center. You can do anything on it. So make sure your next computer has a DVD player and a good sound and graphics card. It’s the best thing that you can possibly do for your computer in the future. This will also help as many stations and companies are putting their programming online. It’s become a big industry and you could use a computer that knows how to handle it. Having these things will make your computer what you need it to be.

Filed Under: General, Internet, Microsoft, Tips Tagged With: , , , , , , ,

Using Excel in the Home

September 21, 2010 by Leave a Comment
Excel round-off error
Image via Wikipedia

Microsoft Excel may seem like a technical program designed for use in businesses, but that is not the only place it can be used. The software can also be used within the home to track a number of things.

Weight loss can be tracked using Microsoft Excel. It is simple to create a worksheet that will allow you to input your weekly weigh-ins. This can also be used to record monthly body measurements or to count calories. Begin the monitoring by setting up a template you can refer to regularly. You can use the first column to input dates that you plan to weigh in. The SUM formula within Excel will allow you to quickly see the total amount of weight you have lost during your journey. The same can be calculated for your loss of inches and total caloric intake.

Managing your finances is easily done using Excel. There are many different ways you can go about this. A beneficial way is to have one page tracking income and other that tracks expenses. Alternatively, you can create 12 sheets within a project, and use one for each month of the year. Formulas will help you to keep the records up to date. Remember to input each time you earn or spend money to keep the spreadsheet accurate. This program can help you to indicate how much money is coming in and going out, as well as where most of your expenses lie.

Keeping a record of your family’s schedule can also be performed with Excel. You can easily create a page for each family member, and input information regarding after school activities, family events, and other scheduling. This will allow you to see where everyone will be throughout the week. Being able to see this information as a whole can help you determine who will be dropping off and picking up each child from their activities.

Enhanced by Zemanta
Filed Under: Excel Tagged With: , , , , , , ,

Excel 2010 New Sparklines Application

September 15, 2010 by Leave a Comment

Excel 2010 comes with a new feature included, which is known as Sparklines. This is a graphical option that will allow you to add little, one-cell charts into the middle of your spreadsheet. As such, you will be able to provide your viewer with a visual representation of the data. This will help this data to look a lot more organized.

An example of when you might want to use Sparklines is whenever you wish to display data in a line or a column in order to show win/loss or to highlight a specific trend that has occurred. You may also want to use it in order to track and highlight any important trends that are occurring within your Excel spreadsheet.

Here is how Sparklines can benefit you whenever you are creating an Excel spreadsheet. If you are reading a chart about how many sales occurred each day over the course of a week, you could see a little image representing each of the rows in the chart. This can be included within the report in such a way that you would never even need to flip a page in order to see the image. In doing so, Excel makes it really easy for you to be able to review and understand any data trends that are occurring within the report that you are viewing.

In order to use Sparkline you will want to go to your Insert tab. There you will find “Sparkline” and a range of data that you will be able to choose from. Here is where you will be able to customize your Sparklines. If you select the Sparkline, then choose the Design tab you will be able to give them the best effects possible, which is something that you were never able to do before with any Excel program prior to the 2010 release of this version of the software.

Filed Under: Excel Tagged With: , , , , , , ,