Google Sheets Deep Dive (Educator Edition)
4.9/5
USD49.00
Do you want to know how to use Google sheets and organise your data and become that person that knows ‘all things spreadsheets’?
It’s time to get nerdy with a Google Sheets Deep Dive!
The Important Stuff
- Module 1: Splitting and joining text and removing duplicates so you can create email lists from a class list.
- Module 2: Calculating percentages and automatically allocating grades using vlookup to win back time.
- Module 3: Calculating average marks and ranking student achievement to easily analyse student progress.
- Module 4: Conditional formatting, inserting images to add clarity to your sheets. Learn how to insert checkboxes to automatically format cells so that you can track student progress and manage workflows.
- Module 5: Data validation so you can make drop down lists in your sheets and to correctly enter dates. Explore how named ranges can be used to help write more complex formulas and build more functional sheets.
- Module 6: Creating and customising filters to empower you analyse the data in your sheets.
- Module 7: Protecting sheets and ranges so that your data and formulas aren’t accidently changed when working collaboratively.
- Module 8: Bring more functionality to your sheet by building a customised data summary section. This helps you drill down into your data easily and brings insights into the learning journey of your students by combining skills learnt in previous modules.
- Module 9: Use pivot tables to analyse data and combine this with slicers to add more functionality to your sheets. This will help you be able to find trends in large data sets and track student progress.
- Module 10: Increase the power of your sheets by importing data from external sheets so you can add even more functionality to your sheets.
- Module 11: Add that extra spark and automation to your sheets by using macros. These will help speed up your workflow amazingly.
- Module 12: Take a bland sheet and make them look fantastic so you can visualise your data better. Also use custom number formats to visualise trends in your data even quicker.
Who Is This Course For?
- Teachers who are feeling like they don’t fully understand how to utilise features and functions in Sheets.
- Teachers who would love to save time by using Sheets to analyse student progress.
- Teachers who want to learn tricks that they can apply to other sheets.
- Teachers who want to master aspects of sheets so they can automate repetitive tasks and save time.
- Teachers who want to become efficient by utilising named ranges.
- Teachers who want to build confidence in using formulas to build your own sheets.
- Teachers who want to create a data summary dashboard using filters and data validation.
What Will You Learn?
- How to build a teacher markbook that automatically allocates grades.
- How to use advanced functions in Sheets to add power to your sheets so you can pick trends in student progress.
- How to use tick boxes to not only track the progress of tasks, but to enable automatic formatting in your sheets to improve workflow.
- How to embed filters within pivot tables so that you can analyse data easier.
- A bunch of time saving tips and tricks that you can apply to any sheet.
Want More For Less?
Sign Up for Learn On Demand
#nevernotlearning
Learn On Demand
The only tech tool training subscription you’ll need to keep being awesome!
$ 29
/ mo
-
Access to over 40 courses in a range of tech tools, including G Suite, Microsoft 365, Apple iPad + more
-
Access to a public forum to chat with like minded people who are working on their tech skills (learning together is always better)
-
Access to our Skills Checklist to identify your current skillset and where your opportunities for growth are
-
Get notified of the latest updates and new features available in the tech tools (because our team nerds out on this stuff - for real)
JOIN NOW
Join Now & Receive A Free Upgrade To Learn On Demand Plus (Offer Ends Oct 31st 2020)
Learn On
Demand Plus
The only tech tool training subscription you’ll need to keep being awesome! PLUS a stack of extra bonuses.
$ 49
/ mo
-
Access to over 40 courses in a range of tech tools, including G Suite, Microsoft 365, Apple iPad + more
-
Access to our certified trainers through the private forum to help you out, solve tech headaches and be your sideline cheerleader
-
Access to our Skills Checklist to identify your current skillset and where your opportunities for growth are
-
Get notified of the latest updates and new features available in the tech tools (because our team nerds out on this stuff - for real)
-
Access to resource packs that are ready to download and use immediately
-
Saving the best to las... You'll also receive access to our MONTHLY LIVE CALLS where we will be delivering fresh new training and also be available for live Q & A!
JOIN NOW
It's a no brainer
BEST OFFER
Some of our FAQ's
These are the standard FAQs. Please add any more that are required for your course. Put
a comment on the new FAQ so it does not get missed.
What payment methods are available for this course?
You can choose to pay by credit card, or request an invoice that can be paid by your borganisation. Select the option you require on the course payment page.
Do I receive a certificate for the course?
Yes. You can request a certificate after completing all of the course modules.
Can I ask questions during the course?
Yes. The course platform includes a discussion forum where you can talk to others taking the course or our trainers. Our Learn On Demand Subscription also includes a private chat facility.
How long will I have to complete the course?
Your registration includes 12 months access to the course materials.
How do I contact Using Technology Better now if I have another question before I register?
You can contact us anytime via this contact form.
Money Back
Guarantee
It’s pretty unlikely you’re going to need this. But we just want to make sure you have no excuses to join. So with this one out of the way, what are you waiting for? Sign up and let’s do this.
