Free online training videos in Microsoft Excel 2003

Introduction to Excel 2003 including a sample training video:
When you start Microsoft Excel a page or 'sheet' with many cell like structures appears. Each Excel cell has an 'address', indicating its position in the Excel worksheet. The cell address specifies the Excel column number and the row number. For example a cell address 'A1' specifies column 'A' and row '1'. A Microsoft Excel 2003 worksheet has 256 columns and 65536 rows (256x256). Excel 2007 has 1,048,576 rows by 16,384 columns. You can enter text, numbers including dates and formulas in the cells. The data in the cells can be formatted using standard procedures. Using the values at the cell addresses you can perform calculations. For example, if the value at cell address 'A1' is 25 and the value at cell address 'B1' is 4, then if you write the formuala '=A1*B1' at cell address C1, the resultant value at cell address C1 will display '100'. Now assume for a moment you made a mistake. You wanted to actually enter '35' in cell 'A1'. Click on Excel cell 'A1', enter '35' and check the result in cell 'C1'. The value at cell address C1 has automatically been updated to '140'! You can access values at addresses in other Excel sheets also and perform the required calculations. This is what makes Microsoft Excel so powerful.

What other things can you do in Microsoft Excel?

You can create sales invoices, purchase orders and packing lists.
You can create a cash flow statement, income statement, profit and loss statement and a balance sheet. It is one of the most versatile programs to perform financial analysis.
You can create budgets, for example, a party budget, a retirement budget or an R&D budget.
You can forecast growth of a company or you can report the actual performance of a sales person compared to her expected performance.
You can use Excel to plan a marriage party or create a marketing plan for a quarter.
You can track the number of hours worked per week by each of your staff using the time function.
You can use Excel like a calendar with date functions to, for example, track milestones.
Using Gant charts you can monitor the progress of a project
Some programmers have created quizzes and games in Excel
There are others who have used the software in Engineering like designing a complete cooling system for a laboratory along with the cost.

Quickly find the topic of your interest from hundreds of videos:

Excel 2003 training
Basic Working Introduction Basic calculations Text formatting Number formatting Dates formatting Freeze Panes Hide & Unhide Data Autofill Copy and Paste Special Custom Lists Fill series Data Entry Guidelines Data Validation: Text & Numbers Data Validation: Dates Data Validation: Custom Data Vaildation: Using named lists Named Ranges Conditional Formatting Dynamic Named Ranges Data Lists Information from Data AutoFilter Advanced Filter Vlookup Hlookup Pivot Tables Functions Sum IF function CountIf SumIf Sumproduct Arrays DSUM 'AND' Function Multiple IFs PMT function: Monthly Payments Compound Interest Forecasting Depreciation Growth Function Time Functions Date Functions Text function: EXACT Goal Seek Solver Internal Rate of Return (IRR) Data Presentation Pie chart Gantt Charts Statistics Templates	Introduction to Excel 2003 including a sample training video: When you start Microsoft Excel a page or 'sheet' with many cell like structures appears. Each Excel cell has an 'address', indicating its position in the Excel worksheet. The cell address specifies the Excel column number and the row number. For example a cell address 'A1' specifies column 'A' and row '1'. A Microsoft Excel 2003 worksheet has 256 columns and 65536 rows (256x256). Excel 2007 has 1,048,576 rows by 16,384 columns. You can enter text, numbers including dates and formulas in the cells. The data in the cells can be formatted using standard procedures. Using the values at the cell addresses you can perform calculations. For example, if the value at cell address 'A1' is 25 and the value at cell address 'B1' is 4, then if you write the formuala '=A1B1' at cell address C1, the resultant value at cell address C1 will display '100'. Now assume for a moment you made a mistake. You wanted to actually enter '35' in cell 'A1'. Click on Excel cell 'A1', enter '35' and check the result in cell 'C1'. The value at cell address C1 has automatically been updated to '140'! You can access values at addresses in other Excel sheets also and perform the required calculations. This is what makes Microsoft Excel so powerful. What other things can you do in Microsoft Excel? You can create sales invoices, purchase orders and packing lists. You can create a cash flow statement, income statement, profit and loss statement and a balance sheet. It is one of the most versatile programs to perform financial analysis. You can create budgets, for example, a party budget, a retirement budget or an R&D budget. You can forecast growth of a company or you can report the actual performance of a sales person compared to her expected performance. You can use Excel to plan a marriage party or create a marketing plan for a quarter. You can track the number of hours worked per week by each of your staff using the time function. You can use Excel like a calendar with date functions to, for example, track milestones. Using Gant charts you can monitor the progress of a project Some programmers have created quizzes and games in Excel There are others who have used the software in Engineering like designing a complete cooling system for a laboratory along with the cost. Quickly find the topic of your interest from hundreds of videos:*	Macros Excel 2003 Printing Printing - Part I Printing Part II Importing Data Databases Text files Specific Uses Invoices Networth Calculator Buy a car or lease Sell or rent property? Expense statements Breakeven Analysis Excel & Outlook Excel & Science Web query Protecting worksheet & hiding formulas Smart tags MySql Exporting data from MySql Importing data into MySql Activex Controls Combo Box Spinner button Scroll bar Project: form controls
Excel 2003 training

Excel 2003 training