Google Guru Bundle

Courses
8
Lessons
239
Enrolled
395

What's Included

Product Details

Access
Lifetime
Content
3 hours
Lessons
56

'Master Google Sheets' Course

Compile, Edit & Publish Spreadsheet Data Like a Pro

By Justin Mares | in Online Courses

Google Spreadsheets is an amazing alternative to Microsoft Excel, and it's time you joined legions of satisfied Google converts. You'll find it a valuable tool for compiling, editing, and sharing spreadsheet data, whether you're drafting charts and graphs, utilizing sorting and filtering tools, or performing any other task.
  • Use Google Spreadsheets like you do Microsoft Excel w/ 3 hours of content
  • Visually represent your data w/ charts & graphs
  • Quickly write formulas & create powerful calculations
  • Use data tools like sorting, subtotaling & filtering
  • Write your own scripts & use Google addons to get more done
  • Create charts, tables, graphs & format data
  • Automate tasks w/ time-saving scripts & add-ons
Justin Mares formerly ran growth at developer tools company Exceptional (acquired by Rackspace in March of 2013). While there, he taught himself how to become a technical marketer and use tools like SQL to run important analyses on customer data. He is also the co-author of Traction Book, which details how startups can get traction, and founded e-commerce company Kettle & Fire (which hit a multi-million dollar run rate in just a few months). For more details on the course and instructor, click here. This course is hosted by StackSkills, the premier eLearning destination for discovering top-shelf courses on everything from coding—to business—to fitness, and beyond!

Details & Requirements

  • Length of time users can access this course: lifetime access
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels

Compatibility

  • Internet required

Course Outline

  • Introduction
    • What we'll cover in this course
  • Spreadsheet Basics
    • Creating, Renaming and Sharing
    • Formatting Basics
    • Freezing Rows and Columns
    • Conditional Formatting
    • Formatting Quiz
  • Manipulating Data like a BOSS
    • Sorting Data
    • Filters and Filter Views
    • Find and Replace
    • Revision History
    • Data Manipulation Quiz!
  • Functions and Formulas
    • Building Formulas and Functions
    • Overview of Formula Types
    • List of All Formulas
    • Math Functions
    • Logical Functions
    • Text Functions
    • Left and Right
    • Find, Replace, Search, Split and Substitute
    • Assignment: Creating your own functions
    • Functions and Formulas Quiz
    • Questions?
  • Charts and Graphs
    • Introduction to Charts and Graphs
    • Different Kinds of Charts
    • Creating our First Chart!
    • Creating a Scatterplot
    • Assignment: Create your own chart!
    • Charts and Graphs Quiz
  • Advanced Google Spreadsheets
    • Note from Justin
  • Lookups
    • Kinds of Lookups
    • Fun with VLOOKUP
    • Exercise: Using VLOOKUP
    • Answer to VLOOKUP Exercise
    • VLOOKUP Additional Resources
    • Fun with HLOOKUP
    • HLOOKUP Exercise
    • Lookups Quiz
  • Pulling Data a Spreadsheet with ImportXML and ImportHTML
    • Introduction to ImportXML
    • ImportXML Syntax
    • Importing XML Data into Spreadsheets
    • Importing Alexa Data with ImportXML
    • ImportXML Resources
    • ImportXML Quiz
    • Using ImportHTML
    • ImportXML and ImportHTML quiz
  • Macros
    • Introduction to Macros
    • Writing our First Macro
    • Example: Write Your Own Macro
    • Macros Quiz!
  • Tools to Use with Google Docs
    • Spreadsheet Add-ons
    • Using Spreadsheet Booster
    • Advanced Spreadsheet Booster
  • Resources
    • Google Spreadsheet Templates
    • Official Google Spreadsheet Resource
    • Bonuses
    • What did you think of the course? Plus, bonus inside!

View Full Curriculum


Access
Lifetime
Content
7 hours
Lessons
19

Effortless Email: Achieve Inbox Zero for Good & Master Gmail

Unshackle Yourself from the Throes of an Unruly Gmail Inbox

By Arman Assadi | in Online Courses

