Complete Microsoft Excel Course 2021: Beginner to Advanced
This course is a more recent Microsoft Excel course, Microsoft Excel 2021. This online course on Microsoft Excel will teach you all you need to know to become a pro-Excel user. You do not need prior knowledge of Excel to take this course. The course is designed for beginners, intermediate and advanced users. This class will take you from the beginner's guide to intermediate user guide and eventually, the advanced user guide. Enrol now and equip yourself with Microsoft Excel skill.
$9.26
$27.78
7-Day Money-Back Guarantee
1-Year Access
1-Year Access
Course Includes:
- Downloadable resources
- 8 Hours Video Class
- Free Certificate of Completion
Complete Microsoft Excel Course 2021: Beginner to Advanced
44 students enrolled 
83 lectures
Self-paced onlineThis course is a more recent Microsoft Excel course, Microsoft Excel 2021. This online course on Microsoft Excel will teach you all you need to know to become a pro-Excel user. You do not need prior knowledge of Excel to take this course. The course is designed for beginners, intermediate and advanced users. This class will take you from the beginner's guide to intermediate user guide and eventually, the advanced user guide. Enrol now and equip yourself with Microsoft Excel skill.
What you will learn
- Mastering the use of some of Excel’s most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, MATCH and many more…)
- Audit Excel Worksheet formulas to ensure clean formulas
- Creating effective spreadsheets
- Managing large sets of data
- Create dynamic report with Excel PivotTables and so much more!
Requirements
This course on Microsoft Excel is designed for beginners, intermediate and advanced users. No special skill is required for you to take this course. Anyone can take this course!
Course Description
This course is a more recent Microsoft Excel course, Microsoft Excel 2021. Microsoft Excel is a helpful and powerful program for data analysis and documentation, it is also one of the most popular tools used to organize data. It is a spreadsheet program, which contains a number of columns and rows, where each intersection of a column and a row...
$9.26
$27.78
7-Day Money-Back Guarantee
1-Year Access
1-Year Access
Course Includes:
- Downloadable resources
- 8 Hours Video Class
- Free Certificate of Completion
Course Content
- 1. Excel - The BasicsPreview15 Mins
- 2. Excel - Create & Close FilesPreview4 Mins
- 3. Excel - Tabs and Group8 Mins
- 4. Excel - Editing Data15 Mins
- 5. Excel - Formatting18 Mins
- 6. Excel - Characteristics of Cell2 Mins
- 7. Excel - Cell Referencing12 Mins
- 8. Excel - Speak Cells9 Mins
- 9. Excel - Text to Column7 Mins
- 10. Excel - Comments5 Mins
- 11. Excel - Copying and Filling11 Mins
- 12. Excel - Fill Series3 Mins
- 13. Excel - Advanced Fill8 Mins
- 14. Excel - Flash Fill5 Mins
- 15. Excel - Viewing Worksheet10 Mins
- 16. Excel - Custom View5 Mins
- 17. Excel - Adjusting Worksheets10 Mins
- 18. Excel - Working with Worksheets11 Mins
- 19. Excel - Compare Two Sheets6 Mins
- 20. Excel - View Files Side by Side6 Mins
- 21. Excel - Logical Test5 Mins
- 22. Excel - IF Function8 Mins
- 23. Excel - Nested IF6 Mins
- 24. Excel - AND Functions6 Mins
- 25. Excel - NOT And If Error5 Mins
- 26. Excel - Auditing Tools9 Mins
- 27. Excel - Text Functions16 Mins
- 28. Excel - Date Functions Pt. 111 Mins
- 29. Excel - Date Functions Pt. 210 Mins
- 30. Excel - Date Functions Pt. 36 Mins
- 31. Excel - Name Range6 Mins
- 32. Excel - Name Range with Formulas10 Mins
- 33. Excel - Basic Formulas8 Mins
- 34. Excel - Count Functions7 Mins
- 35. Excel - Statistical Functions11 Mins
- 36. Excel - Vlookup with Exact Match8 Mins
- 37. Excel - Vlookup Approximately Match6 Mins
- 38. Excel - Vlookup with Trim8 Mins
- 39. Excel - H-Lookup2 Mins
- 40. Excel - Vlookup Rules6 Mins
- 41. Excel - Lookup Full Record6 Mins
- 42. Excel - Index Function6 Mins
- 43. Excel - Match Function2 Mins
- 44. Excel - Protect Cells6 Mins
- 45. Excel - Protect Sheets4 Mins
- 46. Excel - Protect File3 Mins
- 47. Excel - Protect Workbook2 Mins
- 48. Excel - Hyperlink to Sheet5 Mins
- 49. Excel - Hyperlink to File3 Mins
- 50. Excel - Hyperlink to Webpage6 Mins
- 51. Excel - Header and Footer12 Mins
- 52. Excel - Print Page Setup18 Mins
- 53. Excel - Data Sorting10 Mins
- 54. Excel - Advanced Filters7 Mins
- 55. Excel - Filtering Data13 Mins
- 56. Excel - Basic Table8 Mins
- 57. Excel - Advanced Table9 Mins
- 58. Excel - Subtotal6 Mins
- 59. Excel - Column Chart11 Mins
- 60. Excel - Design a Column Chart Pt. 17 Mins
- 61. Excel - Design a Column Chart Pt. 219 Mins
- 62. Excel - Pie, Bar, Column and Line Chart11 Mins
- 63. Excel - XY Chart15 Mins
- 64. Excel - Spark Line Chart9 Mins
- 65. Excel - Pivot Chart11 Mins
- 66. Excel - Pivot Table Example I18 Mins
- 67. Excel - Pivot Table Example II9 Mins
- 68. Excel - Pivot Table Example III8 Mins
- 69. Excel - Pivot Table Example IV6 Mins
- 70. Excel - Pivot Table Example V11 Mins
- 71. Excel - Pivot Table Example VI8 Mins
- 72. Excel - Consolidation12 Mins
- 73. Excel - Consolidation Extended8 Mins
- 74. Excel - Conditional Formatting Pt. 115 Mins
- 75. Excel - Conditional Formatting Pt. 29 Mins
- 76. Excel - Advanced Conditional Formatting10 Mins
- 77. Excel - Data Validation Pt. 116 Mins
- 78. Excel - Data Validation Pt. 210 Mins
- 79. Excel - Inserting Objects5 Mins
- 80. Excel - Creating Objects5 Mins
- 81. Excel - Shortcuts Ctrl+A to Ctrl+Z16 Mins
- Final RemarkPreview1 Mins
- Resource Files23 Mins
About the Instructor
4.5 Stars Rating
1813 Students
36 CoursesThe traditional method for training and skill enhancement in Africa is realistically not accessible to the vast majority who need it, and this is why we are doing this. DoviLearn is an online learning platform delivering top-quality courses (online) for skill enhancement in Africa. Join thousands of professionals, entrepreneurs, freelancers, researchers, and C-level executives in our community. Study at your...
Rating & Reviews
5%
KA
Kelvin afamefune
Kudos to the facilitator
$9.26
$27.78