Google

Google Sheets Complete Course: Free Online Spreadsheet Excel

Instructor

KuKu

Reviews 5.00 (1 Reviews)

Course Overview

To Access this Content and other Bonuses Signup or Login to Membership

What You'll Learn?

  • Complete Google Sheet guide from starting to pro
  • Solve real-life spreadsheet challenges with ease
  • Learn hacks and hidden Google Sheets features that even the Experts don't know
  • Create interactive & visually effective dashboards in Sheets
  • Secrets to properly use tricky features like Conditional formatting
  • Master Pivot tables, charts and sparklines to create impressive Google spreadsheets
  • Analyze data sets with ease using complex functions & formulas
  • Connect multiple Google Sheets together using a single formula
  • Learn formulas that work in both Google sheets & Excel!
  • Feel completely comfortable in a spreadsheet environment
  • Absolute beginners who want a structured, engaging, fun and practical Google Sheets course.
  • Business professionals looking to expand their skills.
  • Students who want to make sure they have the right level of knowledge to succeed at their next job.
  • Spreadsheet users who want to discover & showcase new tips and tricks at work.
  • Willingness to learn. Let's do this!
  • No prior spreadsheet knowledge is needed.
  • 4.5 hours on-demand video
  • 365 days access
  • Access on mobile and TV
  • Certificate of completion

Course Content

  • Google Sheets Complete Course: Free Online Spreadsheet Excel
    • Basics of Google Sheets

      00:21:59
    • BODMAS & Basic Functions

      00:31:08
    • Advanced Maths Functions

      00:24:14
    • Using Wild Card Functions

      00:32:13
    • Logical Functions IF

      00:13:36
    • IF Related Functions

    • IF Related Functions Task

    • Upper Lower Proper Function

    • Left Right Find Function

    • Left & Right more examples

    • Concatenate Function

    • Replace & Substitue Function

    • Split Function one Column

    • Filters Function in Google Sheets

    • Named Ranges & Links

    • Data Validation & Charts

    • Hlook & Vlook Function

    • Other Functions

    • 19 PMT, PPMT, IPMT & PV

    • Sharing & Protection in Sheet

Membership
  • Duration 05:00
  • Lessons 20
  • Last Update January 14, 2025