Connect with us

Jobs & Careers

A Beginner’s Guide to Mastering Gemini + Google Sheets

Published

on


A Beginner's Guide to Mastering Gemini + Google SheetsImage by Author | Ideogram

 

We are living in an exciting era, as generative AI has emerged as a tool that significantly enhances our work. Since the launch of products such as ChatGPT, the advent of large language models (LLMs) has fundamentally changed how we live and work.

Google, as a company, surely would not pass up the chance to develop its own LLM products, as demonstrated by the Gemini model. Moreover, Google already possesses many useful products for business, such as Google Sheets. Google has made a fantastic move by allowing Gemini to be integrated directly into Google Sheets.

As Google Sheets is used by many businesses, it’ll be helpful to understand how we can use Gemini AI inside it. In this article, we’ll go through the implementation of Gemini with Google Sheets.

Curious? Let’s dive in!
 

Google Gemini in Google Sheets

 
According to the official announcement by Google, the current Spreadsheet AI (Gemini in Google Sheets) is already available for the public, but only via the Google Workspace subscription. To try it out, you can explore their pricing plans and utilize the available Free Trial.

Before we try out Google Gemini in Google Sheets, we need to make it available too, as by default, the feature isn’t automatically on and requires us to have a Google Workspace Admin account. Navigate to the admin dashboard and enable Gemini for Google Workspace by turning on the Alpha Features within the Generative AI tabs.
 
A Beginner's Guide to Mastering Gemini + Google Sheets
 
Once the features are enabled, try to create a new Google Sheet using your Google Workspace account. After opening a new file, you’ll see the **Gemini icon**, similar to the image below.
 
A Beginner's Guide to Mastering Gemini + Google Sheets
 
This is your Gemini Assistant, where you can ask anything and direct Gemini to perform certain actions in Google Sheets. If you’re not sure what you can do, you can always ask Gemini “What can Gemini do” in the prompt.

For example, we can ask Google Gemini to create a new table and insert it into our sheets, similar to the image below.
 
A Beginner's Guide to Mastering Gemini + Google Sheets
 
By referencing existing files or tables in Google Sheets, we can ask the Gemini model for further analysis or suggestions. For example, we could ask Gemini for insights from our data and suggestions for charts we could develop, as shown in the image below.
 
A Beginner's Guide to Mastering Gemini + Google Sheets
 
Essentially, you can ask Gemini anything, and the model will suggest or provide actions appropriate for your workflow.

Additionally, you can work directly at the Google Sheet cell level using Gemini, which is facilitated by the =AI formula. The formula currently allows for text generation, summarization, and classification.

The =AI formula takes two parameters: the prompt (or instruction) and an optional reference cell range. Let’s start by generating a new label using the =AI formula. For example, we could try to assign a document name based on the data we have.

=AI("Generate a document name suitable for this row", A2:F2)

 
Then, press the “Generate and Insert” button to execute the formula.
 
A Beginner's Guide to Mastering Gemini + Google Sheets
 
Once the =AI formula is executed, you can drag it to the cells below the first to apply it to all available data. For example, we can generate document names in five different cells, as shown below.
 
A Beginner's Guide to Mastering Gemini + Google Sheets
 
You could even refer to the table as a whole and use the following formula to summarize the dataset.

=AI("Summarize the data in one line", Table1)

 
The result is text data similar to the output below.

The table outlines project management approaches, detailing their characteristics, advantages, disadvantages, suitable applications, and risk levels.

 
This concludes the basic introduction to accessing and implementing the Gemini model in Google Sheets. You can explore further and see how the model could accelerate your data analysis.
 

Conclusion

 
Google Gemini has become a staple product that assists people with their work by generating text based on a natural language prompt. Currently, Google has integrated the Gemini model into Google Sheets through Google Workspace, which we can access after subscribing to the plan.

In this article, we learned how to use Google Gemini directly in Google Sheets, both through the Gemini sidebar and by using the =AI formula.

I hope this has helped!
 
 

Cornellius Yudha Wijaya is a data science assistant manager and data writer. While working full-time at Allianz Indonesia, he loves to share Python and data tips via social media and writing media. Cornellius writes on a variety of AI and machine learning topics.



Source link

Continue Reading
Click to comment

Leave a Reply

Your email address will not be published. Required fields are marked *

Jobs & Careers

AI to Track Facial Expressions to Detect PTSD Symptoms in Children

Published

on


A research team from the University of South Florida (USF) has developed an AI system that can identify post-traumatic stress disorder (PTSD) in children.

The project addresses a longstanding clinical dilemma: diagnosing PTSD in children who may not have the emotional vocabulary, cognitive development or comfort to articulate their distress. Traditional methods such as subjective interviews and self-reported questionnaires often fall short. This is where AI steps in.

“Even when they weren’t saying much, you could see what they were going through on their faces,” Alison Salloum, professor at the USF School of Social Work, reportedly said. Her observations during trauma interviews laid the foundation for collaboration with Shaun Canavan, an expert in facial analysis at USF’s Bellini College of Artificial Intelligence, Cybersecurity, and Computing.

The study introduces a privacy-first, context-aware classification model that analyses subtle facial muscle movements. However, instead of using raw footage, the system extracts non-identifiable metrics such as eye gaze, mouth curvature, and head position, ensuring ethical boundaries are respected when working with vulnerable populations. 

