ADVANCE EXCEL TRAINING offered by CETPA Infotech Pvt Ltd
4.0 /5- 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
Student Forum
Anything you would want to ask experts?
ADVANCE EXCEL TRAINING at CETPA Infotech Pvt Ltd Contact Information
D-58, Sector-2,
Near-RED FM, Gautam Buddha Nagar
Noida ( Uttar Pradesh)