Welcome

Thanks for visiting our website which offers you complete and easy tutorials on Microsoft office Excel, Word, and Outlook. This tutorial site is completely perfect for beginners, intermediate and advanced users. You’ll find here all basics and advanced topics that every ms office users may know through our step by step and practical example. Know more about us here.

Excel 2010

Basic :

This section helps you to know Excel Basic at a glance. Read the following topics.

1. Keyboard Shortcuts 2. Quick Access Ribbon 3. Replace Cell Content 4. Edit Cell Content 5. Plance information into Multiple cells 6. Insert Decimal Points 7. Autofill Value 8. Format Cells 9. Open Multiple Worksheet 10. Add New Worksheet 11. Delete Worksheet 12. Rename Worksheet 13. Change Sheet Tab Color 14. Move / Copy Worksheet 15. Hide Unhide Worksheet 16. Open Worksheet in Multiple Windows 17. Split Workshhet into Panes 18. Freezing Panes 19. Monitor Cell 20. Insert Rows & Column 21. Delete Rows & Column 22. Hide Rows & Columns 23. Unhide Rows & Columns 24. Change Row height 25. Change Width of Column 26. Select Cells and Ranges 27. Select Complete Rows and Columns 28. Select Ranges from Multiple Sheets 29. Select Special Cells 30. Select Cells by Searching 31. Move Cells and Ranges 32. Copy Cell 33. Copy/Move cell by using Mouse 34. Copy Cell to adjacent Cell 35. Copy/Move cells to other sheets 36. Copy Visible Cells 37. Prevent copied Blank Cells 38. Move/Copy Contents 39. Copy & Paste Cells 40. Paste Cells using Clip Board 41. Paste Special 42. Transpose Cells 43. Define Cell Name 44. Manage Cell Name 45. Delete Cell Name 46. Edit Cell Name 47. Add Comments 48. Format Comments 49. Change Text Direction 50. Change Text Rotation 51. Change Text alignment 52. Wrap Text 53. Merge Cell 54. Change Text Color 55. Add border & Lines in cell 56. Clear Cell Contents 57. Create Table 58. Difference: Table & Range 59. Table Style 60. Delete Table 61. Move Table 62. Total Row of Table 63. Remove Duplicate Rows from Table 64. Sorting & Filtering Data from Table 65. Add background Image 66. Apply Cell Style 67. Cell Color 68. Customize Cell Style 69. Change Cell Sytle 70. Change Font Size 71. Enter Data using form 72. Create New Workbook 73. Change Worksheet Color 74. Protect Worksheet with Password 75. Workbook Password 76. Workbook Password Protection 77. Superscript, subscript & strikethrough 78. Print Gridlines 79. Insert Water Mark 80. Print Workbook 81. Insert Page Breaks 83. Set Print Area 84. Add Header and Footer 85. Add custom Header or Footer 86. Copy Page Setup

Find more basic Excel tips

Formulas & Functions :

Without Formulas & Functions, Excel is nothing more than Word Processor. Due to Excels capability to calculate formula and specified functions, it makes Excel a great tool for financial, accounting and Engineering data analysis with great presentation capabilities.

1. ISTEXT 2. TYPE 3. 3. CHAR 4. EXACT 4. TEXT Function 4. Lock Formula