Training that keeps pace with innovation, for a world that changes fast.

background

Excel: work smarter, not harder

From basics to advanced features with AI, Power Query and automations to work more efficiently and smartly.

Best Seller Icon Bestseller
  • Last update 02/2026
  • English
  • Max 5 per corso
  • Final certificate

What you will learn and Course Prerequisites:

Excel is present in virtually every office, but most people use only a small part of its functionality. This course goes from basics to the most advanced techniques, with a practical approach that will allow you to save hours of work every week.

  • Master basic functionalities often misunderstood (e.g. formatting vs calculations)
  • Use AI (Copilot, Claude, ChatGPT) to speed up and improve work with Excel
  • Create complex formulas and advanced logic for intelligent automation
  • Master pivot tables for multidimensional data analysis and dynamic dashboards
  • Import and transform data with Power Query
  • Automate repetitive processes and create custom functions with AI-assisted macros and VBA
  • Integrate Excel with other tools for optimized workflows
  • Apply everything on real case studies for administration, sales, data analysis and project management

The course follows a progressive teaching method with practical examples across all work sectors, allowing you to start from the basics and reach advanced skills immediately applicable to work smarter, not harder.

  • Course Prerequisites:
  • No previous Excel knowledge required
  • Stable Internet connection
  • PC with Excel 2021 (or later) or Microsoft 365
  • Recommended: dual monitor or tablet to follow the lesson and reproduce practical exercises on PC
Show More

What you will be able to achieve

Different projects will be developed within the course. Here are some created in past editions.

Course Content

  • Introduction to Excel and interface navigation
  • Managing workbooks, sheets and collaboration (cloud sharing and real-time work)
  • Excel and AI: tools overview (Copilot, Claude, ChatGPT) and effective requests
  • Formatting vs calculations: difference between visual formatting and real calculations
  • Cell format, numbers, dates and texts
  • Professional navigation: shortcuts, multiple selections and interface customization
  • Fill and series
  • Basic formulas, absolute and relative reference
  • Logical functions: IF, IFS, AND, OR, NOT
  • Error handling: IFERROR and IFNA
  • Lookup and dynamic references: advanced VLOOKUP, XLOOKUP
  • INDEX and MATCH: the winning combination for complex searches
  • Structured references in tables for dynamic formulas
  • Complex calculations with dates and time: NETWORKDAYS, EOMONTH
  • Practical exercises

  • Text manipulation functions: CONCAT, TEXTJOIN, SUBSTITUTE
  • Complex calculations with dates and time: calculations with dates, hours and minutes, elapsed time between dates and times, NETWORKDAYS, EOMONTH
  • Lookup and dynamic references: advanced VLOOKUP, XLOOKUP
  • INDEX and MATCH: the winning combination for complex searches
  • Structured references in tables for dynamic formulas
  • Sort and filter data
  • Insert and modify charts
  • Choose the appropriate chart
  • Most common charts and dashboard creation
  • Practical exercises

  • Pivot tables without secrets: prepare data the right way
  • Create automatic summaries and charts that update themselves
  • Group by month/quarter and calculate percentages automatically
  • Import data from files, databases and websites with Power Query
  • Merge information from different sources and clean data automatically
  • Create reporting that updates with one click
  • Practical exercises

  • Record macros to automate repetitive operations
  • Modify and customize macros with AI help
  • Create custom functions without being expert programmers
  • Automate reports and process multiple files simultaneously
  • Connect Excel with other programs and work tools
  • Protect and control data access (cells, sheets, workbooks with passwords) both locally and on cloud
  • Organize work with reusable templates
  • Solve common problems and recover data
  • Practical exercises

Upcoming Dates

  • Standard:
  • Dates updating
  • Evening:
  • Buy and request a date!
  • Weekend:
  • Buy and request a date!

Schedule

  • Standard:
  • 9:00 - 13:00 / 14:00 - 17:00
  • Duration: 2 days
  • Evening:
  • 4 Days/Week  21:00 - 23:00
  • Duration: 2 weeks
  • Weekend:
  • Sat  9:00 - 13:00 / 14:00 - 17:00
  • Duration: 2 weekends

*All times shown refer to the Rome and Madrid time zone.

Instructor

Author Images
Barbara Callegari
Microsoft Certified Trainer

With over ten years of experience in Data Analysis, Barbara is a prepared and multi-certified instructor, with solid collaboration as a consultant for national-level companies. She has trained students of all levels, creating tailor-made paths that respond exactly to the needs of each participant and the specific requests of clients. Her courses are practical and oriented to real operations: not just theory, but tools and techniques applicable immediately in the working world.

Other Courses by Barbara

Card image Discover the Course
Practical AI: productivity and quality of work.
Python Course Discover the Course
Python: from Basics to Data Analysis.
Video Images
Watch the course presentation
You can review and confirm payment in the next step
  • Course Type
  • Available Dates
  • EnrolledMax 5
  • LanguageEnglish
  • Duration14 h
  • CertificateYes
  • Download MaterialsYes
FAQ

Frequently Asked Questions

Find answers to the most frequently asked questions about the courses.

To enroll in the course, go to the tab on the right, choose the course type you prefer (Standard, Evening, or Weekend), select one of the available dates, and click the 'Enroll' button. Fill out the form with all your details, such as first name, last name, email address, and phone number, then proceed with the payment. Once completed, you will receive an email confirming your enrollment along with all the information you'll need for the course.

Live course registrations follow a tiered system with progressive pricing:
  • Early Bird Rate: up to 30 days before the course starts, with a 20% discount
  • Standard Rate: from 30 days before until registration closes
  • Registration Deadline: 5 days before the course starts
We recommend enrolling as early as possible to take advantage of the Early Bird discount and secure your spot, as courses have a limited number of participants.

Usually, you won't find pre-scheduled dates for evening or weekend courses, as these formats are activated exclusively upon request. If you're interested, you can still select the course and proceed with the enrollment just like with any other option. Once your enrollment is complete, I will promptly schedule a date, which will be set with at least 30 days' notice before the course begins, to allow easier planning for all participants. This approach allows me to offer flexible and personalized solutions tailored to the actual needs of the attendees.

The cancellation policy includes:
  • More than 14 days before the start: full refund (100%)
  • From 13 to 7 days before: voucher for the full amount usable for other courses
  • Less than 7 days before: voucher for 50% of the amount
  • No-show without notice: no refund
Right of withdrawal: the 14-day right of withdrawal does not apply once the course has started. For more details, please see Terms and Conditions.

This course is designed with an extremely practical approach: the goal is to help you acquire concrete skills that are immediately applicable in your daily work. It doesn't follow the official course curriculum, but it enables you to master the tool effectively.

However, I am certified in all the tools I teach (including the Microsoft Certified Trainer qualification for Microsoft products) and I am also available to deliver official courses that specifically prepare for certification exams. If you're interested in this path, contact me or write to me at info@numberslab.net for more information.

Yes, the price you see is exactly what you'll pay. There are no additional costs, taxes, or hidden fees. The displayed price includes everything: full course access, learning materials, and certificate of attendance.

For your convenience, I have included specific FAQs in each section of the site, customized based on the topics covered. I recommend also consulting the other pages to find more detailed answers to your questions.

Haven't found what you were looking for? Write to me at info@numberslab.net or use the contact form that you can find here.