Select your Top Menu from wp menus

10 Most Used Excel Formula

excel help digitaltranscriptions

► HELLO AND WELCOME TO MY A LISTEN I AM
► YOUR GURU AND IN THIS VIDEO WE WILL
► LEARN THE MOST USED FORMULAS IN EXCEL
► LIKE SO HERE IS A RAW DATA SHEET THAT I
► HAVE CREATED WHICH WE WOULD BE USING TO
► DO TOTALS OR DO EXAMPLES ALRIGHT SO THE
► FIRST FORMULA WE ARE GOING TO LEARN IS
► CALLED THE SUM FORMULA IT ALLOWS YOU TO
► ADD STUFF ALL RIGHT SO HOW DO WE ADD
► STUFF NOW SO THIS IS A BIT TO LYNDEE
► OKAY THIS WOULD BE GREAT
► ALRIGHT AND
► OVER HERE I’M QUICK LIGHT IS EQUAL TO
► SON
► IT IS THE FORMULA TO BAD NUMBERS ALL
► RIGHT AND NOW IT SAYS NUMBER ONE COMMA
► NUMBER TWO AND SO ON SO WHAT YOU CAN DO
► IS YOU CAN SELECT A CELL CONTAINING A
► NUMBER PRESS COMMA SELECT ANOTHER CELL
► CONTAINING A NUMBER PRESS COMMA SELECT
► ANOTHER CELL CONTAINING A NUMBER AND SO
► ON AND SO FORTH AND CLOSE THE BRACKET
► YOU CAN HAVE AROUND UP TO TWO SUCH
► CELLS IN THIS ONE FORMULA AND HERE IS
► YOUR ANSWER IT IS ANOTHER WAY OF DOING
► IT IT IS EQUAL TO SOME PUT ON THE
► BRACKET AND SELECT THE CELLS FOR WHICH
► YOU WANT TO DO THE TOTAL LIKE THIS AND
► CLOSE THE BRACKET IT IS CALLED SELECTING
► A RANGE YOU GET YOUR ANSWER THERE IS
► ANOTHER WAY WOW WE HAVE TOO MANY OPTIONS
► IS EQUAL TO SOME AND I FILL THE NUMBER
► FIVE PLUS SEVEN PLUS I DON’T KNOW
► WHAT IT IS NOW SO THIS IS HOW WE DO
► TOTALS AND THERE IS A COOL TRICK I WILL
► TELL YOU
► JUST PRESS ALT AND IS EQUAL TO PUT IT
► TOGETHER AND IT WILL AUTOMATICALLY DO
► THE TOTAL OF A CONTINUOUS CELL RANGE OF
► NUMBERS AND YOU’LL GET YOUR ANSWER BE
► EASY SO WE ARE DONE WE GOT SOME FORMULA
► AND AVERAGE NOW WE UNDERSTAND THAT
► AVERAGES ARE NOT GOOD WE ONE SHOULD
► NEVER BE AN AVERAGE PERSON BUT YOU NEED
► TO FIND OUT THE AVERAGE OF SALES THAT
► HAPPENED FROM JANUARY FEBRUARY MARCH
► APRIL MAY AND JUNE SO HOW DO WE DO THAT
► THERE IS A VERY SIMPLE FORM FOR THAT
► THIS IS EQUAL TO LET’S BRING IT OVER
► HERE SO IS EQUAL TO AV E OR A GE AND
► OPEN THE BRACKET AND IT SAYS SELECT YOUR
► NUMBERS WE NEED IT WITH SOME FORMULA WE
► CAN SELECT OUR NUMBERS ONE BY ONE AGAIN
► YOU CAN HAVE THIS NUMBER ALSO SO YOU CAN
► LEAVE THESE TWO BEHIND AND THE AVERAGE
► IS ALL RIGHT THAT’S ONE WAY OTHER
► WAYS IS EQUAL TO AVERAGE AND SELECT THIS
► RANGE CLOSE THE BRACKET YOU GET THE
► AVERAGE THE AVERAGE SALES FOR JANUARY TO
► JUNE WAS YOU CAN ALSO SELECT THE
► AVERAGE USING THIS OPTION NUMBER SEVEN
► FOR IS AND I’M TIRED OF
► TYPING PHONE NUMBERS AND THE AVERAGE OF
► FIRST TREE IT’S HEY YOU KNOW HOW TO
► DO AVERAGES VERY SIMPLE FORMULA
► BEAUTIFUL FORMULA ALL RIGHT NOW WHAT IT
► DOES IS IT POUNDS IN NUMBER OF CELLS IN
► ARRANGE THAT AND IN NUMBERS ALL RIGHT SO
► I TYPE IN COUNT AND I SELECT THIS
► COMPLETE AREA THIS IS HOW WE APPLY IT
► CLOSE THE BRACKET NOW IT SAYS CELLS IN
► THIS RANGE CONTAIN NUMBERS
► AND THIS IS D IT IS ALSO NUMBER THESE
► THREE ARE TEXT SO IT IS NOT SHOWING THEM
► IN THIS COUNT IF I MAKE THIS AS A A T IT
► TURNED INTO BY PRESSING CONTROL SAID
► TO GO BACK NOW YOU KNOW HOW TO USE THE
► COUNT FORMULA AND COUNTER BEAUTIFUL
► FORMULA AGAIN IT IS EQUAL TO COU AND TA
► AND IT SAYS COUNT THE NUMBER OF CELLS IN
► A RANGE THAT ARE NOT EMPTY NOW IN THIS
► RANGE WE WANT TO FIND OUT THE CELLS
► WHICH ARE NOT EMPTY THERE ARE CELLS
► IN THIS RANGE WHICH ARE NOT EMPTY FOR
► EXAMPLE NOW IF I DELETE ONE OVER HERE
► NOW WE KNOW THERE ARE OTHER CELLS IN
► THIS RANGE THAT ARE NOT EMPTY THAT
► CONTAIN ANYTHING SO THAT’S THE
► COUNTER FORMULA FOR YOU LET’S MOVE ON TO
► THE NEXT ONE THESE ARE ALL VERY VERY
► USEFUL FORMULAS CONCATENATE ALL RIGHT
► THIS IS BEAUTIFUL AMAZING FORMULA IS
► EQUAL TO IN AND IT SAYS JOINS
► SEVERAL TEXT STRINGS INTO ONE BIG STRING
► FOR EXAMPLE I HAPPEN TO HAVE THE FIRST
► NAME AND LAST NAME LET’S ASSUME THAT
► THIS IS THE FIRST NAME AND THIS IS THE
► LAST NAME OR LET’S SAY THIS IS THE
► COUNTRY NAME AND THE CITY NAME I WANT TO
► HAVE THEM TOGETHER SO I WILL SELECT THE
► COUNTRY NAME ALL RIGHT
► ENTER A COMMA AND NOW SELECT THE CITY
► NAME
► CLOSE THE BRACKET AND I WILL HAVE INDIA
► DELHI MENTIONED OVER HERE BUT IT IS NOT
► NICE
► THERE IS NO SPACE IN BETWEEN THEM ALL
► RIGHT OH IN CERTAIN CASES YOU MIGHT WANT
► OFF OR COMBINE BETWEEN THEM SO I’LL
► CHANGE THE APPROACH I HAVE BEEN IS EQUAL
► TO ON CATHY NEED OPEN THE BRACKET SELECT
► TEXT ONE PRESS COMMA INTO THE CODE
► SYMBOL AND PRESS SPACE CLOSE THE CODE
► SYMBOL TO A COMA AND NOW IT’S SELECT THE
► SECOND TERM WHICH YOU WANT TO HAVE JOIN
► CLOSE THE BRACKET AND YOU HAVE INDIAN
► TELLY YOU CAN EDIT THIS FORMULA BY
► DOUBLE CLICKING OVER HERE AND BETWEEN
► THIS COURSE WE CAN MENTION A COMMA
► SYMBOL NOW SEE WHAT WILL HAPPEN IT’S
► INDIA AGAIN KNEE RIGHT HE CAN DO THIS
► WITH FIRST NAMES AND LAST NAMES VERY
► COMMON EXAMPLE NOW IF FORMULA IS A
► BEAUTIFUL FORMULA NOW BY THE WAY I’M
► SHOWING YOU A SHORTCUT VERSION SURE IF
► YOU WERE TO SEE EVEN A MORE DETAILED
► VERSION OF THESE VIDEOS YOU CAN GO TO MY
► WEBSITE MY ‘LISTEN DOT O R G AND CHECK
► OUT ALL THESE VIDEOS THEY ALSO PRACTICE
► FILES AVAILABLE THERE FOR YOU TO
► DOWNLOAD WHICH YOU CAN USE FOR
► PRACTICING OKAY NEXT TOPIC IS IF FORMULA
► ONE OF THE MOST USED FORMULA OKAY HEY
► OKAY AND LET’S SEE LET’S SEE HOW DO WE
► GIVE AN EXAMPLE IF SAMA IS A LOGICAL
► FORMULA WHICH CHECKS WHETHER A CONDITION
► IS MET AND RETURNS ONE VALUE IF TRUE AND
► ANOTHER VALUE IF FALSE ALL RIGHT SO WHAT
► WE’LL DO IS WE’LL IF AND IT SAYS LOGICAL
► YES MY LOGICAL TEST CAN BE SAY IF THIS
► CELL IS EQUAL TO X SAY YEAH
► ALL RIGHT
► AH VALUE IF YOU SAY CAN BE
► WHICH IS THE LANGUAGE OF THIS COUNTRY
► AND VALUE IF FALSE THEY IF IT IS WE CAN
► MENTION THE TEXT AS OKAY SINCE YOU WANT
► TO TEXT AS AN ANSWER YOU HAVE TO MENTION
► IT IN QUOTES AND IT IS
► NOT INDIA RETURNED AWARE THEN WE CAN
► MENTION AT THE LANGUAGE HE I’LL SHOW YOU
► AN EXAMPLE WITH NUMBERS ALSO AND CLOSE
► THE BRACKET NOW SEE THIS IS INDIA SO WE
► GOT AN ANSWER HINDI IF I TYPE IN USA
► OVER HERE IT BECOMES A LANGUAGE OF
► COURSE USA’S
► ENGLISH I AM GOING TO CHANGE THIS AND
► NOW I’M GOING TO SHOW AN EXAMPLE A TOTAL
► SALES JUST ONE FORMULA
► THE TOTAL SALES IS
► LESS THAN OR EQUAL TO
► THREE THOUSAND COMMA VALUES PRO GIVE
► JOB
► COMMA IF VALUE IS FALSE THAT MEANS IF IT
► IS LESSER THAN THIS
► SO WE ARE DOING IT THE OTHER WAY IF IT
► IS LESS THAN SAY
► WORK HARDER ALRIGHT AND IF IT IS FALSE
► THAT MEANS IF IT IS GREATER THAN
► THEN WE’D SAY GOOD JOB I LEARNED THAT
► FROM HANCOCK T IT SAYS WORK HARDER
► BECAUSE YOU’RE CEO UNLESS THEN BE
► THOUSAND IF I MAKE IT THIRTY ONE HUNDRED
► GOOD YEAH HEY BUT IF YOU BELIEVE THEN
► I’M DOING A GOOD JOB DUDE GIVE A THUMBS
► UP ON THIS VIDEO ALRIGHT AND NOW WE ARE
► GOING TO USE THE COUNT IF FORMULA
► BEAUTIFUL FORMULA VERY EFFECTIVE VERY
► USEFUL NOW I WANT TO FIND OUT IS EQUAL
► TO COME IF COUNT THE NUMBER OF CELLS
► WITHIN A RACE THAT MEET OUR GIVEN
► CRITERIA NOW I WANT TO COUNT THE CELLS
► WHICH CONTAIN THE WORD IS USA OR SAY BMW
► ALL RIGHT OVER HERE
► SO IT’S ASKING FOR RANGE SO THIS RANGE
► WILL BE THAT RANGE WHERE YOUR ANSWER IS
► LOCATED NOW THIS IS A BIG RANGE SEE I
► HAVE SELECTED THIS OMAN OH IT SAYS
► CRITERIA I CAN TYPE IN MY CRITERIA NOW
► ALL RIGHT I’M HEADING IT OVER HERE
► CRITERIA SAY THE EMW CLOSE THE BRACKET
► YOU HAVE THE ANSWER BMW IS FIVE TIMES
► OVER HERE ALRIGHT IF I SAY I AM THERE’S
► ANOTHER WAY OF DOING THIS IF I MENTION
► VOLVO OVER HERE AND IS EQUAL TO COUNT IF
► I WANT TO FIND OUT NUMBER OF TIME HAVE
► ALWAYS MENTIONED SO I SELECT THIS RANGE
► OKAY I’M USING A KEYBOARD SHORTCUT WHERE
► I PRESSED SHIFT + CTRL + THE DOWN ARROW
► AND IT WILL CLICK ON SELECTED IN THAT
► COLUMN COLUMN AND IT SAYS CRITERIA NOW
► I’M SCROLLING UP AND INSTEAD OF TYPING
► IN THE CRITERIA I’M SELECTING THIS
► CRITERIA I AM CLOSING THE BRACKET NOW
► AND SO IT’S AGAIN FIVE ALWAYS GOES TO
► FIGHT SO LET ME MAKE A MAZDA A VOLVO IT
► SHOULD BE SIX NOW T THIS IS SIX SO
► THAT’S THE COUNTER FORMULA I’M GOING TO
► SHOW YOU ANOTHER TRICK TO DELETE STUFF
► COMPLETELY EVEN REMOVING THE FORMATTING
► SO THAT’S AN ADDITIONAL FOR YOU
► ADDITIONAL FEATURE
► YOU IN THE HOME TAB SELECT CLEAR ALL
► EVERYTHING GOES
► LIKE THAT AH VLOOKUP EVERYBODY’S
► FAVORITE RIGHT SO LET’S LEARN VLOOKUP
► NOW SO FAR WE LOOK UP J DO YOU WANT TO
► HAVE THIS OUR NAMES OVER HERE LET’S TAKE
► THIS EXAMPLE ALRIGHT WE AND WE WANT TO
► FIND OUT THE TOTAL SALES ALL RIGHT
► THE TOTAL SALES LET ME HAVE ONLY ONE
► NAME I’M MAKING ME HEADER FOR YOU AND
► TOTAL SALES AND I GIVE IT A SPACE ALL
► RIGHT AND I GIVE IT SOME BIGGER SIZE
► THERE WE ARE OKAY FOR HONDA NOW WE WANT
► TO FIND OUT THE TOTAL SALES FOR HONDA
► USING VLOOKUP IS EQUAL TO WE LOOK UP AND
► WE IT SAYS SELECT YOUR LOOKUP VALUE SO
► MY LOOKUP VALUE WOULD BE HONDA COME AH
► IT WILL READ PEOPLE ARRAY WILL BE AT
► RANGE WHICH CONTAINS YOUR ANSWER BE SURE
► THAT IT STARTS FROM THAT COLUMN WHICH
► CONTAINS YOUR LOOKUP VALUE WHICH IS
► HONDA EXCUSE ME
► SO NOW I SELECTED THIS AREA
► COMMA IT SAYS COLUMN INDEX NUMBER NOW
► THIS IS THE MOST IMPORTANT PART A COLUMN
► INDEX NUMBER IS SIMPLY WAY OF EXCEL
► ASKING YOU FROM WHICH COLUMN SHOULD I
► GIVE YOU THE RESULT SINCE THE RESULT IS
► LOCATED IN THIS COLUMN WHICH IS CALLED
► TOTAL SALES AND IT’S NUMBER SHOULD BE
► WHAT ONE TWO THREE FOUR FIVE BUT THAT’S
► NOT THE CASE BECAUSE OUR RANGE IS
► STARTING FROM PRODUCT SO THE COLUMN
► NUMBER WOULD START FROM HERE ONE TWO
► THREE FOUR
► TYPE IN FOUR COMMA ZERO FOR A EXACT
► MATCH PRESS ENTER AND YOU GET THE ANSWER
► , AND SO IF I TAKE ALL OVER HERE
► I’LL GET THE ANSWER IT’S DIFFERENT
► ANSWER IF I TYPE
► MW OVER HERE AND GET A DIFFERENT ANSWER
► T THIS IS A VERY VERY SIMPLE WAY OF
► USING
► WE LOOK A FORMULA SO NOW YOU KNOW WE
► LOOK UP THIS ITSELF DESERVES A THUMBS UP
► GUYS DO GIVE A THUMBS UP TO THIS VIDEO
► AND NOW A VERY IMPORTANT ASPECT THOUGH
► THIS IS NOT A FORMULA BUT A VERY
► IMPORTANT FEATURE THAT IS CALLED
► CREATING A DROP DOWN LIST ALL RIGHT NOW
► MANY A TIMES WHILE YOU ARE DOING DATA
► ENTRY YOU MIGHT BE REQUIRED TO CREATE A
► DROP DOWN LIST SAY OVER HERE ITSELF I
► WANT TO CREATE A DROP DOWN LIST SO HOW
► DO I DO THAT
► SO I GO OVER HERE CLICK IN THIS CELL GO
► TO DATA ALL RIGHT AND GO TO DATA
► VALIDATION AND FROM HERE I SAY LIST AND
► IT’S IT TELLS ME A SOURCE SO I WILL
► SELECT A SOURCE I CLICK OVER HERE AND
► SAY THIS IS MY SOURCE
► ALL RIGHT AND I PRESS OKAY NOW SEE MY
► DROP DOWN LIST IS READY
► I CAN USE MY VLOOKUP WITH A DROP DOWN
► FORMULA SEE THE ANSWER IS CHANGING WOW
► SHE WASN’T DROP DOWN WITH VLOOKUP ALSO
► THIS ALSO THIS ALSO COMES UP AROUND A
► GOOD COMMITTEE AND SOME IF FORMULA THIS
► IS VERY VERY IMPORTANT NOW A SOME IF
► FORMULA SAYS THAT BASED ON A CONDITION
► YOU CAN GET A RESULT
► SAY FOR EXAMPLE IS EQUAL TO SOME F IT
► SAYS RANGE CRITERIA SOME RANGE SO SAY
► FOR EXAMPLE I WANT TO FIND OUT THE TOTAL
► SALES OR JUST BMW
► FROM THIS RANGE ALL RIGHT SO WHAT WILL I
► DO I’LL SELECT THIS AREA ITS RANGE THIS
► RANGE IS THE ONE WHICH CONTAINS THAT
► CRITERIA AND THEN SAY I CAN HAVE MY
► CRITERIA MENTIONED OVER HERE THIS CAN BE
► MY CRITERIA
► BUT I CAN EVEN TYPE IT IN OMA SOME RANGE
► WHICH CELL DO YOU WANT WHICH RANGE DO
► YOU WANT TO PUT UP THIS IS THE RANGE
► THAT YOU WANT TO TOTAL UP I SELECTED IT
► AND HOW ARE YOU CLOSE MY BRACKET LET’S
► ENTER AND AUSTIN MARTIN THE RESULT IS
► THE TOTAL SUM IS IF I CHOOSE
► SAY HONDA IT WILL CHANGE TO AND
► IF I CHOOSE MERCEDES IT CHANGES AGAIN
► SO THIS IS SUMMIT FORMULA SO GUYS TODAY
► WE COVERED MOST USED FORMULAS IN
► EXCEL WHICH YOU CAN ALSO LEARN IN EVEN
► GREATER DETAIL AT MY WEBSITE MY A LESSON
► TAUGHT ORGY AND IF YOU LIKE THIS VIDEO
► DO LIKE CLICK ON THIS THUMBS UP BUTTON
► AND IF YOU HAVE A QUESTION DO MENTION IT
► IN THE COMMENTS OVER HERE AND I WILL
► SURELY REPLY TO YOU AND IF YOU WOULD
► LIKE TO SUBSCRIBE TO THIS CHANNEL THEN
► PLEASE DO IT WILL MOTIVATE ME FURTHER
► CREATE MORE SUCH VIDEOS AND ALSO YOU
► WILL GET NOTIFIED AND EVER LIKE SENT OUT
► A NEW VIDEO ON THE WEB SO HOPE YOU LIKE
► THIS VIDEO UNTIL THE NEXT VIDEO THIS IS
► YOUR GIRL NOW SIGNING OFF OF THE DAY HOW
► WONDERFUL THEIR HEAD HAPPY LEARNING

Video Link

About The Author

Related posts

Leave a Reply

Your email address will not be published. Required fields are marked *