Jun
01
09:30

Data Analysis with Google Sheets: Key Functions and Formulas

Workshop
Hebrew Session
Rami Cohen
CPA @ Rami Cohen
Certified Public Accountant MBA in Business Administration, specializing in Finance Years of experience writing and implementing Excel software training programs self-employed offering : 1. excel training courses 2. accounting, financial and business consulting services in the past: * lecturer at the College of Management in Information Systems courses - Excel, Access, Business Intelligence, and Computer Applications * CPA at KPMG "Somech Chaikin” office, IT and consulting department * Chief Economist at "Ledico BOSCH"
More about 
Rami Cohen
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

Rami Cohen

CPA @ Rami Cohen

About
Rami
Certified Public Accountant MBA in Business Administration, specializing in Finance Years of experience writing and implementing Excel software training programs self-employed offering : 1. excel training courses 2. accounting, financial and business consulting services in the past: * lecturer at the College of Management in Information Systems courses - Excel, Access, Business Intelligence, and Computer Applications * CPA at KPMG "Somech Chaikin” office, IT and consulting department * Chief Economist at "Ledico BOSCH"

Where's your nearest Jolt campus?