Excel Tutorial | Learn Microsoft Excel Online For Free

excel-tutorial-excel-training-how-to-use-excel

Excel Tutorial | Learn Microsoft Excel Online For Free

Microsoft excel is a powerful tool maintain the data in a spreadsheet. In this excel tutorial, you learn how to use Microsoft excel along with excel formulas. This excel tutorial will covers almost everything about Microsoft excel from excel basics to advanced excel tutorial.

 

Useful Excel For Beginners

In this course, you will learn the basics of Microsoft excel and become an effective user. You will learn the fundamentals of excel. You don’t need previous experience for this course. This course will covers the topics that you need to know to become a functional user.

Course Outlines:

  1. Introduction
  2. Basics of Excel
  3. Workbooks and Worksheets
  4. Fundamentals
  5. How to Enter data
  6. Auto Fit
  7. Keyboard Navigation
  8. Auto Complete
  9. Entering Numbers
  10. Navigating edges
  11. Navigating – First and last used cells
  12. Selecting cells – Introduction
  13. Selecting cells – Shift + Arrow
  14. Selecting cells – Ctrl + Shift + Arrow
  15. Selecting cells – Mouse Click and Drag
  16. Selecting cells – Mouse Click and Shift Click
  17. Selecting cells – All Cells & Used Cells
  18. Selecting cells – Rows and Columns
  19. Selecting cells – Non-contiguous cells
  20. Selecting cells – Summary
  21. Number Formatting – Introduction
  22. Number Formatting – General and Text
  23. Number Formatting – Number and Fraction
  24. Number Formatting – Currency
  25. Number Formatting – Accounting
  26. Number Formatting – Percentage
  27. Number Formatting – Date
  28. Number Formatting – Time
  29. Number Formatting – Summary
  30. Inserting and deleting Rows, Columns and Cells
  31. Formatting – Introduction
  32. Formatting – Bold, Italics and Underline
  33. Formatting – Border
  34. Formatting – Fill and Font
  35. Formatting – Alignment
  36. Formatting – Format Painter and Clear Formats
  37. Editing – Editing Cell Content
  38. Editing – Multiple Lines of Text
  39. Editing – Ctrl + Enter
  40. Editing – Autofill
  41. Editing – Copy and Paste
  42. Editing – Cut and Paste
  43. Editing – Autofill Series
  44. Editing – Sort
  45. Editing – Filter
  46. Editing – Find and Replace
  47. Saving – Saving Excel documents
  48. Viewing – Freeze Panes
  49. Calculations – Introduction to Formula
  50. Editing Formula
  51. Introduction to Functions
  52. Entering Functions
  53. Types of Functions
  54. MIN, MAX and AVERAGE Functions
  55. Copying Formula
  56. Cell References
  57. Paste Formula
  58. Counting Functions
  59. Lookup Functions
  60. Date Functions
  61. Text Functions
  62. SUMIF Function
  63. IF Function
  64. Errors
  65. Calculations – Summary
  66. Introduction to Charts
  67. Creating a Chart
  68. Chart Components – Labels
  69. Chart Components – Background
  70. Chart Components – Axes
  71. Chart Components – Format and Design
  72. Chart Types
  73. Introduction to Conditional Formatting
  74. Conditional Formatting – Format All Cells
  75. Conditional Formatting – Format Only Cells
  76. Conditional Formatting – More Rule Types
  77. Conditional Formatting – Formula Based
  78. Conditional Formatting – Summary
  79. Illustrations
  80. Introduction to PivotTables
  81. Creating PivotTable
  82. PivotTable Summarization Types
  83. PivotTable Tools
  84. PivotCharts
  85. Creating a Table
  86. Tables – Functionality
  87. Save & Send
  88. Printing
  89. Conclusion

 

Enroll Now

 

Hope this free course will help you to develop your career as well as yourself. Also Checkout other Free Udemy Course and Let me know your opinion and share it with your friends. In future, i will provide review on more courses available out there. Stay connected with this blog and stay updated.

Nahidur Rahman Rifath

Passionate Software Engineer, Content Writer, Reader

3 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *