- Computer Science (19)
- Business Management (2)
- Arts & Design (1)
- Personal Development (1)
- Data Science (3)
- Marketing (3)
- Business & Finance (1)
- Graphics Designer (38)
- Financial Markets (1)
- Fundamental Analysis (1)
- Technical Analysis (1)
- Commodity and Currency (1)
- Excel and MS Office (12)
- Financial Planning (1)
- Banking and Credit (1)
- Web Development (3)
- Mobile Development (1)
- Programming Language (1)
- Database Design & Development (1)
- No-Code Development (1)
- Entrepreneurship (1)
- Communication (1)
- Management (1)
- Sales (1)
- Business Strategy (1)
- Operations (1)
- Business Law (1)
- Business Analytics & Intelligence (1)
- Human Resources (1)
- Industry (1)
- E-Commerce (1)
- Media (1)
- Accounting & Bookkeeping (10)
- Money Management (1)
- IT Certificates (1)
- Network & Security (1)
- Hardware (2)
- Operating Systems & Server (1)
- Microsoft (1)
- Google (5)
- SAP (9)
Cursor Insert India
Google Sheets (Google Excel)
Google Sheets (Google Excel)
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
Advertisements
Admission Query
6 Months
3 Months
6 Months
6 Months
6 Months
6 Months
