Master Google Sheets

 2Month/20 Hours                                                  Price:25,000

                                                                                      20,000

Master Google Sheets

From the fundamentals to the most advanced features, after taking this class you will be able to use Spreadsheets like a MASTER. Pretty soon, you’ll be using Master Google Sheets better than most people can use Excel… and be able to take advantage of the super useful features that only Google Spreadsheets has to offer.

What you'll learn

·        Create, edit, and share spreadsheets

·        Make Forms/Surveys and Collect/Analyze Data

·        Create Customizable CRM

·        Write Faster With Spreadsheets

·        Create Custom Business Analytics Dashboard

·        Use various Add-ons

·        Explore Google Apps Script

·        Implement Extra Resources To Manage Spreadsheets

Course Content

Getting Started

Signing in to Google Apps
Using the Google Apps Menu
Accessing Sheets from Drive
Making a Copy of a Spreadsheet
Understanding the Display Screen
Using the Menu and the Toolbar
Using Help

Entering Data

Changing the Active Cell
Selecting a Range of Cells
Creating a New Spreadsheet from a Template
Creating and Naming a New Spreadsheet
Inserting, Renaming and Deleting Sheets
Entering Constant Values and using Autofill
Modifying Cell Contents
Closing a Spreadsheet

Using Formulas

Entering Formulas
Using Autofill with Formulas
Using the SUM Function
Using Common Functions
Correcting Formula Errors

Modifying Sheet Data

Copying and Pasting Constant Values and Formulas
Cutting and Pasting Constant Values and Formulas
Checking Spelling
Using Find and Replace
Working with Versions
Viewing Details

Formatting Sheets

Formatting Numbers
Formatting Text
Formatting Cells
Aligning Cell Contents
Using Paint Format
Using Alternating Colors
Changing the Theme
Using Conditional Formatting

Modifying Columns and Rows

Moving Columns or Rows
Resizing Column or Rows
Inserting Columns or Rows
Deleting Columns or Rows
Hiding Columns or Rows
Grouping Columns or Rows
Freezing and Unfreezing Columns or Rows
Using Zoom

Printing Sheets

Previewing a Sheet for Printing
Working with Print Settings
Inserting Page Breaks
Creating Headers and Footers
Repeating Row and Column Headers
Printing a Sheet

Working with Charts and Pictures

Creating a Chart
Changing the Chart Location and Size
Working with the Chart Editor Setup Options
Working with the Chart Editor Customize Options
Inserting an Image
Creating a Drawing
Editing a Drawing

International Student Fees: USD250$

---

Job Interview Preparation  (Soft Skills Questions & Answers)

Tough Open-Ended Job Interview Questions
What to Wear for Best Job Interview Attire
Job Interview Question- What are You Passionate About?
How to Prepare for a Job Promotion Interview

---

Stay connected even when you’re apart

Join our WhatsApp Channel – Get discount offers

 500+ Free Certification Exam Practice Question and Answers

 Your FREE eLEARNING Courses (Click Here)

---

Internships, Freelance and Full-Time Work opportunities

 Join Internships and Referral Program (click for details)

Work as Freelancer or Full-Time Employee (click for details)

Hire an Intern

---

Flexible Class Options

Week End Classes For Professionals  SAT | SUN
Corporate Group Trainings Available
Online Classes – Live Virtual Class (L.V.C), Online Training

Related Courses