![CETPA Infotech Pvt Ltd](https://images.shiksha.com/mediadata/images/1699521557phpwcyN3P_g.jpg)
![CETPA Infotech Pvt Ltd Logo](https://images.shiksha.com/mediadata/images/1699520674phpQ4Hegz.jpeg)
ADVANCE EXCEL TRAINING offered by CETPA Infotech Pvt Ltd
- 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 |
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
ADVANCE EXCEL TRAINING at CETPA Infotech Pvt Ltd Course details
- 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
- 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
ADVANCE EXCEL TRAINING at CETPA Infotech Pvt Ltd Frequently Asked Questions
Q: Which is the best course at CETPA Infotech Pvt Ltd?
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.
![Thumbs Down Icon](https://images.shiksha.ws/pwa/public/images/commonIcons/thumbs-down.webp)
Q: Is CETPA Infotech Pvt Ltd Tier 1 or Tier 2?
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 Down Icon](https://images.shiksha.ws/pwa/public/images/commonIcons/thumbs-down.webp)
Q: Is it easy to get admission in CETPA Infotech Pvt Ltd?
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 Down Icon](https://images.shiksha.ws/pwa/public/images/commonIcons/thumbs-down.webp)
Student Forum
ADVANCE EXCEL TRAINING at CETPA Infotech Pvt Ltd Contact Information
D-58, Sector-2,
Near-RED FM, Gautam Buddha Nagar
Noida ( Uttar Pradesh)
Useful Links
Know more about CETPA Infotech Pvt Ltd
- All About CETPA Infotech Pvt Ltd
- Courses 2025
- Fees 2025
- Reviews on Placements, Faculty & Facilities
- Admission 2025 - Cutoffs, Eligibility & Dates
- Placement - Highest & Average Salary Package
- Infrastructure Details & Reviews
- CETPA Infotech Pvt Ltd Faculty
- Compare CETPA Infotech Pvt Ltd
- CETPA Infotech Pvt Ltd Q&A