Main Menu

Credit Cards

Our Partners


Authorized Pearson Vue Test Center



TESDA

Contest

  

Hands On IT TRAINING

MS EXCEL 2013-2016


26


Course Duration: 15 hours

Prerequisite: NONE

Description:

TRAINEES ARE EXPECTED TO EFFICIENTLY MANAGE SPREADSHEETS AND ANALYZE DATA FOR BUSINESS PRESENTATIONS, DATA STORAGE AND ANALYTICAL REPRESENTATION USING ONE OF THE WORLDS MOST POPULAR SPREADSHEET APPLICATION,

TOPICS COVERED:

MODULE 1: LEARNING MICROSOFT EXCEL 2013 / 2016

• Entering Data into Excel
• Displaying Experimental Data
• Basic Spreadsheet Operations
• Saving the File
• Setting up the Spreadsheet
• Tables and Graphs Formatting

MODULE 2: MICROSOFT EXCEL 2013 / 2016 in Business

• Evaluation Checklist
• Mathematical Models
• Plotting the Regression Results
• Frequency Distributions and Importing Data
• Column Charts of Frequency Distributions
• Sorting Data
• Summary of Statistical Analysis
• Graphical Analysis
• Regression Analysis
• Important Tips and Tricks for your Reports and Analysis
• Copying Figures or Tables as Pictures
• Table Borders in Word
• Calling Variables in Excel and Managing Them
• Selecting All Data in a Column
• Transposing Column Data into a Row
• Excel Scenarios
• Goal Seak
• Absolute Cell References
• Named Ranges in Excel
• Excel Pivot Table

MODULE 3: ADVANCED MICROSOFT EXCEL 2013 / 2016

• Customize the Interface
• Advanced Formatting: Custom Lists, Cell Groups, and Transposing Tables
• Reference Across Sheets
• Advanced Formulas and Using Data Ranges
• Using Data Validation

MODULE 4: MACROS IN EXCEL 2013 / 2016

MODULE 5: DATABASE DESIGN IN EXCEL 2013 / 2016



Other Short Courses..


What do you think?

Leave a Question

 



Inquiries

Page 1 of 3 | << | First | 1 - 2 - 3 - | Last | >> |


@ julna ofilan

Hello, thank you for your interest. We will open for Dec 4-6, Dec 11-13, Dec 18-20/ Mon to Wed 9am to 2pm. We require minimum of 3 participants for the class to push through.
@ Teresa Guibone

Thank you for your interest. MS Excel 2013-2016 training cost P3,800 cash. Yes, it will covers all the module 1-5 in 15 hours, good for 3 meetings. We have 2 branches located in Espana Manila and Buendia Makati. We will open for Dec 4-6, Dec 11-13, Dec 18-20, 2017. Minimum of 3 participants for the class to push through.
hi im interested po sa ms excel my sched po b kayo this coming dec??? thanks
HOw much is the course MS EXCEL 2013-2016? Will it covers the Module from 1 to 5 in 15hours? I am interested to take this course, where and is the training going to be held? Pls. send the dec. 2017 schedule of classes and venue. Thank you
@ Pau

P3,800 po ang course fee para sa lahat ng modules.
Kasama na po ba sa 3,800 yung 5 modules?
@ rosemarie hernandez

Ipopost po namin ang aming December schedule soon. Keep posted.
DEC SEMINAR SCHED PO MERON NA PO KAYA
@ Leah Collantes

We have open for Monday to Wednesday 9am to 2pm, every Saturday 3pm to 8pm and every Sunday 3pm to 8pm. MS Excel training cost P3,800 cash.
@ Sheryl

P3,800 is the course fee for MS Excel 2013-2016 training.
@ rosemarie hernandez

Unfortunately, wala pong kasamang meal. Training certificate at training manual lang po ang kasama sa P3,800.
@ rosemarie hernandez

The course fee is P3,800 cash.
Kindly send schedule of Advanced Excel Training and the training fee
how much is the excel training? http://www.cnctc.edu.ph/courses/item/ms-excel-2013-2016

Thans
anu po yung inclusions ng 3800? may meal n po b kasma yun?
how much po
Hi Please let us know before friday please.. as we have to arrange our accomodation, air tickets and much as to do on our work schedule arrangement.

Thank you
@ Krizel Buyuccan

Please see schedules below.

Espana, Manila

Sun 3-8pm 11-12-2017 to 11-26-2017
Sat 3-8pm 11-11-2017 to 12-25-2017
M to W 9-2pm 11-20-2017 to 11-22-2017
M to W 9-2pm 11-13-2017 to 11-15-2017

Buendia, Makati

