Request For a Free Demo Class

  • ACTE Slider Image
  • NO . 1
    IT Training Institute in 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 Chennai

Courses / Advanced MS Excel Training

Advanced MS Excel Training in Chennai

MS excel knowledge is of great advantage to any working executive, manager or even CEO. Some of the key features are formatting tables & inserting table functions, auto formats of reports, linking of one worksheet to another worksheet, customized formatting of cells. ACTE Provides the Best Advanced Excel Training at Anna nagar, Chennai. This course will give you a deep understanding of the advanced formulas and functions that distinguish Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. We provide practical based training to ensure at most benefit to the candidates.

Advanced Excel Training in ACTE

This Advanced Excel Course will provide the candidates with the power to do the following:

  • Design their own formula-based formatting rules
  • Ability to create MIS reports.
  • Creating MIS reports.
  • Gather real-time data from APIs directly into Excel
  • Ability to analyse large volumes of data.
  • Ability to Manipulate dates, times, text, and arrays

Audience for Advance MS-Excel Course at Anna nagar, Chennai:

Graduates trying to expand their job placement scope and also executives and managers who have already been using Microsoft Excel, but now have the need for learning more powerful features and options of Excel, to manage their worksheet-related tasks more efficiently.

Prerequisites Advance MS-Excel Training Institution at Anna nagar, Chennai:

Since, this is an advanced excel course candidates attending this training should be familiar with the basic operations in Microsoft Excel, such as simple calculations, formatting and printing.

Placement
Placement

Contact ACTE to know more about the advanced MS Excel training in 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.