The Guest Speaker of the session was Ms. Ritu Arora - Certified Corporate Trainer (Microsoft Excel |Power BI)

Ms. Ritu Arorahas been working as a Corporate Trainer since July 2007 and Imparted more than 500 Batches and Trained more than 10000 people.

Director – Dr. V.N. Bajpai welcomed the guest and enlightened the whole audience.

Ms. Ritu startedthe presentation with the most basic terminology of Excel, where she tried to make the session more interactive by asking relevant questions and practical exposures.

The session started with the rows and column shortcuts and even included the concepts of advanced Excel which includethe shortcuts- Ctrl+(), Shift+ f11, Ctrl+Page down and Page Up, Ctrl+: Left Alt+=, Average, Minimum, Maximum, Drag and Drop option, grouping and ungrouping data, slicer, pivot table and it’s use, VLOOKUP and HLOOKUP, and freezing data. Practice worksheets were also being given and YouTube channels were also referenced for learning.

There are certainly more advanced functions of Excelwhich were quoted and lastly, a brief introduction was given over advanced Excel certification and its importance, business trends, and usage of Excel in the corporate world.

Lastly, the eminent guest was being honored with the plague and Words of Gratitude. The workshop was a total sum of learning, knowledge, and exploration regarding advanced Excel.