Learn to Master Google Sheets

Learn to Master Google Sheets

This course is designed  for intermediate users of Google Spreadsheets who want to learn more about the features, functions and formulas available in Google sheets. Google sheets has applications in all fields and learning Google sheets is almost essential today. Google sheets offers many advantages over other spreadsheet programs such as Microsoft Excel and Open Office. These advantages are critical for small businesses and cannot be ignored. Therefore for most businesses and companies, Google spreadsheets offers a superior solution for their spreadsheet tasks and data analysis problems.

Objective of this Course:

To bring your skills to proficient level where you will be able to use google sheets like a competent professional.

This course has been divided into three sections,  and if you know the basics, you should skip the first section to save some time.

S E C T I O N - I: Beginner

1. Tour of the User interface of Google Sheets
2. Two Important Settings to avoid weird date formatting issues
3. Named Ranges
4. 8 Important Date Functions
5. Data Validation & Dropdown lists
6. 5 Google sheet features you should know
7. Basic Functions & IF statement

S E C T I O N - II Intermediate

1. RANK, AND and Nesting of logical operators
2. Creating Charts in Google Sheets
3. Using Filters with dates
4. Filters & Filter Views
5. Team Collaboration methods available in Google Sheets

S E C T I O N - III Advanced

1. Conditional Summing & Counting
2. Pivot Tables
3. Methods of Inserting Images
4. Understanding the most powerful QUERY function

Class Activities:

1. Download the lecture/exercise files 
2. Follow the instruction given at the end of video lectures

F U T U R E     P L A N S: 

1. More activities will be added.
2. More videos will be added based on student’s feedback. Feel free to put your question in the appropriate space and I will answer if possible.

• Class Introduction
• Google Sheet User Interface A Complete Tour for Beginners
• Two Important Settings to Avoid Weird Date Formatting Issues
• 8 Important Date Functions
• Named Ranges
• Data Validation and Drop Down List in Google Sheets
• Google Sheet Features You Must Know
• Basic Function and IF statement
• Rank AND and Nesting If and AND
• Creating Charts in Google Sheets
• Using Filters with dates
• Filters and Filter Views in Google Sheets
• Team Collaboration Methods Available in Google Sheets
• Conditional Summing and Counting
• Pivot Tables Explained
• Methods of Inserting Images from Google drive into Google Sheets
• Understanding The Most Powerful Query Function in Google Sheets
• Index and Match Functions and their Combination