“We don’t use raw video. We completely get rid of subject identification and only keep data about facial movement,” Canavan reportedly emphasised. The AI also accounts for conversational context, whether a child is speaking to a parent or a therapist, which significantly influences emotional expressivity.

Across 18 therapy sessions, with over 100 minutes of footage per child and approximately 185,000 frames each, the AI identified consistent facial expression patterns in children diagnosed with PTSD. Notably, children were more expressive with clinicians than with parents; a finding that aligns with psychological literature suggesting shame or emotional avoidance often inhibits open communication at home.

While still in its early stages, the tool is not being pitched as a replacement for therapists. Instead, it’s designed as a clinical augmentation, a second set of ‘digital’ eyes that can pick up on emotional signals even trained professionals might miss in real time.

“Data like this is incredibly rare for AI systems,” Canavan added. “That’s what makes this so promising. We now have an ethically sound, objective way to support mental health assessments.”

If validated on a larger scale, the system could transform mental health diagnostics for children—especially for pre-verbal or very young patients—by turning non-verbal cues into actionable insights. 



Source link

Continue Reading

Jobs & Careers

Canva Partners With NCERT to Launch AI-Powered Teacher Training

Published

on


Canva has signed a memorandum of understanding (MoU) with the National Council of Educational Research and Training (NCERT) to launch free teacher training and certification programs hosted on the education ministry’s DIKSHA platform. 

The initiative aims to enhance digital literacy, creativity, and AI proficiency among educators across India, in alignment with the objectives of the National Education Policy (NEP) 2020.

As part of the agreement, Canva will offer Indian teachers free access to its education platform and provide learning materials tailored for visual and collaborative instruction. NCERT will ensure that the course content aligns with the national curriculum and is made regionally accessible. Available in multiple Indian languages, the course will also be broadcast via PM e-Vidya DTH channels to extend its reach beyond internet-enabled classrooms.

The certification program includes training on using Canva’s design tools to create engaging lesson plans, infographics, and presentations. Teachers will also learn to co-create content with students and apply AI tools to improve classroom outcomes. Upon completion, participants will receive a joint certificate from NCERT and Canva.

“This partnership is a powerful step toward equipping educators with practical digital skills that not only save time but spark imagination in every classroom,” Jason Wilmot, head of education at Canva, said in a press statement.

Chandrika Deb, country manager for India at Canva stated, “By delivering this program free of cost, in multiple languages, and through a trusted national platform like NCERT, we are not only advancing digital fluency and creative confidence in classrooms across the country, but also deepening Canva’s long-term commitment to India, which plays a pivotal role in our vision to democratize design and creativity at scale.”

Moreover, the company shared some interesting figures. Canva has seen significant global momentum, with over 100 million students and teachers using its platform. In 2024, over 1 billion designs were created, many powered by Canva’s AI tools like Dream Lab, which enables teachers to generate custom visuals instantly. Teacher usage of AI tools has increased by 50% over the past year, with student engagement rising by 107%.

We may see further developments in this partnership as the training program for teachers progresses over time.



Source link

Continue Reading

Jobs & Careers

Capgemini to Acquire WNS for $3.3 Billion with Focus on Agentic AI

Published

on


Capgemini has announced a definitive agreement to acquire WNS, a mid-sized Indian IT firm, for $3.3 billion in cash. This marks a significant step towards establishing a global leadership position in agentic AI.

The deal, unanimously approved by the boards of both companies, values WNS at $76.50 per share—a premium of 28% over the 90-day average and 17% above the July 3 closing price.

The acquisition is expected to immediately boost Capgemini’s revenue growth and operating margin, with normalised EPS accretion of 4% by 2026, increasing to 7% post-synergies in 2027.

“Enterprises are rapidly adopting generative AI and agentic AI to transform their operations end-to-end. Business process services (BPS) will be the showcase for agentic AI,” Aiman Ezzat, CEO of Capgemini, said. 

“Capgemini’s acquisition of WNS will provide the group with the scale and vertical sector expertise to capture that rapidly emerging strategic opportunity created by the paradigm shift from traditional BPS to agentic AI-powered intelligent operations.”

Pending regulatory approvals, the transaction is expected to close by the end of 2025.

WNS’ integration is expected to strengthen Capgemini’s presence in the US market while unlocking immediate cross-selling opportunities through its combined offerings and clientele. 

WNS, which reported $1.27 billion in revenue for FY25 with an 18.7% operating margin, has consistently delivered a revenue growth of around 9% over the past three fiscal years.

“As a recognised leader in the digital BPS space, we see the next wave of transformation being driven by intelligent, domain-centric operations that unlock strategic value for our clients,” Keshav R Murugesh, CEO of WNS, said. “Organisations that have already digitised are now seeking to reimagine their operating models by embedding AI at the core—shifting from automation to autonomy.”

The companies expect to drive additional revenue synergies between €100 million and €140 million, with cost synergies of up to €70 million annually by the end of 2027. 

“WNS and Capgemini share a bold, future-focused vision for Intelligent Operations. I’m confident that Capgemini is the ideal partner at the right time in WNS’ journey,” Timothy L Main, chairman of WNS’ board of directors, said.

Capgemini, already a major player with over €900 million in GenAI bookings in 2024 and strategic partnerships with Microsoft, Google, AWS, Mistral AI, and NVIDIA, aims to solidify its position as a transformation partner for businesses looking to embed agentic AI at scale.



Source link

Continue Reading

Trending