All tutorials
Find a practical guide, or choose AI, SQL or Excel to follow an ordered learning path.
Excel Sales Report Project: Build, Check and Explain a Small Workbook
Build a beginner sales workbook with a Table, calculated totals, category summary and chart. Reconcile results and document the limits.
Read tutorial →Calculate Percentage Change in Excel and Label It Clearly
Calculate percentage changes with explicit baselines. Distinguish percentage points, test increases and declines, and handle a zero starting value.
Read tutorial →Build Your First Excel PivotTable and Reconcile the Totals
Build a PivotTable from a small sales list. Choose SUM versus COUNT, reconcile totals and refresh after a source change.
Read tutorial →Excel INDEX and MATCH: Look Up Values with a Flexible Layout
Use exact-match INDEX and MATCH to return a price from a flexible layout. Keep lookup and return ranges aligned and check missing keys.
Read tutorial →Round Numbers in Excel: Stored Values Versus What You See
Distinguish Excel number formatting from ROUND. Compare rounding each line with rounding a final total and document the calculation rule.
Read tutorial →Handle Excel Errors with IFERROR and IFNA Without Hiding Problems
Diagnose Excel errors before using IFERROR or IFNA. Preserve the difference between a valid zero, a missing match and an invalid calculation.
Read tutorial →Excel SUMIFS and COUNTIFS: Combine More Than One Condition
Combine conditions with SUMIFS and COUNTIFS. Align ranges, use criteria cells and reconcile a small regional sales summary.
Read tutorial →Use Conditional Formatting in Excel Without Hiding the Meaning
Highlight stock conditions with Excel conditional formatting. Test boundaries, align relative references and use text labels alongside colour.
Read tutorial →Create an Excel Drop-Down List with Data Validation
Create a data-validation drop-down for consistent statuses. Test invalid entries, define blank behaviour and review existing records.
Read tutorial →Clean Text in Excel with TRIM, CLEAN and SUBSTITUTE
Clean spreadsheet text while preserving original values. Inspect spaces, normalise labels and verify the effect on category summaries.
Read tutorial →SQL Report Project: Check a Customer Summary from Start to Finish
Build a complete beginner SQL report with joins, totals and validation checks. Define the output grain and reconcile customer results to source orders.
Read tutorial →SQL Table Constraints: Protect Keys and Required Values
Learn SQL primary keys, NOT NULL, UNIQUE and CHECK constraints. Create a small practice table and understand what constraints can and cannot validate.
Read tutorial →Practise SQL UPDATE Safely with a Transaction and ROLLBACK
Practise SQL UPDATE in a disposable database. Preview the WHERE condition, inspect affected rows and use ROLLBACK to undo the exercise.
Read tutorial →Find Duplicate Records in SQL Before You Delete Anything
Find SQL duplicates with an explicit business key. Distinguish repeated activity from duplicate records and inspect candidates before changing data.
Read tutorial →SQL Running Totals: Add Values Without Losing the Detail
Build a SQL running total with SUM OVER. Specify row order and an explicit window frame, then compare cumulative and per-customer totals.
Read tutorial →SQL ROW_NUMBER: Number Rows Within Each Customer
Learn ROW_NUMBER with a small order table. Keep detail rows, partition by customer and use a deterministic tie-breaker for top-per-group results.
Read tutorial →SQL Dates in SQLite: Filter a Month and Calculate Day Differences
Work with SQLite dates using clear ISO values. Filter a month with an exclusive upper boundary and calculate elapsed days with julianday.
Read tutorial →SQL Text Functions: Clean Labels Without Changing Their Meaning
Use SQLite text functions to inspect and clean labels. Practise TRIM, LOWER, LENGTH and SUBSTR while preserving identifiers and original values.
Read tutorial →SQL UNION and UNION ALL: Combine Lists Without Surprises
Combine SQL result lists using UNION and UNION ALL. Understand duplicate removal, compatible columns and final sorting with a small example.
Read tutorial →SQL Common Table Expressions: Make a Long Query Easier to Read
Use SQL common table expressions to break a report into named steps. Build customer totals, filter the summary and check the result.
Read tutorial →Build a Small AI-Assisted Study Guide as a Final Project
Build a small AI-assisted study guide with verified notes, examples, a quiz and answer checks. Practise a complete beginner workflow from brief to review.
Read tutorial →Compare Two Sources with AI Without Blending Their Claims
Compare two source texts with AI while preserving attribution. Separate agreement, disagreement and missing evidence with a traceable review table.
Read tutorial →Keep an AI Work Log So You Can Reproduce a Useful Result
Keep a simple AI work log with inputs, prompts, changes and checks. Reproduce useful workflows without saving unnecessary private information.
Read tutorial →Decide What an AI Automation May Do and Where It Must Stop
Define clear boundaries for AI automation. Separate drafting from sending, set review checkpoints and plan what happens when information is missing.
Read tutorial →Ask AI for a Data-Cleaning Plan Before Changing a CSV
Plan CSV cleaning with AI before editing data. Preserve originals, define duplicate rules and separate suspicious values from confirmed corrections.
Read tutorial →Create Fictional Practice Data with AI That Actually Fits the Rules
Create fictional AI practice data with clear rules, deliberate edge cases and validation checks. Avoid confusing synthetic examples with real evidence.
Read tutorial →Extract Text from an Image with AI and Check Every Critical Detail
Extract text from a clear image with AI and verify the result. Mark unreadable text, preserve rows and check numbers against the original.
Read tutorial →Plan an AI Image Prompt with Composition, Style and Limits
Plan a clear AI image prompt using subject, composition, style and constraints. Review the result for misleading details and practical usability.
Read tutorial →Use AI for Translation Drafts and Check the Meaning
Use AI for a first translation draft and review dates, tone and ambiguity. Learn why a fluent translation still needs language-aware checking.
Read tutorial →Rewrite Technical Text in Plain Language with AI
Rewrite technical text in plain language with AI while preserving meaning. Check conditions, responsibilities and deadlines before sharing the result.
Read tutorial →Practise an Interview with AI and Give Better Examples
Practise interview answers with AI using fictional examples. Ask one question at a time, request evidence-based feedback and avoid inventing experience.
Read tutorial →Plan a Focused Meeting Agenda with AI
Create a focused AI-assisted meeting agenda with time limits, decisions and preparation. Keep discussion topics separate from desired outcomes.
Read tutorial →Use AI to Explore Pros and Cons Without Losing Your Own Judgement
Use AI to explore pros and cons fairly. Ask for tradeoffs, missing evidence and conditions that would change a conclusion.
Read tutorial →Use AI to Build a Transparent Decision Matrix
Build an AI-assisted decision matrix with explicit criteria and weights. Separate facts from preferences and test whether a small change alters the result.
Read tutorial →Make Useful Flashcards with AI Without Memorising Bad Answers
Make AI-assisted flashcards that test one idea at a time. Use examples, avoid overloaded cards and verify facts before studying.
Read tutorial →Create Better Practice Quizzes with AI
Create an AI practice quiz that tests understanding. Use clear questions, separate answers and explanations for common wrong choices.
Read tutorial →Build a Beginner Glossary with AI and Real Examples
Build an AI-assisted glossary that explains unfamiliar terms with examples, boundaries and a short understanding check for each entry.
Read tutorial →Use AI to Turn Long Instructions into a Checklist
Turn long instructions into an accurate checklist with AI. Preserve order, conditions and required evidence, then check for missing steps.
Read tutorial →Ask AI to Clarify a Task Before It Starts
Use AI clarifying questions to resolve important missing details. Prioritise questions, avoid unnecessary interviews and test a fictional event brief.
Read tutorial →Turn a Vague Request into an AI Task Brief
Turn a vague idea into an actionable AI task brief. Define the output, inputs, limits and success checks with a beginner practice activity.
Read tutorial →Make Your First Excel Chart: Choose a Clear Story and Check the Numbers
Create a clear first Excel chart from monthly data. Choose a suitable chart, label units, avoid misleading scales and verify the source range.
Read tutorial →Excel VLOOKUP Exact Match: Find a Price Without Guessing
Learn exact-match VLOOKUP with a product price list. Fix the lookup range, understand FALSE and investigate missing or inconsistent product codes.
Read tutorial →Excel Dates for Beginners: Calculate Days and Handle Deadlines
Understand Excel dates with deadline examples. Use DATE, subtract dates, extract months and avoid ambiguous entries and hidden time values.
Read tutorial →Sort and Filter in Excel Without Mixing Up Your Rows
Learn to sort and filter Excel lists safely. Keep records together, use multiple sort levels and distinguish hidden rows from deleted records.
Read tutorial →Excel Tables for Beginners: Make Lists Easier to Maintain
Turn a plain Excel list into a Table. Learn headers, calculated columns, structured references and checks that keep expanding data organised.
Read tutorial →Excel SUMIF and COUNTIF: Summarise Records That Match a Rule
Use Excel SUMIF and COUNTIF with a small sales table. Match text, compare numbers and check conditional totals without mixing up ranges.
Read tutorial →Excel IF Function for Beginners: Turn a Rule into a Formula
Learn the Excel IF function with a stock reorder sheet. Write logical tests, handle exact boundaries and keep missing values visible.
Read tutorial →Excel SUM, AVERAGE and COUNT: Summarise Numbers Correctly
Use Excel SUM, AVERAGE, MIN, MAX and COUNT with clear examples. Understand blanks, zeros and text so your summaries answer the right question.
Read tutorial →Relative and Absolute References in Excel: When to Use the Dollar Sign
Understand relative and absolute Excel references with a discount example. Learn when to use $B$1, mixed references and reliable copy-down checks.
Read tutorial →Excel Formulas for Beginners: Build and Check Your First Calculations
Build your first Excel formulas with a small sales sheet. Learn cell references, arithmetic order, fill-down and simple checks that catch mistakes.
Read tutorial →SQL Subqueries and EXISTS: Answer Questions in Two Steps
Learn SQL subqueries and EXISTS with above-average orders and customer matching examples. Practise clear two-step reasoning and checked answers.
Read tutorial →SQL CASE WHEN: Create Labels and Conditional Totals
Use SQL CASE WHEN to label orders and build conditional totals. Learn condition order, ELSE behaviour and a beginner reporting exercise.
Read tutorial →SQL LEFT JOIN Explained: Keep Customers with No Orders
Learn SQL LEFT JOIN with customers who have no orders. Handle NULL, count matches correctly and avoid accidentally turning it into an inner join.
Read tutorial →SQL INNER JOIN for Beginners: Connect Customers and Orders
Connect two SQL tables with INNER JOIN. Understand matching keys, one-to-many relationships, aliases and repeated names in query results.
Read tutorial →SQL GROUP BY and HAVING: Build Useful Summary Reports
Build SQL summary reports with GROUP BY and HAVING. Learn the difference between filtering rows and filtering groups with checked examples.
Read tutorial →SQL Aggregate Functions: COUNT, SUM, AVG, MIN and MAX
Learn COUNT, SUM, AVG, MIN and MAX in SQL. Check totals, handle missing values and avoid confusing order counts with customer counts.
Read tutorial →SQL DISTINCT and NULL: Understand Unique and Missing Values
Understand SQL DISTINCT and NULL with small examples. Remove duplicate result combinations and handle missing values without misleading counts.
Read tutorial →SQL ORDER BY and LIMIT: Sort Results and Find the Top Rows
Sort SQL results with ORDER BY, choose ascending or descending order, handle ties and use LIMIT with a practical top-orders exercise.
Read tutorial →SQL WHERE Explained: Filter Rows with AND, OR and IN
Learn SQL WHERE through clear examples. Combine conditions with AND and OR, use IN and BETWEEN, and avoid common filtering mistakes.
Read tutorial →SQL SELECT for Beginners: Choose Columns and Name Your Results
Learn SQL SELECT with a small shop database. Choose columns, use aliases, calculate values and check your results with beginner exercises.
Read tutorial →Build a Simple AI Workflow with a Human Review Step
Build a beginner AI workflow with clear inputs, a useful draft and a human review step. Follow a fictional enquiry example and learn how to handle exceptions.
Read tutorial →Compare Two AI Answers Without Choosing the One That Sounds Better
Learn a fair way to compare AI responses using accuracy, completeness and usefulness. Build a simple checklist and practise judging two short answers.
Read tutorial →Use AI to Understand a Spreadsheet Formula, Not Just Copy It
Learn how to ask AI for a clear spreadsheet-formula explanation. Work through multiplication and SUM, test expected results and avoid copying formulas blindly.
Read tutorial →Ask AI Questions About a Small Table of Data
Learn to ask clear questions about a small dataset. Define the columns, check totals and avoid conclusions the table cannot support.
Read tutorial →Build a Realistic Learning Plan with an AI Assistant
Use AI to plan a beginner learning project with small tasks, practice and progress checks. Follow a practical Excel example and build a plan you can maintain.
Read tutorial →Turn Messy Notes into a Clear Action Plan with AI
Turn rough notes into an action plan without inventing deadlines or responsibilities. Learn a simple table format and practise checking the result.
Read tutorial →Use AI to Summarise Text Without Losing the Important Details
Learn to ask for useful AI summaries that preserve dates, conditions and uncertainty. Follow a worked example and check a summary against its source.
Read tutorial →How to Check an AI Answer Before You Trust It
Learn a practical way to verify AI answers. Separate facts from suggestions, check original sources and test calculations with a beginner-friendly exercise.
Read tutorial →Build a Reusable AI Prompt Template for Everyday Tasks
Stop starting every AI request from scratch. Build a reusable prompt template with clear instructions, examples and a simple quality checklist.
Read tutorial →How to Give AI Useful Context Without Writing a Huge Prompt
Learn how to give an AI assistant the background it needs. Use a simple example, practise choosing relevant details and avoid sharing unnecessary information.
Read tutorial →SQL Practice Lab: SELECT, WHERE, GROUP BY and JOIN
Turn the SQL basics into something you can run. In this practice lab, you will select columns, filter rows, sort results, calculate totals and connect two tables.…
Read tutorial →What Is SQL and What Is It Used For?
SQL is the language people use to communicate with relational databases. This simple guide explains what it does and why it is worth learning.
Read tutorial →How to Use AI for Brainstorming Without Losing Your Creativity
AI is good at producing many ideas quickly. Your creativity becomes more important when you choose, combine, question, and improve those ideas.
Read tutorial →How to Choose the Right AI Tool for Any Task
The best AI tool is not always the most famous one. It is the tool that fits your task, protects your information, and produces results you can…
Read tutorial →Free vs Paid AI Tools: Which One Should You Choose?
A paid AI plan can be useful, but many beginners do not need one immediately. The right choice depends on how often you use AI and what…
Read tutorial →How AI Recommendation Systems Choose What You See
Your home screen is not random. Recommendation systems study signals from your activity and use them to predict what may keep you interested.
Read tutorial →Will AI Replace Your Job?
AI is changing work, but jobs are made of many different tasks. Understanding that difference makes the future feel less mysterious and more manageable.
Read tutorial →What Is AI Automation? A Simple Guide for Beginners
AI automation connects artificial intelligence with repeatable actions. It can sort messages, summarize information, and reduce routine work, but it still needs sensible checks.
Read tutorial →What Is an AI Image Generator and How Does It Work?
AI image generators can turn a written idea into a picture. This guide explains the process in plain language and shows beginners how to get better results.
Read tutorial →How to Use AI to Write Better Emails
A blank email can waste more time than it should. AI can help you find the right words while you stay in control of the facts and…
Read tutorial →How Students Can Use AI to Study Without Cheating
AI can act like a patient study partner when students use it to learn instead of copy. Here are simple, honest ways to make it useful.
Read tutorial →How to Protect Your Privacy When Using AI Tools
AI tools can save time, but they should not receive every detail about your life. These simple privacy habits help beginners use AI with more confidence.
Read tutorial →Excel Templates
Less setup. More getting things done.Free Excel templates for work and everyday life.Free Excel templates for your business, money and everyday plans. Find the workbook you need,…
Read tutorial →How to Select Cells, Rows, and Columns in Excel
Selecting cells, rows, and columns is one of the most basic skills you need when learning Microsoft Excel. Before you can format data, copy information, delete entries,…
Read tutorial →How Small Businesses Can Use AI to Save Time
Running a small business can be exciting, but it can also be exhausting. Small business owners often do many things at once. They talk to customers, create…
Read tutorial →What Are AI Hallucinations and Why Do They Happen?
Artificial intelligence tools like ChatGPT can be very helpful. They can explain difficult topics, write emails, summarize long documents, generate ideas, create code, and answer questions in…
Read tutorial →How Is Data Stored in a Database?
Before you learn SQL, you need to understand how data is stored in a database. Many beginners think a database is one big file where everything is…
Read tutorial →What Is a Database? A Beginner-Friendly Explanation
Almost every app, website, and business system uses a database. When you create an account, your details are stored somewhere.When you buy something online, your order is…
Read tutorial →How to Type Data in Excel Cells
Typing data in Excel cells is one of the first skills every beginner needs to learn. Before you can use formulas, create charts, build reports, or analyze…
Read tutorial →How to Create, Save, Open, and Rename an Excel File
Learning how to create, save, open, and rename an Excel file is one of the first things every beginner should know. Before you start using formulas, charts,…
Read tutorial →Understanding the Excel Screen: Workbook, Worksheet, Rows, Columns, and Cells
When you open Microsoft Excel for the first time, the screen can look confusing. You may see many boxes, letters, numbers, buttons, menus, and tabs. But once…
Read tutorial →What Is Microsoft Excel and What Is It Used For?
Microsoft Excel is one of the most popular computer programs in the world. It is used in offices, schools, businesses, banks, shops, hospitals, and even at home.…
Read tutorial →ChatGPT vs Google Search: What Is the Difference?
For many years, Google Search has been the first place people go when they need answers. You want a recipe? You Google it. You want to compare…
Read tutorial →Common AI Terms Explained for Beginners
Artificial intelligence is now everywhere. People use AI to write emails, create images, summarize documents, generate code, study faster, automate work, and even plan businesses. But for…
Read tutorial →What Are AI Prompts? A Beginner’s Guide to Getting Better Answers from ChatGPT
Artificial intelligence tools like ChatGPT can write, explain, summarize, research, code, brainstorm, and even help you plan your day. But there is one thing many beginners quickly…
Read tutorial →7 ChatGPT Settings That Can Make AI More Personal, Useful, and Private
ChatGPT is powerful even when you use it with the default settings. You can ask questions, write emails, summarize text, create ideas, plan your work, study, code,…
Read tutorial →What Is ChatGPT and How Does It Work?
Artificial intelligence is no longer something we only see in science fiction movies. Today, millions of people use AI tools to write, learn, plan, code, research, create…
Read tutorial →How AI Powers Your Everyday Life Without You Noticing
Artificial intelligence is no longer something that only appears in science fiction movies. It is already part of daily life. The funny thing is that most people…
Read tutorial →The History of AI: From Sci-Fi Dreams to Everyday Tools
Artificial intelligence, or AI, feels like a new thing to many people. Today, people use AI to write emails, create images, answer questions, recommend videos, detect fraud,…
Read tutorial →What Is Generative AI and Why Is Everyone Talking About It?
Generative AI is one of the biggest technology topics in the world today. You may have seen people using AI to write emails, create images, summarize documents,…
Read tutorial →AI vs Machine Learning vs Deep Learning
Artificial Intelligence, Machine Learning, and Deep Learning are three terms you will hear a lot when people talk about modern technology. Many beginners think they all mean…
Read tutorial →What Is Artificial Intelligence?
Artificial Intelligence, often called AI, is one of the most talked-about technologies in the world today. You may have heard people say AI can write articles, create…
Read tutorial →