Google Sheets Course > Formulas in Google Spreadsheets

'Sumifs' and 'Sumproduct' Formulas in Google Spreadsheets

19.5k

Learner's Ratings

4.8

Overall Rating

  • 86%
  • 11%
  • 0%
  • 0%
  • 3%

Reviews

N
Nandini gowd
5

were we cam find are task on learn vern

M
MONIRUL ISLAM
5

Love you sir 💞

M
Muhammad Saleem
4

Nice learning ideas 👍

A
Aqsa Khan
5

ASALAM U ALAIKUM sir ap ka teaching method bht acha ha .... mujy ap sy kuch puchna jo ap assigment daty hn wo kdr submit karvani h n tha plz reply me

A
Ansari Imtiyaz Ahmed Zaheer Anwar
5

WOW BEST OF THE ANY OTHER LEARNING GLASSES

S
Shyam Sunder
5

I have learned google sheet

T
Trushna
5

I was not aware about so many things about Google Spreadsheets, but the LearnVern teachers made it simple and easy to understand. It is excellent course and the style of teaching is fantastic.

K
Kishor Gone
5

There are more important courses in learn vern website I like cyber one' s

N
Nauneet Gaur
5

Good 👍🙏🏼 knowledge sir bhut accha pdhate ho

A
Amit Gohel
4

sir Assignment wali spredsheet kaise downlod kare for prectice ?

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