Google Sheets Masterclass: The Power of Excel and Analysis

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

$35.30

TAKE THIS COURSE

1 Year Access

Advanced

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.

Certification

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

N.A

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.

Certificate

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.

Google Sheets Masterclass: The Power of Excel and Analysis