USD
Contact us at

Microsoft Office Courses

Microsoft Excel Advanced with Artificial Intelligence

Microsoft Office
Artificial Intelligence

Advanced Microsoft Excel with Artificial Intelligence Course

Teacher: Sergio Bazo - Consultant and Instructor - Lernen Capacitaciones

  • Advanced
  • 532 students
  • 4.7
Start the course!

Co-certifies:

Online course description

Are you ready to transform Excel into a strategic tool that automates processes, optimizes decisions and boosts your productivity with artificial intelligence? This advanced course is designed for professionals who want to master Excel's most powerful features. You will learn how to manipulate text with precision, apply advanced conditional logic, use analysis tools for decision making, design interactive forms and automate tasks with VBA macros. In addition, you will discover how to leverage Copilot Pro to optimize workflows using artificial intelligence.

What will I learn?

You will learn how to handle advanced Excel functions to optimize data processing, automate tasks and improve decision making, integrating the use of artificial intelligence with Copilot Pro to boost your productivity.

Who is it aimed at?

Professionals, entrepreneurs, students and the general public

Requirements

Excel Intermediate Level

Content of the Microsoft Excel Advanced with Artificial Intelligence Course

  • Module 1Text functions

    6 Capsules 00:30:01

    • Capsule 1: Welcome to the course!
      Premium Access
    • Capsule 2: CONCAT and UNIRCADENAS Functions
      Premium Access
    • Capsule 3: Functions LEFT, RIGHT and EXTRAE
      Premium Access
    • Capsule 4: CAPSUSC, MINUSC and NOMPROPIO functions
      Premium Access
    • Capsule 5: TEXT function
      Premium Access
    • Capsule 6: TEXT-On and TEXT-On and TEXT-On functions
      Premium Access

  • Module 2Logic functions

    4 Capsules 00:28:39

    • Capsule 1: SI function
      Premium Access
    • Capsule 2: Y function
      Premium Access
    • Capsule 3: Function O
      Premium Access
    • Capsule 4: Complex structures nesting other functions
      Premium Access

  • Module 3Analysis tools

    2 Capsules 00:13:40

    • Capsule 1: Scenario Manager
      Premium Access
    • Capsule 2: Search for target
      Premium Access

  • Module 4Designingforms using form controls

    2 Capsules 00:28:43

    • Capsule 1: Handling the main form controls
      Premium Access
    • Capsule 2: Designing a form using the learned controls
      Premium Access

  • Module 5Macrosin Excel

    4 Capsules 00:35:13

    • Capsule 1: What is a macro and what is it for?
      Premium Access
    • Capsule 2: Macro Recorder
      Premium Access
    • Capsule 3: Creating basic macros with the Visual Basic editor
      Premium Access
    • Capsule 4: Creating forms using Visual Basic
      Premium Access

  • Module 6Data Protection

    3 Capsules 00:15:05

    • Capsule 1: Protecting cells, ranges and sheets in Excel
      Premium Access
    • Capsule 2: Protecting the book structure
      Premium Access
    • Capsule 3: Password Encryption and Write Protection
      Premium Access

  • Module 7COPILOTPRO: Microsoft's AI in a paid version

    2 Capsules 00:11:13

    • Capsule 1: Introduction to COPILOT PRO
      Premium Access
    • Capsule 2: Practical examples of the use of COPILOT PRO in Excel
      Premium Access

Final examTo obtain your course pass certificate, you will have 2 attempts per day to pass a multiple-choice exam with more than 70%.

About our expert

Sergio Bazo teacher of the course Microsoft Excel Advanced with Artificial Intelligence

Sergio Bazo

Consultant and Instructor - Lernen Capacitaciones

Sergio Bazo is a Microsoft-certified teacher with more than 25 years of experience. He has worked in leading educational institutions in Lima, such as the Peruvian Scientific Network and the Ricardo Palma, ISIL and CIBERTEC institutes. Currently, he offers Computer Science courses through the Netzun platform and Artificial Intelligence courses for companies live on Zoom. In addition, his YouTube channel has almost 250,000 followers.

Get certified and boost your career

On behalf of Saint Ignatius University
Optional certificate template for our course*San Ignacio University will certify all NETZUN students.

About the institutions

Netzun - online courses
Edtech company, founded in 2015 and specialized in virtual education based on the 'microlearning' methodology. Its purpose is to democratize the knowledge of extraordinary people throughout Latin America.
San Ignacio University certifies our courses
San Ignacio University is a U.S. university that stands out for offering a unique and cutting-edge academic experience. It has a highly qualified faculty committed to academic excellence and the integral development of its students.

Develop your skills with us

Benefits

Full access to course videos

Downloadable materials

Forum with other students

Certificate of Completion

- 74%

BUY COURSE

US$ 3.90Previously US$ 15.00

OFFER EXPIRES ON:

0 :

Dias

00 :

Hrs

00 :

Mins

00

Segs
Add coupon

Forever

Develop your skills with us

- 74%

BUY COURSE

US$ 3.90 Previously US$ 15.00

OFFER EXPIRES ON:

0 :

Dias

00 :

Hrs

00 :

Mins

00

Segs
Add coupon

BENEFITS

  • Full access to course videos
  • Downloadable materials
  • Forum with other students
  • Certificate of Completion
  • Forever
Online education for your professional growth
Short courses applying the micro-learning methodology
Short classes (micro-learning)
Learn with concise courses lasting an average of 2 hours, subdivided into videos of up to 10 minutes.
  • Concise information on specific skills
  • Easier to learn and super practical
Lifetime access to our courses
Lifetime access
If you purchase a course or specialization, you will have lifetime access to the recorded content.
  • Access your classes anytime, without schedules
  • Access your classes as many times as you want
Certified specializations with learning projects
PREMIUM
Project-Based Learning
All courses and specializations will have a final project so you can put your new skills into practice
  • Put your new skills into practice
  • You will have feedback from mentors
  • Create a portfolio of projects, improve your resume.
Certified courses
Get certified upon approval
your courses
Upon completion of a course, you will need to pass an exam, and we will issue you a digital certificate that validates your skills.
  • Certificate with a unique code
  • Improve your resume
  • Boost your professional career