Microsoft Excel - Excel from Beginner to Advanced
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
1-Year Access
Course Includes:
- 8 Hours Video Class
- Downloadable resources
- Free Certificate of Completion
Microsoft Excel - Excel from Beginner to Advanced
1467 students enrolled 
51 lectures
Self-paced onlineThis 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
- Creating effective spreadsheets
- Managing large sets of data
- Mastering the use of some of Excel’s most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, MATCH and many more…)
- Create dynamic report with Excel PivotTables
- Audit Excel Worksheet formulas to ensure clean formulas
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
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 is a “cell.” Each cell contains one point of data or one...
$9.26
$27.78
1-Year Access
Course Includes:
- 8 Hours Video Class
- Downloadable resources
- Free Certificate of Completion
Course Content
- 1. Understanding Excel User InterfacePreview16 Mins
- 2. Understanding Excel Workbook and Worksheets11 Mins
- 3. Expaining the Ribbon12 Mins
- 4. Saving an Excel File5 Mins
- 5. Combined what you can enter in a Cell7 Mins
- 6. Entering Formula4 Mins
- 7. Copy and Drag3 Mins
- 8. Working with Rows and Columns23 Mins
- 9. Working with Sheets9 Mins
- 10. Using NameRangePreview8 Mins
- 11. Name Range with Formulas10 Mins
- 12. Functions10 Mins
- 13. SUM Functions5 Mins
- 14. Copy and Drag Formula4 Mins
- 15. More Basic Functions5 Mins
- 16. Font Formatting6 Mins
- 17. Formatting Alignment6 Mins
- 18. Formatting Borders6 Mins
- 19. Formatting Numbers7 Mins
- 20. Icons Shapes and Formatting18 Mins
- 21. Printing Page Layout16 Mins
- 22. Printing Headers and Footers6 Mins
- 23. Sorting Data8 Mins
- 24. Filtering Data9 Mins
- 25. Tables10 Mins
- 26. Grouping and Outline7 Mins
- 27. Freeze Panes4 Mins
- 28. Using the IF Functions PT. I18 Mins
- 29. Using the IF Functions PT. II4 Mins
- 30. Using the CountIF14 Mins
- 31. Using the SumIF9 Mins
- 32. Using Left Right and Mid6 Mins
- 33. Using the LEN Function5 Mins
- 34. How to use VLOOKUP with Exact Match14 Mins
- 35. VLOOKUP with Approximately Match6 Mins
- 36. VLOOKUP with TRIM9 Mins
- 37. The Charting Process4 Mins
- 38. Choosing the right chart8 Mins
- 39. Using the Recommended Charts4 Mins
- 40. Creating a New Chart from Scratch4 Mins
- 41. Creating a New Chart Sheet2 Mins
- 42. Walking through all the chart options8 Mins
- 43. How to change Chart Type4 Mins
- 44. Pivot Table Example PT. I25 Mins
- 45. Pivot Table Example PT. II8 Mins
- 46. Pivot Table Example III8 Mins
- 47. Pivot Table Grouping6 Mins
- 48. Pivot Table Slicer14 Mins
- 49. Pivot Table Timeline9 Mins
- 50. Pivot Chart6 Mins
- Some Excel ResourcesMins
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
4.1%
TK
Tobi Kolawole
I love all the course and its really added values to my life
KAB
Khalil Abimbola Babalola
The lecture is good and valuable but the audio is consistently breaking , i mean starting and stopping consistently. The learning is not seamlessly flowing
BO
Bright Oleka
This course is great. I highly recommend it.
TB
Temitope Bayode
Glad i took this excel course, what a great way to start the new year for me.
Thank you for the impact, it's worth every bit of my time..
BT
Boris Taylor
Fantastic lessons, well packaged and brief.
OA
Olanrewaju Azeez
Av not been able to access the video even when av paid.pls unlock the video for me
GHY
Gideon Haruna Yusuf
The Course interesting and impacting.
AO
Alex Omoniyi
Excellent service
$9.26
$27.78