Advanced MS Excel Training in Porur, Chennai
The Advanced Excel training at Porur, Chennai that is provided by ACTE is proven to be effective. This course is taught at ACTE by experts from various MNC’s with over 15 years of experience. This is one of the sought after course in current technological needs. Microsoft Excel is a spreadsheet program that helps the users in creating a grid of text, numbers and formulas to complete the calculations. It is one of the most commonly used business tools today. All most all employees ranging from a higher level to lower levels use this Microsoft Excel to record the data and to make better decisions by analysing data in it. Having grip over Excel would help you in accomplishing your tasks faster than your colleagues.
It is an application developed by Microsoft® for storing the data in the form of spread sheets, helps to analyse the data using different functions / options in Excel.
Our training for Advanced Excel at Porur, Chennai is conducted in various batches with flexible schedule to suite the need of the candidate. We have training in weekday, weekend and also on the evening.
Become a Microsoft Excel Expert which is taught by experienced working professionals. With our Advanced Excel Coursein Porur, Chennai by ACTE you’ll learn concepts in expert level with practical manner.
The training at ACTE is at most practical ensuring proper understanding of the course from the basics to the most advanced features. The Advanced Excel training at Porur, Chennai is designed specifically to satisfy all the needs and requirements of the current day technical organizations. We also provide free demo for the candidates to get a clarity. Contact us today for one.
Benefits of Advanced Excel training at Porur:
- Trainers are experts fron MNC’s
- We provide practical training.
- Course materials are prepared by experts.
- We conduct mock tests before the interview.
- Certified courses.
Advanced Excel training and placement at Porur, Chennai highlights:
- Get Trained from Advanced Excel Certified Partner
- 16+ Modules with In-depth Concepts
- Flexible Online & Offline Classes
- 100+ Students got Placed in IT Companies
- Completed 250+ Batches and Counting
- Up-to-date Advanced Course Curriculum
ACTE will be an interactive learning destination for anyone who wants to enroll in Advanced Excel training. Here are some reasons why you need to master your Advanced Excel skills with us.
Contact ACTE to know more about the advanced MS Excel training in Porur, Chennai.
Advanced Excel Training Course syllabus
Excel 2007 & 2010 Quick Overview
Difference between Excel 2003, 2007 and 2010, Use of Excel, its boundaries & features
Formulae that Add/Subtract/Multiply/Divide • BODMAS/Formula Error Checking • The Sum Function
Problems with Absolute/Relative Cell Referencing, Creating Absolute/Mixed References
The VLOOKUP/HLOOKUP Functions
Creating, Formatting Simple PivotTables • Page Field in a PivotTable • Formatting a PivotTable • Creating/Modifying a PivotChart
IFs and Nested IF Functions • Using AND/OR/NOT Functions
Using The SUMIF/COUNTIF Functions • Using The AVERAGE/COUNT/LARGER/SMALLER Functions
Pivot Tables – Advance
Adding new calculated Fields / Items • Changing the Summary Function • Consolidate Pivot table
LOOKUP Functions – Advance MATCH with VLOOKUP Functions • / & MATCH Functions • OFFSET/ INDIRECT functions
Logical Functions - Advance
If Loop and Nested IF Loop Functions • Using IF/ISERROR Functions
Chart Data Techniques
The Chart Wizard • Chart Types • Adding Title/Legends/Lables • Printing Charts • Adding Data to a Chart • Formatting/Renaming/Deleting Data Series • Changing the Order of Data Series
Using The Today • Now & Date Functions • Using The Datedif/ Networkdays/ Eomonth Functions • Using The Weeknum Functions • Using The Edate/ Networkdays.Intl/ Weekdays.Intl Functions.
Text Functions Using The Mid/ Search/ Left/ Right Functions • Using The Trim/ Clean/ Upper/ Lower Functions • Using The Subsitute/ Text Functions • Using The Trim/ Clean/ Proper/ Dollar Function
Input Messages / Error Alerts/ Drop-Down Lists • Conditional Formatting
Extracting Records with Advanced Filter • Using Formulas In Criteria
Sorting by Top to Bottom / Left to Right • Creating / Deleting Custom List • Sort by using Custom List
Hyper / Data Linking
Hyper linking data, within sheet / workbook • Linking & Updating links between workbooks & application
Math & Trigonometry Functions
Using SUMPRODUCT Functions • Using FLOOR/ CEILING/ MROUND/ MOD/ QUOTIENT Functions
Summarizing Data Creating Subtotals/Nested Subtotals • SUBTOTALS Formula
Creating/Working with an Automatic/Manual Outline • Grouping / Ungrouping
Consolidating Data with Identical/Different Layout
Using Auditing Tools
Displaying/Removing Dependent & Precedent Arrows • Evaluate Formula - Step IN/ Step Out
Custom Views Creating Custom Views • Displaying Custom Views • Deleting Custom Views
Sharing and Protecting Workbooks Sharing Workbooks & Tracking Changes • Protecting sheets / workbooks / Files
Importing & Exporting Data Importing Data from Database/ Text Files/ Web • Exporting Data • Changing External Data Range
- Free demo classes.
- Limited Batch Size.
- Excellent lab facility.
- Innovative ideas are taught by the professionals.
- 100% placement Assurance.
- Expert trainers will teach the students.
- Certificates are provided to the students.
- 6+ experienced in Advanced Excel
- Certified trainer
- Working in top MNC company
- Friendly and interactive
- Trained more than 3000 students
- Ready to help students - 24/7
- Strong knowledge and perfect delivery
- On the spot doubt clarifying person
- Microsoft Excel Certification