Search for Sinhala video computer lessons, videos, Flash Demos, audio tutorials, softwares, fonts and other useful educational materials using our search utility:
Microsoft Excel 2003 Spreadsheets Sinhala Video Tutorials, Free Lessons
Microsoft Excel is a spreadsheet application that is a part of Microsoft Office suite which was developed by Microsoft. It contains support for calculation, graphing, data record storing, pivot tables and macro programs. Excel is widely used for personal and office use. It is an ideal application for data entry and data analytic tasks. You can download the latest trial version of the software here.
- 1. Introduction to Excel workbook
- 2. Close workbooks
- 3. Open Excel workbook
- 4. Save workbooks
- 5. Working with worksheet tabs
- 6. Add autoshapes to a worksheet part 1
- 7. Add autoshapes to a worksheet part 2
- 8. Add borders to Excel worksheet
- 9. Add comments to cells
- 10. Add Delete and rename worksheets in Excel workbooks
- 11. Add images to worksheet
- 12. Add Headers and Footers in to a worksheet
- 13. Understand Auto Filter option in Excel
- 14. Use AVERAGE MIN and MAX functions
- 15. Change the currency format symbol from Windows Control panel
- 16. Change width and height of cells
- 17. Identify text and numeric records
- 18. Copy special features
- 19. Copy worksheet data
- 20. Create and delete worksheets
- 21. Create designated lists
- 22. Create a Formula in a worksheet
- 23. Create rows and columns
- 24. Create workbooks
- 25. Cross referencing data - PART 1
- 26. Cross referencing data - PART 2
- 27. Currency formatting in worksheets
- 28. Types of data used in worksheets
- 29. Define a range of cells in a practical work
- 30. Delete cell data
- 31. Delete comments in a workbook
- 32. Delete Rows and Columns
- 33. Enter records in to cells
- 34. Enter records to worksheets
- 35. Understand Excel program interface
- 36. Excel workbook with data
- 37. Format cells in a worksheet
- 38. Format Excel worksheet
- 39. Hide Columns and Rows
- 40. Align text properly
- 41. More about width and height of worksheets
- 42. Move worksheet data
- 43. Naming cells and ranges - PART 1
- 44. Naming cells and ranges - PART 2
- 45. Print Excel worksheets
- 46. Remove cell ranges from worksheets
- 47. Sort list records
- 48. Using drawing toolbar
- 49. Using format cell dialogbox
- 50. Using Format Painter
- 51. Using SUM function