Training By Himanshu

Category: Google Tools Training

  • Learn Google Calendar: Master Time Management & Scheduling – Free Skillshare Course

    Managing appointments, meetings, and daily tasks can sometimes feel overwhelming. But with Google Calendar, you can turn chaos into clarity. Whether you’re a student, a professional, or simply someone who wants to stay organized, Google Calendar offers powerful features to streamline your time management.

    If you’re looking to master Google Calendar, my complete online course is the perfect place to start. Available on Skillshare (with a free 30-day trial), this course will guide you step-by-step to make the most out of this essential productivity tool.

    👉 Enroll here: Learn Google Calendar on Skillshare

    Why Learn Google Calendar?

    Google Calendar is more than just a scheduling app. It’s a productivity powerhouse that helps you:

    • Keep track of important appointments.
    • Organize work and personal events.
    • Manage multiple calendars in one place.
    • Stay on top of tasks and reminders.
    • Collaborate seamlessly with colleagues or family.

    Once you learn how to use its features effectively, you’ll save time, reduce stress, and boost productivity.

    What You’ll Learn in This Course

    This course is designed for beginners and intermediate users who want to become confident with Google Calendar. You’ll learn everything from basics to advanced settings, including:

    ModuleWhat You’ll Learn
    Creating EventsSchedule meetings, birthdays, and daily tasks with ease.
    Editing Event DetailsAdd descriptions, locations, and video conferencing links.
    Recurring EventsSave time by automating weekly or monthly schedules.
    Reminders & TasksNever forget an important deadline again.
    Creating New CalendarsManage personal, work, and shared calendars separately.
    Important SettingsExplore time zones, notifications, and default event options.
    Adding & Sharing CalendarsCollaborate with teams or family by sharing access.
    Import & Export OptionsAdd calendars via URL or import/export schedules easily.

    Who Is This Course For?

    • Students who want to manage classes, assignments, and deadlines.
    • Working professionals looking to organize meetings and projects.
    • Freelancers balancing multiple clients and tasks.
    • Anyone who struggles with staying organized and punctual.

    If you want to move from “always forgetting” to “always prepared”, this course is for you.

    Why Take This Course on Skillshare?

    • Free 30-Day Trial: You can access the full course at no cost.
    • Structured Learning: Lessons are simple, clear, and beginner-friendly.
    • Hands-On Guidance: Each step is demonstrated so you can follow along.
    • Lifetime Skills: Once you learn Google Calendar, you’ll use it daily.

    👉 Start learning today with free trial access

    Conclusion

    Time management is the foundation of success in today’s fast-paced world. By learning Google Calendar, you’ll not only organize your schedule but also take control of your productivity.

    Don’t let disorganization hold you back. Join the course today and unlock the full potential of Google Calendar!

    👉 Click here to enroll for free with a 30-day trial: Google Calendar Skillshare Course

  • Mastering QUERY Function in Google Sheets: Complete Guide with Examples & Interview Questions

    The QUERY function in Google Sheets is one of the most powerful and versatile tools available. It allows you to perform SQL-like data manipulations—filtering, sorting, aggregating, and grouping—on your spreadsheet data.

    📌 QUERY Function Syntax

    QUERY(data, query, [headers])

    🔹 Arguments:

    1. data: The range of cells that you want to query.
    2. query: A string written in a pseudo-SQL format.
    3. headers (optional): The number of header rows at the top of your data (default is 1).

    🧠 Why Use QUERY?

    It combines the power of multiple functions like FILTER, SORT, VLOOKUP, SUMIF, UNIQUE, and even PIVOT TABLES—all in one.

    ✅ Basic Examples

    Assume we have the following data in A1:D6:

    NameAgeDepartmentSalary
    John25Sales30000
    Alice30HR35000
    Bob24Sales28000
    Carol29Marketing40000
    Dave35HR38000

    🔹 1. Select All Rows

    =QUERY(A1:D6, "SELECT *", 1)

    🔸 Returns the full table.

    🔹 2. Select Specific Columns

    =QUERY(A1:D6, "SELECT A, C", 1)

    🔸 Returns only Name and Department columns.

    🔹 3. Filtering Rows (WHERE Clause)

    =QUERY(A1:D6, "SELECT A, D WHERE C = 'Sales'", 1)

    🔸 Shows Name and Salary of employees in Sales department.

    🔹 4. Using Comparison Operators

    =QUERY(A1:D6, "SELECT A, B WHERE D > 30000", 1)

    🔸 Returns Name and Age of employees earning more than 30,000.

    🔹 5. Sorting (ORDER BY)

    =QUERY(A1:D6, "SELECT A, D ORDER BY D DESC", 1)

    🔸 Returns Name and Salary sorted by Salary in descending order.

    🔹 6. Grouping and Aggregating (GROUP BY)

    =QUERY(A1:D6, "SELECT C, AVG(D) GROUP BY C", 1)

    🔸 Calculates average salary per department.

    🔹 7. Labeling Columns

    =QUERY(A1:D6, "SELECT C, AVG(D) GROUP BY C LABEL AVG(D) 'Average Salary'", 1)

    🔸 Adds a custom label to the aggregated column.

    🔹 8. Limit Results

    =QUERY(A1:D6, "SELECT * LIMIT 3", 1)

    🔸 Returns only the first 3 rows.

    🔹 9. Combining WHERE and ORDER BY

    =QUERY(A1:D6, "SELECT A, D WHERE D > 30000 ORDER BY D DESC", 1)

    🔸 Filters employees with salary > 30,000 and sorts them in descending order.

    🔹 10. Dynamic Query with Cell Reference

    =QUERY(A1:D6, "SELECT A, D WHERE D > "&E1, 1)

    🔸 Assuming cell E1 has the value 30000, this will filter dynamically.

    ⚠️ Notes:

    • Text values in queries must be enclosed in single quotes (‘ ‘).
    • Numbers and cell references can be added directly.
    • QUERY is case-insensitive by default.

    🎯 Common Use Cases

    • Creating dashboards
    • Creating dynamic reports
    • Filtering datasets based on dropdown selections
    • Summarizing large data tables
    • Converting flat data into summarized views like pivot tables

    📘 Real-Life Example:

    Imagine a school with student records:

    StudentClassSubjectMarks
    Rahul10Math85
    Sneha10Science90
    Aman11Math78
    Priya10Math92

    To find average marks in each subject for class 10:

    =QUERY(A1:D5, "SELECT C, AVG(D) WHERE B = 10 GROUP BY C", 1)

    🔸 Returns Math and Science with their average marks for class 10 students.

    💼 Top 10 Interview Questions on Google Sheets QUERY Function

    1. Q: What is the QUERY function in Google Sheets?
      A: It allows you to use SQL-like queries to filter, sort, group, and summarize data.
    2. Q: How do you filter records using a text value in QUERY?
      A: Use WHERE column = 'Text', e.g., WHERE C = 'Sales'.
    3. Q: How can you sort data using QUERY?
      A: Use ORDER BY clause: ORDER BY column [ASC|DESC].
    4. Q: What does GROUP BY do in QUERY?
      A: It aggregates values (e.g., SUM, AVG) based on unique groups in a column.
    5. Q: How do you rename column headers in the QUERY result?
      A: Use the LABEL clause: LABEL AVG(D) 'Average Salary'.
    6. Q: What’s the difference between SELECT * and SELECT A, B?
      A: SELECT * selects all columns; A, B selects only specific columns.
    7. Q: How can you use a cell reference in a QUERY?
      A: Concatenate it: "SELECT A WHERE B > "&E1
    8. Q: Can you use OR and AND in QUERY filters?
      A: Yes. Example: WHERE B > 25 AND C = 'HR'
    9. Q: What happens if you omit the headers parameter?
      A: QUERY assumes the first row is the header by default (1).
    10. Q: How is QUERY different from FILTER function?
      A: FILTER is simpler and only filters data. QUERY is more powerful with sorting, aggregation, grouping, and SQL-like operations.

    Featured products

  • Google Excel Sheet: The Ultimate Guide to Google Sheets for Productivity, Collaboration & Smart Work

    If you’ve ever searched for a way to manage data, collaborate on reports, or simplify your work processes online, you may have come across the term “Google Excel Sheet.” While not an official product name, it’s how many people refer to Google Sheets—Google’s free, cloud-based alternative to Microsoft Excel.

    In this guide, we’ll explore what a Google Excel Sheet really is, why it matters, how it compares to Excel, and how to leverage its cloud and AI-powered features for maximum productivity. Plus, if you’re serious about mastering Google Workspace tools, we’ll show you where to start.

    🔍 What Is a Google Excel Sheet?

    A Google Excel Sheet is a commonly used term for Google Sheets—a cloud-based spreadsheet application that’s part of Google Workspace (formerly G Suite).

    Like Excel, it lets you:

    • Enter, organize, and analyze data
    • Use formulas, functions, charts, and pivot tables
    • Automate calculations and reports

    But unlike traditional Excel, a Google Excel Sheet offers:

    • Real-time collaboration
    • AI-powered features
    • Access from any device
    • No software installation needed

    In short, a Google Excel Sheet gives you the best of Excel, with the added superpowers of the cloud.

    💡 Why Google Excel Sheet Is Gaining Popularity

    Whether you’re a student, entrepreneur, marketer, or team leader, switching to a Google Excel Sheet can transform the way you manage data and collaborate online.

    ✅ 1. Work from Anywhere

    Google Excel Sheets are stored in the cloud, so you can open, edit, and share them from any device, anywhere — all you need is an internet connection.

    ✅ 2. Real-Time Collaboration

    Work on the same sheet with your team at the same time. Add comments, chat live, assign tasks — no need to email files back and forth.

    ✅ 3. Automatic Saving

    No more worrying about hitting “Save.” Every change is saved instantly in your Google Excel Sheet.

    ✅ 4. Powerful Excel-Like Functions

    Use everything from SUM, VLOOKUP, IF, and ARRAYFORMULA to pivot tables, filters, and charts — all within a browser.

    🤖 AI-Powered Features in Google Excel Sheets

    One of the biggest advantages of a Google Excel Sheet over traditional spreadsheets is its built-in AI and machine learning capabilities:

    ⚡ Smart Fill

    Google detects data patterns and suggests auto-completions — like auto-filling full names from first and last columns.

    💡 Explore Tool

    Type in natural questions like “Total sales by region” and let AI generate instant insights, charts, and pivot tables.

    🔁 Smart Cleanup

    Clean messy data with AI-assisted suggestions — like removing duplicates or fixing inconsistent formats.

    🔄 Integration with BigQuery

    Analyze massive datasets right from your Google Excel Sheet using Connected Sheets — no coding required.

    🔗 Integration & Automation

    Google Excel Sheets integrate natively with:

    • Google Forms – Collect responses directly into a sheet
    • Gmail – Share sheets with custom access controls
    • Google Calendar – Build schedules, logs, and availability trackers
    • Google Docs/Slides – Embed live data into reports and presentations

    Plus, use Google Apps Script or tools like Zapier to automate tasks — such as sending reminders, generating reports, or syncing with CRMs.

    🎯 Who Should Learn Google Excel Sheets?

    A Google Excel Sheet is ideal for:

    • Professionals needing collaborative reports, budgets, or project tracking
    • Freelancers & startups managing clients, leads, and schedules
    • Teachers & students tracking attendance, grades, or assignments
    • Marketers & analysts creating dashboards and campaign reports

    🎓 Want to Master Google Excel Sheets & More?

    If you’re serious about improving productivity and getting the most out of Google Workspace, we’ve created a complete, step-by-step course just for you:

    👉 Master Google Workspace (G Suite): Complete Guide for Productivity & Collaboration

    What You’ll Learn:

    ✅ Google Excel Sheets: Formulas, charts, pivot tables, data cleanup, and AI features
    ✅ Google Docs, Slides, Calendar, Gmail & Meet
    ✅ Automation with Forms, Keep, Tasks, and Drive
    ✅ Real-world tips, tricks & use cases
    ✅ 14.5 hours of video, 7 downloads, lifetime access & certificate

    📌 Final Thoughts

    The Google Excel Sheet is more than just an online spreadsheet — it’s a cloud-native, AI-enhanced productivity tool that’s redefining how teams and individuals work with data.

    If you’ve used Excel, switching to Google Excel Sheets gives you added benefits like:

    • Instant collaboration
    • Built-in automation
    • Easy sharing and access from anywhere

    Whether you’re managing finances, projects, schedules, or surveys, Google Excel Sheets offer the smart, scalable, and secure solution you need.

    👉 Ready to master it all?

    Join our course and start using Google Excel Sheets and other Workspace tools like a pro.
    🎓 Enroll Now

    Top rated products

  • How to Count or Sum Cells by Color in Google Sheets (with Script)

    🎨 How to Count or Sum Cells Based on Cell Color in Google Sheets

    Google Sheets doesn’t have built-in functions like COUNTBYCOLOR or SUMBYCOLOR, but you can achieve this using Google Apps Script or manual helper columns if using conditional formatting.

    ✅ Method 1: Using Google Apps Script (Best for Manual Cell Colors)

    You can create custom functions to count or sum cells by fill color.

    🔧 Step-by-Step:

    1. Click Extensions > Apps Script
    2. Delete any existing code and paste the following:
    javascriptCopyEdit// Function to count cells with a specific background color
