Menu
Best Institute Advance Excel in Uttam Nagar
Advantages in Advance Excel
- Excel helps you get PVT. MNC Jobs.
- It will be increase your salary with excel job work.
- Excel software in data storage best way.
- Best Calculation data in excel.
- Easy way of Print Reports.
- Excel tools for Data analysis.
- Easy way vision Data with Charts.
- working with cells and ranges in Excel.
Formulas Functions:- - Text Formula’s (Left, Right, Trim, Len, Upper, Lower, Proper, etc.)
- Date & Time (Day, Month, Year, Date, Datevalue, workday etc.)
Excel Basics
- Keyboard Shortcuts and Commands.
- Advance techniques of copy and paste.
- Basics about Data and Time.
- How to use Auto List.
- Wild Characters.
(how to make powerful use of Wild Characters, Find Replace and Go To. How date and time works in excel, how to create different QAT for different files and much more..)
FORMATS, CONDITIONAL FORMATING & SORTING - Cell Format.
- Data Bars. Color Scales 7 Icon Sets.
- Conditional Formatting with formulas.
- Conditional Formatting with Form Controls.
- Customized Sorting (Advanced).
Charts & Graphs
- Chart Basics.
- Line Chart, Column Chart.
- Sparklines.
- Others
- (How to create multiple chart type in one graph, using primary and secondary axis for different chart type in one chart, how to make best use of newly added features of sparklines.
Data Management - Data Validation and dealing with Invalid Data.
- Group and Outline data.
- Data filter.
- Data text to column.
- Custom Views.
Data Analysis
- Introducing in Pivot table.
- Pivot table (Including Slicer).
- Pivot Table Reports.
- Pivot table create a dynamic report.
- Advanced Filters.
- Lookup Formula’s (If, and, or etc.)
- Vlookup can extract value from multiple tables on multiple sheets.
- Hlookup Formula.
- Using Vlookup for two way lookup. (Vertically and Horizontally at same time.)
Our Mission
Our Training Institute knows that every Government exam & computer Language requires a different approach. We are Info typing, shorthand & Computer since 2008.