Google Sheets Masterclass: Harnessing Excel's Power for Analysis

Master Google Sheets with Excel-style analysis techniques. Learn data cleaning, formulas, pivot tables, and visualisation to transform raw data into actionable insights for smarter, faster decision-making in any professional environment.

For You
For Business

~~£425~~ £29 ex Vat

Save 93.18 % - OFFER ENDS SOON

Add to Cart

Buy Now

Take All courses for £49

1 Year Access
Intermediate
10 Students
7 hours, 21 minutes

Share Link on

£25.00 /Unit Price

£250

Quantity:

Add to Cart

Looking for a more personalised package?

Get access to 5000+ courses including this for only £49. Learn More.

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

Google Sheets Masterclass: Harnessing Excel’s Power for Analysis

~~£425~~ £29

Get This Course