function countColoredCells(range, color) {
  var sheet = SpreadsheetApp.getActiveSpreadsheet();
  var range = sheet.getRange(range);
  var bgColors = range.getBackgrounds();
  var count = 0;
  
  for (var i = 0; i < bgColors.length; i++) {
    for (var j = 0; j < bgColors[i].length; j++) {
      if (bgColors[i][j] == color) {
        count++;
      }
    }
  }
  return count;
}

// Function to sum cells with a specific background color
function sumColoredCells(range, color) {
  var sheet = SpreadsheetApp.getActiveSpreadsheet();
  var range = sheet.getRange(range);
  var bgColors = range.getBackgrounds();
  var values = range.getValues();
  var sum = 0;
  
  for (var i = 0; i < bgColors.length; i++) {
    for (var j = 0; j < bgColors[i].length; j++) {
      if (bgColors[i][j] == color) {
        sum += parseFloat(values[i][j]) || 0;
      }
    }
  }
  return sum;
}
    1. Click the 💾 Save icon and give your project a name.
    2. Back in your sheet, use:
    excelCopyEdit=countColoredCells("A1:A10", "#ffff00")
=sumColoredCells("A1:A10", "#ffff00")

    Replace "A1:A10" with your range and "#ffff00" with the actual color hex code (like Yellow).

    📝 You can find the hex code by:

    • Selecting a colored cell
    • Right-click → View more cell actions > Get cell color hex code

    ⚠️ Notes:

    • This script works only for manually colored cells.
    • It does not detect conditional formatting colors.

    ✅ Bonus: If Using Conditional Formatting

    If color is based on a condition (e.g., values > 100), don’t rely on the color — instead use the same logic:

    excelCopyEdit=COUNTIF(A1:A10, ">100")
