Complete Google Sheets Training - Beginner to Advance Level
1 month of Skillshare
Available with PurchaseFree
All memberships will be billed automatically on a recurring basis until canceled. If eligible for a free trial, cancel before the trial ends to avoid being charged. Offer only valid for new paid subscribers. See full terms of service here.
About this product
Himanshu Dhar
MIS Trainer
Google Sheets is a robust, cloud-based application that empowers you to create sophisticated spreadsheets. Whether you are working at your desk or from your smartphone or tablet on the go Google Sheets helps you organize, analyze, and share your most important data. In this course for Sheets users, you’ll learn how to make your own supercharged spreadsheets. First, you’ll learn how to input and format your data. Next, you’ll learn how formulas, functions and a few exclusive Google Sheets features can accelerate your data analysis. Finally, you’ll get tips for sharing your spreadsheets and collaborating on them with your team.
In this course you will learn the fundamentals as advance topics of Google Sheets (much of which can be used in MS Excel as well). You will not only learn the basics, like adding and subtracting. But you will also learn valuable advanced formulas like TEXT Function, LOGICAL Function, TEXT Function, LOOKUP Function and many more. You may expect to learn following topics in detail.
• Learn how to adjust the way data and information are displayed in Google Sheets
• Learn how to apply function with function arguments
• Learn how to use relative, absolute, and mixed references in Google Sheets
• Learn how to create powerful calculations with Google Sheets functions
• Learn how to visually represent your data with charts and other tools in Google Sheets
• Learn how to use Google Sheets data tools like Slicer, Sorting and filtering
• Learn how to use Google Sheets to leverage data with Pivot Tables
• Learn how to automate Google Sheets tasks with recording Macros
• Learn how to organise your data based on Condition.
• Learn to validate proper entry in the data.
• Mastering Date and time related formulas and format.
• Mastering all important Text function with nested methodology
• Mastering Logical and Lookup and reference Function.
• Mastering Operators use and Math Functions
• Sharing, protecting and Restricting Sheets File
• Working and collecting data on Google Forms
FAQs
What are digital products?
Digital products at Skillshare are expertly crafted tools, resources, and templates developed by top creatives that are available to you for purchase. With a wide range of resources to suit every creative need, they are actionable, making your learning experience real and unforgettable.
How can I purchase a digital product?
Anyone can purchase a digital product on Skillshare — click Buy now to enter your payment information and complete your purchase. Once payment is complete, all files will be available for download instantly from this page. You'll also receive an email with a link to download your digital product after purchase.
Is there a limit to how many times I can download a digital product?
No, there is no limit to how many times you can download a digital product. Even if a product is removed by the creator, you can still access the download page in most cases by logging in to your Skillshare account.
Can I get a refund or cancel my digital product purchase?
Digital products are non-refundable and cannot be returned or canceled. To learn more, see our refund policy in the Skillshare Help Center.
Can I make and sell my own digital products?
Absolutely! Visit How can I sell a digital product on Skillshare? to learn how you can create, list and sell your own digital products on Skillshare.