
Explore module 2 basics in Excel, applying currency formats (including rupees), percentages, decimals, and styles to highlight duplicates, top and bottom values, with sorting and filtering in tables.
Learn essential editing tools in Excel, including sum, average, count, max, and min. Manage data with clear contents, comments, notes, and hyperlinks, and practice sorting and tables.
This introductory course will help you understand the basics of Excel. A great start for beginners of all age groups and youngsters to benefit from this software in school, college, personal life and professional life. Modules are designed in such a way to get a practical learning experience with a number of exercises for practice. The module is for beginners who have just started their journey in learning excel. You need not have any prior working knowledge of Excel to undertake this course. The course will enable you to work with excel by sorting, storing, aligning data into meaningful information. Some of the topics covered include:
Creating Worksheets
Formatting data
Aligning data
Number formats
Conditional formatting
Inserting / Deleting cells
Sorting and filtering data
Basic mathematical operations on data
Viewing and printing sheets
The content has been divided into a number of modules to help you grasp the basics and ponder over it. It is recommended that you do some hands on practice after each module to get a stronghold on the contents of the module.
At the end of all modules, you will find an assignment to work through and practice all that you have learnt. Feel free to write back with any doubts or clarifications or further learnings you may have. Happy to assist! Enjoy your learning!