Email should be a tool to optimize productivity, but it often causes more pain than it eliminates. Free yourself from the chains of a relentless Gmail inbox by using tools and techniques to customize, organize, and streamline your email management process. You'll not only spend eight fewer hours per week on email, but also get more done than you thought possible.
  • Master Gmail inbox management w/ 7 hours of content
  • Save over 8 hours per week (384 hours/year) on email
  • Master the foundation & psychology of effortless email
  • Achieve & maintain inbox zero
  • Eliminate spam & other unwanted, annoying emails
  • Create one custom inbox for all your accounts that shows only the most important emails
  • Learn about productivity shortcuts & tools (like Gmail Labs)
Arman Assadi is on a mission to help people identify their life's craft and create a self-directed lifestyle. He is a solopreneur, writer, Silicon Valley consultant, strategist for multiple serial entrepreneurs and NYT #1 bestselling authors, contributor to sites like Entrepreneur and Business Insider, former Googler, and online educator. Arman's blog is a popular resource among entrepreneurs, solopreneurs, and self-directed learners. For more details on the course and instructor, click here. This course is hosted by StackSkills, the premier eLearning destination for discovering top-shelf courses on everything from coding—to business—to fitness, and beyond!

Details & Requirements

  • Length of time users can access this course: lifetime access
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels

Compatibility

  • Internet required

Course Outline

  • Introduction
    • Introduction to Effortless Email
  • The Foundation and Psychology of Effortless Email
    • Effortless Inbox Mindset
    • How to Check Your Email
    • When to Check Your Email
  • Effortlessly Build a Custom Inbox Zero
    • Effortless Gmail
    • Effortless Inbox Reboot
    • FREE PREVIEW: Setting Up Your Effortless Inbox
  • Setting Yourself up for Lifelong Success
    • How to Train Your Inbox (Dragon)
    • The Secret to Eliminating Spam and Annoying Emails Forever
  • Mastery: Going Pro and Becoming an Email Ninja
    • Effortless Shortcuts
    • Gmail Labs
    • Ultimate Productivity Secrets and Tools
  • BONUS: Effortless Email eBook
    • Effortless Email eBook
  • BONUS: Primetime Productivity Audio Course
    • Session 1: Introduction
    • Session 2: Hour of Primetime
    • Session 3: Secrets to Productivity
    • Session 4: Rituals
    • Session 5: Managing Yourself
    • Session 6: The Success Factor

View Full Curriculum


Access
Lifetime
Content
4.5 hours
Lessons
20

Master the Google Apps Admin Console

Learn to Effectively Manage Your School's Educational Domain

By John Meixner | in Online Courses

Are you an admin for Google Apps for Education? With this course, you'll learn everything you need to know to effectively manage your educational domain and tools. You'll learn everything from how to set up your account for optimal productivity to setting up a naughty word list to monitor student emails, ultimately turning your school's website management into a breeze.
  • Dive into the Google Apps Admin Console w/ 4.5 hours
  • Learn to effectively manage an educational domain as a Google Apps admin
  • Explore advanced options for staff & student accounts
  • Learn advanced Gmail techniques related to Gmail For Staff & Gmail For Students
  • Create & manage Google Groups to streamline communication
  • Utilize security enhancements & implement reporting tools
John Meixner is a Google Apps Certified Deployment Specialist, a Google Apps Certified Administrator, and an Certified Google Trainer. He began his professional speaking career by training thousands of IT administrators on networking technologies, and later founded Netdemics to help bring the cloud to his clients. For more details on the course and instructor, click here. For more details on the course and instructor, click here. This course is hosted by StackSkills, the premier eLearning destination for discovering top-shelf courses on everything from coding—to business—to fitness, and beyond!

Details & Requirements

  • Length of time users can access this course: lifetime access
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: intermediate

Compatibility

  • Internet required

