Video Lecture Google Sheet Basic to Advance Online Certification Course By CA Deepak Gupta

Google Sheet Basic to Advance Online Certification Course

Google Sheet Basic to Advance Online Certification Course

Course Key Features

• Create beautiful spreadsheets with amazing formatting tricks
• Connect multiple Google Sheets together using a single formula
• Learn to build incredible data visualizations using charts
• Format and customize any data
• Learn formulas that work in both Google sheets & Excel!
• Create charts and graphs using Spreadsheet data
• Learn to manipulate text in formulas
• Analyze data sets with ease using complex functions & formulas
• Feel completely comfortable in a spreadsheet environment

Course Description

Google Sheet Basic to Advance Online Certification Course

In our continuous endeavor to empower more and more finance professionals, this Google Sheet Basic to Advance Online Certification Course has been designed for you.  Detailed 2 Days course has been designed where daily more than 2 hrs sessions have been organized. This Course contains Videos along with study material, Excel Files. Live training on Excel will be given.
How I will get the course:

This is an online Google Sheet Certification Course so there will not be any physical delivery of the lectures. After the purchase of the Google Sheet Certification Course you can see the Google Sheet Certification Course under my account option under purchased courses. All the videos, study materials, PDF files, PPT’s, excel files will be uploaded there for quick access of participants. This Google Sheet Certification Course is valid for 60 Days.
Who is Eligible to Join Google Sheet Certification Course:

There is no bound on the eligibility from our side for Google Sheet Certification Course. Any person who want to learn and master in Excel can join this course. However, it will be more beneficial for the below-mentioned persons:

⭐Commerce Graduates/CA/CS/CMA/Law students

⭐Tax professionals whether in JOB or Practice

⭐Qualified CA/CS/CMA/LLB

⭐Semi-qualified CA/CS/CMA working in CA Firms or in Industry

⭐Any other person not covered above can join course if interested.
Course Duration:

The course duration is around 4+ hours.
Certificate:

A Certificate of Participation from Studycafe will be provided on completion of the Google Sheet Certification Course.
Views Limitation:

This is a Completely online course, no bar on the number of views. During 60 days you can access this Google Sheet Basic to Advance Online Certification Course from anywhere at any time with unlimited views.
Course Content

Course Content
Day-1: Google Sheet Basic to Advance Online Certification Course

• What is Google Sheet?
• How to Access & create Google sheet
• Benefits of Using Google Sheet
• How to Sort organise & Filter Data
• How to Create, Edit, and Print your spreadsheet
• How to Import and Analyze your Data
• Feel completely comfortable in a spreadsheet environment

Day-2: Google Sheet Basic to Advance Online Certification Course

• How to design your sheet to highlight trends
• How to create charts, pivot tables, and reports
• How to navigate around Spreadsheets
• How to create online forms which allow you to gather data from individuals
• How to use Lookup functions in Google Sheets such as VLOOKUP
• How to Use Mail merge with Google Sheet

About the author

Deepak Gupta is a Chartered Accountant having more than 10 years of Experience in the Field of Direct Taxation and Indirect Taxation. He has Vast Corporate Experience and has previously worked with Renowned companies like Ericsson, Wipro and Hero Group. He is also expert of MS Excel & MS PowerPoint, Tally.ERP9, Tally Prime and has taken several webinars on these topics.