Select your Top Menu from wp menus

Google Sheets Tutorial – Designed for Beginners

► HI THERE JAMIE KEITH HERE TONIGHT A
► TEACHERS TECH HOPE YOU’RE HAVING A GREAT
► NIGHT TONIGHT TONIGHT I’M GONNA GO OVER
► GOOGLE SHEETS SO THIS TUTORIAL IS GOING
► TO BE A COMPREHENSIVE GUIDE FOR GOOGLE
► SHEETS STARTING FROM SIMPLY FROM JUST
► STARTING IT TO APPLYING FORMATTING TO
► FUNCTIONS AND FORMULAS TO GRAPHING AND
► SO MUCH MORE TAKE A LOOK AT THE
► DESCRIPTION BELOW AT ALL THE DIFFERENT
► THINGS THAT ARE INCLUDED IN THIS AND
► I’LL TIMESTAMP IT SO WE CAN QUICKLY GO
► TO EACH PART SO IF YOU LEAVE THE VIDEO
► YOU CAN COME BACK AT A DIFFERENT TIME TO
► DIFFERENT PARTS IF YOU SEE ANYTHING DOWN
► BELOW THAT YOU’D LIKE ADDED IN A
► DIFFERENT TUTORIAL PLEASE JUST WRITE A
► COMMENT DOWN BELOW SO I CAN START ON
► SOME SMALLER VIDEOS THIS ONE ABOUT
► GOOGLE SHEETS AFTER THIS SO LET’S GET
► STARTED ON THIS TUTORIAL OF GOOGLE
► SHEETS TONIGHT
► SO YOU DO NEED TO BE LOGGED IN TO YOUR
► GOOGLE ACCOUNT I’M ALREADY IN MY GOOGLE
► DRIVE HERE MY FAVORITE WAY TO START ANY
► GOOGLE APPS IS TO BE FROM GOOGLE DRIVE
► AND SO IN THIS CASE WITH GOOGLE SHEETS I
► HAVE A FOLDER I ALREADY CREATED HERE AND
► I’M JUST GONNA GO INSIDE OF THIS IF I
► KNEW HOW I WANTED MY FILES SORTED I
► WOULD GO TO THAT FOLDER AND I WOULD
► RIGHT CLICK AND I CAN START AT GOOGLE
► SHEETS FROM HERE I CAN ALSO GO UP TO THE
► NEW AND START GOOGLE SHEETS SO IT’S JUST
► A SIMPLE WAY I LIKE TO KEEP THINGS
► ORGANIZED IN THIS YOU CAN ALSO GO UP TO
► GOOGLE SHEETS UP HERE WHEN YOU START IT
► WHEN YOU GO UP TO THIS WAY TO YOUR APP
► LAUNCHER IF YOU JUST START IT IT WILL
► JUST PUT IT INTO YOUR GENERAL GOOGLE
► DOCS THIS STEP WHAT I’M SHOWING YOU OVER
► HERE IS JUST TO TO SKIP A STEP SO THINGS
► ARE JUST A LITTLE BIT MORE ORGANIZED SO
► I’M JUST GONNA GO AHEAD AND OPEN IT FROM
► HERE AND YOU CAN SEE I’M IN MY GOOGLE
► SHEETS NOW JUST A LITTLE WALKTHROUGH YOU
► CAN SEE WHERE YOU’D UP HERE THIS IS
► WHERE MY MENU IS HERE UP HERE IS WHERE
► YOU’RE AN ENTITLED IT SO IF I WAS GONNA
► PUT A CLASSROOM LET’S SAY CLASSROOM
► MARKS ON THIS ONE I COULD JUST SIMPLY
► CLICK OFF OF IT AND THAT’S WHAT THIS IS
► GONNA BE THIS IS THAT THIS IS GONNA
► BE SAVED AS THAT IF I GO BACK YOU CAN
► SEE RIGHT AWAY IT’S ALREADY IN MY GOOGLE
► DRIVE AT ANY POINT TO YOU CAN CLICK ON
► THE SHEETS HOME AND THIS WILL GIVE YOU
► KIND OF A QUICK VIEW OF THE DIFFERENT
► SHEETS THIS IS THE ONE I JUST CREATED
► RIGHT HERE YOU CAN ALSO KIND OF NAVIGATE
► YOUR WAY THROUGH DIFFERENT THINGS I CAN
► GO BACK TO MY DRIVE THIS WAY OR GO OVER
► TO SOME OTHER GOOGLE APPS ON THIS ONE
► I’M JUST GOING TO GO BACK AND OPEN UP
► THE ONE I JUST CREATED SO A LITTLE BIT
► OF A WALK AROUND HERE BEFORE I GET
► STARTED WITH SOME BASIC FORMATTING YOU
► CAN SEE THAT WE HAVE OUR ROWS AND OUR
► COLUMNS WE HAVE OUR MENU BAR UP TOP ROLE
► WHERE I’LL BE TALKING ABOUT A BUNCH OF
► DIFFERENT THINGS THE OTHER THING IS THAT
► WE CAN CREATE DIFFERENT SHEETS DOWN
► BELOW SO YOU CAN SEE I’M ON SHEET
► RIGHT HERE IF I EVER WANT A NEW SHEET I
► CAN CREATE A NEW SHEET RIGHT WITHIN IT
► AND THESE CAN BE THESE
► BE DRAGGED AROUND SO I COULD PUT THEM IN
► DIFFERENT ORDERS ORDER THEM SO THIS IS
► SAVED WITHIN THE SAME FILE I COULD
► CREATE ALL THESE DIFFERENT SHEETS WITHIN
► THIS OR ELSE IF YOU WANTED TO CREATE A
► NEW SHEET IF YOU GO UP HERE AND IF I GO
► FILE NEW SPREADSHEET NOTICE A NEW TAB SO
► THIS IS A COMPLETELY NEW TAB THAT’S OPEN
► AND IF I GO BACK TO THIS ONE YOU CAN SEE
► I HAVE MY TWO SHEETS AT THE BOTTOM
► WITHIN THIS ONE FILE BUT IF I GO OVER TO
► HERE THIS IS A BRAND NEW ONE THAT I CAN
► CREATE MY DIFFERENT SHEETS AT THE BOTTOM
► SO THAT’S JUST KIND OF YOUR BASIC WALK
► AROUND WHAT I’M GOING TO DO FIRST IS
► START WITH SOME BASIC EDITING OR BASIC
► FORMATTING OF GOOGLE SHEETS SO LET’S
► TALK ABOUT SOME BASIC ENTERING OF
► INFORMATION INTO A SPREADSHEET SO I JUST
► STARTED WORKING ON THE CLASS ROSTER A
► LITTLE BIT AND I’M JUST GOING TO ENTER
► IN A COUPLE MORE HERE SO I JUST WANT
► HAVE A COUPLE MORE NAMES TO ENTER IN AND
► THEN I’LL DO A LITTLE FORMATTING WITH
► THIS TOO SO IF I GO AHEAD AND CLICK IN A
► CELL SO LET’S SAY FOR A I CAN ENTER
► IN INFORMATION SO LET’S SAY IF I WOULD
► HAVE A NAME LET’S SAY THE PERSON’S NAME
► WAS BEV TAYLOR AND I CAN JUST CLICK OUT
► OF IT OR THE I CAN USE THE ARROWS AND GO
► TO THE NEXT ONE OR HIT TAB AND IT WILL
► CONTINUE ON IF I USE THE ARROWS I CAN
► MOVE ALL AROUND OR CLICK INTO THE SPOT I
► WANT SO LET’S ADD OUR EMAIL ADDRESS I’M
► JUST GONNA MAKE UP AN EMAIL ADDRESS FOR
► HER I’LL JUST SAY TAYLOR AND LET’S SEE
► IF IT WAS AT THE SCHOOL COMM AND I WILL
► ADD JUST ONE MORE HERE WE’LL JUST CALL
► IT SMITH AND JOE AND WE’LL GO JOE DOT
► SMITH AT SCHOOL COMM ALL RIGHT SO WE
► HAVE SOME VACANT BASIC INFORMATION JUST
► SOME TEXT THAT WE’VE ENTERED IN SO RIGHT
► AWAY I CAN SEE AND I’VE TALKED ABOUT
► THIS NOTICE THAT THE EMAILS ARE KIND OF
► TOO LARGE FOR THE SPACE SO I DID SHOW
► YOU TEXT WRAPPING BEFORE BUT I DON’T
► REALLY WANT TO WRAP THIS I CAN GO UP TOP
► AND GRAB SO WHEN I GET THOSE ARROWS ARE
► EATEN HERE THEN I’M GONNA HOLD DOWN MY
► MOUSE AND I’M JUST GONNA STRETCH IT OPEN
► A LITTLE WIDER AND THEN TO MAKE IT SO
► EVERYTHING FITS IN HERE SO IT’S A QUICK
► WAY JUST TO MAKE EVERY DAY
► LOOK A LITTLE BIT NEATER IF YOU EVER
► TRYING TO MOVE THINGS QUICKLY IF YOU
► KNOW YOU NEEDED LET’S SAY A CERTAIN
► PERSON TO PUT SOMEWHERE ELSE IF YOU’RE
► STARTING ON I COULD GO AND SELECT SO
► I’VE SELECTED THEM I CAN RIGHT-CLICK AND
► COPY AND LET’S SAY IF I WANTED THIS
► EMAIL OVER HERE I COULD RIGHT-CLICK AND
► PASTE AND NOTICE THEY JUST PUT IT ACROSS
► IN THE THREE DIFFERENT CELLS THAT WERE
► THERE THIS HASN’T BEEN FORMATTED THIS
► ONE SO I CAN CHANGE IT THAT WAY IF YOU
► DON’T WANT IT YOU CAN JUST SIMPLY
► HIGHLIGHT IT AND YOU CAN HIT DELETE AND
► IT’S GONE REMEMBER YOU DO HAVE YOUR BACK
► YOUR BACK UNDO SO YOU CAN ALSO GO THAT
► WAY TOO IF YOU WANTED TO JUST GO BACK A
► STEP ON IT SO LET’S LOOK AT SOME OTHER
► FORMATTING THAT WE CAN DO WITH THIS SO
► IF I WANTED TO ADD SOME COLOR DIFFERENT
► ONES OR CHANGED THE TEXT ON IT OR THE
► FONT LET’S SAY IF I WANTED THE TOP
► CHANGED A BIT I COULD HIGHLIGHT ALL
► THREE SO I COULD DO ONE AT A TIME AND
► MAYBE I WANT THEM BOLD OR I COULD
► HIGHLIGHT MULTIPLE ONES TO MAKE IT A
► LITTLE FASTER AND HIT IT BOLD YOU NOTICE
► I HAVE MY ITALIC HERE IF I WANTED IT I
► STRAIGHT THROUGH AND I ALSO HAVE TEXT
► COLORS SO MAYBE I JUST DIDN’T WANT I
► WANTED I WANTED TO HAVE BLACK I COULD
► QUICKLY PICK A DIFFERENT COLOR FOR
► DIFFERENT ONES AGAIN I COULD GO BACK
► ONCE I SELECTED THE COLOR I CAN JUST
► SELECT ON IT HERE LET’S GO ORANGE DOWN
► SO THEN I HAVE ORANGE ON THOSE ONES YOU
► CAN ALSO HAVE IF I GO TO THE OTHER SIDE
► RIGHT HERE THE FILL COLOR SO THE FILL
► COLOR IS THE BACKGROUND OF THE CELL SO
► MAYBE ACROSS THE TOP I’VE CHOSE I WANT
► THE COLOR DIFFERENT THERE SO MAYBE I’LL
► GO WITH A LITTLE BIT OF A GRAY AND
► NOTICE NOW I LOOK AT IT AND I MIGHT NOT
► LIKE THE ORANGE ON IT MAYBE IT’LL GO
► BACK TO A BLACK TOO MAY HAVE IT STAND A
► LITTLE BIT BETTER OUT ON IT SO I CAN
► CHANGE THE BACKGROUND I CAN CHANGE THE
► COLOR OF EACH INDIVIDUAL CELL VERY VERY
► QUICKLY BY USING THE FILL COLOR NOW THIS
► ONE OVER HERE IF YOU WANT TO ADD BORDERS
► BECAUSE RIGHT NOW IF YOU PRINT PRINT
► THIS SO AT ANY TIME LIKE SO IF I GO
► THROUGH AND
► WAS GONNA PRINT THIS AND I WON’T PRINTER
► RIGHT NOW BUT IT WOULDN’T HAVE ANY
► BORDERS AROUND THIS IT WOULD JUST BE SO
► BLANK WITH THE TEXT WERE BEING HERE BUT
► IF I WANTED BORDERS THE COLOR WOULD COME
► OUT IF I WANTED BORDERS YOU CAN SEE THE
► OPTION HERE IF I CLICK THAT LITTLE ARROW
► TO THIS SIDE I CAN LOOK THROUGH AND SAY
► WELL DO I WANT IT JUST ON THE INSIDE DO
► I WANT A MIDDLE ONE YEAH I CAN PICK
► MAYBE JUST AROUND THE HOLE ONE OR IF I
► PICK THIS ONE IT WILL GIVE ME BORDERS ON
► ALL OF THEM YOU CAN FORMAT YOUR BORDERS
► A LITTLE BIT TOO SO YOU NOTICE YOU HAVE
► A BORDER COLOR I COULD PICK A DIFFERENT
► ONE AND SOMETIMES MAYBE IT’S NOT THICK
► ENOUGH AND YOU WANT TO JUST THICKER YOU
► COULD GO THROUGH AND MAKE IT A BIT
► THICKER ON IT I’VE TALKED ABOUT MERGING
► CELLS BEFORE AND I SHOWED YOU UNDER
► FORMAT YOU CAN QUICKLY MERGE THE CELLS
► RIGHT HERE TOO SO I JUST SO YOU KNOW ALL
► OF THESE THINGS RIGHT HERE IF I GO UNDER
► UP TOP YOU CAN SEE AS THEY GO THROUGH
► UNDER FORMAT I HAVE ALL THE DIFFERENT
► THINGS THAT I HAVE THE SHORTCUTS TO
► RIGHT THROUGH HERE SO THIS IS JUST SOME
► BASIC FORMATTING JUST TO PUT SOME TEXT
► IN AND TO MAKE IT LOOK TO ADJUST IT TO
► MAKE IT LOOK BETTER ON HOW YOU WANTED IT
► HOW YOU WANT TO PRESENT IT SO LET’S TALK
► ABOUT A LITTLE BIT MORE FOR FORMATTING
► AND I JUST WANT TO TAKE A LOOK AT THESE
► HERE SO WE DO HAVE SOME ALIGNMENT
► DEPENDING ON WHAT YOU WANT IN YOUR CELLS
► SO THERE’S THE HORIZONTAL ALIGNMENT OF A
► CELL WHETHER YOU WANT IT TO BE LEFT
► CENTER OR RIGHT WE ALSO HAVE OUR
► VERTICAL ALIGNMENT HERE TOO I’VE ALREADY
► TALKED ABOUT ABOUT TEXT WRAPPING AND HOW
► YOU WANT YOUR TEXT IN EACH CELL NOW THIS
► IS IF YOU GET SOME REALLY LONG HEADINGS
► YOU MIGHT WANT TO ROTATE YOUR TEXT SO
► FOR INSTANCE I CAN HIGHLIGHT EVERYTHING
► HERE AND IT WILL APPLY THIS ON ALL OF
► THEM SO YOU CAN LOOK AT THE DIFFERENT
► ROTATIONS OF IT AND YOU CAN SEE HOW IT
► KIND OF JUST TILTED EVERYTHING LIKE THIS
► IT DIDN’T TILT IT OVER HERE BUT IT DID
► PUT THE SPACES IN HERE AUTOMATICALLY AND
► GOING BACK BEFORE I SHOWED YOU HOW TO
► STRETCH OUT THE CELLS THIS WAY YOU CAN
► ON YOUR ON YOUR ROWS OVER HERE YOU CAN
► DO THE SAME
► IF YOU NEEDED TO STRETCH THEM OUT LONGER
► ON THAT SIDE – I’M JUST GONNA HIT UNDO
► ON THAT LAST ONE
► ANOTHER TYPE OF FORMATTING YOU CAN DO IS
► QUICKLY ADD DOLLAR AMOUNTS SO LET’S SAY
► THESE ARE SOME FUNDRAISING AMOUNTS THAT
► THAT THESE STUDENTS DID AND I JUST WANT
► TO PUT IT IN DOLLAR AMOUNT SO I CAN
► QUICKLY PUT ON THE FORMAT’S AS CURRENCY
► AND YOU CAN SEE IT’S QUICKLY PUT PUT
► INTO THERE SO NOW LET’S GO ON TO DO SOME
► QUICK USING SOME QUICK FORMULAS AND
► FUNCTIONS HERE FORMULAS AND FUNCTIONS IS
► WHAT MAKES A SPREADSHEET SO GOOD AND
► WHAT I WANT TO SHOW YOU FIRST IS JUST TO
► USE A FORMULA HERE WITH USING THE EQUAL
► SIGN SO THESE ARE VERY SIMPLE FORMULAS
► THAT I COULDN’T BE THAT I WANT TO BE
► USING BUT I JUST WANT YOU GET THE IDEA
► OF HOW THEY WORK SO IN THIS CASE RIGHT
► HERE LET’S SAY I WANTED A TOTAL COLUMN
► AT ON THE BOTTOM OF EACH ONE AND I WANT
► TO KNOW THE TOTAL OF EACH FUNDRAISING
► ONE HERE TOO SO I’M JUST GONNA QUICKLY
► ENTER IN A LITTLE BIT MORE MONEY FOR
► THIS LAST PERSON I NOTICED I FORGOT IT
► AND I’LL JUST PUT SOME RAND AND RANDOM
► NUMBERS HERE AND REMEMBER I CAN FORMAT
► THEM VERY QUICKLY TOO SO AT THE VERY
► BOTTOM HERE I WANT TO ADD UP THESE FOUR
► DIFFERENT PLACE THESE FOUR DIFFERENT
► ONES HERE SO A WAY I COULD DO A FORMULA
► IS ALWAYS START WITH AN EQUAL SIGN ONCE
► I DO THAT I CAN CLICK ON THE CELL AND SO
► YOU CAN SEE IT’S SELECTED I CAN JUST USE
► MY OPERATION SIGN + CLICK ON THE NEXT
► ONE PLUS CLICK ON THE NEXT ONE + AND
► THEN CLICK ON THE LAST ONE AND I CAN HIT
► ENTER AND I QUICKLY HAVE IT ADDED UP
► PRETTY QUICKLY SEEMS TO WORK VERY VERY
► SMOOTH BUT YOU CAN DO THAT EVEN FASTER
► THROUGH FORMULAS ARE NOT FORMULAS BUT
► FUNCTIONS ON IT SO LOOK AT THIS ONE SO
► IF I MOVE OVER TO THE NEXT COLUMN AND IF
► I GO UP TO MY SUM FUNCTION IF I JUST
► CLICK ON IT I JUST HAVE TO HIGHLIGHT
► WHAT I WANT AND NOW I HAVE A QUICK SUM
► AND THE NICE THING ABOUT THESE IS THAT
► REMEMBER IF THESE NUMBERS CHANGE HAVE
► ALL SUDDEN TO YOU THAT MAYBE I WAS
► GATHERING MONEY FROM HER FUNDRAISING AND
► ALL OF A SUDDEN I FOUND OUT OH THIS THIS
► NUM
► WASN’T RIGHT HERE IN THIS NUMBER SHOULD
► HAVE BEEN LET’S SAY IT SHOULD HAVE BEEN
► IT EVERYTHING IS CONNECTED RIGHT SO
► IF I JUST CHANGE ONE NUMBER SO YOU CAN
► IMAGINE AS YOU GET THESE REALLY BIG
► SHEETS OR YOU HAVE A LOTS OF MARKS ON IT
► YOU DON’T YOU CAN JUST ALTER ONE NUMBER
► AND IT’S GOING TO CHANGE YOUR AVERAGE
► CORRECTLY FOR IF YOU HAVE IT SET UP IT
► WILL JUST MAKE THE ADJUSTMENTS FOR YOU
► ON THIS ONE SO I’M GOING TO SHOW YOU A
► DIFFERENT WAY TO DO EVEN EVEN QUICKER
► HERE SO I’M JUST GOING TO DELETE THESE
► TWO PLACES I’M JUST GONNA HIT DELETE SO
► NOW IF I USE MY JUST LIKE I REALLY
► SHOWED YOU BEFORE WAS THE SUM SO I’M
► GONNA QUICKLY JUST SOME HIGHLIGHT IT ALL
► HIT ENTER AND NOW I’M GONNA GO RATHER
► THAN DO EACH COLUMN I’M JUST GONNA CLICK
► ON IT AND I’M GONNA GRAB THIS LITTLE
► BLUE SQUARE HERE AT THE BOTTOM AND I’M
► JUST GONNA DRAG IT THIS WAY NOTICE IT
► JUST COPIED THAT FORMULA ACROSS IN IT
► KNEW THAT IT JUST KEPT EVERYTHING IN
► COLUMNS ADDING UP THAT WAY SO NOW THAT’S
► EVEN QUICKER DOING IT THAT WAY IS
► DRAGGING ACROSS SO I CAN GO UP TO HERE
► IF I WANTED LET’S SAY NOW IF I WANTED TO
► FIND THE TOTAL OF EACH OF EACH
► INDIVIDUAL STUDENT WHAT I CAN DO IS I
► CAN GO UP TO MY SUM AGAIN HIGHLIGHT IT
► ALL HIT ENTER
► LOOK AND NOTICE THAT’S UNDER THE WRONG
► FORMATTING RIGHT NOW IT SHOULD BE UNDER
► A DOLLAR AND I CAN DRAG DOWN SO I HAVE
► TWO DIFFERENT SUMS I HAVE MY SUMS FOR
► EACH ONE AND THEN I HAVE MY SUMS FOR FOR
► EACH TOTAL TO LET’S SAY NOW IF I WAS
► INTERESTED IN A AVERAGE FOR LET ME TYPE
► IN AVERAGE HERE FOR EACH STUDENT IF I
► CLICKED IN HERE AND I GO UP TO HERE NOW
► I GO TO AVERAGE NOW I CAN SELECT THE
► THREE HERE AND I WANT TO KNOW WHAT THEIR
► AVERAGE FUNDRAISING IT SHOWS ME REALLY
► QUICKLY SO AGAIN I CAN DRAG THIS
► STRAIGHT DOWN AND IT’S GOING TO WORK FOR
► EACH STUDENT BECAUSE IF I CLICK ON EACH
► OF THESE AFTER IT WILL TELL ME IF I LOOK
► UP INTO THE FORMULA UP HERE YOU CAN SEE
► THAT IT’S GOOD AVERAGING F TO H
► SO FROM F TO H IT’S NOT PUTTING IN THE
► TOTAL BECAUSE I DID
► SELECT THAT AS PART OF THE FIRST ONE SO
► IT KNOWS AS I COPY IT DOWN IT’S GONNA
► STAY IN THOSE COLUMNS HOW I HAVE
► EVERYTHING SET UP SO THAT’S A QUICK WAY
► TO DO SOME AVERAGES ON ON MONEY USING
► YOUR SUM AND YOUR AVERAGE AVERAGE
► FUNCTIONS ON THOSE SO LET’S SAY MAKING A
► GOOGLE SHEET FOR MY CLASSROOM MARKS HERE
► AND I ALREADY ENTERED IN HERE SOME BUT
► REALIZE OH THEY WANTED THAT CALL THEM
► SOMEWHERE ELSE IN A ROW SOMEWHERE ELSE
► I CAN STILL FORMAT THESE SO LET’S SAY IF
► I WANTED I WANT A BRIGHT GRADE RIGHT
► HERE IN BETWEEN B OR C IF I RIGHT CLICK
► ONTO THE COLUMN NOTICE THAT I HAVE SOME
► INSERT FEATURES SO I CAN INSERT ONE TO
► THE LEFT SO NOW I’VE INSERTED THIS AND I
► CAN GIVE THIS A HEADING AND I’M JUST
► GONNA CALL THIS GREAT HERE AND MAYBE I
► WANT TO PUT ONE MORE ABOVE IT I WANT TO
► PUT THE AVERAGE ON TOP OF EACH ONE IN
► THE NAME OF THE EXAM I CAN RIGHT CLICK
► HERE AND I CAN INSERT ONE ABOVE SO NOW
► IF THIS WAS GOING TO BE EXAM I’LL JUST
► SAY EXAM EXAM AND EXAM EXAM HERE
► SO I’VE ENTERED IT IN THOSE AND NOW WHAT
► I WANT TO DO IS DO SOME AVERAGES ON
► THESE ONES SO LET’S SAY I WANT TO PUT
► THE AVERAGE RATE ON TOP OF THESE
► REMEMBER WHAT I SHOWED YOU BEFORE YOU
► CAN HIGHLIGHT SO YOU CAN CLICK IN
► YOURSELF FIRST YOU CAN GO TO AVERAGE
► PICK YOUR PICK YOUR COLUMN THAT ARE THE
► ONES THAT YOU WANT YOU CAN SEE THERE’S
► . EVERAGE HERE YOU CAN ALWAYS GO
► NOTICE THAT YOU HAVE YOU CAN INCREASE OR
► DECREASE THE DECIMALS HERE SO IF I IT
► ROUNDED IT UP TO OR IF I SHOWED THE
► DECIMAL TO ONE PLACE OR TO TWO SPOTS YOU
► HAVE SOME OPTIONS HERE ON HOW YOU WANT
► TO FORMAT EACH OF THESE TWO I’M NOT
► GOING TO CHANGE THIS ON THIS ONE BUT YOU
► CAN SEE HOW I CAN HAVE CURRENCY OR
► FINANCIAL OR ACCOUNTING JUST DIFFERENT
► WAYS I CAN FORMAT IT SO I’M JUST GONNA
► LEAVE IT – I’M GONNA LEAVE IT TO ONE AND
► SO NOW I CAN DRAG IT THIS WAY AND THEN I
► CAN HAVE MY AVERAGES ALL THE WAY ACROSS
► HERE SO IF I WANTED TO HAVE A GRADE AND
► AGAIN IF I JUST WANTED TO BE BASED IF
► THEY WERE ALL THE SAME I COULD HIT THE
► AVERAGES SO IF I JUST GO TO MY AVERAGE
► AGAIN GO TO AVERAGE AND GO RIGHT ACROSS
► AND HIT ENTER AND YOU CAN SEE THAT
► THERE’S AN AVERAGE THERE DRAG IT DOWN
► AND I HAVE IT THERE TOO SO THEN I CAN
► CLICK ON THIS ONE I CAN GO BACK AND MY
► DECIMALS TO SAY I WANT IT TO THERE SO I
► CAN GRAB ALL THESE AT ONCE IF I WANTED
► TO CHANGE THE FORMAT HERE IF I WANT TO
► INCREASE THE DECIMALS TO SEE IF THERE TO
► SEE WHERE THEY WERE ROUNDING OFF AT I
► CAN DO THAT TOO SO THAT’S JUST A LITTLE
► BIT MORE ABOUT ABOUT USING SOME OF THE
► FORMATTING FEATURES THAT ARE QUICK TO
► USE TO GET THOSE AVERAGES FOR YOU
► ESPECIALLY IN A GRADEBOOK SO NOTICE I
► DIDN’T PUT THIS IN ALPHABETICAL ORDER AT
► ALL AND I MENTIONED BEFORE IN WHEN I WAS
► GOING OVER IN THE VOCABULARY HOW EASY
► THAT WAS TO DO NOW I’M GONNA SHOW YOU
► I’M GONNA SORT THIS IN ALPHABETICAL
► ORDER BUT IT’S GONNA ACTUALLY MESS UP
► THE WAY I HAVE IT SET UP HERE AND BUT
► I’M GONNA FIX IT
► SO IF I JUST CLICK ON IF I WANT LET’S
► SAY BY A LAST NAME HERE IF I GO TO UP TO
► DATA IF I CLICK ON YOU NOTICE WHAT
► HAPPENED IT PUT THE LAST NAME MIXED IT
► ALL UP KIND OF WITH THE BUT IT IS IN IT
► IS IN ALPHABETICAL ORDER BUT IT ALSO PUT
► THE LAST NAME AS A NAME IN THERE SO I’M
► JUST GONNA UNDO THAT SO WHAT I’M GONNA
► DO IS ACTUALLY FREE SOME THINGS HERE SO
► I’M GONNA GO UP TO MY VIEW AND I’M GONNA
► FREEZE THE FIRST TWO ROWS RATE UNDER
► NAME AND ALL THIS STUFF IS FROZEN AND
► I’M GONNA GO TO VIEW AND I’M GONNA
► FREEZE THEIR FIRST TWO COLUMNS BECAUSE
► THAT’S KIND OF WHERE MY NAMES ARE NOW
► NOW IF I GO TO HERE AND EVERYTHING
► THROUGH HERE IS GONNA GET REARRANGED TOO
► IF I GO UP TO MY DATA NOW AND SORT CHEAT
► THROUGH A TWOSIE NOTICE EVERYTHING IS IN
► AND THIS ALL CHANGED AROUND SO IF I GO
► BACK YOU CAN SEE HOW ALL THE NUMBERS
► CHANGED AND NOW IF I GO FORWARD
► EVERYTHING IS CLEAN IN ORDER AND
► EVERYTHING JUST WHEN I FROZE THOSE TWO
► ROWS SO IT’S A HANDY FEATURE WHEN YOU’RE
► SETTING UP YOUR GOOGLE SHEETS FOR
► SOMETHING LIKE THIS
► THINK ABOUT FREEZING CERTAIN ROWS
► AND WE’LL MAKE A LITTLE BIT EASIER FOR
► YOU SO JUST A FEW OTHER FUNCTIONS I WANT
► TO SHOW YOU THAT MIGHT COME IN HANDY
► HERE THAT COULD SAVE YOU SOME TIME AND
► THAT IS FIRSTLY THE UNIQUE ONE SO WITH
► UNIQUE WHAT IT DOES IS IT CAN LOOK FOR
► DUPLICATES OR SOMETHING SO I’VE WRITTEN
► OVER HERE SOME EXTRA NAMES ON THE COLUMN
► AND THERE’S SOME DUPLICATES IN THERE SO
► THE LIST LOOKS LIKE THERE’S ABOUT
► SO MAYBE YOU HAVE A LONG LIST OR
► SOMETHING AND YOU WANT TO KNOW IF
► THERE’S ANY DUPLICATES IN TH ANYTHING
► SO LET’S SAY I WANT THE LIST OVER HERE
► I’M YOU ALWAYS START IT WITH AN EQUALS
► AND I’M GONNA START TYPING IN MY NAME
► AND I CAN SEE THERE’S UNIQUE RATE THERE
► AND SO WHAT I WANTED TO DO IS I’M JUST
► GONNA HIGHLIGHT THIS AREA HERE AND I’M
► GONNA JUST CLOSE IT AND HIT ENTER AND SO
► IT SHOWED ME THAT THESE ARE THE UNIQUE
► ONES SO THERE THESE ARE THE ONES THAT
► OVER HERE YOU CAN SEE THAT THE LIST IS A
► LITTLE LONGER BUT THIS IS THE UNIQUE ONE
► HERE SO THAT’S A HANDY FEATURE IF YOU
► HAVE A LONG LIST AND YOU WANT TO KNOW IF
► THERE’S ANY DUPLICATES IN IT CHECK OUT
► THAT ONE SO A QUICK ONE TO USE IS THE
► COUNT FEATURE REALLY EASY TO USE IT’S
► RIGHT UNDER THE IT’S ONE OF THE MAIN
► ONES HERE YOU CAN SEE COUNT BUT REMEMBER
► AT ANY TIME IF YOU HIT THE EQUAL AND YOU
► START TYPING IN THE WORD IT WILL COME UP
► TOO SO WHAT THE COUNT DOES IF YOU WANT
► TO SEE HOW MANY EXAMS IN TOTAL OR HOW
► MANY OF SOMETHING THERE IS JUST
► HIGHLIGHT THE AREA AND SIMPLY HIT ENTER
► AND IT WILL COUNT THINGS UP FOR YOU VERY
► VERY QUICKLY SO MAYBE YOU HAVE THIS
► GIANT LIST YOU JUST WANT TO KNOW THE
► NUMBERS OF HOW MANY SOMETHING ARE ON IT
► TRY THE COUNT COUNT FUNCTION THE IF
► STATEMENT IS GREAT TO ANALYZE DATA
► QUICKLY AND THEN OUTPUT AN ANSWER OR AN
► OUTPUT INFORMATION YOU WANT TO GIVE ON
► YOUR SPREADSHEET SO I’M GONNA GO AHEAD
► AND USE IT FOR GRADES AND SO WHAT I WANT
► TO HAVE HAPPEN HERE IS IF THE MARK IS
► ABOVE THEN I WANT IT TO SAY I’LL GIVE
► IT A MAYBE AN E AND THEN IF IT’S BELOW
► I JUST WANTED TO SAY KEEP TRYING SO
► WHAT I’M GONNA DO IS IN THIS CELL RIGHT
► HERE I’M GOING TO START WITH MY EQUAL
► SIGN AND I’M GOING TO SAY IF AND IF
► COMES UP SO THE FIRST PART I HAVE TO
► WHAT DO I WANT TO HAVE
► HAPPEN HERE SO I WANT TO SAY IF THIS
► CELL IS CREATED WELL GREATER THAN OR
► EQUAL TO THEN I’M GONNA GIVE IT A
► COMMA THEN I NEED TO SAY THEN I NEED TO
► SAY SOMETHING SO I WANT IT TO SAY II AND
► I CLOSE SO THAT’S IN QUOTATION MARKS OR
► ELSE SO THIS IS THE OTHER PART OF IT SO
► OR ELSE SO ANOTHER COMMA AND I HAVE TO
► DO THE QUOTATION MARKS I’LL SAY KEEP
► TRYING EXCLAMATION MARK AND I HAVE TO
► CLOSE MY UP HERE AND CLOSE MY
► PARENTHESIS ON THIS SO IF I LOOK AT IT
► IT WILL SAY IF WHATEVER’S IN C IS
► GREATER THAN OR EQUAL TO THEN RIGHT
► II IF NOT SAY KEEP TRYING SO LET’S GIVE
► THIS A TRY MAN HIT ENTER YOU CAN SEE SO
► THIS ONE SAID KEEP TRYING YOU CAN SEE
► THE MARK IS BLOWS BELOW AN SO IT’S
► SAYING KEEP TRYING I CAN COPY THIS DOWN
► REAL QUICKLY AND THESE ONES ALL RECEIVED
► AN E SO THE IF STATEMENT IT’S GREAT
► BECAUSE YOU CAN GET ASKED IT A QUESTION
► AND THEN GIVE IT TELL IT TO PUT OUT
► INFORMATION IN A CERTAIN CELL AND IT CAN
► ANALYZE ALL THE STUFF VERY VERY QUICKLY
► AND GIVE YOU RESULTS THAT YOU WANT
► CHARTS ARE A GREAT WAY TO ANALYZE YOUR
► DATA VERY QUICKLY AND THEY LOOK GREAT SO
► I’M GONNA JUST GO UP TO INSERT UP HERE
► AND I’M GONNA GO TO INSERT AND INSERT A
► CHART SO THIS IS THE NEW CHARTS AND
► GOOGLE SHEETS I CAN STILL SWITCH THE OLD
► EDITOR DOWN BELOW HERE BUT I’M GONNA USE
► THIS ONE I’M GONNA RIGHT NOW IT’S BLANK
► CUZ I HAVE TO PUT SOME DATA INTO HERE SO
► I’M GOING TO START WITH A SERIES AND I’M
► GOING TO SELECT THIS EXAM SO I’M JUST
► GONNA SELECT THIS THESE FOUR TESTS RIGHT
► HERE AND I’M GOING TO HIT OK SO YOU CAN
► SEE RIGHT AWAY IT THERE IN ORDER BECAUSE
► I HAD THEM PUT IN ORDER BEFORE BUT SO
► NOW I CAN ADD ANOTHER SERIES SO LET’S
► SAY WE’LL HAVE THIS ONE IN HERE TOO AND
► THEN ADD ANOTHER SERIES I CAN GO TO THIS
► ONE SO I HAVE THEREFORE NOW I WANT THE
► X-AXIS IN THERE SO I’M GONNA GO TO HERE
► AND PUT THE NAME SO I’LL JUST PUT THE
► FIRST NAMES IN AND THEN THAT’S DOWN
► BELOW SO THERE’S DIFFERENT THINGS I CAN
► DO ONCE I HAVE IT SET UP TO CUSTOMIZE IT
► MORE
► – YOU CAN SEE I CAN SELECT A DIFFERENT
► TYPE OF CHARTS I MEAN I COULD CHANGE THE
► ANGLE ON THESE ONES BUT IF I GO BACK
► DOWN YOU CAN PLAY WHAT WITH WHICH ONE’S
► WORK THE BEST FOR YOU
► SO THESE CERTAIN ONES WON’T WORK AT ALL
► ON IT BUT LET’S TRY THE LINES YOU CAN
► SEE THE LINES BUT I’M GONNA GO BACK TO
► MY NORMAL COLUMN ONE BECAUSE IT’S THE
► BEST ONE I THINK THAT WOULD WORK FOR
► THIS ONE NOW NOTICE THAT THERE’S
► CUSTOMIZE OVER HERE TOO SO WE HAVE OUR
► CHART STYLE WHAT YOU CAN GO THROUGH AND
► COLOR YOU KNOW YOU CAN CHANGE YOUR
► COLORS IF YOU WANT D YET I FIND THAT
► LOOKS A LITTLE BIT BETTER I HAVE MY
► FONTS I CAN MAXIMIZE IT WE HAVE OUR
► CHART TITLES SO I’LL JUST PUT MARKS ON
► HERE AND AS YOU CAN SEE HOW IT COMES UP
► AND I CAN CHANGE SOME THINGS ON JUST A
► MORE CUSTOMISATION OF IT I’M NOT GONNA
► GO THROUGH AND DO EVERYTHING TO IT I’LL
► POINT OUT JUST SO AS YOU GO THROUGH DOWN
► YOU HAVE YOUR SERIES WHERE YOU CAN IMPLY
► DIFFERENT THINGS TO IT YOU HAVE YOUR
► LEGEND YOUR HORIZONTAL AXES AND YOUR
► VERTICAL SO IF YOU NEEDED TO NAME
► DIFFERENT ONES OF THESE AND YOU HAVE
► YOUR GRID LINES IF YOU WANTED THOSE ON
► SO YOU CAN GO THROUGH AND CUSTOMIZE YOUR
► CHARTS ON THIS BUT IN SECONDS YOU CAN
► TAKE ALL THE INFORMATION YOU HAVE CREATE
► A VERY ATTRACTIVE CHART FOR IT SO YOU
► MIGHT WANT TO TAKE YOUR CHARTS OUT OF
► GOOGLE SHEETS AND PUT THEM INTO A
► PRESENTATION OR PUT THEM INTO A DOCUMENT
► THAT YOU’RE CREATING I JUST GO UP WHEN I
► CLICK ON IT SEE THESE THREE LITTLE DOTS
► I HAVE SOME OPTIONS HERE I COULD DELETE
► THIS CHART HERE I COULD SAVE THE IMAGE I
► COULD PUBLISH THE CHART I COULD COPY THE
► CHART AND THAT’S WHAT I’M LOOKING AT
► RIGHT NOW SO I WANT TO COPY THIS CHART
► I’VE OPENED UP A GOOGLE OF SHEETS OVER
► HERE AND I’M JUST GOING TO PASTE IT OVER
► HERE SO I’M JUST GONNA RIGHT CLICK AND
► PASTE NOTICE IT ASKED ME TO LINK IT AND
► I’M GONNA SHOW YOU I MEAN I AM GOING TO
► LINK IT AND I’M GONNA SHOW YOU WHAT IT
► DOES FOR ME HERE SO PASTE SO LET’S SAY
► I’VE GOT THIS CHART I’VE COLLECTED THE
► INFORMATION I’M GIVING A PRESENTATION ON
► SOMETHING AND SOMETHING CHANGES OVER
► HERE SO LET’S SAY INSTEAD OF THIS NIGHT
► HUH I’M GONNA GIVE THIS A HERE
► AND AS I HIT ENTER NOTICE THIS ONE JUST
► JUMPED NOW IF I GO BACK OVER TO MY
► PRESENTATION ALL I HAVE TO DO IS UPDATE
► BECAUSE IT’S LINKED SO IT MAKES IT ALL I
► HAVE TO DO IS CHANGE IT IN THE
► SPREADSHEET UPDATE IT I DON’T HAVE TO
► COPY PASTE AGAIN AND IT’S JUST GOING TO
► UPDATE IT I CAN COPY PASTE SO I’VE
► ALREADY COPIED IT BUT I CAN ALSO PASTE
► SAME OR SAME THING PASTE THIS ONE SHOULD
► ALREADY BE UPDATED BUT YOU HAVE THE I’LL
► CLICK OH THERE GOES IN AND UPDATES NOW
► BUT YOU HAVE THE SAME THING THAT HAPPENS
► IN GOOGLE DOCS SO YOU CAN TAKE YOUR
► SHEETS OUT OF TAKE YOUR CHARTS OUT OF
► GOOGLE SHEETS COPY THEM INTO SLIDES OR
► COPY THEM INTO DOCS AND LINK THEM SO
► THAT JUST THE ONE CHANGE OVER HERE THEN
► YOU CAN QUICKLY UPDATE ALL YOUR
► INFORMATION IN OTHER PLACES SO REMEMBER
► JUST LIKE ANYTHING FROM GOOGLE DOCS OR
► GOOGLE SLIDES YOU CAN SHARE THIS OR JUST
► LIKE ANY OF THE OTHER APPS YOU CAN GO UP
► AND SHARE THIS YOU CAN ADD COLLABORATORS
► IF YOU WANTED TO WORK WITH MAYBE ANOTHER
► TEACHER OR WHO A MEMBER YOU’D LIKE YOU
► CAN ADD THE PEOPLE QUICKLY THROUGH HERE
► AND GIVE THEM THEIR PERMISSION SO THEY
► CAN ADD TO THE SPREADSHEET REMEMBER YOU
► HAVE THE ADVANCED TOOL HERE THAT YOU CAN
► GET A LITTLE BIT MORE INFORMATION TO AND
► MAKE A FEW MORE ADJUSTMENTS I’M NOT
► GONNA SHARE THIS ONE RATE RIGHT NOW SO
► I’M JUST GONNA HIT DONE WHAT I WANT TO
► SHOW YOU ABOUT IS ABOUT PUBLISHING TO
► THE WEB YOU CAN TURN THIS WHOLE THING
► INTO A WEB PAGE VERY EASILY JUST GO UP
► TO FILE AND PUBLISH TO THE WEB RIGHT UP
► HERE AND IF I CLICK IT YOU NOTICE I HAVE
► SOME OPTIONS HERE I CAN GO TO LINK OR I
► CAN GO IN EMBED I’M GONNA GO TO LINK
► HERE AND I CAN GO I COULD PICK A CERTAIN
► SHEET IF I WANT I’M GONNA SAY IN THE
► ENTIRE DOCUMENT AND I’M GONNA SAY WEB
► PAGE I HAVE AGAIN SOME CHOICES WHAT I
► COULD PICK A PDF OR BUT A WEB PAGE IS
► GONNA WORK BEST FOR ME HERE ARE MY
► PUBLISHED CONTENT SETTINGS HERE YOU CAN
► SEE WHAT I’VE ALREADY CHOSEN HERE I
► DON’T WANT TO REQUIRE VIEWERS TO SIGN IN
► SO I’M GONNA HIT PUBLISH HERE I’M GONNA
► HIT OK AND SO WHAT IT’S TELLING ME TO DO
► HERE IS TO COPY THIS HERE SO I’M JUST I
► CAN TAKE THIS WHOLE THING HERE
► WELL ACTUALLY I’M JUST GONNA RIGHT-CLICK
► AND IT’S GONNA SAY GO TO HERE SO I’M
► JUST GONNA HIT GO TO HERE AND IT BRINGS
► ME RIGHT TO IT SO ONE THING IS THE FORM
► RESPONSES THIS WAS FROM SOMETHING I HAD
► IT WAS BLANK SO BUT NOTICE IF I CLICK ON
► SHEET HERE IT IS SO I HAVE THIS URL
► THAT I COULD SHARE WITH PEOPLE SO IF YOU
► WANTED TO PUT OUT INFORMATION YOU COULD
► PUBLISH IT AS A WEB PAGE ON IT AND THEN
► PEOPLE COULD VIEW THE INFORMATION THAT
► YOU WANTED TO SHARE WITH THEM THAT WAY
► TOO
► LET’S SAY I’M GOING TO SHARE THIS GOOGLE
► SHEET WITH SOMEBODY BUT I WANT TO GIVE
► THEM SOME ACCESS BUT NOT ACCESS TO
► EVERYTHING WHERE THEY CAN CHANGE ALL THE
► NUMBERS YOU CAN LOCK DOWN CERTAIN PARTS
► OR PROTECT CERTAIN PARTS OF YOUR GOOGLE
► SHEET SO LET’S SAY THIS PART RIGHT UP
► HERE THESE GRADES I DON’T WANT IT I
► DON’T WANT ANYBODY MESSING AROUND I JUST
► WANT THEM LOCKED WHOEVER I SHARE THIS
► DOCUMENT WITH IF I GO UP TO MY DATA UP
► HERE NOTICE I HAVE PROTECTED SHEETS AND
► RANGES SO I’M JUST GONNA GO AHEAD AND
► CLICK ON THAT AND THE RANGE I SELECTED
► IS ALREADY IN HERE YOU CAN SEE I’M ON
► SHEET THAT’S WHAT I WANT TO BE I’M NOT
► GONNA BOTHER ENTERING A DESCRIPTION ON
► IT I’M GONNA GO AHEAD AND HIT SET
► PERMISSION NOW IT’S SAYING RESTRICT WHO
► CAN EDIT THIS I’M GONNA SAY ONLY ME SO I
► COULD GO CUSTOMIZE AND I COULD ADD OTHER
► PEOPLE BUT I’M JUST GONNA SAY ONLY ONLY
► ME AND I’M GONNA HIT DONE AND IT’S SAVED
► SO NOW I’M GONNA GO AHEAD AND SHARE THIS
► DOCUMENT WITH A DIFFERENT ACCOUNT OF
► MINE AND I’M GONNA GO OVER AND OPEN THAT
► UP JUST TO SHOW YOU WHAT THAT WOULD LOOK
► LIKE SO I BELIEVE THIS IS THE ONE HERE
► AND I’VE SHARED THIS WITH HIM SO I WAS
► JUST MAKING SURE THAT WAS THE ONE YEP SO
► I’M GONNA OPEN THIS UP AND I NEED TO GO
► TO THE OTHER SHEET HERE SHEET ONE AND
► THEN SO HERE’S THE INFORMATION SO THIS
► IS THE PART I LOCKED DOWN NOTICE IF I
► TRY TO DELETE IT IT’S SAYING THERE WAS A
► PROBLEM I CAN’T EDIT IT SO ANY OF THESE
► MARKS I CAN’T EDIT BUT IF I GO OVER TO
► JACK I CAN CHANGE THIS AROUND AND EDIT
► THOSE PARTS BECAUSE I DIDN’T I I DIDN’T
► PROTECT THOSE AREAS SO IF YOU ARE GONNA
► SHARE YOUR SHEETS WITH SOMEBODY ELSE
► THINK ABOUT PROTECTING CERTAIN AREAS OF
► DATA THAT YOU DON’T WANT MESSED WITH BUT
► WANT TO MAYBE GIVE THEM ACCESS TO OTHER
► ALL RIGHT THEY CAN HELP YOU OUT WHEN
► YOU’RE WORKING TOGETHER SO I HOPED YOU
► LIKED THIS GOOGLE SHEETS TUTORIAL
► TONIGHT IF YOU HAVE PLEASE SHARE THIS
► WITH A FEW OTHER PEOPLE AND HIT THAT
► LIKE BUTTON BUT I’D REALLY LIKE TO KNOW
► WHAT TYPE OF TUTORIALS IN GOOGLE SHEETS
► THAT YOU WOULD LIKE SO LEAVE A COMMENT
► DOWN BELOW LET ME KNOW SPECIFIC EXAMPLES
► OF VIDEOS THAT I COULD MAKE WITH SHORTER
► ONES THAN THIS TO HELP YOU AND OTHER
► PEOPLE MOVE FORWARD WITH USING GOOGLE
► SHEETS SO REMEMBER I DO THESE WEEKLY
► TECH TIPS AND IF YOU LIKED WHAT YOU SEE
► TONIGHT PLEASE SUBSCRIBE TO MY CHANNEL
► THANKS FOR WATCHING AND I’LL SEE YOU
► NEXT TIME

Video Link

About The Author

Related posts

Leave a Reply

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