by admin | Jul 30, 2026 | Research & Productivity
You export a report, open it, and four thousand rows stare back at you. The answer your manager or your supervisor wants is somewhere in that file. Finding it used to mean an afternoon of pivot tables and half remembered formulas.
This is one area where AI has become properly useful. You can hand a spreadsheet to a chatbot, ask plain questions about it, and get back a summary, a chart, and the formula you were trying to remember. Below is how to analyze data with AI using free tools, which questions actually work, and where these tools still get things wrong.
What it means to analyze data with AI
Two different things share the same name, and mixing them up causes a lot of confusion.
- Chat tools that read a file you upload. You give ChatGPT, Claude, or Gemini a CSV or Excel file and ask questions about it in normal language. This route is free to try.
- AI built into the spreadsheet itself. Copilot in Excel and Gemini in Google Sheets sit inside the app and can edit your sheet directly. Both normally need a paid plan.
If you are starting out, begin with the first one. It costs nothing and it teaches you what these tools are good at before you pay for anything.
The free way: upload your spreadsheet and ask
The workflow is short. Tidy the file, upload it, then ask a specific question.
- Tidy the sheet first. One header row, one record per row, clear column names, no merged cells or decorative blank rows. OpenAI says the same thing in its own guidance: structured data with clear column names and one record per row gives the best results.
- Save it as CSV or XLSX. Delete the columns you do not need before you upload.
- Upload and say what you want to learn. Not “analyze this”, but “which three products lost the most sales between March and June, and by how much”.
If you have already tried our guide on how to chat with a PDF using AI, this will feel familiar. Same idea, different file type.
Which free tools handle spreadsheets
ChatGPT can inspect an uploaded file, answer questions about it, and build tables and charts. Free accounts are limited to three file uploads per day, and a CSV or spreadsheet can be roughly 50MB at most, as set out in the official data analysis help article.
Claude takes a slightly different approach. Its analysis tool writes and runs real code to do the calculation instead of predicting an answer as text. For anything involving actual arithmetic, that distinction matters more than it sounds.
Gemini works the same way in the main Gemini app, and it connects neatly to Google Drive if your files already live there.
The built-in option inside Excel and Google Sheets
If your workplace or university already pays for one of these, the AI is sitting in the app and most people never open it.
Copilot in Excel lives on the Home tab of the ribbon. Microsoft lists four main jobs for it: importing data, highlighting and sorting and filtering, generating formulas and explaining how they work, and surfacing insights as charts, PivotTables, summaries, trends, or outliers. It needs an eligible Microsoft 365 subscription, and your data has to be formatted as a table or supported range before Copilot can read it.
Gemini in Google Sheets opens from the Ask Gemini button in the top right. It can create tables and formulas, generate analysis and charts, and carry out edits you describe in words, including conditional formatting, pivot tables, sorting, filtering, and multi step cleanups. Two practical notes from Google: it needs an eligible Workspace or Google AI plan, and it works best on native Sheets files, so an uploaded .xlsx should be converted with File and then Save as Google Sheets. If a cell shows a formula error, hovering over it and clicking Fix asks Gemini to explain what went wrong.
Five questions worth asking about any dataset
Vague prompts get vague summaries. These five are a reliable starting set, and they work in every tool above.
- Describe this dataset. How many rows are there, what does each column mean, and what data is missing?
- What are the top five and bottom five rows by [column], and what is the gap between them?
- Group this by month and tell me whether the trend is rising or falling.
- Which rows look like duplicates, typing errors, or outliers?
- Write the Excel formula that does this, and explain each part of it.
Important tip: ask for the working, not just the answer. Adding “show me the steps and the columns you used” turns a black box into something you can actually check, and it is the single habit that catches most mistakes.
If your prompts keep returning generic replies, our guide on how to write better AI prompts covers the structure in more detail.
Always check the numbers before you use them
This is the part people skip. A chatbot answering in plain text can produce a confident figure that is simply wrong, which is the same problem behind AI hallucinations. Tools that run code are safer, but code can still read the wrong column or quietly ignore blank rows.
Three checks take about a minute between them. Recalculate one figure by hand. Confirm the row count the AI reports matches the row count in your file. Ask which columns it used, and read that answer properly.
From my own work on websites and analytics data, the failure is almost never the arithmetic. It is the tool confidently answering a slightly different question than the one I asked, and it looks right until someone checks.
Keep private data out of the chat
Spreadsheets are usually the most sensitive files an organisation owns. Customer lists, student records, salaries, and health data should not be dropped into a personal chatbot account just because it is quicker.
A safer habit: delete the name, email, and ID columns before you upload, or build a small anonymised sample that keeps the shape of the data without the identities. Our guide on how to use AI safely and protect your privacy walks through the account settings that matter here.
Common Questions
Do I still need to learn Excel? Yes, and probably more than before. AI writes the formula, but you are the one who has to notice when the result looks wrong. Understanding what a VLOOKUP or a pivot table does is what makes you useful next to the tool rather than dependent on it.
Which free tool is best for spreadsheets? For calculation heavy work, a tool that runs code is the safer bet. For quick summaries and charts, any of the three will do. Try the same file in two of them and compare the answers, which is also a decent accuracy test.
Can AI make charts from my data? Yes. All the tools mentioned can produce charts, and both Copilot in Excel and Gemini in Sheets can insert one directly into the sheet. Google notes that a chart Gemini inserts sits on a new tab with its own copy of the data, so it does not update when the original figures change.
Final takeaway
You do not need a data science course to get value here. Tidy one spreadsheet, upload it to a free tool, ask it the five questions above, then verify one number by hand. That single round trip will teach you more about what AI can and cannot do with data than any amount of reading.
Start small, keep the sensitive columns out, and treat every figure it gives you as a draft until you have checked it.
by admin | Jul 29, 2026 | Future Jobs
Imagine a colleague who never sleeps, never asks for a coffee break, and quietly finishes a twelve step task while you are stuck in a meeting. That is close to what an AI agent does, and it is already running inside software many of us open every morning. So what happens to your job when your tools stop waiting to be told what to do?
Working with AI agents is turning into ordinary office work rather than a prediction about 2030. Microsoft’s 2026 Work Trend Index, published in May 2026, found that the number of active agents inside Microsoft 365 grew 15 times in a single year, and 18 times inside large enterprises. This post explains what that shift means for your role, in plain English, and what you can do about it this month.
What working with AI agents actually means
A chatbot answers. An agent acts.
You give a chatbot a question and it gives you text back. You give an agent a goal, and it plans the steps, uses the tools it has access to, and comes back with a finished result. Instead of asking for an email draft, you might ask an agent to read last quarter’s support tickets, group the repeated complaints, write a short summary, and save the file in a shared folder.
If the idea still feels fuzzy, our beginner guide on what AI agents are covers the basics before you go further here.
Your job moves from doing the work to directing it
This is the real change, and it is easy to miss.
In that same Microsoft research, based on a survey of 20,000 workers who use AI across ten countries, 66 percent said AI has let them spend more time on high value work, and 58 percent said they are producing work they could not have produced a year ago.
The interesting part is where the human sits in that picture. 86 percent of those AI users said they treat AI output as a starting point rather than a final answer, and that they stay responsible for the thinking. The work does not vanish. It moves up a level, from producing the first draft to deciding what good looks like and standing behind the result.
The two skills that matter most when agents do the execution
When those same workers were asked which human skills become more important as AI takes on more work, two answers rose to the top: quality control of AI output at 50 percent, and critical thinking at 46 percent.
There is a second finding worth sitting with. The most advanced AI users in the study were noticeably more likely to say they deliberately do some work without AI to keep their own skills sharp, 43 percent compared with 30 percent of everyone else. They are not avoiding the tools. They are protecting the judgment that makes them useful with the tools.
Practical tip: before you hand a task to an agent, write one sentence describing what a good result looks like. If you cannot write that sentence, you are not ready to review the output, and reviewing is now a real part of your job.
New roles are appearing, not only disappearing
The anxiety around this is fair, and we have looked at the evidence on both sides in our posts on whether AI will take your job and the harder question of AI and entry level jobs.
Movement runs both ways. LinkedIn’s 2026 Labor Market Report found that employers created at least 1.3 million AI related job opportunities over the past two years, in roles such as data annotators, AI engineers and forward deployed engineers. Most of those titles did not exist five years ago. The same report is careful about blame too, pointing at economic conditions and interest rates, rather than AI, as the main reason hiring has been slow.
Inside ordinary teams you can also see quieter new responsibilities forming. Someone has to review what the agents produced. Someone has to decide when a workflow gets updated. Someone has to notice when the quality slowly drifts. None of that sounds glamorous, which is exactly why it is worth claiming early.
How to start working with AI agents this month
You do not need permission from a company transformation programme to begin.
- Pick one repetitive task you do every week, something with a clear input and a clear output.
- Write the goal, the source material, and the quality standard in one short brief.
- Run it through an agent feature you already have access to at work, then compare the result with how you would have done it yourself.
- Keep a note of what it got wrong. That list becomes your review checklist next time.
- Share what worked with one colleague. Teams that talk openly about their AI mistakes improve much faster than teams that hide them.
If you want to know which abilities are worth building alongside this, our guide to the AI skills that will matter most for future jobs is a useful next step.
The part the product demos usually skip
From my own experience running websites and digital projects, this is where things get uncomfortable. An agent acts with real access. It can read files, send messages and touch systems on your behalf, so a careless setup is a security problem and not only a productivity one.
Two habits help. Give an agent the narrowest access it needs for the task rather than everything you can see. And keep company data out of personal AI accounts, which is the quiet risk we covered in our post on shadow AI at work.
Common Questions
Do I need technical skills for working with AI agents?
No. Most workplace agents are set up through plain language instructions. The skills that matter are describing a task clearly and judging whether the result is good enough to use.
Will agents replace whole jobs or only tasks?
Current evidence points mostly at tasks and workflows rather than whole jobs, although roles built almost entirely from routine steps are the most exposed. The World Economic Forum Future of Jobs Report 2025 estimates that 39 percent of workers’ core skills will change by 2030.
What if my employer has not given me any AI tools?
Start with free consumer tools on your own non sensitive work, and never paste confidential company material into a personal account.
Final takeaway
Working with AI agents is less about learning another piece of software and more about changing where you add value. Let the agent handle the steps. Keep the judgment, the standards and the responsibility for yourself. Pick one task this week, brief it properly, and review the result honestly. That single habit will do more for your career than any tool comparison.
by admin | Jul 27, 2026 | AI Tools
Most of us carry a capable AI assistant in our pocket and almost never open it. The phone gets used for messages, maps, photos and a bit of scrolling, while the AI features sit in the background waiting for someone to tap them.
That is a shame, because the phone is where AI is genuinely handy. You are usually standing in a shop, sitting on a bus, or halfway through a task when you need a quick answer. This guide walks through how to use AI on your phone for ordinary daily jobs, in plain language, with no coding and no paid plan needed to get started.
How to use AI on your phone: start with what is already installed
You probably do not need to install anything to begin.
On Android, the Gemini app is Google assistant duty these days. Google explains in its official Gemini mobile app help pages that you can type, talk, use an image or take a photo to start a request, and that Gemini can pull quick information from Gmail and Drive once you connect them. You can also bring up a Gemini overlay on top of whatever app you are using and ask about what is on the screen. One thing to know before switching: if you opt in, Gemini replaces Google Assistant as the main assistant on that phone.
On iPhone, the built in option is Apple Intelligence. Apple lists Writing Tools for summarising and proofreading, Live Translation inside Messages, FaceTime and Phone, Genmoji for custom emoji, and Visual Intelligence for asking about whatever the camera is pointed at. There is a catch worth checking first. Apple says these features need an iPhone 16 or later, or an iPhone 15 Pro or 15 Pro Max. Older iPhones do not get them.
If your phone is older or does not support any of this, no problem. A free chat app fills the gap completely.
Add one AI app, not ten
It is tempting to install five AI apps over a weekend and then use none of them. Pick one, keep it on your home screen, and let it become a habit.
ChatGPT has official apps for iPhone and Android, and Gemini and Perplexity both have solid mobile versions. If you are not sure which assistant suits the way you think, our comparison of ChatGPT vs Gemini vs Claude breaks the differences down without the jargon.
From my own experience running websites and online projects, the phone assistant earns its place on the days I am away from a laptop. Getting a long email boiled down to three lines while waiting for a bus is worth more than any clever feature I would only use once.
Nine everyday jobs your phone AI actually handles well
- Summarise a long email, message thread or article before deciding whether to read it properly
- Rewrite a message that came out too blunt, or shorten a reply that rambled
- Translate a menu, a road sign, a form or an incoming chat message
- Turn a messy voice note into a clean set of notes or a to do list
- Explain an unfamiliar term in a letter, bill or form so you know what question to ask next
- Build a shopping list or a few meal ideas from whatever is already in the kitchen
- Draft a caption, product description or reply for social media
- Add up a photographed receipt or work out a rough split between friends
- Compare two products before you commit to buying one
None of that is dramatic on its own. Added up across a week, it is a real amount of time back.
Point the camera instead of typing
The camera is the part almost everyone underuses. Instead of describing a problem in words, show it.
Both companies support this directly. Gemini lets you take a photo or pick an existing image as the starting point of a question. Apple Visual Intelligence lets you ask about what is in front of you and then act on it, such as creating a calendar event from a poster or translating a menu on the spot.
Where this pays off in real life: a washing machine error code, a plant that is clearly unhappy, an unfamiliar ingredient, a timetable in another language, or a handwritten page you want typed up.
Talk to it when your hands are busy
Voice is the other feature that changes how often you reach for AI at all. OpenAI documents three ChatGPT voice modes, ranging from a real time conversation to a simpler turn by turn version that transcribes your speech before answering. Gemini has its own hands free conversation mode on Android.
Walking, cooking, sitting in a waiting room, or carrying shopping are all moments when typing is not going to happen but a question still needs an answer.
A few things to keep away from your phone AI
Phone assistants are convenient, and convenience is exactly what makes people paste in things they should not.
Important tip: never paste passwords, bank details, ID numbers or another person private information into an AI app. Assume anything you type could be reviewed, and check the app data settings before you trust it with anything sensitive.
Working around cybersecurity has made me cautious here. The risk is rarely a dramatic hack. It is usually someone dropping a full client document into a random app because it was faster that morning. If you want the longer version, our guide on how to use AI safely and protect your privacy is worth ten minutes.
Check permissions too. Most AI apps do not need your contacts or your location for the things you will actually ask them.
Common Questions
Do I have to pay to use AI on my phone?
No. The main assistants all have free tiers that cover normal daily use. Paid plans mainly buy higher limits and faster or newer models, which most casual users do not need on a phone.
Is the built in assistant better than a separate app?
The built in one wins on convenience because it can see your screen and reach your own apps. A separate chat app usually wins on depth for writing, explaining and longer reasoning. Many people end up using both without thinking about it.
Does AI on my phone work without internet?
Mostly not. Apple describes on device processing for parts of Apple Intelligence, and some small features run locally, but the genuinely useful answers still need a connection.
Will it drain my battery?
Short questions barely register. Long voice conversations, video input and image generation are the heavier tasks, so those are the ones to watch on a low battery day.
Can I trust the answers for schoolwork or my job?
Treat every answer as a first draft, not a fact. Phone assistants get things wrong with total confidence, so check anything that matters against a real source before you send it, submit it or act on it.
Final takeaway
You do not need to become an AI expert to get value out of the phone already in your hand. Open the assistant that is sitting there, use it for three or four small jobs this week, and let the habit build from that. For ideas beyond the phone, our roundup of useful AI tools for daily work and study is a good next stop, and if the basics still feel fuzzy, start with our simple explanation of what AI actually is.
by admin | Jul 26, 2026 | AI Guides
You have probably seen “AI,” “machine learning,” and “deep learning” used as if they all mean the same thing. They are related, but they are not identical, and the difference is easier to understand than most articles make it sound.
This quick AI vs machine learning vs deep learning guide gives you a simple way to keep them straight, with everyday examples, so the next time you read a headline or a product description you know exactly what it means.
AI vs machine learning vs deep learning: the simple version
Picture three circles, one inside the other. Artificial intelligence is the big outer circle. Machine learning sits inside it. Deep learning is a smaller circle inside machine learning. So every deep learning system is machine learning, and every machine learning system is a type of AI, but not the other way around.
As IBM puts it, AI is the overarching system, machine learning is a subset of AI, and deep learning is a subset of machine learning. That single picture clears up most of the confusion. Now let us look at each one.
What is artificial intelligence?
Artificial intelligence is the broadest term. It describes any machine that does things we associate with human intelligence, like recognising a face, understanding speech, making a decision, or translating a language.
AI is the goal, not one specific method. Some AI is very simple, following fixed rules a person wrote. Some is far more advanced. The AI you meet every day, like a chatbot or a photo tagger, is what researchers call narrow AI: it is good at one task. The idea of a machine that can do almost anything a human can, often called artificial general intelligence, does not exist yet. If you want the fuller picture, our guide on what AI is walks through it in plain English.
What is machine learning?
Machine learning is a subset of AI, and it is where most of today’s useful AI actually lives. Instead of a programmer writing every rule by hand, a machine learning system learns patterns from data and uses them to make predictions.
A good example is the way Netflix suggests shows or Amazon recommends products. Nobody wrote a rule that says “this person likes cooking videos.” The system learned it from what you watched and clicked before.
Classic machine learning still needs a fair bit of human help. A person often has to decide which features in the data matter before the system can learn from them. Our explainer on what machine learning is goes deeper, and Google’s free Machine Learning Crash Course is a good hands-on next step.
What is deep learning?
Deep learning is a subset of machine learning. It uses neural networks, which are layers of connected “nodes” loosely inspired by the brain. When a neural network has many layers stacked up, we call it deep, and that depth is where the name comes from.
The big advantage is that deep learning can work directly with messy, unstructured data like images, audio, and text, and it figures out the important features on its own instead of waiting for a human to point them out. That is why it powers things like voice assistants, self-driving car vision, and the large language models behind tools like ChatGPT and Gemini. You can read more in our guide on how neural networks work.
Where do generative AI and LLMs fit?
This is a common follow-up question. Generative AI, and the large language models that power chatbots, are built on deep learning. So a tool like ChatGPT is deep learning, which is machine learning, which is a form of AI. All three labels are correct at the same time, they just describe different levels of zoom.
Which term should you actually use?
For everyday conversation, “AI” is a safe general word. Reach for “machine learning” when you specifically mean a system that learns from data, and “deep learning” when that system is built on multi-layer neural networks.
Tip: When a product says it uses “AI,” it almost always means machine learning, and often deep learning, working quietly in the background. Knowing that helps you see past the marketing and ask the better question: what data did it learn from?
From my own experience building websites and working with online tools, nearly every “AI feature” I touch, from spam filters to search to writing helpers, is really machine learning or deep learning under a friendlier label. The words on the box matter less than understanding that these systems learn from data, and that the data can be biased or wrong.
Common Questions
Is deep learning the same as AI?
No. Deep learning is one specific type of AI. All deep learning is AI, but plenty of AI is not deep learning.
Do I need to know the difference to use AI tools?
Not to use them, no. But knowing the difference helps you understand what a tool can and cannot do, and why it sometimes gets things wrong.
Is generative AI machine learning?
Yes. Generative AI is built on deep learning, which is a branch of machine learning, which is a branch of AI.
Final takeaway
The easiest way to remember it: AI is the big idea, machine learning is how most modern AI learns from data, and deep learning is a powerful type of machine learning built on neural networks. Keep those three circles in mind and the buzzwords stop being confusing. Next time you see “AI” in a headline, you will know what is really going on underneath.
by admin | Jul 25, 2026 | Free Courses
Want to learn AI without paying for an expensive course, and actually have something to show for it at the end? That is exactly what IBM SkillsBuild is built for.
IBM SkillsBuild is a free learning platform from IBM where anyone can pick up AI skills, practice on real topics, and earn a digital credential to add to a resume or LinkedIn profile. No fees, no credit card, and no computer science degree required. Here is what it offers, which courses suit beginners, and how to get started.
What is IBM SkillsBuild?
IBM SkillsBuild is IBM’s free online learning program. It is open to adult learners, university students, and high school students, and the courses are self-paced, so you can fit them around work or study. Beyond AI, you will also find courses on cybersecurity, data and analytics, cloud computing, software development, and everyday workplace skills. Everything runs in your browser, and many courses come in several languages, including English, Spanish, French, German, and Portuguese.
The part that makes it stand out for most people: you can earn a digital credential, a shareable badge that proves you finished the course.
Is IBM SkillsBuild really free?
Yes. IBM describes the platform as free online learning, and you only need to sign up with an email address to begin. There is no paywall waiting halfway through, and the digital credentials do not cost extra either. IBM runs SkillsBuild as part of its wider effort to help people build tech and career skills, so free access is the whole point, not a trial that expires.
Best IBM SkillsBuild AI courses for beginners
If you are new to AI, a couple of courses are a great place to start.
- Getting Started with Generative AI is a foundational course (roughly three to ten hours) that explains how machines create text and images, walks through the ethics of generative AI using IBM’s AI Risk Atlas, and introduces large language models with practical examples. You earn a digital credential when you finish.
- Explore Emerging Tech is another foundational course that gives you a plain introduction to five technologies shaping the future: data, artificial intelligence, cloud computing, cybersecurity, and quantum computing. It also comes with a digital credential.
If you only have a spare half hour, there are short activities under an hour, like one on how AI tools are changing the way software gets built, that let you dip a toe in before committing to something longer.
From my own experience building websites and working around cybersecurity, the fastest way to learn a tool is to use it on something real. IBM SkillsBuild leans that way too, with simulations and worked examples rather than slide after slide, which helps the ideas actually stick.
What you will learn
The beginner AI track covers the ideas that keep coming up once you start using AI tools: what generative AI is, how large language models work, and why AI ethics (things like fairness, transparency, and bias) matter. These are the same concepts behind tools you probably already use, like ChatGPT or Gemini. If you want a plain-English primer before you enroll, our guide on what generative AI is pairs well with the course.
Because none of the beginner courses expect you to write code, this is a comfortable starting point if you have been putting AI off. If that sounds like you, our guide on how to learn AI without coding is worth reading alongside it.
How digital credentials help you
A digital credential is more than a certificate you file away and forget. IBM issues it as a verifiable badge you can add to your LinkedIn profile, your resume, or an email signature, and anyone can click it to confirm it is real.
Tip: When you finish a course, add the badge to your LinkedIn profile right away. A verifiable credential from a name like IBM stands out far more than a line that simply says “familiar with AI.”
Keep it in perspective, though. A credential opens a conversation, but what you can do with the skills is what carries it. Treat these courses as a structured way to learn, and build a small project or two on the side to show you can apply what you studied.
How to get started
- Go to the IBM SkillsBuild website and create a free account with your email.
- Open the learning catalog and filter by Artificial Intelligence, then by the Foundational level to find beginner courses.
- Start with a short activity or Getting Started with Generative AI, and work at your own pace.
- Complete the course and claim your digital credential.
You can browse the full IBM SkillsBuild learning catalog and read more about its digital credentials on the official site. If you want to line up more free options, our roundups of free AI certifications online and how to learn AI for free list plenty of trusted places to keep going.
Common Questions
Is IBM SkillsBuild free for everyone?
Yes. The courses and the digital credentials are free, and you sign up with just an email. It is open to adult learners, university students, and high school students.
Do you get a real certificate from IBM SkillsBuild?
You earn a digital credential, which is a shareable badge issued by IBM. It is not a university degree, but it is verifiable and genuinely useful on a resume or LinkedIn profile.
Do you need coding skills or a degree to start?
No. The beginner (foundational) AI courses are written for people with no coding background and no prior AI knowledge.
Final takeaway
IBM SkillsBuild is one of the easiest, lowest-risk ways to start learning AI in 2026. It is free, it is beginner-friendly, and it gives you a credential you can actually show. Pick one foundational course, block out a few hours this week, and you will come away with both new skills and a badge to prove it. The hardest part is starting, so open the catalog and choose your first course today.