Course Outline

  • Top Ten Configuration Tips
    • Introduction
    • Moving To The Cloud And Responsibilities Of The Admin
    • Top Ten Configuration Tips: 1-3
    • Top Ten Configuration Tips: 4-7
    • Top Ten Configuration Tips: 8-10
  • Organizational Units And Users
    • Setting Up Effective Organizational Units
    • Create Staff Accounts And Set Password Policies
    • Adding Accounts In Bulk
    • Create Student Accounts
    • User Management
  • Configuring Apps
    • Configure The Core Apps, Part I
    • Configure The Core Apps, Part II
  • Advanced Gmail
    • Gmail For Staff, Part I
    • Gmail For Staff, Part II
    • Gmail for Students, Part I
    • Gmail for Students, Part II
  • Google Groups
    • Creating Google Groups
    • Managing Google Groups
  • Security And Reporting
    • Security And Reporting
    • Bonus Tools

View Full Curriculum


Access
Lifetime
Content
3 hours
Lessons
19

How to Use Gmail to Maximize Your Productivity

Bring Order to Your Inbox & Turn "Inbox Zero" into a Realistic Goal

By Kosio Angelow | in Online Courses

If "inbox zero" has long been an unobtainable fantasy for you, it's time to make it a reality. Learn everything from setting up your Gmail account for optimal productivity, to processing your emails with tricks like speed typing. You'll not only cease to pull out your hair each time you look at your inbox--you'll send your productivity soaring to new heights.
  • Bring order to your Gmail inbox w/ 3 hours of content
  • Configure your settings for maximum efficiency
  • Learn proven tactics to always be on top of your emails
  • Eliminate unnecessary emails to reduce your inbox count
  • Process emails in record time
  • Utilize hacks to increase productivity: creating "throwaway" email addresses, apply filters, etc.
  • Secure your Gmail account against hacks
Kosio Angelov is the #1 Amazon bestselling author of the "Lean Email Simple System" and a master trainer in the art of "doing the right things, the right way". Enroll in his courses and learn how to be "Successful By Design", how to break the busyness bubble, achieve exponential productivity and live life by design, not by default. Whether you need a productivity boost or to reach inbox zero and tame the never-ending flow of emails, Kosio's strategies will get you there... fast. For more details on the course and instructor, click here. This course is hosted by StackSkills, the premier eLearning destination for discovering top-shelf courses on everything from coding—to business—to fitness, and beyond!

Details & Requirements

  • Length of time users can access this course: lifetime access
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels

Compatibility

  • Internet required

Course Outline

  • WELCOME - WATCH THIS FIRST
    • Welcome Message from Kosio Angelov
    • Overview Of The Entire System - What Can You Expect
  • How To Set Up Gmail For Maximum Productivity
    • How To Set Up Gmail For Maximum Efficiency
    • How To Consolidate All Your Email Accounts Into One (And Why)
  • How To Reduce Your Email Count (Drastically)
    • Inbox Zero Fundamentals - The 5 Strategies That Make It Possible
    • How To Decide Which Emails To Keep And Which Ones To Discard
    • How To Quickly (And Easily) Unsubscribe From All Unecessary Emails
    • How To Create An Unlimited Amount Of "Throwaway" Email Addresses
    • Advanced Unsubscribe Technique
  • The Art of Effective Email Processing
    • The ONLY 5 Actions To Take With Each Email
    • How To Take Your Processing To The Next Level Using Keyboard Shortcuts
    • Filters Are Your Best Friend - Use Them To Boost Your Productivity
    • How To Use Labels Propely
    • Typing Speed - Where Small Impvorements Lead To BIG Results
  • How To Secure Your Email Account and Prevent Hacking
    • How To Secure Your Gmail Account And Make Sure You Never Get Locked Out
    • Advanced Security Options - Taking Your Gmail Security To The Next Level
  • BONUS SECTION: To Infinity And Beyond
    • Boomerang for Gmail - How To Schedule Messages To Be Sent In The Future
    • Inbox Pause - How To Pause Your Emails If Needed
    • How To Easily Create Professional-Looking Signatures

View Full Curriculum


Access
Lifetime
Content
2.5 hours
Lessons
42

25+ Gmail Strategies - Hit Email Inbox Zero

Become a Gmail Power User with Tried-and-True Techniques

