Excel Skills with Artificial Intelligence
From a blank table to a complete report with one command.
إعداد المادة العلمية : أ/ أحمد حسن خميس
هندسة صوتية : علي قنعان
انيميشن ورسوم : ايمان خليفة
إخراج فنى : م/محمد كريم
What you'll learn
- Understand what AI does in an Excel sheet and what it does not
- Write a clear prompt that describes the table
- Protect data and check every number before trusting it
- Write formulas for sums, counts, conditions, lookups, dates and text
- Fix error messages and understand ready-made formulas
- Clean messy tables, combine monthly files and match statements
- Build the pivot table, the chart and the dashboard
- Write a report from the numbers, forecast and try what-if tests
- Use macros and Copilot inside Excel
About this course
This course explains how to use artificial intelligence in Excel to write formulas, clean data and build the pivot table, dashboards and reports. It starts with understanding what AI does in your spreadsheet and what it does not, where to find it, how to write a clear prompt that describes the table, and how to protect your data and check every number before you trust it. After that you write sum and count formulas with more than one condition, decisions inside the cell, fetching data from another table, dates and text, and then fix error messages. Next you clean messy tables, combine monthly files into one table, compare lists and match statements. You then move on to the pivot table, the right chart, the dashboard, the written report, forecasting, what-if testing, macros and Copilot inside Excel. The course suits the accountant, the employee, the learner and anyone who uses Excel at work or in their studies. It is enough to know adding, sorting and filtering, and you need no previous experience with AI. By the end, you will be able to prepare a monthly report that prepares itself and carry out a full project with confidence.
Expected outcomes
- Prepare a complete monthly report in minutes instead of hours
- Build a monthly report that prepares itself with macros
- Execute a complete project for accountants, employees, and students
- Use artificial intelligence in Excel with confidence and security
Learner reviews
These reviews are from learners who bought the content and completed at least 50% of it — there are no reviews from anyone who hasn't gone through the material.
No reviews yet.
Course content
2الأساس: كيف تعمل مع المساعد في إكسل
5 lectures
- ماذا يفعل الذكاء الاصطناعي في جدولك وماذا لا يفعلExplains what AI does and does not do in your spreadsheet: it writes and explains formulas and suggests ideas but does not calculate, so you ask for the formula rather than the number, then check the result with filtering and the status bar.11:52
- أين تجده - خمس أدوات وطريقانExplains two ways to use an AI assistant with Excel: one inside Excel that sees the sheet, and a separate window that only sees what you type or upload, with describing columns or uploading the table, checking the number, and avoiding sensitive data.11:13
- صف جدولك في أمر واضحExplains how to describe your sheet to the assistant in a clear prompt with five parts: the columns, the goal as an action with a condition, the output location and the Excel version, then reading the explanation and checking the number with filtering and the status bar.11:06
- بياناتك أولاExplains protecting your data before using an AI assistant: what leaves your device when you upload, starting with a description instead of the table, making a safe copy by clearing sensitive columns rather than deleting them, keeping a small sample and extending the range when moving the formula.11:27
- راجع وراءه قبل أن تثق بأي رقمExplains five checks to review an assistant's formula before trusting a number, including checking the range, testing two rows by hand, comparing with a known figure, and looking for edge cases such as empty cells, zeros or text in place of numbers.11:50
3المعادلات بكلامك العادي
7 lectures
- اجمع وعد بأكثر من شرطExplains summing, counting and averaging with multiple conditions in Excel, placing condition values in cells instead of inside the formula, the month condition using two dates and comparison operators, then checking the result with filtering and the status bar.11:52
- قرارات داخل الخانةExplains writing decisions inside a cell with conditional formulas, such as commission rate by sales, compound conditions with the AND and OR functions, a bracket table with fixed cells, ordering conditions from largest to smallest, and checking the results.11:53
- اجلب البيانات من جدول آخرExplains how to pull a price from another table by its code using lookup functions, and how to ask the assistant for a formula that handles errors and exposes wrong rows through exact matching.11:55
- التواريخ والمدد والاستحقاقاتExplains that a date in Excel is a number, how to calculate days, working days and delays, and how to detect cells that look like dates but are text before any calculation.11:37
- فك النصوص وادمجهاExplains how to split a single cell holding several pieces of information separated by a delimiter into separate columns, how to turn number-like text into a real number that can be summed, and how to verify the result.12:39
- قوائم تتجدد وحدهاExplains self-updating lists built with filter and sort formulas instead of manual copying, how to combine two conditions together, and how to check the list by counting and summing.12:37
- افهم معادلة لم تكتبها وأصلح رسائل الخطأExplains how to understand a formula inherited from someone else with the assistant's help, the common error message types, and how to trace an error back to its source and fix it instead of hiding it.11:45
4تجهيز البيانات وتنظيفها
4 lectures
- نظف جدولا فوضوياExplains how to clean a messy table by first asking the assistant for a plan: standardizing codes and removing spaces, converting numbers stored as text and dates, removing duplicates, then reconciling before and after.13:10
- اجمع ملفات الشهور في جدول واحدExplains how to combine monthly tables into one using Power Query instead of manual copying so it refreshes automatically, how to avoid column-name mismatches, and how to check the totals.13:09
- قارن قائمتين وطابق كشفينExplains how to compare two lists and reconcile two statements, such as company ledger and bank statement, find the causes of differences like extra spaces and numbers stored as text, and clean the matching column until the reconciliation closes at zero.12:22
- لون جدولك بالقواعد واضبط الإدخالExplains conditional formatting that colors overdue and duplicate rows using formula rules, and data validation with a dropdown list that prevents wrong entries from the start.12:57
5التحليل والرسوم ولوحات المتابعة
4 lectures
- الجدول المحوري بأمر واحدExplains how to build a Pivot Table in one go to answer a manager's questions: choosing rows, columns and values, grouping dates into quarters, and checking the figure with a formula.12:10
- اسأل أرقامكExplains how to ask the assistant why sales dropped by breaking the table down by customer, product and sales rep, and how to verify its figures with Excel formulas before relying on them.12:42
- الرسم البياني المناسب لكل سؤالExplains how to choose the right chart for each question: columns for comparison, a line for time, a pie for a few parts, and horizontal bars for shares, with a title that states the result.12:03
- لوحة متابعة في صفحة واحدةExplains how to build a one-page Dashboard: planning first, then indicators with short formulas, pivot charts, and a Slicer connected to all tables so the page updates with one click.12:45
6التقارير والتوقع والأعمال الآلية
5 lectures
- من الأرقام إلى تقرير مكتوبExplains how to turn numbers into a written commentary with the assistant from a single sheet of figures, citing the cell of each number, then checking every number yourself to catch hidden errors.12:30
- توقع الشهر القادم وجرب ماذا لوExplains how to forecast next month's sales with a straight-line trend and the Forecast Sheet while accounting for seasonality, test the forecast on a known month, and use Goal Seek to find the value that reaches a target.13:00
- ماكرو يكتبه المساعد لعمل يتكررExplains how the assistant writes a macro for a repetitive task, how to ask for a line-by-line explanation and look for delete commands, save the workbook in macro format, and test on a copy before the original.12:06
- تقرير شهري يجهز نفسهExplains how to build a monthly report that refreshes with one click: separating what changes from what stays fixed, combining monthly tables from a folder, linking the pivot and charts, and running a checklist after each refresh.13:21
- Copilot داخل إكسلExplains Copilot inside Excel and its three modes, chat only, plan and allow editing, when to use each, starting with the lowest-risk mode, working on a copy and reviewing the changes.12:42
7المشروعات الختامية
3 lectures
- مشروع المحاسبWalks through the accountant project: building an accounts receivable aging table from a raw invoice list with short prompts, calculating days overdue, bucketing with approximate lookup, summarizing with sums and counts, and checking each step.12:37
- مشروع الموظفApplies one method to two jobs: a payroll sheet and payslip with a deduction rate in a fixed cell, and an inventory table with reorder levels, plus a check cell that returns zero and protection against division by zero.12:59
- مشروع الطالب ومكتبة أوامركWalks through the student project: student grades, averages, letter grades, ranking and a survey summary, using the describe, request, review method, with rounding the average, checking grade boundaries, and remembering that an empty cell is not zero.12:59
Production team
إعداد المادة العلمية
Ahmed Hassan Khamis
449.7K views42 courses
هندسة صوتية
علي قنعان
انيميشن ورسوم
ايمان خليفة
إخراج فنى
م/محمد كريم
