Program Description

●    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.

Key Highlights

check svg

Certification of completion from Internshala.

check svg

Government approved certificate from NSDC (National Skill Development Corporation) & Skill India.

check svg

Downloadable content with lifetime access.

check svg

24*7 doubt solving forum.

check svg

Free access to ‘Internship and Job Preparation’ training.

check svg

Hand picked internships & jobs curated as per your preference in your inbox every week.

check svg

Get highlighted on Internshala and a badge of achievement in your Internshala account if you score above 90% in your final test. This badge will be shown to the employers when you apply to internships and jobs.

Learning Format

Online

Duration

4 Weeks

Certified by

IITM Pravartak Technologies Foundation
Technology Innovation Hub (TIH) of IIT Madras and
Internshala

Program Fee

Rs. 1349 (Inclusive Taxes)

Education Qualification

Students must have completed 12th grade

Suggested Prerequisites

●    Knowledge of English language.
●    Internet connectivity.
●    Desktop/Laptop with a minimum 1 GB RAM and Windows 8 or later (64 bit).

Teaching Hours

Self paced (Suggested 1hr/day)

Lead Faculty

Tripta Singh

Learning Module

•    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



Are you interested in this program?

Our Learning Partners

Want To Know More

Guiding Star with Our Help!

Contact Us