Advanced Data Analysis using Excel

/ / Published in Microsoft Office

Key Features

  • 4 days 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

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

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

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

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

Satisfied in all aspect. Excelent

Rizaldy Maray
STRADCOM CORP.

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

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

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

Erzelle Mercado
Professional Regulatory Commission

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

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

Engr Steve Gonzales
Pasay City

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

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

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

Byron Joseph Hallar
Mariano Marcos State University

malinaw magturo…direct to point

Regino Velasquez
MMDA

Ok ang price.

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

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.

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

Satisfied in all aspects. Excellent

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

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

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

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

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 instructor is very competitive. The place is very conducive to learning.

RADIE INDONILLA
STRADCOM CORPORATION

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

Leandro Gabriel
Guam

Add Feedbacks

Request a Quote
Course Schedules

ABOUT THE COURSE:

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

(₱12500) ₱ 10500
(USD260) USD 220

COURSE SCHEDULES

mon20sep(sep 20)9:00 ammon18oct(oct 18)3:00 pmAdvanced Data Analysis using ExcelData Analysis9:00 am - (october 18) 3:00 pm

sat25sep(sep 25)9:00 amsat23oct(oct 23)3:00 pmAdvanced Data Analysis using ExcelData Analysis9:00 am - (october 23) 3:00 pm

mon27sepfri01octAdvanced Data Analysis using ExcelData Analysis9:00 am - (october 1) 5:00 pm

mon04octmon01novAdvanced Data Analysis using ExcelData Analysis(october 4) 9:00 am - (november 1) 3:00 pm

Next Level Course

Microsoft Power BI Training

Call Us for more information

Tel: +632-87362032 /+632-87356579

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