Course Includes:
- Price: ₹ 10000.00
- Instrutor: Yes
- Duration: 3 Months
- Language: English
- Certificate: Yes
Cursor Insert India
Google Sheets (Google Excel)
Google Sheets (Google Excel)
₹ 10000.00
Course Description
1. Introduction to Google Sheets
- What is Google Sheets?
- Google Sheets vs. Microsoft Excel
- Navigating the Google Sheets Interface
- Creating, Opening & Saving Spreadsheets
- Sharing & Collaborating in Google Sheets
2. Basic Spreadsheet Operations
- Entering & Formatting Data
- Cell Referencing (Relative, Absolute, Mixed)
- Data Validation & Drop-down Lists
- Conditional Formatting & Custom Rules
- Sorting & Filtering Data
3. Formulas & Functions (Basic to Advanced)
3.1 Basic Functions
- SUM, AVERAGE, MIN, MAX
- COUNT, COUNTA, COUNTIF, COUNTIFS
3.2 Logical & Lookup Functions
- IF, AND, OR, NOT
- VLOOKUP, HLOOKUP, XLOOKUP
- INDEX-MATCH & ARRAYFORMULA
3.3 Text Functions
- CONCATENATE, TEXTJOIN
- LEFT, RIGHT, MID
- LEN, TRIM, PROPER, UPPER, LOWER
3.4 Date & Time Functions
- TODAY, NOW
- YEAR, MONTH, DAY, HOUR, MINUTE, SECOND
- DATE, TIME, TEXT for Date Formatting
3.5 Financial & Statistical Functions
- ROUND, CEILING, FLOOR
- RANK, MEDIAN, MODE
- PV, FV, PMT for Financial Calculations
4. Data Analysis & Visualization
- Creating & Customizing Charts (Bar, Pie, Line, Scatter)
- Pivot Tables & Pivot Charts
- Data Consolidation & Summarization
- Using Slicers in Pivot Tables
5. Advanced Google Sheets Features
- Named Ranges & Data Tables
- Goal Seek & Solver for Data Analysis
- Importing Data from External Sources (CSV, Google Drive)
- Linking Data Across Multiple Sheets
6. Automation with Google Sheets
6.1 Google Apps Script (Basics)
- Introduction to Google Apps Script
- Writing Simple Macros & Scripts
- Automating Repetitive Tasks
6.2 Data Connections & Integrations
- ImportRange, ImportData, ImportXML, ImportHTML
- Connecting Google Sheets with Google Forms, Google Docs, and Google Calendar
7. Collaboration & Security in Google Sheets
- Real-time Editing & Commenting
- Version History & Restoring Data
- Protecting Sheets & Cell Ranges
- Managing Access & Permissions
8. Advanced Data Processing & Dashboards
- Creating Interactive Dashboards
- Using Google Data Studio for Visualization
- Embedding Sheets in Websites & Reports
9. Real-Time Projects & Case Studies
- Business Financial Analysis
- Sales & Inventory Management
- Employee Attendance & Payroll Sheets
- Budgeting & Expense Tracking
Course Syllabus
1. Introduction to Google Sheets
2. Basic Spreadsheet Operations
3. Formulas & Functions (Basic to Advanced)
4. Data Analysis & Visualization
5. Advanced Google Sheets Features
6. Automation with Google Sheets
7. Collaboration & Security in Google Sheets
8. Advanced Data Processing & Dashboards
9. Real-Time Projects & Case Studies
Duration: 3 Months Months
Course Creator: Cursor Admin
Advertisements
Admission Query
Related Courses
6 Months
3 Months
6 Months
6 Months
6 Months
6 Months
