Google Sheets Beginners to Pro: 3 - Project BUNDLE

Spreadsheets are the cornerstone of effective business around the work.

They are everywhere - in education, finance, sales, government.

If you show the slightest knowledge of spreadsheets you suddenly become the go to. The pro. The one to notice and get help from. Bosses recognize your skills and your career advancement begins to look really good.

Not only that but mastering spreadsheet skills will suddenly make your life a whole lot easier. You start to learn the shortcuts and vital tools to help you thrive.

Why this course?

In this course, I want to take you on a journey from the basics of using Google Sheets spreadsheets to mastering the essential tools and formulas that you need to improve your efficiency in the workplace, impress your team and make your administrative life easier.

Plus, having tight spreadsheet skills looks impressive on your resume.

This course is about getting in there and completing real-life projects. Projects that you can take away with you and use in your own personal and business life.

If you are looking for a boring lecture-style course here, then this course isn't for you.

The most interesting courses that I have ever taken are the ones where you can follow along and actively create something. You know, apply my skills immediately with a real context to what I am doing and the reward of accomplishing a task at the end.

I always learn the most from these courses.

In this course, we will go through 3 real-life projects that will take you from the very basics of how Google Sheets works all the way through to developing corporate-level dynamic Google Sheets for your workplace.

Not only will we cover how to use:

• tools like Pivot Tables, Charts, Slicers, Data Validation and Conditional Formatting
• the main functions and formulas you need to ace your Google Sheets work-life

 but we will look at:

• spreadsheet design principles
• workflow processes
• develop our shortcut skills, and
• collaborating with others.

What's in the course?

This course is a beast! You will get:

• 45 videos covering all three projects.
• Over 8 hours of video content.
• Each video contains a takeaway summary of what you have covered.
• Starting templates for each project.
• Handy links to further reading or videos.
• Staging templates at strategic points in the course so you can compare your progress.
• A community in the comments section for each video to get support.
• Plus you will walk away with 3 reusable projects that you created.

Who is this course for?

• Beginner to lower intermediate Google Sheets users looking to advance their skills.
• People looking to sharpen their skills and improve their efficiency in Google Sheets
• Anyone looking to better understand spreadsheet design and workflow.
• Someone who knows the benefit of learning through doing and is excited about building some projects as they learn.

Get started with the first Project on me

Yeap. You can dive in and try out the first project for FREE. In this course, you will get access to the first project template, lesson notes and follow along as we build a Budget project together. 

You’ll learn about the Google Sheets interface, copying and pasting data the correct way, and we will cover formatting and even a bunch of formulas. 

Once you have finished the first project you can sign up to finish the rest of the course and really skill up!

The Projects

Project 1: Build a Budget Google Sheet

Budget Sheet

We will get a grasp of the basics of working in Google Sheets by creating a basic Budget. First, I will show you around the Google Sheets User Interface (UI) and then dive into some of the fundamentals.

Project 2: Build a Project Management Workbook

Project Management Sheet

In this project we will create a dynamic Project Management Monitoring Google Sheet, allowing your teams to track their progress and collaborate effectively with each other. We will also explore the benefits of templating data so you don't have to reinvent the wheel each time you need to set up a project.

Project 3 - Build a Gradebook Workbook

Gradebook Sheet

Here we dive into the academic world and create a Gradebook, specifically designed for reuse. We will explore how to analyse your dataset with dynamic dashboards. We'll look at advanced formula construction, integrating live data from other Google Sheets, pivot tables, charts and much more.

Chapters

Introduction

000 | About this course

1 | Create a Simple Budget

001 | Creating your first file

002 | Google Sheets User Interface basics

003 | Copy the budget data into your Google Sheet

004 | Identifying income and expense values

005 | Making the expense data negative

006 | Create a rolling total of profit and loss

007 | Adding a month and year column

008 | Formatting your budget to make it look sharp

009 | Validating the data in your cells with Data Validation

010 | Creating a chart to display your profits and losses over time

011 | Creating different views of your data with filters

2 | Create a Project Management workbook

001 | Project Introduction

002 | Creating the Project Headers

003 | Data Validating Dates

004 | Working Out the Duration

005 | Creating Dropdown Menus

006 | Styling and Custom Conditional Formatting

007 | Creating the Gantt Chart

008 | Improve Readability of our Main Sheet

009 | Protecting Sheets and Ranges

010 | Creating a Dynamic Template Sheet

011 | Importing the General Information From the Main Sheet

012 | Building a Task Breakdown

013 | Adding in Resources, Links and Notes Sections

014 | Template Final Touches

015 | Using the Template

016 | Collaborating and Sharing

3 | Create a Gradebook

001 | Project Introduction

002 | The 'Paste Grades' Tab

003 | Add Core Data

004 | Importing Core Data From Another Sheet

005 | Gradebook: Setup

006 | Gradebook: Inserting Summary Data

007 | Gradebook: Style and Formatting

008 | Gradebook: Adding Bump, Pass-Fail & Letter Grades

009 | Final Course: Entering Data

010 | Final Course: Chart Data

011 | Final Course: Slicers

012 | All Sections: Pass and Fail

013 | All Sections: Letter Grades

014 | By Sections: Setup

015 | By Section: Summary

016 | By Section: Pass-Fail

017 | By Section: Letter Grade

Wrapping Up!

Review and more...

Project Stages Link