Skip to content
Sabaqاردو

Google Sheets for Data Analysis in Urdu (Codanics)

By Codanics

Course audio
Course audio: Urdu
Level
Beginner
Length
49 lessons · 11 hours

What you'll be able to do

  • Import and clean data into tables in Google Sheets
  • Choose and build the right chart for a dataset
  • Summarise data with pivot tables and lookup and logical functions
  • Collaborate and track changes with version history

About this course

Codanics' free Google Sheets course in Urdu/Hindi: about 50 lessons, 11 hours, with small tasks and a quiz for students. It starts with Sheets as a free Excel alternative and real-time collaboration, then file formats, importing data, converting raw data into tables and column stats. A large part is charts: bar, pie, sparkline, area, line, scorecard, scatter and bubble, plus pivot tables with dynamic charts. Later lessons cover univariate to multivariate analysis, the XLMiner ToolPak, formulas, IF, AND, OR, LOOKUP, VLOOKUP and HLOOKUP, version history, offline use, regional settings and everyday editing. Suits Pakistani students and office workers starting data analysis with no paid software.

Before you start: A Google account

Syllabus

49 lessons · 11:02:28 in total

  1. 1Google Spreadsheets Complete Course in Urdu / Hindi | Free on Codanics YouTube1:31
  2. 2Google Spreadsheets as a Free Alternative to Microsoft Excel for Data Analysis8:07
  3. 3Collaborative Work on Google Spreadsheets with Your Colleagues | Real-Time Team Editing Tutorial9:13
  4. 4Data Visualization and Chart Types | Understanding Parts and Components of a Chart/plot27:25
  5. 5Convert Raw Data into Tables in Google Spreadsheets | Simple Data Formatting Tutorial23:45
  6. 6Data Analysis in Google Spreadsheets with Column stats option | Quick Data Analysis24:19
  7. 7Important File Formats for Data Analysts | CSV, TSV, TXT, and XLSX Explained20:42
  8. 8Import Data into Google Spreadsheets — Different Methods Explained6:19
  9. 9Google Sheets Charts Explained | Create Stunning Data Visualizations20:12
  10. 10Real World Data vs Dummy Data | Mapping World Populations | Use Real Data for Better Projects22:44
  11. 11Data Visualization Bar Chart in Google Sheets | Customize Simple Bar Charts Easily27:13
  12. 12Pie Charts in Google Sheets | Understand Percentages for Better Logic Building17:40
  13. 13What is Percentage? | Learn How to Calculate Percentage with Real Life Examples in Urdu / Hindi36:26
  14. 14How to Write a Formula in Google Sheets? | Calculate Percentage in Google Spreadsheet with Example12:04
  15. 15SPARKLINE Bar Chart in Google Sheets | Data Visualization in Google Sheets using SPARKLINE Function2:56
  16. 16Understanding How to Interpret the Data in Google Sheets using Plots (Urdu/Hindi Tutorial)7:38
  17. 17Understanding Data with Pivot Tables and Dynamic Charts38:43
  18. 18Create Area Charts in Google Sheets | Data Visualization Tutorial5:20
  19. 19Create Line Charts in Google Sheets | Data Visualization Tutorial1:59
  20. 20Create a Scorecard Chart in Google Sheets | Data Visualization Tutorial8:01
  21. 21Create a Scatter Plot in Google Sheets | Data Visualization Tutorial2:59
  22. 22Create Bubble Charts in Google Sheets | Data Visualization Tutorial6:54
  23. 23Dimensions of Data: Univariate, Bivariate, and Multivariate Analysis | Data Analysis Explained19:26
  24. 24Uni-, Bi-, and Multi-variate Analysis in Google Sheets | Report Preparation in Google Slides48:30
  25. 25Matrices in Data Analysis and Multivariate Analysis | Understanding Data with Examples in Urdu18:49
  26. 26Google Sheets Extensions: XLMiner Analysis ToolPak | Data Analysis Made Easy in Urdu16:13
  27. 27Writing Formulae & Codes in Google Sheets for Data Analysis | Learn From Zero (Urdu)43:22
  28. 28Formulae & Codes for Tables in Google Sheets | Learn Table Analysis from Zero14:28
  29. 29Major Functions in Google Sheets for Data Analysis | Complete Beginner to Advanced Guide40:05
  30. 30Logical Functions (IF, AND, OR) in Google Sheets for Data Analysis | Complete IF–ELSE Tutorial17:46
Show all 49 lessons
  1. 31Basic view settings in google sheets for freezing panes9:07
  2. 32Google Sheets Working Version History | How to Track Changes and Restore Versions4:17
  3. 33Make Google Sheets Available Offline Using This Extension | Easy Guide4:02
  4. 34Fill Methods in Google Sheets for Productive Work | Boost Your Efficiency5:09
  5. 35Drag, Drop, Move, and Undo/Redo Functions in Google Sheets | Easy Tutorial2:51
  6. 36Insert or Remove Rows and Columns in Google Sheets | Step-by-Step Guide4:21
  7. 37Setting Width of Columns and Rows in Google Sheets | Easy Tutorial1:55
  8. 38Arithmetic operations in google sheets with DMAS and BODMAS rule of mathematics26:50
  9. 39Role of Order and Parentheses in Google Spreadsheets | Why Brackets Are Important in Functions2:37
  10. 40Regional Formatting of Google Sheets for Numbers, Dates, and Currency Format | Easy Guide10:48
  11. 41System Regional and Language Settings May Affect Google Spreadsheet Formatting | How to Fix1:14
  12. 42Task for students for this week which is important1:47
  13. 43Best Resources to Learn Google Sheets | W3Schools & GeeksforGeeks Tutorial Guide8:05
  14. 44AND Logical Function in Google Sheets | Logical Tests for Data Analysis3:22
  15. 45OR Logical Function in Google Sheets | Test Multiple Conditions Easily1:48
  16. 46LOOKUP Function in Google Sheets | Search Values Easily in Your Data2:05
  17. 47VLOOKUP Function in Google Sheets | Search & Match Data Like a Pro15:40
  18. 48HLOOKUP Function in Google Sheets | Horizontal Lookup Explained2:09
  19. 49COUNTBLANK function in google spreadsheet to count missing values3:32

What to take next

Videos by Codanics, played from their official YouTube channel. Subscribe on YouTube

Official upload by the teacher or institution on their own channel, shown with YouTube's embedded player.

Lessons listed from the official YouTube playlist. Full playlist on YouTube

Lessons last checked Oct 2026. Course summary and lesson structure by Sabaq.

Report a problem or a rights request