- About Us
- Career Courses
- Modular Courses
- Soft Skills
- Photo & Video Gallery
- Quick Links
- Contact Us
Join the Best Advance Excel Institute in Delhi (Uttam Nagar, Dwarka Mor, janakpuri)
Advance MS Excel
ObjectiveGraduates of these programs should have the knowledge and skills to use a variety of computer programs in a business setting. Those trained in computer applications may secure entry-level positions in organizations where people rely on computers to complete their work. Some positions may include office clerk, secretary or administrative assistant.
Course Duration1 Month
Graduates of these programs should have the knowledge and skills to use a variety of computer programs in a business setting. Those trained in computer applications may secure entry-level positions in organizations where people rely on computers to complete their work. Some positions may include office clerk, secretary or administrative assistant.
- Keyboard Shortcuts and Commands.
- Working with Ribbon Tabs.
- Advance techniques of Copy and Paste.
- Basics about Date 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….)
- Cell Format.
- Data Bars, Color Scales & Icon Sets.
- Conditional formatting with formulas.
- Conditional formatting with Form Controls.
- Sorting basic.
- Sorting based on Customized List.
- Customized Sorting (Advanced).
(What are commonly committed errors and how to overcome them, different type of conditional formatting, creating customized list
- Data Validation and dealing with Invalid Data.
- Group and Outline Data.
- Data Filter.
- Data Consolidation.
- Data text to column.
- Custom Views.
(Consolidating data vertically and horizontally on few clicks (without using any formula), Viewing & printing multiple reports on same data and same sheet on click of button and much more……….).
- Lookup Formula’s(Vlookup,Hlookup,Index,
Transpose ,Rows,Column etc).
- Logical Formula’s(If,And,Or,etc).
- Date & Time(Day, Month, Year, Date, Date value, EOMonth, Workday etc).
- Math & Trig(Sumif, Sumifs, Sumproduct etc).
(Do you really know what Vlookup can do?)
- Vlookup can extract value from multiple tables on multiple sheets.
- Using Vlookup for two way lookup. (Vertically and Horizontally at same time).
- Database Function( Dsum,Dmax,DCount,etc)
- Financial Function(PMT, PV etc)
- Chart Basics.
- Line Charts, Column Chart.
(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 feature of spark lines).
- Pivot Table (Including Slicer).
- Scenario Modeling.
- Goal Seek.
- Advanced Filters.
(See how to add customized data in Pivot-Table, how to generate multiple reports on a press of button in Pivot Table, How to use newly added feature of slicer in pivot table, Creating customized reports from Advanced Filter on few clicks, what are advantages and disadvantages of using scenario modeling).
Learn Advance Excel From Best Excel Institute In Delhi.
Advance excel is a very powerful tool from Microsoft which is used for complex calculations , data analytics,accounting, and many more. With the help of advance formulas Excel has contributed in a great deal in smooth functioning of small to medium level organizations. even large corporates are using it as a tool to effectively run their MIS departments. Thus lowering the need to spend on ERP softwares which cost very highly. In today’s IT enabled era nearly 90% of the companies are using Excel as a platform for smooth running of their organization.
We can supply you with an international Microsoft Excel Certification from Microsoft itself, which will help you advance your career and put you ahead of the competition. That is why we have established ourselves as the top advanced Excel training Institute in Delhi.
If you work for a company that wishes to decrease the time it takes to prepare long and laborious reports, you might consider taking advanced Excel training. We provide expert Excel training in Delhi, making us the top advanced Excel institute in Delhi.
infotech softnet computer education is the best advanced excel institute in Uttam nagar, Janakpuri, and Dwarka Mor as most of offline students come from vicinity..
Institute Strength:• The institute has a proper set of structured modules that the students have to adhere to.
• The staff is well qualified and have the experience of serving students for at least a decade.
• The infrastructure is top class.
• Institute is recognized by NIELIT Govt. of India for IT Diploma courses.Python is taught as core technology in the curriculm.
• Infotech softnet computer education is the best training institute for python in Uttam Nagar, Janakpuri,Dwarka area. We are one of the best in delhi..