Advanced MS Excel Training in Chennai
The Advanced Excel Course is designed for executives who are already familiar with the basics of Microsoft Excel, and who would like to work with more advanced features of Microsoft Excel that help in improving their efficiency of working with worksheets, analyzing data, creating MIS reports, and automating various tasks. ACTE Provides the Training for Advanced Excel Training in Chennai. Functioning skilled person connected to accounts, MBAs desire to learn Advanced Microsoft Excel, Access, VBA, Macro, Reporting and advanced commands to get familiar with Excel and also to develop desired reports from the data. We provide also online training on MS-Excel Training.
This Advanced Excel Course will empower the participants to be able to do the following:
- Performing complex calculations more efficiently, using various Excel functions.
- Organizing and analyzing large volumes of data.
- Creating MIS reports.
- Designing and using templates.
- Consolidating and managing data from multiple workbooks.
Audience for Advance MS-Excel Course in Chennai
Executives and managers who have already been using Microsoft Excel, but now feel 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 in Chennai
Participants attending this training should be familiar with the basic operations in Microsoft Excel, such as simple calculations, formatting and printing.
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
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