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 | >> |


@ 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?
@ Audrey

The fee is 3800 pesos in cash, 15 hours duration of the course.
how much is the fee? and how long is the duration of this course?
@ May V. Sipin

Please see schedules below.

Espana, Manila

Sun 3-8pm 08-27-2017 to 09-10-2017
Sat 3-8pm 09-09-2017 to 09-23-2017

Buendia, Makati

Sun 9-2pm 09-03-2017 to 09-17-2017
@ verenica ebona

You can make your reservation online through this link http://www.cnctc.edu.ph/reservation_form.php
@ Giz Kaw

Please make your reservation online through this link http://www.cnctc.edu.ph/reservation_form.php . The course fee is 3800 pesos in cash.
Do you have Training Schedule in Advanced Excel on September or October? Thanks!
Do you have Advanced Excel Training on September or October?
requesting for reservation of excel2013-2106 september 3,2016: Thanks
Hi! How to enroll for your http://www.cnctc.edu.ph/courses/item/ms-excel-2013-2016 class? And how much does it cost.
Thanks
@ eloisa

Please see schedules below.

Espana, Manila

Sat 3-8pm 08-19-2017 to 09-02-2017
Sun 3-8pm 08-20-2017 to 09-03-2017

Buendia, Makati

Sat 3-8pm 08-19-2017 to 09-02-2017
kelan po ang earliest schedule for this program?
@ Jiona Macalatan

Hello, we will post soon our September schedule. Please keep in touch for any updates. Thank you.
Hi, my schedule na po ba for September for advance excel?
@ salve

An email has been sent to you detailing the course quotation. Thank you.
@ salve piol

Yes, the course fee is P3,800 per head.
May we kindly request to send us your quotations? Here's my email address: salve.piol@amecfw.com
Thank you.
3,800 per participants? Our office located here in Alabang area, Thank you
@ Vera Jill Asensi

Thank you for your interest. The course fee for Advanced MS Excel is P3,800. We have open Saturday 3pm to 8pm/August 05 to August 19, 2017, Sunday 9am to 2pm/August 06 to August 27, 2016. Minimum of 3 participants for the class to push through. Thank you.
Hello,
Interested to attend this course.
May we know the next available schedule near Makati as well as the training fees?
Thank you!
@ Zen

Please make a reservation online through this link http://www.cnctc.edu.ph/reservation_form.php
Hi! Interested po ako to take the course.
Any reservations?
@ Andy

Ipopost po namin ang aming August schedule soon. Yes bibigyan namin kayo ng training manual on the first day of the class.
Good day! Pwede pong magpa send ng next schedule nito if meron around August onwards? Kung sakali po ba sa Makati Branch ang training nito? Also, are we getting a manual or resources when we join the training?
@ Jose Germyn Tuazon

Noted on this.
Good Afternoon.

Our company is looking for a training center for Microsoft Excel. Please send me your schedule and rate?Do you have facilities like 1 pc/person for oral application of excel.
@ Crisel

Yes the Vlookup, slicers, pivot, macros etc. are included in MS Excel training. The fee is 3800 pesos in cash, 15 hours duration good for 3 days training.
Hi, I'm interested to take Ms excel course. Do you have schedule in August? Also, does this training include Vlookup, slicers and other advance command?
Please send me the details including fees.
Thank you so much
@ Fathalarhman

Our Main office is located @ Rm 210 Dona Amparo Bldg., Espana Blvd. corner G. Tolentino St. Sampaloc Manila and our branch office is located Rm 208 UPY Bldg., Gil Puyat Ave. (formerly Buendia Ave) corner Marconi St. Palanan Makati City.
I am looking for excel course
can you send to me your address company
@ jayson

Yes, mag-oopen po kami para sa June schedule and the course fee for MS Excel is P3,800 cash.
Do you have training for june and how much
@ Camille

Yes, please see schedule below.

Espana, Manila

Sun 3-8pm 05-14-2017 05-28-2017
Sat 3-9pm 06-03-2017 06-17-2017

Buendia, Makati

Sun 9-2pm 05-14-2017 05-28-2017
M to W 9-2pm 05-15-2017 05-17-2017
Hi,

Do you have a class schedule this May?

Thanks,
Camille
@ Myka Karizza G. Rino

Please see schedule below.

Buendia, Makati

Sun 9-2pm 04-23-2017 to 05-14-2017

You can make your reservation through this link http://www.cnctc.edu.ph/reservation_form.php
I want to reserve for this course. Do you have an avail training slot for April 2017? I'd be willing to take your classes in Buendia.
@ bernalyn basilan

Our Main office is located @ Rm 210 Dona Amparo Bldg., Espana Blvd. corner G. Tolentino St. Sampaloc Manila.
san po ang exact address nyo po sa espana? gusto ko po umattend sa sat. salamat po.
@ Cj pacis

Hi, Wala pong requirements na kailangan dalhin pag nag-enroll. Ipopost po namin soon dito sa website angs schedule after ng April. Salamat.
Page 1 of 3 | << | First | 1 - 2 - 3 - | Last | >> |

  
CNCTC Live Chat Inquiry

Subscribe

Stay Informed Subscribe

Name *

Email *