Advanced Excel Training in Anna Nagar – G-TEC

Become a proficient user of Excel by enrolling in the Excel Classes in Chennai offered by G-TEC Anna Nagar Chennai,
rated as the No. 1 Excel Training Institute in Chennai. Our Advanced Excel training equips you with essential skills to efficiently analyze data, create dynamic spreadsheets, and use Excel’s advanced features.

1. Introduction to Microsoft Excel

• 
  About Microsoft Excel
• 
  Various versions of Microsoft Excel/li>
• 
  Excel Fundamentals
• 
  Understanding the Excel Worksheet
• 
  Key terms used in Excel
• 
  Creating an Excel File
• 
  Entering Data and creating a Table
• 
  Navigation in Excel

2. Formatting Cells

• 
  Changing Fonts and Font Size
• 
  Changing Text Color
• 
  Applying Font Styles
• 
  Rotating Texts
• 
  Applying Borders
• 
  Filling Series

3. Formulas in Excel

• 
  Creating Simple formulas – Add, Subtract, Multiply, and Divide
• 
  Absolute Cell Reference and Relative Cell Reference
• 
  Impact of Absolute and Relative Cell References in Formulas

4. Working with Rows and Columns

• 
  Inserting, Deleting, Hiding, Unhiding Rows and Columns
• 
  Formatting Rows and Columns
• 
  Freezing Rows and Columns
• 
  Splitting Windows
• 
  Copy, Paste and Paste Special
• 
  Understanding Transpose
• 
  Define Names and Labels

5. Working with Basic Functions

• 
  Mathematical Functions (SUM, ROUND, SUBTOTAL)
• 
  Basic Statistical Functions (COUNT, COUNTA, AVERAGE, MAX, MIN, MEDIAN, MODE)
• 
  Logical Functions (IF, Nesting IF, AND, OR, NOT, SUMIF, COUNTIF)
• 
  Text Functions (MID, SEARCH, LEFT, RIGHT, TRIM, CLEAN, UPPER, LOWER, PROPER)
• 
  Date and Time Functions (TODAY, NOW, DATE, DATEDIF, NETWORKDAYS, EOMONTH)

6. Sorting and Filtering Data

• 
  Sorting by Single and Multiple Columns
• 
  Sorting for Specific Words and Dates
• 
  Applying Filters
• 
  Using Filters and Clearing Filters

7. Grouping Data

• 
  Understanding and working with Subtotals
• 
  Grouping Rows and Columns
• 
  Auto Outline and Ungrouping data

8. Data Visualization

• 
  Basics of Charts (Column, Bar, Pie, Line Charts)
• 
  Adding Titles, Labels, and Legends
• 
  Working with Data Series
• 
  Formatting Data Series

9. Data Validations

• 
  Creating Data Validation Rules
• 
  Providing Input Messages
• 
  Creating Error Alerts
• 
  Using Operators to Control Input Data
• 
  Creating and managing Dropdown Lists
• 
  Applying Conditional Formatting

10. Advanced Excel

• 
  Working with Advanced Formulas
• 
  Using Named Ranges in Formulas
• 
  Formulas Spanning Multiple Worksheets
• 
  Advanced Functions (IF, AND/OR, SUMIF, AVERAGEIF, COUNTIF, PMT)
• 
  Lookup Functions (LOOKUP, VLOOKUP, HLOOKUP)
• 
  Understanding and Creating Scenarios
• 
  Using the Watch Window
• 
  Consolidating Data
• 
  Iterative Calculations
• 
  What-IF Analysis and Scenario Manager
• 
  Financial Functions
• 
  Quick Analysis Tool

11. Working with Lists

• 
  Converting a List to Table
• 
  Removing Duplicates
• 
  Sorting and Filtering Data in Lists
• 
  Adding Subtotals
• 
  Grouping and Ungrouping Data

12. Working with Illustrations

• 
  Using Clip Art, Shapes, SmartArt

13. Data Visualization – Advanced

• 
  Creating Custom Chart Templates
• 
  Advanced Chart Formats (Treemaps, Sunburst, Histogram, Waterfall, Box, and Whisker, Pareto)
• 
  Sparklines

14. Working with Tables

• 
  Formatting Data as a Table
• 
  Modifying Tables

15. Advanced Formatting

• 
  Conditional Formatting
• 
  Creating and Modifying Templates

16. Working with Pivot Tables

• 
  Creating and Formatting Pivot Tables
• 
  Inserting Slicers and Pivot Charts
• 
  Advanced PivotTable Functionality
• 
  External Data Source

17. Auditing Worksheets

• 
  Tracing Precedents and Dependents
• 
  Showing Formulas
• 
  Tracking Changes
• 
  Protecting Worksheets and Workbooks

Why Choose G-TEC for Tally Training?

At G-TEC Anna Nagar Chennai, we provide the best Excel training in Anna Nagar, ensuring comprehensive knowledge and hands-on experience. Our features include:

Expert Instruction: Learn from seasoned professionals with real-world experience.
Hands-On Learning: Engage in practical exercises and projects that enhance your Excel skills.
Personalized Attention: Small class sizes ensure individual support.
Career Support: Placement assistance to secure job opportunities in top MNCs

Join G-TEC Anna Nagar Chennai and start your journey towards mastering Microsoft Advanced Excel. Our structured curriculum, expert trainers, and practical approach make us the best choice for learning Excel in Anna Nagar. Enroll today and take the first step towards becoming an Excel expert.