Microsoft Office

Course on Excel Practical Exercises

Teacher: Sergio Bazo - Consultant and Instructor - Lernen Capacitaciones

  • Intermediate
  • 33995 students
  • 4.7
Start the course!

Co-certifies:

Online course description

Would you like to get more practice and maximize your Excel skills? Then this course is for you. Practice makes perfect. During this course you will be able to develop more exercises where you will be able to test everything you have learned about Excel. At the end of the course, you will have the opportunity to develop a learning project (optional).

What will I learn?

You will learn how to manage Excel with more security and confidence.

Who is it aimed at?

Alumni of Netzun's Excel courses.

Requirements

Have taken Netzun's Basic, Intermediate and/or Advanced Excel courses.

Course content Practical excel exercises

  • Module 1BasicExcel Exercises

    6 Capsules 00:51:24

    • Capsule 1: Teacher's presentation
      Free View
    • Capsule 2: Formatting exercises
      Premium Access
    • Capsule 3: Exercises on formulas
      Premium Access
    • Capsule 4: Exercises on basic mathematical and statistical functions
      Premium Access
    • Capsule 5: Exercises on graphics design
      Premium Access
    • Capsule 6: Sorting and Filtering Exercises
      Premium Access
  • Module 2IntermediateExcel Exercises

    8 Capsules 01:25:43

    • Capsule 1: Exercises on Conditional Formatting
      Premium Access
    • Capsule 2: Exercises on Subtotals
      Premium Access
    • Capsule 3: Exercises on Advanced Filters and the FILTER function
      Premium Access
    • Capsule 4: Exercises on Cell Validation and the DESREF function and the INDIRECT function
      Premium Access
    • Capsule 5: Exercises on text separation in columns
      Premium Access
    • Capsule 6: Table consolidation exercises
      Premium Access
    • Capsule 7: Exercises on handling statistical functions with one condition
      Premium Access
    • Capsule 8: Exercises on handling search functions
      Premium Access
  • Module 3AdvancedExcel Exercises

    8 Capsules 01:36:02

    • Capsule 1: Exercises on handling text functions
      Premium Access
    • Capsule 2: Exercises on handling database functions (DB)
      Premium Access
    • Capsule 3: Exercises on handling statistical functions with various conditions
      Premium Access
    • Capsule 4: Exercises on handling logic functions
      Premium Access
    • Capsule 5: Exercises on nested functions
      Premium Access
    • Capsule 6: Exercises on Analysis Tools
      Premium Access
    • Capsule 7: Form Controls Exercises
      Premium Access
    • Capsule 8: Macro Recording Exercises
      Premium Access
  • Module 4PivotTables Exercises

    5 Capsules 00:55:13

    • Capsule 1: Exercises on simple Pivot Tables
      Premium Access
    • Capsule 2: Exercises on Pivot Tables with calculated fields and elements
      Premium Access
    • Capsule 3: Exercises on segmentation tables and time scales in one or more pivot tables
      Premium Access
    • Capsule 4: Exercises on dashboard creation using segmentation charts, time scales, dynamic graphs and shapes
      Premium Access
    • Capsule 5: Creating pivot tables from various data sources
      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 Practical Excel Exercises

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