Dl4All › Tutorials › Google Sheets Basic To Advance Course

Google Sheets Basic To Advance Course

24-07-2022, 15:39, posted by Baturi

Last updated 4/2020
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.31 GB | Duration: 6h 53m
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

Homepage

https://www.udemy.com/course/learn-google-sheets-basic-to-advance-course/

https://rapidgator.net/file/1ae4f91aa8d8e3693939ce95f9adeced/mlhpj.Google.Sheets.Basic.To.Advance.Course.part1.rar.html
https://rapidgator.net/file/565ad99389a63f4d5a5fec92f5cb3543/mlhpj.Google.Sheets.Basic.To.Advance.Course.part2.rar.html
https://rapidgator.net/file/01e5a15517cba54bbca7cbc9c6758846/mlhpj.Google.Sheets.Basic.To.Advance.Course.part3.rar.html

https://nitro.download/view/551D287F427DDA0/mlhpj.Google.Sheets.Basic.To.Advance.Course.part1.rar
https://nitro.download/view/775161906D1ED0A/mlhpj.Google.Sheets.Basic.To.Advance.Course.part2.rar
https://nitro.download/view/626E9E0C21273E2/mlhpj.Google.Sheets.Basic.To.Advance.Course.part3.rar

https://uploadgig.com/file/download/56d1DA84bD6F2d26/mlhpj.Google.Sheets.Basic.To.Advance.Course.part1.rar
https://uploadgig.com/file/download/2d633aF8e30Aa758/mlhpj.Google.Sheets.Basic.To.Advance.Course.part2.rar
https://uploadgig.com/file/download/c829cfb391deec7c/mlhpj.Google.Sheets.Basic.To.Advance.Course.part3.rar

Links are Interchangeable - No Password - Single Extraction

Go back