All Courses
Call Us (02) 8736-2032

CNCTC, Inc.

Your IT Career Starts Here. We build Achievers

T: (02) 8285-2936 / (02) 8351-1431 / 8736-5196
SMART: 09073576583 / 09993302327
GLOBE: 09776468236 / 09776932556

Email: cnctcinc@yahoo.com

CNCTC, Inc
Rm 210 Dona Amparo Bldg., Espana Blvd. corner G. Tolentino St. Sampaloc Manila

  • Home
  • About Us
  • All Courses
    • CISCO Training
      • CCNA Bootcamp
      • CCNP Enterprise Bootcamp
      • CCNP – ENCOR
      • CCNP – ENARSI
      • CCNP Security Bootcamp
      • CCNP – SCOR
      • CCNP – SSNGFW
    • SQL Databases
      • Introduction to SQL Databases
      • Querying Microsoft SQL Server
      • Database Design with Microsoft SQL Server
      • Database Administration Fundamentals
      • Administering Microsoft® SQL Server® 2014 Databases
      • Administering a SQL Database Infrastructure
      • Oracle Databases PL/SQL Language References
    • Python Programming
      • Python Programming for Beginners
      • Django Python Framework Bootcamp
    • Microsoft .NET Programming
      • Developing ASP.NET Core MVC Web Applications
      • Microsoft VISUAL BASIC.NET 2015
      • Programming with C# for Beginners
    • Java Programming
      • Java Programming Bootcamp – Complete Introduction
      • Java Spring Framework
    • PHP and MySQL
      • PHP & MySQL Programming
      • Laravel PHP Framework Programming
    • COMPTIA Courses
      • COMPTIA A+ Essentials and Practical application
      • COMPTIA Network+ bootcamp
      • CompTIA Security+
      • CompTIA CySA+
      • CompTIA Linux+
    • Linux Courses
      • LPIC-1 Linux Professional Bootcamp
      • LPIC-2 Linux Professional Bootcamp
      • Red Hat System Administration I
      • Red Hat System Administration II
      • Red Hat Certified System Administrator Bootcamp (Fast Track)
    • TESDA CSS NCII
      • PC Assembly, Hardware and Software Troubleshooting/Repair and Data Recovery w/ OJT
      • PC Networking and Administration
      • TESDA CSS NCII
    • Microsoft Office 365
      • MS-Word, Excel, Power point and Internet For Beginners
      • Microsoft Power BI Training
      • Microsoft Excel for Intermediate
      • Microsoft Excel for Advanced
      • Advanced Data Analysis using Excel
    • Microsoft Azure
      • Microsoft Azure Fundamentals
      • Microsoft Azure Administrator Associate
    • Microsoft Active Directory
      • Windows Server 2019 Administration
      • MCSA – Windows 2016 Server Bootcamp
    • VMware
      • VMware Certified Technical Associate – Data Center Virtualization 2021
      • VMware Certified Professional – Network Virtualization 2021
    • ITIL
      • ITIL Foundation v4
    • Mobile App Development
      • Android App Development Bootcamp
      • iOS App Development Bootcamp
    • Web Design and Dev
      • Vue.JS Application Development Fundamentals
      • JavaScript & JQuery for Beginners Training
      • Web Design with HTML and CSS
      • Web Design with WordPress (CMS) Training Course
    • Adobe Graphics Design
      • Adobe Photoshop CC
      • Adobe Illustrator CC
      • Adobe InDesign CC
      • Adobe Animate CC
    • Amazon Web Services
      • AWS Certified Solutions Architect – Associate
      • AWS Certified Cloud Practitioner Bootcamp
    • View All Courses
  • Schedules
  • Live Online Training
  • Enroll Now
    • Enroll a Course
    • Reserve a Course
    • Manage Reservations
    • Testing Center
    • Career Center
    • Our Clients
    • Verify Certificate
    • Evaluate Us
    • Facilities
    • Testimonials
  • Contact Us
GETQuotation
  • Home
  • Microsoft Office
  • Advanced Data Analysis using Excel
June 25, 2022

Advanced Data Analysis using Excel

by CNCTC / Sunday, 28 February 2021 / Published in Microsoft Office

Live Online
Classroom
1 on 1

Key Features

  • 1 day Instructor-Led Live Online Classroom
  • Webex Virtual Class for interactive near classroom experience
  • Access to Remote Lab PC for Hands-On activities
  • Unlimited Practice exams
  • In-House Testing Facility
  • Integrated Courseware in the Learning Management System
  • Step by Step guide for challenging hands-on lab activities
  • Flexible Schedules – Both Weekdays and Weekends Classes 
  • Get Trained by Excel Expert Trainer with Over 15 Years of Industry Experience
  • No. 1 Training Center for Data Analysis using Excel Courses
  • E-learning Access for Pre-course and Post Training Support 
  • Best Price Guaranteed for Data Analysis using Excel Courses

