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:  Data Tools in Excel

  • Text to Columns
  • Flash Fill
  • Remove Duplicates
  • Data Validation
  • Consolidate

Module 2:  Advanced Conditional Formatting

  • Editing Standard Formatting Rules
  • Using Formulas in Conditional Formatting

Module 3:  Working with Functions and Formulas

  • Autosum Functions (SUM & AVERAGE)
  • IF and Nested Functions
  • Working with Named Ranges
  • Array Functions (SUMIF & AVERAGEIF)
  • Formula Auditing
  • Formulas with Absolute References
  • Text Functions

Module 4:  Sparklines

  • Creating Sparklines
  • Editing Sparklines

Module 5:  Data Manipulation with Pivot Tables 

  • Creating Basic Pivot Tables
  • Grouping Pivot Data
  • Calculated Fields in Pivot Tables
  • Filtering Pivot Data
  • Changing the Pivot Table Display Methods

Module 6:  Advanced Charting Features

  • Creating Combination Charts
  • Displaying a Secondary Axis
  • Modifying Axis Options
  • Display Data Trends
  • Charting an Acceptable Range
  • Charting Targets

Module 7:  Specialist Functions and Formulas

  • Nested IF Statements Using the AND and OR Operators
  • VLOOKUPs
  • The MATCH Function

Module 8: MSEXCEL 2016 VBA ADVANCED

  • Advanced Procedures
  • Advanced Variables
  • Debugging and Error Traps
  • Creating Custom User Forms
  • Workbook and Worksheet Events




Other Short Courses..


What do you think?

Leave a Question

 



Inquiries

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


@ Jane D

Hello. Yes, meron po kami open na schedule sa Buendia Makati.
Hi may Makati branch ba kayo for training? Thank you.
@ Juliefer Zuniega

Yes but we suggest you to make a reservation through this link http://www.cnctc.edu.ph/reservation_form.php so that we can advise you 2 days before if the class will push through or not. We need a minimum of 3 participants for the class to start.
Hi Sir/Madam,

Do you accept walk-in enrollees? because I am not sure yet when will I become available. Hoping to hear from you soon. You can text me at 09166558941.
@ Erica Joy David

Please see schedules below.

Espana, Manila

Sun 3-8pm 01-14-2018 to 01-28-2018
Sat 3-8pm 01-13-2018 to 01-27-2018
M to W 9-2pm 01-22-2018 to 01-24-2018
M to W 9-2pm 01-15-2018 to 01-17-2018

Buendia, Makati

M to W 9-2pm 01-29-2018 to 01-31-2018
Sat 3-8pm 01-13-2018 to 01-27-2018
M to W 9-2pm 01-15-2018 to 01-17-2018
M to W 9-2pm 01-22-2018 to 01-24-2018
Sun 9-3pm 01-14-2018 to 01-28-2018
@ Mutya Fajalin

Yes magkakaroon kami ng schedule for February. Ipopost po namin soon. Keep posted for the updates.
@ Pedro Mar Mitra

For the basic training we suggest you to take first the MS Office training. You can make a reservation through this link http://www.cnctc.edu.ph/reservation_form.php
May next schedule pa po ba?
Hello good eve just wanted to ask if may available schedule pa kayo by february 2018.Thank you
hi im interested in your training about microsoft excel, since ill already forgot the basic excel, kindly assist what training will i take and when is the earliest schedule this january, because im applying for a position which required microsoft excell, thanks..
@ Grace

Yes meron po. Ang fee ay 3800 pesos in cash. Please see below schedules.

Espana, Manila
Sun 3-8pm 01-07-2018 to 01-21-20181
Sat 3-8pm 01-06-2018 to 01-20-2018
M to W 9-2pm 12-18-2017 to 12-20-2017
T to Th 9-2pm 01-02-2018 to 01-04-2018
M to W 9-2pm 01-08-2018 to 01-10-2018
M to W 9-2pm 01-15-2018 to 01-17-2018
Hi.

May schedule po ba kayo ng MS Excel 2013-2016 Training on the 2nd week of January 2018?

If then, how much yung training fee?
@ Kat Echavez

Hello! Yes, included po ang macros sa MS Excel training.
Hi, included po ba yung macros sa excel course?
@ Michael bacolor

