Microsoft Office
Artificial Intelligence

Intermediate Microsoft Excel with Artificial Intelligence Course

Teacher: Sergio Bazo - Consultant and Instructor - Lernen Capacitaciones

  • Intermediate
  • 589 students
  • 4.6
Start the course!

Co-certifies:

Online course description

How can you take your Excel proficiency to the next level? In this intermediate course, you will learn how to optimize your workflow with advanced tools, conditional functions and data analysis techniques. In addition, we will explore how Artificial Intelligence, through platforms such as ChatGPT and Gemini, can empower the use of Excel, automating tasks and improving efficiency in data management.

What will I learn?

You will learn to use advanced Excel functions to organize, analyze and manage data efficiently, applying automation, validations and dynamic formats, as well as artificial intelligence tools to optimize processes and decision making.

Who is it aimed at?

Professionals, entrepreneurs, students and the general public.

Requirements

Excel Basic Level

Content of the Microsoft Excel Intermediate course with Artificial Intelligence

  • Module 1Schemasin Excel

    4 Capsules 00:23:09

    • Capsule 1: Welcome to the course!
      Premium Access
    • Capsule 2: Creation of auto-schemas
      Premium Access
    • Capsule 3: Creation of manual diagrams
      Premium Access
    • Capsule 4: The Subtotals Tool
      Premium Access
  • Module 2Logical valuesTRUE or FALSE

    3 Capsules 00:11:06

    • Capsule 1: What are logical values and what are they for?
      Premium Access
    • Capsule 2: Comparison Formulas
      Premium Access
    • Capsule 3: Logical Values from Functions
      Premium Access
  • Module 3Conditional Formats

    3 Capsules 00:35:38

    • Capsule 1: Conditional formatting using default options
      Premium Access
    • Capsule 2: Conditional formatting rules
      Premium Access
    • Capsule 3: Custom Conditional Formats
      Premium Access
  • Module 4Advanced Filters

    2 Capsules 00:49:16

    • Capsule 1: The Advanced Command
      Premium Access
    • Capsule 2: FILTER and CHOOSECOLS functions
      Premium Access
  • Module 5Dynamic Tablesand Charts

    5 Capsules 00:46:13

    • Capsule 1: What is a pivot table and what is it for?
      Premium Access
    • Capsule 2: Basic Pivot Tables and Pivot Charts in Excel
      Premium Access
    • Capsule 3: Calculated fields
      Premium Access
    • Capsule 4: Segmentation charts and time scales
      Premium Access
    • Capsule 5: Creation of Dashboards
      Premium Access
  • Module 6Cell Validations

    4 Capsules 00:32:54

    • Capsule 1: Basic validations
      Premium Access
    • Capsule 2: Validations using logical values
      Premium Access
    • Capsule 3: Dependent validations
      Premium Access
    • Capsule 4: Dynamic List Validations
      Premium Access
  • Module 7Othercommands and functions for database management

    4 Capsules 00:24:45

    • Capsule 1: Dividing text into columns
      Premium Access
    • Capsule 2: Elimination of duplicates
      Premium Access
    • Capsule 3: Consolidating tables
      Premium Access
    • Capsule 4: New Functions for Database Management
      Premium Access
  • Module 8Principalconditional and database statistical functions

    3 Capsules 00:37:04

    • Capsule 1: Functions for counting data
      Premium Access
    • Capsule 2: Functions for summation and averaging of data
      Premium Access
    • Capsule 3: Functions for finding the maximum and the minimum
      Premium Access
  • Module 9Mainsearch functions

    2 Capsules 00:22:19

    • Capsule 1: SEARCHV and SEARCHH functions
      Premium Access
    • Capsule 2: BUSCARX function
      Premium Access
  • Module 10Artificial Intelligence Platformsapplied to Excel

    2 Capsules 00:08:10

    • Capsule 1: CHAT GPT
      Premium Access
    • Capsule 2: GEMINI
      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 Intermediate 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