Advanced Excel Courses in Kollam – Master Data Analysis, Formulas & Reporting

Introduction | Editing Sheet | Formatting | Project 1

Level 1: Excel Basics

Duration: 10 Days

Part 1: Introduction to Microsoft Excel

• Understanding the Excel interface
• Workbook and worksheet basics
• Navigating and selecting cells
• Saving and opening files

Part 2: Data Entry and Formatting

• Entering data into cells
• Basic cell formatting (font, alignment, borders)
• Using fill handles for quick data entry
• Creating simple tables

Part 3: Basic Formulas and Functions

• Introduction to Excel formulas
• Basic mathematical operations (SUM, AVERAGE, COUNT)
• Relative and absolute cell references
• AutoSum and AutoFill

Part 4: Intermediate Formulas and Functions

• Using logical functions (IF, AND, OR)
• Working with text functions (CONCATENATE, LEFT, RIGHT)
• Date and time functions
• Error handling with IFERROR

Part 5: Data Manipulation

• Sorting and filtering data
• Basic chart creation (column, pie, bar)
• Introduction to data validation
• Printing and page setup

part 6: Practical Exercises and Review

• Real-world scenarios and problem-solving
• Review of course topics
• Q&A and open discussion

Duration: 15 Days

Part 1: Advanced Data Filtering

• Advanced filter functions (FILTER, SORT, UNIQUE)
• Working with data tables
• Creating custom views

Part 2: Advanced Formulas for Data Analysis

• Aggregate functions (SUBTOTAL, AGGREGATE)
• Calculated columns and tables

Part 3: Advanced PivotTable Techniques

• Slicers, timelines, and calculated fields
• Building hierarchies in PivotTables
• Advanced PivotTable data analysis

Part 4: Introduction to Dashboard Design

• Understanding the importance of dashboards
• Planning a dashboard project
• Data visualization best practices

Part 5: Advanced Visualization Techniques

• Advanced chart types (waterfall, Gantt, radar)
• Heatmaps and conditional formatting
• Custom visuals and graphics