Google Sheets Course > Working with Data in Google Spreadsheets

Assignment : Data Cleanup Process in Google Spreadsheets

28.3k

Learner's Ratings

4.8

Overall Rating

  • 84%
  • 12%
  • 1%
  • 1%
  • 2%

Reviews

M
Mohd Akber
5

Hi, Hello Sir Nice class from the starting i attend all the Assignment but for this SUMIF and SUMPRODUCT I Can't solve the can you plz how this slove i try many time i fail

S
Sudheer Kumar
5

Thank you so much sir hindi me translate karake padahane ke liye

M
manpreet Kaur
5

hello sir sir explore meri sheet pe show nai ho raha please let me know how to work

R
ruby yadav
5

sir ye jo aap data use karte hai vo ham kaha se laye ?

S
SVC BHARATPUR
5

hy

P
PRATHIKADAPA NARSIMHARAJU
5

easy to understand

F
FEROZ KHAN
5

easy to understand the concept through one of the best tutor well done learn Vern

H
Harakrishna Maji
5

Jaspal Singh Sir very very happy with your video god bless you Sir

M
Mohammed ayman
5

NICE WAY OF EXPLANATION!! ALSO WORKFULL !

N
Noor Misbah
4

helpful

Show More
Recommended Courses
Course Content

  1. Setup Your Gmail Account
    36m 31s
  2. Getting Started with Google Drive
    9m 43s

  1. Basics of Google Spreadsheets
    21m 3s
  2. Assignment : Basics of Google Spreadsheets
    51s
  3. Modifying Cells,Rows & Columns in Google Spreadsheets
    16m 54s
  4. Assignment : Modifying Cells,Rows & Columns in Google Spreadsheets
    56s
  5. Modifying Spreadsheets
    7m 55s
  6. Assignment : Modifying Spreadsheets
    18s
  7. Cell Placements in Google Spreadsheets
    8m 19s

  1. Cell Border Formatting in Google Spreadsheets
    13m 30s
  2. Assignment : Cell Border Formatting in Google Spreadsheets
    32s
  3. Merge Cells in Google Spreadsheets
    9m 1s
  4. Hide/Unhide Rows and Columns in Google Spreadsheets
    3m 4s
  5. Cell Formatting in Google Spreadsheets
    4m 52s
  6. Assignment : Cell Formatting in Google Spreadsheets
    38s
  7. Freeze/Unfreeze Rows and Columns in Google Spreadsheets
    6m 26s
  8. Explore Feature in Google Spreadsheets
    9m 53s
  9. Assignment : Explore Feature in Google Spreadsheets
    45s
  10. Opening, Importing & Copying Files in Google Spreadsheets
    7m 58s
  11. Text Wrapping and Text Rotation in Google Spreadsheets
    5m 20s
  12. Assignment : Text Wrapping and Text Rotation in Google Spreadsheets
    39s
  13. Using Google's Inbuilt Template Gallery
    26m 33s

  1. Basic Math Formulas in Google Spreadsheets
    18m 27s
  2. Assignment : Basic Math Formulas in Google Spreadsheets
    30s
  3. 'Sum' and 'Sumif' Formulas in Google Spreadsheets
    19m 28s
  4. Assignment : 'Sum' and 'Sumif' Formulas in Google Spreadsheets
    1m 11s
  5. 'Sumifs' and 'Sumproduct' Formulas in Google Spreadsheets
    10m 17s
  6. Assignment : 'Sumifs' and 'Sumproduct' Formulas in Google Spreadsheets
    1m 8s
  7. 'Count' Formulas in Google Spreadsheets
    20m 20s
  8. Assignment : 'Count' Formulas in Google Spreadsheets
    39s
  9. 'If' Function in Google Spreadsheets
    18m 48s
  10. Assignment : 'If' Function in Google Spreadsheets
    34s
  11. Basic Billing System with Nested 'If' in Google Spreadsheets
    38m 28s
  12. Creating Report Card with Help of Google Spreadsheets
    33m 31s
  13. Applying Alternating Colors to Google Spreadsheets
    7m 17s
  14. Conditional Formatting in Google Spreadsheets
    16m 55s
  15. Filter Data in a Google Spreadsheets
    17m 43s
  16. Assignment : Filter Data in a Google Spreadsheets
    55s

  1. Find & Replace in Google Spreadsheets
    7m 12s
  2. Assignment : Find & Replace in Google Spreadsheets
    27s
  3. Cut, Copy, Paste, Undo, Redo in Google Spreadsheets
    10m 25s
  4. Assignment : Cut, Copy, Paste, Undo, Redo in Google Spreadsheets
    59s
  5. File Menu and View Menu in Google Spreadsheet
    20m 43s
  6. Assignment : File and View Menu in Google Spreadsheet
    44s
  7. Share, Email and Download Google Spreadsheet
    21m 44s
  8. Assignment : Share, Email and Download Google Spreadsheet
    40s
  9. Create a Shortcut of Google Spreadsheets to Drive
    7m 34s
  10. Publish Google Spreadsheets to Web and to Print PDF
    18m 58s

  1. Check Version History of Google Spreadsheets
    11m 12s
  2. Insert Notes and Comments in Google Spreadsheets
    6m 40s
  3. Insert Check Box and URL/Link in Google Spreadsheets
    13m 33s
  4. Assignment : Insert Check Box and URL/Link in Google Spreadsheets
    23s
  5. Sorting Data in Google Spreadsheets
    15m 57s
  6. Assignment : Sorting Data in Google Spreadsheets
    16s
  7. Named Ranges, Protect Sheets & Ranges
    18m 39s
  8. Assignment : Named Ranges, Protect Sheets & Ranges
    17s

  1. Insert Images in Google Spreadsheets
    6m 54s
  2. Assignment : Insert Images in Google Spreadsheets
    19s
  3. Insert Peoples Chips in Google Spreadsheets
    5m 51s
  4. Insert Drawings in Google Spreadsheets
    9m 24s
  5. Assignment : Insert Drawings in Google Spreadsheets
    30s
  6. Insert Charts in Google Spreadsheets
    20m 57s
  7. Assignment : Insert Charts in Google Spreadsheets
    28s

  1. Data Validation in Google Spreadsheets
    38m 10s
  2. Assignment : Data Validation in Google Spreadsheets
    28s
  3. Pivot Tables in Google Spreadsheets
    15m 11s
  4. Assignment : Pivot Tables in Google Spreadsheets
    23s
  5. Data Cleanup Process in Google Spreadsheets
    15m 57s
  6. Assignment : Data Cleanup Process in Google Spreadsheets
    30s

  1. 3rd Party Add-ons and App Script Feature in Google Spreadsheet
    20m 50s
  2. Assignment : 3rd Party Add-ons and App Script Feature in Google Spreadsheet
    18s
  3. Import Data with Importrange Formula in Google Spreadsheet
    16m
  4. Macros in Google Spreadsheet
    7m 38s

  1. Course Summary
    2m 53s

  1. Interview Questions
    13m 49s

  1. Career Guideline
    1m 31s
Enroll For Free