CERTIFICATE IN ADVANCED EXCEL ( S-1-EXCEL-01 )

1: Introduction to Advanced Excel

• Overview of Excel Interface
• Workbook and Worksheet Basics
• Navigating Worksheets
• Data Entry and Editing
• Saving and Sharing Workbooks

 2:  Formulas and Functions

• Understanding Formulas
• Basic Arithmetic Operations (Sum, Subtract, Multiply, Divide)
• Using Basic Functions (SUM, AVERAGE, MIN, MAX)
• Relative and Absolute Cell References
• AutoFill and Flash Fill

3: Formatting and Customization

• Cell Formatting (Number, Text, Date)
• Conditional Formatting
• Customizing Rows and Columns (Insert, Delete, Resize)
• Using Themes and Styles
• Creating and Modifying Tables

 4: Data Management and Analysis

• Sorting and Filtering Data
• Using Excel Tables
• Data Validation and Drop-Down Lists
• Removing Duplicates
• Grouping and Subtotaling Data

5: Advanced Formulas and Functions

• Logical Functions (IF, AND, OR)
• Lookup Functions (VLOOKUP, HLOOKUP, INDEX, MATCH)
• Text Functions (CONCATENATE, LEFT, RIGHT, MID)
• Date and Time Functions
• Array Formulas

 6: Charts and Visualization

• Creating and Formatting Charts (Column, Line, Pie, Bar)
• Using Sparklines
• Creating Pivot Tables and Pivot Charts
• Conditional Formatting with Charts
• Using Data Analysis Tools (Goal Seek, Solver)

 7: Working with Multiple Worksheets and Workbooks

• Managing Multiple Worksheets
• Linking Data Between Worksheets
• Consolidating Data from Multiple Workbooks
• Using 3D Formulas
• Protecting Worksheets and Workbooks

8: Macros and Automation

• Introduction to Macros
• Recording and Running Macros
• Editing Macro Code
• Assigning Macros to Buttons
• Introduction to VBA (Visual Basic for Applications)

 9: Advanced Data Analysis

• Using Power Query for Data Import and Transformation
• Introduction to Power Pivot
• Creating Relationships between Tables
• Using DAX (Data Analysis Expressions)
• Advanced Pivot Table Techniques

 10: Collaboration and Data Sharing

• Sharing Workbooks and Collaboration Tools
• Tracking Changes and Comments
• Using Excel Online and OneDrive
• Data Import and Export (CSV, XML)
• Integrating Excel with Other Office Applications (Word, PowerPoint)