Google Sheets (2021 Updated) and TallyPrime with GST Course

Rating 0 out of 5 (0 ratings in Udemy)

What you'll learn

Good understanding of Google Sheets at MIS level
Expertise in Text, Logical and Math Function
Expertise in Lookup and Reference Function
Understanding Date and Time Format and Function
Mastery in Pivot Table and Chart Preparation
Learning Data Validation, Filter and Conditional Formatting
Mastery in Data organizing Tools in Excel
Work with Record Macro
Working with Named Ranges and Linking
Working Knowledge of Financial …

Rating 0 out of 5 (0 ratings in Udemy)

What you'll learn

Good understanding of Google Sheets at MIS level
Expertise in Text, Logical and Math Function
Expertise in Lookup and Reference Function
Understanding Date and Time Format and Function
Mastery in Pivot Table and Chart Preparation
Learning Data Validation, Filter and Conditional Formatting
Mastery in Data organizing Tools in Excel
Work with Record Macro
Working with Named Ranges and Linking
Working Knowledge of Financial Functions
Sharing and Protection option
Creating amazing Google Forms
How to Create Company in Tally
Accounting basics like debits and credits that will help you understand and post entries with confidence
Learn to transfer account information (Bookkeeping) from physical to TallyPrime Software
Learn to create ledger and alter ledger as well
Voucher Entry – Learn to do voucher entry and checking Balance sheet and Profit and Loss Account on that basis
Stock & Inventory Management in TallyPrime
Learn how sales Bill is generated in TallyPrime in POS (Point of Sales)
Bill of Materials (BOM) - Learn in how many ways Bill of material can be generated
Learn the procedure of TDS and TCS in general and implementing it in Tally.
GST in TallyPrime - Learn about implementing absolutely necessary and advanced GST topics like GST Taxation, RCM, GST on Services, GST on Fixed Assets Mutiple
Cost Center and Cost Categories
Budget and Bank Reconciliation in Tally
Payroll in TallyPrime - Learn complete Corporate Payroll set up that complies with Govt. prescribed deduction rates

Description

TallyPrime is simple and designed to be used by people from non-IT and non-accounts background as well. Ease of discovering information, consistent options, navigating without the need to remembering the paths and much more makes you start using TallyPrime right away. The course content is going to teach students in detail on how to manage accounting, Inventory, orders and payroll in Tally.

This is Comprehensive training of 4 hours focuses on practicality and based on current industry norms. It doesn’t waste any time running around the bush, wasting your precious time.

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

Duration 10 Hours 58 Minutes

Paid

Self paced

All Levels

English (US)

Rating 0 out of 5 (0 ratings in Udemy)

Go to the Course
We have partnered with providers to bring you collection of courses, When you buy through links on our site, we may earn an affiliate commission from provider.