Google Sheets Basic To Advance Course

Hands-on Practical Examples, Lots of Exercises, Practice Files, that will make you master in Google Sheets

What you'll learn

Learn how to use Google Sheets from Scratch

All Advance Functions Vlookup, Filter, Finance etc

Create Forms for Collect Data directly in Google Sheets

Pivot Table for MIS Reporting in Depth

Requirements

You require a Google Account and a computer or tablet or mobile

Most Important your DESIRE to learn

Description

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 TableImport of Data in Google Sheets from ExcelGoogle FormsFormatting Tip & TricksDate & TimeTextLookupsConditional Sum, CountingLogical OperatorsNew Techniques will be uploaded time to time.

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Get Familiar with Google Sheets

Lecture 2 Create First Google Sheets

Lecture 3 Insert, Delete, Rename, Hide, Un-hide Sheets

Lecture 4 Create First Data Table

Lecture 5 Selection of Data, Cell, Range

Lecture 6 All About Rows Columns Insert Delete

Lecture 7 Formatting of Sheets Cells Ranges

Lecture 8 Copy Paste, Paste Special

Lecture 9 Formatting Practice : Let's Make Travel Expense Report

Lecture 10 Printing Google Sheets

Section 3: Getting Start with Formulas

Lecture 11 How Calculations Work?

Lecture 12 Relative Reference & Absolute Reference

Lecture 13 Give Custom Name to Cell

Lecture 14 Assign Custom Name to Range of Cells

Section 4: Google Forms with Google Sheets

Lecture 15 Introduction of Google Forms

Lecture 16 Google Forms - Part 1

Lecture 17 Google Forms - Part 2

Lecture 18 Google Forms - Part 3

Section 5: Learn Text Function

Lecture 19 Convert Roman Numeral

Lecture 20 Join Texts Strings : Concatenate Function

Lecture 21 Join Texts with Number Date in Specified Format : Text with Concatenate Function

Lecture 22 Give Format to Numbers : Fixed Function

Lecture 23 Join Function

Lecture 24 Left Right MID Len Function

Lecture 25 Lower Upper Proper Function

Lecture 26 Replace Function

Lecture 27 Find Search Function

Lecture 28 Repeat Text in Cell: REPT Function

Lecture 29 Split Strings using Delimiter : Split Function

Lecture 30 Value Function

Lecture 31 Trim Function

Lecture 32 Exact Function

Lecture 33 Substitute Function

Lecture 34 Advance Text Functions Techniques

Section 6: Working with Date and Time

Lecture 35 Some Basic Date Related Functions but Important

Lecture 36 EDate and EODate Funcation

Lecture 37 Days360 Calculate Number of Days

Lecture 38 NetworkDays.INTL Function

Lecture 39 Workday.INTL Function

Lecture 40 Calculate Age

Lecture 41 Time Sheet

Section 7: Logical Functions

Lecture 42 Logical Operators

Lecture 43 If function

Lecture 44 Nested If

Lecture 45 AND

Lecture 46 OR

Lecture 47 IFS

Section 8: Lookup

Lecture 48 Address

Lecture 49 Choose

Lecture 50 Formulatext Function

Lecture 51 Vlookup Hlookup Lookup

Lecture 52 Payslip using Vlookup

Section 9: Financial Functions

Lecture 53 Four Most Important Concept before start Financial Function

Lecture 54 Present Value of Money

Lecture 55 Present Value of Money of Lum Sum Amount

Lecture 56 Present Value of Lum Sum Amount with Installment

Lecture 57 Future Value with Three Examples

Lecture 58 Know Installment Amount of Loan using PMT Function

Lecture 59 Rate Calculation

Lecture 60 Number of Periods (NPER) Calculation

Lecture 61 Deferred Loan Installment Payment Calculation

Lecture 62 Calculate Bond Price or Face Value of Bond

Lecture 63 Yield Calculation on Bond

Lecture 64 NPV

Lecture 65 Introduction of Pivot Table

Section 10: Pivot Table in Google Sheets

Lecture 66 Pivot Table in Details

Lecture 67 Use some Functions in Pivot Table

Lecture 68 Grouping & Extract Data from Pivot Table

Lecture 69 Calculated Fields

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