Key Features

  • 4 days Instructor-Led Face to Face Classroom training
  • We are a TESDA Registered Training Center
  • Offering Flexible Schedules – Both Weekdays and Weekends Classes
  • Get Trained by Excel Expert Instructor with Over 15 Years of Industry Experience
  • In-House testing Facility
  • No. 1 Training Center for Data Analysis using Excel Courses
  • We Guarantee Best Price for Data Analysis using Excel Courses

Key Features

  • Gain the technical skills needed in the workplace. 1 on 1 training is the best way to learn
  • Quickest way to master any of our course offerings.
  • Experience superb hands-on laboratory activities and unobstructed attention from your trainer.
  • Guaranteed to start the Training

TRAINEE FEEDBACKS

A great way to get a general overview of web designing. A complete class for those who want to understand the different areas of web designing.

Chito Esguerra
Makati City

Very nice learning experience. The trainer is exceptionally knowledgeable and friendly.

Mia Irish Zotomayor
PPP Center

The trainer is very knowledgeable about the subject matter and very supportive of the students learning capability.

Leandro Gabriel
Guam

He knows the subject matter really well and he is easy to get along with. You will feel at ease to ask questions about the topic. The staffs are very friendly and accommodating.

Maricar Cabrera
Metro Manila

The instructor is very competitive. The place is very conducive to learning.

RADIE INDONILLA
STRADCOM CORPORATION

Training at CNCTC is memorable and it’s worth the cost. Theories combined with real-life and industry-based application will really equip you in your field of specialization in IT. The Trainer plays an essential role in uplifting the quality of training at CNCTC. No dull moments. He masters his craft. He has a wide array of industry experience and the wit and wisdom to keep the hands-on training lively and beneficial to trainees. Thanks Sir for the knowledge, skills, and attitude you’ve imparted with us. Your labor for us is not wasted… WE LOOK FORWARD TO TRAINING SOON AT CNCTC IN OTHER TOPICS… MORE POWER TO YOU!

Raymond Cabrera
Central Luzon

Trainer is a solid instructor.. He can give practical example based on his experience. He gives ample amount of advise for his trainee to fully understand and absorb the details of discussion.

ernel zapanta
Las Pinas City

malinaw magturo…direct to point

Regino Velasquez
MMDA

Our Trainer was very supportive from the start until the end of the course program which is very appreciative. Thank you and all the best.

Enrico Andrada
Pasig City

Very knowledgeable on the course topic Excellent. Thank you for providing excellent training.

Erzelle Mercado
Professional Regulatory Commission

Very good and ready to answer questions where I’m confused about. I learned a lot especially for the technologies that are not familiar to me, now I’m more knowledgeable about networks. Thank you very much

Rovie Jerome Bascos
Caloocan City

Trainor is evidently highly skilled and is a master of the subject matter.

Byron Joseph Hallar
Mariano Marcos State University

Thanks a lot to CNCTC specially to our great instructor Sir Veva. For his effective teaching skills, full of useful information and techniques that will help anybody to it’s best understanding, very approachable and helpful instructor which he made learning a fun, interesting and meaningful experience. Two thumbs up for you Sir Veva! Thank you. Good luck for your future endeavor. God bless.

Marvin Garcia
Mandaluyong City

Very informative and professional on teaching. Great and awesome training center. “,)

Mark Clauden Agustin
Makati City

Ok dito.. magaling mga instructor nila. I’m totally zero knowledge on Active Directory before, after ko magtraining dito, nagamit ko naman pinag-aralan ko dito sa CNCTC.. Sana magkaroon sila ng SAP course, or ITIL..:)

JTC
Marikina City

Satisfied in all aspects. Excellent

Rizaldy Maray
STRADCOM CORPORATION

Thank you for a great trainer. Great presentation style with lots of opportunities to ask questions and talk about real-life troubleshooting scenarios which all made us for a really enjoyable and informative training course.

MARK JOSEPH ANGELO ALEJO
STRADCOM CORPORATION

I Recommend Mr. Roel as a Good Trainer, Friendly, Easygoing, knowledgeable, and Very Patient.

Very Accommodating and Nice staff.

Marchiame Pasco
Metro Manila

All in all, the training was great and the Instructor was excellent.

Engr Steve Gonzales
Pasay City

Kudos to the Trainer for being patient and understanding of his students’ proficiency on the entire course. Thank you.

Melissa Jolinda Lucas
Professional Regulatory Commission

Satisfied in all aspect. Excelent

Rizaldy Maray
STRADCOM CORP.

Thank you for a great trainer. Great presentation style with lots of opportunities to ask questions and talk about real life troubleshooting scenario which all made us for a really enjoyable and informative training course.