M to W 9-2pm 11-20-2017 to 11-22-2017
M to W 9-2pm 11-13-2017 to 11-15-2017
Sun 3-8pm 11-12-2017 to 11-26-2017
Hi, Im interested on the course above but with your available dates, Do we have schedule on the 16-17th Nov?

Anticipating for your promt reply.

Thank you.
@ Yam

We will post soon our November weekend schedule. Please keep posted. Thanks.
Hi weekend schedule for the month of november?
@ Sam Lo Ang

Hello, we have open for Monday to Wednesday November 06-08, 2017, November 13-15, November 20-22, November 27-29, 2017. Minimum of 3 participants for the class to push through.
Hi! May we know the schedules this coming November?
Kindly send the schedule for the month of November
@ Melanie

Please see below the open schedules:
Espana, Manila
Days & Time Start Date End Date Status Enrolled Reserved
Sun 3-8pm 10-22-2017 11-05-2017 open -- --
Sat 3-8pm 10-28-2017 11-11-2017 open -- 3
M to W 9-2pm 10-23-2017 10-25-2017 open -- --
M to W 9-2pm 10-30-2017 11-01-2017 open -- --
Buendia, Makati
Days & Time Start Date End Date Status Enrolled Reserved
Sun 3-8pm 10-22-2017 11-05-2017 open -- 4
M to W 9-2pm 10-23-2017 10-25-2017 open -- --
M to W 9-2pm 10-30-2017 11-03-2017 open -- 1
Kelan po ulit magkakasched neto?
@ Christine Joy

Yes it's package and you will need to pay the whole amount.
What if I am already knowledgeable of the modules 1 - 2, can I just attend modules 3 - 5 or is it a package? Should I pay the whole amount of Php3,800.00?
@ Yam

Kailangan my basic knowledge na po kayo about MS Excel kasi advanced topic na po sa Excel ang ididiscuss. Ipopost namin ang aming November schedule soon.
Meron na po bang november sched? Thanks
Hi, kahit wala bang basic ms excel okay lang? Ididiscuss pa rin ba ang basic ms excel? Thanks
@ Sarah

You can register or make a reservation online through this link http://www.cnctc.edu.ph/reservation_form.php
Hi how can I register for this course?
@ Tin

Yes, cover na po all modules sa P3,800 na course fee good for 3 meetings.
@ divina

We do offer on-site training and it cost P3,800 cash per head. Thanks.
The 3,800 fee covers all modules na po ba for 1 day or 1 day per module?
how much is the fee if done on site (Excel) for our office in pasay, around 10 pax.
@ Adonis Suarnaba

The fee is 3800 pesos in cash. Please see schedule below.

Espana, Manila

Sun 3-8pm 10-01-2017 to 10-15-2017
Sat 3-8pm 09-30-2017 to 10-14-2017
M to W 9-2pm 10-09-2017 to 10-11-2017
M to W 9-2pm 10-16-2017 to 10-18-2017

Buendia, Makati

Sun 9-2pm 10-01-2017 to 10-15-2017
M to W 9-2pm 10-02-2017 to 10-04-2017
M to W 9-2pm 10-09-2017 to 10-11-2017
Tue to Thur 9-3pm 08-22-2018 to 08-24-2018
When will be the next session and how much?
@ Liez

We will post our October and November schedule soon. Please keep posted for the updates.
Please email me for your october and november sched. Thank you
@ sarah,

We will post our October schedules soon. Keep posted.
Good day!
Do you have schedules on Oct 2017?
@ Rejoice A. Pallan

P3,800 cash po ang course fee ng Advanced MS Excel training.
Just want to inquire about the course, magkano po ba? Is there any free or cheaper training for me?
@ MARIZA L ARQUIZA

Please see schedules below.

Espana, Manila

Sun 3-8pm 09-17-2017 to 10-01-2017
Sat 3-8pm 09-09-2017 to 09-23-2017

Buendia, Makati

Sun 9-2pm 09-03-2017 to 09-17-2017
Good Morning, im interested with your course may i know your schedules for this year? thanks
@ gary

Magkakaroon po kami ng November schedule. Ipopost namin soon. Keep posted for the updates.
im interested of this course because i need this in my work.. im here in abroad now, im back to manila this coming november i wish i could get a schedule for november.. please send me an email garyfacturanan@gmail.com .. thank you..
hi.. ask ko lng meron schedule for the month of november?
Page 1 of 3 | << | First | 1 - 2 - 3 - | Last | >> |

  
CNCTC Live Chat Inquiry

Job Openings

Subscribe

Stay Informed Subscribe

Name *

Email *