Excel for Beginners

Excel for Beginners

Excel is a powerful tool for organizing data and performing basic to complex mathematical calculations. Large amounts of data can be represented as charts or graphs for easy presentation or for analyzing and making predictions based on the data. It is used to manage data to help you be more organized and get work done faster.
Excel is not only used by accountants - it is used by students, office workers, teachers, business owners, and even scientists. It is a very in-demand skill and necessary in almost every job sector.
In this course, you will learn the basics of excel from understanding conditional formatting to using functions such as SUM, MIN, etc.
This course is taught through a combination of video lectures and quizzes.
.

Last Update 05/22/2020
Completion Time 2 hours 14 minutes
Members 530
    • 01. Introduction of the Course
    • 02. Familiarize with Excel Interface
    • 03. Familiarize with Excel Interface Continued
    • 04. Application of Navigation and Selection Tools
    • 05. Exploring Data Entry and Data Editing
    • 06. Uses of Fill Handle
    • 07. Managing Rows, Columns, and Cells Insert and Delete
    • 08. Managing Rows, Columns, and Cells Hide and Resize
    • 09. Uses of Font Formatting
    • 10. Format Painter
    • 11. Application of Alignment Tools
    • 12. Number Formatting
    • 13. Conditional Formatting
    • 14. Finding and Replacing Data
    • 15. Sorting
    • 16. Filtering
    • 17. Application of Freeze Pane
    • 18. Formulas
    • 19. Functions SUM and AUTO SUM
    • 20. Functions SUBTOTAL, AVG, MIN, and MAX
    • 21. Absolute Cell References
    • 22. Calculations Across Sheets
    • 23. Different Paste Options in Excel
    • 24. Basic Chart Types
    • 25. Editing Charts
    • 26. Print Preview, Orientation, margins, and Scale
    • 27. Page Breaks
    • 28. Keyboard shortcuts, adding comments and saving to PDF
    • 29. Conclusion
    • Assessment and Certificate