Google Sheets Course

Access your data from any browser

Course Duration

16 Hours

Course Level

Intermediate

Overview

Google Sheets is a spreadsheet application, similar to Excel, that is free and cloud-based.
This means that Google Sheets opens in the browser window like a regular web page. Each user can access his files and edit and share them from any computer.
Google Sheets contains all of Excel’s functionality for performing powerful data analysis.
The Google Sheets course is designed to teach employees and managers in businesses and organizations to use this tool professionally for shared data management in spreadsheets.

Who is it for?

1. Employees and managers in businesses who know Excel and want to get to know another  and collaborative platform.
2. Employees and managers who need to share data sheets with colleagues, or customers

Pre-requisites

None

Topics

  • Basic Level:
  • Creating tables and formatting: texts, dates, numbers
  • Simple formulas: addition, subtraction, multiplication, division, examples of formulas, percentage calculations,
  • Relative formula and fixed formula, formula copying,
  • cell fixation within a formula, links between sheets
  • Statistical formulas: AVERAGE, COUNT, COUNTA, MIN, MAX, SUM,
  • Connecting and splitting texts
  • Conditional Formatting
  • Long document management, different display settings, freezing of on-screen titles and in printing, hiding rows / columns
  • Printing options
  • Sorting and filtering data
  • Graphs
  • PIVOT TABLES – Beginning
  • Sharing Options

    Advanced Level:
  • Aligning the basic spreadsheet content:
  • Sheet shortcuts
  • Naming cells, ranges
  • Logical formulas IF, OR, AND, Nested IF, COUNTIFS, SUMIFS
  • Different display settings, freezing on-screen titles and in printing, hiding rows / columns
  • Working with databases: Criteria for building a database for data exploration and processing
  • Sorting and filtering data, Advanced Sorting
  • Pivot Tables for analyzing multiple data tables
  • Conditional formatting
  • Functions:
  • VLOOKUP + HLOOKUP formula for searching and finding information and comparing tables
  • FILTER, SORT, UNIQUE Functions
  • Create drop-down lists
  • Creating graphs
  • Sharing Options

The list of topics above is partial and only an outline. A full and detailed syllabus will be sent as part of a bespoke proposal that will be tailored to your organization and your requests.

What is Live Online training?​
How does it work?​
What are bespoke courses?​
Request Free Consultation

Excel Training Live © 2021

What is Live Online training?​

In live online training, instructors connect with a group of participants in an interactive virtual learning space that includes screen sharing, and other digital aids.

The way in which training is delivered has evolved considerably in the last few years. Businesses have realized the benefits and flexibility of online training, allowing employees to participate from any country or location, be it their home, office, or meeting room.

To be effective, Live Online training needs to be meticulously designed to be practical and personalized, and based around the roles, workloads and skill levels of the staff being trained. Additionally, they must make the most of the tools available for remote learning.

Our Live Online trainers understand how to construct and deliver interactive trainings that function as a workshop, and not as a lecture, so the trainees get a practical, professional and effective learning experience. Sharing the trainees screen ensures the skills being taught are being successfully applied, and the chat box allows questions to be asked without disrupting the lesson, and for answer to be provided immediately.

How does it work?​

As each organization is different, and your organization has its own specific need and requirements, the first step is for us to get more acquainted. We invite you to complete our specially created contact form to help us understand more about your company.

The next step is to arrange and conduct a free consultation on Zoom where we dive into the specifics or your requirements and understand exactly what would be the best course structure that should be developed for you.

During the consultation we construct together the scope and duration of the trainings, and what targets you would like to achieve. Based on this information we will send you a personalized price quote for the training.

After approval of the quote, we will choose together convenient dates for the classes, and we will conduct a TNA (training needs analysis). This will allow us to organize the classes into homogenous groups and pinpoint the specific missing skills that need to be addressed.

The first hour of the course is usually dedicated to creating a common baseline for the students, to bridge any gaps in the skill levels.

After the course has completed, we offer ongoing support for the course graduates to help them fully assimilate their new knowledge and skills within their job.

What are bespoke courses?​

Bespoke trainings are tailor made trainings to specifically fit the needs and requirements of any company or organization. This is based on the skill levels and job requirements of the employees.

Why Should I Consider Bespoke Training?

Bespoke training are courses specially created to fit the requirements of your organization and are a highly valuable resource for your employees. Courses are structure around the skill levels and occupational needs of your business. Since the training has been built for your company, it saves the money, time and effort that otherwise would be spent on designing and conducting an in-house training course yourself.

Each employee is different, coming with a different skill set and each learning in a different way. Generic classes or traditional courses are not created with the employees in mind and may not be the best option for your company. Customized trainings that fit your organization’s specific needs provide a more effective platform for improving employee’s skill sets.