Google Sheets Masterclass: The Power of Excel and Analysis

Course Overview Are you looking to gain a new in-demand skill from the comfort of your home? Well, look no …

Google Sheets Masterclass: The Power of Excel and Analysis

Google Sheets Masterclass: The Power of Excel and Analysis




1 Year Access


128 Students


7 hours, 21 minutes

Gift this course

Course Overview

Are you looking to gain a new in-demand skill from the comfort of your home? Well, look no further; you’ve come to the right place!

Our easy-to-follow Google Sheets Masterclass: The Power of Excel and Analysis will provide you with all the deep knowledge and insight you need to know about this topic. This comprehensive course has been broken down into several manageable modules, which we believe will assist you to easily grasp each concept – from the fundamental to the more advanced aspects of the course. 

Learn the most in-demand skills from the safety & comfort of your home. Enjoy the freedom to learn at your own comfortable pace and prepare yourself for the market of the future.

Learning Outcomes

Whether you are an aspiring professional or a complete beginner, this course will improve your expertise and boost your CV with key skills and an accredited certification attesting to your knowledge. 

Entry Requirement

    • This course is available to all learners of all academic backgrounds.
    • Learners should be aged 16 or over to undertake the qualification.
    • Some basic understanding of the English language and numeracy.  


After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can, however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £29 or in PDF format at the cost of £19.

    • PDF certificate’s turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days

Why choose us?

      • Affordable, engaging & high-quality e-learning study materials;
      • Tutorial videos/materials from the industry-leading experts;
      • Study in a user-friendly, advanced online learning platform;
      • Efficient exam systems for the assessment and instant result;
      • The UK & internationally recognised accredited qualification;
      • Access to course content on mobile, tablet or desktop from anywhere, anytime;
      • The benefit of career advancement opportunities;
      • 24/7 student support via email.

Career path

Develop Your Career Plan is a useful qualification to possess and would be beneficial for any related profession or industry. 

Course Curriculum

