How to Learn Excel VBA Online

1. Learn Excel VBA. Look for nonmacro solutions before you start messing with VBA. If you don't know Excel's capabilities well, you're likely to write macros that do things you could accomplish instead with good spreadsheet design and a few mouse clicks.
2. Navigate to Microsoft's VBA for Excel 2003 training page. There is no equivalent page for Excel 2007, but you won't need version-specific knowledge until you've mastered the fundamentals of VBA.
3. Watch the introductory videos and work through the textual tutorials that introduce programming with VBA. There are three courses. Complete them, do the practice sessions and take the tests.
4. Complete the VBA tutorials at xlpert.com and xl-vba.com. Xlpert offers a free eight-lesson course, while xl-vba's course has 23 lessons. The writing doesn't sparkle and there's a lot missing (to encourage you to buy a complete course), but the material will reinforce what you learned from Microsoft's site. Repetition is useful when learning a new language.
5. Build a spreadsheet that does something useful for you, then turn it into a macro-driven application. When you feel stymied--and you will from time to time--press the F1 key to activate Excel VBA's help system. You can learn VBA entirely from the help system, but it would be very hard if you're not already a programmer.
6. Visit Microsoft's developers' forums to research problems and ask questions of other programmers. A link below leads to the forums page where you'll find a list of several Excel-related discussion groups.

Read more ►

How to Define a Table in Excel 2007

1. Start off by doing one of the following: Select the range of cells that you want to make into a table within your worksheet then proceed to Step 2 OR Start immediately with Step 2.
2. Click on the 'Insert' tab at the top of the document.
3. Find the 'Tables' group, then click on 'Table.' The 'Create Table' dialog box will appear.
4. Type in a range for your table if you did not select a range in Step 1. If you did already select a range then that range will automatically appear in the dialog box.
5. Check the 'My Table Has Headers' box if the data set you selected already contains the headers you want to use. If you don't check this box, the table will display default header names, which you can then go in and change.
6. Hit the 'OK' button at the bottom of the Create Table dialog box to create your table.

Read more ►

How to Calculate Population Standard Deviation Using Excel

1. Add the numbers in the first column of your Excel 2007 document. For example, add the numbers 15.4,13.2,11.1,12.5,11.3 and 13 in A2, A3, A4, A5, A6 and A7.
2. Click on the 'A9' cell for this example. This is the cell where you will calculate the standard deviation. When you calculate another standard deviation, choose any cell at the bottom of the list of numbers you are using.
3. Click on the 'Formulas' tab while you are in the 'A9' cell. Click on 'Statistical' on the drop-down menu.
4. Click 'Insert Function' on the top left-hand side of the Excel spreadsheet. The 'Insert Function' window will pop open.
5. Click on the drop-down menu of 'Or select a category.'
6. Scroll down the 'Select a function' window. Choose 'STDEV,' which is the function of standard deviation based on the sample.
7. Click 'OK.' The 'Functions Arguments' window will pop open. Ensure that on 'Number 1' cell, A2:A7 is populated. If A2:A7 is not populated, enter A2:A7 manually. Click 'OK.'
8. The standard deviation has been successfully calculated in the 'A9' cell. In this example, the calculated value of the standard deviation is 1.560449.

Read more ►

How to Insert a Checkbox in Excel 2007

1. Click on the 'Developer' tab.
2. Click 'Insert' then 'Check Box' under 'Form Controls.'
3. Click where you want the check box to appear on the spreadsheet.
4. Click 'Properties' on the 'Developer' tab. Edit the properties you want to have on your check box.

Read more ►

How to Select Multiple Entries From the List in Excel 2003

1. Click the Windows 'Start' button and select 'All Programs.' Click 'Microsoft Office' in the list of programs, then click 'Microsoft Excel' to open the software.
2. Click the 'File' ribbon tab at the top of the Excel software. Click 'Open' to view the 'Open' dialog window. Double-click the Excel file you want to use.
3. Click the first cell you want to select. Hold the 'Ctrl' key and use the mouse to click each cell you want to select.
4. Right-click one of the selected cells and select 'Copy.' The cells' contents copy to the Windows clipboard. You can now move the content to a new program window or copy the cells to a new spreadsheet.

Read more ►

How to Align Decimal Points in a Word Table

