🧮 Microsoft Excel Training – Basic to Advanced

Offered by Palium Skills, Kolkata

Excel skills are essential for students, professionals, and businesses. Palium Skills offers structured Basic and Advanced Excel Training programs — available in both Classroom (Kolkata) and Live Online modes — to help participants master Excel for real-world applications.

📘 Basic Excel Training

Duration: 12 Hours
Mode: Classroom / Live Online
Level: Beginner

Course Overview

This course introduces participants to Microsoft Excel’s interface, tools, and functions. It focuses on building confidence in managing data, formatting, calculations, and charts.

Course Modules

1. Getting Started with Excel

   • Excel interface, workbooks, and worksheets

   • Data entry, navigation, and editing

2. Formatting and Layout

   • Formatting cells, rows, and columns

   • Using number formats, borders, and alignment

3. Basic Formulas & Functions

   • SUM, AVERAGE, COUNT, MIN, MAX

   • Introduction to relative & absolute references

4. Data Management

   • Sorting, filtering, and removing duplicates

   • Freezing panes, hiding/unhiding sheets

5. Charts & Conditional Formatting

   • Creating column, bar, pie, and line charts

   • Applying conditional formatting rules

6. Printing & Page Setup

   • Page layout, print areas, and headers/footers

Key Highlights

✅ Hands-on exercises
✅ Step-by-step guided practice
✅ Certificate of Completion

Learning Outcome

Participants will be able to prepare reports, use formulas efficiently, and present data clearly in charts and tables.

---

📗 Advanced Excel Training

Duration: 16 Hours
Mode: Classroom / Live Online
Level: Intermediate to Advanced

Course Overview

This course takes Excel skills to the next level — teaching participants how to analyze data, use complex functions, and create interactive dashboards.

Course Modules

1. Basic Excel Brushup

• Cell Referencing

• Hyperlink 

1. Data Tools & Validation

   • Conditional Formatting 

     Data validation, text-to-columns, flash fill

   • Consolidation and subtotals

2. Advanced Functions & Formulas

   • Text, Date, and Array functions

   • Lookup (VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH)

   • Logical (IF, AND, OR, IFERROR)

3. PivotTables & PivotCharts

   • Building and customizing PivotTables

   • Using slicers, timelines, and calculated fields

4. Data Analysis Techniques

   • Scenario Manager, Goal Seek, Data Tables

5. Advanced Visualization

   • Conditional formatting with formulas

   • Sparklines and advanced charting

6. Automation with Macros (VBA Intro)

   • Recording and running macros

   • Introduction to VBA concepts

7. Data Protection & Collaboration

   • Worksheet and workbook protection

   • Linking and sharing workbooks

Key Highlights

✅ Real-life case studies & exercises
✅ Excel Dashboard creation
✅ Course completion certificate

Learning Outcome

Participants will be able to handle large datasets, automate repetitive tasks, and design professional dashboards for business reporting.

🎓 Why Learn with Palium Skills?

• Experienced corporate trainers

• Small batch sizes for personalized attention

• Both offline (Kolkata) and live online options available

• Placement and project support

📞 Contact Palium Skills
Phone: +91 84205 94969 / +91 70448 71915
Email: info@paliumskills.com
Website: www.paliumskills.com

Start mastering Excel today — the skill that every professional needs!