Search for Sinhala video computer lessons, videos, Flash Demos, audio tutorials, softwares, fonts and other useful educational materials using our search utility:
Microsoft Excel 2007 Spreadsheets Sinhala Video Tutorials and Free Lessons
Microsoft Excel is a versatile application of the popular Microsoft Office suite. You can use Excel to create tabular data, perform financial calculations, store data, sort data according to given criteria information analysis and many more useful operations. It is an ideal application for data entry and data analytic tasks. You can download the latest trial version of the software here.
- 1. Start MS Excel 2007 Application
- 2. Understand the Ribbon
- 3. Office Button
- 4. Quick Access Toolbar
- 5. Worksheet
- 6. Cell ID and the Name Box
- 7. Worksheet Buttons
- 8. Rename, Create, Delete, Move and Copy Worksheets
- 9. Enter Records to Cells
- 10. Save Workbook
- 11. Save with Different Name
- 12. Open Excel Documents
- 13. Copy and Move Cell Data
- 14. Copy Numbers
- 15. Using Fill Handle
- 16. Insert Columns and Rows
- 17. Insert Cells
- 18. Column Width and Row Height
- 19. Edit Cell Content
- 20. Workbook Views
- 21. Wrap Text
- 22. Merge and Center Cells
- 23. Basic Formatting
- 24. Create Formula by Entering Numbers
- 25. Create Formula by Entering Cell Address
- 26. Use Autofill Handle to Copy Formula
- 27. Using Sum Function to Find Average
- 28. Using Average Function to Find Average
- 29. Change Decimal Positions
- 30. Format Worksheet Adding Borders and Fill
- 31. Cell Alignment
- 32. Using Autofilter
- 33. Remove Autofilter
- 34. Use Format as Table
- 35. Customize Formatting
- 36. Alignment and Number Format
- 37. Save Formatted Worksheet
- 38. Freez Pans in Worksheets
- 39. Remove Duplicate Records
- 40. Remove Duplicate Using Advanced Filter Option
- 41. Using Conditional Formatting
- 42. Creating new Conditional Formatting Rules
- 43. Using Conditional Formatting Rules Manager
- 44. Using the Insert Tab
- 45. Insert Pictures
- 46. Picture Adjustments Using Picture Tools
- 47. Add Picture Styles
- 48. Crop Images
- 49. Using Cliparts
- 50. Insert Shapes