1. Open the saved Word table.
2. Click the “View Ruler” button at the top of the right vertical scroll bar to display the horizontal ruler and left ruler near the document.
3. Click the “Tab” selector at the top of the left ruler to bring up the “Decimal” tab. The “Decimal” tab symbol displays one horizontal line, one vertical line and a decimal on the right side. Usually, this “Decimal” symbol appears on the third click.
4. Click and drag the cursor on the column that will contain the decimal tab stop. This column will appear highlighted.
5. Click the horizontal ruler where you wish to insert the decimal tab stop. A dashed vertical line will temporarily appear where you clicked.
6. Click in the cell. A vertical bar will indicate where the decimal will line up.
7. Type the number with the decimal point. Continue typing numbers in the column. The decimal points will line up vertically.

Read more ►

How to Change Default Fonts in Excel

Change the Font Attributes in a Worksheet
1. Select the cell, or group of cells, that you want to format. To select one cell, place the mouse pointer on the cell and click the left mouse button. To select a group of adjacent cells, click on one of the cells and drag the mouse pointer to highlight all the cells in the group.
2. Locate the font box on the tool bar. Click the arrow on the right side of the box to see the drop down menu. The menu contains the various fonts.
3. Change the default font. Use the scroll bar on the right side of the menu to see all the fonts available. Click on a font to select it.
4. Change the font size. Click on the font size box, located on the right side of the font box, to select a new font size. You can also increase the font size with the 'Increase Font Size' button or decrease it with the 'Decrease Font Size' button.
Change the Font Attributes in a Workbook
5. Open the 'Options' dialog box. Click on 'Tools' on the tool bar and select 'Options.' This opens the Options dialog box in which you can change the default attributes of your workbook.
6. Change the default font. Click the 'General' tab and then click the arrow in the 'Standard font' field. Select a new font from the list.
7. Change the font size. Click the 'Size' box and select a new font size.
8. Click 'OK' when you have finished making your changes. You will have to restart Excel in order for the changes to take effect.

Read more ►

How to Install Word, PowerPoint and Excel Only

1. Place your Microsoft Office disc into the optical drive of your computer to begin the installation.
2. Enter the Microsoft Office product key in the field and click 'Continue.' Accept the software agreement and again press 'Continue.'
3. Click the button 'Customize' and select the tab 'Installation Options' to display the list of all programs included in the Microsoft Office package.
4. Right-click on each program in the list except Microsoft Word, Excel and PowerPoint, and select the option 'X Not Available' from the menu. This will prevent those unneeded programs from installing
5. Click the button 'Install Now' on the bottom of the installation window.
6. Restart the computer when prompted to finish up the Microsoft Office installation process.

Read more ►

How to Disable a Macro in Excel 2003

1. Open Excel 2003. Select 'Tools' on the menu bar. Click 'Macro' and 'Security.' The Macro Security dialog box appears.
2. Select 'High.' This will disable all macros that are not from a trusted source. Select 'Very High.' This will only allow macros to run if they are in a trusted location. So using these two choices will disable any macros that are not from trusted source or in a trusted location.
3. Click 'OK' to confirm the macro security changes in Microsoft Excel 2003.

Read more ►

How to Print a Large Excel Spreadsheet

1. Set the print area by selecting the top left corner of the area you wish to print, and dragging to the bottom right. This will create an outline around the area you wish to print. Click 'File,' 'Print Area' and 'Set Print Area.'
2. Click 'File' and 'Print Preview.'
3. Set the page size to the paper you will be using. The standard is A4.
4. Set the scaling. Try checking 'Fit to one page(s) wide by one page(s) tall' box. If the percentage showed in the toolbar changes to below 40 percent, the text will probably be too small to read. If not, click on the page to view a print preview and check if the spreadsheet is big enough to be understood. Choose a bigger percentage if not.
5. Reset the margins. You may need to click the 'Margins' icon in the toolbar to show the margins if they do not show up automatically. Drag along the margin to shrink it, and create more usable space.
6. Click 'Print.'

Read more ►

How to Auto Fill in a Cell in Excel

