Microsoft Excel

5.0
10 Hours Professional Tamil

What You'll Learn

  • Introduction to Excel
  • Formatting and Editing
  • Formulas & Functions
  • Lookup & Reference
  • Logical Functions
  • Data Management & Analysis
  • Charts & Graphs
  • Finalizing & Printing

Requirements

  • Basic Computer Operating Skills
  • MS Excel Installation

Tools & Technologies

MS Excel MS Excel

Course Description

Master Excel from beginner to advanced with this complete Tamil course. Learn data handling, formulas, functions, dashboards, and real-world analysis techniques to prepare for Data Analyst and Business Analyst roles. Perfect for job seekers aiming to build strong, industry-ready Excel skills.

Course Curriculum

7 modules • 69 lessons
Module 1: Excel Basics 6 lessons • 30m 40s
  • Introduction to Excel 1m 16s
  • Creating a New Workbook 1m 05s
  • Saving a Workbook 5m 53s
  • Opening a Workbook 1m 40s
  • Excel Interface Tour 5m 30s
  • Data Entry & Data Types Concept 15m 16s
Module 2: Formatting & Editing 17 lessons • 2h 04m
  • Clipboard Operations 18m 29s
  • Font Formatting 7m 59s
  • Borders 9m 00s
  • Fill & Font Colors 4m 33s
  • Alignment 3m 02s
  • Indentation 2m 47s
  • Text Orientation 2m 37s
  • Wrap Text & Shrink to Fit 5m 33s
  • Merge Cells 9m 02s
  • Data Types (Number, Currency, Date) 14m 40s
  • Insert Cells, Rows, Columns & Sheets 4m 03s
  • Delete Operations 4m 56s
  • Row Height & Column Width 5m 55s
  • Hide & Unhide 6m 29s
  • Organize Sheets 8m 32s
  • Hyperlinks 17m 07s
  • Cell Styles u2014
Module 3: Formulas & Functions 18 lessons • 2h 11m
  • Basic Math Operations 13m 24s
  • Rounding Functions 15m 04s
  • Generating Numbers 8m 07s
  • Absolute & Sign Values 1m 44s
  • Aggregate Functions 7m 37s
  • Text Extraction (Left, Right, Mid) 7m 32s
  • Text Before & After 17m 21s
  • Text Split 10m 10s
  • Text Position (Find, Search, Len) 6m 34s
  • Concatenation 7m 23s
  • Text Case (Upper, Lower, Proper) 1m 51s
  • Replace & Substitute 6m 18s
  • Trim Function 3m 09s
  • Date & Time Functions 6m 23s
  • DateValue & TimeValue 1m 51s
  • Extracting Date/Time Parts 5m 36s
  • Date Difference & NetworkDays 6m 38s
  • Date Addition & EOMonth 3m 56s
Module 4: Lookup & Logical Functions 10 lessons • 1h 19m
  • VLOOKUP 6m 54s
  • HLOOKUP 2m 37s
  • LOOKUP Function 3m 50s
  • XLOOKUP 9m 48s
  • INDEX & MATCH 14m 00s
  • Comparison Operators 5m 51s
  • Comparison Functions 9m 02s
  • IF Function 12m 09s
  • Multiple Conditions (IFS, SWITCH) 15m 31s
  • Logical Operators (AND, OR, XOR) 23m 16s
Module 5: Data Analysis 7 lessons • 1h 59m
  • Excel Tables 14m 55s
  • Filtering & Sorting 20m 59s
  • Slicers 11m 15s
  • Conditional Formatting 24m 26s
  • Pivot Tables 16m 16s
  • Timelines 11m 55s
  • Pivot Charts 19m 39s
Module 6: Charts & Visualization 3 lessons • 20m
  • Column & Bar Charts 9m 19s
  • Pie & Doughnut Charts 4m 21s
  • Line & Area Charts 4m 55s
Module 7: Finalizing & Printing 8 lessons • 1h 08m
  • Proofing (Spell Check) 12m 03s
  • Comments & Notes 5m 53s
  • Protection (Sheet & Workbook) 15m 06s
  • Page Layout & Margins 2m 52s
  • Scaling & Printing 4m 55s
  • Print Area 2m 17s
  • Page Breaks 3m 02s
  • Print Titles u2014

Your Instructor

Parthiban Kannan

Parthiban Kannan

Co-founder & Manager

4 Courses

14+ years of experience in digital transformation, leading teams of 15+ members and delivering 160+ projects for organizations like Lakshmi Machine Works, Milacron, Schneider Electric, Aatomz Research, and Variablz Technologies. AI innovator with a patent approved by the Government of India, with strong expertise in Data Science, Data Analysis, Business Intelligence, and Software Development.

FAQ

Frequently Asked Questions

Is this course suitable for beginners?

Yes, it starts from basics and gradually moves to advanced data analysis concepts.

Do I need any prior knowledge of Excel?

No prior experience is required. Everything is explained from scratch.

In which language is the course taught?

The course is delivered completely in Tamil for easy understanding.

Will I learn advanced Excel functions?

Yes, including VLOOKUP, XLOOKUP, INDEX-MATCH, IF, Pivot Tables, and more.

Is this course useful for Data Analyst roles?

Yes, it covers essential Excel skills required for Data Analyst and Business Analyst jobs.

Will there be practical examples?

Yes, the course focuses on real-world use cases and hands-on practice.

Can I use this course for job preparation?

Absolutely, it is designed to build job-ready Excel skills.

Will I learn data visualization in Excel?

Yes, charts, graphs, and dashboards are covered in detail.