Request For a Free Demo Class

  • ACTE Slider Image
  • NO . 1
    IT Training Institute in Porur, Chennai
    Get Trained
    Get Certified
    Get Employed
    ACTE Slider Training
  • Our Aim - Placement for All
    100% Placement Assurance
    2000 + Students Placed in MNCs
    100 + Corporate Trainers
    90 + MNC Tie Up
    ACTE Slider Our Aim
  • Hurry Up !!
    Upgrade Your Technical Skills
    High Quality Training
    High Quality Results
    ACTE Courses

Advanced MS Excel Course with Placement in Porur, Chennai

Courses / Advanced MS Excel Training

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.

Advanced Excel Training in ACTE

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:

    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.

  • 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
Placement
Placement

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
Basic Formula
Formulae that Add/Subtract/Multiply/Divide • BODMAS/Formula Error Checking • The Sum Function
Absolute Referencing
Problems with Absolute/Relative Cell Referencing, Creating Absolute/Mixed References
LOOKUP Functions
The VLOOKUP/HLOOKUP Functions
PivotTables
Creating, Formatting Simple PivotTables • Page Field in a PivotTable • Formatting a PivotTable • Creating/Modifying a PivotChart
Logical Functions
IFs and Nested IF Functions • Using AND/OR/NOT Functions
Statistical 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
Date/Time Functions
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
Validations
Input Messages / Error Alerts/ Drop-Down Lists • Conditional Formatting
Advanced Filters
Extracting Records with Advanced Filter • Using Formulas In Criteria
Advanced Sorting
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
Outlining
Creating/Working with an Automatic/Manual Outline • Grouping / Ungrouping
Consolidation
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

Course Highlights

  • 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.

About Trainer

  • 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

Aneesh
(Verizon Communications)
6+ experience

Certifications

  • Microsoft Excel Certification
  • Our Reviews

     

    ACTE 5 Star Rating: Recommended 4.9 out of 5 based on 2456 ratings.