Google Sheets Masterclass: Harnessing Excel's Power for Analysis

Google Sheets Masterclass: Harnessing Excel's Power for Analysis

Course Overview

Become a trained professional from the safety and comfort of your own home by taking Google Sheets Masterclass: Harnessing Excel’s Power for Analysis . Whatever your situation and requirements, One Education can supply you with professional teaching, gained from industry experts, and brought to you for a great price with a limited-time discount.

One Education has been proud to produce an extensive range of best-selling courses, and Google Sheets Masterclass: Harnessing Excel’s Power for Analysis is one of our best offerings. It is crafted specially to promote easy learning at any location with an online device. Each topic has been separated into digestible portions that can be memorised and understood in the minimum of time. 

Teaching and training are more than just a job for the staff at One Education; we take pride in employing those who share our vision for e-learning and its importance in today’s society. To prove this, all learning materials for each course are available for at least one year after the initial purchase.  

All of our tutors and IT help desk personnel are available to answer any questions regarding your training or any technical difficulties. 

By completing Google Sheets Masterclass: Harnessing Excel’s Power for Analysis, you will have automatically earnt an e-certificate that is industry-recognised and will be a great addition to your competencies on your CV.

Whatever your reason for studying Google Sheets Masterclass: Harnessing Excel’s Power for Analysis, make the most of this opportunity from One Education and excel in your chosen field.

Please be aware that there are no hidden fees, no sudden exam charges, and no other kind of unexpected payments. All costs will be made very clear before you even attempt to sign up.  

Course design

The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.

You are taught through a combination of

  • Video lessons
  • Online study materials

Will I receive a certificate of completion?

Upon successful completion, you will qualify for the UK and internationally-recognised CPD accredited certification. You can choose to make your achievement formal by obtaining your PDF Certificate at the cost of £9 and Hard Copy Certificate for £15.

Why study this course

It doesn’t matter if you are an aspiring professional or absolute beginner; this course will enhance your expertise and boost your CV with critical skills and an accredited certification attesting to your knowledge.

The Google Sheets Masterclass: Harnessing Excel’s Power for Analysis is fully available to anyone, and no previous qualifications are needed to enrol. All One Education needs to know is that you are eager to learn and are over 16.

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 Protect
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
Order Your Certificate
Order Your Certificate Now 00:00:00

COPYRIGHT © 2022 One Education

Home Search Cart
    Your Cart
    Your cart is emptyBrowse Courses

    Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year

    Claim Offer & Upgrade

    Membership renews after 12 months. You can cancel anytime from your account.

    Other Students Also Buy
      Apply Coupon