MARK JOSEPH ANGELO ALEJO
STRADCOM CORP.

CNCTC is a sure-win if you want to learn and improve your skills in computer and networking. Rating: 10/10.

JOSE RAMIL GABRONINO
Makati City

Ms./Mrs. Ma’am Cha! You tought us very well and you did excellent job. I am very happy that I completed this training under your very good discussion. I am very satisfied and very glad that you taught me well. Though it is just a short time but i learned a lot from you. Thanks for more patient to us. Keep up the good work! Thanks a lot.

Jackelyn Dinar
Metro Manila

The trainer did a very good job simplifying difficult material. Thank you.

A very enjoyable and meaningful experience at CNCTC keep up the good work. Thank you.

FRANK MAGAN
STRADCOM CORPORATION

The trainer’s approached is highly appreciated. Knows his course and provides additional informations. Training experience with CNCTC is absolutely recommendable.

Isaias Jefferson Sales
Saipem

The information that you have given me is what I believe to be some of the best available.

This was a thoroughly rewarding experience. I’ve gained new ice breaker strategies. Thank you so much CNCTC.

BANJO CRISTOBAL
STRADCOM CORPORATION

What an excellent instructor and I learned things that I did not know about.. including how to do things better than I have been. Again thank you very much.

“I am so impressed with CNCTC  the courses; the manuals which are actually usable, readable and understandable. SALAMAT…

ARNOLD TIA
STRADCOM CORPORATION

Ok ang price.

Filmark Torres
Makati City

Add Feedbacks

Request a Quote
Course Schedules

ABOUT THE COURSE:

This 1-day course equips you with the ability to analyze data and helps you come out with better decisions. Data Analysis using Microsoft Excel gives you the best analytical tool to analyze data by using the built-in pivot tables.

You will learn how to perform data analysis using Excel's most popular features such as the ff.

  1. Sort: You can sort your Excel data on one column or multiple columns. You can sort in ascending or descending order.
  2. Filter: Filter your Excel data if you only want to display records that meet certain criteria.
  3. Conditional Formatting: Conditional formatting in Excel enables you to highlight cells with a certain color, depending on the cell's value.
  4. Charts: A simple Excel chart can say more than a sheet full of numbers. As you'll see, creating charts is very easy.
  5. Data Analysis Function: A simple way to analyze sort of data.
  6. Pivot Tables: Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract the significance from a large, detailed data set.
  7. Tables: Tables allow you to analyze your data in Excel quickly and easily.
  8. What-If Analysis: What-If Analysis in Excel allows you to try out different values (scenarios) for formulas.
  9. Solver: Excel includes a tool called solver that uses techniques from operations research to find optimal solutions for all kinds of decision problems.
  10. Analysis ToolPak: The Analysis ToolPak is an Excel add-in program that provides data analysis tools for financial, statistical, and engineering data analysis.

WHO SHOULD ATTEND

This course is for organizations and individuals who are looking to automate data and forms for daily and monthly reporting. It is ideal for Office Staff, Fresh IT Graduates, IT Enthusiasts, and those who support and manipulate company data.

Prerequisite:

  • Deep knowledge and understanding of Basic MS Excel
  • Basic understanding of creating formulas and how cells are referenced by rows and columns within Excel

EMPLOYMENT OBJECTIVES

Upon completion of the course, students will be qualified to be data analysts, bookkeepers, office clerks.

COURSE CURRICULUM

Data Analysis using Excel Syllabus

Chapter 1 - Sort

  • Custom Sort Order
  • Sort by Color
  • Reverse List
  • Randomize List

Chapter 2 - Filter

  • Number and Text Filters
  • Date Filters
  • Advanced Filter
  • Data Form
  • Remove Duplicates
  • Outlining Data
  • Subtotal
  • Unique Values

Chapter 3 - Conditional Formatting:

  • Manage Rules
  • Data Bars
  • Color Scales
  • Icon Sets
  • Find Duplicates
  • Shade Alternate Rows
  • Compare Two Lists
  • Conflicting Rules
  • Heat Map

Chapter 4 - Charts and Data Analysis Functions

  • CONCATENATE
  • LEN
  • COUNT
  • DAYS/NETWORKDAYS
  • SUMIFS
  • AVERAGEIFS
  • VLOOKUP
  • FIND AND SEARCH
  • IFERROR
  • COUNTIFS
  • LEFT/RIGHT
  • RANK
  • MINIFS
  • MAXIFS
  • SUMPRODUCT

Chapter 5 - Pivot Tables

  • · Group Pivot Table Items
  • · Multi-level Pivot Table
  • · Frequency Distribution
  • · Pivot Chart
  • · Slicers
  • · Update Pivot Table
  • · Calculated Field/Item
  • · GetPivotData