By Mellon Training | in Online Courses

Spend hours each day sifting through a large pile of emails? There's a better way to use Gmail. This course will teach you valuable techniques to tame your inbox, allowing you to configure settings, organize emails, and customize your interface like a pro. You'll spend less time dealing with the minutiae of email management, and more time getting things done, period.
  • Learn over 25 techniques to tame your Gmail inbox w/ 2.5 hours of content
  • Create your own inbox zero system
  • Clean up your email environment: archive, delete, mass subscribe, etc.
  • Organize your inbox w/ filters, stars & labels
  • Customize your interface: consolidate multiple accounts, get desktop notifications, etc.
  • Quickly compose, search for & reply to emails
  • Utilize tools like Gmail Labs, Contacts, Tasks, etc.
Andreas Exadaktylos has over 16 years of experience in teaching as an instructor, especially in Microsoft Excel, and has a passion for software products that make people's lives easier. He runs his own computer learning school, Futurekids, as well as the online video tutorial platform Mellon Training, and enjoys building websites and utilizing SEO techniques to improve them. For more details on the course and instructor, click here. This course is hosted by StackSkills, the premier eLearning destination for discovering top-shelf courses on everything from coding—to business—to fitness, and beyond!

Details & Requirements

  • Length of time users can access this course: lifetime access
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: beginner, intermediate, advanced, all levels

Compatibility

  • Internet required

Course Outline

  • Welcome to the Productive Gmail Management System Course
    • Course Introduction
    • Introduce Yourself!
    • How to view in HD
    • Download the Course Study Tracker
    • Create Your Own Inbox Zero System
  • CLEAN UP YOUR EMAIL ENVIRONMENT
    • Perform Actions Quickly on Many Emails
    • Clean Up Your Email: Archiving and Deleting
    • Trash and Spam Messages
    • Get Rid of Those Newsletters - Mass Unsubscribe
    • I need your help!
  • ORGANIZE YOUR INBOX ~ FILTERS + STARS + LABELS
    • Managing Your Emails With Labels – PART 1
    • Managing Your Emails With Labels – PART 2
    • The Stars System: Organize Your Messages
    • Using Filters to Automatically Process a Message
    • Advanced Filtering: Tips & Tricks
    • Unsubscribe to Emails using Filters
    • How can I help you?
    • Block a Sender in Gmail using Filters
  • CUSTOMIZE YOUR GMAIL INTERFACE
    • Essential Settings From the Gear Icon
    • Add and Manage Multiple Email Accounts In One Place
    • You’ve Got Mail: Desktop Notifiers
    • BONUS ~ How to Delete Your Gmail Account Permanently
  • INCREASE THE SPEED OF EMAIL PROCESSING
    • The Secrets of Composing a Message Fast
    • Create an email Signature with Gmail or WiseStamp
    • Keyboard Shortcuts: Turn Yourself into an Email Ninja!
    • Advanced Searching: Find Any Email You’re Looking For
    • Use Search Operators to Perform Advanced Searching
    • Are You On Vacation? Let Gmail Reply For You
    • Delegate the Management of Your Inbox to an Assistant
    • CHEAT SHEET ~ Keyboard shortcuts for Gmail
  • USING GMAIL LABS TO FINE-TUNE YOUR EMAIL SYSTEM
    • Exploring the Settings of Gmail Labs and Mark as Read Button
    • Reply to Mail Faster with Canned Responses
    • Un-send Emails and View Messages without Clicking Through
    • Quick Links: Put Your Most Frequent Gmail Destinations In Front of You
  • TASKS AND CONTACTS MANAGEMENT
    • Contacts and Contact Groups: Save Time and Be Productive
    • Tasks: Maintain Multiple To-do Lists
  • THIRD-PARTY TOOLS ~ IFTTT + BOOMERANG + BATCHEDINBOX
    • Use IFTTT to Automate Gmail’s Interaction with Popular Apps
    • Schedule Sending and Set Email Reminders with Boomerang
    • Deliver Your Emails at Times You Specify with BatchedInbox
  • INBOX BY GMAIL > THE FUTURE IS HERE
    • Exploring the New Design
    • Pinning, Sweeping, and Snoozing Messages and Reminders
  • CONCLUSION
    • Thank you!

