വസ്തു കരം അടക്കാൻ ഇനി അക്ഷയ സെൻഡർ വരെ പോകേണ്ട. വീട്ടിലിരുന്ന് അടക്കാം...
എങ്ങനെ എന്നെ അറിയണോ വീഡിയോ കണ്ടുനോക്കു...
This video explains step by step process of online land tax payment in Kerala Govt. Revenue Department's Revenue eServices
It gives you a detailed explanation of how to pay your land tax through online.. gives you a live video of how to do it by yourself. step by step.
If you face any issue with the process watch the full video at the end it shows the possible explanation of the payment failure.
Revenue eServices link : http://revenue.kerala.gov.in/
This video explains a detailed step by step explanation of how to steam a live video in you tube and Facebook
in Malayalam language with English subtitle.
How to use OBS Studio check here : https://youtu.be/muXTlxKJgXU
OBS studio black screen issue : https://youtu.be/muXTlxKJgXU
Video by Joseph Redfield from Pexels
Video by nikhil d souza from Pexels
music : The Bone Train - Slynk
This is a video shows how to record your screen using free and opensource software OBS Studio
It also explains how to solve the black screen issue with OBS Studio.
and how to embedded your webcam in video recording or live steaming.
OBS Download link : https://obsproject.com/
I don't have OBS black screen issue then go to : 05:49
I only need OBS black screen problem solution then go to : 02:41
How to go Live streaming : https://youtu.be/o9DoWpxEHGk
Thank you..
Please subscribe and support
ഗൂഗിൾ ഫോമിലെ ഡാറ്റ ഉപയോഗിച്ചു സർട്ടിഫിക്കറ്റ് ഉണ്ടാക്കി മെയിൽ ചെയ്യണോ ഈസി ആയി എങ്കിൽ
വീഡിയോ കാണു..
How we can generate 100s of certificates easily using list of name and email ID and send it!!
This video clearly explains the step by step process of creating/ generating customized certificut
we use google spread sheet and google slide in drive. using Autocrat addon
Thank you for watching the video
Subscribe for more videos like this
Important Note:
** If you have a regular gmail account (like @gmail.com) then you can sent only up to 100 certificate in a day
** you can sent the remaining certificate in next day if you want.
** To rerun the job again delete the new data in the additional columns generated and run again. (Don't delete the colum. only delete the data)
Than you
Credits :
Thanks to Nikhil for giving me this idea
Video by Julia M Cameron from Pexels
Video by Pavel Danilyuk from Pexels
Video by Pavel Danilyuk from Pexels
This video clearly explains the steps to follow the online bill payment methode
KSEB Self care Link : https://wss.kseb.in/selfservices/
Photo by Pok Rie from Pexels
Photo by Rohan Makhecha on Unsplash
How to pay BSNL Landline/BB Bill online | Gpay | Latest 2020
https://youtu.be/QMh5fPFeg_I
This video clearly explains below details
1. How to pay the BSNL bill online using BSNL service
2. How to pay BSNL bill using Gpay
and more..
link :
https://www.bsnlepay.com.
or
https://www.epay.bsnl.co.in/customer_login/
credits
Photo by William Iven on Unsplash
Part_10 :
Tip #1 : Comments
can create highlighting notes or comments using this
Tip #2 : Charts
Can create graphical charts using data in excel
Tip #3 : Hyperlinks
It can used to create external website hyperlinks and also can make hyperlinks of workbook inside and outside files.
Tip #4 : Name cells
Name a group of cell and call it anywere
Tip #5 : PMT and NPER
You can calculate loan payments with this function
Part 9_2 : https://youtu.be/MrsmUx8sZ8M
Tip #1 : LEN
Tip #2 : CONCATENATE
Tip #3 : UPPER, LOWER, PROPER
Tip #4 : TEXT
Tip #5 : TRIM, CLEAN
Part 9_1 : https://youtu.be/H1TjUkHdpSU
Tip #1 : LEFT,RIGHT,MID
Tip #2 : FIND, SEARCH
Tip #3 : REPLACE, SUBSTITUTE
Tip #4 : CODE, CHAR
Tip #5 : EXACT
Part 8_2 : https://youtu.be/Ph1Bz4V5IJw
Tip #1 : ISLOGICAL
Tip #2 : ISODD
Tip #3 : ISEVEN
Tip #4 : ISNA
Tip #5 : ISREF
Part 8_1 : https://youtu.be/cIEWTl8V7Ds
Tip #1 : ISERROR
Tip #2 : ISNUMBER
Tip #3 : ISBLANK
Tip #4 : ISFORMULA
Tip #5 : ISTEXT & ISNONTEXT
Part 7 : https://youtu.be/2DfkrpgbUa4
Tip #1 : ABS
Tip #2 : RAND & RANDBETWEEN
Tip #3 : ROUND, ROUNDUP & ROUNDDOWN
Tip #4 : CEILING & FLOOR
Tip #5 : SUBTOTAL
Part 6 : https://youtu.be/b8WGJlzqYLs
Tip #1 : VLOOKUP
Tip #2 : INDEX
Tip #3 : MATCH
Tip #4 : ROW and COLUMN
Tip #5 : CHOOSE
Part 5 : https://youtu.be/fskHJ2vmTOc
Tip #1 : DAY, MONTH, YEAR
Tip #2 : TODAY & NOW
Tip #3 : END OF DATE & END OF MONTH
Tip #4 : WORKDAYS
Tip #5 : WEEKDAY & WEEKNUM
Part 4 : https://youtu.be/gZld6iknrb0
Tip #1 : IF function
Tip #2 : Nested IF
Tip #3 : IF with AND & OR
Tip #4 : COUNTIF
Tip #5 : SUMIF
Part 3 : https://youtu.be/h1czL6_6PGo
Tip #1 : Freeze Panes
Tip #2 : Print Title
Tip #3 : Print Selection
Tip #4 : Page break view
Tip #5 : other printing tips
Part 2 : https://youtu.be/wn0IXZD01XA
Tip #1 : Transpose
Tip #2 : Conditional Formatting
Tip #3 : Remove Duplicate
Tip #4 : Dropdown List
Tip #5 : Combines cells
Part 1 : https://youtu.be/93P3xcN4H0s
Tip #1 : Column or Row width Adjustment
Tip #2 : Select Data
Tip #3 : Quick Analysis
Tip #4 : Fill & Series
Tip #5 : Format Painter
Please subscribe and share the video... More parts are coming with exiting tips..
This video shows 5 great and simple tricks in MS Excel, which will make your work flow faster
TEXT FUNCTIONS
Part 9_2 :
Tip #1 : LEN
It returns the length of the text string
Tip #2 : CONCATENATE
This function can used to joint multiple text string in to one
Tip #3 : UPPER, LOWER, PROPER
These functions can used to change the case of string's
Tip #4 : TEXT
Used to format the cell into text format
Tip #5 : TRIM, CLEAN
These functions can used to remove the extra spaces and line breaks
Part 9_1 : https://youtu.be/H1TjUkHdpSU
Tip #1 : LEFT,RIGHT,MID
Tip #2 : FIND, SEARCH
Tip #3 : REPLACE, SUBSTITUTE
Tip #4 : CODE, CHAR
Tip #5 : EXACT
Part 8_2 : https://youtu.be/Ph1Bz4V5IJw
Tip #1 : ISLOGICAL
Tip #2 : ISODD
Tip #3 : ISEVEN
Tip #4 : ISNA
Tip #5 : ISREF
Part 8_1 : https://youtu.be/cIEWTl8V7Ds
Tip #1 : ISERROR
Tip #2 : ISNUMBER
Tip #3 : ISBLANK
Tip #4 : ISFORMULA
Tip #5 : ISTEXT & ISNONTEXT
Part 7 :
Tip #1 : ABS
Tip #2 : RAND & RANDBETWEEN
Tip #3 : ROUND, ROUNDUP & ROUNDDOWN
Tip #4 : CEILING & FLOOR
Tip #5 : SUBTOTAL
Part 6 :
Tip #1 : VLOOKUP
Tip #2 : INDEX
Tip #3 : MATCH
Tip #4 : ROW and COLUMN
Tip #5 : CHOOSE
Part 5 : https://youtu.be/fskHJ2vmTOc
Tip #1 : DAY, MONTH, YEAR
Tip #2 : TODAY & NOW
Tip #3 : END OF DATE & END OF MONTH
Tip #4 : WORKDAYS
Tip #5 : WEEKDAY & WEEKNUM
Part 4 : https://youtu.be/gZld6iknrb0
Tip #1 : IF function
Tip #2 : Nested IF
Tip #3 : IF with AND & OR
Tip #4 : COUNTIF
Tip #5 : SUMIF
Part 3 : https://youtu.be/h1czL6_6PGo
Tip #1 : Freeze Panes
Tip #2 : Print Title
Tip #3 : Print Selection
Tip #4 : Page break view
Tip #5 : other printing tips
Part 2 : https://youtu.be/wn0IXZD01XA
Tip #1 : Transpose
Tip #2 : Conditional Formatting
Tip #3 : Remove Duplicate
Tip #4 : Dropdownl List
Tip #5 : Combines cells
Part 1 : https://youtu.be/93P3xcN4H0s
Tip #1 : Column or Row width Adjustment
Tip #2 : Select Data
Tip #3 : Quick Analysis
Tip #4 : Fill & Series
Tip #5 : Format Painter
Please subscribe and share the video... More parts are coming with exiting tips..
TEXT FUNCTIONS
Part 9_1 :
Tip #1 : LEFT,RIGHT,MID
We can use these functions to extract characters from a cell.
Tip #2 : FIND, SEARCH
Use this function to look specific text in a cell, it returns the position of matching text
Tip #3 : REPLACE, SUBSTITUTE
REPLACE replaces part of a text string, based on the number of characters you specify,
with a different text string. Use SUBSTITUTE when you want to replace specific text in a text string;
Tip #4 : CODE, CHAR
CODE Returns a numeric code for the first character in a text string. The returned code corresponds to the character set used by your computer.
CHAR Returns the corresponding character for the code
Tip #5 : EXACT
This function is used to compare two text, it is case sensitive
Part 9_2 :
Tip #1 : LEN
Tip #2 : CONCAT, TEXTJOIN, CONCATENATE
Tip #3 : UPPER, LOWER, PROPER
Tip #4 : TEXT
Tip #5 : TRIM, CLEAN
Part 8_2 : https://youtu.be/Ph1Bz4V5IJw
Tip #1 : ISLOGICAL
Tip #2 : ISODD
Tip #3 : ISEVEN
Tip #4 : ISNA
Tip #5 : ISREF
Part 8_1 : https://youtu.be/cIEWTl8V7Ds
Tip #1 : ISERROR
Tip #2 : ISNUMBER
Tip #3 : ISBLANK
Tip #4 : ISFORMULA
Tip #5 : ISTEXT & ISNONTEXT
Part 7 :
Tip #1 : ABS
Tip #2 : RAND & RANDBETWEEN
Tip #3 : ROUND, ROUNDUP & ROUNDDOWN
Tip #4 : CEILING & FLOOR
Tip #5 : SUBTOTAL
Part 6 :
Tip #1 : VLOOKUP
Tip #2 : INDEX
Tip #3 : MATCH
Tip #4 : ROW and COLUMN
Tip #5 : CHOOSE
Part 5 : https://youtu.be/fskHJ2vmTOc
Tip #1 : DAY, MONTH, YEAR
Tip #2 : TODAY & NOW
Tip #3 : END OF DATE & END OF MONTH
Tip #4 : WORKDAYS
Tip #5 : WEEKDAY & WEEKNUM
Part 4 : https://youtu.be/gZld6iknrb0
Tip #1 : IF function
Tip #2 : Nested IF
Tip #3 : IF with AND & OR
Tip #4 : COUNTIF
Tip #5 : SUMIF
Part 3 : https://youtu.be/h1czL6_6PGo
Tip #1 : Freeze Panes
Tip #2 : Print Title
Tip #3 : Print Selection
Tip #4 : Page break view
Tip #5 : other printing tips
Part 2 : https://youtu.be/wn0IXZD01XA
Tip #1 : Transpose
Tip #2 : Conditional Formatting
Tip #3 : Remove Duplicate
Tip #4 : Dropdownl List
Tip #5 : Combines cells
Part 1 : https://youtu.be/93P3xcN4H0s
Tip #1 : Column or Row width Adjustment
Tip #2 : Select Data
Tip #3 : Quick Analysis
Tip #4 : Fill & Series
Tip #5 : Format Painter
Please subscribe and share the video... More parts are coming with exiting tips..
This video shows 5 great and simple tricks in MS Excel, which will make your work flow faster
IS FUNCTIONS Part 2
Part 8_2 :
Tip #1 : ISLOGICAL
The Excel ISLOGICAL function returns TRUE when a cell contains the logical values TRUE or FALSE, and returns FALSE for cells that contain any other value, including empty cells.
Tip #2 : ISODD
Function to check the number is odd
Tip #3 : ISEVEN
Function to check the number is even
Tip #4 : ISNA
Function to find the cell has NA error
Tip #5 : ISREF
This function will check up the cell has referance or not,You can use the ISREF function to check if a cell contains a valid reference.
Part 8_1 : https://youtu.be/cIEWTl8V7Ds
Tip #1 : ISERROR
Tip #2 : ISNUMBER
Tip #3 : ISBLANK
Tip #4 : ISFORMULA
Tip #5 : ISTEXT & ISNONTEXT
Part 7 : https://youtu.be/2DfkrpgbUa4
Tip #1 : ABS
Tip #2 : RAND & RANDBETWEEN
Tip #3 : ROUND, ROUNDUP & ROUNDDOWN
Tip #4 : CEILING & FLOOR
Tip #5 : SUBTOTAL
Part 6 : https://youtu.be/b8WGJlzqYLs
Tip #1 : VLOOKUP
Tip #2 : INDEX
Tip #3 : MATCH
Tip #4 : ROW and COLUMN
Tip #5 : CHOOSE
Part 5 : https://youtu.be/fskHJ2vmTOc
Tip #1 : DAY, MONTH, YEAR
Tip #2 : TODAY & NOW
Tip #3 : END OF DATE & END OF MONTH
Tip #4 : WORKDAYS
Tip #5 : WEEKDAY & WEEKNUM
Part 4 : https://youtu.be/gZld6iknrb0
Tip #1 : IF function
Tip #2 : Nested IF
Tip #3 : IF with AND & OR
Tip #4 : COUNTIF
Tip #5 : SUMIF
Part 3 : https://youtu.be/h1czL6_6PGo
Tip #1 : Freeze Panes
Tip #2 : Print Title
Tip #3 : Print Selection
Tip #4 : Page break view
Tip #5 : other printing tips
Part 2 : https://youtu.be/wn0IXZD01XA
Tip #1 : Transpose
Tip #2 : Conditional Formatting
Tip #3 : Remove Duplicate
Tip #4 : Dropdownl List
Tip #5 : Combines cells
Part 1 : https://youtu.be/93P3xcN4H0s
Tip #1 : Column or Row width Adjustment
Tip #2 : Select Data
Tip #3 : Quick Analysis
Tip #4 : Fill & Series
Tip #5 : Format Painter
Please subscribe and share the video... More parts are coming with exiting tips..
This video shows 5 great and simple tricks in MS Excel, which will make your work flow fasterIS FUNCTIONS Part 1
Part 8_1 :
Tip #1 : ISERROR
This function returns true for any error occurred in excel, otherwise it returns false
Tip #2 : ISNUMBER
It is a function checking whether the value in a cell is number or not
Tip #3 : ISBLANK
This function will check the cell is blank or not
Tip #4 : ISFORMULA
function to check the cell has an excel formula or not
Tip #5 : ISTEXT & ISNONTEXT
Function to check whether the cell contains text or not
Part 8_2 : https://youtu.be/Ph1Bz4V5IJw
Tip #1 : ISLOGICAL
Tip #2 : ISODD
Tip #3 : ISEVEN
Tip #4 : ISNA
Tip #5 : ISREF
Part 7 : https://youtu.be/2DfkrpgbUa4
Tip #1 : ABS
Tip #2 : RAND & RANDBETWEEN
Tip #3 : ROUND, ROUNDUP & ROUNDDOWN
Tip #4 : CEILING & FLOOR
Tip #5 : MOD
Part 6 : https://youtu.be/b8WGJlzqYLs
Tip #1 : VLOOKUP
Tip #2 : INDEX
Tip #3 : MATCH
Tip #4 : ROW and COLUMN
Tip #5 : CHOOSE
Part 5 : https://youtu.be/fskHJ2vmTOc
Tip #1 : DAY, MONTH, YEAR
Tip #2 : TODAY & NOW
Tip #3 : END OF DATE & END OF MONTH
Tip #4 : WORKDAYS
Tip #5 : WEEKDAY & WEEKNUM
Part 4 : https://youtu.be/gZld6iknrb0
Tip #1 : IF function
Tip #2 : Nested IF
Tip #3 : IF with AND & OR
Tip #4 : COUNTIF
Tip #5 : SUMIF
Part 3 : https://youtu.be/h1czL6_6PGo
Tip #1 : Freeze Panes
Tip #2 : Print Title
Tip #3 : Print Selection
Tip #4 : Page break view
Tip #5 : other printing tips
Part 2 : https://youtu.be/wn0IXZD01XA
Tip #1 : Transpose
Tip #2 : Conditional Formatting
Tip #3 : Remove Duplicate
Tip #4 : Dropdown List
Tip #5 : Combines cells
Part 1 : https://youtu.be/93P3xcN4H0s
Tip #1 : Column or Row width Adjustment
Tip #2 : Select Data
Tip #3 : Quick Analysis
Tip #4 : Fill & Series
Tip #5 : Format Painter
Please subscribe and share the video... More parts are coming with exiting tips..
