Course Outline
Excel Basics (Review) + Introduction to AI
-
Excel Interface & Basic Elements
Workbook / Worksheet
Rows, columns, cells
Efficient file navigation -
Data Formatting
Formatting numbers, text, and dates
Auto-adjusting column width
Useful formats in business -
Basic Functions and Calculations
SUM, AVERAGE, MIN, MAX
Counting functions: COUNT, COUNTA, COUNTBLANK -
Data Accuracy Verification Techniques
-
Introduction to AI for Beginners
What Copilot can do in Excel
How to use it for:
Generating simple formulas,
Explaining an operation,
Verifying data
Very simple practical examples (to avoid intimidating beginners)
Data Management + Practical Formulas + AI
-
Filtering and Sorting
Alphabetical / Numerical sorting
Filtering by conditions
Removing duplicates -
Date & Time Functions
DATE, TODAY, WEEKDAY, WORKDAY
Calculating deadlines and durations -
Conditional Formatting
Simple rules
Highlighting key values -
Working with Excel Tables (Beginner Level)
Creating a table
Advantages: sorting, filtering, totals -
Preparing Data for Printing
-
AI for Working with Simple Data
Let Copilot explain what a table contains
Automated data segmentation
Generating very simple formulas
Reformatting or restructuring data on demand
Table Structures + Validation + Optimization + AI
-
Tables in Excel (Intermediate Level)
Calculated columns
Dynamic formulas
Automatic updates -
Data Validation
Dropdown lists
Rules for data control
Input and error messages -
Tips & Tricks for Beginners
Useful shortcuts
Quick selections
Autofill, Flash Fill -
AI for Structuring, Validation, and Verification
Automatic generation of lists
Suggestions for data verification
Explanation of validations
Detection of anomalies in tables
Intermediate Functions + Lookups + AI for Formulas
-
Logical Functions
IF
AND / OR
IFS and simple combinations -
Lookup Functions (Beginner–Intermediate Level)
VLOOKUP
XLOOKUP (modern and easy to understand) -
AI for Generating and Explaining Formulas
“Write the formula for…”
Transforming a request into a correct formula
Explaining the steps of a formula
Adjusting existing formulas -
Final Tips & Tricks
Efficient approaches
Common mistakes to avoid
Requirements
Basic computer literacy
Testimonials (7)
many new things
Bera Mihai - Simea
Course - Excel AI - Intermediar
Machine Translated
a cell where you can use the functions to facilitate the work
Sinca Manuela Mariana - Simea
Course - Excel AI - Intermediar
Machine Translated
Pivot; IF, XLOOKUP, and the list can go on. :)
Stir Ana-Adela - Simea
Course - Excel AI - Intermediar
Machine Translated
Module on formula usage and their correct application
Daniela Sbircea - Simea
Course - Excel AI - Intermediar
Machine Translated
Formula shortcuts and the Smart Table
Marginean Alin-Nicolae - Simea
Course - Excel AI - Intermediar
Machine Translated
I use paper and a pen to work out the conditions for the IF function :) I never liked this function, but finally, I understand it.
Iozefina Matei - Simea
Course - Excel AI - Intermediar
Machine Translated
The "Filter" function
Nedelcu Alexandru - Simea
Course - Excel AI - Intermediar
Machine Translated