CETPA Infotech Pvt Ltd
CETPA Infotech Pvt Ltd Logo

ADVANCE EXCEL TRAINING 

  • Private Institute

ADVANCE EXCEL TRAINING
 at 
CETPA Infotech Pvt Ltd 
Overview

Duration

60 hours

Mode of learning

Online

Schedule type

Self paced

Official Website

Go to Website External Link Icon

Credential

Certificate

ADVANCE EXCEL TRAINING
 at 
CETPA Infotech Pvt Ltd 
Highlights

  • Get Expert in Excel
  • Training methodology which is easy to follow.
  • Training on Advanced Excel Methods
  • Real time training so that you can quickly put methods into practice
  • Online Instructor Led Training as well as Classroom Training available
  • Get Guidance from Expert Trainers
Read more
Details Icon

ADVANCE EXCEL TRAINING
 at 
CETPA Infotech Pvt Ltd 
Course details

What are the course deliverables?
  • Microsoft Excel learners gets recognized in the organization
  • It brings efficiency in work life.
  • Excel still rules industry when it comes to spread sheet usage in business.
  • Adds great value to one’s resume
More about this course
  • Microsoft Excel is a powerful tool which allows to manipulate large amount of data, automate tasks, and present complex information.
  • CETPA is an ISO 9001-2015 certified training company and is the official training partner of Microsoft.
  • Student will be trained from Industry expert and according to Microsoft’s Advanced Excel course curriculum.
  • In addition to that student will also get training certificate from Microsoft

ADVANCE EXCEL TRAINING
 at 
CETPA Infotech Pvt Ltd 
Curriculum

ADVANCE FUNCTIONS OF EXCEL

Logical Function: IF / ELSE, AND, OR, NOT, NESTED IF/ELSE

Date and Time Functions: DATE, DAY, SECOND, MINUTES, HOURS, NOW, TODAY, MONTH, YEAR

Information Functions: ISBLANK, ISERROR, ISEVEN, etc.

Math Functions: RAND, ROUND,

CEILING, FLOOR, INT, LCM, MOD, EVEN, SUMIF, SUMIFS

Statistical Functions: AVERAGE, AVERAGEIF, COUNT, COUNTA, COUNTBLANK, COUNTIF, MAX , MIN

Text Functions: LEFT, RIGHT, TEXT, LOWER, UPPER, PROPER, REPLACE, REPT, FIND, SEARCH, SUBSTITUTE, TRIM, CONCATENATE

CONDITIONAL FORMATTING

Using Conditional Formatting

Using Conditional Formatting with Multiple Cell Rules

Using Colour Scales in Conditional Formatting

Highlighting Duplicate

Creating New Rules and Managing Existing Rules

DATA SORTING AND FILTERING

Sorting Data A-Z and Z-A

Using Filters to Sort Data

Advance Filtering Options

PIVOT TABLES

Creating Pivot Tables

Using Pivot Table Options

Changing and Updating Data Range

Formatting Pivot Table

CONCEPT OF CELL REFERENCING:-

Relative

Absolute

Mixed

VLOOKUP & HLOOKUP

Using VLOOKUP & HLOOKUP from same sheet

Using VLOOKUP & HLOOKUP from other sheet

Using VLOOKUP & HLOOKUP from other workbook

Using VLOOKUP with MATCH

CHARTS

Column Chart

Pie Chart

Line Chart

Shortcut Of Chart

MODULE-2 (ADVANCE EXCEL)

INDEX & MATCH

Using Index and Match to find LEFT column Values

Using MATCH to make the column dynamic

OFFSET

Using OFFSET to make reports dynamic

Using OFFSET to make Name Range Dynamic

Using OFFSET to make PIVOT Table dynamic

NAME MANAGER

3 methods of Creating Range name

Making Range Name Dynamic/li>

DATA VALIDATION

Custom Validation

Multilevel Data Validation

Input Message

Error Alert

DATA COSOLIDATION

Data Consolidation

3D Formulas

WHAT-IF ANALYSIS

Scenario Manager

Goal Seek

Data Table

NEW FEATURES OF 2010

Sparkline

Slicer

FLASH Fill

PANES PROPERTIES

Freeze Panes & Unfreeze Panes

Split Panes

SORTING

Sorting

Custom Sort

Sort on Custom List

Sort on Colour

PASTE SPECIAL FEATURES

SHARE & PROTECT WORKBOOK AND WORKSHEET

Protection of whole sheet

Protection of a range

Protection of a cell

Sharing a workbook

Watching the Changes by Users

Accepting or Rejecting the Changes

DATA ANALYSIS

Correlation

Histogram

Pareto Analysis

Other courses offered by CETPA Infotech Pvt Ltd

– / –
60 hours
– / –
3 months
– / –
    – / –
– / –
27.5 K
– / –
60 hours
– / –
– / –
24 weeks
– / –
View Other 33 CoursesRight Arrow Icon

ADVANCE EXCEL TRAINING
 at 
CETPA Infotech Pvt Ltd 
 
Frequently Asked Questions

Q:   Which is the best course at CETPA Infotech Pvt Ltd?

A: 

CETPA is quite popular for offering the best summer course in Delhi. The most popular technologies opted by aspirants for summer training include Python, Django, Machine Learning, Deep Learning, Data Science, Artificial Intelligence, Full Stack, Java.

Best IT Courses in India that Help You Stand Out

  • Machine Learning & Artificial Intelligence (AI-ML)
  • Software Development.
  • Cloud Computing.
  • Cyber Security.
  • Blockchain Technology.
  • Data Science.
  • Web Development.
  • DevOps.

The highest value courses in India include banking, teachers, pilot, digital marketing, software development, etc.

Q:   Is CETPA Infotech Pvt Ltd Tier 1 or Tier 2?

A: 

CETPA Infotech Pvt Ltd is generally classified as a Tier 2 training institute. It offers a range of technical courses across various domains, such as IT, engineering, and management. While it provides quality training and has a strong presence in regions like Noida, Lucknow, Roorkee, and Dehradun, it does not have the same level of national recognition or scale as Tier 1 institutes, which are typically larger, more established, and often affiliated with well-known universities or organizations.

CETPA focuses on practical training and industry-relevant skills, catering to a specific audience seeking to enhance their employability. While it has good placement support and partnerships with companies, it operates on a smaller scale compared to top-tier institutions.

Thumbs Up IconUpvote Thumbs Down Icon

Q:   Is it easy to get admission in CETPA Infotech Pvt Ltd?

A: 

Generally, admission to CETPA Infotech Pvt Ltd is taken as not that complicated. The main aim of the institute is to provide technical training which is accessible. Usually, no strict eligibility criteria are found to make it accessible to almost everyone. Candidates usually just need to fill up an online application and might be interviewed or assessed briefly about the course. The procedure is basically for persons seeking to enhance their skills in different technical fields.

Thumbs Up IconUpvote Thumbs Down Icon
qna

ADVANCE EXCEL TRAINING
 at 
CETPA Infotech Pvt Ltd 

Student Forum

chatAnything you would want to ask experts?
Write here...

ADVANCE EXCEL TRAINING
 at 
CETPA Infotech Pvt Ltd 
Contact Information

Address

D-58, Sector-2,
Near-RED FM, Gautam Buddha Nagar

Noida ( Uttar Pradesh)

Go to College Website ->