Special Discount

Use the code MAY in your cart for 40% off this course!

Enroll Now
  • 00 Days
  • 00 Hours
  • 00 Minutes
  • 00 Seconds

Course curriculum

    1. Identify the purpose

    2. Plan & Organize

    3. Add Your Data

    4. Calculations

    5. Analyze Your Data

    6. Sharing & Collaborating

    1. Google Sheets User Interface - Intro

    2. Google Sheets User Interface: The Toolbar

    3. Google Sheets User Interface: Menus

    4. Creating a Spreadsheet: Intro

    5. Creating a Spreadsheet: Adding Spreadsheets

    6. Creating a Spreadsheet: Naming Sheets

    7. Editing a Spreadsheet: Hiding Sheets

    8. Editing a Spreadsheet: Renaming Spreadsheets

    9. Editing a Spreadsheet: Copying Data Across Cells & Sheets

    10. Duplicating, Printing & Publishing a Spreadsheet

    11. Keyboard Shortcuts

    1. Formulas & Functions: SUM Function

    2. Formulas & Functions: Average Function

    3. Formulas & Functions: Count Function

    4. Formulas & Functions: SUMIF & COUNTIF Functions

    5. Formulas & Functions: VLOOKUP Function

    6. Importing Data: Excel Import to Google Sheets

    7. Importing Data: Google Sheets Import External Data

    8. Analyzing Data: Analyzing With Charts

    9. Paste Special: Paste Values & Formats

    10. Paste Special: Pasting Formulas

    11. Sort & Filter: Basic Filtering

    12. Sort & Filter: Advanced Filtering

    13. Relative & Absolute References

    14. Format Cells, Rows & Columns: Designing & Formatting Cells Rows

    15. Format Cells, Rows & Columns: Formatting Data

    16. Highlighting Data Points

    1. Introduction to the Example Dashboard Project

    2. How to Organize Data in Google Sheets

    3. How to Import Data for The Dashboard

    4. How to Format & Clean Data for the Dashboard

    5. Learn to Freeze Rows & Columns in Your Dataset

    6. Learn Pivot Tables

    7. How to Insert Charts

    8. Importing External Google Sheets Documents Into Our Primary Spreadsheet

    9. Finalizing Our Example Dashboard

    1. Advanced Functions: RAND Function

    2. Advanced Functions: Location Functions

    3. Advanced Functions: Statistical Functions

    4. Advanced Functions: Logical Functions

    5. Advanced Functions: Transpose Function

    6. Advanced: VLOOKUP & HLOOKUP Functions

    7. Formatting Tips & Tricks: Alternating Colors

    8. Formatting Tips & Tricks: Conditional Formatting

    9. Formatting Tips & Tricks: Creating Drop Down Menus

    10. Formatting Tips & Tricks: Find & Replace

    11. Formatting Tips & Tricks: Google Sheet Themes

    12. Formatting Tips & Tricks: Hiding & Grouping Rows & Columns

    13. Formatting Tips & Tricks: Interactive Cross-Out Checkboxes

    14. Formatting Tips & Tricks: Naming Cells & Ranges

    15. Formatting Tips & Tricks: Split Function

    16. Formatting Tips & Tricks: Text to Columns Tool

    1. Bonus Sheets vs Excel: Intro

    2. Google Sheets vs Excel

About this course

  • $99.00
  • 60 lessons
  • 7.5 hours of video content

Your Instructor

Tom Cote

Instructor

Tom Cote is the CEO and Managing Partner at Sidekick Digital Media and the CEO and Co-Founder at Pallate. He is also a former Product Lifecycle Manager and Global Launch Manager at Microsoft. Managing more than $5M per year in digital marketing spend for clients, he has unparalleled expertise to share with his students.

Discover your potential, starting today

Enroll today