Module 1: Getting started
Introduction 00:04:00
Getting started on Windows, macOS, Android, and IOS 00:01:00
Module 2: Google Sheets Basic
Sheets Basics to start 00:13:00
Cells Rows and Columns 00:09:00
Productivity Tips and File Sharing 00:09:00
Menu and Toolbar options 00:08:00
Save and print in Sheets 00:03:00
Language and Spreadsheet settings 00:09:00
Version recovery and edit History 00:03:00
Module 3: Data Types and Formulas
Data Types 00:07:00
Data Entry 00:06:00
Autofill in sheets 00:04:00
Data handling basics (copy, cut and paste) 00:04:00
Common functionalities in sheets 00:05:00
Regular Functions in Google Sheets (sum,average,counta and countunique) 00:12:00
Relative Vs. Absolute referencing 00:06:00
Module 4: Data Formatting and Useful tools
Useful tools and Report design 00:03:00
Split Text into columns 00:04:00
Conditional formatting 00:04:00
Create Drop-down lists from data 00:05:00
Data Validations 00:05:00
Importing TXT data files into Google Sheets 00:08:00
Importing .CSV data files into Google Sheets 00:05:00
Getting Data from Other Google Sheets 00:04:00
Module 5: Reports: Filtering, Sorting, and Cleaning Data
Sort Features 00:03:00
Filter and Filter view in Sheets 00:05:00
Filtered Results-(SubTotal) 00:04:00
Remove Duplicates 00:04:00
Trim White Spaces 00:04:00
Find and Replace Data 00:05:00
Module 6: Google Sheets: Essential Functions to Analyse Data
Unique and Sort Functions 00:05:00
SUM(IFS) applying on (COUNT,MIN, MAX) 00:14:00
Logical Functions 00:07:00
IF Function (IF, Then) No voice 00:04:00
Nested IF and IFS Functions 00:11:00
Named Ranges 00:03:00
Rounding Values 00:04:00
Module 7: Google Sheets: Lookup Functions
VLOOKUP Function 00:06:00
HLOOKUP Function 00:04:00
HLOOKUP Match formula 00:06:00
Module 8: XLOOKUP and #NA
XLOOKUP Function 00:04:00
Handling hash NA and Approximates match in XLOOKUP 00:06:00
Module 9: Text, Date, and Time Functions
Basic Text Functions 00:06:00
Split and Join Data from multiple columns 00:04:00
Search and SUBSTITUTE 00:06:00
Date Time Functions 00:06:00
Time Calculations(worked hours) 00:04:00
Module 10: Collaborate, Publish, and Prote
Collaboration and Sharing files 00:06:00
Publishing Sheet or chart to Link in a web page 00:04:00
Publishing Sheet or chart to Embedding in a web page 00:05:00
Email Google Sheets or chart 00:03:00
Prepare for Print or PDF with page breaks 00:05:00
Protect a sheet or range 00:04:00
Use Google Forms to collect real-time data 00:06:00
Exercise and Solution for PDF layout 00:04:00
Module 11: Google Sheets: Charts
Chart Basics – Column and Line Charts 00:04:00
Aggregating Data in Charts – Bar and Pie Charts 00:05:00
Combo charts 00:03:00
Gauge chart 00:06:00
Table chart 00:03:00
Scorecard chart for KPI Dashboards 00:02:00
Adding Slicers to charts 00:04:00
Sparklines chart 00:05:00
Sparklines for Stock and Currency 00:04:00
Geo charts 00:03:00
Module 12: Pivot Tables in Google Sheets
Explore Pivot Features in Google Sheets 00:05:00
Pivot Table Basics in Google Sheets 00:03:00
Use Filters and Slicers for Dynamic Pivot Tables 00:04:00
Grouping items and dates(Month,Year) 00:04:00
Custom Formulas in Pivot Tables 00:03:00
Module 13: Advanced Google Sheets Functions and Formulas
INDEX MATCH for complex lookups 00:04:00
ARRAYFORMULA function 00:05:00
Create your own Arrays and Make totals 00:03:00
INDIRECT Function Lookup 00:03:00
Create Random Data and Text 00:02:00
SEQUENCE Function 00:04:00
Module 14: The QUERY Functions
QUERY Function Basics 00:05:00
QUERY Function using Select and Where 00:08:00
QUERY Function for Aggregation 00:04:00
Group By Multiple Columns 00:05:00
Transform Distinct Values using Pivot(Query Function) 00:03:00
Aggregates and Sorting using Order by clause 00:04:00
QUERY Function for Dynamic Totals 00:06:00
QUERY Function to Combine Data from Multiple Sheets 00:04:00
QUERY Function with IMPORTRANGE to Combine External Sheets 00:04:00
Module 15: Google Sheets: Import Data from Web
Import Tables from the Web(IMPORTHTML) 00:04:00
Import any structured data from Web(IMPORTXML) 00:02:00
Module 16: Google Sheets: QR Code and Images
Insert Image on Google Sheets 00:04:00
Generate QR Code on Required data 00:06:00

Course Ratings


  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Ratings found for this course.

How Do Our Courses Work?

Purchase and payment

Add your chosen course to your basket. Once you’ve added all the courses you need.

Course access

Add your chosen course to your basket. Once you’ve added all the courses you need.


Add your chosen course to your basket. Once you’ve added all the courses you need.

Continued support

Add your chosen course to your basket. Once you’ve added all the courses you need.

Dive into an enriching online learning journey with Alpha Academy. We pride ourselves on offering a diverse range of courses tailored to your needs. Elevate your expertise or discover a new passion. With Alpha Academy, your pursuit of knowledge has no bounds.


For Business

Certificate validator

Payment methods possible


    Your Cart
    Your cart is emptyReturn to Shop

    WINTER SALE :: ALL COURSES for $64.09 / year


    No more than 50 active courses at any one time. Membership renews after 12 months. Cancel anytime from your account. Certain courses are not included. Can't be used in conjunction with any other offer.

      Apply Coupon