Course Outline

Introduction

Google Sheets Overview

  • What is Google Sheets?
  • Google Sheets features
  • Google Sheets vs Excel

Google Sheets Fundamentals

  • Creating, sharing, formatting spreadsheets
  • Working with pivot tables
  • Sorting and filtering data
  • Using find and replace

Functions and Formulas

  • Creating functions and formulas
  • Using lookups

Data Visualization

  • Creating charts and graphs

Google Sheets Advanced

  • Pulling data
  • Creating macros
  • Using add-ons

Summary and Conclusion

Requirements

  • A basic understanding of computers

Audience

  • Data Analysts
  14 Hours
 

Need help picking the right course?
Call us +971 4871 6715

Testimonials

Related Courses

Business Intelligence in MS SQL Server 2008

 14 hours

Training is dedicated to the basics of create a data warehouse environment based on MS SQL Server 2008. Course participant gain the basis for the design and construction of a data warehouse that runs on MS SQL Server 2008. Gain knowledge of

55232-A: Writing Analytical Queries for Business Intelligence

 21 hours

This three-day instructor led course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. Specifically, this course presents TSQL within the context of data analysis - in other words, making

AWS QuickSight

 14 hours

AWS QuickSight is a business analytics service by Amazon. It provides tools for building data visualization, performing ad hoc analysis, and getting business insights from different data sources. This instructor-led, live training (online or

Sisense Business Intelligence

 14 hours

Sisense is a Business Intelligence tool that provides user-friendly solutions for managing, visualizing, and modifying multiple big data sets quickly and efficiently. This instructor-led, live training (online or onsite) is aimed at developers

Big Data Business Intelligence for Govt. Agencies

 35 hours

Advances in technologies and the increasing amount of information are transforming how business is conducted in many industries, including government. Government data generation and digital archiving rates are on the rise due to the rapid growth of

Big Data Business Intelligence for Telecom and Communication Service Providers

 35 hours

Overview Communications service providers (CSP) are facing pressure to reduce costs and maximize average revenue per user (ARPU), while ensuring an excellent customer experience, but data volumes keep growing. Global mobile data traffic will grow

Qlik Sense for Data Science

 14 hours

Qlik Sense is a cloud-based data analytical software for analyzing and displaying data. With Qlik Sense, users will be able to gain impactful insights by connecting to different data sources and creating advanced visualizations. This

Big Data Business Intelligence for Criminal Intelligence Analysis

 35 hours

Advances in technologies and the increasing amount of information are transforming how law enforcement is conducted. The challenges that Big Data pose are nearly as daunting as Big Data's promise. Storing data efficiently is one of these

Datameer for Data Analysts

 14 hours

Datameer is a business intelligence and analytics platform built on Hadoop. It allows end-users to access, explore and correlate large-scale, structured, semi-structured and unstructured data in an easy-to-use fashion. In this instructor-led,

IRIS: Document Classification and Data Capture

 7 hours

IRIS is an Enterprise Content Management (ECM) system. With IRIS, users can automate document classification and data capturing. This instructor-led, live training (online or onsite) is aimed at content managers who wish to optimize and update

Power BI Dashboards

 14 hours

Learn how to Get & Transform Data to Prepare Interactive Dashboards Power BI is one of the most popular Data Visualization tool, and a Business Intelligence Tool. Power BI is a collection of data connectors, apps, and software services, which

Pentaho Open Source BI Suite Community Edition (CE)

 28 hours

Pentaho Open Source BI Suite Community Edition (CE) is a business intelligence package that provides data integration, reporting, dashboards, and load capabilities. In this instructor-led, live training, participants will learn how to maximize

Qlik: Advanced Topics in Design and Development

 14 hours

QlikView is a platform that provides organizations self-service business intelligence. QlikView's clean, straightforward, and simple interfaces allow users to easily analyze data and use data discoveries to support decision making. In this

QlikView Server Administration

 14 hours

QlikView is a platform that provides organizations self-service business intelligence. QlikView's clean, straightforward, and simple interfaces allow users to easily analyze data and use data discoveries to support decision making. In this

Business Intelligence with SSAS

 14 hours

SSAS (SQL Server Analysis Services), is a Microsoft SQL Server transactional processing (OLAP) and data mining tool for analyzing data across multiple databases, tables or files. The semantic data models provided by SSAS are used by client