Lala Lajpatrai Institute of Management

Layer 7

Lorem ipsum dolor sit amet, consectetur adipiscing elit.            Donec nec enim eu purus rutrum placerat viverra eu elit.            Etiam eu scelerisque enim.

Lorem ipsum dolor sit amet, consectetur adipiscing elit.            Donec nec enim eu purus rutrum placerat viverra eu elit.            Etiam eu scelerisque enim.

Advanced Excel

Microsoft Advanced Excel – Workshop

MS Excel is an indispensable tool for analysts, planners, controllers, financial experts and other users. But even though it is so widely used, the users lack skills of building effective and practical solutions for reporting and visual analysis. Considering these points,

Mr. Pranav Shah conducted MS Advance Excel Workshop for all the MMS – II students in our college. Students found this workshop very useful as it helped them to secure their final placement. The following are the contents covered in the Advanced Excel workshop;

BASIC Microsoft Excel
Functions : LOOKUP, VLOOKUP, HLOOKUP, COUNTIF, SUMIF, PIVOT TABLES, MACRO’S ( Int )
Develop the Worksheet
Special Operations

Advanced Excel
Batch Course Vendor Resource Person Dates
2017-19 Advanced Excel Knowledge Mould Pranav Shah 7th,8th and 14th, 15th July 2018
2018-20 Advanced Excel Knowledge Mould Pranav Shah 26th Sept to 29th Sept 2019
2020-22 Advanced Excel Knowledge Mould Pranav Shah 21st March 2021 to 4th April 2021
2021-23 Advanced Excel Knowledge Mould Pranav Shah 30th Jan, 6th feb, 13th feb and 19th feb 2022
2022-24 Advanced Excel Knowledge Mould Pranav Shah 18th December 2022, 25th Dece 2022, 8th Jan,15th jan, 22nd jan 2023