Course Outline
Excel Basics (Recap) + Introduction to AI
-
Excel Interface & basic elements
Workbook / Worksheet
Rows, columns, cells
Efficient navigation within the file -
Data Formatting
Formatting numbers, texts, dates
Auto-adjusting column widths
Useful formats in business -
Basic Functions and Calculations
SUM, AVERAGE, MIN, MAX
Counting functions: COUNT, COUNTA, COUNTBLANK -
Techniques for verifying data accuracy
-
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 overwhelming 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
Automatic segmentation of data
Generating very simple formulas
Reformatting or restructuring data on request
Table Structures + Validations + Optimizations + AI
-
Tables in Excel (intermediate level)
Calculated columns
Dynamic formulas
Automatic updates -
Data Validation
Drop-down 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 checks
Explanation of validations
Detection of anomalies in the table
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 me a formula for...
Converting a requirement into the 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