Achieve your career goals

“A learning experience so engaging it’s addictive”

Unlimited
£85/month
Get Started

Unlimited workshops and collections

Join a global community of professionals

Interact with industry superstars

30 day money-back guarantee

Cancel anytime

“A learning experience so engaging it’s addictive”

Leadership & management
Marketing & sales
Product
Finance & legal
Data
Personal skills
Business strategy
Career Development

Analyze Data with Google Sheets


4.19
/ 5
Mini-course
193
students
17
times delivered

Questions we’ll answer:

1

How do you perform simple calculations in Google Sheets?

2

How do you use basic functions on data sets in Google Sheets?

3

How do you pull data efficiently using VLOOKUP?

How do you draw business insights from data sets using a PIVOT table?

What to expect:

The skill of analyzing data (often with Google Sheets or Excel) has become an integral demand in business. Still, most people are hesitant when having to work with these programs. In this workshop, you will learn:

- How to fill in, sort, and search for data at minimum time

- How to use critical functions, including VLOOKUP, which will help you retrieve data efficiently

- Creating a PIVOT table to analyze data

Why Google Sheets? We chose to teach data analysis using this program because you can easily collaborate on it and share it. Nevertheless, these functions and formulas apply to Excel and other spreadsheet programs.

Join this workshop to get a head start in analyzing data right on your own.

PLEASE NOTE:* This workshop requires prior experience in editing spreadsheets in Google Sheets. If you have yet to work on this program, we recommend that you first become familiar with its fundamental controls: https://www.coursera.org/learn/getting-started-with-google-sheets (free online course)*

What’s a Rich Text element?

The rich text element allows you to create and format headings, paragraphs, blockquotes, images, and video all in one place instead of having to add and format them individually. Just double-click and easily create content.

Static and dynamic content editing

A rich text element can be used with static or dynamic content. For static content, just drop it into any page and begin editing. For dynamic content, add a rich text field to any collection and then connect a rich text element to that field in the settings panel. Voila!

How to customize formatting for each rich text

Headings, paragraphs, blockquotes, figures, images, and figure captions can all be styled after a class is added to the rich text element using the "When inside of" nested selector system.

Deck preview:

No items found.
No items found.
This Jolt’s delivered by:
Rami Cohen
CPA @ Rami Cohen

193

people have taken this workshop

Yaakov L.



It was super practical. Rami is a great jolter!

Danielle N.



Rami was super engaging. It was great that we had practical tasks to try out what we had just learned.I learned more practical skills than I have in any other previous Jolt.

Aprooved by SUBA commetee:
January 2020
Jolt was built by:
Last updated:
January 2020
193
students
17
times delivered
Get Started
Approved by SUBA committee:
January 2020
Last updated:
January 2020
Management & leadership
Marketing & sales
Product
Finance
Data
Personal skills & self development

Analyze Data with Google Sheets


4.19
|
reviews
193
students
17
times delivered
CPD certified

In this workshop you'll learn:

How do you perform simple calculations in Google Sheets?

How do you use basic functions on data sets in Google Sheets?

How do you pull data efficiently using VLOOKUP?

How do you draw business insights from data sets using a PIVOT table?

What to expect:

The skill of analyzing data (often with Google Sheets or Excel) has become an integral demand in business. Still, most people are hesitant when having to work with these programs. In this workshop, you will learn:

- How to fill in, sort, and search for data at minimum time

- How to use critical functions, including VLOOKUP, which will help you retrieve data efficiently

- Creating a PIVOT table to analyze data

Why Google Sheets? We chose to teach data analysis using this program because you can easily collaborate on it and share it. Nevertheless, these functions and formulas apply to Excel and other spreadsheet programs.

Join this workshop to get a head start in analyzing data right on your own.

PLEASE NOTE:* This workshop requires prior experience in editing spreadsheets in Google Sheets. If you have yet to work on this program, we recommend that you first become familiar with its fundamental controls: https://www.coursera.org/learn/getting-started-with-google-sheets (free online course)*

Deck preview:

No items found.
No items found.

193

people have taken this workshop

Yaakov L.



It was super practical. Rami is a great jolter!

Danielle N.



Rami was super engaging. It was great that we had practical tasks to try out what we had just learned.I learned more practical skills than I have in any other previous Jolt.

193
students
17
times delivered
positive reviews
CPD certified
This Jolt was delivered by:
Rami Cohen
CPA @ Rami Cohen
Aprooved by SUBA commetee :
January 2020
Jolt was built by:
Last updated:
January 2020