Hello. Thank you for your interest. The course fee for MS Excel training is P3,800 cash. You can make a course reservation through this link http://www.cnctc.edu.ph/reservation_form.php

Thank you.
@ Grace

Hello. The computer was already available during the training, but you can bring your own laptop if you want. Thanks.
HI

IM HIGHLY INTERESTED IN YOUR TRAINING COURSE IN EXCEL 2013-2016 pls send me the details asap if

Thanks
Hi thank you for getting back to me. May I know if the laptop are already included at the training or do we need to bring our own laptop? Thank you.
@ Grace Bernaldez

Hi, open pa po ang enrollment ng Dec 11-13 at Dec 18-20. Gawa po kayo ng reservation sa link na ito http://www.cnctc.edu.ph/reservation_form.php

Thank you.
@ Eds Aquino

Hi, yes meron po at open ang enrollment ng Sunday schedule. P3,800 cash po ang course fee ng Advanced MS Excel training.
Hello may slot pa po ba on Dec 11-13 or Dec 18-20? Gusto ko po sana mag pareserve ako at ang pinsan ko. Please send me email for the details. Thank you
Hi, meron pabang sunday sched for dec? and how much
@ Irene Manrique

Hi, our office is located at Our Branch office is located @ Rm 208 UPY Bldg., Gil Puyat Ave. (formerly Buendia Ave) corner Marconi St. Palanan Makati City. Please make a course reservation through this link http://www.cnctc.edu.ph/reservation_form.php

Thank you.
Hello po , ask ko lang san po sa Buendia? and papa sched sana ko Sun 3-8pm
@ ivy grace tibay

Yes, may slot pa po. Please see schedules below.

Espana, Manila

Sun 3-8pm 12-10-2017 to 01-07-2018
Sat 3-8pm 12-09-2017 to 01-06-2018
M to W 9-2pm 12-11-2017 to 12-13-2017
M to W 9-2pm 12-18-2017 to 12-20-2017

Buendia, Makati

M to W 9-2pm 12-11-2017 to 12-13-2017
M to W 9-2pm 12-18-2017 to 12-20-2017
Sun 3-8pm 12-10-2017 to 01-07-2018
Hi for excel training 2016 may slot pa ba for this dec? Can you give training schedule?
@ rosemarie hernandez

Next schedule po is on December 11 to 13, 2017 sa ngayon kayo palang po ang nakareserved.
kelan po yung confirmed weekdays schedule nyo this December
@ rosemarie hernandez

Unfortunately, reschedule po ang MS Excel training both in Espana Manila and Buendia Makati.
hoping you will have a confirmed schedule this mon to wed kahit po makati area.
@ Ruby Ambrosio

Yes, mag-oopen po kami ng weekends schedule para sa 2018. Please keep in touch po para sa update. Thank you.
@ roel

P3,800 cash po ang course fee. Meron po kami sa Espana Manila at Buendia Makati. Open po ang every Saturday at every Sunday schedule at makakatanggap po kayo ng certificate of completion after ng training.
Good morning! May schedule na po ba kayo for 2018, say for the last 2 weekends of January?
Thank you.
may Certificate po bang kasama? Please let me know, need ko po sana this dec, tapos weekend, meron po ba? gusto ko sana mag enrol...
magkanu po at sang branch merong training na to? weekend po ba meron sa December?
@ Daisy Vela

Hello, ang weekend schedule po namin ay magkaiba ang pasok ng every Saturday at every Sunday.
Hi. wala po kayo dec sched ng pang sat sun? thanks
@ slane reyes

P3,800 cash po ang course fee ng MS Excel training.
how much is the seminar fee on this training?
@ ROSEMARIE HERNANDEZ

Yes, you can make your reservation online through this link http://www.cnctc.edu.ph/reservation_form.php
DO YOU HAVE EXCEL 2013 TO 2016 SCHED THIS DEC 4 TO 6
@ 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.
Page 1 of 4 | << | First | 1 - 2 - 3 - 4 - | Last | >> |

  
CNCTC Live Chat Inquiry

Job Openings

Subscribe

Stay Informed Subscribe

Name *

Email *