View Full Curriculum


Access
Lifetime
Content
1.5 hours
Lessons
17

Google Chrome Developer Tools

Build JavaScript Apps, Analyze Network Usage, Increase SEO & More, Straight From Your Chrome Browser

By Jeff Everhart | in Online Courses

Google Chrome isn't just a way to view websites--it offers a suite of powerful tools to take them to the next level. Elevate your web design and development skills using the almighty suite of Google Chrome Development Tools, tucked into each Chrome browser. Before you know it, you'll be tweaking front-end designs, increasing data transfer speeds, and much more like a veritable pro.
  • Master using Google Chrome Development Tools w/ 1.5 hours of content
  • Debug and alter HTML & CSS directly in your browser
  • Build web apps using Chrome’s V8 JavaScript engine
  • Test responsive page designs by emulating mobile devices in Chrome
  • Access HTML5 LocalStorage & other persistent data stores
  • Analyze network usage for your site & increase its speed
  • Improve SEO, increase mobile speed & utilize free fonts
Jeff Everhart has been working on the wWb since before smartphones existed, and spends most of his working hours making difficult technology concepts easier to understand. He specializes in full-stack JavaScript applications, data visualization, Google Apps, and WordPress development. With several years of online teaching experience and technology training in higher education, you can ensure that Jeff's courses are of the highest quality possible. For more details on the course and instructor, click here. This course is hosted by StackSkills, the premier eLearning destination for discovering top-shelf courses on everything from coding—to business—to fitness, and beyond!

Details & Requirements

  • Length of time users can access this course: lifetime access
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels

Compatibility

  • Internet required
  • Google Chrome required
  • Some HTML, CSS, or JavaScript/jQuery experience recommended
  • Some web/app hosting experience recommended

Course Outline

  • Start Here
    • Course Introduction
    • Accessing Chrome Dev Tools
    • Getting Started with Chrome Dev Tools
  • Working with HTML and CSS in Chrome Dev Tools
    • Using the Elements Panel
    • Getting Started with Elements Panel
  • Working with JavaScript in Chrome Dev Tools
    • Using the JavaScript Console
    • Using the Sources Panel
    • Getting Started with JavaScript Console
  • Working with Browser Storage in Chrome Dev Tools
    • Using the Resources Panel
    • Getting Started with Resources Panel
  • Thinking Mobile First in Chrome Dev Tools
    • Testing Responsive Design by Emulating Mobile Devices
    • Getting Started with Mobile Emulation
  • Analyzing Page Load Time in Chrome Dev Tools
    • Using the Network Panel
    • Using the Audits Panel
  • Bonus Content
    • Using Google PageSpeed Insight to Improve Page Load Times
    • Improving SEO with Google Keyword Planner
    • Using Free Fonts with Google Fonts API

View Full Curriculum


Access
Lifetime
Content
1.5 hours
Lessons
11

Master Google Drive

Remotely Store, Access & Collaborate Upon Your Data Like a Pro

By John Meixner | in Online Courses

Pesky USB sticks? Inaccessible data? Not a problem any longer! Google Drive turns remote file storage and access, as well as virtual collaboration, into a dream. This cloud storage platform will enable you to easily organize, track, and back up your data remotely, allowing you to seamlessly collaborate upon and share it with others.
  • Master use of Google Drive w/ 1.5 hours of content
  • Easily organize, track & back up your data in the cloud
  • Quickly share stored files w/ others
  • Collaborate w/ others on shared documents in real time
  • Eliminate the need to deal w/ attachment, USB sticks, lost data, etc.
John Meixner is a Google Apps Certified Deployment Specialist, a Google Apps Certified Administrator, and an Certified Google Trainer. He began his professional speaking career by training thousands of IT administrators on networking technologies, and later founded Netdemics to help bring the cloud to his clients. For more details on the course and instructor, click here. This course is hosted by StackSkills, the premier eLearning destination for discovering top-shelf courses on everything from coding—to business—to fitness, and beyond!

