Teacher: Sergio Bazo - Consultant and Instructor - Lernen Capacitaciones
Co-certifies:
In the Advanced Excel course we will start by looking at the handling of more text functions, database management, conditional functions such as the IF function, AND function and OR function. Then you will learn how to use important analysis tools such as the Scenario Manager and the SOLVER tool. In addition, you will learn procedures to protect your information in Excel. Then we will see the procedure to design forms. Finally we will know what macros are and we will learn how to use the macro recorder.
In this course you will learn how to use advanced Excel functions and tools.
General public
To take this course you must have intermediate knowledge of Excel. Preferably you should have taken Netzun's Basic and Intermediate courses.
12 Capsules 03:01:21
3 Capsules 00:20:34
4 Capsules 00:44:17
3 Capsules 00:56:55
2 Capsules 00:22:21
Final examTo obtain your course pass certificate, you will have 2 attempts per day to pass a multiple-choice exam with more than 70%.
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.
*San Ignacio University will certify all NETZUN students.
Benefits
Full access to course videos
Downloadable materials
Forum with other students
Certificate of Completion
US$ 2.90Previously US$ 15.00
OFFER EXPIRES ON:
0 :
Dias00 :
Hrs00 :
Mins00
SegsForever
US$ 2.90 Previously US$ 15.00
OFFER EXPIRES ON:
0 :
Dias00 :
Hrs00 :
Mins00
Segs
USD