=SUMIF(A1:A10, ">100")

    Always use the logic that drives the color rather than the color itself.

    🚀 Want to Learn All These Pro Techniques?

    Everything from custom formulas, conditional formatting, scripts, and data tools is covered in my premium Google Sheets course!

    🔗 📘 Enroll Now – Unlock the Power of Google Sheets

    💥 Limited-Time Offer: ₹1,299 → ₹449 Only!

    🎯 Course Features:

    • 29 detailed video lessons
    • 3h 46m of content from beginner to advanced
    • Covers formulas, charts, pivot tables, automation, Apps Script, and more
    • Ideal for students, professionals, and business users

    💡 Take control of your spreadsheets and become a data ninja with this course!

    Top rated products

  • How to Create a Dependent Drop Down List in Google Sheets (Dynamic & Easy)

    🔄 How to Create a Dependent Drop Down List in Google Sheets

    A dependent drop-down list means that the options in the second dropdown depend on the selection made in the first. This is especially useful for things like selecting a category and sub-category, country and state, etc.

    ✅ Step-by-Step Example:

    Let’s say you want this setup:

    📋 Source Data:

    CategorySub-Items
    FruitsApple, Banana, Mango
    VegetablesCarrot, Spinach
    BeveragesTea, Coffee

    🔧 Step 1: Set Up Your Lists

    Use a new sheet (e.g., named "Lists"):

    makefileCopyEditA1: Fruits       B1: Apple    C1: Banana   D1: Mango  
