📊Excel and Google Sheets AI Tutorials.

YAROCELIS.eth - Tech Trends
Coinmonks
5 min readMay 8, 2024

--

Get in Front of 50k Tech Leaders: Grow With Us

Halfway through the week and we’re not slowing down! We decode the secrets to simplifying those complex Excel and Google Sheets formulas — complete with stellar cheat sheets. Plus, catch up on the latest tech drama as the U.S. cuts off chip supplies to Huawei and explores how new tools are cracking down on AI-generated image authenticity. Buckle up; it’s a tech-packed ride!

Please help us by filling out this form to serve you better.

  • 📰 News and Trends.
  • Excel and Google Sheets AI Tutorials.
  • U.S. Cuts Off Chip Supply to Huawei.
  • Publications I am currently reading and recommending
  • 🧰 AI Tools (Phone Calls)
  • New Tool Tackles Image Authenticity

📰 AI News and Trends

  • Wayve, an A.I. Start-Up for Autonomous Driving, Raises $1 Billion (NYT)
  • OpenAI says it’s building a tool to let content creators ‘opt-out’ of AI training (TC)
  • A New Diplomatic Strategy Emerges as Artificial Intelligence Grows (NYT)
  • Microsoft Creates Top Secret Generative AI Service for US Spies (Yahoo)
  • Deepfakes of your dead loved ones are a booming Chinese business (MIT)

🌐 Other Tech news

  • Apple unveils new iPad Pro with ‘outrageously powerful’ AI-powered chip (CNN) and Everything announced at Apple’s Let Loose iPad event (Engadget)
  • TikTok Sues to Block U.S. Ban (WSJ)
  • Threads is testing cross-posting from Instagram globally (TC)
  • Amazon Set to Debut Remote-Enabled Shoppable Ads As It Readies Inaugural Upfront (HReporter)
  • Kamala Harris Pledges $100M To Boost Small Auto Manufacturers In Detroit (Benzinga)

Excel and Google Sheets AI Tutorials

With around 250–300 million active Google Sheets users worldwide and even more using Excel, managing these tools efficiently is essential. To address this need, I’ve explored several AI apps that simplify formula creation and enhance creativity with spreadsheets. These innovations not only save time but also streamline workflow. As we dive into this tutorial, I invite you to share your thoughts and questions. Let’s get started!

GPT Excel

This app has a free trial, but not free forever. It allows you to prompt for any Excel, Google Sheets, or Airtable Formula and create SQL, MySQL, Oracle DB, and other queries and rational expressions in Regex. Please take a look at the video below for a quick walkthrough.

Numerous

Numerous is an outstanding app that serves as an extension to your browser. After installing it, as demonstrated in the video below, you can activate it by navigating to Extensions and selecting it. This tool allows you to:

  • Interact directly with your tables.
  • Create comments on specific texts.
  • Generate and elucidate formulas, and
  • Perform tasks such as classifying, formatting, and extracting data, among various other functions.

Sheety AI

Sheety AI is another tool that I have been playing with, where you can prompt via text for any Google Sheet Formula, very easy to use, just describe your problem in the left box and get a formula to solve it in the right box. Catered for Google Sheets users only.

ChatGPT

Similarly, you can prompt ChatGPT to give you Excel, Google Sheets, SQL, and any formulas or queries, but it will take an extra step as you have to prompt it correctly, copy the output, and paste it into the correct cell (or table) and adjust as needed to obtain the correct output.

Our Favorite is Numerous AI as its embedded in our google sheets and makes it easy to use, by saving time jumping from screen to screen of app to app, but all of the above work well. Let us know which one do you like the most.

Check this Amazing Excel Cheat Sheet and this Excel Formulas Bible.

Explore all our tutorials at the link below. Subscribe to gain access to our comprehensive suite of tools, course listings, and a one-on-one session.

Give me all AI Tutorials

Access All of our AI Tools (500+), AI Tutorials, and a List of 70+ Courses for Free when you become a Member.

U.S. Cuts Off Chip Supply to Huawei

The Biden administration has recently revoked export licenses for Intel and Qualcomm, preventing them from supplying semiconductors to Huawei. This decision is part of broader efforts to apply pressure on the Chinese tech industry, citing national security concerns.

These revoked licenses specifically impact the supply of chips for Huawei’s laptops and mobile phones. This action reflects ongoing tensions between the U.S. and China over technology and cybersecurity, with the U.S. maintaining strict controls despite Huawei’s attempts to overcome these barriers, as evidenced by their development of advanced chips and new products like the Mate 60 Pro smartphone and MateBook X Pro laptop. The move has been described by experts as an indication of the U.S.’s firm stance on national security threats posed by Chinese technology. This decision has also been framed as economic bullying by the Chinese embassy, which criticized the U.S. for undermining the global economic and trading order.

Share

📰 Publications I am currently reading and recommending:

  • Smart Solopreneur — A newsletter designed for experienced online solopreneurs, like strategists, copywriters, freelancers, and consultants.
  • Growth Forum — Learn how to build a repeatable sales process creating a pipeline full of qualified deals.

🧰 AI Tools

Phone Calls

  • Vibrato — AI assistant that can make phone calls.
  • Gnbly — Personal AI assistant. He can help you book restaurant reservations, call service providers, and more.
  • AI Phone — AI-powered phone call app with live translation and transcription.
  • Belva — Making phone calls for you, with AI.
  • GPT-Trainer — A must-try AI Agent Platform*
  • Text Blaze — Automate Anything With AI & Use it Anywhere.*

Download over 500+ Tools free here. To be featured, Fill out This Form.

Paid Members get a Free Consulting Session with us — Book it

New Tool Tackles Image Authenticity

OpenAI has developed a new detection tool that allegedly is capable of identifying 98% of images generated by its DALL-E 3 system under typical conditions. However, the tool’s effectiveness decreases when images are modified, such as through cropping or hue changes.

This reflects broader challenges in the AI industry in tracking and identifying AI-generated content. Amidst growing concerns over the proliferation of fake AI-created images, particularly in influencing public opinion during elections, OpenAI’s efforts are part of a larger initiative to enhance digital content authenticity. The company has also joined a Microsoft and Adobe-led industry group and, along with Microsoft, launched a $2 million fund to support AI education. Despite its high accuracy, the tool sometimes mistakenly flags non-AI images as AI-generated and struggles with images from other AI sources.

--

--

YAROCELIS.eth - Tech Trends
Coinmonks

⛓Web3 | 🪐AI | Trends🙏 | Subscribe to our AI, and Tech trends letter. YaroCELIS.org