Details & Requirements

  • Length of time users can access this course: lifetime access
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels

Compatibility

  • Internet required

Course Outline

  • Understand
    • Introduction
    • What Is Google Drive?
    • Getting To Know The Interface
    • Customizing Drive
  • Create
    • Creating Drive Files
    • Top Tips for Docs, Sheets, Slides
    • Creating Forms
    • Add-Ons And Templates
  • Share
    • Basic Sharing
    • Advanced Sharing
  • Upload
    • Adding Files To Drive

View Full Curriculum


Access
Lifetime
Content
3.5 hours
Lessons
55

Google Apps for Everyone

Master This Powerful Productivity Suite to Craft Documents, Create Spreadsheets & More

By Mike Daugherty | in Online Courses

If you haven't added Google Apps to your productivity toolbox already, now's your chance. Google Apps is a powerful (and yes, free) suite of tools that allows you to easily craft documents, create spreadsheets, assemble presentations, and more. And this course is your ticket to full-fledged mastery.
  • Get an overview of Google Apps w/ 3.5 hours of content
  • Understand how to use Google Apps as an alternative to Microsoft Office
  • Dive into Docs, Drive, Spreadsheets, Forms, Presentations & Drawings
  • Set up your account & create your first Google Doc
  • Create forms to collect data, create sleek presentations, etc.
  • Augment your workflow & increase your productivity
Mike Daugherty is the Director of IT for a high-performing school district in Ohio, where he has successfully implemented a 1:1 computing initiative with Google Chromebooks. He is responsible for providing training to staff on how to use Google's product suite to create, share, and collaborate with colleagues and students alike. Previously, Mike successfully formed and sold two technology companies. For more details on the course and instructor, click here. This course is hosted by StackSkills, the premier eLearning destination for discovering top-shelf courses on everything from coding—to business—to fitness, and beyond!

Details & Requirements

  • Length of time users can access this course: lifetime access
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels

Compatibility

  • Internet required
  • Google/Gmail account required

Course Outline

  • Google Drive
    • Intro
    • Creating Your Free Account
    • Google Drive
    • New Lecture
  • Google Docs
    • Creating Your First Google Doc
    • Fonts, Sizes and Colors (oh my!)
    • Bold, Underline, Spacing, Justify, and Clearing the formatting
    • Inserting An Image
    • Inserting a Link
    • Headers and Footers
    • Tables - Two Ways to Use Them
    • Sharing and collaboration
    • Downloading a Copy of Your File in Microsoft Word
    • Uploading and Converting a Document
    • Revision History - Always Saving, all the time.
    • Making it in Google
  • Google Spreadsheets
    • Intro and formatting your data
    • Creating Charts
    • The Power of Conditional Formatting
    • Validating Your Data
    • Notifications
    • Protecting a row, column or sheet
    • Sorting Your Data
    • Creating and Saving Data Filters
    • The Big Freeze
    • Functions and Names Ranges
  • Google Forms
    • Your First Form
    • Long Answer Questions
    • Multiple Choice Questions
    • Check Box Questions
    • Drop down Question
    • Inserting an Image into Your Form
    • Inserting a Video
    • Pages and Sections
    • Options After Your Form is Submitted
    • Scale and Grid Questions
    • Data Validation
  • Google Presentations
    • Intro and themes
    • Adding Slides
    • Transitions and Animations
    • Importing Slides
    • Exporting Your Presentation
    • Options for Showing Your Presentation
    • Presentation Summary
  • Google Drawings
    • Intro and Your First Text Box
    • Word Art in Google Drawings
    • Lines, Curves, and Scribbles
    • Adding Shapes
    • Arranging Images in Your Drawings
    • Exporting the Drawing
  • Bringing it All Together
    • Upload, Convert, and Sharing Something You Have Previously Created
    • Instant Feedback Quiz / Flash Cards
    • Branch Logic
    • Summary
    • New Lecture

View Full Curriculum



Terms

  • All sales final
  • Instant digital redemption