Nov
19
13:30

Google Sheets: Work with Data More Effectively

Workshop
Hebrew Session
Keren Singer
CFO, Investor Relations @ Banx.one
Keren is a CPA with an MBA and has experience as a CFO and COO of global hi-tech companies. Her expertise is in FP&A, accounting, operations, logistics, strategy planning, M&As, business operations, growth initiatives, IR, venture capital, funding, biz dev, restructuring and transformations. Keren has helped reduce costs by more than 50%, managed revenue of over $500 million, assisted with 500% increase in business and raised $50m in investments. Her passions include travel, design, volunteering, lecturing, and having fun with her daughter an
More about 
Keren Singer
*Formerly known as 'Data Analysis with Google Sheets: Key Functions and Formulas'* PLEASE NOTE: * This Jolt requires prior experience in editing spreadsheets in Google Sheets or Excel. If you have yet to work on one of these programs, we recommend that you first become familiar with its fundamental controls: https://www.coursera.org/learn/getting-started-with-google-sheets (free online course) -- 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 Jolt, 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 Jolt to get a head start in analyzing data right on your own.

Questions this talk answers:

01

How Do You Perform Simple Calculations In Google Sheets?

02

How Do You Use Basic Functions On Data Sets In Google Sheets?

03

How Do You Pull Data Efficiently Using VLOOKUP?

See the full programme

Keren Singer

CFO, Investor Relations @ Banx.one

About
Keren
Keren is a CPA with an MBA and has experience as a CFO and COO of global hi-tech companies. Her expertise is in FP&A, accounting, operations, logistics, strategy planning, M&As, business operations, growth initiatives, IR, venture capital, funding, biz dev, restructuring and transformations. Keren has helped reduce costs by more than 50%, managed revenue of over $500 million, assisted with 500% increase in business and raised $50m in investments. Her passions include travel, design, volunteering, lecturing, and having fun with her daughter an

Where's your nearest Jolt campus?