A2: Vegetables   B2: Carrot   C2: Spinach
A3: Beverages    B3: Tea      C3: Coffee

    🔧 Step 2: Name Each Range

    1. Select B1:D1 (Apple, Banana, Mango).
    2. Go to Data > Named ranges, name it Fruits.
    3. Do the same for:
      • B2:C2 → Name it Vegetables
      • B3:C3 → Name it Beverages

    📝 Important: The named range must match exactly with the text in your first dropdown.

    🔧 Step 3: Create the First Dropdown (Main Category)

    1. In your main sheet, click on cell A1.
    2. Go to Data > Data validation.
    3. Under Criteria, choose List of items and type:
    CopyEditFruits,Vegetables,Beverages

    Click Done.

    🔧 Step 4: Create the Dependent Dropdown

    1. Click on cell B1 (where the dependent dropdown will go).
    2. Go to Data > Data validation.
    3. Under Criteria, choose Custom formula is.
    4. Enter:
    excelCopyEdit=INDIRECT(A1)

    ✅ This tells Google Sheets: “Get the named range based on the value in A1.”

    Click Done.

    🔍 How It Works:

    • When you select “Fruits” in A1 → B1 will show Apple, Banana, Mango
    • If you select “Vegetables”, you’ll see Carrot, Spinach in B1

    🚀 Want to Learn Google Sheets Like a Pro?

    This kind of powerful, dynamic logic is covered step-by-step in our Google Sheets course!

    🔗 ✅ Enroll Now – Unlock the Power of Google Sheets

    💥 Special Price: ₹1,299 → Just ₹449!

    🎯 What You’ll Learn:

    • ✅ 29 step-by-step video tutorials
    • 🕒 3 hours 46 minutes of practical content
    • 🔎 From formulas & charts to scripts, automation, and dashboards
    • 👨‍🎓 Perfect for beginners and professionals alike

    📈 Start automating, organizing, and analyzing data like an expert.

    Top rated products

  • How to Delete All Rows with Specific Text in Google Sheets (Manual + Script)

    🗑️ How to Delete All Rows Containing Specific Text in a Column in Google Sheets

    When working with large datasets, you may need to delete all rows where a certain word or value appears in a specific column — like removing all rows where column B says "Cancelled".

    You can do this manually, with filters, or use Google Apps Script to automate it.

    ✅ Method 1: Use Filter to Delete Rows Containing Specific Text (Manual)

    Steps:

    1. Select your data range.
    2. Go to Data > Create a filter.
    3. Click the filter icon in the target column (e.g., Column B).
    4. Uncheck all and select only the value you want to delete (e.g., "Cancelled").
    5. Select the filtered rows by clicking the row numbers.
    6. Right-click > Delete selected rows.
    7. Turn off the filter.

    ✅ Best for: Small to medium datasets.

    ✅ Method 2: Use Google Apps Script (Automatic & Reusable)

    If you want a repeatable way to delete rows based on a value, use this simple script.

    🔧 Script to Delete Rows Containing Specific Text:

    1. Click Extensions > Apps Script.
    2. Paste this code:
    javascriptCopyEditfunction deleteRowsWithText() {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  const columnToCheck = 2; // Column B (use 1 for A, 2 for B, etc.)
  const textToDelete = "Cancelled";
  const data = sheet.getDataRange().getValues();
  
  for (let i = data.length - 1; i >= 0; i--) {
    if (data[i][columnToCheck - 1] === textToDelete) {
      sheet.deleteRow(i + 1);
    }
  }
}
    1. Save and click ▶️ Run.

    ✅ Customizable: Change columnToCheck and textToDelete as needed.

    ✅ Why loop backward? It prevents row shifting issues while deleting.

    🚀 Want to Learn All These Google Sheets Hacks (and More)?

    If you’re enjoying these powerful techniques, you’ll love our full Google Sheets training!

    🔗 💡 Unlock the Power of Google Sheets – Enroll Now

    🎯 Limited-Time Offer: ₹1,299 → ₹449 only!

    📘 Course Highlights:

    • 🎥 29 video lessons
    • 🕒 3 hours 46 minutes total duration
    • 🔍 Beginner to advanced: formulas, pivot tables, scripts, data analysis
    • 🧑‍🏫 Learn through real-world examples and practical demos

    Whether you’re managing business reports, automating tasks, or cleaning data — this course helps you master Google Sheets efficiently.

    Top rated products

  • How To Combine Multiple Columns Into One Single Column In Google Sheets?

    Whether you’re organizing survey data, merging name fields, or stacking column values into a single list — Google Sheets offers multiple ways to combine multiple columns into one.

    ✅ Scenario:

    Suppose you have this data:

    ABC
    TomAliceJohn
    SamRaviRiya

    You want to create a single vertical list like:

    nginxCopyEditTom  
