Classroom Training
- Empower your career with classroom training led by industry experts at AJR INSTITUTE.
- Don't wait any longer—kickstart your professional journey by enrolling in our Advanced Excel Training
Instructor-Led Online Training
- Enroll in our instructor-led live online training and receive recorded videos of each session.
- Don't let distance be a barrier to your professional growth. Advanced Excel Training Online!
Syllabus of Advanced Excel Training in Chennai
Module 1: Introduction to Spreadsheet Software
- Font Formatting
- Number Formatting
- Table Formatting
- Conditional Formatting
- Hide / Unhide
- Sort / Filter
- Paste Special
- Find and Select
Module 2: Inserting Data
- Illustrations
- Charts
- Text Boxes
Module 3: Basic Functions
- Sum / Average / Count / Max / Min
- Basic Text / Date / Time / Lookup / Information Functions
- Name Manager
- Formula Auditing
Module 4: Data Management
- Importing from Text
- Importing from the Web
- Text to Columns
- Removing Duplicates
- Grouping and Ungrouping
Module 5: Review Tools
- Proofing
- Comments
- Protection
Module 6: View Options
- Types of Views
- Zoom
- Windows
Module 7: Developer Tools
- Enabling Developer Options
- Using Checkbox / Option Buttons
Module 8: Excel Versions Comparison
- Differences between Excel versions 2003, 2007, 2010, 2013, and 2016
- Understanding Excel's Features and Limitations
Module 9: Basic Formulas
- Addition, Subtraction, Multiplication, Division
- BODMAS / Formula Error Checking
- The SUM Function
Module 10: Referencing Techniques
- Absolute and Relative Cell Referencing
- Creating Absolute and Mixed References
Module 11: LOOKUP Functions
- VLOOKUP Functions
- HLOOKUP Functions
Module 12: PivotTables
- Creating and Formatting Simple PivotTables
- Using Page Field in a PivotTable
- Formatting PivotTables
- Creating and Modifying PivotCharts
Module 13: Logical Functions
- IFs and Nested IF Functions
- Using AND / OR / NOT Functions
Module 14: Statistical Functions
- Using SUMIF / COUNTIF Functions
- Using AVERAGE / COUNT / LARGER / SMALLER Functions
Module 15: Advanced PivotTable Techniques
- Adding New Calculated Fields / Items
- Changing the Summary Function
- Consolidating PivotTables
Module 16: Advanced LOOKUP Functions
- MATCH with VLOOKUP Functions
- INDEX & MATCH Functions
- OFFSET / INDIRECT Functions
Module 17: Advanced Logical Functions
- IF Loop and Nested IF Loop Functions
- Using IF / ISERROR Functions
Module 18: Chart Data Manipulation
- Chart Wizard
- Different Chart Types
- Adding Titles, Legends, Labels
- Printing Charts
- Formatting and Renaming Data Series
- Changing Data Series Order
Module 19: Date and Time Functions
- Using TODAY, NOW, and DATE Functions
- Using DATEDIF, NETWORKDAYS, EOMONTH Functions
- Using WEEKDAY, EDATE, NETWORKDAYS.INTL, WEEKDAY.INTL Functions
Module 20: Text Functions
- MID, SEARCH, LEFT, RIGHT Functions
- TRIM, CLEAN, UPPER, LOWER Functions
- SUBSTITUTE, TEXT Functions
Module 21: Data Validation
- Input Messages, Error Alerts, Drop-Down Lists
- Conditional Formatting
Module 22: Advanced Filters
- Extracting Records with Advanced Filter
- Using Formulas in Criteria
Module 23: Advanced Sorting
- Sorting by Top to Bottom / Left to Right
- Creating and Deleting Custom Lists
- Sorting with Custom Lists
Module 24: Hyperlinking and Data Linking
- Creating Hyperlinks within Sheets / Workbooks
- Linking and Updating Links between Workbooks and Applications
Module 25: Math and Trigonometry Functions
- Using SUMPRODUCT Function
- Using FLOOR, CEILING, MROUND, MOD, QUOTIENT Functions
Module 26: Data Summarization
- Creating Subtotals and Nested Subtotals
- Using SUBTOTALS Formula
- Working with Automatic and Manual Outlines
- Grouping and Ungrouping Data
Module 27: Data Consolidation
- Consolidating Data with Identical / Different Layouts
- Using Auditing Tools
- Displaying and Removing Dependent and Precedent Arrows
- Using Evaluate Formula – Step In / Step Out
Module 28: Custom Views
- Creating, Displaying, and Deleting Custom Views
Module 29: Sharing and Protecting Workbooks
- Sharing Workbooks and Tracking Changes
- Protecting Sheets, Workbooks, and Files
Module 30: Importing and Exporting Data
- Importing Data from Databases, Text Files, and Web
- Exporting Data
- Changing External Data Ranges
Trainer Profile
- AJR Institute's trainers aren't just educators; they are seasoned professionals actively working in leading MNCs. Bringing real-world expertise to the classroom, they guide students through technical and hands-on projects, shaping them into proficient Advanced Excel Developers.
- Our dedicated tutors go beyond theoretical learning, ensuring students gain practical, solid, and technical knowledge. Through engaging sessions, they empower learners with the skills demanded by the industry.
- At AJR Institute, we prioritize individual attention. Our trainers invest time in understanding each student's unique needs, providing personalized support for both academic excellence and career aspirations. Your success is our mission.
- Step into the world of real-time software projects! Our tutors believe in learning by doing. Through hands-on training, students don't just understand Advanced Excel; they experience it in action, preparing them for the challenges of the professional landscape.
- Beyond technical expertise, our trainers equip students with essential interview tips. From refining resume-building skills to navigating job interviews, we prepare our learners for success in the competitive tech job market.
- Ready to shape your future as a Advanced Excel Developer? Connect with us and experience the transformative journey of technical education with hands-on guidance from industry experts.
Quick Enquiry
Please wait while submission in progress...
Features of Advanced Excel Training in Chennai at AJR INSTITUTE
IT Experts as Trainers
At AJR INSTITUTE, receive guidance from industry experts who are passionate about imparting their knowledge to learners.
Realtime Projects
Gain the chance to participate in real-time projects for a profound hands-on experience. Highlight your project expertise to enhance your prospects of securing employment!
Certification
Attain certification from AJR INSTITUTE and prepare to successfully achieve global certifications. AJR INSTITUTE students pursue global certifications, with a 100% success rate.
Budget-Friendly Fees
At AJR INSTITUTE, not only is the course fee budget-friendly, but you also have the flexibility to pay in convenient installments. Our motto is to provide quality training at an affordable price.
Flexible Timing
At AJR INSTITUTE, enjoy unparalleled flexibility. Choose between classroom or online training, opt for early morning or late evenings, decide on weekdays or weekends.
100% Placement Assistance
Our placement training is not a one-size-fits-all approach. We provide personalized career guidance, helping you identify your career goals to find the perfect job fit.