Microsoft Office

Intermediate Excel Course

Teacher: Sergio Bazo - Consultant and Instructor - Lernen Capacitaciones

  • Intermediate
  • 50230 students
  • 4.7
Start the course!

Co-certifies:

Online course description

The Intermediate Excel course is the continuation of the Basic Excel course. Here we will start learning how to use conditional formatting. In addition, we will see how to use more tools for database management, such as tables and pivot charts. You will also learn how to use many more important functions such as search functions, conditional statistical functions and text functions.

What will I learn?

In this course you will learn how to use important commands and functions that will allow you to become more and more proficient in the use of Excel.

Who is it aimed at?

General public.

Requirements

To take this course you must have basic knowledge of Excel. Preferably you should have taken Netzun's Basic Excel course.

Content of the Intermediate Excel course

  • Module 1Conditional Formatting

    9 Capsules 01:01:11

    • Capsule 1: Definition of conditional formatting
      Free View
    • Capsule 2: Applying formatting only to cells that contain
      Premium Access
    • Capsule 3: Apply formatting only to values with a lower or upper range
      Premium Access
    • Capsule 4: Apply formatting only to values that are above or below average
      Premium Access
    • Capsule 5: Formatting only unique or duplicate values
      Premium Access
    • Capsule 6: Creating Conditional Color Scale Formats
      Premium Access
    • Capsule 7: Creating conditional formats with data bars
      Premium Access
    • Capsule 8: Creating conditional icon set formats
      Premium Access
    • Capsule 9: Creating custom conditional formats with a formula
      Premium Access
  • Module 2Database Administration

    15 Capsules 04:25:56

    • Capsule 1: Creating Schemes by grouping rows and columns
      Premium Access
    • Capsule 2: Creating schemas using the Subtotals tool
      Premium Access
    • Capsule 3: Management of advanced filters I
      Premium Access
    • Capsule 4: Advanced Filter Management II
      Premium Access
    • Capsule 5: Dynamic Tables and Charts I
      Premium Access
    • Capsule 6: Dynamic Tables and Charts II
      Premium Access
    • Capsule 7: Dynamic Tables and Charts III
      Premium Access
    • Capsule 8: Creation of Dashboards
      Premium Access
    • Capsule 9: Procedures for eliminating duplicates
      Premium Access
    • Capsule 10: Validation of cells I
      Premium Access
    • Capsule 11: Validation of cells II
      Premium Access
    • Capsule 12: Creation of dependent validations
      Premium Access
    • Capsule 13: Procedure for separating text in columns
      Premium Access
    • Capsule 14: Procedure to consolidate several tables
      Premium Access
    • Capsule 15: Importing data using Power Query
      Premium Access
  • Module 3FunctionsII

    11 Capsules 02:22:48

    • Capsule 1: Assigning names to cells and ranges
      Premium Access
    • Capsule 2: Statistical functions with a criterion
      Premium Access
    • Capsule 3: Handling of the SEARCHV function
      Premium Access
    • Capsule 4: Handling the SEARCH function
      Premium Access
    • Capsule 5: Handling the SEARCARX function
      Premium Access
    • Capsule 6: Using the SEARCH function
      Premium Access
    • Capsule 7: Handling the CHANGE function
      Premium Access
    • Capsule 8: Handling the SI.ERROR function
      Premium Access
    • Capsule 9: Handling the CONCAT function
      Premium Access
    • Capsule 10: Handling of the functions MAYUSC, MINUSC and NOMPROPIO
      Premium Access
    • Capsule 11: Handling of the UNIRCADENAS function
      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 Intermediate Excel course

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

- 81%

BUY COURSE

US$ 2.90Previously US$ 15.00

OFFER EXPIRES ON:

0 :

Dias

00 :

Hrs

00 :

Mins

00

Segs
Add coupon

Forever

Develop your skills with us

- 81%

BUY COURSE

US$ 2.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