Sam  
Alice  
Ravi  
John  
Riya

    🔹 Method 1: Use the FLATTEN Function (Quick & Easy)

    Formula:

    excelCopyEdit=FLATTEN(A1:C2)

    Result:

    It combines all the values from the range A1:C2 into a single column.

    📝 Note: FLATTEN() reads the data row-wise, moving left to right, top to bottom.

    🔹 Method 2: Using ARRAYFORMULA with SPLIT and JOIN

    If your data is dynamic or you want to control delimiters, use this formula:

    excelCopyEdit=TRANSPOSE(SPLIT(JOIN(",", A1:C2), ","))

    ✅ What It Does:

    • JOIN(",", A1:C2) → Converts your 2D data into one comma-separated string.
    • SPLIT(..., ",") → Splits it back into individual elements.
    • TRANSPOSE(...) → Converts the horizontal array into a vertical column.

    🔹 Method 3: Stack Columns Vertically Using FILTER

    If you want to stack entire columns (e.g., A, B, C) but remove blank cells, use:

    excelCopyEdit=FILTER(A:A, A:A <> "")

    Repeat for B and C, or stack together like:

    excelCopyEdit={FILTER(A:A, A:A <> ""); FILTER(B:B, B:B <> ""); FILTER(C:C, C:C <> "")}

    This ensures that blank cells are skipped and data appears vertically.

    🚀 Ready to Master Google Sheets from Basics to Brilliance?

    🎓 All of these tricks and tons more are explained with step-by-step videos in my bestselling Google Sheets course:

    🔗 🔓 Unlock the Power of Google Sheets – Enroll Now!

    💥 Limited-Time Offer: ₹1,299 → ₹449 only!

    📘 Course Highlights:

    • 29 expertly crafted videos
    • 3 hours and 46 minutes of quality content
    • Covers basic to advanced topics (formulas, pivot tables, automation, scripts)
    • Ideal for students, professionals, freelancers, business users

    💡 Learn how to organize, automate, and analyze your data like a pro.

    Top rated products

  • How to Combine Date and Time in Google Sheets (No Add-ons Needed)

    📅⏰ How To Combine Date And Time Columns Into One Column In Google Sheets?

    When working with separate date and time columns, you may need to merge them into a single datetime format. Here’s how to do it effortlessly:

    ✅ Example Setup

    A (Date)B (Time)
    26/06/202510:30 AM

    You want column C to show:
    26/06/2025 10:30 AM

    ✅ Method 1: Use a Simple Formula

    In cell C2, use this formula:

    excelCopyEdit=A2 + B2

    What it does:
    In Google Sheets, dates and times are stored as numbers. Adding a date and time simply combines them.

    ✅ Step-by-Step Instructions

    1. Ensure that column A has dates (26/06/2025) and column B has times (10:30 AM).
    2. In column C, enter: =A2+B2
    3. Format column C:
      • Click Format > Number > Custom date and time
      • Use the format: dd/mm/yyyy hh:mm AM/PM or any style you prefer.

    You now have a complete datetime column.

    ⚠️ Common Issues & Fixes

    • Wrong format? → Apply a custom datetime format from the Format menu.
    • #VALUE! error? → Ensure both columns contain valid date and time values.

    🚀 Want to Master Google Sheets from Start to Finish?

    📣 Learn this and hundreds of other practical skills in my complete Google Sheets course:

    🔗 Enroll Now – Unlock the Power of Google Sheets

    💰 Special Offer: ₹1,299 ₹449 (Limited Time Only!)

    🎓 What’s Inside:

    • ✅ 29 value-packed videos
    • ⏱ 3 hours 46 minutes of step-by-step tutorials
    • 📊 Covers formulas, pivot tables, data analysis, automation, and more!
    • 🧠 Easy-to-follow explanations + real-world examples

    👨‍🏫 Whether you’re a student, working professional, or entrepreneur — this course will empower your productivity and data skills.

    Related Products

  • How to Get a List of Sheet Names in Google Sheets (Step-by-Step)

    Google Sheets doesn’t offer a built-in formula to list sheet names directly like Excel VBA might. However, you can achieve it easily using Google Apps Script. Here’s how:

    ✅ Step 1: Open Google Apps Script

    1. Open your Google Sheets file.
    2. Click on Extensions > Apps Script.

    ✅ Step 2: Paste This Script

    In the script editor, paste the following code:

    javascriptCopyEditfunction listSheetNames() {
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const sheets = ss.getSheets();
  const sheetNames = sheets.map(sheet => [sheet.getName()]);
  
  const outputSheetName = "Sheet List";
  let outputSheet = ss.getSheetByName(outputSheetName);
  
  if (!outputSheet) {
    outputSheet = ss.insertSheet(outputSheetName);
  } else {
    outputSheet.clear();  // Clear old data
  }
  
  outputSheet.getRange(1, 1, sheetNames.length, 1).setValues(sheetNames);
}

    ✅ Step 3: Save and Run

    1. Click the 💾 Save icon and name your project.
    2. Click the ▶️ Run button.
    3. If prompted, authorize the script to access your spreadsheet.

    ✅ What Happens Next?

    • A new sheet called “Sheet List” will be created (or updated).
    • It will display the names of all sheets in your file—automatically.

    🚀 Want to Master Google Sheets from A to Z?

    🎯 Whether you’re just starting out or looking to boost your spreadsheet superpowers, our premium Google Sheets course is your gateway to mastery.

    🔗 Enroll Now – Unlock the Power of Google Sheets

    🔥 Offer: ₹1,299 ₹449 (Limited-Time Deal)

    What You’ll Get:

    • 📹 29 videos totaling 3 hours 46 minutes
    • ✅ From beginner basics to advanced data analysis
    • 📈 Learn formulas, pivot tables, data validation, automation & more
    • 💼 Ideal for students, professionals, entrepreneurs

    💡 With real-world examples and practical exercises, you’ll quickly become confident in handling data, automating tasks, and making smarter decisions.

    Related Products

  • How to Generate QR Codes in Excel and Google Sheets (Step-by-Step Guide)

    You can generate QR codes in Excel (Microsoft 365) and Google Sheets easily using built-in features or free add-ons. Here’s a detailed guide for both platforms:

    ✅ In Microsoft Excel (Microsoft 365)

    🔸 Method 1: Using Excel Add-in – “QR4Office”

    📌 Steps:

    1. Open Excel and go to the Insert tab.
    2. Click on “Get Add-ins” (or Office Add-ins).
    3. Search for “QR4Office” and click Add.
    4. Once added, go to Insert → My Add-ins → QR4Office.
    5. A QR code generator pane will appear on the right.

    🎯 To Generate a QR Code:

    • Enter the text or URL you want to convert.
    • Adjust size, color, and error correction level.
    • Click Insert — the QR code will appear in your sheet as an image.

    🔸 Method 2: Using a Web API (Google Chart API)

    You can generate QR codes dynamically using a formula with an image from an online API.

    📌 Steps:

    1. Use this formula in a cell:
    =IMAGE("https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl=" & A2)

    ✅ Replace A2 with the cell that has the text or link you want to turn into a QR code.

    📝 chs=150x150: Size of the QR code
    📝 chl=: The data encoded in the QR code

    Note: Excel’s IMAGE function is available in Microsoft 365 versions only.

    ✅ In Google Sheets

    📌 Steps:

    1. In a cell, enter this formula:
    =IMAGE("https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl=" & A2)

    ✅ Replace A2 with the reference cell containing the text or URL you want in the QR code.

    The QR code will appear in the cell as an image.

    🧠 Extra Tips:

    • You can drag the formula down to generate QR codes for an entire list.
    • You can use ENCODEURL(A2) inside the formula to safely encode special characters:
    =IMAGE("https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl=" & ENCODEURL(A2))

    Top rated products

  • Mastering Gmail’s Vacation Responder: Auto-Replies Made Easy

    Mastering Gmail’s Vacation Responder: Auto-Replies Made Easy

    ✅ What is Vacation Responder in Gmail?

    The Vacation Responder is an automatic email reply feature in Gmail. When you’re away from work or unavailable (e.g., on vacation, sick leave, or in training), Gmail can automatically send a pre-written response to incoming emails.

    🔧 How to Set Up Vacation Responder in Gmail

    1. Open Gmail.
    2. Click on the gear icon (⚙️) → See all settings.
    3. In the General tab, scroll down to Vacation responder.
    4. Fill in the following:
      • First day and (optional) Last day.
      • Subject (e.g., “Out of Office: Back on June 10”).
      • Message body.
      • Choose if you want the message sent only to people in your contacts.
    5. Click Save Changes.

    🔍 How It Works:

    • Once enabled, Gmail will send one auto-response per sender during the active period.
    • If someone emails you again during the same period, they won’t receive the message again unless:
      • It’s been 4+ days since the last auto-reply.
      • They use a different email address.

    🧠 Real-Life Examples

    ✅ Example 1: Corporate Employee on Vacation

    Scenario: Priya is on annual leave from May 28 to June 7.

    Auto-reply settings:

    • Subject: Out of Office: Back on June 10
    • Message: Hi, Thank you for your email. I’m currently out of the office and will return on Monday, June 10. I will not be checking emails during this time. For urgent matters, please contact my colleague Rahul at rahul@example.com. Best regards, Priya Sharma

    ✅ Example 2: Freelancer or Trainer Away for a Workshop

    Scenario: Himanshu (you) are attending a 5-day Excel workshop and can’t respond immediately.

    Auto-reply settings:

    • Subject: Currently Unavailable: Excel Workshop Week
    • Message: Hello, I’m currently conducting an Excel training workshop and may have limited access to email from May 28 to June 1. I’ll respond to your message as soon as possible after this period. For urgent inquiries regarding course enrollment or scheduling, please contact +91-XXXX-XXXXXX. Thank you for your patience. Regards, Himanshu

    ✅ Example 3: School Teacher on Summer Break

    Scenario: A school teacher, Mr. Patel, is off for summer holidays.

    Auto-reply settings:

    • Subject: Out for Summer Break
    • Message: Dear Parent/Student, Thank you for reaching out. I am currently on summer break and will return to school duties on July 15. I will not be regularly checking my email during this time. Wishing you a relaxing summer! Mr. Patel

    📝 Best Practices

    • Keep it professional and concise.
    • Mention return date clearly.
    • Provide alternative contacts for urgent matters.
    • Don’t share sensitive personal details.
    • Use a friendly and polite tone.

    🔒 Privacy Tip

    Enable “Send responses only to people in my Contacts” if you don’t want to auto-respond to unknown or spammy emails.

    🎯 Summary Table

    FeaturePurposeReal-Life Use Case
    Vacation ResponderAuto-reply to emails during absenceVacation, leave, training, holiday breaks
    Custom datesDefine start and end of auto-responseFlexible scheduling
    Custom messageInform sender about your availabilityMaintain communication etiquette

    Out of Office? Let Gmail Talk for You

    Click to Install Free Training App

    On sale products