Select your Top Menu from wp menus

Excel Tutorial | 20 Tricks & Shortcuts That Can Make Anyone An Excel Expert

► HELLO AND WELCOME TODAY I’M GOING TO
► TELL YOU TRICKS WHICH CAN MAKE
► ANYBODY IN EXCEL EXPORT YES EXCITING
► ISN’T IT LET’S SEE HOW WE CAN DO IT
► FIRST IS TO CLICK AND SELECT ALL YES I
► KNOW ALL OF YOU REMEMBER THAT CONTROL A
► SHORTCUT KEY YES THAT MAKES SELECTION
► EASY BUT THIS MAKES EASIER FOR EXAMPLE
► YOU’RE WORKING ON THE SCHITA YOU’RE
► SELECTING MULTIPLE TIMES AND NOW YOU
► NEED TO SELECT ALL OF THEM RATHER THAN
► GOING TO YOUR KEYBOARD YOU CAN QUICKLY
► GO IN THE CORNER AND PRESS CLICK THERE
► YOU GO SELECT IT ISN’T IT FAST SO WHEN
► YOU ARE ON THE SHEET IT’S RATHER FASTER
► TO GO ON THE CORNER AND CLICK IT OPEN
► EXCEL FILES IN BULK YES A LOT OF FILES
► IF YOU WANT TO OPEN THEM IT’S VERY EASY
► JUST GO TO THE DESKTOP OF THE PLACE
► WHERE YOU SAVED THEM SELECT ALL OF THEM
► TOGETHER LIKE THIS AND JUST PRESS ENTER
► SELECT AND ENTER THE MOMENT YOU WILL
► ENTER ALL OF THE FILES WILL OPEN THEN
► YOU CAN SEE UP BUZZING THE NAME SO YES
► ALL OF THEM ARE OPEN NOW HOW TO SHIFT
► BETWEEN TWO EXCEL FILES YES CTRL TAB I
► KNOW ALL OF YOU REMEMBER THAT THERE’S AN
► ALT TAB BUT REMEMBER THIS THING THAT ALT
► TAB TAKES YOU THROUGH ALL THE FILES
► WHICH ARE OPEN
► IRRESPECTIVE THOSE ARE EXCEL OR NOT BUT
► CTRL TAB WILL TAKE YOU IN BETWEEN THE
► EXCELS ONLY LET ME SHOW YOU SO NOW THERE
► ARE CERTAIN FILES WHICH ARE OPEN SO I’M
► PRESSING CTRL TAB CONTROL TAB AND YOU
► CAN SEE THE EXAMS ARE MOVING ONLY I AM
► ROTATING MYSELF IN BETWEEN THE EXCELS
► NOT AMONG THE OTHER FILES SO THAT IS
► EASY FOR US CTRL TAB JUST REMEMBER THIS
► HOW TO CREATE A NEW SHARK MENU YES QUICK
► ACCESS TOOLBAR LET ME SHOW YOU WE ALL OF
► US HAVE IT BUT WE CAN USE IT MORE
► CONVENIENTLY MORE FAST TO ADD THE JOIST
► VALUES THERE THE CHOICE OPTIONS SO WE
► HAVE TO GO TO THE QUICK ACCESS TOOLBAR
► MORE COMMANDS AND THERE YOU GO YOU’LL
► FIND A LOT OF COMMANDS OVER THERE SO YOU
► NEED TO FIND THE AREA WHERE FROM YOU
► WILL SELECT SO I WILL SELECT PROPERLY
► LET’S SAY OUT OF SOME WHICH IS ALREADY
► THERE IN MY SHEET CLICK NO IT’S ALREADY
► THERE SO I CANNOT READ IT SO OKAY SO
► I’LL CHOOSE ANOTHER ONE NOW WHICH IS NOT
► THERE SO LET’S SAY FOR EXAMPLE WHERE’S
► THE CUT CUT CUT YEAH THERE IT IS SO WHAT
► I’LL DO IS I WILL ADD CUT TO BE PUT
► THERE
► I WILL CLICK AD AND IT’S THERE SO ONCE I
► PRESS OK IT IS IT VISIBLE OVER THERE SO
► I CAN QUICKLY USE THIS CUT IN MY WORK
► THAT I’M DOING SO IT’S MAKING MY WORK
► VERY FAST ADDING A DIAGONAL LINE IN THE
► CELLS SOMETIMES MOST OF US NEED THIS
► DIAGONAL LINE TO CRUSH SOME CELLS AND
► I’M SURE A LOT OF YOU GUYS HAVE BEEN
► WORKING WITH THE CELLS ON THE LINES ON
► THE BORDERS BUT THIS IS DIFFERENT SO IF
► YOU GO ONTO THE ALIGNMENT AND CLICK THIS
► IS THE FORMAT CELL AND OVER THERE IN THE
► BORDERS YOU CAN SEE THIS BOX SO IN THE
► BOX IN THE MIDDLE IF YOU CLICK YOU WILL
► SEE THAT THERE WILL BE A DIAGONAL LINE
► AND THIS IS REALLY GOING TO BE REFLECTED
► IN YOUR EXCEL SHEET SO LET’S SEE HOW
► THIS CELL LOOKS LIKE NOW I BELIEVE YOU
► CAN IMAGINE WHAT CAN BE THE UTILITY OF
► THIS PARTICULAR DIAGONAL LINE THEN WE
► CAN ADD MORE THAN ONE NEW COLUMNS OR
► ROWS YES IT IS IRRITATING TO CLICK ONE
► LINE AND ADD ANOTHER ONE AND THEN GOING
► FOR ANOTHER COLUMN A ROW BY SELECTING
► CLICKING INSERT THEN INSERT AND THEN AND
► SO IT’S REALLY IRRITATING SO THE EASIER
► WAY I WILL GO AND SHOW YOU HOW YOU CAN
► DO IT SO RATHER THAN GOING FOR INSERT
► AND USING THIS MENU LIKE THIS LET ME
► REMOVE THIS LINE AND LET ME HIGHLIGHT
► ONE OF THESE LINES SO THAT I CAN SEE HOW
► IT’S IMPACTING SO LET’S SAY FOR EXAMPLE
► I CHOOSE A CERTAIN NUMBER FOR EXAMPLE
► ROWS I’VE SELECTED YOU CAN SEE SO I WILL
► SIMPLY GO IN INSERT SO IT HAS ADDED
► ABOVE THIS ROWS SO IT’S FASTER TO ADD
► QUICKLY A NUMBER OF ROWS WHICH WE NEED
► TO BE ADDED THEN SPEEDY MOVE OF COPYING
► DATA YES COPY AND THEN GOING TO THIS
► PLACE AND PASTE NO NO MORE NEED OF THIS
► WHENEVER YOU GO ON YOUR EXCEL AND YOU
► SELECT A COLUMN OR ROW THERE IS A PLUS
► SIGN YOU CAN SEE THIS IS THE PLUS SIGN
► AND WHEN IT IS CLICK AND DRAG IT AND
► THERE YOU GO NO NEED TO COPY AND PASTE
► YOU CAN SIMPLY DRAG AND DROP IT IS
► SIMPLE ISN’T IT THEN SPEEDY DELETE BLANK
► CELLS YEAH THAT’S ALSO VERY IMPORTANT
► SOME DEFAULT DATA WILL BE BLANK AND FOR
► VARIOUS REASON IT’S IT CREATES PROBLEM
► FOR YOU TO CALCULATE SO THE BEST WAY TO
► DO
► FILTER IT SO WHENEVER THERE IS SOMETHING
► BLANK AND YOU NEED TO CLEAR IT AND MAKE
► IT REALLY BLANK SO YOU HAVE TO GO AND
► SELECT FROM THE FILTER GO DOWN AND THERE
► YOU GO IT’S BLANK SO SELECT IT AND NOW I
► WILL USE THE QUICK ACCESS TOOLBAR TO
► SELECT VISIBLE CELLS ONLY SO I WILL
► DELETE THEM NOW SO THAT’S HOW I CAN
► QUICKLY ACCESS DELETE AND USE THIS TOOL
► YES
► WAIT SEARCH WITH THE WILD CARDS YES WE
► CAN USE WHITE CARD AS WELL LET ME SHOW
► YOU HOW YOU CAN USE THEM IN YOUR CELLS
► SO FOR EXAMPLE WE HAVE CERTAIN DATA OVER
► HERE SOME ALLEYS A MARK SO LET ME
► HIGHLIGHT ALLY FOR DIFFERENTIATION SO
► YES LET’S GO AND YOU ALL KNOW THIS IS
► CTRL F SO YOU GO THERE AND YOU FIND
► CERTAIN CHARACTERS SO EITHER THAT THERE
► WAS A AL BUT NOTHING I DON’T KNOW AT THE
► END SO AL AND AT THE END WHATEVER IS
► STARTING WITH AL IT IS VISIBLE HERE THEN
► I WILL USE STATIC WITH MARK SO YOU CAN
► SEE ALL THE MARKETS APPEARING SO STATIC
► MEANS THAT WHATEVER IS BEFORE MARK I
► DON’T KNOW BEFORE K SO I HAVE TO INCLUDE
► IT THERE SO STATIC IS FOR INCLUDING THE
► WHOLE CHARACTER AND STAR IS FOR THE
► DIGITS
► LET’S MOVE GENERATE A UNIQUE VALUE IN A
► NEW COLUMN THAT’S ALSO VERY INTERESTING
► SO LET ME SHOW YOU HOW YOU CAN GENERATE
► A UNIQUE VOLUME ALL OF YOU MUST HAVE
► USED THIS FILTER TODAY WE ARE GOING TO
► USE ADVANCED FILTER THAT IS ALSO VERY
► CONVENIENT SO CLICK ON IT COPY TO
► ANOTHER SELECTION AND WE’LL COPY UNIQUE
► NUMBERS FROM THIS FILE SO UNIQUE RECORDS
► ONLY WILL SELECT THIS FILE AND COPY TO
► THIS COLUMN AND THERE YOU GO IT HAS
► COPIED ONLY THE UNIQUE NUMBERS FROM THIS
► THIS WAS A QUICK ILLUSTRATION OF
► ADVANCED FILTER THEN WE HAVE INPUT
► RESTRICTION FOR DATA VALIDATION FUNCTION
► SO THERE ARE CERTAIN COLUMNS OR ROWS
► WHERE WE NEED WELDED DATA WE NEED TO
► MAKE SURE THAT THE USERS WHATEVER THE
► ENTER IN THE SHEET SHOULD BE
► AND RANGE OR NUMBERS SO LET’S SAY FOR
► EXAMPLE WE HAVE AN AGE CONSTRAINT WE
► WANT TO PUT HERE SO SIMPLY YOU WILL GO
► TO THE DATA TAB AND DATA VALIDATION
► CLICK THERE AND SELECT WHOLE NUMBERS
► WHOLE NUMBERS AND IGNORE BLANKS THAT’S
► VERY IMPORTANT THAT IT’S NOT APPLICABLE
► ON BLANKS THEN BETWEEN LET’S SAY FOR
► EXAMPLE THE DATA SHOULD BE BETWEEN
► AND YEARS OF AGE AND ANYTHING OUTSIDE
► THIS RANGE SHOULD NOT BE ACCEPTED SO LET
► ME PUT SOME SAMPLE DATA OVER HERE FOR
► EXAMPLE SO IT IS BETWEEN THE RANGE
► YES ACCEPTED MMM
► THAT IS ALSO WITHIN THE RANGE OF
► THIS SHOULD NOT BE AND THERE YOU GO THE
► EXCEL WILL SAY THAT IT’S NOT A VALID
► NUMBER AND NOT WITHIN THE RANGE SO ENTER
► A CORRECT NUMBER SO THAT’S HOW YOU CAN
► QUICKLY VALIDATE YOUR DATA WHEN YOU GET
► INPUT FROM THE USERS FAST NAVIGATION
► WITH CTRL + ARROW BUTTON YES WHEN YOU
► ARE IN YOUR EXCEL IT’S VERY EASY TO MOVE
► WITH THE CONTROL AND THE ARROW YOU SEE I
► CAN MOVE WITH THE CONTROL AND AN ARROW
► ACROSS THE VALID SHEET SO YOU CAN EASILY
► GO TO THE OTHER END OF THE SHEET WITH
► THE CONTROL AND AN ARROW IT MAKES FAST
► TO NAVIGATE THEN TRANSPOSE DATA FROM ONE
► ROW TO ONE COLUMN THAT MAKES A DATA
► REPRESENTATION DIFFERENT LET’S SAY HOW
► WE CAN DO IT SO WE HAVE CERTAIN DATA
► SELECT IT AND WE NEED TO PUT IT THERE SO
► FIRST WE NEED TO COPY IT SO SELECT IT
► AND PRESS COPY AND THEN SELECT THE PLACE
► WHERE YOU WANT TO PULL IT DOWN PASTE AND
► THERE IS ONE OPTION TRANSPOSE CLICK ON
► IT AND THE DATA WILL BE PASTED IN A
► DIFFERENT DIMENSION SO THIS GIVES YOU AN
► OPPORTUNITY TO ANALYZE THE DATA
► DIFFERENTLY IT’S THE SAME DATA BUT
► PRESENTED IN A DIFFERENT WAY FROM ROWS
► TO THE COLUMNS HIDE THE DATA THOROUGHLY
► I KNOW ALL OF YOU KNOW HOW TO HIDE THE
► DATA LET ME SHOW YOU HOW YOU DO IT FOR
► EXAMPLE IF YOU HAVE A SHEET AND YOU HIDE
► C COLUMN BY GOING IN THE OPTIONS HIDE
► YOU CAN SEE ANYONE CAN FIND IT OUT THAT
► THERE IS SOMETHING HIDDEN IN BETWEEN YES
► BUT THERE’S ANOTHER WAY FROM WHICH NO
► ONE WILL FIGURE IT OUT THAT IT’S HIDDEN
► SO JUST SELECT THE DATA AND SIMPLY GO TO
► THE NUMBER TAB AND OPEN THE CELL FORMAT
► AND GO TO THE CUSTOM AND IN THE TYPE YOU
► HAVE TO PUT SEMICOLON THREE OF THEM AND
► THAT’S IT NOW YOUR DATA IS HIDDEN BUT
► YOU CAN SEE IT IF YOU CLICK ON THE DATA
► IN THE FORMULA BAR THERE YOU GO SO YOU
► CAN SEE IN THE FORMULA BAR YOUR DATA BUT
► ANYONE WHO WILL SEE THAT I WILL NOT BE
► ABLE TO REALLY SEE THIS BECAUSE IT’S
► HIDDEN BUT TOTALLY HIDDEN THEN WE HAVE
► TO COMPOSE TEXT WITH AND THERE ARE
► CERTAIN FORMULAS THAT YOU USE TO
► CONCATENATE FOR EXAMPLE IS EQUAL TO
► CONCATENATE IT’S LONG FORMULAS SUCH I
► JUST FORGET IT LET’S MAKE IT EASY JUST
► SELECT THE FIRST ONE THEN AND SIGN AND
► THEN GO TO THE OTHER ONE THEN AND SIGN
► AND THEN TO ANOTHER ONE SO WE HAVE
► CAPTURED THREE CELLS IN ONE WITH ONLY
► THE M SIGN IT’S FASTER RATHER THAN GOING
► FOR THE FORMULA ETC IT MAKES LIFE EASIER
► THEN TRANSFORM IN THE CASE OF THE TEXT
► YES THERE ARE SOME FORMULAS YOU SHOULD
► REALLY REALLY REMEMBER LIKE FOR EXAMPLE
► UPPER WHICH MAKES THE DATA UPPERCASE ALL
► OF IT AND THEN THEN THERE IS A ANOTHER
► ONE THAT YOU CAN SAY LOWER THAT MAKES
► ALL THE DATA IN THE LOWER CASE SO YOU
► CAN SELECT AND MAKE IT LOWER BUT THIS IS
► NOT THE IDEAL CONDITION SO IDEAL
► CONDITION IS THAT IT SHOULD BE GAPS THE
► FIRST CHARACTER AND THEN THE NOVEL IS
► SMALL SO YOU SIMPLY WRITE PROPER AND
► THEN TEXT IT WILL MAKE IT PERFECTLY AS
► WE WANT IT THERE YOU GO
► SO UPPER LOWER AND PROPER THESE ARE THE
► TWO COMMANDS THEN WE HAVE INPUT VALUES
► STRING WITH ZERO THAT’S INTERESTING THAT
► WHEN AN INPUT VALUE STARTS WITH ZERO IT
► IS NORMALLY NOT VISIBLE EXCEL DOESN’T
► SHOW IT FOR EXAMPLE LET ME PUT SOME
► NUMBERS OVER HERE AND
► SET WILL SHOW ONLY ZEROS ARE NOT
► VISIBLE IF YOU WANT TO SEE THE YOU
► WILL HAVE TO GO CLAY
► AND SINGLE QUOTE NOT DOUBLE COAT BUT
► SINGLE COAT SO WHEN YOU PRESS THE SINGLE
► CODE PUT ZEROS AS MUCH AS YOU WANT AND
► EXCEL WILL SHOW THEM THAT’S A SHORT KEY
► SINGLE : TO SHOW THE NUMBERS AND OF
► COURSE THE SEED ROWS BEHIND UP THEN
► SPEED UP AND PUT IN COMPLICATED TERMS
► AND AUTOCORRECT YES SO LET ME SHOW YOU
► HOW AUTOCORRECT WORKS SO GO OF THE FILE
► AND THEN OPTIONS AND THE OPTIONS THERE
► IS ONE PROOFING SO IN THE PROOFING YOU
► CAN FIND THIS AUTOCORRECT OPTION CLICK
► ON THE AUTOCORRECT AND THERE YOU CAN ADD
► SOMETHING THAT YOU WANT TO MAKE IT FAST
► AND DON’T YOU DON’T HAVE TO WRITE BUT
► EXCEL WILL WRITE RATHER SO YOU LOVE
► WHENEVER YOU WRITE SQ EXCEL WILL WRITE
► SO LEMON A LICORICE A ADD IT PRESS OKAY
► THERE YOU GO NOW WHENEVER I WILL WRITE
► SQ EXCEL WILL AUTOMATICALLY COMPLETE IT
► AND UNDERSTAND THAT I WANT TO WRITE
► SLALOM ON A LICORICE ACER SUCH
► COMPLICATED WORDS WHICH YOU WANT EXCEL
► TO WRITE IT FOR YOU QUICKLY YOU CAN MAKE
► IT FAST
► WITH THE HELP OF AUTOCORRECT THEN WE
► HAVE ONE CLICK TO GET MORE STAIRS YES
► MOST USER KNOW HOW TO CHECK THE DATA
► STATUS IN THE BOTTOM OF THE EXCEL SHEET
► BUT LET ME SHOW YOU HOW YOU CAN MAKE IT
► FAST LET ME DELETE THIS FIRST AND I
► SELECT IT AND IN THE BOTTOM YOU CAN SEE
► A LOT OF STATUS LIKE WHAT IS THE SUM OF
► THIS SELECTION COUNT AVERAGE YOU CAN ADD
► MORE AS WELL IF YOU CLICK RIGHT AND
► THERE YOU GO THERE ARE A LOT OF OTHER
► THINGS LIKE YOU CAN SEE THE STATUSES SO
► FOR EXAMPLE LET ME ADD SOMETHING FROM
► OVER HERE MINIMUM MAXIMUM SO THESE ARE
► THE ONES I WANT TO SEE ON THE END THE
► POWER SO YOU CAN SEE IN THE STATUS BAR
► YOU CAN SEE MORE THINGS THEN ONLY THE
► COUNT OF THE SUM RENAME THE SHEET USING
► DOUBLE CLICK YES MOST OF THE USER WHEN
► THEY GO IN EXCEL AND WANT TO CHANGE THE
► NAME OF THE SHEET THEY GO RIGHT CLICK
► AND RENAME AND THEN WRITE IT YES BUT
► THERE’S A FASTER WAY TO DO THAT JUST GO
► ON THE EXCEL NAME AND DOUBLE CLICK YOU
► CAN SEE AND WRITE THAT WAS IT FROM MY
► SIDE AND I HOPE YOU ENJOYED IT THANK YOU
► VERY MUCH FOR JOINING BYE BYE
► YOU

Video Link

About The Author

Related posts

1 Comment

Leave a Reply

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