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
Testimonials
Related Courses
Business Intelligence in MS SQL Server 2008
14 hoursTraining 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 hoursThis 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 hoursAWS 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 hoursSisense 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 hoursAdvances 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 hoursOverview 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 hoursQlik 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 hoursAdvances 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 hoursDatameer 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 hoursIRIS 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 hoursLearn 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 hoursPentaho 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 hoursQlikView 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 hoursQlikView 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 hoursSSAS (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