● Learn essential features such as creating, formatting, and managing worksheets and workbooks effectively.
● Explore data manipulation tools like sorting, filtering, and summarizing to extract meaningful insights.
● Delve into advanced features and functionalities of Excel, such as conditional formatting, pivot tables, and data visualization.
● Engage in practical exercises and real-world case studies to apply learned concepts and techniques.
● Develop problem-solving skills by tackling diverse business scenarios and data analysis challenges.
Online
4 Weeks
IITM Pravartak Technologies Foundation
Technology Innovation Hub (TIH) of IIT Madras
and
Internshala
Rs. 1349 (Inclusive Taxes)
Students must have completed 12th grade
● Knowledge of English language.
● Internet connectivity.
● Desktop/Laptop with a minimum 1 GB RAM and Windows 8 or later (64 bit).
Self paced (Suggested 1hr/day)
Tripta Singh
• Get Started with Internshala Trainings
• Introduction to Excel
• orientation/Tour
• Interface & Terminology
• Excel Worksheets
• Excel Ribbon
• Backstage View
• Quick Access Toolbar
• Keyboard Shortcuts
• Cell Basics
• Modifying Cells/Rows/Columns
• Basic Cell Formatting
• Cell Number Formats
• Cut, Copy & Paste
• Format Painter
• Personalizing Worksheets
• Multiple Worksheets
• Find & Replace
• Sheet Protection
• Printing & Page Layout
• Introduction
• Basic Formulas
• Advanced Formulas
• Cell References
• Excel Functions
• Date/Time Functions
• Text Functions
• Financial Functions
• Logical Functions
• Lookup Functions-1
• Lookup Functions-2
• Data Validation
• Troubleshooting
• Working with data
• Freezing Options
• Data Sorting
• Data Filtering
• Tables
• Charts
• Conditional Formatting
• What-If Analysis
• Pivot Tables
• The End