Advanced Excel Training Programme

REPORT ON ADVANCED EXCEL TRAINING PROGRAMME

  Programme Details Name of the Programme: Advanced Excel Training Programme Duration: 3 Days Dates: 1st, 2nd & 3rd October 2026 Participants: II BCA Students Venue: Computer Lab, Sahyadri Institute of Commerce First Grade College, Chikkamagaluru Resource Person: Mr. Chandan L Assistant Professor, Department of MBA, RNS Institute of Technology, Bengaluru   Sahyadri Institute of Commerce First Grade College, Chikkamagaluru, organised a three-day Advanced Excel Training Programme for the II BCA students from 1st to 3rd October 2026. The programme was designed to provide students with practical and hands-on knowledge of Microsoft Excel and its advanced features, enabling them to effectively work with data, perform calculations, analyse information and present insights in a structured manner. The training was conducted by Mr. Chandan L, Assistant Professor, Department of MBA, RNS Institute of Technology, Bengaluru. The programme followed a practical, hands-on approach, allowing students to learn various Excel functions and immediately apply them to real-world datasets and exercises. Objectives of the Programme The major objectives of the Advanced Excel Training Programme were to:
  • Introduce students to advanced features and functionalities of Microsoft Excel.
  • Develop students’ ability to work efficiently with large datasets.
  • Strengthen their understanding of Excel formulas and functions.
  • Develop skills in data lookup and retrieval using VLOOKUP and HLOOKUP.
  • Introduce students to conditional and logical functions for data analysis.
  • Enable students to organise, filter and analyse data effectively.
  • Develop skills in creating charts and presenting data visually.
  • Introduce students to Pivot Tables for summarising and analysing large datasets.
  • Provide hands-on experience through practical exercises and activities.
  • Enhance students’ employability by developing an industry-relevant technical skill.
Day 1 – Excel Functions, Formulas and Data Lookup Date: 1st October 2026 The first day of the programme focused on strengthening the students’ understanding of Excel fundamentals and introducing them to advanced formulas and functions. The session began with an overview of Excel formulas, functions and data handling techniques. Students were introduced to commonly used functions and were guided through practical examples to understand how formulas can be used to automate calculations and analyse data. A major component of the session was VLOOKUP and HLOOKUP. Students learned how these functions can be used to search for specific information within datasets and retrieve corresponding values from tables. The resource person demonstrated the functions using practical examples, followed by hands-on exercises where students created formulas and worked with sample datasets. Students were also introduced to functions such as IF, SUMIF, COUNTIF and related conditional functions, enabling them to perform calculations based on specific conditions. Key Topics Covered – Day 1
  • Excel formulas and functions
  • Relative and absolute cell references
  • VLOOKUP
  • HLOOKUP
  • IF function
  • SUMIF and COUNTIF
  • Conditional calculations
  • Working with structured datasets
  • Data searching and retrieval
  • Practical exercises and hands-on activities
Key Takeaways – Day 1 Students gained an understanding of how Excel functions can be used to simplify repetitive calculations and retrieve information efficiently. The hands-on exercises helped students understand the practical application of VLOOKUP, HLOOKUP and conditional functions. Day 2 – Data Management, Analysis and Visualisation Date: 2nd October 2026 The second day focused on data management, analysis and visualisation using Excel. Students learned various techniques for organising and managing datasets. Practical demonstrations were provided on sorting and filtering data, identifying relevant information and working efficiently with large datasets. The session also covered additional Excel functions and features that can be used for data analysis. Students were introduced to conditional formatting, which enables users to visually identify trends, patterns, high and low values and other important information within a dataset. The participants were also introduced to data validation and techniques for maintaining consistency and accuracy while entering data. The session included exercises involving text and date-related functions, along with practical activities designed to strengthen the students’ understanding of data manipulation and analysis. Students were also guided on creating charts and graphs to present data in a more meaningful and visually understandable format. Key Topics Covered – Day 2
  • Sorting and filtering data
  • Conditional Formatting
  • Data Validation
  • Text functions
  • Date and time functions
  • Logical and conditional functions
  • Data cleaning and organisation
  • Working with large datasets
    • Creating charts and graphs
    • Data visualisation
    • Practical data analysis exercises
    Key Takeaways – Day 2 Students learned how to organise, analyse and interpret datasets using Excel. The practical exercises helped them understand how Excel can be used not only for calculations but also for identifying patterns and presenting information visually. Day 3 – Advanced Data Analysis and Pivot Tables Date: 3rd October 2026 The third day focused on one of the most powerful features of Excel for data analysis — Pivot Tables. The session began with an introduction to the purpose and importance of Pivot Tables in analysing large volumes of data. Students were guided through the process of creating Pivot Tables from datasets and organising information using different fields. The resource person demonstrated how students could use Rows, Columns, Values and Filters within Pivot Tables to generate meaningful summaries from large datasets. Students also learned how to group and summarise information, compare different categories and extract useful insights from data. The session further introduced students to Pivot Charts, enabling them to represent Pivot Table results visually. The final session included hands-on exercises where students worked with datasets and created their own Pivot Tables and visualisations. This helped them consolidate the concepts covered throughout the three-day programme. Key Topics Covered – Day 3
    • Introduction to Pivot Tables
    • Creating Pivot Tables
    • Rows, Columns, Values and Filters
    • Summarising large datasets
    • Grouping and analysing data
    • Filtering and sorting Pivot Table data
    • Calculated summaries
    • Pivot Charts
    • Data interpretation and insights
    • Practical hands-on exercises
    Key Takeaways – Day 3 Students gained practical experience in using Pivot Tables to summarise and analyse large datasets. They also learned how to convert raw data into meaningful information and present their findings using Pivot Charts. Overall Learning Outcomes At the completion of the three-day Advanced Excel Training Programme, students were able to:
    • Work confidently with Excel formulas and functions.
    • Apply VLOOKUP and HLOOKUP for data retrieval.
    • Use logical and conditional functions for data analysis.
    • Sort, filter and organise large datasets.
    • Apply conditional formatting to identify patterns and trends.
    • Use data validation for accurate data entry.
      • Create meaningful charts and graphs.
      • Analyse large datasets using Pivot Tables.
      • Create Pivot Charts for effective data visualisation.
      • Interpret data and generate useful insights.
      • Apply Excel skills to academic, business and workplace-related problems.Work with text and date-related functions.
      Valedictory and Concluding Session The three-day training programme concluded with a session where the students reflected on the knowledge and practical skills gained during the workshop. The resource person, Mr. Chandan L, encouraged the students to continue practising the Excel features covered during the training and to explore additional functionalities that could support their academic and professional work. The programme provided students with an opportunity to move beyond basic spreadsheet operations and understand how Excel can be used as a powerful tool for data management, analysis, reporting and decision-making. The hands-on nature of the training ensured that students were actively involved throughout the programme. The practical exercises and datasets helped students understand the real-world applications of the concepts discussed.    
    •