Select your Top Menu from wp menus

Google Sheets – Full Tutorial 2018

► THERE’S A COUPLE DIFFERENT WAYS TO CREATE
► A GOOGLE SPREADSHEET.
► YOU CAN EITHER DO IT FROM SCRATCH, WHICH IS
► WHAT WE’LL DO FIRST, OR YOU CAN CREATE IT
► FROM A TEMPLATE.
► OR, YOU MAY HAVE A SPREADSHEET ALREADY THAT
► YOU WANT TO GET INTO GOOGLE DRIVE AND THEN
► OPEN IT IN SHEETS.
► WE’LL GO OVER THAT AS WELL.
► THE WAY TO JUST CREATE A BLANK GOOGLE SHEET
► IS TO START OUT BY GOING TO DRIVE.GOOGLE.COM.
► THIS IS GOOGLE DRIVE.
► IF YOU DON’T HAVE AN ACCOUNT, A GOOGLE ACCOUNT
► ALREADY THEN YOU’LL HAVE TO CREATE ONE BUT
► LET’S ASSUME THAT YOU HAVE ON AND GO TO A
► BLANK AREA THAT’S IN THE WHERE THAT YOUR FILES
► AND FOLDERS ARE I’M GOING TO RIGHT CLICK AND
► GOOGLE SHEETS IS ONE OF THE OPTIONS IF YOU
► GO OVER TO THE RIGHT YOU’LL SEE THAT YOU CAN
► DO IT FROM A BLANK SPREADSHEET OR A TEMPLATE
► SO IF YOU WANTED TO DO SOMETHING COMMON LIKE
► MAYBE A BUDGET OR CREATE AN INVOICE FOR A
► CUSTOMER THERE’LL BE A TEMPLATE FOR THAT THAT’LL
► GET YOU STARTED BUT RIGHT NOW WE’RE JUST GONNA
► DO A BLANK SPREADSHEET SO YOU’LL SEE IT OPENED
► A NEW WINDOW WITH YOUR GOOGLE SHEETS SPREADSHEET
► IN IT GOOGLE DRIVE IS STILL OPEN IN THE BACKGROUND
► AND IT’LL LOOK EXACTLY LIKE THIS IF YOU’RE
► USING GOOGLE CHROME AS YOUR BROWSER BUT IF
► YOU’RE USING ANOTHER ONE IT’LL STILL DO THE
► MULTIPLE TABS IT’LL BE SIMILAR THE FIRST THING
► THAT YOU PROBABLY WANT TO DO IS NAME IT SOMETHING
► THAT’S MEANINGFUL TO WHAT IT’S GOING TO BE
► SO WE’LL LET’S JUST ASSUME THAT YOU’RE DOING
► INVENTORY NAME AN INVENTORY YOU’RE READY TO
► GO THERE’S A FEW BASICS ABOUT HOW TO DO THIS
► SO YOU’RE ONLY IN ONE CELL AT A TIME IF YOU’RE
► ENTERING DATA AND IT STARTS OUT IN A YOU
► REFERENCE THESE BY SAYING THE COLUMN FIRST
► AND THEN THE ROW AND TYPE WHAT YOU WANT IN
► HERE MAYBE THIS WILL BE THE AMOUNT AND TO
► GO DOWN YOU EITHER HIT ENTER OR YOU HIT THE
► DOWN ARROW TYPICALLY YOU WOULD JUST HIT ENTER
► WHICH ALWAYS BRING YOU DOWN BUT SOMETIMES
► YOU MAY WANT TO GO LEFT OR RIGHT UP DOWN AND
► JUST USE ARROW KEYS SO RIGHT NOW I’M GOING
► TO HIT THE DOWN ARROW AND THAT’S DONE YOU’VE
► ENTERED YOUR FIRST DATA IN A GOOGLE SPREADSHEET
► SO LET’S ENTER A FEW NUMBERS IN HERE JUST
► TO SHOW YOU WHAT YOU MIGHT WANT TO DO NEXT
► WE’LL DO THREE FOUR AND THREE AND THEN AND
► THEN IF YOU WANT TO SUM THEM GO TO INSERT
► FUNCTION AND IT’S GOING TO HAVE THE MOST COMMON
► FUNCTIONS HERE THIS IS GOING TO BE WHAT YOU’RE
► USING A LOT OF THE TIME AND JUST CHOOSE SOME
► LEFT CLICK ON IT AND IT WANTS THE RANGE OF
► THE VALUES SO WE’RE WORKING IN A TWO ALL THE
► WAY THROUGH A FOUR AND YOU’VE ALSO COULD HAVE
► JUST USED YOUR MOUSE LEFT CLICK THAN A TWO
► AND DRAGGED IT DOWN TO A FOUR AND NOW HIT
► ENTER AND YOU’VE DONE YOUR FIRST SPREADSHEET
► FUNCTION SATTING UP THREE FOUR AND THREE SO
► THAT’S HOW YOU CREATE A BLANK SPREADSHEET
► IT’S PRETTY EASY THE KEY IS JUST REMEMBER
► TO GO TO YOUR GOOGLE DRIVE GREAT IT FROM THERE
► GIVE IT A GOOD NAME THEN YOU CAN FIND IT LATER
► I’M GOING TO SHOW YOU THE STEPS ON HOW TO
► UPLOAD AN EXISTING SPREADSHEET SO ONE OF THE
► LITTLE TRICKS THAT YOU WANT TO DO IS YOU WANT
► TO GO TO YOUR SETTINGS AND MAKE SURE CONVERT
► UPLOADS IS CHECKED IF THAT’S NOT CHECKED IT’S
► GOING TO UPLOAD IT SAY IN THIS CASE IN A EXCEL
► FORMAT THAT’S GOING TO SIT ON YOUR GOOGLE
► DRIVE IN A NON-NATIVE FORMAT SO IF YOU PUT
► ON GOOGLE DRIVE TO USE IT IN SHEETS JUST HAVE
► THIS CHECKED IN IT’LL CONVERT IT FOR YOU AUTOMATICALLY
► NOW THAT YOU WANT TO UPLOAD YOUR FILE GO TO
► NEW AND FILE UPLOAD AND THIS IS GOING TO LOOK
► AT THE HARD DRIVE ON YOUR COMPUTER I HAPPEN
► TO HAVE PUT MINE HERE SO THIS IS THE SAMPLE
► DATA THIS IS AN EXCEL SPREADSHEET SELECT IT
► CLICK OPEN AND YOU SEE IN THE LOWER RIGHT
► HAND CORNER IT’S UPLOADING ONE ITEM IT HAS
► THIS X HERE WHICH IS SAYING THAT IT’S IN EXCEL
► BUT IF YOU SEE BY THE TIME IT GETS INTO MY
► DRIVE IT’S IN GOOGLE SHEETS IF YOU DIDN’T
► CLICK THAT CHECK MARK THAT I SHOWED YOU A
► MINUTE AGO THIS WOULD STILL BE AN X AND YOU
► COULD VIEW IT BUT IT WOULDN’T BE IN THE NATIVE
► FORMAT IF I OPEN UP SAMPLE DATA IT’LL OPEN
► UP IN GOOGLE SHEETS AND IT’S READY TO GO SEE
► BUT IT DOESN’T ALWAYS UPLOAD PERFECTLY IN
► THIS EXAMPLE THE HEADER JUST LOOKS BLACK IF
► I CLICK IN SAY EXAMPLE C ONE I CAN SEE THERE’S
► A VALUE IN THERE BUT WHAT IT DID WAS IT TURNED
► MY FONTS BLACK AND THE BACKGROUND BLACK SO
► LET’S JUST GO AND TURN THE TEXT COLOR TO WHITE
► AND WE CAN SEE WHAT’S HAPPENING HERE SO THAT’S
► YOUR THREE WAYS TO CREATE A NEW SHEETS MAKE
► A BLANK SHEET CREATE ONE FROM A TEMPLATE OR
► UPLOAD EXISTING DATA NEXT WE’RE GOING TO GO
► THROUGH HOW TO FORMAT IT AND SO HANG ON FOR
► THAT.
► IF YOU’RE USING GOOGLE SHEETS AND YOU HAVE
► SOME DATA THAT LOOKS LIKE THIS ON THE LEFT
► AND YOU WANT TO MAKE IT APPARENT THAT IT’S
► A TABLE, USE SOME NICE COLORS, MAKE IT OBVIOUS
► WHAT THE HEADERS AND THE TITLE ARE, THAT’S
► WHAT WE’RE GOING TO DO IN THIS TUTORIAL.
► WE’RE GOING TO START WITH UNFORMATTED DATA
► AND WORK OUR WAY OVER TO SOMETHING THAT LOOKS
► LIKE THIS.
► HERE WE GO.
► IF WE DO ONE CELL, LET’S SAY WE WANTED TO
► DO A, YOU HOVER OVER IT WITH THE MOUSE AND
► YOU LEFT-CLICK ONE TIME.
► THAT SELECTS IT.
► DON’T DOUBLE CLICK.
► IF YOU DOUBLE CLICK, IT BRINGS YOU INSIDE
► THE CELL AND IT THINKS THAT YOU WANT TO CHANGE
► THE CONTENTS OF IT.
► THE SECOND WAY THAT WE’RE GOING TO SELECT
► DATA IS WE’RE GOING TO EITHER SELECT THE ENTIRE
► COLUMN, AND I DID THAT BY LEFT CLICKING ON
► THE A, OR YOU CAN DO THE ENTIRE ROW.
► LET’S LEFT-CLICK ON THE AND, WHILE THAT’S
► HIGHLIGHTED, IF YOU HOLD DOWN THE SHIFT KEY,
► YOU CAN GO DOWN AND IT SELECTS MORE THAN ONE
► AT A TIME.
► YOU CAN ALSO SELECT THE ENTIRE SHEET BY CLICKING
► HERE IN THE UPPER LEFT HAND CORNER.
► THAT’S EVERYTHING.
► SO, WHEN YOU’RE LOOKING AT THIS DATA, THE
► FIRST THING THAT YOU WANT TO DO IS MAKE IT
► APPARENT THAT THESE ARE DOLLARS.
► WE’RE GOING TO HIGHLIGHT ALL OF THOSE.
► I JUST LEFT CLICKED IN F.
► I HELD DOWN THE SHIFT KEY AND I USED THE RIGHT
► AND DOWN ARROWS TO SELECT THIS ENTIRE RANGE.
► I’M GOING TO GO UP AND CLICK THE DOLLAR SIGN
► IN THE TOOLBAR.
► THAT FORMATS IT AS CURRENCY BUT THEN I WANT
► TO GO TO COLUMN F BECAUSE I DON’T REALLY FIND
► IT TO BE MATERIAL WHAT THE CENTS ARE ON A
► PARTICULAR ITEM.
► I KIND OF WANT IT ON THE TOTALS BECAUSE I
► WANT TO SEE EVERYTHING DOWN TO THE PENNY.
► LET’S GO AHEAD AND DECREASE THE DECIMAL PLACES.
► I WANT YOU TO SEE, FOR EXAMPLE, THIS IS $.,
► BUT DECREASE IT BY , OOPS WRONG WAY.
► IF I DECREASE IT BY , IT ROUNDS FOR ME.
► GOOGLE SHEETS USES A STANDARD ROUNDING CONVENTION
► AND THIS TURNS $. INTO $..
► THE VALUE IN HERE IS STILL $..
► IF I DOUBLE CLICK, IT’S IN THERE.
► WE’VE JUST CHANGED HOW IT’S DISPLAYED.
► LET’S TAKE THIS SAMPLE DATA.
► THIS IS THE TITLE OF THE ENTIRE TABLE.
► IT’S NOT A HEADER FOR A PARTICULAR COLUMN
► SO WE SHOULD PROBABLY MERGE THESE ROWS.
► I LEFT-CLICKED IN A, I HELD DOWN THE SHIFT
► KEY, AND I PRESSED THE RIGHT ARROW.
► OR, YOU CAN JUST TAKE YOUR MOUSE LEFT CLICK,
► SELECT ALL THESE, LEFT CLICK AND DRAG.
► LET’S MERGE CELLS.
► IT’S A LITTLE ICON HERE THAT’S MERGING THEM
► SO YOU MERGE THEM TOGETHER.
► BUT, I WANT IT CENTERED HORIZONTALLY AS WELL
► SO THIS ICON GIVES YOU THREE OPTIONS.
► CENTER IT LEFT, CENTER IN THE MIDDLE CENTER
► TO THE RIGHT.
► LET’S PUT IT IN THE MIDDLE AND THEN LET’S
► MAKE IT BOLD.
► THAT WOULD BE RIGHT HERE AND WE’RE GONNA MAKE
► A -POINT SO YOU REALLY SEE, “HEY THIS IS
► TABLE WITH SAMPLE DATA.”
► ACTUALLY, I’M GONNA MAKE IT A LITTLE SMALLER.
► IT’S KIND OF ANNOYING.
► THERE WE GO.
► NOW WHAT I WANT TO DO IS A REALLY HANDY SHORTCUT
► THAT WAS ADDED JUST A FEW MONTHS AGO TO GOOGLE
► SHEETS.
► I’M GOING TO SELECT WHAT I’M CONSIDERING TO
► BE THE TABLE HERE.
► BUT, IF YOU SEE I ALSO SELECTED THE HEADER
► WHICH IS ROW AND THE FOOTER WHICH IS ROW
► YOU’LL SEE WHY HERE.
► I GO TO FORMAT.
► I’M GOING TO SAY ALTERNATING COLORS.
► WHY IT DOESN’T JUST SAY FORMAT IT AS A TABLE
► I DON’T KNOW.
► BUT, ALTERNATING COLORS, AND THEN ON THE RIGHT-HAND
► SIDE IT BRINGS UP THESE OPTIONS.
► NOW I HAVE A HEADER AND IT DOESN’T KNOW THAT
► I HAVE A FOOTER YOU GOT TO TELL IT THAT.
► I HAVE A FOOTER AS WELL.
► YOU SEE THE ROW THERE BECAME DARKER.
► I’M GONNA CLICK, AND CLICK IT AGAIN, AND THEN
► YOU JUST CHOOSE THE COLOR AND HIT DONE.
► NOW WHEN YOU LOOK AT THIS, IT LOOKS MORE LIKE
► A TABLE.
► IT’S APPARENT THAT THESE ARE THE TYPES OF
► UNITS THAT WE’RE LOOKING AT.
► THIS IS THE CONTENT, THE ACTUAL DATA.
► LET’S MAKE IT MORE APPARENT THOUGH THAT THESE
► DOWN HERE ARE TOTALS.
► I SELECTED A.
► I’M GOING TO HOLD DOWN MY CONTROL KEY AND
► SELECT G.
► THAT ENABLES YOU TO SELECT TWO INDIVIDUAL
► CELLS AT ONCE, TWO OR MORE.
► WHAT I’M GOING TO DO HERE IS PUT A BOTTOM
► BORDER ON.
► I’M NOT DOING AN UNDERLINE.
► I’M DOING A BOTTOM BORDER AND I’M GOING TO
► EXPLAIN THE DIFFERENCE.
► FIRST, I’LL LET YOU SEE IT.
► THERE’S THE TWO BOTTOM BORDERS.
► I DIDN’T DO AN UNDERLINE BECAUSE, IF YOU SORT
► THIS DATA FOR SOME REASON, THE UNDERLINE IS
► GOING TO MOVE.
► BUT, IF YOU DO A BOTTOM BORDER, IT SHOULD
► STAY WITH ROW .
► I ALSO DON’T LIKE THIS FONT.
► LET’S USE THE TRICK WHERE YOU SELECT THE ENTIRE
► WORKSHEET BY CLICKING IN THE UPPER LEFT HAND
► CORNER AND THEN WE’LL DROP DOWN THE FONT AND
► WE’LL CHANGE IT TO CALIBRI.
► I THINK THAT IT WOULD BE BETTER IF THE HEADER,
► THE CONTENT OF THE CELLS IN THE HEADER, WAS
► CENTER ALIGNED.
► LET’S CLICK ON THE TO SELECT THAT ENTIRE
► ROW AND THEN GO TO THE VERTICAL ALIGNMENT
► WHICH IS HERE.
► LINE UP VERTICALLY.
► LET’S SAY I WANT TO ZOOM IN % ON THIS,
► BUT WHEN I DO, THINGS ARE TOO WIDE.
► SO, I’M GOING MAKE THE UNIT COST WITHOUT A
► SPACE IN HERE.
► YOU’LL SEE WHY IN A LITTLE BIT.
► I’M GONNA MAKE THE UNIT COST A LOT SKINNIER
► LIKE THIS AND I GOING TO MAKE THE UNITS SKINNIER.
► THEN, MAYBE I COULD SEE EVERYTHING.
► LET’S MAKE IT A LITTLE BIT MORE SKINNY…A
► LITTLE BIT MORE.
► WHAT HAPPENED HERE WAS I MADE IT SO SKINNY
► THAT THIS ISN’T FITTING WELL.
► WHAT I HAVE TO DO IS, OR ONE OF THE OPTIONS
► THAT I CAN DO IS, TO ROTATE IT.
► YOU CAN DO THIS WITH ALL YOUR HEADERS IF YOU
► WANT.
► YOU COULD SELECT ROW AND ROTATE.
► THE OTHER OPTION-THIS UNIT COST IS ALSO RUNNING
► OVER A LITTLE BIT.
► I’M GOING TO SHRINK IT SOME MORE SO YOU CAN
► TELL.
► WHAT I’M DOING TO SHRINK THIS AND JUST CHANGING
► THE COLUMN WIDTH BY HOVERING OVER THE LINE
► THAT SEPARATES THE TWO.
► HOLDING DOWN THE LEFT MOUSE BUTTON AND MOVING
► LEFT AND RIGHT.
► MY OTHER OPTION TO MAKE THIS FIT, I COULD
► JUST SHRINK THE FONT BUT A FANCIER OPTION
► IS TO WRAP THE TEXT, WHICH IS THIS MIDDLE
► OPTION YOU SEE.
► THAT PUT ONE OVER THE OTHER.
► IF YOU DON’T LIKE HOW THE OTHERS ARE ALL DOWN
► AT THE BOTTOM OF THE ROW BECAUSE NOW THE ROW
► IS TALLER, LET’S CHANGE THE HORIZONTAL ALIGNMENT.
► THAT WOULD BE, WHERE WOULD THAT BE?
► VERTICAL ALIGNMENT, EXCUSE ME.
► LET’S CHANGE THE VERTICAL ALIGNMENT.
► LET’S PUT THEM IN THE MIDDLE.
► NOW THEY’RE ALL LINED UP.
► THAT SHOULD PRETTY MUCH COVER THE BASIC THINGS
► THAT YOU CAN DO WITH YOUR DATA TO FORMAT IT
► AND MAKE IT LOOK MORE LIKE A TABLE.
► THIS DRAWS THE USERS EYE DOWN TO THE IMPORTANT
► PARTS OR UP TO THE IMPORTANT PARTS LIKE THE
► HEADER OR DOWN TO THE FOOTER.
► LET’S GO AHEAD AND MAKE THESE BOLD.
► THAT WAY IT’S MORE APPARENT THAT THEY’RE THE
► SUM.
► WHEN YOU’RE USING GOOGLE SHEETS, A VERY BASIC
► CONCEPT THAT YOU USE ALL THE TIME WHEN YOU’RE
► WORKING WITH DATA IS CELL REFERENCES.
► WE WILL GO THROUGH FOUR DIFFERENT TYPES OF
► CELL REFERENCES.
► WE WILL START WITH THE MOST BASIC AND WORK
► OUR WAY THROUGH TO REFERENCING CELLS AND OTHER
► FILES.
► THE MOST BASIC TYPE OF CELL REFERENCE IS CALLED
► A RELATIVE CELL REFERENCE.
► IT’S THE TYPE THAT YOU JUST TYPE RIGHT IN.
► IN THIS CASE, IT’S GOING TO BE C.
► YOU USE UPPERCASE.
► THAT’S THE STANDARD SYNTAX THAT YOU ARE SUPPOSED
► TO USE, BUT LOWERCASE WORKS FINE TOO.
► IN THIS CASE, WE’RE GOING TO DO =C-D.
► S FEW THINGS TO KEEP IN MIND HERE.
► YOU ALWAYS TYPE THE COLUMN LETTER FIRST AND
► THEN THE ROW NUMBER.
► SO, WE WANTED COLUMN C ROW .
► THEN WE’RE JUST GOING TO SUBTRACT D WHICH
► IS THE EXPENSES.
► WE’RE GOING TO TRY TO CALCULATE OPERATING
► INCOME.
► YOU WOULD SAY THESE ARE TWO RELATIVE CELL
► REFERENCES.
► I’M GOING TO PRESS ENTER.
► YOU WILL SEE WHY THEY’RE RELATIVE IN THIS
► NEXT STEP.
► THAT DID STRAIGHT SUBTRACTION.
► BUT, IF YOU COPY IT DOWN TO THESE NEXT TWO
► ROWS…AND TO DO THAT I’M GOING TO GO IN THE
► LOWER RIGHT HAND CORNER WHERE YOU SEE A LITTLE
► BLUE SQUARE AND MY CURSOR TURNS INTO A PLUS
► SIGN.
► I’M GOING TO HOLD MY LEFT MOUSE KEY DOWN AND
► DRAG.
► THAT’S GOING TO COPY IT DOWN.
► NOW YOU COULD ALSO DOUBLE CLICK ON THAT SQUARE
► AND IT WILL COPY IT DOWN AS FAR AS THE DATA
► ON THE LEFT GOES.
► IT’S KIND OF SMART IN THAT WAY.
► I’M GOING TO LET GO AND HERE’S WHAT I MEAN
► BY THESE BEING RELATIVE REFERENCES.
► WHEN YOU LOOK BACK AND CELL E, IT WAS C-D.
► WHEN YOU COPIED IT DOWN IT BECAME C-D.
► WITHOUT THOSE CHANGE, SPREADSHEETS WOULD WORK
► WAY DIFFERENTLY.
► THOSE BEING SMART ENOUGH TO INCREMENT MAKES
► SPREADSHEETS FAR EASIER TO WORK WITH.
► THAT’S RELATIVE CELL REFERENCES IN THEIR MOST
► BASIC FORM.
► NOW, THIS NEXT TYPE OF CELL REFERENCE IS CALLED
► A FIXED CELL REFERENCE AND I WILL SHOW YOU
► WHERE YOU MIGHT WANT SOMETHING LIKE THAT IN
► THIS NEXT EXAMPLE.
► IN THIS CASE, TO CALCULATE THE TAX, YOU WANT
► CELL E AND THEN YOU WANT TO MULTIPLY IT BY
► D WHICH IS WHERE THE TAX RATE IS AND IT WORKS
► FINE.
► THERE, THAT’S THE RIGHT AMOUNT.
► I KNOW IT’S A NEGATIVE TAX, BUT YOU HAD A
► LOSS.
► IF I COPY THAT FORMULA DOWN TO F AND F,
► IT STOPS WORKING AND EVEN GETS WORSE.
► FIRST IT GIVES ZERO AND THEN IT GIVES AN ERROR.
► WHAT IS HAPPENING HERE IS THAT IT THINKS THESE
► ARE BOTH RELATIVE CELL REFERENCES BECAUSE
► THAT’S THE WAY YOU TYPED THEM IN.
► IF I LOOK AT F, IT INCREMENTED D DOWN .
► BECAUSE YOU MOVE THE FORMULA DOWN , YOU HAVE
► TO TELL GOOGLE SHEETS
► THAT D SHOULDN’T MOVE AND HOW YOU SPECIFY
► THAT AS YOU PUT A LITTLE $ BEFORE THE .
► THAT’S A FIXED CELL REFERENCE.
► IF THE COLUMN WERE MOVING.
► IF YOU WERE COPYING THESE FORMULAS FROM LEFT
► TO RIGHT, YOU COULD FIX THE COLUMN AS WELL.
► BUT IT DOESN’T MATTER BECAUSE THE COLUMNS
► NOT CHANGING.
► SO, LET’S TAKE THAT OUT FOR NOW TO LEAVE IT
► CLEAN.
► LET’S COPY THAT FORMULA DOWN.
► JUST SO WE’RE CONSISTENT, LET’S GO BACK INTO
► F AND MAKE THAT FIXED AS WELL EVEN THOUGH
► THAT’S NOT CAUSING A PROBLEM UNTIL YOU GO
► DOWN.
► NOW WE HAVE THE SAME FORMULA IN ALL THOSE
► CELLS.
► LET’S JUST GO AHEAD AND FILL IN THE NET INCOME
► BECAUSE WE NEED IT FOR THE NEXT STEP.
► I’LL DO THAT.
► I’LL COPY THAT DOWN WITH THE PLUS SIGN.
► I’M GOING TO DOUBLE CLICK, IT COPIES IT DOWN
► BUT IT STOPS HERE BECAUSE THERE’S NO NUMBERS
► TO THE LEFT.
► WE HAVE A TOTAL INCOME OF $,.
► IN THIS EXAMPLE I HAVE OTHER INCOME.
► IT’S ON THIS OTHER SHEET AND I WANT TO PULL
► IN THE INCOME FROM THERE.
► I CAN DO A CELL REFERENCE.
► WHAT YOU DO IS START IT WITH AN = LIKE YOU
► ALWAYS DO AND THEN THE EASIEST WAY IS JUST
► TAKE YOUR MOUSE, GO OVER TO THE OTHER INCOME,
► AND SELECT THE CELL.
► I’M GOING TO TAP C.
► OVER HERE, ON THE RIGHT, IT SHOWS YOU WHAT’S
► IN THE CELL ON THE OTHER SHEET.
► IT’S A LITTLE PREVIEW WINDOW.
► THAT’S WHAT YOU WANT.
► HIT ENTER AND IT BRINGS OVER THAT ,.
► IF YOU WANTED TO AUTOMATE THIS, OR TYPE IT
► IN, YOU HAVE THESE LITTLE ACCENT MARKS.
► THEY’RE LIKE A SINGLE QUOTE, AND THEN THE
► NAME OF THE SHEET, AND THEN YOU CLOSE IT OFF
► WITH ANOTHER ACCENT.
► THEN, YOU HAVE TO PUT AN !, AND THEN THE CELL
► REFERENCE.
► WE DID ALL THAT IN THERE AND YOU’RE GOOD.
► THE LAST TYPE OF REFERENCE THAT WE’RE GOING
► TO DO IS A REFERENCE TO ANOTHER FILE.
► SINCE WE’RE USING GOOGLE SHEETS, IT’S ALL
► ONLINE.
► TO FIND THE FILE WE’RE ACTUALLY GOING TO USE
► THE ADDRESS OR URL TO IT.
► I’LL SHOW YOU HOW TO GET THAT.
► FIRST, YOU’RE GOING TO START IT WITH = AND
► THE FUNCTION THAT YOU USE IS IMPORTRANGE EVEN
► THOUGH WE’RE JUST PICKING UP ONE CELL, IT’S
► A CALLED A RANGE.
► IF YOU LOOK AT THIS SYNTAX, GOOGLE SHEETS
► IS TELLING YOU AN IMPORTANT THING HERE.
► DON’T FORGET THE QUOTES.
► IF YOU DON’T HAVE THE QUOTES, IT WON’T WORK.
► WE’RE GONNA PUT IN A QUOTE AND THEN I’M GOING
► TO GO OUT A FULL SCREEN ON MY BROWSER.
► I HAVE THIS OTHER FILE OPEN.
► TO GET THE URL, GO TO THE FILE THAT YOU’RE
► LINKING TO, CLICK THE SHARE BUTTON IN THE
► UPPER RIGHT HAND CORNER, AND USE THIS URL
► THAT IT GIVES YOU.
► I JUST SET THIS TO ANYONE IN MY ORGANIZATION
► CAN EDIT.
► IT SHOULD PROBABLY WORK WITH WHATEVER SETTING
► YOU HAVE THERE AS LONG AS IT YOU OWN BOTH
► FILES.
► I COPIED THAT URL.
► LET’S LOOK REAL QUICKLY AT THE FILE.
► THIS CELL THAT WE WANT IS IN D HERE.
► REMEMBER THAT.
► GO BACK TO THE LINK.
► WE’RE GONNA TO GO INTO THE FORMULA BAR RIGHT
► NOW TO PASTE THIS.
► CLOSE IT OFF WITH A QUOTE TOO.
► DO A COMMA.
► NOW, THE NEXT INPUT THAT IT WANTS IS THE CELL
► REFERENCE.
► AS LONG AS IT’S ON THE FIRST SHEET IN THAT
► FILE, YOU DON’T NEED THE NAME OF THAT SHEET.
► IF YOU DO NEED A NAME OF THE SHEET, JUST DO
► IT THE WAY THAT WE DID A LOT CELL REFERENCE.
► YOU SEE HERE, WHERE I’M MOVING MY MOUSE.
► THE OTHER QUIRK HERE IS THAT IT NEEDS QUOTES.
► YOU USUALLY DON’T NEED A QUOTE ON CELL REFERENCE
► SO IT’S EASY TO FORGET IT WHEN YOU’RE DOING
► THIS.
► LET’S SURROUND IT IN QUOTES.
► REMEMBER, WE WANT IT AT D.
► LET’S DO D, CLOSE IT OFF WITH QUOTES, AND
► A PARENTHESIS.
► NOW, IF THIS IS THE FIRST TIME YOU’RE DOING
► THIS.
► WHEN YOU HIT ENTER, IT’S GOING TO ASK FOR
► YOUR PERMISSION.
► BUT, I’VE DONE THIS BEFORE WHEN I WAS TRYING
► TO GET THIS LITTLE VIDEO TOGETHER SO IT’S
► NOT GOING TO ASK ME.
► IT’S GOING TO TAKE A SECOND THINK ABOUT IT.
► THEN IT PULLED IT IN.
► WE CAN CHANGE THAT FORMAT IF YOU WANT.
► A LOT OF TIMES YOU CAN’T TELL WHAT FORMAT
► IT’S GOING TO COME OVER IN UNTIL YOU SEE IT.
► JUST GET THAT DOLLAR SIGN OFF.
► LET’S TAKE THE DECIMAL POINTS AWAY.
► NOW EVERYTHING LOOKS REAL NICE.
► THAT’S IT.
► YOU HAVE RELATIVE, YOU HAVE FIXED, YOU HAVE
► TO ANOTHER SHEET, AND THEN YOU HAVE TO ANOTHER
► FILE.
► WE’RE GONNA USE THIS SIMPLE TABLE OF DATA
► HERE TO SHOW YOU THE BASIC PARTS OF FORMULAS
► IN SPREADSHEETS, WHAT THE DIFFERENT TYPES
► ARE CALLED, AND HOW TO COMBINE THEM TOGETHER
► TO DO MOST ANYTHING YOU WANT.
► THE FIRST FORMULA THAT WE’RE GOING TO DO IS
► WE’RE JUST GOING TO CALCULATE THE ORDER TOTAL
► AND THAT’S GOING TO BE THE QUANTITY TIMES
► THE PRICE.
► IF YOU WANT TO USE YOUR SPREADSHEET JUST LIKE
► AN OLD CALCULATOR, ALL YOU DO IS JUST TYPE
► THE VALUES DIRECTLY IN.
► WRITE TIMES $. AND THAT’S GONNA GET
► YOU TO ..
► BUT, THE PROBLEM WITH DOING IT THIS WAY IS
► THAT YOU CAN’T COPY THIS FORMULA DOWN AND,
► IF THESE VALUES CHANGE, THIS FORMULA DOESN’T
► AUTOMATICALLY UPDATE BECAUSE IT’S JUST HARD
► CODED.
► THIS IS PROBABLY THE MOST BASIC TYPE OF FORMULA
► THAT YOU CAN DO BUT IT’S NOT VERY USEFUL.
► YOU DON’T WANT ANY HARD CODED SO LET’S DELETE
► THAT AND LET’S START OVER.
► LET’S TYPE AN EQUAL SIGN.
► THAT STARTS EVERY FORMULA.
► IN ANY FORMULA OR FUNCTION OR WHATEVER YOU
► DO IN GOOGLE SHEETS THAT’S NOT A VALUE, YOU
► NEED TO START WITH AN EQUALS SIGN.
► THEN, IT GIVES YOU THIS GRAY BRACKET UNDERNEATH
► AND WHAT THAT’S SAYING IS YOUR FORMULA HAS
► JUST STARTED.
► I NEED SOME DATA.
► IT’S NOT FINISHED YET SO IT’S WAITING FOR
► INPUT.
► THE FIRST CELL THAT WE WANT TO GIVE IT IS
► B.
► LEFT-CLICK YOUR MOUSE IN B AND IT’S ALREADY
► CALCULATING SAYING I’VE GOT A VALUE, IT’S
► BUT YOU’RE NOT DONE YET, RIGHT?
► YOU WANT TO MULTIPLY THAT BY C.
► LET’S GRAB THAT VALUE.
► YOU’RE GETTING . WHICH IS WHAT YOU GOT
► WHEN YOU HARD KEYED BUT THIS ONE’S MORE FLEXIBLE.
► IF I HIT ENTER AND I GO BACK AND I CHANGE
► . TO ., THIS FORMULA UPDATES.THIS FORMULA
► UPDATES BU IT WOULDN’T IF YOU HARD KEYED IT.
► ANOTHER BIG ADVANTAGE OF USING FORMULAS IS
► YOU CAN COPY THEM DOWN.
► SO I SELECTED THIS CELL AND IN THE LOWER RIGHT
► HAND CORNER YOU GET A LITTLE SQUARE.
► IF YOU HOVER OVER THAT WITH YOUR MOUSE IT
► TURNS INTO A PLUS SIGN.
► LEFT-CLICK AND DRAG IT DOWN OR YOU CAN DOUBLE
► CLICK TOO AND STOP WHERE YOU WANT YOUR FORMULAS
► TO STOP AND IT COPIES THEM ALL DOWN.
► IT SAVES YOU A TON OF TIME.
► THAT’S YOUR MOST BASIC TYPE OF FORMULAS.
► CELL REFERENCES, WHICH IS THE FIRST LINE HERE,
► COMBINED WITH OPERATORS.
► JUST MULTIPLYING TWO CELL REFERENCES TOGETHER.
► THE SECOND THING THAT YOU CAN DO AFTER YOU
► HIT THE EQUAL SIGN IS USE A FUNCTION.
► I’M GOING TO SHOW YOU THE COUNT FUNCTION WORKS.
► AND AGAIN, I HIT EQUAL.
► IT’S WAITING FOR SOMETHING.
► THAT’S WHAT THE GRAY BRACKET IS.
► I’M GOING TO TYPE IN COUNT AND I’M GONNA DO
► WITH MY CAPS LOCK ON BECAUSE YOU’RE SUPPOSED
► TO DO THESE THINGS IN UPPERCASE IF YOU REALLY
► WANT TO BE PROPER.
► BUT, YOU CAN DO IT IN LOWERCASE TO IF YOU
► WANT.
► SO I TYPED IN COUNT.
► THIS IS LISTING ALL OF THE FUNCTIONS THAT
► ARE AVAILABLE THAT START WITH COUNT.
► YOU CAN SEE IT WAS FILTERING AS I TYPE SO,
► IF YOU JUST HAVE A C IN HERE, IT’S GONNA SHOW
► YOU EVERYTHING THAT STARTS WITH C. ANOTHER
► WAY TO INPUT THIS FUNCTION IS TO GO TO INSERT
► FUNCTION AND THIS WILL SHOW YOU THE MOST COMMON
► FUNCTIONS.
► ACTUALLY, COUNT IS ON HERE BECAUSE YOU WILL
► USE COUNT ALL THE TIME.
► LET’S LEFT-CLICK ON THAT AND THIS PUT IN THE
► TWO PARENTHESES FOR ME.
► EVERY FUNCTION HAS TO HAVE AN OPENING IN A
► CLOSING PARENTHESIS AND THOSE TELL THE SPREADSHEET
► WHEN YOU’RE STARTING TO GIVE IT INPUT AND
► WHEN YOU’RE DONE.
► AS YOU START TO LOOK AT THE HELPER TEXT DOWN
► HERE WHICH ALWAYS POPS UP AFTER YOU TYPE IN
► THE NAME OF THE FORMULA AND YOU HIT THE FIRST
► PARENTHESIS.
► IT CAN TAKE A VALUE BUT IT CAN TAKE OTHER
► VALUES TOO IF YOU WANT.
► SO THIS IS IN BRACKETS.
► WHAT THAT’S SAYING IS IT’S OPTIONAL.
► WE’RE ON VALUE ONE RIGHT NOW AND THAT’S HIGHLIGHTED
► BECAUSE SHEETS IS TELLING YOU THAT’S WHERE
► YOU ARE.
► IF YOU GO DOWN, IT ALSO HAS A LITTLE GRAY
► TRIANGLE WHICH IS GIVING YOU AN EXPLANATION
► FOR WHAT VALUE ONE IS AND IT’S JUST SAYING
► GIVE ME THE RANGE OF DATA THAT YOU WANT ME
► TO COUNT.
► I’M GONNA DO IT WITH MY MOUSE.
► YOU CAN ALSO JUST TYPE IT IN OR USE THE ARROW
► KEYS.
► IN THIS CASE, I WANT D THROUGH D.
► LEFT-CLICK IN D, HOLD DOWN THE LEFT MOUSE
► KEY, AND DRAG DOWN TO D.
► LET OFF THE MOUSE KEY AND YOU SEE IT PUT THE
► RANGE INTO THE FUNCTION.
► THIS FUNCTION IS DONE IF YOU WANT IT TO BE.
► NOW, THERE’S NO LITTLE GRAY BRACKET HERE WAITING
► FOR MORE DATA AND IT’S SHOWING YOU A VALUE
► THAT IT’S CALCULATED.
► LET’S GO AHEAD AND PRESS ENTER.
► I’VE COUNTED FOUR.
► WE’RE ALSO GOING TO DO A TOTAL.
► THIS IS GOING TO BE ANOTHER VERY COMMON FUNCTION
► THAT’S GOING TO WORK THE SAME WAY AND I JUST
► DID THAT ONE WITH MY ARROW KEYS.
► YOU SEE IF YOU DO THESE A LOT, YOU GET FAST
► AT IT.
► THE NEXT CONCEPT THAT I WANT TO SHOW YOU IS
► STRINGING FUNCTIONS TOGETHER FOR A LONGER
► FORMULA.
► YOU CAN STRING THEM TOGETHER WITH OTHER OPERATORS.
► IN THIS CASE, WE’RE GOING TO CALCULATE THE
► AVERAGE.
► YOU WOULD CALCULATE THE AVERAGE BY DIVIDING
► THE TOTAL BY THE COUNT, RIGHT?
► ALTHOUGH I JUST DID THESE IN THESE TWO CELLS,
► YOU REALLY COULD DO D DIVIDED BY D.
► THAT’S THE AVERAGE.
► YOU COULD ALSO KIND OF HOMEBREW A FUNCTION
► HERE.
► YOU COULD PUT THE SUM IN THE NUMERATOR AND
► THEN YOU COULD DIVIDE IT BY THE COUNT AS THE
► DENOMINATOR.
► CLOSE OFF THE PARENTHESES AND TYPE ENTER.
► IT’S THE SAME THING.
► SO, YOU STRUNG TWO FUNCTIONS TOGETHER.
► YOU COULD ALSO JUST USE THE AVERAGE FUNCTION
► IF YOU KNEW THAT EXISTED AN AVERAGE THESE
► CELLS.
► CLOSE OFF THE PARENTHESES.
► HIT THE ESCAPE KEY.
► CLOSE OFF THE PARENTHESES.
► HIT ENTER.
► SAME VALUE.
► LET’S GIVE THIS A DATE, RIGHT?
► IF YOU WANT TO GIVE IT TODAY’S DATE JUST USE
► A POPULAR FUNCTION CALLED TODAY.
► IT DOESN’T NEED ANY INPUTS BUT IT STILL NEEDS
► PARENTHESES BECAUSE IT’S A FUNCTION.
► TYPE ENTER.
► THERE YOU GO.
► THAT’S THE BASICS OF HOW TO USE FORMULAS IN
► GOOGLE SHEETS.
► I HAVE AN EXAMPLE SPREADSHEET HERE THAT HAS
► SOME PRETTY TYPICAL DATA IN IT.
► WHEN YOU HAVE DATA LIKE THIS, A LOT OF TIMES
► YOU JUST WANT TO PUT IT IN A DIFFERENT ORDER
► WHICH WOULD BE SORT.
► OR YOU ONLY WANT TO SHOW PART OF IT BASED
► ON SOME SORT OF CRITERIA AND THAT WOULD BE
► FILTER.
► I’LL SHOW YOU SORT FIRST AND THEN WE’LL GET
► INTO FILTERING A FEW ITEMS.
► KEEP IN MIND THOUGH, YOU CAN DO THIS TWO MAIN
► WAYS.
► WE’RE GOING TO SORT AND FILTER FROM THE MENUS
► FIRST BUT THEN I’LL SHOW YOU A NEW CONCEPT
► THAT DIDN’T REALLY EXISTS IN PREVIOUS SPREADSHEETS
► IS THAT THERE’S FUNCTIONS THAT CAN DO SORT
► AND FILTER.
► TO DO THOSE, WE’LL GO DOWN BELOW BECAUSE THEY
► PRODUCE A NEW LIST THAT’S BASED ON THE DATA
► IN THIS LIST.
► ALL RIGHT, WHAT YOU TYPICALLY WANT TO DO IS
► SELECT THE TABLE.
► THAT’S GONNA MAKE THIS EASIER.
► THEN YOU GO TO THE DATA MENU AND THEN DO SORT
► RANGE.
► THERE’S SHORTCUTS UP HERE IF YOU JUST WANT
► TO SORT THE ENTIRE SHEET.
► THAT’S NOT GOING TO KNOW WHERE YOUR HEADER
► IS THOUGH SO THAT’S GONNA SORT THE HEADER
► TOO.
► MAYBE THAT’S OKAY.
► YOU CAN ALSO JUST SORT A RANGE BUT WE ALREADY
► SELECTED THE RANGE SO LET’S JUST GO DOWN TO
► THE SORT RANGE OPTION.
► IT’S GOING TO GIVE YOU A POP UP.
► I THINK IT’S EASIER TO USE.
► THERE’S A COUPLE OPTIONS ON HERE THAT WE CAN
► TALK THROUGH THAT YOU’RE GONNA WANT TO CHANGE
► FROM TIME TO TIME AND THEY’RE NOT IN THOSE
► SHORTCUTS IF YOU DO THE OTHER OPTIONS ON THE
► MENU.
► IT’S TELLING YOU, LOOK WE’RE LOOKING AT SORTING
► A THROUGH G WHICH IS WHAT YOU HIGHLIGHTED
► BACK HERE BEHIND THIS BOX.
► BUT, WE DID HAVE A HEADER ROW AND I DON’T
► WANT THAT SORTED SO PUT THE CHECK MARK THERE.
► IT’S SMART ENOUGH TO TAKE THE NAMES FROM THE
► HEADER ROW AND PUT THEM IN THIS DROP-DOWN
► LIST NOW THAT YOU TOLD IT IT HAS A HEADER.
► IN THIS CASE WE’RE JUST GONNA WANT TO SORT
► THIS BY REGION BECAUSE WE WANT TO SEE WHAT
► HAPPENED IN EVERY REGION REGION.
► KEEP IT FROM A TO Z AND WITHIN THOSE REGIONS
► WERE GONNA WANT TO SORT IT BY REP NAME.
► YOU CLICK SORT.
► IT DID NOT DELETE ANY DATA.
► IT’S SHOWING YOU THE EXACT SAME DATA AND YOU
► DON’T HAVE TO UNSORT IT TO DO ANYTHING.
► YOU CAN LEAVE IT LIKE THIS.
► IF YOU NOTICE IT DOES IT BY REGION ALPHABETICALLY
► AND THEN WITHIN THAT REGION IT DID IT ALPHABETICALLY
► BY THE NAME OF REP. THAT MAYBE IS ALL YOU
► WANTED TO DO IN WHICH CASE ALL YOU NEED IS
► SORT AND YOU’RE DONE.
► BUT, IF YOU WANT TO TAKE THIS A STEP FURTHER
► BY DOING SOME MORE ANALYSIS, LET’S SELECT
► THE TABLE AGAIN, GO TO DATA, AND LET’S TRY
► FILTER.
► I TURNED THE FILTER ON AND YOU CAN SEE AT
► THE TOP OF EVERY COLUMN OF DATA, YOU GOT THIS
► UPSIDE DOWN TRIANGLE.
► THAT’S LETTING YOU KNOW THAT YOU CAN FILTER
► THAT COLUMN.
► BUT, THERE IS NO FILTER SELECTED YET.
► IF YOU WANT TO SEE JUST THE PENCILS THAT WERE
► SOLD, YOU WANT TO CLEAR ALL OF THESE.
► JUST CLICKED UNCLEAR AND JUST HIGHLIGHT THE
► PENCILS.
► CLICK OK.
► THAT FILTERED OUT EVERYTHING ELSE IN THE LIST.
► THE DATA IS STILL THERE.
► AS YOU CAN SEE, IT GOES FROM TO SO THOSE
► ROWS STILL EXIST BUT THEY’RE HIDDEN FROM VIEW.
► ONE CONCEPT HERE THAT’S IMPORTANT TO KNOW
► IS THAT IF I SUM THESE, IF I JUST DO E TO
► E, THEN YOU’LL GET WHICH IS THESE TWO
► BEING ADDED TOGETHER.
► BUT, IF YOU DO THE WHOLE RANGE, AND AGAIN
► YOU CAN SEE THIS GOES DOWN TO ROW , IT’S
► JUST HIDDEN, IT STILL PICKS UP THOSE VALUES.
► THEY’RE UNDERNEATH AND YOUR FORMULAS CAN PICK
► THEM UP IF YOU’RE DOING SIMPLE FORMULAS LIKE
► SUM AND COUNT.
► BUT, I DIGRESS.
► THAT’S ONE TYPE OF FILTER.
► RESET YOUR FILTER.
► JUST CLICK SELECT ALL SO ALL OF THEM ARE IN
► PLAY AND THEN DO TEXT CONTAINS PEN.
► THAT’LL PICK UP PENCILS, PEN SET, AND PIN.
► THEN, ONCE YOU HAVE A FILTER ON, YOU CAN SEE
► THAT CHANGES FROM AN IMAGE OF THE UPSIDE-DOWN
► TRIANGLE TO FILTER SO YOU KNOW THAT THERE’S
► AN ACTIVE FILTER ON HERE SO THAT TELLS YOU
► IT’S PROBABLY NOT SHOWING EVERYTHING RIGHT
► NOW AND THAT’S TRUE.
► IT STILL GOES , , .
► IS HIDDEN AND IS HIDDEN.
► WHILE YOU HAVE A FILTER ON YOU COULD STILL
► DO ANOTHER SORT OR ANOTHER FILTER BUT LET’S
► JUST SORT THIS BY REP. THE FILTER STAYS.
► IT’S STILL SHOWING ONLY THE THINGS THAT HAVE
► THE LETTERS PEN IN THEM BUT THIS IS SORTED
► SO IT’S NOT FILTERED SO IT DIDN’T TURN INTO
► A FUNNEL BUT YOU COULD ALSO DO ANOTHER FILTER
► IF YOU WANTED.
► LET’S CLEAR ALL OF THEM AND JUST SO TO SHOW
► JONES AND MORGAN.
► AND THERE YOU GO.
► THERE’S TWO FILTERS APPLIED.
► YOU CAN APPLY AS MANY FILTERS AS YOU WANT.
► THAT’S THE BASICS OF HOW TO USE SORT AND FILTER
► THROUGH THE MENU.
► WE’RE GOING TO TURN THAT OFF.
► THERE’S A COUPLE DIFFERENT WAYS TO TURN IT
► OFF.
► I’M GONNA TO TURN OFF FILTER.
► IMAGINE THAT THIS IS THE DATA THAT WE STARTED
► WITH.
► I WANT TO GET RID OF THIS ROW THAT’S HIGHLIGHTED
► LIKE IT’S PART OF THE TABLE.
► I DON’T LIKE THAT.
► I’M GONNA RIGHT-CLICK, DELETE ROW.
► NOW I WANT TO SHOW YOU THE SECOND MAIN WAY
► TO SORT AND FILTER WHICH IS USING FUNCTIONS.
► THERE’S THREE DIFFERENT FUNCTIONS THAT WE’RE
► GOING TO GO OVER.
► THE FIRST ONE IS SORT.
► HIT =SORT.
► OPEN IT UP WITH AN OPENING PARENTHESIS WHICH
► GOES ON EVERY FUNCTION AND THEN IT KNOWS.
► YOU DO THE PARENTHESES AND IT’S READY TO ROCK.
► LET’S GIVE IT A RANGE.
► IN THIS CASE, LET’S DO A TO G.
► MATTER OF FACT, LET’S DO A SO WE DON’T PICK
► UP THE HEADER, WE WANT TO LEAVE THE HEADER
► THERE, TO G.
► LET’S LOOK AT THE HELPER TEXT AGAIN.
► THE SECOND THING IT WANTS IS THE SORT COLUMN.
► IT’S, “WHAT DO YOU WANT ME TO SORT IT BY?”
► LET’S DO IT BY THE REP. THAT’S SORT COLUMN
► THREE.
► IT WANTS A NUMBER, NOT THE NAME OF THE HEADER.
► WE WANT IT TO BE ASCENDING SO LEAVE THAT AS
► TRUE.
► NOW YOU SEE THE NEXT THING IN THE HELPER TEXT
► IS BRACKETS WHICH IS SAYING IT’S NOT NECESSARY,
► IT’S OPTIONAL.
► SO LET’S END THIS HERE.
► WHEN I HIT ENTER IT’S GOING TO WRITE THIS
► OUT TO THE RIGHT AND DOWN BELOW IT.
► SO START IT WHERE IT HAS ROOM TO WORK.
► AND THEY’RE SORTED LISTS.
► YOU SEE IT GOT RID OF THE FORMATTING.
► THAT’S ALRIGHT, YOU DIDN’T NEED IT.
► THIS IS ALL DYNAMIC SO, IF YOU CHANGE WHAT’S
► IN THE ORIGINAL LIST, IT WILL CHANGE DOWN
► HERE.
► IF YOU CHANGE WHAT’S UP HERE IT’LL CHANGE
► WHAT WAS OUTPUT DOWN HERE.
► IF YOU CLICK IN ONE OF THESE COLUMNS AND HIT
► DELETE, DELETE, DELETE, IT DOESN’T GO ANYWHERE
► BECAUSE IT’S ALL BEING DRIVEN BY THE SORT
► FUNCTION IN A.
► IF YOU WERE TO GO IN A AND PRESS DELETE,
► IT GETS RID OF EVERYTHING.
► THE SECOND FUNCTION THAT YOU DO IS A FILTER.
► YOU CAN GUESS HOW THIS IS GONNA WORK.
► WE DON’T HAVE TO GO THROUGH IT IN MUCH DEPTH
► BECAUSE IT’S THE SAME CONCEPT.
► IT’S GOING TO OUTPUT A NEW LIST THAT’S FILTERED
► BASED ON HOW YOU WANT IT TO BE AND IT’S DYNAMIC.
► IF YOU CHANGE WHAT’S ABOVE, IT’LL CHANGE WHAT’S
► OUTPUT AND FILTER IT.
► IT MAY TAKE SOME TIME TO STUDY THIS ONE.
► IT’S A LITTLE BIT TRICKIER TO USE FILTER THROUGH
► A FUNCTION, I THINK.
► BUT THE LAST ONE THAT’S ADDED IS A NEW TYPE
► OF FUNCTION.
► IT’S CALLED SORTING.
► THIS ONE KIND OF DESERVES ITS OWN LITTLE TUTORIAL
► I THINK.
► WHAT IT CAN DO IS, LET’S GIVE IT THE RANGE
► IS, IN PLAIN ENGLISH, IT’S SAYING “HEY,
► I WANT THE TOP SALESPEOPLE FROM HERE.
► I WANT THE LAST FIVE DATES.
► IT CAN SORT AND RETURN N NUMBER OF VALUES
► FROM YOUR DATA SET.
► WE’LL TRY ONE HERE.
► I WON’T GET INTO IT TOO MUCH.
► LET’S TRY A.
► THE TOP THREE.
► THAT’S ALL YOU HAVE TO DO.
► THE OTHER PARAMETERS ARE OPTIONAL.
► THERE WE GO.
► THAT’S THE FIRST THREE SALES.
► IF YOU WANT TO LEARN MORE ABOUT THESE FUNCTIONS
► OR ABOUT THE SORTING FUNCTION IN PARTICULAR,
► YOU CAN SUBSCRIBE TO MY CHANNEL.
► I DO LOTS OF TUTORIALS ON LITTLE THINGS, MOSTLY
► IN GOOGLE SHEETS WITH SOME OTHER THINGS AS
► WELL.
► I HOPE YOU ENJOYED THIS VIDEO AND THAT’S ALL.
► THANKS!

Video Link

About The Author

Related posts

Leave a Reply

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