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

Clear information, nice atmosphere, involvement in finding solution of the problems mentioned by the participants

Aleksandra Woźniak, AIRBUS HELICOPTERS POLSKA SP. Z O.O.

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
Read More...

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
Read More...

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
Read More...

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,
Read More...

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
Read More...

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
Read More...

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
Read More...

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
Read More...

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
Read More...

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
Read More...

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
Read More...

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
Read More...

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
Read More...

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
Read More...

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
Read More...