Chapter 6 - Tables

  • Structured References
  • Table Styles
  • Quick Analysis

Chapter 7 - What-If Analysis

  • Data Tables
  • Goal Seek
  • Quadratic Equation

Chapter 8 - Solver

  • Transportation Problem
  • Assignment Problem
  • Capital Investment
  • Shortest Path Problem
  • Maximum Flow Problem
  • Sensitivity Analysis
  • Analysis

Chapter 9 - ToolPak

  • Histogram
  • Descriptive Statistics
  • Anova
  • F-Test
  • t-Test
  • Moving Average
  • Exponential Smoothing
  • Correlation
  • Regression

COURSE FEE

(₱8500) ₱ 6500
(USD175) USD 135

COURSE SCHEDULES

Current Month
Instructor-Led Live OnlineTraining or Classroom Training

sat02jul(jul 2)9:00 amsat30(jul 30)5:00 pmAdvanced Data Analysis using ExcelData Analysis9:00 am - 5:00 pm (30)

Data Analysis

Date and Time

2 (Saturday) 9:00 am - 30 (Saturday) 5:00 pm

Training Mode

Instructor-Led Live Online

Training or Classroom Training

Health Guidelines for Face to Face Classroom Training

Masks Required
Temperature Checked At Entrance
Physical Distance Maintained
Classroom Area Sanitized

Schedules

View All

Course Details

Learn More

Enroll Now

CalendarGoogleCal

Instructor-Led Live OnlineTraining or Classroom Training

sun03jul(jul 3)9:00 amsun31(jul 31)5:00 pmAdvanced Data Analysis using ExcelData Analysis9:00 am - 5:00 pm (31)

Data Analysis

Date and Time

3 (Sunday) 9:00 am - 31 (Sunday) 5:00 pm

Training Mode

Instructor-Led Live Online

Training or Classroom Training

Health Guidelines for Face to Face Classroom Training

Masks Required
Temperature Checked At Entrance
Physical Distance Maintained
Classroom Area Sanitized

Schedules

View All

Course Details

Learn More

Enroll Now

CalendarGoogleCal

Next Level Course

Microsoft Power BI Training

Call Us for more information

Tel: (+632) 8285-2936 / (+632) 8736-2032

Smart: 09073576583 / 09993302327

Globe: 09776468236 / 09776932556

GET STARTED

Request Course Quotation

Virtual/Webex Learning

Take advantage of CNCTC 's latest interactive Instructor-Led Live Online Training. Online Courses are delivered using WebEx to bring the classroom to your home or at your workplace and can be accessed directly on your own computer with an internet connection. By using Cisco’s WebEx, and integrating our Computer lab facilities, we can provide a near-classroom experience remotely to your own location of choice. Register Now!

Contact Us for a Demo

Popular Courses

  • A+
  • Network+
  • CCNA
  • CCNP
  • TESDA
  • Windows Server 2019 Administration
  • Linux
  • PHP
  • SQL Server
  • Java
  • Azure
  • Python
  • Database Administration Fundamentals

News and Articles

  • Career Center
  • News and Articles
  • Certification Exam Fees
TESDA
Pearson Vue Test Center
Facebook
blank
Verify Certificate
blank


CNCTC, Inc.: Main Office: Unit 301, 810 Galicia St. near corner Espana Blvd. Sampaloc, Manila 1008 Philippines
22+ years In Greater Metro Manila Area

Branch Office: 101C 18th Avenue Corner P Tuazon Ave. Cubao Quezon City 1109 Philippines

Email: cnctcinc@yahoo.com  Call Us: (02)  8736-2032 / (02)  8285-2936 |(02) 8351-1431 | 09993302327 | 09776932556   

ABOUT CNCTC

blank

Based in the University belt Area of Manila. CNCTC is a TESDA registered training center serving the IT Training needs of thousands of successful IT professionals and corporate clients from around the world. For the past 20 years of its operations, CNCTC provided superior quality of training and service to all. [Read More] 

FIND YOUR CLASS

blank
blank

Courses Offered


blank

Learning Methods


blank

Testing Center


COURSE CATEGORIES

  • CCNA Courses
  • CCNP Courses
  • TESDA CSS NCII
  • CompTIA
  • Linux
  • Microsoft Certifications
  • Microsoft .NET
  • Databases SQL
  • Java
  • Amazon Web
  • Azure Programming
  • PHP Programming
  • Python
  • ITIL Courses
  • VMware
  • C# Programming
  • Microsoft Office
  • Graphics Design
  • Mobile App Development
  • Network Security
  • PMP Certification
  • Web Design
  • GET SOCIAL
CNCTC, Inc.

Terms and Conditions | Privacy Policy
Copyright © 2000-2022. All rights reserved. | www.cnctc.edu.ph

TOP
X