Online Training on 'Advanced Excel' 20 April 2021 : 2.00 pm to 5.00 pm

Online Training on 'Advanced Excel' 20 April 2021 : 2.00 pm to 5.00 pm

Context Setting

Excel is intended for anyone who seeks to develop one of the most critical and fundamental digital skills today. Excel remains one of the most omnipresent pieces of software used in workplaces across the world.


Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio


This workshop explores ways to

  • Performing daily use and complex function more efficiently 
  • Learn how to create MIS and Dashboard reports in excel
  • Learn how to automate GST returns

Key Takeaways

Introduction to Excel - 

  • Tips & Tricks that will help efficiency & accuracy
  • Excel Option Settings for enhanced productivity and ease of operations

Using various types of Functions in Excel

  • Numerical Functions (Int, Round, RoundUp, RoundDown)
  • Text Functions (Left, Right, Mid, Concatenate, Trim, Upper, Lower, Proper)
  • Date Functions (Today, Now, Month, Year, Dateif, Weeknum)
  • Summarization using Group Functions (Sum, Count, Sumif, Sumifs, Countif, Countifs)

Using Lookup and Conditional Functions in Excel

  • Conditional Functions (If, And, Or, Nested If)
  • Lookup Functions (Vlookup, Hlookup)
  • Combining Multiple functions for tackling complex conditions

Using Sort and Subtotals to summarizing data

Using Filters & Advanced Filters

Pivot Tables - Effective summarized representation of data using Pivot Tables

  • Creating Table to add dynamism to your data (Auto update) 
  • Creating Pivot Table
  • Use of sections and Layout (Row, Column, Filter and Values)
  • Insert Slicer
  • Add design to make reports attractive
  • Create Pivot charts to make summary visual base


  • Visual representation of data using charts
  • Insert Timeline in data
  • Add design to make reports attractive

Automate MIS reports 

  • Tricks and Tips to automate any reports (Live example of GSTR 1 and GSTR 3B)

Participation Fees

Type of Organisation
Fees per Participant 
CII Members Companies
Rs. 1500/- Per Participant + 18% GST
Non-Member Companies
Rs. 1750/- Per Participant + 18% GST


10% on 3 or more nominations from an organization.


Participation fees is non-refundable/ non-adjustable against any other programme of CII, but change in nomination(s) is accepted.


Registration: Prior registration for participation by the sponsoring companies is necessary. 

Who Should Attend / Target Audience

  • Executives who live with Excel
  • People who consolidate data and create reports
  • People who want to take their Excel usage to the next level