top of page
Microsoft Excel Tutorial for Complete Beginners

Microsoft Excel Tutorial for Complete Beginners

  • 49Steps
Get a certificate by completing the program.
Everyone who has completed all steps in the program will get a badge.

About

It is not about how much data you have collected, but how you process, and bring in meaning using visuals. It all begins with using the right tool. Microsoft Excel is the industry leading spreadsheet software program, a powerful data visualization and analysis tool that can help you take your data analytics to the next level. Here are the topics with numbers added in front of each item: Here are the topics with numbers added in front of each item: 1. Opening Microsoft Excel 2. Creating Excel templates 3. Overview of the Excel platform 4. Customizing the ribbons 5. Sorting in Excel 6. Transpose data 7. Adjust cell sizes 8. Format painter tool 9. Freeze panes 10. Trim data 11. Basic form in Excel 12. Mean, median, mode 13. 3D Forms in Excel 14. Show forms in Excel 15. Cell fill series 16. Creating tables 17. Quick analysis 18. Plotting charts 19. Adding second y-axis 20. Forecast function in Excel 21. Plotting pie charts 22. Plotting sparklines 23. Chart axis format 24. Hiding data in Excel 25. Pivot tables 26. Plotting pivot charts 27. Find and replace 28. Inserting hyperlinks 29. Data validation 30. Dynamic maps in Excel 31. Convert PDF to Excel 32. Header and Footer 33. Separate names 34. 20 shortcut keys 35. Camera tool 36. Change background 37. Convert Excel to PDF 38. Copy Excel data to Word 39. Adding borders 40. Break passivity 41. Creating drop-down list 42. Excel document printing 43. Creating organizational charts 44. Protecting Excel sheet 45. Taking screenshot 46. Excel free online 47. Tips and Tricks Part 1 48. Tips and Tricks Part 2 49. Tips and Tricks Part 3 50. Tips and Tricks Part 4 51. Tips and Tricks Part 5 52. Tips and Tricks Part 6 53. Tips and Tricks Part 7 54. Tips and Tricks Part 8 55. Tips and Tricks Part 9 56. Tips and Tricks Part 10 Thank you for joining this course and i look forward to interacting with you.

Overview

Already a participant? Log in

bottom of page