-50%

Google Sheets Basic to Advance Course

veer7
Mahavir Bhardwaj
Last Update October 1, 2024
0 already enrolled

About This Course

Google Sheets becomes very popular spreadsheets program because First, it’s FREE, Secondly, Cloud base simply login your account on any device and start working, above all Flexibility of uses, Getting improved day by day.

So keeping Google Sheets’s importance in mind, you need get familiar with Feature & Function of Google Sheets as quickly as possible.

We bring this Google Spreadsheet course for you to get in depth knowledge of Google’s Free Wonderful Program.

This course will begin from very basic level, once you complete you will be able to do complex calculations, make formats within minutes, create Dynamic MIS Reports, Use Google Forms, Create Dynamic Dashboards & So….

What you Learn?

We tried to cover almost all feature & Functions but majors are listed below: –

  • Pivot Table
  • Import of Data in Google Sheets from Excel
  • Google Forms
  • Formatting Tip & Tricks
  • Date & Time
  • Text
  • Lookups
  • Conditional Sum, Counting
  • Logical Operators
  • New Techniques will be uploaded time to time.

Learning Objectives

Learn how to use Google Sheets from Scratch
Create Forms for Collect Data directly in Google Sheets
All Advance Functions Vlookup, Filter, Finance etc
Pivot Table for MIS Reporting in Depth

Target Audience

  • Any person who wants to become expert in Google Sheets
  • All big fortune companies now moving to Google Product So future is Good if you want to upgrade yourself

Curriculum

70 Lessons

Get Familiar with Google Sheets

Introduction7:38Preview
Insert Delete Hide Unhide Rename00:4:37Preview
Data Entry 100:5:27
Selection00:4:18
Insert Delete Row Column00:6:53
Basic Formatting00:6:19
Copy Paste00:4:28
Travel Expense Report00:9:24
Printing00:7:38

Getting Start with Formulas

Text Functions

Date Functions

Logical Functions

Lookup Function

Financial Functions

Advance Financial Function

Sumifs

Pivot Table

Google Forms

Your Instructors

Mahavir Bhardwaj

4.67/5
27 Courses
3 Reviews
15 Students
See more

500.001,000.00

50% off
Level
Intermediate
Lectures
70 lectures
Subject
Language
English
Enrollment validity: 730 days
Select the fields to be shown. Others will be hidden. Drag and drop to rearrange the order.
  • Image
  • SKU
  • Rating
  • Price
  • Stock
  • Availability
  • Add to cart
  • Description
  • Content
  • Weight
  • Dimensions
  • Additional information
Click outside to hide the comparison bar
Compare

Don't have an account yet? Sign up for free

No apps configured. Please contact your administrator.
No apps configured. Please contact your administrator.
Alert: You are not allowed to copy content or view source !!