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
  • Microsoft Excel for Intermediate
June 25, 2022

Microsoft Excel for Intermediate

by CNCTC / Tuesday, 11 January 2022 / Published in Microsoft Office
Intermediate Excel
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
  • 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 Certified Office 365 Trainer with Over 15 Years of Industry Experience
  • No. 1 Training Center for Office 365 Courses
  • Best Price Guaranteed for Office 365 Courses

Key Features

  • 1 day 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 Certified Certified Office 365 Trainer with Over 15 Years of Industry Experience
  • No. 1 Training Center for Office 365Courses
  • We Guarantee Best Price for Office 365 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

Thank You, I learned a lot. I’m very happy with the training and I recommend CNCTC if you want to learn more on Computer Networking… Thanks!

Noel Cruz
Quezon City

What I like here in CNCTC is that even though the training is somewhat fast, i was able to learn alot in just a short period of time. Also the fee in the training is not that expensive compare to other training centers.

CARLA JEAN PINILI
Metro Manila

Thank You. I learned a lot. I’m very happy with the training and I recommend CNCTC if you want to learn more on Computer Networking… Thanks!

Noel Cruz
Quezon City

Perfect training. Trainer is awesome and professional. I learned a lot. Very inspiring! Thanks also for the unlimited coffee =) CNCTC is the BEST!

Brian Retuta
Metro Manila

THANK YOU.  VERY EFFECTIVE TEACHER,, LEARN A LOT

Om R. Merchadani
Pasay City

Highly recommended to anyone who is looking to boost their career. Trainer has positive attitude and wonderful teaching style. Thank you CNCTC for sharing your expertise.

Athena Garcia
Bonifacio Global City

Thank you Sir!! Hope to see you again for my next training. CNCTC- Keep up the good work in providing excellent training to students.

Jene
Central Luzon

The Instructor is very accommodating. I don’t have any hesitation to ask if I have some questions. I have learned a lot. Keep up the good work!

Joel Fuentebella
Mandaluyong City

sulit ka!!!!,,,

dann
Las Pinas City

The training is very informative. Thank you.

Cyrine Ravina
Manila

Outstanding trainer. Shared most of his knowledge in his career and course curriculum. Thank you very much!

Andrew Delfin Carabeo
Paranaque City

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

Byron Joseph Hallar
Mariano Marcos State University

The Trainer is very good and simple style of teaching but very very effective.

Jayson Matienzo
Metro Manila
Request a Quote
Course Schedules

ABOUT THE COURSE

This 1-day course is designed specifically for Intermediate level. This will be your next step in learning how to be efficient in Microsoft Excel. Training is more on the actual implementation of MS Excel in making spreadsheets for office data purposes.

WHO SHOULD ATTEND

This course is for organizations and individuals who are looking to create and manage MS Excel Spreadsheets. It is ideal for Office Staffs, Fresh IT Graduates, IT Enthusiasts, and to those who support and manipulate company data.

COURSE OUTCOME

After completing this course you will learn how to:

  • Learn to use formulas and functions.
  • Create and modify charts.
  • Convert, sort, filter, and manage lists.
  • Insert and modify illustrations in a worksheet.
  • Learn to work with tables.
  • Learn to use conditional formatting and styles.

ENTRY REQUIREMENTS

Introduction to MS Excel for Beginners

OCCUPATIONAL OBJECTIVES

Upon completion of the course, students will be qualified to be a data analyst, bookkeeper, office clerk

COURSE CURRICULUM

Microsoft Excel for Intermediate Syllabus

Chapter 1: Advanced Formulas

  • Using Named Ranges in Formulas
  • Naming a Single Cell
  • Naming a Range of Cells
  • Naming Multiple Single Cells Quickly
  • Using Formulas That Span Multiple Worksheets
  • Using the IF Function
  • Using AND/OR Functions
  • Using the SUMIF, AVERAGEIF, and COUNTIF Functions
  • Using the PMT Function
  • Using the LOOKUP Function
  • Using the VLOOKUP Function
  • Using the HLOOKUP Function
  • Using the CONCATENATE Function
  • Using the TRANSPOSE Function
  • Using the PROPER, UPPER, and LOWER Functions
  • The UPPER Function
  • The LOWER function
  • The TRIM Function
  • Using the LEFT, RIGHT, and MID Functions
  • The MID Function
  • Using Date Functions
  • Using the NOW and TODAY Functions
  • Creating Scenarios
  • Utilize the Watch Window
  • Consolidate Data
  • Enable Iterative Calculations
  • What-If Analyses
  • Use the Scenario Manager
  • Use Financial Functions

Chapter 2: Working with Lists

  • Converting a List to a Table
  • Removing Duplicates from a List
  • Sorting Data in a List
  • Filtering Data in a List
  • Adding Subtotals to a List
  • Grouping and Ungrouping Data in a List

Chapter 3: Working with Illustrations

  • Working with Clip Art
  • Using Shapes
  • Working with SmartArt

Chapter 4: Visualizing Your Data

  • Creating a Custom Chart Template
  • Inserting Charts
  • Add and Format Objects
  • Insert a Text Box
  • Create a Custom Chart Template

Chapter 5: Working with Tables

  • Format Data as a Table
  • Move between Tables and Ranges
  • Modify Tables
  • Define Titles

Chapter 6: Advanced Formatting

  • Applying Conditional Formatting
  • Working with Styles
  • Creating and Modifying Templates

Chapter 7: Microsoft Excel Features that Were New in 2013

  • New Functions in Excel 2013
  • Using New Chart Tools
  • Using the Quick Analysis Tool
  • Using the Chart Recommendation Feature

Chapter 8: Features New in 2016

  • New Charts
  • Treemap
  • Sunburst
  • Histogram
  • Waterfall
  • Box and Whisker
  • Pareto

COURSES FEE

(₱5500) ₱ 3800
(USD110]) USD80

COURSE SCHEDULES

Current Month
Instructor-Led Live OnlineTraining or Classroom Training

mon27jun9:00 am5:00 pmMicrosoft Excel for IntermediateOffice 3659:00 am - 5:00 pm

Date and Time

(Monday) 9:00 am - 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

sat02jul9:00 am5:00 pmMicrosoft Excel for IntermediateOffice 3659:00 am - 5:00 pm

Date and Time

(Saturday) 9:00 am - 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

mon04jul9:00 am5:00 pmMicrosoft Excel for IntermediateOffice 3659:00 am - 5:00 pm

Date and Time

(Monday) 9:00 am - 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

Enroll Now

Next Level Course

Microsoft Excel for Advanced

Call Us for more information

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

Smart: 09993302327

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

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

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