1. Click the first cell that you want to include in the data range.
2. Type the first value for the series.
3. Type the second value in the next cell to establish a pattern.
4. Click the first cell and drag your mouse to the second cell to highlight both cells.
5. Hover your mouse over the Fill Handle, located in the lower-right corner of the highlighted cells.
6. Drag the Fill Handle across the range of cells that you want to auto fill.

Read more ►

How to Make a Drop

1. Type the entries you want in the drop-down box. Place one word in each cell in a single column. For example, you may want a drop-down box in cell A1 limited to red, yellow and blue. Type 'Red' in cell 'B1,' 'Yellow' in cell 'B2' and 'Blue' in cell 'B3.'
2. Click on 'Data > Validation > Settings' in Excel 2003 or 'Data > Data Validation > Data Validation' in Excel 2007.
3. Click on 'List' in the Allow box.
4. Enter the location of the inputs for the list box. In the above example, the inputs are in cells B1 to B3, so enter '=B1:B3.' Click on the 'In-cell drop-down' box if it isn't already checked.
5. Click on 'OK.'

Read more ►

How to Use Excel Effectively

Learning Excel
1. Open the program, and from the Help menu (the blue '?' button), access office.microsoft.com. You'll be asked to identify or let Microsoft identify the installed versions of Office products on your system. A browser will open.
2. Select the 'Tutorial' option on the help screen, which now displays in the Internet browser.
3. Select the first tutorial offered, explaining the differences between Excel 2000, 2003 and Excel 2007 and 2010. Follow onscreen instructions and lessons. Learning the improvements to the newer versions is key to efficiently using Excel.
Options
4. Select 'Options' from the Office Button in Excel 2007 and the File tab in Excel 2010 at the bottom of the window and make changes to the default options to make the basic program operation as personally efficient as possible for its regular use. In both versions, the Quick Access Toolbar can be customized to place buttons for commonly used commands. In Excel 2010, the Ribbon can also be customized.
5. Select 'Backup file when saving' In the 'Save' tab. This is unchecked by default. Back-up files are critically important, especially if converting from Excel 2000 or 2003 to the new versions. When the active workbook is saved, the older copy will be renamed with an 'wbk' file extension, allowing the file to be used again if the 'xlsx' file becomes corrupted or damaged.
6. Customize the Quick Access Bar and the Ribbon with commands used frequently. The Quick Access Bar, if placed below the ribbon (default is above ribbon) and customizing options resembles the tool bars that would have been used in earlier versions of Excel.

Read more ►

How to Skip Printing Rows That Have a Cell Value of Zero in MS Excel 2003

1. Open the Excel file you want to print.
2. Select 'Data' from the menu bar, then select 'Filter' and follow the right arrow to select 'AutoFilter' from that menu. Each of your column headings will now have buttons with down arrows next to them.
3. Click on the arrow button in the column that contains zeroes you want to suppress. For example, let's say your spreadsheet lists employee names in column A and the number of hours they worked in column B. You don't want to print any rows where the employee worked zero hours. You would click on the column B arrow.
4. Click on '(Custom...)' from the drop-down box to bring up the Custom AutoFilter setting. In the drop-down box under your column B heading, select 'does not equal' and in the empty drop-down box to the right of it, select '0.'
5. Click 'OK.' Your list is now filtered and rows with zeroes are hidden.
6. Print your document.

Read more ►

How to Convert True

1. Click the 'Developer' tab at the top of an Excel worksheet. Then click the 'Insert' drop-down menu in the 'Controls' group.
2. Click the check box image in the 'Form Controls' section of the drop-down menu. This changes your mouse pointer to a cross.
3. Click anywhere in the worksheet to insert the check box with a description next to it.
4. Right-click the description next to the check box, then left-click the description until you see a blinking text cursor.
5. Press 'Backspace' or 'Delete' to erase the description that is automatically shown. Then type your own description. Click outside the description area in a blank cell when you are finished. For example, type 'Sales quota met?' as a description.
6. Right-click the check box, and click 'Format Control' on the pop-up menu to bring up a 'Format Control' window.
7. Click the 'Control' tab at the top of the window.
8. Click in the 'Cell link' text box and type the cell to which you want to link the check box. For example, click in the cell link text box and type 'A1.' Cell A1 will now show either 'TRUE' or 'FALSE' depending on whether the check box is checked or unchecked.
9. Click 'OK' to close the 'Format Control' window.

Read more ►