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.