Master Excel in Telugu
From Basic Excel to Advanced Excel - Learn Practical Skills for Real Office Work
Stop struggling with Excel. Start working confidently.
Learn Excel step-by-step in simple Telugu, with practical examples designed around the kind of tasks students and employees encounter in real-world office work.
Whether you are a student, fresher, job seeker, or working professional, this course will help you build practical Excel skills from the fundamentals to advanced topics.
by Pillala Eliyaz
112 Detailed Lessons
2K + reviews (4.9 of 5)
Is Excel Making Your Work Difficult?
Do you face any of these problems?
- Spending too much time preparing Excel reports?
- Struggling to create formulas?
- Depending on someone else to complete Excel work?
- Finding it difficult to work with large amounts of data?
- Confused about VLOOKUP, XLOOKUP, IF, SUMIFS, INDEX & MATCH and other formulas
- Don’t know how to create Pivot Tables and Professional charts?
- Want to create Excel dashboards but don’t know where to start?
- Mentioning “MS Excel” on your resume but not feeling confident when someone gives you an actual Excel task?
You are not alone.
Knowing how to enter data into Excel is different from knowing how to use Excel effectively.Â
Turn Excel Problems Into Practical Skills
Imagine receiving a large Excel file from your manager. Instead of getting confused, you know how to:
- Clean and organize the data
- Use the right formulas
- Find required information quickly
- Analyze hundreds or thousands of records
- Create summaries using Pivot Tables
- Build charts and reports
- Create professional dashboards
- Present information clearly
That’s the difference between knowing Excel and being confident with Excel.
Learn Excel From Basics to Advanced
You don't need to be an Excel expert before starting.
This course is structured step-by-step so that you can build your knowledge gradually.
Start with the Fundamentals.
Learn Excel basics, data entry, formatting and essential spreadsheet operations.
Build your formula skills.
Learn important Excel functions and understand when and how to use them.
Work with real data
Learn sorting, filtering, lookup techniques, data management and analysis
Create professional reports
Learn charts, Pivot Tables, dashboards and reporting techniques.
Solve practical problems.
Apply your Excel knowledge to real-world examples and assignments.
What will you learn?
Module 1
Class1: What is Excel?
Module 2
Class2.1 : Ribbon and Tabs, Quick Access Toolbar, Entering Text, Numbers and Dates
Class2.2 : Auto Fill
Class2.3 : Flash Fill
Class2.4 : How do you Select Ranges?
Class2.5 : Freeze Panes
Module 3
Class 3.1 : What is Cut, Copy, Paste? Format Painter
Class 3.2 : Paste Special Part 1
Class 3.3 : Paste Special Part 2
Class 3.4 : Paste Special Part 3
Class 3.5 : Font Formatting
Class 3.6 : Alignment
Class 3.7 : Number Formatting
Class 3.8 : Borders
Class 3.9 : Conditional Formatting Part – 1
Class 3.10 : Conditional Formatting Part – 2
Class 3.11 : Conditional Formatting Part – 3
Class 3.12 : Format as Tables and Tables
Class 3.13 : Insert and Delete
Class 3.14 : Explore Format
Class 3.15 : Clear
Class 3.16 : Themes
Module 4
Class 4.1 : Formula Basics
Class 4.2 : Formulas
Module 5
Class 5.1 : Sorting
Class 5.2 : Filter
Class 5.3 : Data Validation
Class 5.4 : Remove Duplicates
Class 5.5 : Text to Columns
Class 5.6 : Find and Replace
Class 5.7 : Named Ranges
Module 6
Class 6.1 : Column Charts
Class 6.2 : Pie Charts
Class 6.3 : Line Graphs
Class 6.4 : Bar Charts
Class 6.5 : Spark Lines
Class 6.6 : Trend Lines
Module 7
Class 7.1 : Average Function
Class 7.2 : Int Function
Class 7.3 : Mod Function
Class 7.4 : Randbetween Function
Class 7.5 : Round Function
Class 7.6 : SUM Function
Class 7.7 : ABS Function
Class 7.8 : Sign Function
Class 7.9 : Max Function
Class 7.10 : Min Function
Class 7.11 : Large Function
Class 7.12 : Small Function
Class 7.13 : Rank Function
Module 8
Class 8.1 : Concat & Concatenate
Class 8.2 : Find
Class 8.3 : Search
Class 8.4 : Left
Class 8.5 : Right
Class 8.6 Len
Class 8.7 Lower
Class 8.8 MID
Class 8.9 Proper
Class 8.10 Rept
Class 8.11 Substitute
Class 8.12 Trim
Class 8.13 Upper
Module 9
Class 9.1 Count Function
Class 9.2 CountA
Class 9.3 Count Blank
Class 9.4 CountIF
Class 9.5 CountIFS
Class 9.6 AND
Class 9.7 OR
Class 9.8 IF
Class 9.9 SUMIF
Class 9.10 SUMIFS
Class 9.11 Index
Class 9.12 Match
Module 10
Class 10.1 Day
Class 10.2 Month
Class 10.3 Year
Class 10.4 Date
Class 10.5 Second
Class 10.6 Hour
Class 10.7 Minute
Class 10.8 Minute
Class 10.9 Networkdays
Class 10.10 Weekday
Class 10.11 Today
Class 10.12 Now
Class 10.13 Edate
Class 10.14 Emonth
Module 11
Class 11.1 Column Function
Class 11.2 Row
Class 11.3 ISBlank
Class 11.4 Iserror
Class 11.5 Istext
Class 11.6 Is Number
Class 11.7 ISNA
Class 11.8 ISERR
Class 11.9 ISNontext
Module 12
Class 12.1 Lookup
Class 12.2 Vlookup
Class 12.3 Hlookup
Class 12.4 D Functions
Class 12.5 Excel Errors
Class 12.6 Xlookup
Module 13
Class 13.1 Pivot Tables
Class 13.2 Pivot Charts
Class 13.3 Slicers
Class 13.4 Dashboard Basics
Class 13.5 Interactive Reports
Module 14
Class 14.1 Introduction to VBA
Class 14.2 Recording VBA Code
Class 14.3 Running small VBA Scripts
Frequently Asked Questions
Do I need previous Excel knowledge?
No. The course starts with fundamentals and gradually moves toward advanced topics.
Is this course available in Telugu?
Yes. The course is designed for Telugu-speaking learners.
Is this course suitable for beginners?
Yes. Beginners can start from the basics and progress step-by-step.
Is this course useful for working professionals?
Yes. The course focuses on practical Excel skills that can be applied to common workplace tasks.
Will I get practical examples?
Yes. The course includes practical examples and exercises to help you understand how Excel features can be applied.
Can I learn at my own pace?
Yes. The course covers a wide range of Excel formulas and functions, including logical, mathematical, text, date/time, lookup and database functions.
Does the course cover Pivot Tables?
Yes. Pivot Tables and related reporting concepts are included.
Does the course cover dashboards?
Yes. Dashboard fundamentals and practical reporting concepts are included
Does the course cover VBA?
The course includes an introduction to VBA and few automation concepts.
Learn the Skill. Practice the Skill. Use the Skill.
Learn with Eliyaz
