eHow launches Android app: Get the best of eHow on the go.
Excel is a spreadsheet program that is part of the Microsoft Office software bundle. Learn to use Microsoft Excel with tips from an assistant certified public accountant in this free video series on Microsoft Excel.
There are 27 videos in this series:
Excel macros speed up the work process by recording functions and words that are repetitively typed. Use Excel macros with tips from an assistant certified public accountant in this free video on Microsoft Excel.
Add two cells in an Excel spreadsheet by selecting the auto sum key or manually highlighting the brackets and clicking equal sum. Add two cells in an Excel spreadsheet with tips from an assistant certified public accountant in this free video on Microsoft Excel.
Sum columns or rows in an Excel spreadsheet by highlighting the row or column and clicking auto sum. Add columns or rows in an Excel spreadsheet with tips from an assistant certified public accountant in this free video on Microsoft Excel.
Insert a column or row in an Excel spreadsheet by first highlighting the column to the left or the row on top and clicking on the toolbar, selecting insert and then columns. Insert columns or rows on an Excel spreadsheet with tips from an assistant certified public accountant in this free video on Microsoft Excel.
Sort a row or column in an Excel spreadsheet by highlighting the row or column, clicking data on the toolbar and clicking options and sort. Sort Excel spreadsheet columns and rows with tips from an assistant certified public accountant in this free video on Microsoft Excel.
Create a bar graph from an Excel spreadsheet by highlighting the information and clicking chart wizard from the toolbar. Make a bar graph with Excel with tips from an assistant certified public accountant in this free video on Microsoft Excel.
Use provided formulas in Excel by selecting the drop down menu from the toolbar next to the auto sound function. Use formulas in Excel with tips from an assistant certified public accountant in this free video on Microsoft Excel.
Get totals and subtotals in an Excel spreadsheet by using the auto sum function on the toolbar menu and specifying which cells are being added. Add totals and subtotals with Excel with tips from an assistant certified public accountant in this free video on Microsoft Excel.
Excel workbooks are used for complicated analysis, and worksheets are for simpler Excel assignments. Learn when to use worksheets and workbooks in Excel with tips from an assistant certified public accountant in this free video on Microsoft Excel.
Adding or deleting an Excel worksheet is done by going to one of the bottom tabs, right-clicking the mouse and choosing insert or delete. Insert or delete Excel worksheets with tips from an assistant certified public accountant in this free video on Microsoft Excel.
Rename an Excel worksheet by either clicking on the name part of the file and retyping a new name or by right clicking the file and renaming it. Change the name of an Excel worksheet file with tips from an assistant certified public accountant in this free video on Microsoft Excel.
Format cell numbers in Excel by highlighting the cells and clicking one of the format icons on the toolbar. Format cell numbers in Excel with tips from an assistant certified public accountant in this free video on Microsoft Excel.
Align text cells in Excel by highlighting the cell and choosing to align format from the toolbar. Align a text cell to the left, right or center in Excel with tips from an assistant certified public accountant in this free video on Microsoft Excel.
Add background color or patterns to Excel cells by highlighting the cell and choosing a color from the tool menu. Choose a color or pattern in Excel with tips from an assistant certified public accountant in this free video on Microsoft Excel.
Protect Excel cells from modification by highlighting the entire sheet, going to tools on the menu bar and going to protection and then clicking protect sheet. Protect Excel cells from modification with tips from an assistant certified public accountant in this free video on Microsoft Excel.
Rows and columns in Excel are formatted by highlighting either and double clicking on the selection. Format rows and columns in Excel with tips from an assistant certified public accountant in this free video on Microsoft Excel.
Headers and footers in Excel documents are added by clicking on file, then page setup and selecting header and footer. Add headers and footers in Excel documents with tips from an assistant certified public accountant in this free video on Microsoft Excel.
Add custom menus to an Excel toolbar by going to tools, customize, customize toolbar menus and selecting options. Add custom menus to an Excel toolbar with tips from an assistant certified public accountant in this free video on Microsoft Excel.
Defining cell names in Excel is done by highlighting the cell, going to insert on the menu and selecting name and define. Define cell names in Excel with tips from an assistant certified public accountant in this free video on Microsoft Excel.
Defining cell ranges in Excel is done by highlighting the cell, going to insert on the menu and selecting name and define. Define cell ranges in Excel with tips from an assistant certified public accountant in this free video on Microsoft Excel.
Using cell ranges in Excel formulas is done by highlighting the range and typing the name in the box below the font type. Use cell ranges in Excel formulas with tips from an assistant certified public accountant in this free video on Microsoft Excel.
The autofill function in Excel works by putting the cursor on the bottom right corner until it changes appearance and then dragging the box all the way across. Use the autofill function in Excel with tips from an assistant certified public accountant in this free video on Microsoft Excel.
Use the freeze pane command in Excel to create static headings by highlighting the targeted row, going to window on the menu and selecting freeze panes. Use the freeze pane command in Excel to create static headings with tips from an assistant certified public accountant in this free video on Microsoft Excel.
Save an Excel worksheet as HTML by going to format on the top menu and clicking options and choosing HTML after saving the document first. Save an Excel worksheet as an HTML document with tips from an assistant certified public accountant in this free video on Microsoft Excel.
Spreadsheet templates in Excel are created to prevent work duplication. Create spreadsheet templates in Excel with tips from an assistant certified public accountant in this free video on Microsoft Excel.
Knowing how to use Microsoft's Excel spreadsheet software is an essential skill for today's office workplace. Most jobs require at the very minimum the ability to navigate through the various sheets of a spreadsheet. The Excel application has been the most widely used spreadsheet program since the early 1990s. In this free video series on Microsoft Excel, let an assistant certified public accountant explain how to use Excel spreadsheet applications. First, he talks about recording an Excel macro, adding two cells, columns or rows together, sorting columns or rows and use provided Excel formulas. Next, he gives instructions on deciding when to use worksheets and workbooks, adding or deleting a worksheet, renaming a worksheet and aligning text in Excel cells. Finally, he discusses formatting rows and columns, defining cell names and ranges, using the autofill function and saving a worksheet as an HTML file.
Amar Enhsaihan Amar Enhsaihan is an assistant certified public accountant (CPA) and works with Excel applications everyday on his job.dkdk
Read More
Copyright © 1999-2009 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use and Privacy Policy. en-US Portions of this page are modifications based on work created and shared by Google and used according to terms described in the Creative Commons 3.0 Attribution License.
