Microsoft Office

Basic Excel Course

Teacher: Sergio Bazo - Consultant and Instructor - Lernen Capacitaciones

  • Basic
  • 54633 students
  • 4.8
Start the course!

Co-certifies:

Online course description

Microsoft Excel is one of the main programs of the Office suite that allows the creation of tables and the management of databases. Its use has become an indispensable requirement for almost every job.

In the Basic Excel course we will start from scratch. We will first see the structure of the screen, then the process of entering data into the sheet, handling formats, designing formulas, handling the main basic statistical functions, creating graphs, handling basic database management tools and creating formats to be able to send documents to print from Excel.

What will I learn?

In this course you will learn the basic handling of the Microsoft Excel program, starting from scratch.

Who is it aimed at?

General public

Requirements

To follow this course you only need to have knowledge of Windows.

Contents of the Basic Excel course

  • Module 1Introductionto Excel

    3 Capsules 00:43:57

    • Capsule 1: What is a spreadsheet and what is it for?
      Free View
    • Capsule 2: The work area
      Premium Access
    • Capsule 3: Handling a book with multiple sheets
      Premium Access
  • Module 2Inputand edition of information

    2 Capsules 00:37:41

    • Capsule 1: Entry of texts, numbers, dates and times. Generation of automatic series.
      Premium Access
    • Capsule 2: Data editing
      Premium Access
  • Module 3Formats

    4 Capsules 00:45:13

    • Capsule 1: Application of font formats and alignment
      Premium Access
    • Capsule 2: Application of basic number and date formats
      Premium Access
    • Capsule 3: Handling cell styles
      Premium Access
    • Capsule 4: Table format handling
      Premium Access
  • Module 4Formulas

    6 Capsules 00:52:25

    • Capsule 1: Concept and components of a formula
      Premium Access
    • Capsule 2: Formulas with arithmetic operators
      Premium Access
    • Capsule 3: Formulas with comparison operators
      Premium Access
    • Capsule 4: Formulas using the concatenation operator or text union
      Premium Access
    • Capsule 5: Handling parentheses in a formula
      Premium Access
    • Capsule 6: Formulas using Relative, Absolute and Mixed References
      Premium Access
  • Module 5FunctionsI

    3 Capsules 00:30:09

    • Capsule 1: Definition and syntax of a function
      Premium Access
    • Capsule 2: Handling basic arithmetic functions
      Premium Access
    • Capsule 3: Handling the most commonly used rounding functions
      Premium Access
  • Module 6Graphs

    1 Capsules 00:44:40

    • Capsule 1: Definition of graph. Main types of graphs
      Premium Access
  • Module 7Database Management

    3 Capsules 00:38:35

    • Capsule 1: Basic concepts and structure of a database
      Premium Access
    • Capsule 2: Sorting database records
      Premium Access
    • Capsule 3: Filtering a database using AutoFilters
      Premium Access
  • Module 8Preparinga document before printing

    1 Capsules 00:14:21

    • Capsule 1: Adjusting the document before sending it for printing
      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 Basic 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